基于javaweb+mysql的ssm+maven学生考勤请假管理系统(java+ssm+jsp+layui+mysql)
运行环境
Java≥8、MySQL≥5.7、Tomcat≥8
开发工具
eclipse/idea/myeclipse/sts等均可配置运行
适用
课程设计,大作业,毕业设计,项目练习,学习演示等
功能说明
基于javaweb+mysql的SSM+Maven学生考勤请假管理系统(java+ssm+jsp+layui+mysql)
项目介绍
本项目包含辅导员、管理员、教师、学生四种角色;
辅导员包含以下功能: 辅导员角色登录,学生管理,密码修改,请假审批,签到列表等功能。
管理员角色包含以下功能: 管理员登录,班级管理,辅导员管理,教师管理等功能。
教师角色包含以下功能: 教师登录,签到管理,请假列表,密码修改等功能。
学生角色包含以下功能: 学生角色登录,查看我的签到,修改密码,请假管理,开始签到等功能。
环境需要
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版本; 6.是否Maven项目:是;
技术栈
- 后端:Spring+SpringMVC+Mybatis 2. 前端:JSP+CSS+JavaScript+layui
使用说明
- 使用Navicat或者其它工具,在mysql中创建对应名称的数据库,并导入项目的sql文件; 2. 使用IDEA/Eclipse/MyEclipse导入项目,Eclipse/MyEclipse导入时,若为maven项目请选择maven; 若为maven项目,导入成功后请执行maven clean;maven install命令,然后运行; 3. 将项目中db.properties配置文件中的数据库配置改为自己的配置; 4. 运行项目,输入localhost:8080/ 登录
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);
}
}
}
Pager<Manage> pagers = manageService.findByMap(params);
model.addAttribute("pagers", pagers);
//存储查询条件
model.addAttribute("obj", manage);
return "manage/manage";
}
/**********************************【增删改】******************************************************/
/**
* 跳至添加页面
* @return
*/
@RequestMapping(value = "/add")
public String add() {
return "manage/add";
}
/**
* 跳至详情页面
* @return
*/
@RequestMapping(value = "/view")
public String view(Integer id,Model model) {
Manage obj = manageService.load(id);
model.addAttribute("obj",obj);
return "manage/view";
}
/**
* 添加执行
* @return
*/
@RequestMapping(value = "/exAdd")
public String exAdd(Manage manage, Model model, HttpServletRequest request, HttpServletResponse response) {
manageService.insert(manage);
return "redirect:/manage/findBySql.action";
}
/**
* 跳至修改页面
* @return
*/
@RequestMapping(value = "/update")
public String update(Integer id,Model model) {
Manage obj = manageService.load(id);
*/
@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")
params.put("status", record.getStatus());
}
//分页查询
Pager<Record> pagers = recordService.findByMap(params);
model.addAttribute("pagers", pagers);
//存储查询条件
model.addAttribute("obj", record);
return "record/record";
}
/**********************************【增删改】******************************************************/
/**
* 跳至添加页面
* @return
*/
@RequestMapping(value = "/add")
public String add() {
return "record/add";
}
/**
* 跳至详情页面
* @return
*/
@RequestMapping(value = "/view")
public String view(Integer id,Model model) {
Record obj = recordService.load(id);
model.addAttribute("obj",obj);
return "record/view";
}
/**
* 添加执行
* @return
*/
@RequestMapping(value = "/exAdd")
@ResponseBody
public String exAdd(Record record, Model model, HttpServletRequest request, HttpServletResponse response) {
String ipAdrress = getIp(request);
Record obj = recordService.load(record.getId());
Integer userId = Integer.valueOf(attribute.toString());
Fdy byId = fdyService.getById(userId);
byId.setPassword(password);
fdyService.updateById(byId);
j.put("res", 1);
return j.toString();
}
/**
* 添加执行
* @return
*/
@RequestMapping(value = "/exAdd")
public String exAdd(Fdy fdy, Model model, HttpServletRequest request, HttpServletResponse response) {
fdy.setIsDelete(0);
fdyService.insert(fdy);
return "redirect:/fdy/findBySql.action";
}
/**
* 跳至修改页面
* @return
*/
@RequestMapping(value = "/update")
public String update(Integer id,Model model) {
Bj b = new Bj();
b.setIsDelete(0);
List<Bj> listAllByEntity = bjService.listAllByEntity(b);
model.addAttribute("bjs", listAllByEntity);
Fdy obj = fdyService.load(id);
model.addAttribute("obj",obj);
return "fdy/update";
}
/**
* 添加修改
* @return
*/
@RequestMapping(value = "/exUpdate")
public String exUpdate(Fdy fdy, Model model, HttpServletRequest request, HttpServletResponse response) {
/**
* @ClassName:
* @Description:
*/
@Controller
@RequestMapping("/bj")
public class BjController extends BaseController {
/**
* 依赖注入 start dao/service/===
*/
@Autowired
private BjService bjService;
// --------------------------------------- 华丽分割线 ------------------------------
/**
* 分页查询 返回list对象(通过对By Sql)
*
* @param request
* @param response
* @return
*/
@RequestMapping(value = "/findBySql")
public String findBySql(Bj bj, Model model, HttpServletRequest request, HttpServletResponse response) {
//分页查询
String sql = "SELECT * FROM bj WHERE isDelete = 0 ";
if(!isEmpty(bj.getName())){
sql += " and name like '%"+bj.getName()+"%'";
}
if(!isEmpty(bj.getZy())){
* 分页查询 返回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")
sql += " and code like '%"+fdy.getCode()+"%'";
}
if(!isEmpty(fdy.getSex())){
sql += " and sex like '%"+fdy.getSex()+"%'";
}
if(!isEmpty(fdy.getBjId())){
sql += " and bjId like '%"+fdy.getBjId()+"%'";
}
sql += " ORDER BY ID DESC ";
Pager<Fdy> pagers = fdyService.findBySqlRerturnEntity(sql);
model.addAttribute("pagers", pagers);
//存储查询条件
model.addAttribute("obj", fdy);
return "fdy/fdy";
}
/**
* 分页查询 返回list对象(通过Map)
*
* @param request
* @param response
* @return
*/
@RequestMapping(value = "/findByMap")
public String findByMap(Fdy fdy, Model model, HttpServletRequest request, HttpServletResponse response) {
//通过map查询
Map<String,Object> params = new HashMap<String,Object>();
if(!isEmpty(fdy.getUsername())){
params.put("username", fdy.getUsername());
}
if(!isEmpty(fdy.getPassword())){
params.put("password", fdy.getPassword());
}
if(!isEmpty(fdy.getCode())){
params.put("code", fdy.getCode());
}
if(!isEmpty(fdy.getSex())){
params.put("sex", fdy.getSex());
}
if(!isEmpty(fdy.getBjId())){
params.put("bjId", fdy.getBjId());
}
//分页查询
Pager<Fdy> pagers = fdyService.findByMap(params);
model.addAttribute("pagers", pagers);
//存储查询条件
model.addAttribute("obj", fdy);
return "fdy/fdy";
}
/**********************************【增删改】******************************************************/
* 查询学生自己可以签到列表
* @param record
* @param model
* @param request
* @param response
* @return
*/
@RequestMapping(value = "/mysign")
public String mysign(Record record, 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 record WHERE studentId="+userId;
if(!isEmpty(record.getSignId())){
sql += " and signId like '%"+record.getSignId()+"%'";
}
if(!isEmpty(record.getStudentId())){
sql += " and studentId like '%"+record.getStudentId()+"%'";
}
if(!isEmpty(record.getIp())){
sql += " and ip like '%"+record.getIp()+"%'";
}
if(!isEmpty(record.getCreateTime())){
sql += " and createTime like '%"+record.getCreateTime()+"%'";
}
if(!isEmpty(record.getStatus())){
sql += " and status like '%"+record.getStatus()+"%'";
}
sql += " ORDER BY ID DESC ";
Pager<Record> pagers = recordService.findBySqlRerturnEntity(sql);
model.addAttribute("pagers", pagers);
//存储查询条件
model.addAttribute("obj", record);
model.addAttribute("signId", record.getSignId());
return "record/mysign";
}
if (ip == null || ip.length() == 0 || "unknown".equalsIgnoreCase(ip)) {
ip = request.getHeader("Proxy-Client-IP");
}
if (ip == null || ip.length() == 0 || "unknown".equalsIgnoreCase(ip)) {
ip = request.getHeader("WL-Proxy-Client-IP");
}
if (ip == null || ip.length() == 0 || "unknown".equalsIgnoreCase(ip)) {
ip = request.getHeader("HTTP_CLIENT_IP");
}
if (ip == null || ip.length() == 0 || "unknown".equalsIgnoreCase(ip)) {
ip = request.getHeader("HTTP_X_FORWARDED_FOR");
}
if (ip == null || ip.length() == 0 || "unknown".equalsIgnoreCase(ip)) {
ip = request.getRemoteAddr();
}
} else if (ip.length() > 15) {
String[] ips = ip.split(",");
for (int index = 0; index < ips.length; index++) {
String strIp = ips[index];
if (!("unknown".equalsIgnoreCase(strIp))) {
ip = strIp;
break;
}
}
}
return ip;
}
/**
* 跳至修改页面
* @return
*/
@RequestMapping(value = "/update")
public String update(Integer id,Model model) {
Record obj = recordService.load(id);
model.addAttribute("obj",obj);
return "record/update";
}
/**
* 添加修改
* @return
*/
@RequestMapping(value = "/setQd")
public String setQd(Record record, Model model, HttpServletRequest request, HttpServletResponse response) {
Record obj = recordService.load(record.getId());
//1.通过实体类修改,可以多传修改条件
/**
* @ClassName:
* @Description:
*/
@Controller
@RequestMapping("/record")
public class RecordController extends BaseController {
@Autowired
private SignService signService;
/**
* 依赖注入 start dao/service/===
*/
@Autowired
private RecordService recordService;
// --------------------------------------- 华丽分割线 ------------------------------
/**
* 分页查询 返回list对象(通过对By Sql)
*
* @param request
* @param response
* @return
*/
@RequestMapping(value = "/findBySql")
public String findBySql(Record record, Model model, HttpServletRequest request, HttpServletResponse response) {
//分页查询
String sql = "SELECT * FROM record WHERE signId="+record.getSignId();
if(!isEmpty(record.getSignId())){
sql += " and signId like '%"+record.getSignId()+"%'";
}
if(!isEmpty(record.getStudentId())){
sql += " and studentId like '%"+record.getStudentId()+"%'";
}
/**
* 分页查询 返回list json(通过Map)
*
* @param request
* @param response
* @return
*/
@RequestMapping(value = "/findByMapJson", method = RequestMethod.POST)
@ResponseBody
public String findByMapJson(Manage manage,HttpServletRequest request, HttpServletResponse response) {
//通过map查询
Map<String,Object> params = new HashMap<String,Object>();
if(!isEmpty(manage.getUsername())){
params.put("username", manage.getUsername());
}
if(!isEmpty(manage.getPassword())){
params.put("password", manage.getPassword());
}
//分页查询
Pager<Manage> pagers = manageService.findByMap(params);
JSONObject jsonObject = new JSONObject();
jsonObject.put("pagers", pagers);
jsonObject.put("obj", manage);
return jsonObject.toString();
}
/**
* ajax 添加
* @param
* @return
*/
@RequestMapping(value = "/exAddJson", method = RequestMethod.POST)
@ResponseBody
public String exAddJson(Manage manage, Model model, HttpServletRequest request, HttpServletResponse response) {
manageService.insert(manage);
JSONObject jsonObject = new JSONObject();
jsonObject.put("message", "添加成功");
j.put("res", 1);
return j.toString();
}
/**
* 添加执行
* @return
*/
@RequestMapping(value = "/exAdd")
public String exAdd(Fdy fdy, Model model, HttpServletRequest request, HttpServletResponse response) {
fdy.setIsDelete(0);
fdyService.insert(fdy);
return "redirect:/fdy/findBySql.action";
}
/**
* 跳至修改页面
* @return
*/
@RequestMapping(value = "/update")
public String update(Integer id,Model model) {
Bj b = new Bj();
b.setIsDelete(0);
List<Bj> listAllByEntity = bjService.listAllByEntity(b);
model.addAttribute("bjs", listAllByEntity);
Fdy obj = fdyService.load(id);
model.addAttribute("obj",obj);
return "fdy/update";
}
/**
* 添加修改
* @return
*/
@RequestMapping(value = "/exUpdate")
public String exUpdate(Fdy fdy, Model model, HttpServletRequest request, HttpServletResponse response) {
//1.通过实体类修改,可以多传修改条件
///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())){
// params.put("bjId", teacherBj.getBjId());
// }
//
// teacherBjService.deleteByMap(params);
// //4.状态删除
// TeacherBj load = teacherBjService.getById(teacherBj.getId())
// load.setIsDelete(1);
// teacherBjService.update(load);
//5.状态删除
//TeacherBj load = teacherBjService.load(id);
//load.setIsDelete(1);
//teacherBjService.updateById(load);
return "redirect:/teacherBj/findBySql.action";
}
// --------------------------------------- 华丽分割线 ------------------------------
// --------------------------------------- 【下面是ajax操作的方法。】 ------------------------------
/*********************************查询列表【不分页】***********************************************/
/**
* 【不分页 => 查询列表 => 无条件】
* @Title: listAll
* @Description: TODO(这里用一句话描述这个方法的作用)
* @param @return 设定文件
* @return String 返回类型
* @throws
*/
@RequestMapping(value = "/listAllJson", method = RequestMethod.POST)
@ResponseBody
/**
* 依赖注入 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())){
* @return String 返回类型
* @throws
*/
@RequestMapping(value = "/listByMapJson", method = RequestMethod.POST)
@ResponseBody
public String listByMapJson(Manage manage,HttpServletRequest request, HttpServletResponse response){
//通过map查询
Map<String,Object> params = new HashMap<String,Object>();
if(!isEmpty(manage.getUsername())){
params.put("username", manage.getUsername());
}
if(!isEmpty(manage.getPassword())){
params.put("password", manage.getPassword());
}
List<Manage> listAll = manageService.listByMap(params);
JSONObject jsonObject = new JSONObject();
jsonObject.put("list", listAll);
jsonObject.put("obj", manage);
return jsonObject.toString();
}
/**
* 分页查询 返回list json(通过对象)
*
* @param request
* @param response
* @return
*/
@RequestMapping(value = "/findByObjJson", method = RequestMethod.POST)
@ResponseBody
public String findByObjByEntityJson(Manage manage, HttpServletRequest request, HttpServletResponse response) {
//分页查询
Pager<Manage> pagers = manageService.findByEntity(manage);
JSONObject jsonObject = new JSONObject();
jsonObject.put("pagers", pagers);
jsonObject.put("obj", manage);
return jsonObject.toString();
}
/**
* 分页查询 返回list json(通过Map)
*
* @param request
* @param response
* @return
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());
@Controller
@RequestMapping("/login")
public class LoginController extends BaseController{
@Autowired
private ManageService manageService;
@Autowired
private FdyService fdyService;
@Autowired
private TeacherService teacherService;
@Autowired
private StudentService studentService;
/**
* 跳转登陆 管理员
* @return
*/
@RequestMapping("/mLogin")
public String login(){
return "login/mLogin";
}
/**
* 除了管理员意外的登陆
* @return
*/
@RequestMapping("/uLogin")
public String uLogin(){
return "login/login";
}
@RequestMapping("/message")
public String message(Integer type,Model model){
if (type == 1){
model.addAttribute("mess", "该辅导员并没有负责的班级。");
}
return "login/message";
}
/**
* 管理员退出
* @param request
* @return