if(!isEmpty(xm.getTeacherId())){ sql += " and teacherId like '%"+xm.getTeacherId()+"%'"; } if(!isEmpty(xm.getContent())){ sql += " and content like '%"+xm.getContent()+"%'"; } if(!isEmpty(xm.getStatus())){ sql += " and status like '%"+xm.getStatus()+"%'"; } if(!isEmpty(xm.getScore())){ sql += " and score like '%"+xm.getScore()+"%'"; } sql += " ORDER BY ID DESC "; Pager<Xm> pagers = xmService.findBySqlRerturnEntity(sql); model.addAttribute("pagers", pagers); //存储查询条件 model.addAttribute("obj", xm); return"xm/spxm2"; }
@RequestMapping(value = "/spfindBySql3") public String spfindBySql3(Xm xm, Model model, HttpServletRequest request, HttpServletResponse response){ //分页查询 /* 0 一待审 1 一审不通 2 一审通过 3 二待审 4 二审不通 5 二审通过 6 三待审 7 三审不通 8 三审通过 9 积分设置完成结束*/ String sql = "SELECT * FROM xm WHERE status = 6 or status = 8 or status = 9"; if(!isEmpty(xm.getName())){ sql += " and name like '%"+xm.getName()+"%'"; } if(!isEmpty(xm.getTeacherId())){ sql += " and teacherId like '%"+xm.getTeacherId()+"%'"; } if(!isEmpty(xm.getContent())){ sql += " and content like '%"+xm.getContent()+"%'"; } if(!isEmpty(xm.getStatus())){ sql += " and status like '%"+xm.getStatus()+"%'"; } if(!isEmpty(xm.getScore())){ sql += " and score like '%"+xm.getScore()+"%'"; } sql += " ORDER BY ID DESC "; Pager<Xm> pagers = xmService.findBySqlRerturnEntity(sql); model.addAttribute("pagers", pagers); //存储查询条件 model.addAttribute("obj", xm); return"xm/spxm3"; }
if(!isEmpty(xm.getName())){ sql += " and name like '%"+xm.getName()+"%'"; } if(!isEmpty(xm.getTeacherId())){ sql += " and teacherId like '%"+xm.getTeacherId()+"%'"; } if(!isEmpty(xm.getContent())){ sql += " and content like '%"+xm.getContent()+"%'"; } if(!isEmpty(xm.getStatus())){ sql += " and status like '%"+xm.getStatus()+"%'"; } if(!isEmpty(xm.getScore())){ sql += " and score like '%"+xm.getScore()+"%'"; } sql += " ORDER BY ID DESC "; Pager<Xm> pagers = xmService.findBySqlRerturnEntity(sql); model.addAttribute("pagers", pagers); //存储查询条件 model.addAttribute("obj", xm); return"xm/xm1"; }
@RequestMapping(value = "/findBySql2") public String findBySql2(Xm xm, Model model, HttpServletRequest request, HttpServletResponse response){
Object attribute = request.getSession().getAttribute("userId"); if (attribute == null){ return"redirect:/login/mtuichu"; } Integer userId = Integer.valueOf(attribute.toString()); /* -1 新建 * 0 一待审 1 一审不通 2 一审通过 3 二待审 4 二审不通 5 二审通过 6 三待审 7 三审不通 8 三审通过 9 积分设置完成结束*/ //分页查询 String sql = "SELECT * FROM xm WHERE 1=1 and (status = 2 or status =3 or status = 4) and teacherId = "+ userId; if(!isEmpty(xm.getName())){ sql += " and name like '%"+xm.getName()+"%'"; } if(!isEmpty(xm.getTeacherId())){ sql += " and teacherId like '%"+xm.getTeacherId()+"%'"; } if(!isEmpty(xm.getContent())){ sql += " and content like '%"+xm.getContent()+"%'"; }