演示视频:
基于ssm maven超市库存管理系统源码
开发工具:idea或eclipse
数据库:mysql 数据库连接工具:navcat
关键代码:
package com.iuexam.controller;
import java.util.List;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpSession;
import com.iuexam.entity.Department;
import com.iuexam.service.DepartmentService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.ui.ModelMap;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import com.github.pagehelper.PageHelper;
import com.github.pagehelper.PageInfo;
import com.iuexam.entity.Kcxx;
import com.iuexam.entity.Manager;
import com.iuexam.entity.Staff;
import com.iuexam.service.imp.KcxxServiceImp;
import com.iuexam.service.imp.ManagerServiceImp;
import com.iuexam.service.imp.StaffServiceImp;
import com.iuexam.tools.Constants;
@Controller
@RequestMapping("/manager")
public class ManagerController {
@Autowired
ManagerServiceImp managerServiceImp;
@Autowired
StaffServiceImp staffServiceImp;
@Autowired
KcxxServiceImp kcxxServiceImp;
@Autowired
private DepartmentService departmentService;
@RequestMapping("/login")
public String login() {
return "manager/managerlogin";
}
@RequestMapping(value="/dologin")
public String dologin(@RequestParam("loginname") String managerid,@RequestParam("password") String pwd,
HttpSession session,HttpServletRequest request) {
Manager manager=managerServiceImp.getbyid(managerid, pwd);
if(manager!=null) {
session.setAttribute(Constants.Manager_SESSION, manager);
return "redirect:/manager/flatform/main";
}else {
request.setAttribute("error", "账号密码不匹配");
return "login";
}
}
@RequestMapping(value="/flatform/main")
public String main(HttpSession session,HttpServletRequest request) {
// 验证是否有session信息,防止非法登录,没有就跳转到登录页面
if(session.getAttribute(Constants.Manager_SESSION)==null)
{
return "redirect:/logout";
}
List<Kcxx> kcxx=kcxxServiceImp.kcxxWithProdata();
List<Kcxx> kcxx2=kcxxServiceImp.kcxxWithPronum();
if(!kcxx.isEmpty()||!kcxx2.isEmpty()) {
request.setAttribute("msg", "");
}else {
request.setAttribute("msg", "");
}
return "manager/main";
}
@RequestMapping(value="/flatform/staffmain")
public String staffmain(HttpSession session,HttpServletRequest request) {
// 验证是否有session信息,防止非法登录,没有就跳转到登录页面
if(session.getAttribute(Constants.Manager_SESSION)==null)
{
return "redirect:/logout";
}
List<Kcxx> kcxx=kcxxServiceImp.kcxxWithProdata();
List<Kcxx> kcxx2=kcxxServiceImp.kcxxWithPronum();
if(!kcxx.isEmpty()||!kcxx2.isEmpty()) {
request.setAttribute("msg", "");
}else {
request.setAttribute("msg", "");
}
return "manager/staffmain";
}
@RequestMapping(value="/logout")
public String logout(HttpSession session) {
// 退出清除esison
session.removeAttribute(Constants.Staff_SESSION);
session.invalidate();
return "redirect:/logout";
}
@RequestMapping("/getbyid")
public String grxx(String managerid,HttpServletRequest request,Model model){
request.setAttribute("manager", managerServiceImp.getmanager(managerid));
model.addAttribute("manager",managerServiceImp.getmanager(managerid));
return "manager/grxx";
}
@RequestMapping("/update")
public String update(Manager manager,HttpServletRequest request,Model model){
if(managerServiceImp.update(manager)) {
manager=managerServiceImp.getmanager(manager.getManagerid());
model.addAttribute("manager", manager);
return "redirect:/logout";
}
return null;
}
// 跳转到修改个人信息页面
@RequestMapping("/toupdate")
public String editmanager(Manager manager,HttpServletRequest request,Model model){
model.addAttribute("manager", managerServiceImp.getmanager(manager.getManagerid()));
return "manager/editmanager";
}
// 跳转到增加页面
@RequestMapping("/toadd")
public String toadd(Model model){
List<Department> departmentList = departmentService.selectDeptList(null);
model.addAttribute("departmentList",departmentList);
return "manager/addstaff";
}
//跳转到修改员工信息页面
@RequestMapping("/toupdatestaff")
public String editstaff(Staff staff,HttpServletRequest request,Model model){
model.addAttribute("staff", staffServiceImp.getbyid(staff.getStaffid()));
List<Department> departmentList = departmentService.selectDeptList(null);
model.addAttribute("departmentList",departmentList);
return "manager/editstaff";
}
//修改员工信息
@RequestMapping("/updatestaff")
public String updatestaff(Staff staff,HttpServletRequest request,Model model){
if(staffServiceImp.update(staff)) {
staff=staffServiceImp.getbyid(staff.getStaffid());
model.addAttribute("staff", staff);
return "redirect:getall";
}
return null;
}
// 先判断数据库有没有,有就更新,没有就新增
@RequestMapping("/insert")
public String insert(Staff staff,HttpServletRequest request,Model model){
if(null==staffServiceImp.getbyid(staff.getStaffid())) {
staffServiceImp.insert(staff);
}else {
staffServiceImp.update(staff);
}
return "redirect:getall";
}
// 删除
@RequestMapping("/delete")
public String delete(String staffid) {
staffServiceImp.delete(staffid);
return "redirect:getall";
}
// 查询所有
@RequestMapping("/getall")
public String getall_cus(ModelMap model,
@RequestParam(defaultValue="1",required=true,value="pn") Integer pn
) {
PageHelper.startPage(pn, 4);
List<Staff> staffs= staffServiceImp.getall();
PageInfo<Staff> pageInfo=new PageInfo<Staff>(staffs);
model.addAttribute("pageInfo", pageInfo);
return "manager/getall_staff";
}
//根据条件查询
@RequestMapping("getbyparams")
public String getbyparams(@RequestParam(value="staffname",required=false)String staffname,@RequestParam(value="staffid",required=false)String staffid,
@RequestParam(defaultValue="1",required=true,value="pn") Integer pn,HttpServletRequest request,Model model
) {
PageHelper.startPage(pn, 100);
List<Staff> staffs= staffServiceImp.getbyparams(staffid, staffname);
PageInfo<Staff> pageInfo=new PageInfo<Staff>(staffs);
model.addAttribute("pageInfo", pageInfo);
return "manager/getstaffbyparams";
}
}
package com.iuexam.controller;
import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.List;
import javax.servlet.http.HttpServletRequest;
import com.iuexam.entity.Warehouse;
import com.iuexam.service.WarehouseService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.beans.propertyeditors.CustomDateEditor;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.ui.ModelMap;
import org.springframework.web.bind.ServletRequestDataBinder;
import org.springframework.web.bind.annotation.InitBinder;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.ResponseBody;
import com.github.pagehelper.PageHelper;
import com.github.pagehelper.PageInfo;
import com.iuexam.entity.Kcxx;
import com.iuexam.service.imp.KcxxServiceImp;
@Controller
@RequestMapping("/staff/flatform/kcxx")
public class KcxxController {
@Autowired
KcxxServiceImp kcxxServiceImp;
@Autowired
private WarehouseService warehouseService;
// 跳转到增加页面
@RequestMapping("/toadd")
public String toadd(){
return "addkcxx";
}
// 跳转到修改页面
@RequestMapping("/toupdate")
public String editProduct(Kcxx kcxx,HttpServletRequest request,Model model){
model.addAttribute("kcxx", kcxxServiceImp.getbyid(kcxx.getProid()));
List<Warehouse> warehouseList = warehouseService.selectAllWarehouse(null,null);
model.addAttribute("warehouseList",warehouseList);
return "editkcxx";
}
// 先判断数据库有没有,有就更新,没有就新增
@RequestMapping("/insert")
public String insert(Kcxx kcxx,HttpServletRequest request,Model model){
if(null==kcxxServiceImp.getbyid(kcxx.getProid())) {
kcxxServiceImp.insert(kcxx);
}else {
kcxxServiceImp.update(kcxx);
}
return "redirect:getall";
}
// 删除
@RequestMapping("/delete")
public String delete(String proid) {
kcxxServiceImp.delete(proid);
return "redirect:getall";
}
// 修改
@RequestMapping("/update")
public String update(Kcxx kcxx,HttpServletRequest request,Model model){
if(kcxxServiceImp.update(kcxx)) {
kcxx=kcxxServiceImp.getbyid(kcxx.getProid());
model.addAttribute("kcxx", kcxx);
return "redirect:getall";
}
return null;
}
// 查询所有
@RequestMapping("/getall")
public String getall_kcxx(ModelMap model,
@RequestParam(defaultValue="1",required=true,value="pn") Integer pn
) {
PageHelper.startPage(pn, 4);
List<Kcxx> kcxxs= kcxxServiceImp.getall();
PageInfo<Kcxx> pageInfo=new PageInfo<Kcxx>(kcxxs);
model.addAttribute("pageInfo", pageInfo);
return "getall_kcxx";
}
// 查询单个
@RequestMapping("/getbyid")
public String getbyid(String proid,HttpServletRequest request,Model model) {
request.setAttribute("kcxx", kcxxServiceImp.getbyid(proid));
model.addAttribute("kcxx",kcxxServiceImp.getbyid(proid));
return "getall";
}
@RequestMapping("/kcxxWithPro")
public String kcxxWithPro(String proid,HttpServletRequest request,Model model) {
Kcxx kcxx=kcxxServiceImp.kcxxWithPro(proid);
request.setAttribute("kcxx", kcxx);
model.addAttribute("kcxx",kcxx);
return "getkcxx";
}
// 库存预警
@RequestMapping("/kcxxWithPronum")
public String kcxxWithPronum(ModelMap model,
@RequestParam(defaultValue="1",required=true,value="pn") Integer pn
) {
PageHelper.startPage(pn, 4);
List<Kcxx> kcxxs= kcxxServiceImp.kcxxWithPronum();
PageInfo<Kcxx> pageInfo=new PageInfo<Kcxx>(kcxxs);
model.addAttribute("pageInfo", pageInfo);
return "getkcxx_num";
}
// 临期产品
@RequestMapping("/kcxxWithProdata")
public String kcxxWithProdata(ModelMap model,
@RequestParam(defaultValue="1",required=true,value="pn") Integer pn
) {
PageHelper.startPage(pn, 4);
List<Kcxx> kcxxs= kcxxServiceImp.kcxxWithProdata();
PageInfo<Kcxx> pageInfo=new PageInfo<Kcxx>(kcxxs);
model.addAttribute("pageInfo", pageInfo);
return "getkcxx_data";
}
@InitBinder
protected void init(HttpServletRequest request, ServletRequestDataBinder binder) {
SimpleDateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd");
dateFormat.setLenient(false);
binder.registerCustomEditor(Date.class, new CustomDateEditor(dateFormat, false));
}
// 按条件获取所有进货信息
@RequestMapping("getbyparams")
public String getbyparams(HttpServletRequest request,Model model,@RequestParam(value="proid",required=false)String proid,
@RequestParam(value="pname",required=false)String pname,@RequestParam(defaultValue="1",required=true,value="pn") Integer pn
) {
PageHelper.startPage(pn, 100);
List<Kcxx> ckin= kcxxServiceImp.getbyparams(proid,pname);
PageInfo<Kcxx> pageInfo=new PageInfo<Kcxx>(ckin);
model.addAttribute("pageInfo", pageInfo);
return "getkcxxbyparams";
}
@RequestMapping("getkcxx")
@ResponseBody
public Kcxx getkcxx(String proid,HttpServletRequest request,Model model) {
Kcxx kcxx=new Kcxx();
kcxx=kcxxServiceImp.getbyid(proid);
return kcxx;
}
}