Java项目:教师师资管理系统(java+SSM+JSP+bootstrap+Mysql)

package com.kewen.teacher.controller; import java.io.File; import java.util.Date; import java.util.HashMap; import java.util.List; import java.util.Map; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Controller; import org.springframework.ui.Model; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RequestMethod; import org.springframework.web.bind.annotation.RequestParam; import org.springframework.web.bind.annotation.ResponseBody; import org.springframework.web.multipart.MultipartFile; import org.springframework.web.multipart.commons.CommonsMultipartFile; import com.alibaba.fastjson.JSONObject; import com.kewen.teacher.base.BaseController; import com.kewen.teacher.po.*; import com.kewen.teacher.utils.Pager; import java.util.*; import com.kewen.teacher.po.*; import com.kewen.teacher.mapper.*; import com.kewen.teacher.service.*; /** * @ClassName: * @Description: * @author - - admin * @date - 2018年10月23日 19时51分28秒 */ @Controller @RequestMapping("/xm") public class XmController extends BaseController { /** * 依赖注入 start dao/service/=== */ @Autowired private XmService xmService; // --------------------------------------- 华丽分割线 ------------------------------ /*********************************查询列表【不分页】***********************************************/ /** * 【不分页 => 查询列表 => 无条件】 * @Title: listAll * @Description: TODO(这里用一句话描述这个方法的作用) * @param @return 设定文件 * @author * @return String 返回类型 * @throws */ @RequestMapping(value = "/listAll") public String listAll(Xm xm, Model model, HttpServletRequest request, HttpServletResponse response){ List<Xm> listAll = xmService.listAll(); model.addAttribute("list", listAll); return "xm/xm"; } /** * 【不分页=》查询列表=>有条件】 * @Title: listByEntity * @Description: TODO(这里用一句话描述这个方法的作用) * @param @return 设定文件 * @author * @return String 返回类型 * @throws */ @RequestMapping(value = "/listByEntity") public String listByEntity(Xm xm, Model model, HttpServletRequest request, HttpServletResponse response){ List<Xm> listAll = xmService.listAllByEntity(xm); model.addAttribute("list", listAll); return "xm/xm"; } /** * 【不分页=》查询列表=>有条件】 * @Title: listByMap * @Description: TODO(这里用一句话描述这个方法的作用) * @param @return 设定文件 * @author * @return String 返回类型 * @throws */ @RequestMapping(value = "/listByMap") public String listByMap(Xm xm, Model model, HttpServletRequest request, HttpServletResponse response){ //通过map查询 Map<String,Object> params = new HashMap<String,Object>(); if(!isEmpty(xm.getName())){ params.put("name", xm.getName()); } if(!isEmpty(xm.getTeacherId())){ params.put("teacherId", xm.getTeacherId()); } if(!isEmpty(xm.getContent())){ params.put("content", xm.getContent()); } if(!isEmpty(xm.getStatus())){ params.put("status", xm.getStatus()); } if(!isEmpty(xm.getScore())){ params.put("score", xm.getScore()); } List<Xm> listAll = xmService.listByMap(params); model.addAttribute("list", listAll); return "xm/xm"; } /*********************************查询列表【分页】***********************************************/ /** * 分页查询 返回list对象(通过对象) * * @param request * @param response * @return */ @RequestMapping(value = "/findByObj") public String findByObj(Xm xm, Model model, HttpServletRequest request, HttpServletResponse response) { //分页查询 Pager<Xm> pagers = xmService.findByEntity(xm); model.addAttribute("pagers", pagers); //存储查询条件 model.addAttribute("obj", xm); return "xm/xm"; } /** * 分页查询 返回list对象(通过对By Sql) * * @param request * @param response * @return */ @RequestMapping(value = "/spfindBySql1") public String findBySql(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 = 0"; 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/spxm1"; } @RequestMapping(value = "/spfindBySql2") public String spfindBySql2(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 = 3"; 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/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"; } @RequestMapping(value = "/sp1") public String sp1(Xm xm,Integer isTy, Model model, HttpServletRequest request, HttpSer