基于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.daowen.vo.SpcommentVo; 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); } /** * 浏览排行榜 * @return */ @ResponseBody @PostMapping("/admin/shangpin/hotclick") public JsonResult hotclick(){ HashMap map=new HashMap(); map.put("order","order by clickcount desc"); map.put("topcount",5); List<ShangpinVo> listShangpin=shangpinSrv.find(map); return JsonResult.success(1,"热销产品",listShangpin); } @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 shorder o ,orderitem 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"); String hyid=request.getParameter("hyid"); ShangpinVo shangpin = null; if (id == null) { return JsonResult.error(-1, "参数异常"); } shangpin = shangpinSrv.loadPlus(Integer.parseInt(id)); if(hyid!=null){ shangpinSrv.executeUpdate("update shangpin set clickcount=clickcount+1 where id="+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); } 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/comment/list") public JsonResult spcomment(){ String id=request.getParameter("id"); String hyid=request.getParameter("hyid"); HashMap map=new HashMap(); if(id==null) map.put("id",id); if(hyid!=null) map.put("hyid",hyid); List<SpcommentVo> listMap=shangpinSrv.getComment(map); return JsonResult.success(1,"获取评论信息",listMap); } @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"); St