Java项目:学生课堂考勤管理系统(java+SSM+JSP+layui+Mysql)

package com.kwxy.hyt.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.kwxy.hyt.base.BaseController; import com.kwxy.hyt.po.*; import com.kwxy.hyt.utils.Pager; import java.util.*; import com.kwxy.hyt.po.*; import com.kwxy.hyt.mapper.*; import com.kwxy.hyt.service.*; /** * @ClassName: * @Description: * @author - - admin * @date - 2018年10月27日 09时48分24秒 */ @Controller @RequestMapping("/teacherBj") public class TeacherBjController extends BaseController { /** * 依赖注入 start dao/service/=== */ @Autowired private TeacherBjService teacherBjService; // --------------------------------------- 华丽分割线 ------------------------------ /*********************************查询列表【不分页】***********************************************/ /** * 【不分页 => 查询列表 => 无条件】 * @Title: listAll * @Description: TODO(这里用一句话描述这个方法的作用) * @param @return 设定文件 * @author * @return String 返回类型 * @throws */ @RequestMapping(value = "/listAll") public String listAll(TeacherBj teacherBj, Model model, HttpServletRequest request, HttpServletResponse response){ List<TeacherBj> listAll = teacherBjService.listAll(); model.addAttribute("list", listAll); return "teacherBj/teacherBj"; } /** * 【不分页=》查询列表=>有条件】 * @Title: listByEntity * @Description: TODO(这里用一句话描述这个方法的作用) * @param @return 设定文件 * @author * @return String 返回类型 * @throws */ @RequestMapping(value = "/listByEntity") public String listByEntity(TeacherBj teacherBj, Model model, HttpServletRequest request, HttpServletResponse response){ List<TeacherBj> listAll = teacherBjService.listAllByEntity(teacherBj); model.addAttribute("list", listAll); return "teacherBj/teacherBj"; } /** * 【不分页=》查询列表=>有条件】 * @Title: listByMap * @Description: TODO(这里用一句话描述这个方法的作用) * @param @return 设定文件 * @author * @return String 返回类型 * @throws */ @RequestMapping(value = "/listByMap") public String listByMap(TeacherBj teacherBj, Model model, HttpServletRequest request, HttpServletResponse response){ //通过map查询 Map<String,Object> params = new HashMap<String,Object>(); if(!isEmpty(teacherBj.getTeacherId())){ params.put("teacherId", teacherBj.getTeacherId()); } if(!isEmpty(teacherBj.getBjId())){ params.put("bjId", teacherBj.getBjId()); } List<TeacherBj> listAll = teacherBjService.listByMap(params); model.addAttribute("list", listAll); return "teacherBj/teacherBj"; } /*********************************查询列表【分页】***********************************************/ /** * 分页查询 返回list对象(通过对象) * * @param request * @param response * @return */ @RequestMapping(value = "/findByObj") public String findByObj(TeacherBj teacherBj, Model model, HttpServletRequest request, HttpServletResponse response) { //分页查询 Pager<TeacherBj> pagers = teacherBjService.findByEntity(teacherBj); model.addAttribute("pagers", pagers); //存储查询条件 model.addAttribute("obj", teacherBj); return "teacherBj/teacherBj"; } /** * 分页查询 返回list对象(通过对By Sql) * * @param request * @param response * @return */ @RequestMapping(value = "/findBySql") public String findBySql(TeacherBj teacherBj, Model model, HttpServletRequest request, HttpServletResponse response) { //分页查询 String sql = "SELECT * FROM teacherBj WHERE 1=1 "; if(!isEmpty(teacherBj.getTeacherId())){ sql += " and teacherId like '%"+teacherBj.getTeacherId()+"%'"; } if(!isEmpty(teacherBj.getBjId())){ sql += " and bjId like '%"+teacherBj.getBjId()+"%'"; } sql += " ORDER BY ID DESC "; Pager<TeacherBj> pagers = teacherBjService.findBySqlRerturnEntity(sql); model.addAttribute("pagers", pagers); //存储查询条件 model.addAttribute("obj", teacherBj); return "teacherBj/teacherBj"; } /** * 分页查询 返回list对象(通过Map) * * @param request * @param response * @return */ @RequestMapping(value = "/findByMap") public String findByMap(TeacherBj teacherBj, Model model, HttpServletRequest request, HttpServletResponse response) { //通过map查询 Map<String,Object> params = new HashMap<String,Object>(); if(!isEmpty(teacherBj.getTeacherId())){ params.put("teacherId", teacherBj.getTeacherId()); } if(!isEmpty(teacherBj.getBjId())){ params.put("bjId", teacherBj.getBjId()); } //分页查询 Pager<TeacherBj> pagers = teacherBjService.findByMap(params); model.addAttribute("pagers", pagers); //存储查询条件 model.addAttribute("obj", teacherBj); return "teacherBj/teacherBj"; } /**********************************【增删改】******************************************************/ /** * 跳至添加页面 * @return */ @RequestMapping(value = "/add") public String add() { return "teacherBj/add"; } /** * 跳至详情页面 * @return */ @RequestMapping(value = "/view") public String view(Integer id,Model model) { TeacherBj obj = teacherBjService.load(id); model.addAttribute("obj",obj); return "teacherBj/view"; } /** * 添加执行 * @return */ @RequestMapping(value = "/exAdd") public String exAdd(TeacherBj teacherBj, Model model, HttpServletRequest request, HttpServletResponse response) { teacherBjService.insert(teacherBj); return "redirect:/teacherBj/findBySql.action"; } /** * 跳至修改页面 * @return */ @RequestMapping(value = "/update") public String update(Integer id,Model model) { TeacherBj obj = teacherBjService.load(id); model.addAttribute("obj",obj); return "teacherBj/update"; } /** * 添加修改 * @return */ @RequestMapping(value = "/exUpdate") public String exUpdate(TeacherBj teacherBj, Model model, HttpServletRequest request, HttpServletResponse response) { //1.通过实体类修改，可以多传修改条件 teacherBjService.updateById(teacherBj); //2.通过主键id修改 //teacherBjService.updateById(teacherBj); return "redirect:/teacherBj/findBySql.action"; } /** * 删除通过主键 * @return */ @RequestMapping(value = "/delete") public String delete(Integer id, Model model, HttpServletRequest request, HttpServletResponse response) { ///1.通过主键删除 teacherBjService.deleteById(id); /*以下是多种删除方式*/ // //2.通过实体条件删除 // teacherBjService.deleteByEntity(teacherBj); // //3.通过参数删除 // //通过map查询 // Map<String,Object> params = new HashMap<String,Object>(); // // if(!isEmpty(teacherBj.getTeacherId())){ // params.put("teacherId", teacherBj.getTeacherId()); // } // // if(!isEmpty(teacherBj.getBjId()))