基于javaweb的SSM校园考勤管理系统(java+ssm+jsp+css+js+jquery+layui+mysql)

运行环境

Java≥8、MySQL≥5.7、Tomcat≥8

开发工具

eclipse/idea/myeclipse/sts等均可配置运行

适用

课程设计，大作业，毕业设计，项目练习，学习演示等

功能说明

基于javaweb的SSM校园考勤管理系统(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.数据库：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 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 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 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 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 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 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 listAllByEntity = bjService.listAllByEntity(b);

//查看教师已经选中的

TeacherBj t = new TeacherBj();

t.setTeacherId(id);

List select = teacherBjService.listAllByEntity(t);

List ids = new ArrayList();

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 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 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 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 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 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 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();

---

项目链接：
https://javayms.github.io?id=491524180701201jb
https://javayms.pages.dev?id=491524180701201jb