Java源码社

基于javaweb的JSP+Servlet医院管理系统(java+javaweb+jdbc+mysql+html+jsp)

更新于

运行环境

Java≥8、MySQL≥5.7、Tomcat≥8

开发工具

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

适用

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

功能说明

230023122402

240023122402

250023122402

功能介绍：

登录、注册、用户/管理员(角色)、用户信息管理、科系信息管理、查看所有科系、新增科系信息、删除指定科系、修改科系信息、病房信息管理、病人信息管理、医生类型管理、病人手术管理

基于javaweb的JSP+Servlet医院管理系统(java+javaweb+jdbc+mysql+html+jsp)

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
	case "delete_sc":
		delete_sc(request, response);break;
	case "alter_sc":
		alter_sc(request, response);break;
	default:
		break;
	}
}
/*-------------------------------- 用户 -----------------------------------*/
//查询所有用户
protected void query_all_user(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
	response.setContentType("text/html;charset=utf-8");
	UserDao userDao = new UserDao();
	
	ArrayList<User> results = userDao.query_all_user();
	PrintWriter out = response.getWriter();
	//输出结果
	if(results != null){
		out.write("<div class='all'>");
		out.write("<div><span>用户名</span><span>密码</span><span>权限级别</span></div>");
		for(User i: results){
			out.write("<div>");
			out.write("<span>"+i.getUsername()+"</span>");
			out.write("<span>"+i.getPassword()+"</span>");
			out.write("<span>"+i.getLevel()+"</span>");
			out.write("</div>");
		}
		out.write("</div>");
	}
	
	out.flush();
	out.close();
}
//插入用户
protected void insert_user(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
	response.setContentType("text/html;charset=utf-8");
	String username = request.getParameter("username");
	String password = request.getParameter("password");
	String level = request.getParameter("level");
	
	int flag =  new UserDao().insert_user(username, password, level);
	String info = null;
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

}
package service;



public class LoginServlet extends HttpServlet {
	private static final long serialVersionUID = 1L;

	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		request.setCharacterEncoding("utf-8");
		String username = request.getParameter("username");
		String password = request.getParameter("password");
		String level = null;
		//实例化UserDao对象
		UserDao userDao = new UserDao();
		User user = userDao.login(username, password);
		//判断是否登录成功
		if(user != null){//成功
			level = user.getLevel();
			//判断权限
			if(level.equals("用户")){
				//将用户对象放到session中
				request.getSession().setAttribute("user", user);
				//转发到user.jsp中
				request.getRequestDispatcher("user.jsp").forward(request, response);
			}
			else{
				//将管理员对象放到session中
				request.getSession().setAttribute("admin", user);
				//转发到admin.jsp中
				request.getRequestDispatcher("admin.jsp").forward(request, response);
			}	
		}else {
			//失败
			request.setAttribute("info"," 错误:用户名或密码错误！");
			request.getRequestDispatcher("message.jsp").forward(request, response);
		}
	}

}
package service;

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
	int flag = new SectionDao().alter_department(dno, after_dno, after_dname);
	String info = null;
	PrintWriter out = response.getWriter();
	if (flag == 1) {
		info = dno + "号系修改成功！";
	} else {
		info = "错误：修改院系失败!";
	}
	out.write("<div class='error'>");
	out.write("<div>" + info + "</div>");
	out.write("</div>");
	out.flush();
	out.close();
}

/*-------------------------------- 病房-----------------------------------*/
// 查询所有病房
protected void query_all_class(HttpServletRequest request, HttpServletResponse response)
		throws ServletException, IOException {
	response.setContentType("text/html;charset=utf-8");
	ArrayList<Room> results = new RoomDao().query_all_class();
	PrintWriter out = response.getWriter();
	//输出结果
	if (results != null) {
		out.write("<div class='all'>");
		out.write("<div><span>病房编号</span><span>病房名</span><span>所属科系</span></div>");
		for (Room i : results) {
			out.write("<div>");
			out.write("<span>" + i.getClno() + "</span>");
			out.write("<span>" + i.getClname() + "</span>");
			out.write("<span>" + i.getDname() + "</span>");
			out.write("</div>");
		}
		out.write("</div>");
	}
	out.flush();
	out.close();
}
// 插入病房
protected void insert_class(HttpServletRequest request, HttpServletResponse response)
		throws ServletException, IOException {
	response.setContentType("text/html;charset=utf-8");
	String clno = request.getParameter("clno");
	String clname = request.getParameter("clname");

	String dno = request.getParameter("dno");


	int flag = new RoomDao().insert_class(clno, clname, dno);
	String info = null;
	PrintWriter out = response.getWriter();
	if (flag == 1) {
		info = "病房"+clname+"插入成功！";
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
	response.setContentType("text/html;charset=utf-8");
	String clno = request.getParameter("clno");
	String after_clno = request.getParameter("after_clno");
	String after_clname = request.getParameter("after_clname");
	String after_dname = request.getParameter("after_dname");
	int flag = new RoomDao().alter_class(clno, after_clno, after_clname, after_dname);
	String info = null;
	PrintWriter out = response.getWriter();
	if (flag == 1) {
		info = "病房"+clno+"修改成功！";
	} else {
		info = "错误：修改病房失败!";
	}
	out.write("<div class='error'>");
	out.write("<div>" + info + "</div>");
	out.write("</div>");
	out.flush();
	out.close();
}

/*-------------------------------- 病人-----------------------------------*/
// 查询所有病人
protected void query_all_student(HttpServletRequest request, HttpServletResponse response)
		throws ServletException, IOException {
	response.setContentType("text/html;charset=utf-8");
	ArrayList<Patient> results = new PatientDao().query_all_student();
	PrintWriter out = response.getWriter();
	// 输出结果
	if (results != null) {
		out.write("<div class='all'>");
		out.write("<div><span>病人号</span><span>姓名</span><span>性别</span><span>年龄</span><span>所在病房</span></div>");
		for (Patient i : results) {
			out.write("<div>");
			out.write("<span>" + i.getSno() + "</span>");
			out.write("<span>" + i.getSname() + "</span>");
			out.write("<span>" + i.getSsex() + "</span>");
			out.write("<span>" + i.getSage() + "</span>");
			out.write("<span>" + i.getClname() + "</span>");
			out.write("</div>");
		}
		out.write("</div>");
	}
	out.flush();
	out.close();
}
// 插入病人
protected void insert_student(HttpServletRequest request, HttpServletResponse response)
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
/*-------------------------------- 医生 -----------------------------------*/
//查询所有医生
protected void query_all_course(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
	response.setContentType("text/html;charset=utf-8");
	ArrayList<Doctor> results = new DoctorDao().query_all_course();
	PrintWriter out = response.getWriter();
	if(results != null){
		//输出结果
		if(results != null){
			out.write("<div class='all'>");
			out.write("<div><span>医生号</span><span>类型名称</span><span>医生姓名</span><span>挂号费</span></div>");
			for(Doctor i:results) {
				out.write("<div>");
				out.write("<span>"+i.getCno()+"</span>");
				out.write("<span>"+i.getCname()+"</span>");
				out.write("<span>"+i.getCteacher()+"</span>");
				out.write("<span>"+i.getCcredit()+"</span>");
				out.write("</div>");
			}
			out.write("</div>");
		}
	}
	out.flush();
	out.close();
}
//插入医生
protected void insert_course(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
	response.setContentType("text/html;charset=utf-8");
	String Cno = request.getParameter("cno");
	String Cname = request.getParameter("cname");
	String Cteacher = request.getParameter("cteacher");
	int Ccredit = Integer.parseInt(request.getParameter("ccredit"));
	int flag =  new DoctorDao().insert_course(Cno, Cname, Cteacher, Ccredit);
	String info = null;
	PrintWriter out =  response.getWriter();
	if(flag == 1){
		info = "医生"+Cname+"插入成功！";
	}else{
		info = "错误：医生插入失败！";
	}
	out.write("<div class='error'>");
	out.write("<div>"+info+"</div>");
	out.write("</div>");
	out.flush();
	out.close();
}
//删除医生
protected void delete_course(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
	response.setContentType("text/html;charset=utf-8");

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