(基于ssm的Java毕业设计)图书馆书库管理系统(源码)

package com.daowen.controller; import java.io.IOException; import java.math.BigDecimal; import java.text.DecimalFormat; import java.text.ParseException; import java.text.SimpleDateFormat; import java.util.Date; import java.util.HashMap; import java.util.List; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import com.alibaba.fastjson.JSONObject; import com.daowen.entity.Lanmu; import com.daowen.service.*; import com.daowen.util.JsonResult; import com.daowen.vo.LanmuVo; import com.daowen.vo.ShangpinVo; import com.github.pagehelper.PageHelper; import com.github.pagehelper.PageInfo; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Controller; import org.springframework.web.bind.annotation.GetMapping; import org.springframework.web.bind.annotation.PostMapping; import org.springframework.web.bind.annotation.RequestMapping; import com.daowen.entity.Shangpin; import com.daowen.ssm.simplecrud.SimpleController; import com.daowen.util.SequenceUtil; import com.daowen.webcontrol.PagerMetal; import org.springframework.web.bind.annotation.ResponseBody; @Controller public class ShangpinController extends SimpleController { @Override @RequestMapping("/admin/shangpinmanager.do") public void mapping(HttpServletRequest request, HttpServletResponse response) { mappingMethod(request, response); } @ResponseBody @PostMapping("/admin/shangpin/mylanmu") public JsonResult list(){ List<LanmuVo> listLanmu=shangpinSrv.getMyLanmus(); return JsonResult.success(1,"获取栏目",listLanmu); } @ResponseBody @PostMapping("/admin/shangpin/count") public JsonResult counttongji(){ String sql=" select lm.name ,count(*) as value from shangpin sp,lanmu lm where lm.id=sp.typeid "; String pubren=request.getParameter("pubren"); if(pubren!=null) sql+=" and sp.pubren="+pubren; sql+=" group by sp.typeid,lm.name "; List<HashMap<String,Object>> listTongji=shangpinSrv.queryToMap(sql); return JsonResult.success(1,"",listTongji); } @ResponseBody @PostMapping("/admin/shangpin/saledstat") public JsonResult saleStat(){ String sql=" select sp.name as name,sum(count) as value from shangpin sp,orderitem oi where sp.id=oi.spid "; String pubren=request.getParameter("pubren"); if(pubren!=null) sql+=" and sp.pubren="+pubren; sql+=" group by sp.id,sp.name "; List<HashMap<String,Object>> listTongji=shangpinSrv.queryToMap(sql); return JsonResult.success(1,"",listTongji); } @ResponseBody @PostMapping("/admin/shangpin/hotsales") public JsonResult hotSales(){ String sql=" select sp.*,t.saledcount from shangpin sp inner join (select oi.spid,sum(oi.count) as saledcount from border o ,boitem oi where o.id=oi.orderid and o.state!=1 group by oi.spid) t on t.spid=sp.id order by saledcount desc limit 10 "; List<HashMap<String,Object>> listMap=shangpinSrv.queryToMap(sql); return JsonResult.success(1,"热销产品",listMap); } @ResponseBody @GetMapping("/admin/shangpin/type") public JsonResult getTypes(){ List<Lanmu> listLanmu=lanmuSrv.getEntity("where type=2"); return JsonResult.success(1,"获取 书籍类别",listLanmu); } @RequestMapping("/admin/shangpin/info") @ResponseBody public JsonResult info() { String id = request.getParameter("id"); ShangpinVo shangpin = null; if (id == null) { return JsonResult.error(-1, "参数异常"); } shangpin = shangpinSrv.loadPlus(Integer.parseInt(id)); return JsonResult.success(1, "获取 书籍信息", shangpin); } public void shenpi() { String id = request.getParameter("id"); String forwardurl = request.getParameter("forwardurl"); String spstate = request.getParameter("spstate"); String reply = request.getParameter("reply"); String shenpiren = request.getParameter("shenpiren"); int statuscode = 3; // 验证错误url String errorurl = request.getParameter("errorurl"); if (id == null) return; Shangpin shangpin = shangpinSrv.load(" where id=" + id); if (shangpin == null) return; if (spstate != null) statuscode = Integer.parseInt(spstate); shangpin.setSpstate(statuscode); shangpinSrv.update(shangpin); if (forwardurl == null) { forwardurl = "/admin/shangpinmanager.do?actiontype=get"; } redirect(forwardurl); } @ResponseBody @PostMapping("/admin/shangpin/shangjia") public JsonResult shangjia() { String[] ids = request.getParameterValues("ids"); if (ids == null) return JsonResult.error(-1,"参数异常"); String spliter = ","; String sql = " update shangpin set state=1 where id in(" + join(spliter, ids) + ")"; int count=shangpinSrv.executeUpdate(sql); JSONObject jsonObject=new JSONObject(); jsonObject.put("count",count); return JsonResult.success(1,"上架成功",jsonObject); } @ResponseBody @PostMapping("/admin/shangpin/xiajia") public JsonResult xiajia() { String[] ids = request.getParameterValues("ids"); if (ids == null) return JsonResult.error(-1,"参数异常"); String spliter = ","; String sql = " update shangpin set state=2 where id in(" + join(spliter, ids) + ")"; int count=shangpinSrv.executeUpdate(sql); JSONObject jsonObject=new JSONObject(); jsonObject.put("count",count); return JsonResult.success(1,"下架成功",jsonObject); } private void bindcoupon(){ String forwardurl = request.getParameter("forwardurl"); String id = request.getParameter("id"); String couponid=request.getParameter("couponid"); if (id == null) return; Shangpin shangpin = shangpinSrv.load("where id="+id); if (shangpin == null) return; if(couponid!=null) { shangpin.setCouponid(Integer.parseInt(couponid)); shangpinSrv.update(shangpin); } if (forwardurl == null) { forwardurl = "/admin/shangpinmanager.do?actiontype=get"; } redirect(forwardurl); } public void kucunadd() { String forwardurl = request.getParameter("forwardurl"); String id = request.getParameter("id"); String supplor = request.getParameter("supplor"); String cgdate = request.getParameter("cgdate"); String cgren = request.getParameter("cgren"); if (id == null) return; Shangpin shangpin = shangpinSrv.load(new Integer(id)); if (shangpin == null) return; String shuliang = request.getParameter("shuliang"); String danwei = request.getParameter("danwei"); if (shuliang != null) { shangpin.setKucun(shangpin.getKucun() + Integer.parseInt(shuliang)); shangpin.setDanwei(danwei); shangpinSrv.update(shangpin); } if (forwardurl == null) { forwardurl = "/admin/shangpinmanager.do?actiontype=get"; } redirect(forwardurl); } @ResponseBody @PostMapping("/admin/shangpin/delete") public JsonResult delete() { String[] ids = request.getParameterValues("ids"); if (ids == null) return JsonResult.error(-1,"参数异常"); String spliter = ","; String sql = " where id in(" + join(spliter, ids)+ ")"; int count=shangpinSrv.delete(sql); JSONObject jsonObject=new JSONObject(); jsonObject.put("count",count); return JsonResult.success(1,"删除成功",jsonObject); } public void save() { String forwardurl = request.getParameter("forwardurl"); String name = request.getParameter("name"); String jiage = request.getParameter("jiage"); String tuijian = request.getParameter("tuijian"); String typeid = request.getParameter("typeid"); String subtypeid = request.getParameter("subtypeid"); String tupian = request.getParameter("tupian"); String jieshao = request.getParameter("jieshao"); String pubren = request.getParameter("pubren"); String subtitle = request.getParameter("subtitle"); String discount = request.getParameter("discount"); String chandi = request.getParameter("chandi"); String tagid = req