基于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<=(talPage-1)){
returnsList = saleReturnService.findReturnOrderByPage((int)(pageNum-0));
cutPage = pageNum+1;
}else if(pageNum == talPage){
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";
}
}
package com.xu.web;
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);
}
}
package com.xu.web;
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";
}
/**
* 更新商品存放仓库
* @param request
* @param model
* @return
*/
@RequestMapping("updateArea")
public String upDateArea(HttpServletRequest request,Model model){
logger.info("存放仓库信息更新开始");
Long goodsId = Long.parseLong(request.getParameter("goodsId"));
String area = request.getParameter("area");
try {
stockService.updateStockAreaByGoodsId(area,goodsId);
List<Stock> list = stockService.findAllStock();
model.addAttribute("outList", list);
logger.info("存放仓库信息更新完成");
} catch (ServiceException e) {
e.printStackTrace();
}
*/
@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 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;
model.addAttribute("currentPage", crrentPage);
model.addAttribute("saleorderList", saleorderList);
return "sale";
}
/**
* 分页功能中上一页
* @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){
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";
}
private Long ttalPage;
private List<Message> messageList = new ArrayList<Message>();
@RequestMapping("/in")
public String forwordIn(){
return "login";
}
@RequestMapping("/checkMessage")
public String seeMessage(HttpServletRequest request,Model model){
Long id = Long.parseLong(request.getParameter("id"));
try {
Message message = managerService.findMessageById(id);
managerService.updateEmployeeById(id);
model.addAttribute("message",message);
} catch (ServiceException e) {
e.printStackTrace();
}
return "seemessage";
}
@RequestMapping("/out")
public String forwordOut(HttpServletRequest req){
ServletContext app = req.getSession().getServletContext();
app.removeAttribute("user");
return "login";
}
@RequestMapping("/gotoInformation")
public String forwordInformation(){
return "information";
}
/**
* 获取所有消息
* @param model
* @return
*/
@RequestMapping("/getMessage")
public String getAllMessage(Model model){
try {
messageList = managerService.findAllMessage();
cunt = managerService.findMessageCounts();
crrentPage = 1L;
ttalPage = managerService.getMessageTotalPage();
}
} catch (ServiceException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
model.addAttribute("currentPage", currentPage);
model.addAttribute("orderList", orderList);
return "add-stock";
}
}
package com.xu.web;
@Controller
@RequestMapping("/stock")
@SessionAttributes(value={"outList","coun","totPage","curPage","sock"})
public class StockController {
private Logger logger = LoggerFactory.getLogger(this.getClass());
private Long coun;
private Long totPage;
private Long curPage;
private Stock stock;
private Goods goods;
private List<Stock> outList;
@Resource
private StockService stockService;
/**
* 添加商品信息和库存
* @param request
* @return
Long pageNum =Long.parseLong(request.getParameter("curPage"));
try {
customerList = suppliersAndCustomerService.findCustomerByPage((int)(pageNum-1));
} catch (ServiceException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
curtPage = pageNum;
model.addAttribute("curtPage", curtPage);
model.addAttribute("goodsList", customerList);
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)){
}
/**
* 跳转到商品出库页面
* @param model
* @return
*/
@RequestMapping("/out")
public String out(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 "outStock";
}
/**
* 跳转到商品库存查询页面
* @return
*/
@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);
goods.setSupplierId(supplierId);
goods.setUnit(unit);
stock.setArea(area);
stock.setCounts(count);
goods.setPrice(price);
logger.info("库存添加完成");
try {
stockService.stockAdd(stock, goods);
} catch (ServiceException e) {
e.printStackTrace();
}
return "index";
}
/**
* 更新库存信息
* @param request
* @param model
* @return
*/
@RequestMapping("/update")
public String UpdateStock(HttpServletRequest request,Model model){
logger.info("库存信息更新开始");
Long goodsId = Long.parseLong(request.getParameter("goodsId"));
Long count = Long.parseLong(request.getParameter("count"));
try {
stockService.updateStock(goodsId,count);
outList = stockService.findStockByPage(0);
model.addAttribute("outList", outList);
logger.info("库存信息更新完成");
} catch (ServiceException e) {
e.printStackTrace();
}
return "outStock";
}
/**
* 跳转到商品出库页面
* @param model
* @return
*/
private PurchaseItem purchaseItem;
private PurchaseOrder purchaseOrder;
@Resource
private ManagerService managerService;
@Resource
private StockService stockService;
/*
* 此方法用于添加采购商品
*/
@RequestMapping("/add")
public String add(HttpServletRequest request,HttpServletResponse response,Model model){
logger.info("开始添加商品");
Long suppliersId = Long.parseLong(request.getParameter("suppliersId"));
String name = request.getParameter("name");
Double price = Double.parseDouble(request.getParameter("price"));
Long count =Long.parseLong(request.getParameter("count"));
String unit = request.getParameter("unit");
String space = request.getParameter("space");
Long supplierId = Long.parseLong(request.getParameter("supplierId"));
String approveId = request.getParameter("approveId");
String batchId = request.getParameter("batchId");
goods = new Goods();
goods.setName(name);
goods.setApproveId(approveId);
goods.setBatchId(batchId);
goods.setSpace(space);
goods.setSupplierId(supplierId);
goods.setUnit(unit);
goods.setPrice(price);
try {
stockService.saveGoods(goods);
} catch (ServiceException e) {
e.printStackTrace();
}
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 {
@Controller
@RequestMapping("/log")
@SessionAttributes(value={"messageList","message","cunt","crrentPage","ttalPage"})
public class LoginAndLogOutController {
@Resource
private ManagerService managerService;
private Long cunt;
private Long crrentPage;
private Long ttalPage;
private List<Message> messageList = new ArrayList<Message>();
@RequestMapping("/in")
public String forwordIn(){
return "login";
}
@RequestMapping("/checkMessage")
public String seeMessage(HttpServletRequest request,Model model){
Long id = Long.parseLong(request.getParameter("id"));
try {
Message message = managerService.findMessageById(id);
managerService.updateEmployeeById(id);
model.addAttribute("message",message);
} catch (ServiceException e) {
e.printStackTrace();
}
return "seemessage";
}
@RequestMapping("/out")
public String forwordOut(HttpServletRequest req){
ServletContext app = req.getSession().getServletContext();
app.removeAttribute("user");
return "login";
}
@RequestMapping("/gotoInformation")
public String forwordInformation(){
return "information";
}
return "querySuppliers";
}
}
package com.xu.web;
@RestController
@WebServlet(urlPatterns="/managerlogin")
public class LoginServlet extends HttpServlet{
private Logger logger = LoggerFactory.getLogger(this.getClass());
private static final long serialVersionUID = 1L;
@Resource
private ManagerService managerService;
@Override
protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
String name = req.getParameter("username");
String password = req.getParameter("password");
String user = req.getParameter("user");
if("manager".equals(user)){
Managers managers = null;
try {
managers = managerService.login(name, password);
} catch (ServiceException e) {
e.printStackTrace();
}
if(managers!=null){
logger.info("提交采购订单");
String pay = request.getParameter("pay");
purchaseOrder = new PurchaseOrder();
purchaseOrder.setPay(pay);
purchaseOrder.setInDate(new Date());
purchaseOrder.setFlag("未入库");
try {
int i = managerService.addPurchaseOrder(purchaseOrder, list);
if(i==1){
list.removeAll(list);
/*orderList.removeAll(orderList);*/
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);
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";
@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("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")
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";
}
@Controller
@RequestMapping("/log")
@SessionAttributes(value={"messageList","message","cunt","crrentPage","ttalPage"})
public class LoginAndLogOutController {
@Resource
private ManagerService managerService;
private Long cunt;
private Long crrentPage;
private Long ttalPage;
private List<Message> messageList = new ArrayList<Message>();
@RequestMapping("/in")
public String forwordIn(){
return "login";
}
@RequestMapping("/checkMessage")
public String seeMessage(HttpServletRequest request,Model model){
Long id = Long.parseLong(request.getParameter("id"));
try {
Message message = managerService.findMessageById(id);
managerService.updateEmployeeById(id);
model.addAttribute("message",message);
} catch (ServiceException e) {
e.printStackTrace();
}
return "seemessage";
}
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";
}
/**
* 分页功能中下一页
* @param request
* @param model
* @return
*/
@RequestMapping("/multipageUp")
public String getPurchaseUp(HttpServletRequest request,Model model){
Long pageNum =Long.parseLong(request.getParameter("curPage"));
try {
if(pageNum<=(talPage-1)){
returnsList = saleReturnService.findReturnOrderByPage((int)(pageNum-0));
cutPage = pageNum+1;
}else if(pageNum == talPage){
returnsList = saleReturnService.findReturnOrderByPage((int)(pageNum-1));
cutPage = pageNum;
}
} catch (ServiceException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
model.addAttribute("cutPage", cutPage);
}
}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);
}
}
package com.xu.web;
@Controller
@RequestMapping("/manager")
public class ManagerRegisterController {
private Logger logger = LoggerFactory.getLogger(this.getClass());
@Resource
private ManagerService managerRegisterService;
private Managers manager;
private Employee employee;
@RequestMapping(value = "/register", method = RequestMethod.POST)
public @ResponseBody int data(HttpServletRequest request,HttpServletResponse response) {
String user = request.getParameter("user");
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";
}
/**
* 分页功能中下一页
* @param request
* @param model
* @return
*/
@RequestMapping("/multipageUp")
public String getPurchaseUp(HttpServletRequest request,Model model){
Long pageNum =Long.parseLong(request.getParameter("curPage"));
try {
if(pageNum<=(talPage-1)){
returnsList = saleReturnService.findReturnOrderByPage((int)(pageNum-0));
cutPage = pageNum+1;
}else if(pageNum == talPage){
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";
}
}
package com.xu.web;
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";
}
}
package com.xu.web;
@Controller
@RequestMapping("/returnPurchase")
@SessionAttributes(value={"itemList","returnList","counts","tatPage","currPage"})
public class ReturnPurchaseController {
private Logger logger = LoggerFactory.getLogger(this.getClass());
private List<ReturnItem> itemList;
* @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")
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 "querySuppliers";
}
/**
* 跳转到商品订单查询首页
* @return
*/
@RequestMapping("/goodsOrder")
public String gotoQueryGoodsOrder(){
return "querySaleOrder";
}
/**
* 跳转到商品订单查询首页
* @return
*/
@RequestMapping("/allgoodsOrder")
public String gotoQueryAllGoodsOrder(){
return "queryAllSaleOrder";
}
/**
* 销售统计
* @param request
* @param model
* @return
*/
@RequestMapping("/queryAllOrder")
public String queryAllOrders(HttpServletRequest request,Model model){
String min = request.getParameter("logmin");
String max = request.getParameter("logmax");
try {
Map<String,Long> map = queryService.findAllOrderCount(min,max);
model.addAttribute("map", map);
} catch (ServiceException e) {
e.printStackTrace();
}
return "queryAllSaleOrder";
}
/**
* 查询某种商品在某个时间段的销量
* @param request
* @param model
* @return
*/
@RequestMapping("/queryOrder")
public String queryGoodsOrders(HttpServletRequest request,Model model){
@RestController
@WebServlet(urlPatterns="/managerlogin")
public class LoginServlet extends HttpServlet{
private Logger logger = LoggerFactory.getLogger(this.getClass());
private static final long serialVersionUID = 1L;
@Resource
private ManagerService managerService;
@Override
protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
String name = req.getParameter("username");
String password = req.getParameter("password");
String user = req.getParameter("user");
if("manager".equals(user)){
Managers managers = null;
try {
managers = managerService.login(name, password);
} catch (ServiceException e) {
e.printStackTrace();
}
if(managers!=null){
logger.info(name+"登录成功!!!");
ServletContext app = req.getSession().getServletContext();
Long count = 0L;
try {
count = managerService.findMessageCount();
} 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);
curtPage = pageNum+1;
}else if(pageNum == totaPage){
customerList = suppliersAndCustomerService.findCustomerByPage((int)(pageNum-1));
curtPage = pageNum;
}
} catch (ServiceException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
model.addAttribute("curtPage", curtPage);
model.addAttribute("goodsList", customerList);
return "customer-list";
}
}
package com.xu.web;
@Controller