基于ssm+mysql的在线收银系统源码数据库文档.zip

package com.controller; import java.io.File; import java.io.IOException; import java.sql.Timestamp; import java.util.ArrayList; import java.util.HashMap; import java.util.List; import java.util.Map; import java.io.PrintWriter; import javax.annotation.Resource; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import javax.servlet.http.HttpSession; import org.springframework.stereotype.Controller; import org.springframework.ui.ModelMap; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RequestParam; import org.springframework.web.multipart.MultipartFile; import com.entity.Xiaoshoujilu; import com.server.XiaoshoujiluServer; import com.util.PageBean; import net.sf.json.JSONObject; import com.util.db; import java.sql.SQLException; import java.sql.*; @Controller public class XiaoshoujiluController { @Resource private XiaoshoujiluServer xiaoshoujiluService; @RequestMapping("addXiaoshoujilu.do") public String addXiaoshoujilu(HttpServletRequest request,Xiaoshoujilu xiaoshoujilu,HttpSession session) throws SQLException{ Timestamp time=new Timestamp(System.currentTimeMillis()); xiaoshoujilu.setAddtime(time.toString().substring(0, 19)); xiaoshoujiluService.add(xiaoshoujilu); db dbo = new db(); dbo.hsgexecute("update shangpinxinxi set kucun=kucun-"+xiaoshoujilu.getXiaoshoushuliang()+" where shangpinbianhao='"+xiaoshoujilu.getShangpinbianhao()+"'"); //kuabiaogaizhi session.setAttribute("backxx", "添加成功"); session.setAttribute("backurl", request.getHeader("Referer")); //session.setAttribute("backurl", "xiaoshoujiluList.do"); return "redirect:postback.jsp"; //return "redirect:xiaoshoujiluList.do"; } // 处理编辑 @RequestMapping("doUpdateXiaoshoujilu.do") public String doUpdateXiaoshoujilu(int id,ModelMap map,Xiaoshoujilu xiaoshoujilu){ xiaoshoujilu=xiaoshoujiluService.getById(id); map.put("xiaoshoujilu", xiaoshoujilu); return "xiaoshoujilu_updt"; } // 后台详细 @RequestMapping("xiaoshoujiluDetail.do") public String xiaoshoujiluDetail(int id,ModelMap map,Xiaoshoujilu xiaoshoujilu){ xiaoshoujilu=xiaoshoujiluService.getById(id); map.put("xiaoshoujilu", xiaoshoujilu); return "xiaoshoujilu_detail"; } // 前台详细 @RequestMapping("xsjlDetail.do") public String xsjlDetail(int id,ModelMap map,Xiaoshoujilu xiaoshoujilu){ xiaoshoujilu=xiaoshoujiluService.getById(id); map.put("xiaoshoujilu", xiaoshoujilu); return "xiaoshoujiludetail"; } // @RequestMapping("updateXiaoshoujilu.do") public String updateXiaoshoujilu(int id,ModelMap map,Xiaoshoujilu xiaoshoujilu,HttpServletRequest request,HttpSession session){ xiaoshoujiluService.update(xiaoshoujilu); session.setAttribute("backxx", "修改成功"); session.setAttribute("backurl", request.getHeader("Referer")); return "redirect:postback.jsp"; //String url = request.getHeader("Referer"); //return "redirect:"+url; //return "redirect:xiaoshoujiluList.do"; } // 分页查询 @RequestMapping("xiaoshoujiluList.do") public String xiaoshoujiluList(@RequestParam(value="page",required=false)String page, ModelMap map,HttpSession session,Xiaoshoujilu xiaoshoujilu, String shangpinbianhao, String shangpinmingcheng, String shangpinleibie, String shangpinjiage, String kucun, String xiaoshoushuliang1,String xiaoshoushuliang2, String zongjine, String yonghuming, String xingming, String lianxidianhua, String caozuoyuan){ if(page==null||page.equals("")){ page="1"; } PageBean pageBean=new PageBean(Integer.parseInt(page), 15); Map<String, Object> pmap=new HashMap<String,Object>(); pmap.put("pageno", pageBean.getStart()); pmap.put("pageSize", 15); if(shangpinbianhao==null||shangpinbianhao.equals("")){pmap.put("shangpinbianhao", null);}else{pmap.put("shangpinbianhao", shangpinbianhao);} if(shangpinmingcheng==null||shangpinmingcheng.equals("")){pmap.put("shangpinmingcheng", null);}else{pmap.put("shangpinmingcheng", shangpinmingcheng);} if(shangpinleibie==null||shangpinleibie.equals("")){pmap.put("shangpinleibie", null);}else{pmap.put("shangpinleibie", shangpinleibie);} if(shangpinjiage==null||shangpinjiage.equals("")){pmap.put("shangpinjiage", null);}else{pmap.put("shangpinjiage", shangpinjiage);} if(kucun==null||kucun.equals("")){pmap.put("kucun", null);}else{pmap.put("kucun", kucun);} if(xiaoshoushuliang1==null||xiaoshoushuliang1.equals("")){pmap.put("xiaoshoushuliang1", null);}else{pmap.put("xiaoshoushuliang1", xiaoshoushuliang1);} if(xiaoshoushuliang2==null||xiaoshoushuliang2.equals("")){pmap.put("xiaoshoushuliang2", null);}else{pmap.put("xiaoshoushuliang2", xiaoshoushuliang2);} if(zongjine==null||zongjine.equals("")){pmap.put("zongjine", null);}else{pmap.put("zongjine", zongjine);} if(yonghuming==null||yonghuming.equals("")){pmap.put("yonghuming", null);}else{pmap.put("yonghuming", yonghuming);} if(xingming==null||xingming.equals("")){pmap.put("xingming", null);}else{pmap.put("xingming", xingming);} if(lianxidianhua==null||lianxidianhua.equals("")){pmap.put("lianxidianhua", null);}else{pmap.put("lianxidianhua", lianxidianhua);} if(caozuoyuan==null||caozuoyuan.equals("")){pmap.put("caozuoyuan", null);}else{pmap.put("caozuoyuan", caozuoyuan);} int total=xiaoshoujiluService.getCount(pmap); pageBean.setTotal(total); List<Xiaoshoujilu> list=xiaoshoujiluService.getByPage(pmap); map.put("page", pageBean); map.put("list", list); session.setAttribute("p", 1); return "xiaoshoujilu_list"; } @RequestMapping("xiaoshoujilu_yanben1.do") public String xiaoshoujilu_yanben1(@RequestParam(value="page",required=false)String page, ModelMap map,HttpSession session,Xiaoshoujilu xiaoshoujilu, String shangpinbianhao, String shangpinmingcheng, String shangpinleibie, String shangpinjiage, String kucun, String xiaoshoushuliang1,String xiaoshoushuliang2, String zongjine, String yonghuming, String xingming, String lianxidianhua, String caozuoyuan){ if(page==null||page.equals("")){ page="1"; } PageBean pageBean=new PageBean(Integer.parseInt(page), 15); Map<String, Object> pmap=new HashMap<String,Object>(); pmap.put("pageno", pageBean.getStart()); pmap.put("pageSize", 15); if(shangpinbianhao==null||shangpinbianhao.equals("")){pmap.put("shangpinbianhao", null);}else{pmap.put("shangpinbianhao", shangpinbianhao);} if(shangpinmingcheng==null||shangpinmingcheng.equals("")){pmap.put("shangpinmingcheng", null);}else{pmap.put("shangpinmingcheng", shangpinmingcheng);} if(shangpinleibie==null||shangpinleibie.equals("")){pmap.put("shangpinleibie", null);}else{pmap.put("shangpinleibie", shangpinleibie);} if(shangpinjiage==null||shangpinjiage.equals("")){pmap.put("shangpinjiage", null);}else{pmap.put("shangpinjiage", shangpinjiage);} if(kucun==null||kucun.equals("")){pmap.put("kucun", null);}else{pmap.put("kucun", kucun);} if(xiaoshoushuliang1==null||xiaoshoushuliang1.equals("")){pmap.put("xiaoshoushuliang1", null);}else{pmap.put("xiaoshoushuliang1", xiaoshoushuliang1);} if(xiaoshoushuliang2==null||xiaoshoushuliang2.equals("")){pmap.put("xiaoshoushuliang2", null);}else{pmap.put("xiaoshoushuliang2", xiaoshoushuliang2);} if(zongjine==null||zongjine.equals("")){pmap.put("zongjine", null);}else{pmap.put("zongjine", zongjine);} if(yonghuming==null||yonghuming.equals("")){pmap.put("yonghuming", null);}else{pmap.put("yonghuming", yonghuming);} if(xingming==null||xingming.equals("")){pmap.put("xingming", null);}else{pmap.put("xingming", xingming);} if(lianxidianhua==null||lianxidianhua.equals("")){pmap.put("lianxidianhua", null);}else{pmap.put("lianxidianhua", lianxidianhua);} if(caozuoyuan==null||caozuoyuan.equals("")){pmap.put("caozuoyuan", null);}else{pmap.put("caozuoyuan", caozuoyuan);} int total=xiaoshoujiluService