基于javaweb的医院挂号管理系统(java+jsp+javascript+servlet+mysql)
运行环境
Java≥8、MySQL≥5.7、Tomcat≥8
开发工具
eclipse/idea/myeclipse/sts等均可配置运行
适用
课程设计,大作业,毕业设计,项目练习,学习演示等
功能说明
基于javaweb+mysql的医院挂号管理系统(java+JSP+JavaScript+Servlet+Mysql)
项目介绍
本项目分为前后台,有管理员、患者、医生三种角色;
管理员角色包含以下功能: 管理员登录,医生用户管理,修改密码,科室类别信息管理,医生信息管理,添加医生信息,查询医生信息,注册用户管理,黑名单管理,预约信息管理,查询预约信息,医生预约查询,预约信息统计,科室汇总统计等功能。 患者角色包含以下功能: 查看首页,患者登录,修改密码,修改个人资料,查看预约信息,查看医生信息,查看科室分类,医生查询,预约医生等功能。 医生角色包含以下功能: 医生登录,修改登录密码,修改个人信息,预约信息管理,查询预约信息等功能。
环境需要
1.运行环境:最好是java jdk 1.8,我们在这个平台上运行的。其他版本理论上也可以。 2.IDE环境:IDEA,Eclipse,Myeclipse都可以。推荐IDEA; 3.tomcat环境:Tomcat 7.x,8.x,9.x版本均可 4.硬件环境:windows 7/8/10 1G内存以上;或者 Mac OS; 5.数据库:MySql 5.7版本; 6.是否maven项目:否;
技术栈
JSP+CSS+JavaScript+servlet+mysql
使用说明
- 使用Navicat或者其它工具,在mysql中创建对应名称的数据库,并导入项目的sql文件; 2. 使用IDEA/Eclipse/MyEclipse导入项目,Eclipse/MyEclipse导入时,若为maven项目请选择maven; 若为maven项目,导入成功后请执行maven clean;maven install命令,然后运行; 3. 将项目中util/DBO.java配置文件中的数据库配置改为自己的配置; 4. 运行项目,输入localhost:8080/jsp_yiyuanguahaosys登录
管理员控制层:
/**
- 管理员登陆 增加 修改 删除 删除登陆日志
*/
public class AdminAction extends HttpServlet {
/**
- Constructor of the object.
*/
public AdminAction() {
super();
/**
- Destruction of the servlet.
*/
public void destroy() {
super.destroy(); // Just puts “destroy” string in log
// Put your code here
/**
- The doGet method of the servlet.
- This method is called when a form has its tag value method equals to get.
- @param request the request send by the client to the server
- @param response the response send by the server to the client
- @throws ServletException if an error occurred
- @throws IOException if an error occurred
*/
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
doPost(request,response);
/**
- The doPost method of the servlet.
- This method is called when a form has its tag value method equals to post.
- @param request the request send by the client to the server
- @param response the response send by the server to the client
- @throws ServletException if an error occurred
- @throws IOException if an error occurred
*/
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType(Constant.CONTENTTYPE);
request.setCharacterEncoding(Constant.CHARACTERENCODING);
try{
String method=request.getParameter(“method”).trim();
AdminBean loginbean = new AdminBean();
HttpSession session = request.getSession();
session.setMaxInactiveInterval(1200);
SystemBean systembean = new SystemBean();
String sysdir = systembean.getDir();
if(method.equals(“one”)){//admin登录
String username = request.getParameter(“username”);
String password = request.getParameter(“password”);String sf = request.getParameter(“sf”);
if(username == null||username.trim().equals(“”)){
request.setAttribute(“message”, “请正确输入用户名!”);
request.getRequestDispatcher(sysdir+“/login.jsp”).forward(request, response);
else if(password == null||password.trim().equals(“”)){
request.setAttribute(“message”, “请输入密码!”);
request.getRequestDispatcher(sysdir+“/login.jsp”).forward(request, response);
else{
ComBean cb=new ComBean();
String str=cb.getString(“select id from admin where username='”+username+“’ and password='”+password+“’ and sf='”+sf+“'”);
if(str!=null){
session.setAttribute(“user”, username);session.setAttribute(“sf”, sf);
request.getRequestDispatcher(“admin/index.jsp”).forward(request, response);
else{
request.setAttribute(“message”, “登录信息错误!”);
request.getRequestDispatcher(“admin/login.jsp”).forward(request, response);
else if(method.equals(“editpwd”)){//admin edit password
String username2 = (String)session.getAttribute(“user”);
if(username2 == null){
request.getRequestDispatcher(“error.jsp”).forward(request, response);
else{
String oldpwd = MD5.MD5(request.getParameter(“oldpwd”).trim());
String newpwd = MD5.MD5(request.getParameter(“newpwd”).trim());
String username = (String)session.getAttribute(“user”);
int flag = loginbean.editPassword(username, oldpwd, newpwd);
switch (flag){
case Constant.SUCCESS:
request.setAttribute(“message”, “密码修改成功!”);
request.getRequestDispatcher(sysdir+“/system/editpwd.jsp”).forward(request, response);
break;
case Constant.PASSWORD_ERROR:
request.setAttribute(“message”, “原始密码错误,请确认权限!”);
request.getRequestDispatcher(sysdir+“/system/editpwd.jsp”).forward(request, response);
break;
case Constant.SYSTEM_ERROR:
request.setAttribute(“message”, “系统维护中,请稍后再试!”);
request.getRequestDispatcher(sysdir+“/system/editpwd.jsp”).forward(request, response);
break;
else if(method.equals(“exit”)){//admin exit
session.removeAttribute(“user”);
session.removeAttribute(“sf”);
System.gc();
request.getRequestDispatcher(“index.jsp”).forward(request, response);
else if(method.equals(“manager”)){//add,update manager
String username = request.getParameter(“bh”).trim();
String password = MD5.MD5(request.getParameter(“password”).trim());
int flag = loginbean.addManager(username, password, “2”, “1”);
if(flag == Constant.SUCCESS){
request.setAttribute(“message”, “增加成功!”);
request.getRequestDispatcher(sysdir+“/system/user.jsp”).forward(request, response);
else if(flag == Constant.SAME_NAME){
request.setAttribute(“username”, username);
request.setAttribute(“message”, “该用户名已经存在!”);
request.getRequestDispatcher(sysdir+“/system/user.jsp”).forward(request, response);
else{
request.setAttribute(“message”, “系统维护中,请稍后再试!”);
request.getRequestDispatcher(sysdir+“/system/user.jsp”).forward(request, response);
else if(method.equals(“delm”)){//delete manager
String username2 = (String)session.getAttribute(“user”);
if(username2 == null){
request.getRequestDispatcher(“error.jsp”).forward(request, response);
else{
int id = Integer.parseInt(request.getParameter(“id”).trim());
if(id == 1){
request.setAttribute(“message”, “不能删除原始帐号!”);
request.getRequestDispatcher(sysdir+“/system/user.jsp”).forward(request, response);
else{
int flag = loginbean.delManager(id);
if(flag == Constant.SUCCESS){
request.setAttribute(“message”, “删除成功!”);
request.getRequestDispatcher(sysdir+“/system/user.jsp”).forward(request, response);
else{
request.setAttribute(“message”, “系统维护中,请稍后再试!”);
request.getRequestDispatcher(sysdir+“/system/user.jsp”).forward(request, response);
else if(method.equals(“dellog”)){//delete login note
String username2 = (String)session.getAttribute(“user”);
if(username2 == null){
request.getRequestDispatcher(“error.jsp”).forward(request, response);
else{
String check[] = request.getParameterValues(“checkit”);
if(check == null){
request.setAttribute(“message”, “请选择要删除的记录!”);
request.getRequestDispatcher(sysdir+“/system/log.jsp”).forward(request, response);
else{
int id[]= new int[check.length];
for(int i = 0;i<check.length;i++){
int s = Integer.parseInt(check[i]);
id[i] = s;
int flag = loginbean.delLog(id);
if(flag == Constant.SUCCESS){
request.setAttribute(“message”, “删除记录成功!”);
request.getRequestDispatcher(sysdir+“/system/log.jsp”).forward(request, response);
else{
request.setAttribute(“message”, “系统维护中,请稍后再试!”);
request.getRequestDispatcher(sysdir+“/system/log.jsp”).forward(request, response);
else{//无参数传入转到错误页面
request.getRequestDispatcher(“error.jsp”).forward(request, response);
}catch(Exception e){
e.printStackTrace();
request.getRequestDispatcher(“error.jsp”).forward(request, response);
/**
- Initialization of the servlet.
- @throws ServletException if an error occure
*/
public void init() throws ServletException {
// Put your code here
登录管理控制层:
public class LoginAction extends HttpServlet {
/**
- Constructor of the object.
*/
public LoginAction() {
super();
/**
- Destruction of the servlet.
*/
public void destroy() {
super.destroy(); // Just puts “destroy” string in log
// Put your code here
/**
- The doGet method of the servlet.
- This method is called when a form has its tag value method equals to get.
- @param request the request send by the client to the server
- @param response the response send by the server to the client
- @throws ServletException if an error occurred
- @throws IOException if an error occurred
*/
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
doPost(request,response);
/**
- The doPost method of the servlet.
- This method is called when a form has its tag value method equals to post.
- @param request the request send by the client to the server
- @param response the response send by the server to the client
- @throws ServletException if an error occurred
- @throws IOException if an error occurred
*/
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType(Constant.CONTENTTYPE);
request.setCharacterEncoding(Constant.CHARACTERENCODING);
HttpSession session = request.getSession();
MemberBean memberBean = new MemberBean();
String method = Filter.escapeHTMLTags(request.getParameter(“method”).trim());
if(method.equals(“PAGEUSERLOGIN”)){//登陆页面会员登陆
String username = Filter.escapeHTMLTags(request.getParameter(“username”).trim());
String password = Filter.escapeHTMLTags(request.getParameter(“password”).trim());
String reg_type = Filter.escapeHTMLTags(request.getParameter(“reg_type”).trim());
String lastip = request.getRemoteAddr();
int flag = memberBean.memberLogin(username, password, reg_type);
if(flag == Constant.SUCCESS){//登陆成功
String info = memberBean.getLastTimeIP(username);
int flag2 = memberBean.upmemberLogin(username, lastip);
if(flag2 == Constant.SUCCESS){
session.setAttribute(“member”, username);
session.setAttribute(“type”, reg_type);
session.setAttribute(“info”, info);
request.getRequestDispatcher(“member/index.jsp”).forward(request, response);
else{
session.setAttribute(“member”, username);
session.setAttribute(“type”, reg_type);
session.setAttribute(“info”, info);
session.setAttribute(“message”, “登陆成功,登陆信息更新失败!”);
request.getRequestDispatcher(“member/index.jsp”).forward(request, response);
else if(flag == Constant.NAME_ERROR){//用户名错误
request.setAttribute(“reg_user”, username);
request.setAttribute(“message”, “登录信息错误或已经被拉入黑名单!”);
request.getRequestDispatcher(“login.jsp”).forward(request, response);
else if(flag == Constant.PASSWORD_ERROR){//密码错误
request.setAttribute(“reg_user”, username);
request.setAttribute(“message”, “登录信息错误或已经被拉入黑名单!”);
request.getRequestDispatcher(“login.jsp”).forward(request, response);
else if(method.equals(“logout”)){//从iframe页面退出登陆
session.removeAttribute(“member”);
session.removeAttribute(“type”);
request.getRequestDispatcher(“login1.jsp”).forward(request, response);
else if(method.equals(“pagelogout”)||method.equals(“memberexit”)){//从网页退出登陆
session.removeAttribute(“member”);
session.removeAttribute(“type”);
request.getRequestDispatcher(“index.jsp”).forward(request, response);
else{
request.getRequestDispatcher(“error.jsp”).forward(request, response);
/**
- Initialization of the servlet.
- @throws ServletException if an error occure
*/
public void init() throws ServletException {
// Put your code here
用户管理控制层:
public class ComServlet extends HttpServlet {
/**
- Constructor of the object.
*/
public ComServlet() {
super();
/**
- Destruction of the servlet.
*/
public void destroy() {
super.destroy(); // Just puts “destroy” string in log
// Put your code here
/**
- The doGet method of the servlet.
- This method is called when a form has its tag value method equals to get.
- @param request the request send by the client to the server
- @param response the response send by the server to the client
- @throws ServletException if an error occurred
- @throws IOException if an error occurred
*/
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
doPost(request,response);
/**
- The doPost method of the servlet.
- This method is called when a form has its tag value method equals to post.
- @param request the request send by the client to the server
- @param response the response send by the server to the client
- @throws ServletException if an error occurred
- @throws IOException if an error occurred
*/
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType(Constant.CONTENTTYPE);
request.setCharacterEncoding(Constant.CHARACTERENCODING);
HttpSession session = request.getSession();
ComBean cBean = new ComBean();
String date2=new SimpleDateFormat(“yyyy-MM-dd”).format(Calendar.getInstance().getTime());
String method = request.getParameter(“method”);
if(method.equals(“addFenLei”)){ //增加科室 ------代码注释
String fl = request.getParameter(“bj”);
String str=cBean.getString(“select id from fenlei where fl='”+fl+“'”);
if(str==null){
int flag = cBean.comUp(“insert into fenlei(fl) values('”+fl+“')”);
if(flag == Constant.SUCCESS){
request.setAttribute(“message”, “操作成功!”);
request.getRequestDispatcher(“admin/ys/fenlei.jsp”).forward(request, response);
else {
request.setAttribute(“message”, “操作失败!”);
request.getRequestDispatcher(“admin/ys/fenlei.jsp”).forward(request, response);
else {
request.setAttribute(“message”, “科室重复!”);
request.getRequestDispatcher(“admin/ys/fenlei.jsp”).forward(request, response);
else if(method.equals(“delFenLei”)){ //删除科室
//hm xm dh zz zj sj sjzj lx bz
String id = request.getParameter(“id”);
int flag = cBean.comUp(“delete from fenlei where id='”+id+“'”);
if(flag == Constant.SUCCESS){
request.setAttribute(“message”, “操作成功!”);
request.getRequestDispatcher(“admin/ys/fenlei.jsp”).forward(request, response);
else {
request.setAttribute(“message”, “操作失败!”);
request.getRequestDispatcher(“admin/ys/fenlei.jsp”).forward(request, response);
else if(method.equals(“delmember”)){ //删除注册用户
//hm xm dh zz zj sj sjzj lx bz
String id = request.getParameter(“id”);
int flag = cBean.comUp(“delete from member where id='”+id+“'”);
if(flag == Constant.SUCCESS){
request.setAttribute(“message”, “操作成功!”);
request.getRequestDispatcher(“admin/member/person.jsp”).forward(request, response);
else {
request.setAttribute(“message”, “操作失败!”);
request.getRequestDispatcher(“admin/member/person.jsp”).forward(request, response);
else if(method.equals(“addpb”)){ //增加排班信息
String ys = request.getParameter(“ys”);
String ks = request.getParameter(“ks”);
String sj = request.getParameter(“sj”);
String xx = request.getParameter(“xx”);
String str=cBean.getString(“select id from pb where ys='”+ys+“’ and xx='”+xx+“'”);
if(str==null){
int flag = cBean.comUp(“insert into pb(ys,ks,sj,xx) values('”+ys+“‘,’”+ks+“‘,’”+sj+“‘,’”+xx+“')”);
if(flag == Constant.SUCCESS){
request.setAttribute(“message”, “操作成功!”);
request.getRequestDispatcher(“admin/pb/index.jsp”).forward(request, response);
else {
request.setAttribute(“message”, “操作失败!”);
request.getRequestDispatcher(“admin/pb/index.jsp”).forward(request, response);
else{
request.setAttribute(“message”, “时间冲突!”);
request.getRequestDispatcher(“admin/pb/index.jsp”).forward(request, response);
else if(method.equals(“uppb”)){ //修改排班信息
String id = request.getParameter(“id”);
String ys = request.getParameter(“ys”);
String ks = request.getParameter(“ks”);
String sj = request.getParameter(“sj”);
String xx = request.getParameter(“xx”);
String str=cBean.getString(“select ks from pb where ys='”+ys+“’ and xx='”+xx+“’ and id!='”+id+“'”);
if(str==null){
int flag = cBean.comUp(“update pb set ys='”+ys+“‘,ks=’”+ks+“‘,sj=’”+sj+“‘,xx=’”+xx+“’ where id='”+id+“'”);
if(flag == Constant.SUCCESS){
request.setAttribute(“message”, “操作成功!”);
request.getRequestDispatcher(“admin/pb/index.jsp”).forward(request, response);
else {
request.setAttribute(“message”, “操作失败!”);
request.getRequestDispatcher(“admin/pb/index.jsp”).forward(request, response);
else{
request.setAttribute(“message”, “时间冲突!”);
request.getRequestDispatcher(“admin/pb/index.jsp”).forward(request, response);
else if(method.equals(“delpb”)){ //删除排班信息
String id = request.getParameter(“id”);
int flag = cBean.comUp(“delete from pb where id='”+id+“'”);
if(flag == Constant.SUCCESS){
request.setAttribute(“message”, “操作成功!”);
request.getRequestDispatcher(“admin/pb/index.jsp”).forward(request, response);
else {
request.setAttribute(“message”, “操作失败!”);
request.getRequestDispatcher(“admin/pb/index.jsp”).forward(request, response);
else if(method.equals(“delys”)){ //删除 医生
//hm xm dh zz zj sj sjzj lx bz
String id = request.getParameter(“id”);
int flag = cBean.comUp(“delete from ys where id='”+id+“'”);
if(flag == Constant.SUCCESS){
request.setAttribute(“message”, “操作成功!”);
request.getRequestDispatcher(“admin/ys/index.jsp”).forward(request, response);
else {
request.setAttribute(“message”, “操作失败!”);
request.getRequestDispatcher(“admin/ys/index.jsp”).forward(request, response);
//预约
else if(method.equals(“gh”)){ //加入预约
String member=(String)session.getAttribute(“member”);
String ysid = request.getParameter(“ysid”);
String sj = request.getParameter(“sj”);
String xs = request.getParameter(“xs”);
String lxr = request.getParameter(“lxr”);
String lxfs = request.getParameter(“lxfs”);
String xm=cBean.getString(“select xm from ys where id='”+ysid+“'”);
String ks=cBean.getString(“select ks from ys where id='”+ysid+“'”);
String fy=cBean.getString(“select fy from ys where id='”+ysid+“'”);
String ysbh=cBean.getString(“select bh from ys where id='”+ysid+“'”);
long bh=System.currentTimeMillis();
int flag = cBean.comUp("insert into gh(ysid,xm,ks,sj,lxr,lxfs,tjsj,member,bh,fy,xs,ysbh) " +
“values('”+ysid+“‘,’”+xm+“‘,’”+ks+“‘,’”+sj+“‘,’”+lxr+“‘,’”+lxfs+“‘,’”+date2+“‘,’”+member+“‘,’”+bh+“‘,’”+fy+“‘,’”+xs+“‘,’”+ysbh+“')”);
if(flag == Constant.SUCCESS){
request.setAttribute(“message”, “操作成功,请在用户中心查看预约编号!”);
request.getRequestDispatcher(“ys.jsp”).forward(request, response);
else {
request.setAttribute(“message”, “操作失败!”);
request.getRequestDispatcher(“ys.jsp”).forward(request, response);
else if(method.equals(“delgh”)){ //删除预约
String id = request.getParameter(“id”);
int flag = cBean.comUp(“delete from gh where id='”+id+“'”);
if(flag == Constant.SUCCESS){
request.setAttribute(“message”, “操作成功!”);
request.getRequestDispatcher(“member/gh/index.jsp”).forward(request, response);
else {
request.setAttribute(“message”, “操作失败!”);
request.getRequestDispatcher(“member/gh/index.jsp”).forward(request, response);
else if(method.equals(“delgh2”)){ //删除预约
String id = request.getParameter(“id”);
int flag = cBean.comUp(“delete from gh where id='”+id+“'”);
if(flag == Constant.SUCCESS){
request.setAttribute(“message”, “操作成功!”);
request.getRequestDispatcher(“admin/gh/index.jsp”).forward(request, response);
else {
request.setAttribute(“message”, “操作失败!”);
request.getRequestDispatcher(“admin/gh/index.jsp”).forward(request, response);
else if(method.equals(“delgh3”)){ //删除预约
String id = request.getParameter(“id”);
int flag = cBean.comUp(“delete from gh where id='”+id+“'”);
if(flag == Constant.SUCCESS){
request.setAttribute(“message”, “操作成功!”);
request.getRequestDispatcher(“admin/gh/index2.jsp”).forward(request, response);
else {
request.setAttribute(“message”, “操作失败!”);
request.getRequestDispatcher(“admin/gh/index2.jsp”).forward(request, response);
else if(method.equals(“wcgh”)){ //删除预约
String id = request.getParameter(“id”);
int flag = cBean.comUp(“update gh set zt=‘已完成’ where id='”+id+“'”);
if(flag == Constant.SUCCESS){
request.setAttribute(“message”, “操作成功!”);
request.getRequestDispatcher(“admin/gh/index2.jsp”).forward(request, response);
else {
request.setAttribute(“message”, “操作失败!”);
request.getRequestDispatcher(“admin/gh/index2.jsp”).forward(request, response);
else if(method.equals(“hmd”)){ //删除预约
String id = request.getParameter(“id”);
String member=cBean.getString(“select member from gh where id='”+id+“'”);
int flag = cBean.comUp(“update member set hmd=‘是’ where username='”+member+“'”);
System.out.println(“update member set hmd=‘是’ where username='”+member+“'”);
if(flag == Constant.SUCCESS){
request.setAttribute(“message”, “操作成功!”);
request.getRequestDispatcher(“admin/gh/index2.jsp”).forward(request, response);
else {
request.setAttribute(“message”, “操作失败!”);
request.getRequestDispatcher(“admin/gh/index2.jsp”).forward(request, response);
/**
- Initialization of the servlet.
- @throws ServletException if an error occure
*/
public void init() throws ServletException {
// Put your code here