第8次1接口文档Base URL: http://localhost:8080商品 /api/goods| 方法 | 路径 | 说明 || GET | /api/goods | 查询全部 || GET | /api/goods/{id} | 按ID查询 || POST | /api/goods | 新增 || PUT | /api/goods | 修改 || DELETE | /api/goods/{id} | 删除 |POST/PUT 请求体:json { name:商品名, category:分类, price:2.00, stock:100, description:描述 }PUT 需额外传 id。购物车 /api/cart| 方法 | 路径 | 说明 || GET | /api/cart | 获取列表 || POST | /api/cart | 添加 { goodsId:1, quantity:1 } || PUT | /api/cart/{id} | 更新数量 { quantity:3 } || DELETE | /api/cart/{id} | 删除单项 || DELETE | /api/cart | 清空 |响应格式json { code: 1, msg: success, data: null }code: 1成功, 0失败2数据库CREATEDATABASEIFNOTEXISTSdaily_goodsDEFAULTCHARACTERSETutf8mb4DEFAULTCOLLATEutf8mb4_unicode_ci;USEdaily_goods;DROPTABLEIFEXISTScart;DROPTABLEIFEXISTSgoods;CREATETABLEgoods(idINTAUTO_INCREMENTPRIMARYKEYCOMMENT商品ID,nameVARCHAR(100)NOTNULLCOMMENT商品名称,categoryVARCHAR(50)DEFAULTNULLCOMMENT商品分类,priceDECIMAL(10,2)DEFAULT0.00COMMENT商品价格,stockINTDEFAULT0COMMENT库存数量,descriptionVARCHAR(500)DEFAULTNULLCOMMENT商品描述,create_timeDATETIMEDEFAULTCURRENT_TIMESTAMPCOMMENT创建时间,update_timeDATETIMEDEFAULTCURRENT_TIMESTAMPONUPDATECURRENT_TIMESTAMPCOMMENT更新时间)ENGINEInnoDBDEFAULTCHARSETutf8mb4COMMENT商品表;CREATETABLEcart(idINTAUTO_INCREMENTPRIMARYKEYCOMMENT购物车ID,goods_idINTNOTNULLCOMMENT商品ID,quantityINTDEFAULT1COMMENT数量,create_timeDATETIMEDEFAULTCURRENT_TIMESTAMPCOMMENT创建时间,update_timeDATETIMEDEFAULTCURRENT_TIMESTAMPONUPDATECURRENT_TIMESTAMPCOMMENT更新时间,UNIQUEKEYuk_goods(goods_id))ENGINEInnoDBDEFAULTCHARSETutf8mb4COMMENT购物车表;INSERTINTOgoods(name,category,price,stock,description)VALUES(农夫山泉矿泉水,饮料,2.00,200,550ml 天然矿泉水),(康师傅方便面,食品,4.50,150,红烧牛肉面 袋装),(清风抽纸,日用品,12.00,80,原木纯品 3层130抽*3包),(蓝月亮洗衣液,清洁,29.90,60,深层洁净 1kg装),(蒙牛纯牛奶,饮料,3.00,120,250ml 利乐砖),(舒肤佳香皂,个人护理,4.50,200,纯白清香型 115g),(海天酱油,调味品,8.80,90,金标生抽 500ml),(金龙鱼食用油,食品,59.90,40,花生油 1.8L),(得力文具套装,文具,15.00,100,8件套学习用品),(飞科电吹风,家电,89.00,30,1800W 恒温护发);3前端页面4功能实现第9次packageorg.example.dailygoods.controller;importorg.example.dailygoods.pojo.Goods;importorg.example.dailygoods.pojo.Result;importorg.example.dailygoods.service.GoodsService;importorg.springframework.beans.factory.annotation.Autowired;importorg.springframework.web.bind.annotation.*;importjava.util.List;RestControllerRequestMapping(/api/goods)publicclassGoodsController{AutowiredprivateGoodsServicegoodsService;GetMappingpublicResultlist(){ListGoodsgoodsListgoodsService.findAll();returnResult.success(goodsList);}GetMapping(/{id})publicResultgetInfo(PathVariableIntegerid){GoodsgoodsgoodsService.getById(id);returnResult.success(goods);}PostMappingpublicResultadd(RequestBodyGoodsgoods){goodsService.add(goods);returnResult.success();}PutMappingpublicResultupdate(RequestBodyGoodsgoods){goodsService.update(goods);returnResult.success();}DeleteMapping(/{id})publicResultdelete(PathVariableIntegerid){goodsService.deleteById(id);returnResult.success();}}
web应用技术-第8次和第9次课后作业
第8次1接口文档Base URL: http://localhost:8080商品 /api/goods| 方法 | 路径 | 说明 || GET | /api/goods | 查询全部 || GET | /api/goods/{id} | 按ID查询 || POST | /api/goods | 新增 || PUT | /api/goods | 修改 || DELETE | /api/goods/{id} | 删除 |POST/PUT 请求体:json { name:商品名, category:分类, price:2.00, stock:100, description:描述 }PUT 需额外传 id。购物车 /api/cart| 方法 | 路径 | 说明 || GET | /api/cart | 获取列表 || POST | /api/cart | 添加 { goodsId:1, quantity:1 } || PUT | /api/cart/{id} | 更新数量 { quantity:3 } || DELETE | /api/cart/{id} | 删除单项 || DELETE | /api/cart | 清空 |响应格式json { code: 1, msg: success, data: null }code: 1成功, 0失败2数据库CREATEDATABASEIFNOTEXISTSdaily_goodsDEFAULTCHARACTERSETutf8mb4DEFAULTCOLLATEutf8mb4_unicode_ci;USEdaily_goods;DROPTABLEIFEXISTScart;DROPTABLEIFEXISTSgoods;CREATETABLEgoods(idINTAUTO_INCREMENTPRIMARYKEYCOMMENT商品ID,nameVARCHAR(100)NOTNULLCOMMENT商品名称,categoryVARCHAR(50)DEFAULTNULLCOMMENT商品分类,priceDECIMAL(10,2)DEFAULT0.00COMMENT商品价格,stockINTDEFAULT0COMMENT库存数量,descriptionVARCHAR(500)DEFAULTNULLCOMMENT商品描述,create_timeDATETIMEDEFAULTCURRENT_TIMESTAMPCOMMENT创建时间,update_timeDATETIMEDEFAULTCURRENT_TIMESTAMPONUPDATECURRENT_TIMESTAMPCOMMENT更新时间)ENGINEInnoDBDEFAULTCHARSETutf8mb4COMMENT商品表;CREATETABLEcart(idINTAUTO_INCREMENTPRIMARYKEYCOMMENT购物车ID,goods_idINTNOTNULLCOMMENT商品ID,quantityINTDEFAULT1COMMENT数量,create_timeDATETIMEDEFAULTCURRENT_TIMESTAMPCOMMENT创建时间,update_timeDATETIMEDEFAULTCURRENT_TIMESTAMPONUPDATECURRENT_TIMESTAMPCOMMENT更新时间,UNIQUEKEYuk_goods(goods_id))ENGINEInnoDBDEFAULTCHARSETutf8mb4COMMENT购物车表;INSERTINTOgoods(name,category,price,stock,description)VALUES(农夫山泉矿泉水,饮料,2.00,200,550ml 天然矿泉水),(康师傅方便面,食品,4.50,150,红烧牛肉面 袋装),(清风抽纸,日用品,12.00,80,原木纯品 3层130抽*3包),(蓝月亮洗衣液,清洁,29.90,60,深层洁净 1kg装),(蒙牛纯牛奶,饮料,3.00,120,250ml 利乐砖),(舒肤佳香皂,个人护理,4.50,200,纯白清香型 115g),(海天酱油,调味品,8.80,90,金标生抽 500ml),(金龙鱼食用油,食品,59.90,40,花生油 1.8L),(得力文具套装,文具,15.00,100,8件套学习用品),(飞科电吹风,家电,89.00,30,1800W 恒温护发);3前端页面4功能实现第9次packageorg.example.dailygoods.controller;importorg.example.dailygoods.pojo.Goods;importorg.example.dailygoods.pojo.Result;importorg.example.dailygoods.service.GoodsService;importorg.springframework.beans.factory.annotation.Autowired;importorg.springframework.web.bind.annotation.*;importjava.util.List;RestControllerRequestMapping(/api/goods)publicclassGoodsController{AutowiredprivateGoodsServicegoodsService;GetMappingpublicResultlist(){ListGoodsgoodsListgoodsService.findAll();returnResult.success(goodsList);}GetMapping(/{id})publicResultgetInfo(PathVariableIntegerid){GoodsgoodsgoodsService.getById(id);returnResult.success(goods);}PostMappingpublicResultadd(RequestBodyGoodsgoods){goodsService.add(goods);returnResult.success();}PutMappingpublicResultupdate(RequestBodyGoodsgoods){goodsService.update(goods);returnResult.success();}DeleteMapping(/{id})publicResultdelete(PathVariableIntegerid){goodsService.deleteById(id);returnResult.success();}}
