Java项目实战-疾病科普知识网站的Java毕业设计(源码+演示视频+数据库).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/list") public JsonResult list(){ HashMap<String,Object> map=new HashMap<>(); String userid=request.getParameter("userid"); map.put("userid",userid); List<XinxiVo> listXinxi=xinxiSrv.getEntityPlus(map); return JsonResult.success(1,"获取信息",listXinxi); } @ResponseBody @PostMapping("/admin/xinxi/mylanmu") public JsonResult mylanmu(){ 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); } 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) return; Xinxi xinxi = xinxiSrv.load(" where id=" + id); if (xinxi == null) return; if (status != null) statuscode = Integer.parseInt(status); xinxi.setState(statuscode); xinxiSrv.update(xinxi); if (forwardurl == null) { forwardurl = "/admin/xinximanager.do?actiontype=get"; } redirect(forwardurl); } @ResponseBody @GetMapping("/admin/xinxi/related") public JsonResult related(){ String id=request.getParameter("id"); if(id==null||id.equals("")) return JsonResult.error(-1,"参数异常"); List<Xinxi> relateds = xinxiSrv.getRelated(Integer.parseInt(id)); return JsonResult.success(1,"",relateds); } /******************************************************** ******************信息注销监听支持***************************** *********************************************************/ public void delete() { String[] ids = request.getParameterValues("ids"); if (ids == null) return; String spliter = ","; String SQL = "