admin管理员组文章数量:1130349
基于javaweb和mysql的springboot进销存管理系统(java+springboot+jpa+maven+jquery+mysql+jsp)
私信源码获取及调试交流
私信源码获取及调试交流
运行环境
Java≥8、MySQL≥5.7
开发工具
eclipse/idea/myeclipse/sts等均可配置运行
适用
课程设计,大作业,毕业设计,项目练习,学习演示等
功能说明
基于javaweb的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
@Controller
@RequestMapping("/salereturn")
@SessionAttributes(value={"cont","returnsList","cutPage","talPage"})
public class SaleReturnController {
private Logger logger = LoggerFactory.getLogger(this.getClass());
private List<SaleReturnItem> itemsList;
private List<SaleReturnOrder> returnsList;
private Long cont;
private Long cutPage;
private Long talPage;
@Resource
private SaleReturnService saleReturnService;
@Resource
private SaleService saleService;
/**
* 添加销售退货订单
* @param request
* @param model
* @return
*/
@RequestMapping("/addOrder")
public String addReturnOrder(HttpServletRequest request,Model model){
logger.info("销售退货订单添加");
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";
}
}
/**
try {
customerList = suppliersAndCustomerService.findCustomerByPage(0);
couns = suppliersAndCustomerService.findCustomerCount();
curtPage = 1L;
totaPage = suppliersAndCustomerService.getCustomerTotalPage();
model.addAttribute("couns", couns);
model.addAttribute("curtPage", curtPage);
model.addAttribute("totaPage", totaPage);
model.addAttribute("goodsList", customerList);
} catch (ServiceException e) {
e.printStackTrace();
}
return "customer-list";
}
/**
* 添加客户
* @param request
* @param model
* @return
*/
@RequestMapping("/customeradd")
public String customerAdd(HttpServletRequest request,Model model){
String name = request.getParameter("name");
String address = request.getParameter("address");
String zip = request.getParameter("zip");
String telPhone = request.getParameter("telPhone");
String linkMan = request.getParameter("linkMan");
String linkTel = request.getParameter("linkTel");
String bank = request.getParameter("bank");
String bankAccount = request.getParameter("bankAccount");
String email = request.getParameter("email");
customer = new Customer();
customer.setName(name);
customer.setAddress(address);
customer.setZip(zip);
customer.setTelPhone(telPhone);
customer.setLinkMan(linkMan);
customer.setLinkTel(linkTel);
customer.setBank(bank);
customer.setBankAccount(bankAccount);
customer.setEmail(email);
try {
suppliersAndCustomerService.saveCustomer(customer);
} catch (ServiceException e) {
e.printStackTrace();
}
try {
customerList = suppliersAndCustomerService.findCustomerByPage(0);
couns = suppliersAndCustomerService.findCustomerCount();
curtPage = 1L;
}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 "outStock";
}
/**
* 分页功能中 首页 尾页
* @param request
* @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")
return "customer-list";
}
/**
* customer分页功能中上一页
* @param request
* @param model
* @return
*/
@RequestMapping("/multipageDown2")
public String getPurchaseDown2(HttpServletRequest request,Model model){
Long pageNum =Long.parseLong(request.getParameter("curPage"));
try {
if(pageNum>1){
customerList = suppliersAndCustomerService.findCustomerByPage((int)(pageNum-2));
curtPage = pageNum-1;
}else if(pageNum == 1){
customerList = suppliersAndCustomerService.findCustomerByPage((int)(pageNum-1));
curtPage = pageNum;
}
} catch (ServiceException e) {
e.printStackTrace();
}
model.addAttribute("curtPage", curtPage);
model.addAttribute("goodsList", customerList);
return "customer-list";
}
/**
* customer分页功能中下一页
* @param request
* @param model
* @return
*/
@RequestMapping("/multipageUp2")
public String getPurchaseUp2(HttpServletRequest request,Model model){
Long pageNum =Long.parseLong(request.getParameter("curPage"));
try {
if(pageNum<=(totaPage-1)){
customerList = suppliersAndCustomerService.findCustomerByPage((int)(pageNum-0));
curtPage = pageNum+1;
}else if(pageNum == totaPage){
customerList = suppliersAndCustomerService.findCustomerByPage((int)(pageNum-1));
curtPage = pageNum;
}
} catch (ServiceException e) {
} catch (ServiceException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
model.addAttribute("returnList", returnList);
model.addAttribute("counts", counts);
model.addAttribute("currPage", currPage);
model.addAttribute("tatPage", tatPage);
return "returnPurchase-list";
}
/**
* 分页功能中 首页 尾页
* @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;
}
// TODO Auto-generated catch block
e.printStackTrace();
}
model.addAttribute("currentPage", crrentPage);
model.addAttribute("saleorderList", saleorderList);
return "out-salestock";
}
/**
* 分页功能中下一页
* @param request
* @param 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";
}
}
purchaseItem = new PurchaseItem();
purchaseItem.setCount(count);
purchaseItem.setPrice(price);
purchaseItem.setName(name);
purchaseItem.setSupplierId(suppliersId);
list.add(purchaseItem);
model.addAttribute("list", list);
logger.info("成功添加商品");
return "article-list";
}
/**
* 此方法用于跳转到入库首页
* @param model
* @return
*/
@RequestMapping("/forwordAddStock")
public String fowordAddStock(Model model){
try {
orderList = managerService.findPurchaseOrderByPage(0);
count = managerService.findPurchaseOrderCount();
currentPage = 1L;
totalPage = managerService.getTotalPage();
model.addAttribute("currentPage", currentPage);
model.addAttribute("totalPage", totalPage);
model.addAttribute("orderList", orderList);
model.addAttribute("count", count);
} catch (ServiceException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return "add-stock";
}
/**
*
* @param request
* @param model
* @return
*/
@RequestMapping("/addstock")
public String addStocks(HttpServletRequest request,Model model){
logger.info("采购商品添加至库存");
Long orderId = Long.parseLong(request.getParameter("orderId"));
try {
Long id = Long.parseLong(request.getParameter("orderId"));
try {
suppliersAndCustomerService.delCustomerById(id);
customerList = suppliersAndCustomerService.findCustomerByPage(0);
couns = suppliersAndCustomerService.findCustomerCount();
model.addAttribute("couns", couns);
model.addAttribute("goodsList", customerList);
} catch (ServiceException e) {
e.printStackTrace();
}
return "customer-list";
}
/**
* 跳转到员工资料首页
* @param model
* @return
*/
@RequestMapping("/gotoEmployee")
public String forwordEmployee(Model model){
try {
employeeList = suppliersAndCustomerService.findEmplyeeByPage(0);
couns = suppliersAndCustomerService.findEmployeeCount();
curtPage = 1L;
totaPage = suppliersAndCustomerService.getEmployeeTotalPage();
model.addAttribute("couns", couns);
model.addAttribute("curtPage", curtPage);
model.addAttribute("totaPage", totaPage);
model.addAttribute("goodsList", employeeList);
} catch (ServiceException e) {
e.printStackTrace();
}
return "employee-list";
}
/**
* 删除员工
* @param request
* @param model
* @return
*/
@RequestMapping("/delEmployee")
public String delEmployee(HttpServletRequest request,Model model){
Long id = Long.parseLong(request.getParameter("orderId"));
try {
suppliersAndCustomerService.delEmployeeById(id);
employeeList = suppliersAndCustomerService.findEmplyeeByPage(0);
couns = suppliersAndCustomerService.findEmployeeCount();
model.addAttribute("couns", couns);
model.addAttribute("goodsList", employeeList);
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
* @param model
* @return
*/
@RequestMapping("/multipageDown1")
public String getPurchaseDown1(HttpServletRequest request,Model model){
Long pageNum =Long.parseLong(request.getParameter("curPage"));
try {
@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){
try {
saleorderList = saleService.findSaleOrderByPage(0);
cunt = saleService.findSaleOrderCount();
crrentPage = 1L;
/**
* 添加销售订单
* @param request
* @param model
* @return
*/
@RequestMapping("/addSaleOrder")
public String saveSaleOrder(HttpServletRequest request,Model model){
String pay = request.getParameter("pay");
SaleOrder saleOrder = new SaleOrder();
saleOrder.setFlag("未发货");
saleOrder.setPay(pay);
saleOrder.setSaleDate(new Date());
try {
int i = saleService.addSaleOrder(saleOrder,itemList);
if(i==1){
itemList.clear();
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) {
e.printStackTrace();
}
return "sale";
}
/**
* 分页功能中 首页 尾页
* @param request
* @param model
* @return
*/
@RequestMapping("/multipage")
public String getPurchase(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;
* 分页功能中 首页 尾页
* @param request
* @param model
* @return
*/
@RequestMapping("/multipage")
public String getPurchase(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 "outStock";
}
/**
* 分页功能中上一页
* @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){
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 "outStock";
}
/**
* 分页功能中下一页
*/
@RequestMapping("/multipageDown")
public String getPurchaseDown(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 "outStock";
}
/**
* 分页功能中下一页
* @param request
* @param model
* @return
*/
@RequestMapping("/multipageUp")
public String getPurchaseUp(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 "outStock";
}
/**
* 分页功能中 首页 尾页
* @param request
* @param model
session.setAttribute("mess", "信息成功失败,请重新输入");
return "information";
}
}
/**
* 分页功能中 首页 尾页
* @param request
* @param model
* @return
*/
@RequestMapping("/multipage")
public String getPurchase(HttpServletRequest request,Model model){
Long pageNum =Long.parseLong(request.getParameter("curPage"));
try {
messageList = managerService.findMessageByPage((int)(pageNum-1));
} catch (ServiceException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
crrentPage = pageNum;
model.addAttribute("currentPage", crrentPage);
model.addAttribute("messageList", messageList);
return "message";
}
/**
* 分页功能中上一页
* @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){
messageList = managerService.findMessageByPage((int)(pageNum-2));
crrentPage = pageNum-1;
}else if(pageNum == 1){
messageList = managerService.findMessageByPage((int)(pageNum-1));
crrentPage = pageNum;
}
@Resource
private SaleReturnService saleReturnService;
@Resource
private SaleService saleService;
/**
* 添加销售退货订单
* @param request
* @param model
* @return
*/
@RequestMapping("/addOrder")
public String addReturnOrder(HttpServletRequest request,Model model){
logger.info("销售退货订单添加");
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
*/
public String getPurchaseDown(HttpServletRequest request,Model model){
Long pageNum =Long.parseLong(request.getParameter("curPage"));
try {
if(pageNum>1){
messageList = managerService.findMessageByPage((int)(pageNum-2));
crrentPage = pageNum-1;
}else if(pageNum == 1){
messageList = managerService.findMessageByPage((int)(pageNum-1));
crrentPage = pageNum;
}
} catch (ServiceException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
model.addAttribute("currentPage", crrentPage);
model.addAttribute("messageList", messageList);
return "message";
}
/**
* 分页功能中下一页
* @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)){
messageList = managerService.findMessageByPage((int)(pageNum-0));
crrentPage = pageNum+1;
}else if(pageNum == ttalPage){
messageList = managerService.findMessageByPage((int)(pageNum-1));
crrentPage = pageNum;
}
} catch (ServiceException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
model.addAttribute("currentPage", crrentPage);
model.addAttribute("messageList", messageList);
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")
public String getPurchaseUp(HttpServletRequest request,Model model){
Long pageNum =Long.parseLong(request.getParameter("curPage"));
try {
if(pageNum<=(tatPage-1)){
returnList = returnPurchaseService.findReturnOrderByPage((int)(pageNum-0));
currPage = pageNum+1;
}else if(pageNum == tatPage){
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";
}
}
基于javaweb和mysql的springboot进销存管理系统(java+springboot+jpa+maven+jquery+mysql+jsp)
私信源码获取及调试交流
私信源码获取及调试交流
运行环境
Java≥8、MySQL≥5.7
开发工具
eclipse/idea/myeclipse/sts等均可配置运行
适用
课程设计,大作业,毕业设计,项目练习,学习演示等
功能说明
基于javaweb的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
@Controller
@RequestMapping("/salereturn")
@SessionAttributes(value={"cont","returnsList","cutPage","talPage"})
public class SaleReturnController {
private Logger logger = LoggerFactory.getLogger(this.getClass());
private List<SaleReturnItem> itemsList;
private List<SaleReturnOrder> returnsList;
private Long cont;
private Long cutPage;
private Long talPage;
@Resource
private SaleReturnService saleReturnService;
@Resource
private SaleService saleService;
/**
* 添加销售退货订单
* @param request
* @param model
* @return
*/
@RequestMapping("/addOrder")
public String addReturnOrder(HttpServletRequest request,Model model){
logger.info("销售退货订单添加");
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";
}
}
/**
try {
customerList = suppliersAndCustomerService.findCustomerByPage(0);
couns = suppliersAndCustomerService.findCustomerCount();
curtPage = 1L;
totaPage = suppliersAndCustomerService.getCustomerTotalPage();
model.addAttribute("couns", couns);
model.addAttribute("curtPage", curtPage);
model.addAttribute("totaPage", totaPage);
model.addAttribute("goodsList", customerList);
} catch (ServiceException e) {
e.printStackTrace();
}
return "customer-list";
}
/**
* 添加客户
* @param request
* @param model
* @return
*/
@RequestMapping("/customeradd")
public String customerAdd(HttpServletRequest request,Model model){
String name = request.getParameter("name");
String address = request.getParameter("address");
String zip = request.getParameter("zip");
String telPhone = request.getParameter("telPhone");
String linkMan = request.getParameter("linkMan");
String linkTel = request.getParameter("linkTel");
String bank = request.getParameter("bank");
String bankAccount = request.getParameter("bankAccount");
String email = request.getParameter("email");
customer = new Customer();
customer.setName(name);
customer.setAddress(address);
customer.setZip(zip);
customer.setTelPhone(telPhone);
customer.setLinkMan(linkMan);
customer.setLinkTel(linkTel);
customer.setBank(bank);
customer.setBankAccount(bankAccount);
customer.setEmail(email);
try {
suppliersAndCustomerService.saveCustomer(customer);
} catch (ServiceException e) {
e.printStackTrace();
}
try {
customerList = suppliersAndCustomerService.findCustomerByPage(0);
couns = suppliersAndCustomerService.findCustomerCount();
curtPage = 1L;
}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 "outStock";
}
/**
* 分页功能中 首页 尾页
* @param request
* @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")
return "customer-list";
}
/**
* customer分页功能中上一页
* @param request
* @param model
* @return
*/
@RequestMapping("/multipageDown2")
public String getPurchaseDown2(HttpServletRequest request,Model model){
Long pageNum =Long.parseLong(request.getParameter("curPage"));
try {
if(pageNum>1){
customerList = suppliersAndCustomerService.findCustomerByPage((int)(pageNum-2));
curtPage = pageNum-1;
}else if(pageNum == 1){
customerList = suppliersAndCustomerService.findCustomerByPage((int)(pageNum-1));
curtPage = pageNum;
}
} catch (ServiceException e) {
e.printStackTrace();
}
model.addAttribute("curtPage", curtPage);
model.addAttribute("goodsList", customerList);
return "customer-list";
}
/**
* customer分页功能中下一页
* @param request
* @param model
* @return
*/
@RequestMapping("/multipageUp2")
public String getPurchaseUp2(HttpServletRequest request,Model model){
Long pageNum =Long.parseLong(request.getParameter("curPage"));
try {
if(pageNum<=(totaPage-1)){
customerList = suppliersAndCustomerService.findCustomerByPage((int)(pageNum-0));
curtPage = pageNum+1;
}else if(pageNum == totaPage){
customerList = suppliersAndCustomerService.findCustomerByPage((int)(pageNum-1));
curtPage = pageNum;
}
} catch (ServiceException e) {
} catch (ServiceException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
model.addAttribute("returnList", returnList);
model.addAttribute("counts", counts);
model.addAttribute("currPage", currPage);
model.addAttribute("tatPage", tatPage);
return "returnPurchase-list";
}
/**
* 分页功能中 首页 尾页
* @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;
}
// TODO Auto-generated catch block
e.printStackTrace();
}
model.addAttribute("currentPage", crrentPage);
model.addAttribute("saleorderList", saleorderList);
return "out-salestock";
}
/**
* 分页功能中下一页
* @param request
* @param 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";
}
}
purchaseItem = new PurchaseItem();
purchaseItem.setCount(count);
purchaseItem.setPrice(price);
purchaseItem.setName(name);
purchaseItem.setSupplierId(suppliersId);
list.add(purchaseItem);
model.addAttribute("list", list);
logger.info("成功添加商品");
return "article-list";
}
/**
* 此方法用于跳转到入库首页
* @param model
* @return
*/
@RequestMapping("/forwordAddStock")
public String fowordAddStock(Model model){
try {
orderList = managerService.findPurchaseOrderByPage(0);
count = managerService.findPurchaseOrderCount();
currentPage = 1L;
totalPage = managerService.getTotalPage();
model.addAttribute("currentPage", currentPage);
model.addAttribute("totalPage", totalPage);
model.addAttribute("orderList", orderList);
model.addAttribute("count", count);
} catch (ServiceException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return "add-stock";
}
/**
*
* @param request
* @param model
* @return
*/
@RequestMapping("/addstock")
public String addStocks(HttpServletRequest request,Model model){
logger.info("采购商品添加至库存");
Long orderId = Long.parseLong(request.getParameter("orderId"));
try {
Long id = Long.parseLong(request.getParameter("orderId"));
try {
suppliersAndCustomerService.delCustomerById(id);
customerList = suppliersAndCustomerService.findCustomerByPage(0);
couns = suppliersAndCustomerService.findCustomerCount();
model.addAttribute("couns", couns);
model.addAttribute("goodsList", customerList);
} catch (ServiceException e) {
e.printStackTrace();
}
return "customer-list";
}
/**
* 跳转到员工资料首页
* @param model
* @return
*/
@RequestMapping("/gotoEmployee")
public String forwordEmployee(Model model){
try {
employeeList = suppliersAndCustomerService.findEmplyeeByPage(0);
couns = suppliersAndCustomerService.findEmployeeCount();
curtPage = 1L;
totaPage = suppliersAndCustomerService.getEmployeeTotalPage();
model.addAttribute("couns", couns);
model.addAttribute("curtPage", curtPage);
model.addAttribute("totaPage", totaPage);
model.addAttribute("goodsList", employeeList);
} catch (ServiceException e) {
e.printStackTrace();
}
return "employee-list";
}
/**
* 删除员工
* @param request
* @param model
* @return
*/
@RequestMapping("/delEmployee")
public String delEmployee(HttpServletRequest request,Model model){
Long id = Long.parseLong(request.getParameter("orderId"));
try {
suppliersAndCustomerService.delEmployeeById(id);
employeeList = suppliersAndCustomerService.findEmplyeeByPage(0);
couns = suppliersAndCustomerService.findEmployeeCount();
model.addAttribute("couns", couns);
model.addAttribute("goodsList", employeeList);
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
* @param model
* @return
*/
@RequestMapping("/multipageDown1")
public String getPurchaseDown1(HttpServletRequest request,Model model){
Long pageNum =Long.parseLong(request.getParameter("curPage"));
try {
@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){
try {
saleorderList = saleService.findSaleOrderByPage(0);
cunt = saleService.findSaleOrderCount();
crrentPage = 1L;
/**
* 添加销售订单
* @param request
* @param model
* @return
*/
@RequestMapping("/addSaleOrder")
public String saveSaleOrder(HttpServletRequest request,Model model){
String pay = request.getParameter("pay");
SaleOrder saleOrder = new SaleOrder();
saleOrder.setFlag("未发货");
saleOrder.setPay(pay);
saleOrder.setSaleDate(new Date());
try {
int i = saleService.addSaleOrder(saleOrder,itemList);
if(i==1){
itemList.clear();
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) {
e.printStackTrace();
}
return "sale";
}
/**
* 分页功能中 首页 尾页
* @param request
* @param model
* @return
*/
@RequestMapping("/multipage")
public String getPurchase(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;
* 分页功能中 首页 尾页
* @param request
* @param model
* @return
*/
@RequestMapping("/multipage")
public String getPurchase(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 "outStock";
}
/**
* 分页功能中上一页
* @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){
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 "outStock";
}
/**
* 分页功能中下一页
*/
@RequestMapping("/multipageDown")
public String getPurchaseDown(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 "outStock";
}
/**
* 分页功能中下一页
* @param request
* @param model
* @return
*/
@RequestMapping("/multipageUp")
public String getPurchaseUp(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 "outStock";
}
/**
* 分页功能中 首页 尾页
* @param request
* @param model
session.setAttribute("mess", "信息成功失败,请重新输入");
return "information";
}
}
/**
* 分页功能中 首页 尾页
* @param request
* @param model
* @return
*/
@RequestMapping("/multipage")
public String getPurchase(HttpServletRequest request,Model model){
Long pageNum =Long.parseLong(request.getParameter("curPage"));
try {
messageList = managerService.findMessageByPage((int)(pageNum-1));
} catch (ServiceException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
crrentPage = pageNum;
model.addAttribute("currentPage", crrentPage);
model.addAttribute("messageList", messageList);
return "message";
}
/**
* 分页功能中上一页
* @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){
messageList = managerService.findMessageByPage((int)(pageNum-2));
crrentPage = pageNum-1;
}else if(pageNum == 1){
messageList = managerService.findMessageByPage((int)(pageNum-1));
crrentPage = pageNum;
}
@Resource
private SaleReturnService saleReturnService;
@Resource
private SaleService saleService;
/**
* 添加销售退货订单
* @param request
* @param model
* @return
*/
@RequestMapping("/addOrder")
public String addReturnOrder(HttpServletRequest request,Model model){
logger.info("销售退货订单添加");
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
*/
public String getPurchaseDown(HttpServletRequest request,Model model){
Long pageNum =Long.parseLong(request.getParameter("curPage"));
try {
if(pageNum>1){
messageList = managerService.findMessageByPage((int)(pageNum-2));
crrentPage = pageNum-1;
}else if(pageNum == 1){
messageList = managerService.findMessageByPage((int)(pageNum-1));
crrentPage = pageNum;
}
} catch (ServiceException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
model.addAttribute("currentPage", crrentPage);
model.addAttribute("messageList", messageList);
return "message";
}
/**
* 分页功能中下一页
* @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)){
messageList = managerService.findMessageByPage((int)(pageNum-0));
crrentPage = pageNum+1;
}else if(pageNum == ttalPage){
messageList = managerService.findMessageByPage((int)(pageNum-1));
crrentPage = pageNum;
}
} catch (ServiceException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
model.addAttribute("currentPage", crrentPage);
model.addAttribute("messageList", messageList);
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")
public String getPurchaseUp(HttpServletRequest request,Model model){
Long pageNum =Long.parseLong(request.getParameter("curPage"));
try {
if(pageNum<=(tatPage-1)){
returnList = returnPurchaseService.findReturnOrderByPage((int)(pageNum-0));
currPage = pageNum+1;
}else if(pageNum == tatPage){
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";
}
}
本文标签: 进销存管理系统SpringBootJavaWebMySQLjava
版权声明:本文标题:基于javaweb和mysql的springboot进销存管理系统(java+springboot+jpa+maven+jquery+mysql+jsp) 内容由热心网友自发贡献,该文观点仅代表作者本人, 转载请联系作者并注明出处:https://it.en369.cn/jiaocheng/1759991591a2836963.html, 本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容,一经查实,本站将立刻删除。


发表评论