Java项目:医院管理系统(java+javaweb+jdbc+Mysql+lw)

package service; import java.io.IOException; import java.io.PrintWriter; import java.util.ArrayList; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import dao.RoomDao; import dao.DoctorDao; import dao.SectionDao; import dao.OperationDao; import dao.PatientDao; import dao.UserDao; import model.Room; import model.Doctor; import model.Section; import model.Operation; import model.Patient; import model.User; 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; case "delete_class": delete_class(request, response);break; case "alter_class": alter_class(request, response);break; //病人操作 case "query_all_student": query_all_student(request, response);break; case "insert_student": insert_student(request, response);break; case "delete_student": delete_student(request, response);break; 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>"); } 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>"); 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 = "错误：修改用户失败!"; } out.write("<div class='error'>"); out.write("<div>"+info+"</div>"); out.write("</div>"); out.flush(); out.close(); } /*-------------------------------- 院系-----------------------------------*/ // 查询所有院系 protected void query_all_department(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { response.setContentType("text/html;charset=utf-8"); ArrayList<Section> results = new SectionDao().query_all_department(); PrintWriter out = response.getWriter(); // 输出结果 if (results != null) { out.write("<div class='all'>"); out.write("<div><span>系编号</span><span>系名</span></div>"); for (Section i : results) { out.write("<div>"); out.write("<span>" + i.getDno() + "</span>"); out.write("<span>" + i.getDname() + "</span>"); out.write("</div>"); } out.write("</div>"); } out.flush(); out.close(); } // 插入院系 protected void insert_department(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { response.setContentType("text/html;charset=utf-8"); String dno = request.getParameter("dno"); String dname = request.getParameter("dname"); int flag = new SectionDao().insert_department(dno, dname); String info = null; PrintWriter out = response.getWriter(); if (flag == 1) { info = "院系"+dname+"插入成功！"; } else { info = "错误：院系插入失败！"; } out.write("<div class='error'>"); out.write("<div>" + info + "</div>"); out.write("</div>"); out.flush(); out.close(); } // 删除院系 protected void delete_department(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { response.setContentType("text/html;charset=utf-8"); String dno = request.getParameter("dno"); int flag = new SectionDao().delete_department(dno); 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 alter_department(HttpServletRequest request, HttpServletResponse response) t