Java源码社

基于javaweb的SSH实验室预约管理系统(java+ssh+mysql+jsp)

更新于

运行环境

Java≥8、MySQL≥5.7、Tomcat≥8

开发工具

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

适用

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

功能说明

081323292409

101323292409

111323292409

121323292409

131323292409

141323292409

151323292409

161323292409

171323292409

基于javaweb的SSH实验室预约管理系统(java+ssh+mysql+jsp)

管理员：
admin 123456

老师：
t01 123456
t02 123456
t03 123456

学生（课代表）：
s01 123456
s02 123456
s03 123456

老师可以设置课代表，课代表可以预约实验室，管理员可以审核

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
		List<Course> courses=this.courseService.queryByPage(coursePage,column,data,size);
		session.setAttribute("courses", courses);
		session.setAttribute("coursePage", coursePage);
		
		return SUCCESS;
	}
}else if(user.getType()==2)
{
	if(type==0)
	{
		String[] column={
				"teacherId"
			};
		String[] data={
				user.getId()+""
		};
		int size=1;
		int totalCount=this.courseService.courseCounts(column,data,size);
		setCoursePage(PageUtil.createPage(everyPage, totalCount, 0));
		List<Course> courses=this.courseService.queryByPage(coursePage,column,data,size);
		session.setAttribute("courses", courses);
		session.setAttribute("coursePage", coursePage);
		
		return SUCCESS;
	}
	if(type==1)
	{
		String[] column={
				"teacherId","status"
			};
		String[] data={
				user.getId()+"","1"
		};
		int size=2;
		int totalCount=this.courseService.courseCounts(column,data,size);
		setCoursePage(PageUtil.createPage(everyPage, totalCount, 0));
		List<Course> courses=this.courseService.queryByPage(coursePage,column,data,size);
		session.setAttribute("courses", courses);
		session.setAttribute("coursePage", coursePage);
		
		return SUCCESS;
	}
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
		course=this.getCourseService().findById(id);
		return "check";
	}
}




public class StudentAction extends ActionSupport{
	private static final long serialVersionUID = 9056665237987325857L;
	private StudentService studentService;
	private TeacherService teacherService;
	private int id;
	private int stateCode;
	private String message;
	private Student student;
	@JSON(serialize=false)
	public StudentService getStudentService() {
		return studentService;
	}
	public void setStudentService(StudentService studentService) {
		this.studentService = studentService;
	}
	@JSON(serialize=false)
	public TeacherService getTeacherService() {
		return teacherService;
	}
	public void setTeacherService(TeacherService teacherService) {
		this.teacherService = teacherService;
	}
	public int getId() {
		return id;
	}
	public void setId(int id) {
		this.id = id;
	}
	public int getStateCode() {
		return stateCode;
	}
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
 */
private static final long serialVersionUID = -8603513762614322358L;
private Admin admin;
private Page adminPage;
private int currentPage;
private AdminService adminService;
private final int everyPage=10;
public Admin getAdmin() {
	return admin;
}
public void setAdmin(Admin admin) {
	this.admin = admin;
}
public Page getAdminPage() {
	return adminPage;
}
public void setAdminPage(Page adminPage) {
	this.adminPage = adminPage;
}
public int getCurrentPage() {
	return currentPage;
}
public void setCurrentPage(int currentPage) {
	this.currentPage = currentPage;
}
public AdminService getAdminService() {
	return adminService;
}
public void setAdminService(AdminService adminService) {
	this.adminService = adminService;
}
public int getEveryPage() {
	return everyPage;
}
public String execute(){
	HttpServletRequest request = ServletActionContext.getRequest();
	HttpSession session=request.getSession();
	int totalCount=this.adminService.adminCounts();
	setAdminPage(PageUtil.createPage(everyPage, totalCount, 0));
	List<Admin> admins=this.adminService.queryByPage(adminPage);
	session.setAttribute("admins", admins);
	session.setAttribute("adminPage", adminPage);
	return SUCCESS;
}
public String nextPage(){
	//下一页
	HttpServletRequest request = ServletActionContext.getRequest();
	HttpSession session=request.getSession();
	int totalCount=this.adminService.adminCounts();
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
public class ScanCourseAction extends ActionSupport{
	/**
	 * 
	 */
	private static final long serialVersionUID = 7236063679221783012L;
	private Course course;
	private Page coursePage;
	private int currentPage;
	private CourseService courseService;
	private int type;
	private final int everyPage=10;
	
	
	public int getType() {
		return type;
	}
	public void setType(int type) {
		this.type = type;
	}
	public Course getCourse() {
		return course;
	}
	public void setCourse(Course course) {
		this.course = course;
	}
	public Page getCoursePage() {
		return coursePage;
	}
	public void setCoursePage(Page coursePage) {
		this.coursePage = coursePage;
	}
	public int getCurrentPage() {
		return currentPage;
	}
	public void setCurrentPage(int currentPage) {
		this.currentPage = currentPage;
	}
	public CourseService getCourseService() {
		return courseService;
	}
	public void setCourseService(CourseService courseService) {
		this.courseService = courseService;
	}
	public int getEveryPage() {
		return everyPage;
	}
	
	public String execute(){
		HttpServletRequest request = ServletActionContext.getRequest();
		HttpSession session=request.getSession();
		User user=(User) session.getAttribute("user");
		if(type==2)
		{
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
	Course cs=this.getCourseService().findById(id);
	if(cs!=null)
	{
		cs.setStatus(res);
		this.getCourseService().update(cs);
		stateCode=1;
		message="审核成功！";
		return "updateSuccess";
	}
	stateCode=0;
	this.getCourseService().update(cs);		
	message="审核失败，没有相关记录";
	return ERROR;
}
public String delete(){
	Course cs=this.getCourseService().findById(id);
	this.getCourseService().delete(cs);
	message="删除成功";
	stateCode=1;
	return "deleteSuccess";
}
public String search(){
	HttpServletRequest request = ServletActionContext.getRequest();
	HttpSession session=request.getSession();
	int totalCount=this.roomService.roomCounts();
	setRoomPage(PageUtil.createPage(everyPage, totalCount, 0));
	List<Room> rooms=this.roomService.queryByPage(roomPage);
	session.setAttribute("roomPage", roomPage);
	String[] time=date.split("-");
	List<Course> courses=this.getCourseService().findByDateAndCourseNo(Integer.valueOf(time[0]), Integer.valueOf(time[1]), Integer.valueOf(time[2]), courseNo);
	for(int i=0;i<rooms.size();i++)
	{
		rooms.get(i).setState(0);
		for(int j=0;j<courses.size();j++)
		{
			if(courses.get(j).getRoomId()==rooms.get(i).getId())
				rooms.get(i).setState(1);
		}
		
	}
	session.setAttribute("flag", "1");
	session.setAttribute("rooms", rooms);
	session.setAttribute("date", date);
	session.setAttribute("courseNo", courseNo);
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
public String delete(){
	Teacher tc=getTeacherService().findTeacherById(id);
	if(tc==null)
	{
		message="出现未知问题！";
		return "deleteFailure";
	}
	this.getTeacherService().delete(tc);
	message="删除成功！";
	return "deleteSuccess";
}
public String update(){
	Teacher tc=getTeacherService().findTeacherById(id);
	if(tc==null)
	{
		message="出现未知问题！";
		return "updateFailure";
	}
	HttpServletRequest request = ServletActionContext.getRequest();
	HttpSession session=request.getSession();
	User user=(User)session.getAttribute("user");
	if(user.getType()==2)
	{
		if(!user.getNo().equals(tc.getNo()))
		{
			message="无法修改他人信息！";
			return "updateFailure";
		}
	}
	if(user.getType()==3||user.getNo().equals(tc.getNo()))
	{
		if(teacher.getPwd()!=null&&!teacher.getPwd().trim().equals(""))
			tc.setPwd(teacher.getPwd().trim());
		if(teacher.getName()!=null&&!teacher.getName().trim().equals(""))
			tc.setName(teacher.getName().trim());
		if(teacher.getPhone()!=null&&!teacher.getPhone().trim().equals(""))
			tc.setPhone(teacher.getPhone().trim());
		this.getTeacherService().update(tc);
		user.setName(tc.getName());
		session.setAttribute("user",user);
		message="更新成功！";
		return "updateSuccess";
	}
	else
	{

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