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

最新推荐文章于 2024-08-12 23:11:19 发布
最新推荐文章于 2024-08-12 23:11:19 发布
阅读量79 收藏
点赞数
文章标签： mysql java servlet
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/m0_71327920/article/details/132502391
版权

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

运行环境

Java≥8、MySQL≥5.7、Tomcat≥8

开发工具

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

适用

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

功能说明

功能介绍：

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

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

			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;
		PrintWriter out =  response.getWriter();
		if(flag == 1){
			info = "用户插入成功！";

		int flag = new OperationDao().insert_sc(sno, cno, grade);
		String info = null;
		PrintWriter out = response.getWriter();
		if (flag == 1) {
			info = sno + "号病人" + cno + "手术信息"+grade+"插入成功！";
		} else {
			info = "错误：手术信息插入失败！";
		}
		out.write("<div class='error'>");
		out.write("<div>" + info + "</div>");
		out.write("</div>");
		out.flush();
		out.close();
	}
	// 删除手术记录
	protected void delete_sc(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		response.setContentType("text/html;charset=utf-8");
		String sno = request.getParameter("sno");
		String cteacher = request.getParameter("cno");
		int flag = new OperationDao().delete_sc(sno, cteacher);
		String info = null;
		PrintWriter out = response.getWriter();
		if (flag == 1) {
			info = "成功删除" + sno + "号病人"+cteacher+"手术信息！";
		} else {
			info = "错误：删除手术信息失败！";
		}
		out.write("<div class='error'>");
		out.write("<div>" + info + "</div>");
		out.write("</div>");
		out.flush();
		out.close();
	}
	// 修改手术记录
	protected void alter_sc(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		response.setContentType("text/html;charset=utf-8");
		String sno = request.getParameter("sno");
		String cno = request.getParameter("cno");
		String after_grade = (request.getParameter("after_grade"));
		int flag = new OperationDao().alter_sc(sno, cno, after_grade);
		String info = null;
		PrintWriter out = response.getWriter();
		if (flag == 1) {
			info = sno + "号病人" + cno + "号手术记录修改成功！";
		} else {
			info = "错误：修改手术记录失败!";
		}
		out.write("<div class='error'>");
		out.write("<div>" + info + "</div>");
		out.write("</div>");

		String sno = request.getParameter("sno");
		String sname = request.getParameter("sname");
		String ssex = request.getParameter("ssex");
		int sage = Integer.parseInt(request.getParameter("sage"));
		String clno = request.getParameter("clno");
		int flag = new PatientDao().insert_student(sno, sname, ssex, sage, clno);
		String info = null;
		PrintWriter out = response.getWriter();
		if (flag == 1) {
			info = "病人"+sname+"插入成功！";
		} else {
			info = "错误：病人插入失败！";
		}
		out.write("<div class='error'>");
		out.write("<div>" + info + "</div>");
		out.write("</div>");
		out.flush();
		out.close();
	}
	// 删除病人
	protected void delete_student(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		response.setContentType("text/html;charset=utf-8");
		String sno = request.getParameter("sno");
		int flag = new PatientDao().delete_student(sno);
		String info = null;
		PrintWriter out = response.getWriter();
		if (flag == 1) {
			info = "成功删除" + sno + "号病人！";
		} else {
			info = "错误：删除病人失败！";
		}
		out.write("<div class='error'>");
		out.write("<div>" + info + "</div>");
		out.write("</div>");
		out.flush();
		out.close();
	}
	// 修改病人信息
	protected void alter_student(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		response.setContentType("text/html;charset=utf-8");

			throws ServletException, IOException {
		response.setContentType("text/html;charset=utf-8");
		String clno = request.getParameter("clno");
		int flag = new RoomDao().delete_class(clno);
		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 alter_class(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		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) {

			query_all_course(request, response);break;
		case "insert_course":
			insert_course(request, response);break;
		case "delete_course":
			delete_course(request, response);break;
		case "alter_course":
			alter_course(request, response);break;
		//手术操作
		case "query_all_sc":
			query_all_sc(request, response);break;
		case "insert_sc":
			insert_sc(request, response);break;
		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.write("<div class='error'>");
		out.write("<div>"+info+"</div>");
		out.write("</div>");
		out.flush();
		out.close();
	}
	//删除用户
	protected void delete_user(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		response.setContentType("text/html;charset=utf-8");
		String username = request.getParameter("username");
		
		int flag =  new UserDao().delete_user(username);
		String info = null;
		PrintWriter out =  response.getWriter();
		if(flag == 1){
			info = "成功删除名为"+username+"用户！";
		}else{
			info = "错误：删除用户失败！";
		}
		out.write("<div class='error'>");
		out.write("<div>"+info+"</div>");
		out.write("</div>");
		out.flush();
		out.close();
	}
	//修改用户
	protected void alter_user(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		response.setContentType("text/html;charset=utf-8");
		String username = request.getParameter("username");
		String after_username = request.getParameter("after_username");
		String after_password = request.getParameter("after_password");
		String after_level = request.getParameter("after_level");
		
		int flag =  new UserDao().alter_user(username,after_username,after_password,after_level);
		String info = null;
		PrintWriter out =  response.getWriter();
		if(flag == 1){
			info = "名为"+username+"用户信息修改成功！";
		}else{
			info = "错误：修改用户失败!";

			alter_student(request, response);break;
		//医生操作
		case "query_all_course":
			query_all_course(request, response);break;
		case "insert_course":
			insert_course(request, response);break;
		case "delete_course":
			delete_course(request, response);break;
		case "alter_course":
			alter_course(request, response);break;
		//手术操作
		case "query_all_sc":
			query_all_sc(request, response);break;
		case "insert_sc":
			insert_sc(request, response);break;
		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();
	}
	//插入用户

		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");
		String cno = request.getParameter("cno");
		int flag =  new DoctorDao().delete_course(cno);
		String info = null;
		PrintWriter out =  response.getWriter();
		if(flag == 1){
			info = "成功删除"+cno+"医生！";
		}else{
			info = "错误：删除医生失败！";
		}
		out.write("<div class='error'>");
		out.write("<div>"+info+"</div>");
		out.write("</div>");
		out.flush();
		out.close();
	}
	//修改医生信息
	protected void alter_course(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		response.setContentType("text/html;charset=utf-8");
		
		String cno = request.getParameter("cno");
		String after_cno = request.getParameter("after_cno");
		String after_cname = request.getParameter("after_cname");
		String after_cteacher = request.getParameter("after_cteacher");
		double after_ccredit = Double.parseDouble(request.getParameter("after_ccredit"));
		int flag = new DoctorDao().alter_course(cno, after_cno, after_cname, after_cteacher, after_ccredit);
		String info = null;
		PrintWriter out = response.getWriter();
		if (flag == 1) {
			info = cno + "号医生修改成功！";
		} else {
			info = "错误：修改医生信息失败!";
		}
		out.write("<div class='error'>");
		out.write("<div>" + info + "</div>");
		out.write("</div>");
		out.flush();


public class AdminDao extends HttpServlet {
	private static final long serialVersionUID = 1L;
    
	private String action;//存储操作描述
	//接收请求
	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		request.setCharacterEncoding("utf-8");
		action = request.getParameter("action");
		//判断所执行操作
		switch (action) {
		//用户操作
		case "query_all_user":
			query_all_user(request, response);break;
		case "insert_user":
			insert_user(request,response);break;
		case "delete_user":
			delete_user(request, response);break;
		case "alter_user":
			alter_user(request, response);break;
		//系别操作
		case "query_all_department":
			query_all_department(request, response);break;
		case "insert_department":
			insert_department(request, response);break;
		case "delete_department":
			delete_department(request, response);break;
		case "alter_department":
			alter_department(request, response);break;
		//病房操作
		case "query_all_class":
			query_all_class(request, response);break;
		case "insert_class":
			insert_class(request, response);break;	

			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;
		PrintWriter out =  response.getWriter();
		if(flag == 1){
			info = "用户插入成功！";
		}else{
			info = "错误：用户插入失败！";
		}
		out.write("<div class='error'>");
		out.write("<div>"+info+"</div>");
		out.write("</div>");
		out.flush();
		out.close();
	}
	//删除用户
	protected void delete_user(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		response.setContentType("text/html;charset=utf-8");
		String username = request.getParameter("username");
		
		int flag =  new UserDao().delete_user(username);
		String info = null;
		PrintWriter out =  response.getWriter();
		if(flag == 1){
			info = "成功删除名为"+username+"用户！";
		}else{
			info = "错误：删除用户失败！";
		}
		out.write("<div class='error'>");
		out.write("<div>"+info+"</div>");

		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+"插入成功！";
		} else {
			info = "错误：病房插入失败！";
		}
		out.write("<div class='error'>");
		out.write("<div>" + info + "</div>");
		out.write("</div>");
		out.flush();
		out.close();
	}
	// 删除病房
	protected void delete_class(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		response.setContentType("text/html;charset=utf-8");
		String clno = request.getParameter("clno");
		int flag = new RoomDao().delete_class(clno);


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);
		}
	}

}


				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+"插入成功！";
		} else {
			info = "错误：病房插入失败！";
		}
		out.write("<div class='error'>");
		out.write("<div>" + info + "</div>");
		out.write("</div>");
		out.flush();
		out.close();
	}
	// 删除病房
	protected void delete_class(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		response.setContentType("text/html;charset=utf-8");
		String clno = request.getParameter("clno");
		int flag = new RoomDao().delete_class(clno);
		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();

	private static final long serialVersionUID = 1L;
       
	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		
	}

	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 = request.getParameter("level");
		//实例化UserDao对象
		UserDao userDao = new UserDao();
		User user = userDao.register(username, password,level);
		//判断是否注册成功
		if(user != null){//成功
			if (level.equals("用户")) {
				request.getSession().setAttribute("user", user);//将用户对象放到session中
				//转发到user.jsp中
				request.getRequestDispatcher("user.jsp").forward(request, response);
			}else{
				request.getSession().setAttribute("admin", user);//将管理员对象放到session中
				//转发到user.jsp中
				request.getRequestDispatcher("admin.jsp").forward(request, response);
			}
		}else {//失败
			request.setAttribute("info"," 错误:已存在该用户,不能重复注册！");
			request.getRequestDispatcher("message.jsp").forward(request, response);
		}
	}

}

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

	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {


public class RegisterServlet extends HttpServlet {
	private static final long serialVersionUID = 1L;
       
	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		
	}

	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 = request.getParameter("level");
		//实例化UserDao对象
		UserDao userDao = new UserDao();
		User user = userDao.register(username, password,level);
		//判断是否注册成功
		if(user != null){//成功
			if (level.equals("用户")) {
				request.getSession().setAttribute("user", user);//将用户对象放到session中
				//转发到user.jsp中
				request.getRequestDispatcher("user.jsp").forward(request, response);
			}else{
				request.getSession().setAttribute("admin", user);//将管理员对象放到session中
				//转发到user.jsp中
				request.getRequestDispatcher("admin.jsp").forward(request, response);
			}
		}else {//失败
			request.setAttribute("info"," 错误:已存在该用户,不能重复注册！");
			request.getRequestDispatcher("message.jsp").forward(request, response);
		}
	}

}


				request.getRequestDispatcher("user.jsp").forward(request, response);
			}else{
				request.getSession().setAttribute("admin", user);//将管理员对象放到session中
				//转发到user.jsp中
				request.getRequestDispatcher("admin.jsp").forward(request, response);
			}
		}else {//失败
			request.setAttribute("info"," 错误:已存在该用户,不能重复注册！");
			request.getRequestDispatcher("message.jsp").forward(request, response);
		}
	}

}

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中

		case "alter_student":
			alter_student(request, response);break;
		//医生操作
		case "query_all_course":
			query_all_course(request, response);break;
		case "insert_course":
			insert_course(request, response);break;
		case "delete_course":
			delete_course(request, response);break;
		case "alter_course":
			alter_course(request, response);break;
		//手术操作
		case "query_all_sc":
			query_all_sc(request, response);break;
		case "insert_sc":
			insert_sc(request, response);break;
		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>");
		}
		

	// 查询所有病房
	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+"插入成功！";
		} else {
			info = "错误：病房插入失败！";
		}
		out.write("<div class='error'>");
		out.write("<div>" + info + "</div>");
		out.write("</div>");
		out.flush();
		out.close();

请添加图片描述
请添加图片描述
请添加图片描述

m0_71327920
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
基于javaweb的医院管理系统(java+javaweb+jdbc+Mysql+lw)
m0_71096470的博客
05-18 463
功能介绍： 登录、注册、用户/管理员(角色)、用户信息管理、科系信息管理、查看所有科系、新增科系信息、删除指定科系、修改科系信息、病房信息管理、病人信息管理、医生类型管理、病人手术管理 适用 课程设计，大作业，毕业设计，项目练习，学习演示等 } } 管理员服务类： public class AdminDao extends HttpServlet { private static final long serialVersionUID = 1L; private String actio
Java项目:医院预约挂号系统(java+jdbc+jsp+mysql+ajax)
常年被追砍的博客
07-08 894
一、项目简述 功能： 用户分为患者，医生，管理员，患者可进行注册选择医生 挂号，选择日期，选择号源，医生可进行接诊，管理员可 对用户，医生信息的维护等等功能。 二、项目运行 环境配置： Jdk1.8 + Tomcat8.5 + mysql + Eclispe (IntelliJ IDEA,Eclispe,MyEclispe,Sts 都支持) 项目技术： Jdbc+ Servlert + Jsp + css + JavaScript + JQuery + Ajax + Fileupload等等..
基于javaweb的his智能医院管理系统(java+springboot+vue+mybatis+mysql)
m0_69593263的博客
10-24 1720
基于javaweb的his智能医院管理系统(java+springboot+vue+mybatis+mysql) 运行环境 Java≥8、MySQL≥5.7、Node.js≥10 开发工具 后端：eclipse/idea/myeclipse/sts等均可配置运行 前端：WebStorm/VSCode/HBuilderX等均可 适用 课程设计，大作业，毕业设计，项目练习，学习演示等
基于javaweb的医院门诊查询系统（前端+后端）
qq_43485489的博客
08-09 1303
基于javaweb的医院门诊查询系统（前端+后端），采用eclipse开发工具，结合前端layui+jquery+css，使用jsp+ssm技术进行编写，数据库采用了mysql，navicat作为管理工具。感兴趣的同学可以交流交流！！！！.........
基于javaweb+mysql的jsp+servlet医院挂号管理系统(java+jsp+javascript+servlet+mysql)
m0_71097188的博客
07-31 141
管理员角色包含以下功能： 管理员登录,医生用户管理,修改密码,科室类别信息管理,医生信息管理,添加医生信息,查询医生信息,注册用户管理,黑名单管理,预约信息管理,查询预约信息,医生预约查询,预约信息统计,科室汇总统计等功能。患者角色包含以下功能： 查看首页,患者登录,修改密码,修改个人资料,查看预约信息,查看医生信息,查看科室分类,医生查询,预约医生等功能。医生角色包含以下功能： 医生登录,修改登录密码,修改个人信息,预约信息管理,查询预约信息等功能。课程设计，大作业，毕业设计，项目练习，学习演示等。
基于 Servlet+jsp+mysql 开发 javaWeb 学生宿舍管理系统
06-02
基于 Servlet+jsp+mysql 开发 javaWeb 学生宿舍管理系统基于 Servlet+jsp+mysql 开发 javaWeb 学生宿舍管理系统基于 Servlet+jsp+mysql 开发 javaWeb 学生宿舍管理系统基于 Servlet+jsp+mysql 开发 javaWeb 学生宿舍...
Java+Servlet+Jdbc+Jsp+Mysql实现Web学生信息管理系统
07-16
在本项目中，"Java+Servlet+Jdbc+Jsp+Mysql实现Web学生信息管理系统"，开发者利用了Java后端技术、Servlet、JDBC、JSP以及MySQL数据库来构建一个完整的Web应用，用于管理学生信息。以下是这些技术在系统中的具体应用...
Java项目:电影院售票管理系统(java+Servlet+JSP+JDBC+Mysql)
07-09
这个项目是一个基于Servlet+JSP的电影院售票系统，分为管理员和会员两种角色。 管理员权限包括： 修改登录密码 电影类别管理 电影信息管理 会员信息管理 订单信息管理 留言信息管理 会员权限包括： 会员注册 ...
Java项目:医院管理系统(java+javaweb+jdbc+Mysql+lw)
01-10
本项目基于Java技术栈，结合javaweb、jdbc、Mysql数据库以及轻量级框架lw，旨在构建一个功能完善的医院管理系统。下面我们将详细探讨该项目涉及的技术知识点及其应用。 首先，Java作为后端开发的主要语言，以其跨...
基于java+mysql+JDBC+tomcat+Servlet+JSP+js的学生管理系统
08-31
基于java+mysql+JDBC+tomcat+Servlet+JSP+js的学生管理系统源码，包括所有的代码，以及后面新增的成绩管理也在这上面，也是简单的crud，给初学者一些参考，有不足的地方请指出，这个适合于学习完javaweb或者正的同学...
基于javaweb+mysql的springboothis智能医院管理系统(java+springboot+vue+maven+mybatis+mysql)
m0_71098312的博客
07-24 413
基于javaweb+mysql的springboothis智能医院管理系统(java+springboot+vue+maven+mybatis+mysql)基于javaweb+mysql的SpringBoothis智能医院管理系统(java+springboot+vue+maven+mybatis+mysql)Spring + SpringBoot+ mybatis + Maven + Vue 等等组成，B/S模式 + Maven管理等等。课程设计，大作业，毕业设计，项目练习，学习演示等。
基于javaweb+mysql的ssm医院住院信息管理系统(java+ssm+maven+jsp+mysql)
m0_71414463的博客
08-15 285
项目技术： JSP ++ MyBatis + Bootstrap+ Css + JavaScript + JQuery + Ajax + Maven等等。本系统功能包括：实现了挂号收费，门诊管理，划价收 费，药房取药，体检管理，药房管理，系统维护等各个模块功能，非常不错。基于javaweb+mysql的ssm医院住院信息管理系统(java+ssm+maven+jsp+mysql)基于javaweb+mysql的SSM医院住院信息管理系统(java+ssm+maven+jsp+mysql)
【计算机毕业设计】基于Web的社区医院管理服务系统
weixin_63982010的博客
10-23 82
在Internet高速发展的今天，我们生活的各个领域都涉及到计算机的应用，其中包括社区医院管理服务系统的网络应用，在外国线上管理系统已经是很普遍的方式，不过国内的管理系统可能还处于起步阶段。社区医院管理服务系统具有社区医院信息管理功能的选择。社区医院管理服务系统采用java技术，基于springboot框架，mysql数据库进行开发，实现了首页、个人中心、用户管理、医生管理、预约医生管理、就诊信息管理、诊疗方案管理、病历信息管理、健康档案管理、费用信息管理、系统管理等内容进行管理。
springboot基于Web的社区医院管理服务系统
2301_77732240的博客
04-23 202
健康档案管理，在健康档案管理页面可以对索引、用户账号、用户姓名、性别、年龄、用户电话、头像、药物过敏、重大病史、家族病史、登记时间、医生账号、医生姓名等内容进行详情、修改或删除等操作，如图所示。预约医生管理，在预约医生管理页面中可以对索引、预约编号、医生账号、医生姓名、预约时间、科室、用户账号、用户姓名、审核回复、审核状态、审核等内容进行详情、就诊、修改或删除等操作，如图所示。用户管理，在用户管理页面中可以对索引、用户账号、 用户姓名、性别、用户电话、年龄、头像等内容进行详情、修改或删除等操作，如图所示。
基于javaweb+mysql的springboot医院管理系统(java+springboot+ssm+mysql+maven+thymeleaf+html)
m0_71097188的博客
07-27 529
本系统重点是门诊和住院管理 填写患者的详细信息，如姓名，年龄、手机号、性别、身 份证号、选择科室挂号类型医生、会出来相对的挂号费， 点击提交的时候会判断你输入的各项信息是否正确，如果 该手机号或者该身份证号正在就诊，则会提示该手机号或 者该身份证号正在就诊。科室中心管理、医生列表管理、药品产地管理、项目大类 管理、挂号类型管理、仓库管理、经办人管理、供货商管 理、药品分类管理、药品字典管理。项目分为门诊管理、住院管理、系统管理、统计管理、数 据中心、排班管理、仓库管理、药房管理。
基于WEB网页的医院病历管理系统的开发与应用 计算机毕设源码62176
weixin_ZYKJ985的博客
10-05 392
本选题则旨在通过标签分类管理等方式，实现后台首页，系统用户（管理员，医生，普通用户），权限管理，模块管理（科室，病历信息，年龄分布，申请查看，病历查看，工作量，就诊量）等系统管理功能从而实现实现线上快捷方便的对医院病历信息进行管理的需求.....
SpringBoot依赖之Quartz Scheduler定时调度器使用MySQL存储Job
ahauedu的专栏
08-07 631
接上一篇。本篇将在 Spring Boot 项目中，使用 Quartz Scheduler 结合 MySQL 数据库来存储 Job。
CVE-2012-2122 mysql/mariaDB身份认证漏洞
最新发布
weixin_68177269的博客
08-12 101
当连接MariaDB/MySQL时，输入的密码会与期望的正确密码比较，不断的尝试登录连接，回导致MySQL认为两个密码是相同的。也就是说只要知道用户名，不断尝试就能够直接登入SQL数据库。影响范围#所有的Mariadb和mysql版本:5.1.61、5.0.11、5.3.5、5.5.22。可见经过大数量的暴力登录之后，直接不需要密码登录到mysql。使用docker-compose 创建靶场环境。下载安装vulhub靶场环境。二、msf漏洞scan探测。不知道为什么没跑出来🥴。
mysql 日志爆满，删除日志文件，定时清理日志
minihuabei的博客
08-08 1136
今天发现网站不能正常访问，于是登陆服务器查找问题。机智的我随手用命令：df -l 发现 硬盘爆满了，于是就知道问题所在了。然后通过命令 du -sh * 一路检查，发现mysql的日志文件占据了大部分空间 , 整整27G，于是现在的任务就是清理mysql的日志文件（主要是清理.log文件和mysql-bin.00000X二进制日志文件）
JavaWeb学生考勤管理系统实操：JDBC+Spring+JSP+MySQL
- MySQL：作为关系型数据库管理系统，是项目中数据存储和查询的主要工具。 - Servlet：作为Java Web应用的核心组成部分，负责处理HTTP请求，实现服务器端的业务逻辑。 整个学生考勤管理系统的设计，不仅涉及了Java...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值