基于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/ 登录
}
if(!isEmpty(qj.getStatus())){
params.put("status", qj.getStatus());
}
//分页查询
Pager<Qj> pagers = qjService.findByMap(params);
model.addAttribute("pagers", pagers);
//存储查询条件
model.addAttribute("obj", qj);
return "qj/qj";
}
/**********************************【增删改】******************************************************/
/**
* 跳至添加页面
* @return
*/
@RequestMapping(value = "/add")
public String add() {
return "qj/add";
}
@RequestMapping(value = "/myadd")
public String myadd() {
return "qj/myadd";
}
/**
* 跳至详情页面
* @return
*/
@RequestMapping(value = "/view")
public String view(Integer id,Model model) {
Qj obj = qjService.load(id);
model.addAttribute("obj",obj);
return "qj/view";
}
/**
* 添加执行
* @return
*/
@RequestMapping(value = "/exAdd")
public String exAdd(Qj qj, Model model, HttpServletRequest request, HttpServletResponse response) {
Object attribute = request.getSession().getAttribute("userId");
if (attribute == null){
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);
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.通过实体类修改，可以多传修改条件
obj.setStatus(2);
recordService.updateById(obj);
//2.通过主键id修改
//recordService.updateById(record);
return "redirect:/record/findBySql.action?signId="+obj.getSignId();
}
@RequestMapping(value = "/exUpdate")
public String exUpdate(Record record, Model model, HttpServletRequest request, HttpServletResponse response) {
//1.通过实体类修改，可以多传修改条件
recordService.updateById(record);
//2.通过主键id修改
//recordService.updateById(record);
*/
@RequestMapping("/tologin")
public String toLogin(String code,String password,Integer role, HttpServletRequest request, HttpServletResponse response){
// 4 学生，3 任课教师 ，2辅导员
if (role == 4){
Student s = new Student();
s.setIsDelete(0);
s.setCode(code);
s.setPassword(password);
Student byEntity = studentService.getByEntity(s);
if(byEntity == null){
return "redirect:/login/uLogin.action";
}else{
request.getSession().setAttribute("role",role);
request.getSession().setAttribute("username", byEntity.getUsername());
request.getSession().setAttribute("userId", byEntity.getId());
}
}
if (role == 3){
Teacher s = new Teacher();
s.setIsDelete(0);
s.setCode(code);
s.setPassword(password);
Teacher byEntity = teacherService.getByEntity(s);
if(byEntity == null){
return "redirect:/login/uLogin.action";
}else{
request.getSession().setAttribute("role",role);
request.getSession().setAttribute("username", byEntity.getUsername());
request.getSession().setAttribute("userId", byEntity.getId());
}
}
if (role == 2){
Fdy s = new Fdy();
s.setCode(code);
s.setPassword(password);
Fdy byEntity = fdyService.getByEntity(s);
if(byEntity == null){
return "redirect:/login/uLogin.action";
}else{
request.getSession().setAttribute("role",role);
request.getSession().setAttribute("username", byEntity.getUsername());
request.getSession().setAttribute("userId", byEntity.getId());
}
}
return "login/index";
/*********************************查询列表【不分页】***********************************************/
/**
* 【不分页 => 查询列表 => 无条件】
* @Title: listAll
* @Description: TODO(这里用一句话描述这个方法的作用)
* @param @return 设定文件
* @return String 返回类型
* @throws
*/
@RequestMapping(value = "/listAllJson", method = RequestMethod.POST)
@ResponseBody
public String listAllJson(Manage manage, HttpServletRequest request, HttpServletResponse response){
List<Manage> listAll = manageService.listAll();
JSONObject jsonObject = new JSONObject();
jsonObject.put("list", listAll);
jsonObject.put("obj", manage);
return jsonObject.toString();
}
/**
* 【不分页=》查询列表=>有条件】
* @Title: listByEntity
* @Description: TODO(这里用一句话描述这个方法的作用)
* @param @return 设定文件
* @return String 返回类型
* @throws
*/
@RequestMapping(value = "/listByEntityJson", method = RequestMethod.POST)
@ResponseBody
public String listByEntityJson(Manage manage, HttpServletRequest request, HttpServletResponse response){
List<Manage> listAll = manageService.listAllByEntity(manage);
JSONObject jsonObject = new JSONObject();
jsonObject.put("list", listAll);
jsonObject.put("obj", manage);
return jsonObject.toString();
}
params.put("username", manage.getUsername());
}
if(!isEmpty(manage.getPassword())){
params.put("password", manage.getPassword());
}
List<Manage> listAll = manageService.listByMap(params);
model.addAttribute("list", listAll);
return "manage/manage";
}
/*********************************查询列表【分页】***********************************************/
/**
* 分页查询 返回list对象(通过对象)
*
* @param request
* @param response
* @return
*/
@RequestMapping(value = "/findByObj")
public String findByObj(Manage manage, Model model, HttpServletRequest request, HttpServletResponse response) {
//分页查询
Pager<Manage> pagers = manageService.findByEntity(manage);
model.addAttribute("pagers", pagers);
//存储查询条件
model.addAttribute("obj", manage);
return "manage/manage";
}
/**
* 分页查询 返回list对象(通过对By Sql)
*
* @param request
* @param response
* @return
*/
@RequestMapping(value = "/findBySql")
public String findBySql(Manage manage, Model model, HttpServletRequest request, HttpServletResponse response) {
//分页查询
String sql = "SELECT * FROM manage WHERE 1=1 ";
if(!isEmpty(manage.getUsername())){
sql += " and username like '%"+manage.getUsername()+"%'";
}
if(!isEmpty(manage.getPassword())){
sql += " and password like '%"+manage.getPassword()+"%'";
}
*/
@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");
/**
* @ClassName:
* @Description:
*/
@Controller
@RequestMapping("/fdy")
public class FdyController extends BaseController {
/**
* 依赖注入 start dao/service/===
*/
@Autowired
private FdyService fdyService;
@Autowired
private BjService bjService;
// --------------------------------------- 华丽分割线 ------------------------------
/**
* 分页查询 返回list对象(通过对By Sql)
* 管理员退出
* @param request
* @return
*/
@RequestMapping("/mtuichu")
public String mtuichu(HttpServletRequest request){
//request.getSession().invalidate();
return "login/mLogin";
}
/**
* 欢迎页
* @return
*/
@RequestMapping("/welcome")
private String welcome(){
return "login/welcome";
}
/**
* 管理员登陆
* @param manage
* @param request
* @param response
* @return
*/
@RequestMapping("/toMlogin")
public String toLogin(Manage manage, HttpServletRequest request, HttpServletResponse response){
Manage byEntity = manageService.getByEntity(manage);
if(byEntity == null){
return "redirect:/login/mtuichu";
}else{
request.getSession().setAttribute("role", 1);
request.getSession().setAttribute("username", byEntity.getUsername());
request.getSession().setAttribute("userId", byEntity.getId());
}
return "login/index";
}
/**
* 除了管理员意外的登陆
* @param code
* @param password
* @param role
* @param request
* @param response
* @return
*/
}
/**
* 分页查询 返回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";
}
/**
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()+"%'";
}
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/record";
}
/**
@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());
}
@ResponseBody
public String findByMapJson(TeacherBj teacherBj,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);
JSONObject jsonObject = new JSONObject();
jsonObject.put("pagers", pagers);
jsonObject.put("obj", teacherBj);
return jsonObject.toString();
}
/**
* ajax 添加
* @param
* @return
*/
@RequestMapping(value = "/exAddJson", method = RequestMethod.POST)
@ResponseBody
public String exAddJson(TeacherBj teacherBj, Model model, HttpServletRequest request, HttpServletResponse response) {
teacherBjService.insert(teacherBj);
JSONObject jsonObject = new JSONObject();
jsonObject.put("message", "添加成功");
return jsonObject.toString();
}
/**
* ajax 修改
* @param
* @return
*/
@RequestMapping(value = "/exUpdate.json", method = RequestMethod.POST)
@ResponseBody
public String exUpdateJson(TeacherBj teacherBj, Model model, HttpServletRequest request, HttpServletResponse response) {
}
/**
* 分页查询 返回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() {
return "bj/add";
}
/**
* 跳至详情页面
* @return
*/
@RequestMapping(value = "/view")
public String view(Integer id,Model model) {
Bj obj = bjService.load(id);
model.addAttribute("obj",obj);
return "bj/view";
}
/**
* 添加执行
* @return
*/
@RequestMapping(value = "/exAdd")
public String exAdd(Bj bj, Model model, HttpServletRequest request, HttpServletResponse response) {
bj.setIsDelete(0);
bjService.insert(bj);
return "redirect:/bj/findBySql.action";
}
/**
* 跳至修改页面
* @return
*/
@RequestMapping(value = "/update")
public String update(Integer id,Model model) {
Bj obj = bjService.load(id);
model.addAttribute("obj",obj);
return "bj/update";
}
/**
* 添加修改
* @return
*/
* @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(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";
}
/**
* 分页查询 返回list对象(通过Map)
*
* @param request
* @param response
* @return
*/
@RequestMapping(value = "/findByMap")
public String findByMap(Record record, Model model, HttpServletRequest request, HttpServletResponse response) {
//通过map查询
Map<String,Object> params = new HashMap<String,Object>();
if(!isEmpty(record.getSignId())){
params.put("signId", record.getSignId());
}
if(!isEmpty(record.getStudentId())){
params.put("studentId", record.getStudentId());
}
if(!isEmpty(record.getIp())){
params.put("ip", record.getIp());
}
if(!isEmpty(record.getCreateTime())){
params.put("createTime", record.getCreateTime());
}
if(!isEmpty(record.getStatus())){
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")
s.setPassword(password);
Student byEntity = studentService.getByEntity(s);
if(byEntity == null){
return "redirect:/login/uLogin.action";
}else{
request.getSession().setAttribute("role",role);
request.getSession().setAttribute("username", byEntity.getUsername());
request.getSession().setAttribute("userId", byEntity.getId());
}
}
if (role == 3){
Teacher s = new Teacher();
s.setIsDelete(0);
s.setCode(code);
s.setPassword(password);
Teacher byEntity = teacherService.getByEntity(s);
if(byEntity == null){
return "redirect:/login/uLogin.action";
}else{
request.getSession().setAttribute("role",role);
request.getSession().setAttribute("username", byEntity.getUsername());
request.getSession().setAttribute("userId", byEntity.getId());
}
}
if (role == 2){
Fdy s = new Fdy();
s.setCode(code);
s.setPassword(password);
Fdy byEntity = fdyService.getByEntity(s);
if(byEntity == null){
return "redirect:/login/uLogin.action";
}else{
request.getSession().setAttribute("role",role);
request.getSession().setAttribute("username", byEntity.getUsername());
request.getSession().setAttribute("userId", byEntity.getId());
}
}
return "login/index";
}
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
