基于javaweb的医院管理系统(java+javaweb+jdbc+Mysql+lw)
功能介绍:
登录、注册、用户/管理员(角色)、用户信息管理、科系信息管理、查看所有科系、新增科系信息、删除指定科系、修改科系信息、病房信息管理、病人信息管理、医生类型管理、病人手术管理
适用
课程设计,大作业,毕业设计,项目练习,学习演示等
} 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("<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 dname = request.getParameter("dname");
int flag = new RoomDao().insert_class(clno, clname, dname);
String info = null;
PrintWriter out = response.getWriter();
}
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("<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>");
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 = "错误:用户插入失败!";
}
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");
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 = "错误:删除手术信息失败!";
}
// 查询所有手术安排
protected void query_all_sc(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("text/html;charset=utf-8");
ArrayList<Operation> results = new OperationDao().query_all_sc();
PrintWriter out = response.getWriter();
// 输出结果
if (results != null) {
out.write("<div id='all_sc' class='all'>");
out.write("<div><span>病人号</span><span>姓名</span><span>性别</span><span>年龄</span><span>医生名</span><span>医生类型</span><span>手术时间</span></div>");
for (Operation 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.getCteacher() + "</span>");
out.write("<span>" + i.getCname() + "</span>");
out.write("<span>" + i.getGrade() + "</span>");
out.write("</div>");
}
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();
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;