jspmysql金院电商创业平台.zip

package com.daowen.controller; import java.text.MessageFormat; import java.util.List; import java.util.HashMap; import java.text.SimpleDateFormat; import java.util.Date; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import com.daowen.util.JsonResult; import com.daowen.vo.LanmuVo; import com.daowen.vo.XinxiVo; 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.*; import com.daowen.service.*; import com.daowen.ssm.simplecrud.SimpleController; import com.daowen.webcontrol.PagerMetal; import org.springframework.web.bind.annotation.ResponseBody; /************************** * * 资讯控制 * */ @Controller public class XinxiController extends SimpleController { @Autowired private XinxiService xinxiSrv = null; @Autowired private LanmuService lanmuSrv = null; @Autowired private AgreerecordService arSrv=null; @Override @RequestMapping("/admin/xinximanager.do") public void mapping(HttpServletRequest request, HttpServletResponse response) { mappingMethod(request, response); } @RequestMapping(value="/admin/xinxi/agree") @ResponseBody public JsonResult agree(HttpServletRequest request, HttpServletResponse response) { String targetid = request.getParameter("targetid"); String commentator = request.getParameter("commentator"); if (targetid == null || commentator == null) { return JsonResult.error(-1, "参数异常"); } Boolean hasExist = arSrv.isExist(MessageFormat.format( " where targetid={0} and typename=''xinxi'' and commentator=''{1}'' ", targetid, commentator)); if (hasExist) { return JsonResult.error(-2, "你已经操作过"); } Xinxi xinxi = xinxiSrv.load("where id=" + targetid); if (xinxi == null) { return JsonResult.error(-3, "数据异常"); } Agreerecord ar = new Agreerecord(); ar.setCommentator(commentator); ar.setTargetid(targetid); ar.setTypename("xinxi"); arSrv.save(ar); xinxi.setAgreecount(xinxi.getAgreecount() + 1); xinxiSrv.update(xinxi); JsonResult jsonResult =JsonResult.success(1,"你赞了他"); HashMap<String,Integer> data= new HashMap<String,Integer>(); data.put("agreecount", xinxi.getAgreecount()); jsonResult.setData(data); return jsonResult; } @RequestMapping(value="/admin/xinxi/against") @ResponseBody public JsonResult against(HttpServletRequest request, HttpServletResponse response) { String targetid = request.getParameter("targetid"); String commentator = request.getParameter("commentator"); if (targetid == null || commentator == null) { return JsonResult.error(-1, "参数异常"); } Boolean hasExist = arSrv.isExist(MessageFormat.format( " where targetid={0} and typename=''xinxi'' and commentator=''{1}'' ", targetid, commentator)); if (hasExist) { return JsonResult.error(-2, "你已经操作过"); } Xinxi xinxi = xinxiSrv.load("where id=" + targetid); if (xinxi == null) { return JsonResult.error(-3, "数据异常"); } Agreerecord ar = new Agreerecord(); ar.setCommentator(commentator); ar.setTargetid(targetid); ar.setTypename("xinxi"); arSrv.save(ar); xinxi.setAgainstcount(xinxi.getAgainstcount()+1); xinxiSrv.update(xinxi); JsonResult<HashMap<String,Integer>> jsonResult = JsonResult.success(1, "你赞了它"); HashMap<String,Integer> data= new HashMap<String,Integer>(); data.put("againstcount", xinxi.getAgainstcount()); jsonResult.setData(data); return jsonResult; } @ResponseBody @PostMapping("/admin/xinxi/clickstat") public JsonResult clickcounttongji(){ String sql=" select lm.name as name,sum(clickcount) as value from xinxi x,lanmu lm where lm.id=x.lmid group by lm.id ,lm.name "; List<HashMap<String,Object>> listXinxi=xinxiSrv.queryToMap(sql); return JsonResult.success(1,"",listXinxi); } @ResponseBody @PostMapping("/admin/xinxi/count") public JsonResult counttongji(){ String sql=" select lm.name as name,count(*) as value from xinxi x,lanmu lm where lm.id=x.lmid group by lm.id ,lm.name "; List<HashMap<String,Object>> listXinxi=xinxiSrv.queryToMap(sql); return JsonResult.success(1,"",listXinxi); } @ResponseBody @PostMapping("/admin/xinxi/mylanmu") public JsonResult list(){ List<LanmuVo> listLanmu=xinxiSrv.getMyLanmus(); return JsonResult.success(1,"获取栏目",listLanmu); } @ResponseBody @PostMapping("/admin/xinxi/hot") public JsonResult hotxinxi(){ HashMap<String,Object> map=new HashMap<>(); map.put("order","order by clickcount desc"); map.put("topcount",10); List<XinxiVo> listXinxi=xinxiSrv.getEntityPlus(map); return JsonResult.success(1,"获取信息",listXinxi); } @ResponseBody @PostMapping("/admin/xinxi/info") public JsonResult info(){ String id=request.getParameter("id"); if(id==null) return JsonResult.error(-1,"参数异常"); XinxiVo xinxi=xinxiSrv.loadPlus(Integer.parseInt(id)); return JsonResult.success(1,"获取信息",xinxi); } @ResponseBody @PostMapping("/admin/xinxi/pagelist") public JsonResult pagelist(){ String lmid=request.getParameter("lmid"); String title = request.getParameter("title"); String pubren= request.getParameter("pubren"); String subtypeid= request.getParameter("subtypeid"); HashMap<String ,Object> map=new HashMap(); if (title != null) map.put("title",title); if(lmid!=null) map.put("lmid",lmid); if(subtypeid!=null) map.put("subtypeid",subtypeid); if(pubren!=null) map.put("pubren",pubren); map.put("order"," order by id desc "); // int pageindex = 1; int pagesize = 10; // 获取当前分页 String currentpageindex = request.getParameter("currentpageindex"); // 当前页面尺寸 String currentpagesize = request.getParameter("pagesize"); // 设置当前页 if (currentpageindex != null) pageindex = new Integer(currentpageindex); // 设置当前页尺寸 if (currentpagesize != null) pagesize = new Integer(currentpagesize); PageHelper.startPage(pageindex,pagesize); List<XinxiVo> listXinxi = xinxiSrv.getEntityPlus(map); request.setAttribute("listXinxi", listXinxi); PageInfo<XinxiVo> pageInfo=new PageInfo<XinxiVo>(listXinxi); return JsonResult.success(1,"获取会员信息",pageInfo); } public void shenpi() { String id = request.getParameter("id"); String forwardurl = request.getParameter("forwardurl"); String status = request.getParameter("state"); String reply = request.getParameter("reply"); String shenpiren = request.getParameter("shenpiren"); int statuscode = 3; // 验证错误url String errorurl = request.getParameter("errorurl"); if (id == null) retu