基于springboot的超市收银管理系统源码+数据库（毕业设计）.zip

package com.example.controller.commodity; import com.example.pojo.commodity.Product; import com.example.pojo.stock.Product_import; import com.example.pojo.stock.Product_online; import com.example.pojo.stock.Product_scrap; import com.example.service.commodity.ImportService; import com.example.service.commodity.OnlineService; import com.example.service.commodity.ProductService; import com.example.service.commodity.ScrapService; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Controller; import org.springframework.ui.Model; import org.springframework.web.bind.annotation.*; import javax.servlet.http.HttpServletResponse; import java.io.PrintWriter; import java.text.SimpleDateFormat; import java.util.Date; import java.util.List; /** * @author LinJie * @create 2020-12-11 10:10 */ @Controller @RequestMapping("/product") public class productController { @Autowired private ProductService productService; @Autowired private ImportService importService; @Autowired private ScrapService scrapService; @Autowired private OnlineService onlineService; @RequestMapping("/queryAll") public String queryAll(Model model) { List<Product> products = productService.queryAll(); model.addAttribute("allProducts", products); return "data-tables"; } //根据ID查询： @RequestMapping("/toQueryID") public String toQueryID(String id) { return "product/queryProdID"; } @RequestMapping("/queryID") public String queryID(String ProdID, Model model) { Product product = productService.queryByID(ProdID); System.out.println("【productID】" + product); model.addAttribute("allProducts", product); return "data-tables"; } //根据名称查询： @RequestMapping("/toQueryName") public String toQueryName(String name) { return "product/queryProdName"; } @RequestMapping("/queryName") public String queryName(String ProdName, Model model) { Product product = productService.queryByName(ProdName); System.out.println("【productName】" + product); model.addAttribute("allProducts", product); return "data-tables"; } //根据类别查询： @RequestMapping("/toQueryClass") public String toQueryClass(String id) { return "product/queryProdClass"; } @RequestMapping("/queryClass") public String queryClass(String ProdClass, Model model) { List<Product> products = productService.queryByClass(ProdClass); System.out.println("【productClass】" + products); model.addAttribute("allProducts", products); return "data-tables"; } @RequestMapping("/queryProductBySomething") public String queryProductBySomething(@RequestParam("proId") String proId, @RequestParam("proName") String proName, @RequestParam("proClass") String proClass, Model model) { List<Product> products = productService.queryBySomething(proId, proName, proClass); System.out.println("模糊查询:" + products); model.addAttribute("allProducts", products); return "data-tables"; } //这里开始是库存部分 @RequestMapping("/queryStock") public String queryStock(Model model) { List<Product> product_stock = productService.queryAll(); model.addAttribute("allProductStock", product_stock); return "stock/stock-tables"; } @RequestMapping("/queryProductBySomething2") public String queryProductBySomething2(@RequestParam("proId") String proId, @RequestParam("proName") String proName, @RequestParam("proClass") String proClass, Model model) { List<Product> products = productService.queryBySomething(proId, proName, proClass); System.out.println("模糊查询:" + products); model.addAttribute("allProductStock", products); return "stock/stock-tables"; } //跳转到上架 @RequestMapping("/upProduct/{productId}") public String upProduct(@PathVariable("productId") String productId, Model model) { Product product = productService.queryByID(productId); model.addAttribute("upProduct", product); return "stock/up"; } @RequestMapping("/up") public String up(@RequestParam String productId, @RequestParam int productNumber, HttpServletResponse response) throws Exception { response.setContentType("text/html; charset=UTF-8"); //转码 PrintWriter out = response.getWriter(); //【判断1】上架的数量为负数 if (productNumber < 0) { out.println("<script>"); out.println("alert('【操作失败】上架的数量不能小于0');"); out.println("history.back();"); out.println("</script>"); return null; } //【判断2】上架的数量小于库存量 Product product = productService.queryByID(productId); if (productNumber > product.getProduct_stock()) { out.println("<script>"); out.println("alert('【操作失败】上架的数量不能大于库存量');"); out.println("history.back();"); out.println("</script>"); return null; } //【正常执行】 //【1】修改商品表中的在架量、库存量 int zaiJia = product.getProduct_online() + productNumber; int kuCun = product.getProduct_stock() - productNumber; product.setProduct_online(zaiJia); product.setProduct_stock(kuCun); productService.updateWhole(product); //【2】插入上架记录 Product_online product_online = new Product_online(); Date date = new Date(); SimpleDateFormat sdf = new SimpleDateFormat("yyyyMMddHHmmss"); product_online.setProduct_date(sdf.format(date)); product_online.setProduct_id(productId); product_online.setProduct_name(product.getProduct_name()); product_online.setProduct_number(productNumber); product_online.setProduct_price(product.getProduct_export_price()); product_online.setProduct_type(product.getProduct_class()); onlineService.insertOnline(product_online); return "redirect:/product/queryStock"; } //stocks-Tables报废商品按钮点击后反应 @RequestMapping("/scrapProduct/{productId}") public String scarpProduct(@PathVariable("productId") String productId, Model model) { Product product = productService.queryByID(productId); model.addAttribute("scarpProduct", product); return "stock/scrap"; } //报废商品逻辑操作 @RequestMapping("/scrapProduct02") public String scarpProduct02(@RequestParam String productId, @RequestParam int productNumber, @RequestParam String productType, Model model, HttpServletResponse response) throws Exception { response.setContentType("text/html; charset=UTF-8"); //转码 PrintWriter out = response.getWriter(); Product product = productService.queryByID(productId); //首先判断输入是否有误 if (productNumber < 0) { //【判断】报废数量小于0 out.println("<script>"); out.println("alert('【操作失败】报废的数量不能小于0');"); out.println("history.back();"); out.println("</script>"); return null; }//【判断】如果报废的数量大于库存量 else if (productNumber > product.getProduct_stock()) { out.println("<script>"); out.println("alert('【操作失败】报废的数量大于库存量');"); out.println("history.back()