基于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
使用说明
- 使用Navicat或者其它工具,在mysql中创建对应名称的数据库,并导入项目的sql文件; 2. 使用IDEA/Eclipse/MyEclipse导入项目,导入成功后请执行maven clean;maven install命令,然后运行; 3. 将项目中application.properties配置文件中的数据库配置改为自己的配置; 4. 运行项目,项目运行成功后在浏览器中访问: 管理员登录地址:http://localhost:8080/ manager管理员账号密码:admin/123456 employee雇员账号密码:test/123456
*/
@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";