基于javaweb+mysql的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
使用说明
- 使用Navicat或者其它工具,在mysql中创建对应名称的数据库,并导入项目的sql文件; 2. 使用IDEA/Eclipse/MyEclipse导入项目,修改配置,运行项目; 3. 将项目中db.xml配置文件中的数据库配置改为自己的配置,然后运行;
/**
* 跳至详情页面
* @return
*/
@RequestMapping(value = "/view")
public String view(Integer id,Model model) {
Teacher obj = teacherService.load(id);
model.addAttribute("obj",obj);
return "teacher/view";
/**
* 添加执行
* @return
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("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";
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";
/**
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/===
*/
@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());
@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) {
*/
@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";
/**
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);
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);
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());
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);
// 查询班级列表
/**
* 分页查询 返回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())){
// --------------------------------------- 华丽分割线 ------------------------------
/**
* 分页查询 返回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);
* @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())){
//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);
* @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());