Java项目:校园考勤管理系统(java+SSM+JSP+CSS+JS+JQUERY+Layui+Mysql)

 源码获取：俺的博客首页 "资源" 里下载！

项目介绍

基于SSM的校园考勤平台

角色：管理员、学生、教师

管理员：首页、个人中心学生管理、教师管理、学校公告管理、班级管理、考勤打卡管理、请假管理、课程名称管理、课表信息管理、学校论坛、系统管理

学生：首页、个人中心、考勤打卡管理、请假管理、学校论坛

教师：首页、个人中心、请假管理、课程名称管理、课表信息管理、学校论坛、系统管理

环境需要

1.运行环境：最好是java jdk 1.8，我们在这个平台上运行的。其他版本理论上也可以。
2.IDE环境：IDEA，Eclipse,Myeclipse都可以。推荐IDEA;
3.tomcat环境：Tomcat 7.x,8.x,9.x版本均可
4.硬件环境：windows 7/8/10 1G内存以上；或者 Mac OS；
5.是否Maven项目: 是；查看源码目录中是否包含pom.xml；若包含，则为maven项目，否则为非maven项目 
6.数据库：MySql 5.7/8.0等版本均可；

技术栈

后端：SSM(Spring+SpringMVC+Mybatis)

前端：JSP+CSS+JS+JQUERY+Layui

使用说明

1. 使用Navicat或者其它工具，在mysql中创建对应名称的数据库，并导入项目的sql文件；
2. 使用IDEA/Eclipse/MyEclipse导入项目，修改配置，运行项目；
3. 将项目中db.xml配置文件中的数据库配置改为自己的配置，然后运行；

 

 

学生管理控制层： 

@Controller
@RequestMapping("/student")
public class StudentController extends BaseController {
	
	@Autowired
	private BjService bjService;
	/**
	 * 依赖注入 start dao/service/===
	 */
	@Autowired
	private StudentService studentService;
	
	@Autowired
	private FdyService fdyService;
	
	@Autowired
	private RecordService recordService;
	
	// --------------------------------------- 华丽分割线 ------------------------------
	
	
	/**
	 * 分页查询 返回list对象(通过对By Sql)
	 * 
	 * @param request
	 * @param response
	 * @return
	 */
	@RequestMapping(value = "/findBySql")
	public String findBySql(Student student, Model model, HttpServletRequest request, HttpServletResponse response) {
		
		Object attribute = request.getSession().getAttribute("userId");
		
		if (attribute == null){
			return "redirect:/login/uLogin";	
		}
		Integer userId = Integer.valueOf(attribute.toString());
		Fdy byId = fdyService.getById(userId);
		if (byId== null || byId.getBjId() == null){
			return "redirect:/login/message?type=1";
		}
		//分页查询
		String sql = "SELECT * FROM student WHERE isDelete = 0 and  bjId = "+ byId.getBjId();
        if(!isEmpty(student.getCode())){
        	sql += " and code like '%"+student.getCode()+"%'";
		}
        if(!isEmpty(student.getUsername())){
        	sql += " and username like '%"+student.getUsername()+"%'";
		}
        if(!isEmpty(student.getPassword())){
        	sql += " and password like '%"+student.getPassword()+"%'";
		}
        if(!isEmpty(student.getBjId())){
        	sql += " and bjId like '%"+student.getBjId()+"%'";
		}
        if(!isEmpty(student.getIsDelete())){
        	sql += " and isDelete like '%"+student.getIsDelete()+"%'";
		}
        sql += " ORDER BY ID DESC ";
		Pager<Student> pagers = studentService.findBySqlRerturnEntity(sql);
		model.addAttribute("pagers", pagers);
		//存储查询条件
		model.addAttribute("obj", student);
		return "student/student";
	}
	
	@RequestMapping(value = "/pass")
	public String pass(Integer id,HttpServletRequest request,Model model) {
       Object attribute = request.getSession().getAttribute("userId");
		
		if (attribute == null){
			return "redirect:/login/uLogin";	
		}
		Integer userId = Integer.valueOf(attribute.toString());
		Student obj = studentService.load(userId);
		model.addAttribute("obj",obj);
		return "student/pass";
	}
	
	
	@RequestMapping("/upass")
	@ResponseBody
	public String upass(HttpServletRequest request,String password){
      Object attribute = request.getSession().getAttribute("userId");
      JSONObject j = new  JSONObject();
	   	if (attribute == null){
	   		j.put("res", 0);
	   		return j.toString();
		}
			Integer userId = Integer.valueOf(attribute.toString());
			Student byId = studentService.getById(userId);
			byId.setPassword(password);
			studentService.updateById(byId);
			j.put("res", 1);
			return j.toString();
			
	}
	
	/**
	 * 分页查询 返回list对象(通过Map)
	 * 
	 * @param request
	 * @param response
	 * @return
	 */
	@RequestMapping(value = "/findByMap")
	public String findByMap(Student student, Model model, HttpServletRequest request, HttpServletResponse response) {
		//通过map查询
		Map<String,Object> params = new HashMap<String,Object>();
        if(!isEmpty(student.getCode())){
        	params.put("code", student.getCode());
		}
        if(!isEmpty(student.getUsername())){
        	params.put("username", student.getUsername());
		}
        if(!isEmpty(student.getPassword())){
        	params.put("password", student.getPassword());
		}
        if(!isEmpty(student.getBjId())){
        	params.put("bjId", student.getBjId());
		}
        if(!isEmpty(student.getIsDelete())){
        	params.put("isDelete", student.getIsDelete());
		}
		//分页查询
		Pager<Student> pagers = studentService.findByMap(params);
		model.addAttribute("pagers", pagers);
		//存储查询条件
		model.addAttribute("obj", student);
		return "student/student";
	}
	
	/**********************************【增删改】******************************************************/
	
	/**
	 * 跳至添加页面
	 * @return
	 */
	@RequestMapping(value = "/add")
	public String add() {
		return "student/add";
	}

	/**
	 * 跳至详情页面
	 * @return
	 */
	@RequestMapping(value = "/view")
	public String view(Integer id,Model model) {
		Student obj = studentService.load(id);
		model.addAttribute("obj",obj);
		return "student/view";
	}
	
	/**
	 * 添加执行
	 * @return
	 */
	@RequestMapping(value = "/exAdd")
	public String exAdd(Student student, Model model, HttpServletRequest request, HttpServletResponse response) {

		Object attribute = request.getSession().getAttribute("userId");
		
		if (attribute == null){
			return "redirect:/login/uLogin";	
		}
		Integer userId = Integer.valueOf(attribute.toString());
		Fdy byId = fdyService.getById(userId);
		if (byId== null || byId.getBjId() == null){
			return "redirect:/login/message?type=1";
		}
		student.setBjId(byId.getBjId());
		student.setIsDelete(0);
		studentService.insert(student);
		return "redirect:/student/findBySql.action";
	}
	
	
	/**
	 * 跳至修改页面
	 * @return
	 */
	@RequestMapping(value = "/update")
	public String update(Integer id,Model model) {
		Student obj = studentService.load(id);
		model.addAttribute("obj",obj);
		return "student/update";
	}
	
	/**
	 * 添加修改
	 * @return
	 */
	@RequestMapping(value = "/exUpdate")
	public String exUpdate(Student student, Model model, HttpServletRequest request, HttpServletResponse response) {
		//1.通过实体类修改，可以多传修改条件
		studentService.updateById(student);
		//2.通过主键id修改
		//studentService.updateById(student);
		return "redirect:/student/findBySql.action";
	}
	
	/**
	 * 删除通过主键
	 * @return
	 */
	@RequestMapping(value = "/delete")
	public String delete(Integer id, Model model, HttpServletRequest request, HttpServletResponse response) {
		Student load = studentService.load(id);
		load.setIsDelete(1);
		studentService.updateById(load);
		return "redirect:/student/findBySql.action";
	}
	
	
}

教师管理控制层：

@Controller
@RequestMapping("/teacher")
public class TeacherController extends BaseController {
	
	
	/**
	 * 依赖注入 start dao/service/===
	 */
	@Autowired
	private TeacherService teacherService;
	
	@Autowired
	private BjService bjService;
	
	@Autowired
	private TeacherBjService teacherBjService;
	
	
	// --------------------------------------- 华丽分割线 ------------------------------
	
	
	
	
	/**
	 * 分页查询 返回list对象(通过对象)
	 * 
	 * @param request
	 * @param response
	 * @return
	 */
	@RequestMapping(value = "/findByObj")
	public String findByObj(Teacher teacher, Model model, HttpServletRequest request, HttpServletResponse response) {
		//分页查询
		Pager<Teacher> pagers = teacherService.findByEntity(teacher);
		model.addAttribute("pagers", pagers);
		//存储查询条件
		model.addAttribute("obj", teacher);
		return "teacher/teacher";
	}
	
	/**
	 * 分页查询 返回list对象(通过对By Sql)
	 * 
	 * @param request
	 * @param response
	 * @return
	 */
	@RequestMapping(value = "/findBySql")
	public String findBySql(Teacher teacher, Model model, HttpServletRequest request, HttpServletResponse response) {
		//分页查询
		String sql = "SELECT * FROM teacher WHERE isDelete = 0 ";
        if(!isEmpty(teacher.getCode())){
        	sql += " and code like '%"+teacher.getCode()+"%'";
		}
        if(!isEmpty(teacher.getUsername())){
        	sql += " and username like '%"+teacher.getUsername()+"%'";
		}
        if(!isEmpty(teacher.getPassword())){
        	sql += " and password like '%"+teacher.getPassword()+"%'";
		}
        if(!isEmpty(teacher.getKc())){
        	sql += " and kc like '%"+teacher.getKc()+"%'";
		}
        if(!isEmpty(teacher.getIsDelete())){
        	sql += " and isDelete like '%"+teacher.getIsDelete()+"%'";
		}
       sql += " ORDER BY ID DESC ";
		Pager<Teacher> pagers = teacherService.findBySqlRerturnEntity(sql);
		model.addAttribute("pagers", pagers);
		//存储查询条件
		model.addAttribute("obj", teacher);
		return "teacher/teacher";
	}
	
	
	/**
	 * 分页查询 返回list对象(通过Map)
	 * 
	 * @param request
	 * @param response
	 * @return
	 */
	@RequestMapping(value = "/findByMap")
	public String findByMap(Teacher teacher, Model model, HttpServletRequest request, HttpServletResponse response) {
		//通过map查询
		Map<String,Object> params = new HashMap<String,Object>();
        if(!isEmpty(teacher.getCode())){
        	params.put("code", teacher.getCode());
		}
        if(!isEmpty(teacher.getUsername())){
        	params.put("username", teacher.getUsername());
		}
        if(!isEmpty(teacher.getPassword())){
        	params.put("password", teacher.getPassword());
		}
        if(!isEmpty(teacher.getKc())){
        	params.put("kc", teacher.getKc());
		}
        if(!isEmpty(teacher.getIsDelete())){
        	params.put("isDelete", teacher.getIsDelete());
		}
		//分页查询
		Pager<Teacher> pagers = teacherService.findByMap(params);
		model.addAttribute("pagers", pagers);
		//存储查询条件
		model.addAttribute("obj", teacher);
		return "teacher/teacher";
	}
	
	/**********************************【增删改】******************************************************/
	
	/**
	 * 跳至添加页面
	 * @return
	 */
	@RequestMapping(value = "/add")
	public String add(Model model) {
		// 查询班级列表
				Bj b = new Bj();
				b.setIsDelete(0);
				List<Bj> listAllByEntity = bjService.listAllByEntity(b);
				model.addAttribute("bjs", listAllByEntity);
		return "teacher/add";
	}

	@RequestMapping(value = "/pass")
	public String pass(Integer id,HttpServletRequest request,Model model) {
       Object attribute = request.getSession().getAttribute("userId");
		
		if (attribute == null){
			return "redirect:/login/uLogin";	
		}
		Integer userId = Integer.valueOf(attribute.toString());
		Teacher obj = teacherService.load(userId);
		model.addAttribute("obj",obj);
		return "teacher/pass";
	}
	
	
	@RequestMapping("/upass")
	@ResponseBody
	public String upass(HttpServletRequest request,String password){
      Object attribute = request.getSession().getAttribute("userId");
      JSONObject j = new  JSONObject();
	   	if (attribute == null){
	   		j.put("res", 0);
	   		return j.toString();
		}
			Integer userId = Integer.valueOf(attribute.toString());
			Teacher byId = teacherService.getById(userId);
			byId.setPassword(password);
			teacherService.updateById(byId);
			j.put("res", 1);
			return j.toString();
			
	}
	
	/**
	 * 跳至详情页面
	 * @return
	 */
	@RequestMapping(value = "/view")
	public String view(Integer id,Model model) {
		Teacher obj = teacherService.load(id);
		model.addAttribute("obj",obj);
		return "teacher/view";
	}
	
	/**
	 * 添加执行
	 * @return
	 */
	@RequestMapping(value = "/exAdd")
	public String exAdd(Teacher teacher,@RequestParam(value = "ids") Integer[] ids, Model model, HttpServletRequest request, HttpServletResponse response) {
		
		if (ids != null && ids.length > 0){
			teacher.setIsDelete(0);
			teacherService.insert(teacher);
			for (Integer bId : ids){
				TeacherBj tb = new TeacherBj();
				tb.setBjId(bId);
				tb.setTeacherId(teacher.getId());
				teacherBjService.insert(tb);
			}
		}
		
		
		return "redirect:/teacher/findBySql.action";
	}
	
	
	/**
	 * 跳至修改页面
	 * @return
	 */
	@RequestMapping(value = "/update")
	public String update(Integer id,Model model) {
		Teacher obj = teacherService.load(id);
		// 查询班级列表
		Bj b = new Bj();
		b.setIsDelete(0);
		List<Bj> listAllByEntity = bjService.listAllByEntity(b);
		//查看教师已经选中的
		TeacherBj t = new TeacherBj();
		t.setTeacherId(id);
		List<TeacherBj> select = teacherBjService.listAllByEntity(t);
		
		List<Integer> ids = new ArrayList<Integer>();
		
		if (!CollectionUtils.isEmpty(select)){
			for (TeacherBj b2 : select){
				ids.add(b2.getBjId());
			}
		}
		
		if (!CollectionUtils.isEmpty(listAllByEntity)){
			
			for (Bj bj : listAllByEntity){
				
				if (!CollectionUtils.isEmpty(ids) && ids.contains(bj.getId())){
					bj.setIsCheck(1);
				}else{
					bj.setIsCheck(0);
				}
			}
		}
		
		
		model.addAttribute("bjs", listAllByEntity);
		model.addAttribute("obj",obj);
		return "teacher/update";
	}
	
	/**
	 * 添加修改
	 * @return
	 */
	@RequestMapping(value = "/exUpdate")
	public String exUpdate(Teacher teacher,@RequestParam(value = "ids") Integer[] ids, Model model, HttpServletRequest request, HttpServletResponse response) {
		teacherService.updateById(teacher);
		if (ids != null && ids.length > 0){
			teacher.setIsDelete(0);
			//删除
			TeacherBj t = new TeacherBj();
			t.setTeacherId(teacher.getId());
			teacherBjService.deleteByEntity(t);
			for (Integer bId : ids){
				TeacherBj tb = new TeacherBj();
				tb.setBjId(bId);
				tb.setTeacherId(teacher.getId());
				teacherBjService.insert(tb);
			}
		}
		return "redirect:/teacher/findBySql.action";
	}
	
	/**
	 * 删除通过主键
	 * @return
	 */
	@RequestMapping(value = "/delete")
	public String delete(Integer id, Model model, HttpServletRequest request, HttpServletResponse response) {
		Teacher load = teacherService.load(id);
		TeacherBj t = new TeacherBj();
		t.setTeacherId(id);
		teacherBjService.deleteByEntity(t);
		load.setIsDelete(1);
		teacherService.updateById(load);
		return "redirect:/teacher/findBySql.action";
	}
	
	
}

签到管理控制层：

@Controller
@RequestMapping("/sign")
public class SignController extends BaseController {
	
	/**
	 * 依赖注入 start dao/service/===
	 */
	@Autowired
	private RecordService recordService;
	
	@Autowired
	private SignService signService;
	
	
	@Autowired
	private TeacherBjService teacherBjService;
	
	@Autowired
	private FdyService fdyService;
	
	@Autowired
	private StudentService studentService;
	
	/**
	 * 教师查看自己所教学的班级
	 * mybj
	 */
	
	@RequestMapping(value = "/mybj")
	public String mybj(Sign sign, Model model, HttpServletRequest request, HttpServletResponse response) {
		
		Object attribute = request.getSession().getAttribute("userId");
		
		if (attribute == null){
			return "redirect:/login/uLogin";	
		}
		Integer userId = Integer.valueOf(attribute.toString());
		TeacherBj b = new TeacherBj();
		b.setTeacherId(userId);
		List<TeacherBj> listAllByEntity = teacherBjService.listAllByEntity(b);
		model.addAttribute("bjs", listAllByEntity);
		return "sign/mybj";
	}
	
	@RequestMapping(value = "/mybj2")
	public String mybj2(Sign sign, Model model, HttpServletRequest request, HttpServletResponse response) {
		
		Object attribute = request.getSession().getAttribute("userId");
		
		if (attribute == null){
			return "redirect:/login/uLogin";	
		}
		Integer userId = Integer.valueOf(attribute.toString());
		TeacherBj b = new TeacherBj();
		b.setTeacherId(userId);
		List<TeacherBj> listAllByEntity = teacherBjService.listAllByEntity(b);
		model.addAttribute("bjs", listAllByEntity);
		return "sign/mybj2";
	}
	
	
	//${ctx}/sign/mySign.do?bjId=${data.bjId}
	
	@RequestMapping(value = "/findBySql")
	public String findBySql(Sign sign, Model model, HttpServletRequest request, HttpServletResponse response) {
		//分页查询
		Object attribute = request.getSession().getAttribute("userId");
		
		if (attribute == null){
			return "redirect:/login/uLogin";	
		}
		Integer userId = Integer.valueOf(attribute.toString());
		
		String sql = "SELECT * FROM sign WHERE bjId= "+sign.getBjId() + " and teacherId="+userId;
        if(!isEmpty(sign.getBjId())){
        	sql += " and bjId like '%"+sign.getBjId()+"%'";
		}
        if(!isEmpty(sign.getTeacherId())){
        	sql += " and teacherId like '%"+sign.getTeacherId()+"%'";
		}
        if(!isEmpty(sign.getName())){
        	sql += " and name like '%"+sign.getName()+"%'";
		}
        if(!isEmpty(sign.getStatus())){
        	sql += " and status like '%"+sign.getStatus()+"%'";
		}
        if(!isEmpty(sign.getFdyId())){
        	sql += " and fdyId like '%"+sign.getFdyId()+"%'";
		}
       sql += " ORDER BY ID DESC ";
		Pager<Sign> pagers = signService.findBySqlRerturnEntity(sql);
		model.addAttribute("pagers", pagers);
		//存储查询条件
		model.addAttribute("obj", sign);
		model.addAttribute("bjId", sign.getBjId());
		return "sign/sign";
	}
	
	/**
	 * 辅导员列表
	 * @param sign
	 * @param model
	 * @param request
	 * @param response
	 * @return
	 */
	@RequestMapping(value = "/fdySign")
	public String fdySign(Sign sign, Model model, HttpServletRequest request, HttpServletResponse response) {
		//分页查询
		Object attribute = request.getSession().getAttribute("userId");
		
		if (attribute == null){
			return "redirect:/login/uLogin";	
		}
		Integer userId = Integer.valueOf(attribute.toString());
		
		String sql = "SELECT * FROM sign WHERE fdyId= "+userId;
		
        if(!isEmpty(sign.getBjId())){
        	sql += " and bjId like '%"+sign.getBjId()+"%'";
		}
        if(!isEmpty(sign.getTeacherId())){
        	sql += " and teacherId like '%"+sign.getTeacherId()+"%'";
		}
        if(!isEmpty(sign.getName())){
        	sql += " and name like '%"+sign.getName()+"%'";
		}
        if(!isEmpty(sign.getStatus())){
        	sql += " and status like '%"+sign.getStatus()+"%'";
		}
        if(!isEmpty(sign.getFdyId())){
        	sql += " and fdyId like '%"+sign.getFdyId()+"%'";
		}
       sql += " ORDER BY ID DESC ";
		Pager<Sign> pagers = signService.findBySqlRerturnEntity(sql);
		model.addAttribute("pagers", pagers);
		//存储查询条件
		model.addAttribute("obj", sign);
		return "sign/fdySign";
	}
	
	
	
	
	/**
	 * 分页查询 返回list对象(通过Map)
	 * 
	 * @param request
	 * @param response
	 * @return
	 */
	@RequestMapping(value = "/findByMap")
	public String findByMap(Sign sign, Model model, HttpServletRequest request, HttpServletResponse response) {
		//通过map查询
		Map<String,Object> params = new HashMap<String,Object>();
        if(!isEmpty(sign.getBjId())){
        	params.put("bjId", sign.getBjId());
		}
        if(!isEmpty(sign.getTeacherId())){
        	params.put("teacherId", sign.getTeacherId());
		}
        if(!isEmpty(sign.getName())){
        	params.put("name", sign.getName());
		}
        if(!isEmpty(sign.getStatus())){
        	params.put("status", sign.getStatus());
		}
        if(!isEmpty(sign.getFdyId())){
        	params.put("fdyId", sign.getFdyId());
		}
		//分页查询
		Pager<Sign> pagers = signService.findByMap(params);
		model.addAttribute("pagers", pagers);
		//存储查询条件
		model.addAttribute("obj", sign);
		return "sign/sign";
	}
	
	/**********************************【增删改】******************************************************/
	
	/**
	 * 跳至添加页面
	 * @return
	 */
	@RequestMapping(value = "/add")
	public String add(Integer bjId,Model model) {
		model.addAttribute("bjId", bjId);
		return "sign/add";
	}

	/**
	 * 跳至详情页面
	 * @return
	 */
	@RequestMapping(value = "/view")
	public String view(Integer id,Model model) {
		Sign obj = signService.load(id);
		model.addAttribute("obj",obj);
		return "sign/view";
	}
	
	/**
	 * 添加执行
	 * @return
	 */
	@RequestMapping(value = "/exAdd")
	public String exAdd(Sign sign, Model model, HttpServletRequest request, HttpServletResponse response) {
	Object attribute = request.getSession().getAttribute("userId");
		
		if (attribute == null){
			return "redirect:/login/uLogin";	
		}
		Integer userId = Integer.valueOf(attribute.toString());
		sign.setTeacherId(userId);
		sign.setStatus(0);
		signService.insert(sign);
		//查询学生，插入记录表
		Student s = new Student();
		s.setBjId(sign.getBjId());
		s.setIsDelete(0);
		List<Student> listAllByEntity = studentService.listAllByEntity(s);
		if (!CollectionUtils.isEmpty(listAllByEntity)){
			
			for (Student ss : listAllByEntity){
				Record re = new Record();
			//	re.setCreateTime(new Date());
				re.setSignId(sign.getId());
				//0 未签到 1 已签到 2 请假
				re.setStatus(0);
				re.setStudentId(ss.getId());
				recordService.insert(re);
			}
		}
		return "redirect:/sign/findBySql.action?bjId="+sign.getBjId();
	}
	
	
	/**
	 * 跳至修改页面
	 * @return
	 */
	@RequestMapping(value = "/update")
	public String update(Integer id,Model model) {
		Sign obj = signService.load(id);
		model.addAttribute("obj",obj);
		return "sign/update";
	}
	
	/**
	 * 添加修改
	 * @return
	 */
	@RequestMapping(value = "/sp")
	public String sp(Sign sign, Model model, HttpServletRequest request, HttpServletResponse response) {
		//1.通过实体类修改，可以多传修改条件
		Sign obj = signService.load(sign.getId());
		
		if (sign.getStatus() == 2){
			Fdy f = new Fdy();
			f.setBjId(obj.getBjId());
			Fdy byEntity = null;
			try {
				byEntity = fdyService.listAllByEntity(f).get(0);
				obj.setFdyId(byEntity.getId());
				obj.setStatus(sign.getStatus());
				signService.updateById(obj);
			} catch (Exception e) {
				
			}
		
		}
		
		
		//2.通过主键id修改
		//signService.updateById(sign);
		return "redirect:/sign/findBySql.action?bjId="+obj.getBjId();
	}
	
	@RequestMapping(value = "/exUpdate")
	public String exUpdate(Sign sign, Model model, HttpServletRequest request, HttpServletResponse response) {
		Sign obj = signService.load(sign.getId());
		signService.updateById(sign);
		return "redirect:/sign/findBySql?bjId="+obj.getBjId();
	}
	
	/**
	 * 删除通过主键
	 * @return
	 */
	@RequestMapping(value = "/delete")
	public String delete(Integer id, Model model, HttpServletRequest request, HttpServletResponse response) {
		Sign obj = signService.load(id);
		///1.通过主键删除
		signService.deleteById(id);
		return "redirect:/sign/findBySql?bjId="+obj.getBjId();
	}
	
	
}

源码获取：俺的博客首页 "资源" 里下载！