赞
踩
基于javaweb+mysql的springboot进销存管理系统(java+springboot+jpa+maven+jquery+mysql+jsp)
运行环境
Java≥8、MySQL≥5.7
开发工具
eclipse/idea/myeclipse/sts等均可配置运行
适用
课程设计,大作业,毕业设计,项目练习,学习演示等
功能说明
基于javaweb+mysql的SpringBoot进销存管理系统(java+springboot+jpa+maven+jquery+mysql+jsp)
项目介绍
本系统基本完成了一个基于spring boot + JPA的进销存管理系统,包括manager管理员与employee雇员两种角色。 主要实现采购管理、库存管理、销售管理、查询统计、资料管理和系统管理功能。 本系统的实现使用了很多计算机技术,包括Java语言、Spring boot框架、 JPA持久层框架和MySQL数据库。带文档
环境需要
1.运行环境:最好是java jdk 1.8,我们在这个平台上运行的。其他版本理论上也可以。 2.IDE环境:IDEA,Eclipse,Myeclipse都可以。推荐IDEA; 3.硬件环境:windows 7/8/10 1G内存以上;或者 Mac OS; 4.数据库:MySql 5.7版本; 5.是否Maven项目:是;
技术栈
springboot+jpa+mysql+maven+jquery
使用说明
*/ @RequestMapping("/multipageUp") public String getPurchaseUp(HttpServletRequest request,Model model){ Long pageNum =Long.parseLong(request.getParameter("curPage")); try { if(pageNum<=(totaPage-1)){ goodsList = systemService.findGoodsByPage((int)(pageNum-0)); curtPage = pageNum+1; }else if(pageNum == totaPage){ goodsList = systemService.findGoodsByPage((int)(pageNum-1)); curtPage = pageNum; } } catch (ServiceException e) { // TODO Auto-generated catch block e.printStackTrace(); } model.addAttribute("curtPage", curtPage); model.addAttribute("goodsList", goodsList); return "allGoods"; } /** * suppliers分页功能中 首页 尾页 * @param request * @param model * @return */ @RequestMapping("/multipage1") public String getPurchase1(HttpServletRequest request,Model model){ Long pageNum =Long.parseLong(request.getParameter("curPage")); try { suppliersList = suppliersAndCustomerService.findSuppliersByPage((int)(pageNum-1)); } catch (ServiceException e) { // TODO Auto-generated catch block e.printStackTrace(); } curtPage = pageNum; model.addAttribute("curtPage", curtPage); model.addAttribute("goodsList", suppliersList); return "suppliers-list"; } /** * suppliers分页功能中上一页 * @param request
} catch (ServiceException e) { e.printStackTrace(); } app.setAttribute("messageCount", count); app.setAttribute("user",managers); app.setAttribute("role",Role.Manager.value()); req.getRequestDispatcher("/WEB-INF/jsp/index.jsp").forward(req, resp); }else{ logger.info("登录失败,用户名或者密码错误"); HttpSession session = req.getSession(); session.setAttribute("msg","用户名或者密码错误"); req.getRequestDispatcher("/WEB-INF/jsp/login.jsp").forward(req, resp); } }else if("employee".equals(user)){ Employee employee = null; try { employee = managerService.employeelogin(name, password); } catch (ServiceException e) { e.printStackTrace(); } if(employee!=null){ logger.info(name+"登录成功!!!"); ServletContext app = req.getSession().getServletContext(); try { Long count = managerService.findMessageCount(); app.setAttribute("messageCount", count); app.setAttribute("user",employee); app.setAttribute("role",Role.Employee.value()); req.getRequestDispatcher("/WEB-INF/jsp/index.jsp").forward(req, resp); } catch (ServiceException e) { e.printStackTrace(); } }else{ logger.info("登录失败,用户名或者密码错误"); HttpSession session = req.getSession(); session.setAttribute("msg","用户名或者密码错误"); req.getRequestDispatcher("/WEB-INF/jsp/login.jsp").forward(req, resp); } }else{ logger.info("登录失败,没有选择用户类型"); HttpSession session = req.getSession(); session.setAttribute("msg","请选择用户类型");
* @param request * @param model * @return */ @RequestMapping("/multipage") public String getPurchase(HttpServletRequest request,Model model){ Long pageNum =Long.parseLong(request.getParameter("curPage")); try { returnList = returnPurchaseService.findReturnOrderByPage((int)(pageNum-1)); } catch (ServiceException e) { // TODO Auto-generated catch block e.printStackTrace(); } currPage = pageNum; model.addAttribute("currPage", currPage); model.addAttribute("returnList", returnList); return "returnPurchase-list"; } /** * 分页功能中上一页 * @param request * @param model * @return */ @RequestMapping("/multipageDown") public String getPurchaseDown(HttpServletRequest request,Model model){ Long pageNum =Long.parseLong(request.getParameter("curPage")); try { if(pageNum>1){ returnList = returnPurchaseService.findReturnOrderByPage((int)(pageNum-2)); currPage = pageNum-1; }else if(pageNum == 1){ returnList = returnPurchaseService.findReturnOrderByPage((int)(pageNum-1)); currPage = pageNum; } } catch (ServiceException e) { // TODO Auto-generated catch block e.printStackTrace(); } model.addAttribute("currPage", currPage); model.addAttribute("returnList", returnList); return "returnPurchase-list"; } /** * 分页功能中下一页 * @param request * @param model * @return */ @RequestMapping("/multipageUp")
try { Long count = queryService.findGoodsOrderByTimeAndName(min,max,orderName); model.addAttribute("name",orderName); model.addAttribute("count", count); } catch (ServiceException e) { e.printStackTrace(); } return "querySaleOrder"; } /** * 查询商品 * @param request * @param model * @return */ @RequestMapping("/queryGoods") public String querygoods(HttpServletRequest request,Model model){ String name = request.getParameter("goodName"); try { Goods goods = queryService.findGoodsByName(name); if (goods != null) { model.addAttribute("goods",goods); } } catch (ServiceException e) { e.printStackTrace(); } return "queryGoods"; } /** * 查询客户 * @param request * @param model * @return */ @RequestMapping("/queryEmployee") public String querycustomer(HttpServletRequest request,Model model){ String name = request.getParameter("customerName"); try { Customer customer = queryService.findCustomerByName(name); model.addAttribute("customer",customer); } catch (ServiceException e) {
// TODO Auto-generated catch block e.printStackTrace(); } model.addAttribute("curPage", curPage); model.addAttribute("outList", outList); return "stock"; } /** * 分页功能中下一页 * @param request * @param model * @return */ @RequestMapping("/multipageUp1") public String getPurchaseUp1(HttpServletRequest request,Model model){ Long pageNum =Long.parseLong(request.getParameter("curPage")); try { if(pageNum<=(totPage-1)){ outList = stockService.findStockByPage((int)(pageNum-0)); curPage = pageNum+1; }else if(pageNum == totPage){ outList = stockService.findStockByPage((int)(pageNum-1)); curPage = pageNum; } } catch (ServiceException e) { // TODO Auto-generated catch block e.printStackTrace(); } model.addAttribute("curPage", curPage); model.addAttribute("outList", outList); return "stock"; } }
@RequestMapping("/stockquery") public String forwordStockQuery(){ return "queryStock"; } /** * 商品库存查询 * @param request * @param model * @return */ @RequestMapping("/query") public String stockQuery(HttpServletRequest request,Model model){ logger.info("库存查询开始"); Long goodsId = Long.parseLong(request.getParameter("goodsId")); try { Stock stock = stockService.findStockByGoodsId(goodsId); model.addAttribute("sock", stock); logger.info("库存查询完成"); } catch (ServiceException e) { e.printStackTrace(); } return "queryStock"; } /** * 跳转到移库页面 * @param model * @return */ @RequestMapping("/area") public String forwordStockArea(Model model){ try { outList = stockService.findStockByPage(0); coun = stockService.findStockCount(); curPage = 1L; totPage = stockService.getTotalPage(); model.addAttribute("coun", coun); model.addAttribute("curPage", curPage); model.addAttribute("totPage", totPage); model.addAttribute("outList", outList); } catch (ServiceException e) { e.printStackTrace(); } return "updateArea"; }
@Controller @RequestMapping("/sale") @SessionAttributes(value={"cunt","crrentPage","ttalPage","saleorderList","itemList"}) public class SaleController { private Logger logger = LoggerFactory.getLogger(this.getClass()); private List<SaleItem> itemList = new ArrayList<SaleItem>(); private List<SaleOrder> saleorderList = new ArrayList<SaleOrder>(); private Long cunt; private Long crrentPage; private Long ttalPage; @Resource private SaleService saleService; @Resource private StockService stockService; /** * 此方法用于跳转到销售订单页面 * @return */ @RequestMapping(value="/gotosale") public String turn(Model model){ try { saleorderList = saleService.findSaleOrderByPage(0); cunt = saleService.findSaleOrderCount(); crrentPage = 1L; ttalPage = saleService.getTotalPage(); model.addAttribute("crrentPage", crrentPage); model.addAttribute("ttalPage", ttalPage); model.addAttribute("saleorderList", saleorderList); model.addAttribute("cunt", cunt); } catch (ServiceException e) { // TODO Auto-generated catch block e.printStackTrace(); } return "sale"; } /** * 此方法用于跳转到发货页面 * @return */ @RequestMapping(value="/gotooutsale") public String turns(Model model){
* @return */ @RequestMapping("/multipageUp1") public String getPurchaseUp1(HttpServletRequest request,Model model){ Long pageNum =Long.parseLong(request.getParameter("curPage")); try { if(pageNum<=(ttalPage-1)){ saleorderList = saleService.findSaleOrderByPage((int)(pageNum-0)); crrentPage = pageNum+1; }else if(pageNum == ttalPage){ saleorderList = saleService.findSaleOrderByPage((int)(pageNum-1)); crrentPage = pageNum; } } catch (ServiceException e) { // TODO Auto-generated catch block e.printStackTrace(); } model.addAttribute("currentPage", crrentPage); model.addAttribute("saleorderList", saleorderList); return "out-salestock"; } }
app.setAttribute("messageCount", count); app.setAttribute("user",employee); app.setAttribute("role",Role.Employee.value()); req.getRequestDispatcher("/WEB-INF/jsp/index.jsp").forward(req, resp); } catch (ServiceException e) { e.printStackTrace(); } }else{ logger.info("登录失败,用户名或者密码错误"); HttpSession session = req.getSession(); session.setAttribute("msg","用户名或者密码错误"); req.getRequestDispatcher("/WEB-INF/jsp/login.jsp").forward(req, resp); } }else{ logger.info("登录失败,没有选择用户类型"); HttpSession session = req.getSession(); session.setAttribute("msg","请选择用户类型"); req.getRequestDispatcher("/WEB-INF/jsp/login.jsp").forward(req, resp); } } @Override protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { // TODO Auto-generated method stub doGet(req, resp); } } @Controller @RequestMapping("/manager") public class ManagerRegisterController { private Logger logger = LoggerFactory.getLogger(this.getClass()); @Resource private ManagerService managerRegisterService;
* @param model * @return */ @RequestMapping("/multipage1") public String getPurchase1(HttpServletRequest request,Model model){ Long pageNum =Long.parseLong(request.getParameter("curPage")); try { outList = stockService.findStockByPage((int)(pageNum-1)); } catch (ServiceException e) { // TODO Auto-generated catch block e.printStackTrace(); } curPage = pageNum; model.addAttribute("curPage", curPage); model.addAttribute("outList", outList); return "stock"; } /** * 分页功能中上一页 * @param request * @param model * @return */ @RequestMapping("/multipageDown1") public String getPurchaseDown1(HttpServletRequest request,Model model){ Long pageNum =Long.parseLong(request.getParameter("curPage")); try { if(pageNum>1){ outList = stockService.findStockByPage((int)(pageNum-2)); curPage = pageNum-1; }else if(pageNum == 1){ outList = stockService.findStockByPage((int)(pageNum-1)); curPage = pageNum; } } catch (ServiceException e) { // TODO Auto-generated catch block e.printStackTrace(); } model.addAttribute("curPage", curPage); model.addAttribute("outList", outList); return "stock"; } /** * 分页功能中下一页 * @param request * @param model * @return */
Long pageNum =Long.parseLong(request.getParameter("curPage")); try { if(pageNum>1){ saleorderList = saleService.findSaleOrderByPage((int)(pageNum-2)); crrentPage = pageNum-1; }else if(pageNum == 1){ saleorderList = saleService.findSaleOrderByPage((int)(pageNum-1)); crrentPage = pageNum; } } catch (ServiceException e) { // TODO Auto-generated catch block e.printStackTrace(); } model.addAttribute("currentPage", crrentPage); model.addAttribute("saleorderList", saleorderList); return "sale"; } /** * 分页功能中下一页 * @param request * @param model * @return */ @RequestMapping("/multipageUp") public String getPurchaseUp(HttpServletRequest request,Model model){ Long pageNum =Long.parseLong(request.getParameter("curPage")); try { if(pageNum<=(ttalPage-1)){ saleorderList = saleService.findSaleOrderByPage((int)(pageNum-0)); crrentPage = pageNum+1; }else if(pageNum == ttalPage){ saleorderList = saleService.findSaleOrderByPage((int)(pageNum-1)); crrentPage = pageNum; } } catch (ServiceException e) { // TODO Auto-generated catch block e.printStackTrace(); } model.addAttribute("currentPage", crrentPage); model.addAttribute("saleorderList", saleorderList);
if(pageNum<=(ttalPage-1)){ saleorderList = saleService.findSaleOrderByPage((int)(pageNum-0)); crrentPage = pageNum+1; }else if(pageNum == ttalPage){ saleorderList = saleService.findSaleOrderByPage((int)(pageNum-1)); crrentPage = pageNum; } } catch (ServiceException e) { // TODO Auto-generated catch block e.printStackTrace(); } model.addAttribute("currentPage", crrentPage); model.addAttribute("saleorderList", saleorderList); return "sale"; } /** * 分页功能中 首页 尾页 * @param request * @param model * @return */ @RequestMapping("/multipage1") public String getPurchase1(HttpServletRequest request,Model model){ Long pageNum =Long.parseLong(request.getParameter("curPage")); try { saleorderList = saleService.findSaleOrderByPage((int)(pageNum-1)); } catch (ServiceException e) { // TODO Auto-generated catch block e.printStackTrace(); } crrentPage = pageNum; model.addAttribute("currentPage", crrentPage); model.addAttribute("saleorderList", saleorderList); return "out-salestock"; } /** * 分页功能中上一页 * @param request * @param model * @return */ @RequestMapping("/multipageDown1") public String getPurchaseDown1(HttpServletRequest request,Model model){ Long pageNum =Long.parseLong(request.getParameter("curPage")); try { if(pageNum>1){ saleorderList = saleService.findSaleOrderByPage((int)(pageNum-2)); crrentPage = pageNum-1; }else if(pageNum == 1){
* @return */ @RequestMapping("/multipage") public String getPurchase(HttpServletRequest request,Model model){ Long pageNum =Long.parseLong(request.getParameter("curPage")); try { returnsList = saleReturnService.findReturnOrderByPage((int)(pageNum-1)); } catch (ServiceException e) { // TODO Auto-generated catch block e.printStackTrace(); } cutPage = pageNum; model.addAttribute("cutPage", cutPage); model.addAttribute("returnsList", returnsList); return "salereturn"; } /** * 分页功能中上一页 * @param request * @param model * @return */ @RequestMapping("/multipageDown") public String getPurchaseDown(HttpServletRequest request,Model model){ Long pageNum =Long.parseLong(request.getParameter("curPage")); try { if(pageNum>1){ returnsList = saleReturnService.findReturnOrderByPage((int)(pageNum-2)); cutPage = pageNum-1; }else if(pageNum == 1){ returnsList = saleReturnService.findReturnOrderByPage((int)(pageNum-1)); cutPage = pageNum; } } catch (ServiceException e) { // TODO Auto-generated catch block e.printStackTrace(); } model.addAttribute("cutPage", cutPage); model.addAttribute("returnsList", returnsList); return "salereturn"; } /** * 分页功能中下一页
return "queryStock"; } /** * 商品库存查询 * @param request * @param model * @return */ @RequestMapping("/query") public String stockQuery(HttpServletRequest request,Model model){ logger.info("库存查询开始"); Long goodsId = Long.parseLong(request.getParameter("goodsId")); try { Stock stock = stockService.findStockByGoodsId(goodsId); model.addAttribute("sock", stock); logger.info("库存查询完成"); } catch (ServiceException e) { e.printStackTrace(); } return "queryStock"; } /** * 跳转到移库页面 * @param model * @return */ @RequestMapping("/area") public String forwordStockArea(Model model){ try { outList = stockService.findStockByPage(0); coun = stockService.findStockCount(); curPage = 1L; totPage = stockService.getTotalPage(); model.addAttribute("coun", coun); model.addAttribute("curPage", curPage); model.addAttribute("totPage", totPage); model.addAttribute("outList", outList); } catch (ServiceException e) { e.printStackTrace(); } return "updateArea"; }
Long orderId =Long.parseLong(request.getParameter("orderId")); try { List<SaleItem> saleItem = saleService.delPurchaseItemByPurchaseId(orderId); SaleOrder saleOrder = saleService.delOrderByPurchaseId(orderId); if("已发货".equals(saleOrder.getFlag())){ saleService.updateStockBySaleReturnOrder(saleItem); } itemsList = saleReturnService.addSaleReturnOrder(saleOrder, saleItem); returnsList = saleReturnService.findReturnOrderByPage(0); cont = saleReturnService.findReturnOrderCount(); cutPage = 1L; talPage = saleReturnService.getTotalPage(); model.addAttribute("itemsList", itemsList); model.addAttribute("returnsList", returnsList); model.addAttribute("cont", cont); model.addAttribute("cutPage", cutPage); model.addAttribute("talPage", talPage); logger.info("销售退货订单添加成功"); return "salereturn"; } catch (Exception e) { e.printStackTrace(); return "salereturn"; } } /** * 跳转到退货首页 * @param model * @return */ @RequestMapping("/forwordSaleReturn") public String forwordSale(Model model){ try { returnsList = saleReturnService.findReturnOrderByPage(0); cont = saleReturnService.findReturnOrderCount(); cutPage = 1L; talPage = saleReturnService.getTotalPage(); model.addAttribute("itemsList", itemsList); model.addAttribute("returnsList", returnsList); model.addAttribute("cont", cont); model.addAttribute("cutPage", cutPage); model.addAttribute("talPage", talPage); } catch (ServiceException e) { // TODO Auto-generated catch block e.printStackTrace(); } catch (EmptyResultDataAccessException e) { return null; } return "salereturn"; }
@RequestMapping("/gotoIndex") public String index(){ return "index"; } /** * 查看所有商品 * @param model * @return */ @RequestMapping("/goods") public String goods(Model model){ try { goodsList = systemService.findGoodsByPage(0); couns = systemService.findGoodsCount(); curtPage = 1L; totaPage = systemService.getTotalPage(); model.addAttribute("couns", couns); model.addAttribute("curtPage", curtPage); model.addAttribute("totaPage", totaPage); model.addAttribute("goodsList", goodsList); } catch (ServiceException e) { e.printStackTrace(); } return "allGoods"; } /** * 跳转到供应商资料首页 * @param model * @return */ @RequestMapping("/gotoSuppliers") public String forwordsuppliers(Model model){ try { suppliersList = suppliersAndCustomerService.findSuppliersByPage(0); couns = suppliersAndCustomerService.findSuppliersCount(); curtPage = 1L; totaPage = suppliersAndCustomerService.getTotalPage(); model.addAttribute("couns", couns); model.addAttribute("curtPage", curtPage);
model.addAttribute("totalPage", totalPage); model.addAttribute("orderList", orderList); model.addAttribute("count", count); logger.info("提交采购订单成功"); } } catch (ServiceException e) { e.printStackTrace(); } return "article-list"; } /** * 分页功能中 首页 尾页 * @param request * @param model * @return */ @RequestMapping("/multipage") public String getPurchase(HttpServletRequest request,Model model){ Long pageNum =Long.parseLong(request.getParameter("curPage")); try { orderList = managerService.findPurchaseOrderByPage((int)(pageNum-1)); } catch (ServiceException e) { // TODO Auto-generated catch block e.printStackTrace(); } currentPage = pageNum; model.addAttribute("currentPage", currentPage); model.addAttribute("orderList", orderList); return "article-list"; } /** * 分页功能中上一页 * @param request * @param model * @return */ @RequestMapping("/multipageDown") public String getPurchaseDown(HttpServletRequest request,Model model){
e.printStackTrace(); } return "message"; } /** * 修改个人信息 * @param req * @return */ @RequestMapping("/updatInformation") public String updateInformation(HttpServletRequest req){ String gender = req.getParameter("gender"); Long age = Long.parseLong(req.getParameter("age")); String phonenumber = req.getParameter("phonenumber"); ServletContext app = req.getSession().getServletContext(); Object attribute = app.getAttribute("user"); HttpSession session = req.getSession(); if(attribute instanceof Employee){ ((Employee) attribute).setGender(gender); ((Employee) attribute).setAge(age); ((Employee) attribute).setPhonenumber(phonenumber); try { Employee employee = managerService.updateEmplyeeByName((Employee)attribute); app.setAttribute("user",employee); session.setAttribute("mess", "信息成功修改"); } catch (ServiceException e) { e.printStackTrace(); } return "information"; }else if(attribute instanceof Managers){ ((Managers) attribute).setAge(age); ((Managers) attribute).setGender(gender); ((Managers) attribute).setPhonenumber(phonenumber); try { Managers managers = managerService.updateManagersByName((Managers) attribute); app.setAttribute("user",managers); session.setAttribute("mess", "信息成功修改"); } catch (ServiceException e) { e.printStackTrace(); } return "information"; }else{ session.setAttribute("mess", "信息成功失败,请重新输入"); return "information"; } }
Copyright © 2003-2013 www.wpsshop.cn 版权所有,并保留所有权利。