基于javaweb+mysql的jsp+servlet医院预约挂号系统(java+jdbc+jsp+mysql+ajax)
运行环境
Java≥8、MySQL≥5.7、Tomcat≥8
开发工具
eclipse/idea/myeclipse/sts等均可配置运行
适用
课程设计,大作业,毕业设计,项目练习,学习演示等
功能说明
基于javaweb+mysql的JSP+Servlet医院预约挂号系统(java+jdbc+jsp+mysql+ajax)
一、项目简述
功能: 用户分为患者,医生,管理员,患者可进行注册选择医生 挂号,选择日期,选择号源,医生可进行接诊,管理员可 对用户,医生信息的维护等等功能。
二、项目运行
环境配置: Jdk1.8 + Tomcat8.5 + mysql + Eclispe (IntelliJ IDEA,Eclispe,MyEclispe,Sts 都支持)
项目技术: Jdbc+ Servlert + Jsp + css + JavaScript + JQuery + Ajax + Fileupload等等。
}
request.setAttribute("message",message);
request.getRequestDispatcher("register.jsp").forward(request,response);
}
}
@WebServlet(urlPatterns = "/DoctorSearch")
public class DoctorSearch extends HttpServlet {
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
doGet(request,response);
}
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
request.setCharacterEncoding("UTF-8");
//从前端得到数据
String office = Util.nullToString(request.getParameter("office"));
String name = Util.nullToString(request.getParameter("doctor"));
int start = Util.nullToZero(request.getParameter("start"));
DoctorDao doctorDao=new DoctorDao();
//数据库查询语句
String where="where office like ? and dname like ? ";
//获取结果数量
int total=doctorDao.getDoctorCount(where,new Object[]{Util.toLike(office),Util.toLike(name)});
//页数
Pages pages = new Pages(start , total, 6);
where+=" limit "+((pages.getCurrentPage()-1)*6)+",6";
//根据页号显示结果
String message="";
OfficeDao officeDao=new OfficeDao();
List<com.qst.bean.Office> offices;
switch (action){
case "add":
String officename = request.getParameter("officename");
String description = request.getParameter("description");
offices= officeDao.query("officename", officename,"");
if(offices.size()==0){
com.qst.bean.Office office = new com.qst.bean.Office(officename, description, 0);
if(officeDao.insert(office)){
message=officename+"添加成功!";
}else {
message=officename+"添加失败!";
}
}else {
message=officename+"已存在!";
}
request.setAttribute("message",message);
//req.getRequestDispatcher("admin/office.jsp").forward(req,resp);
break;
case "query":
offices = officeDao.query("officename", "","");
JSONArray array=new JSONArray();
for(com.qst.bean.Office office:offices){
JSONObject jsonObject=new JSONObject();
jsonObject.put("officename",office.getOfficename());
jsonObject.put("description",office.getDescription());
jsonObject.put("doctornum",office.getDoctornum());
array.add(jsonObject);
}
response.setContentType("application/json; charset=utf-8");
response.getWriter().write(array.toString());
return;
}
String office= Util.nullToString(request.getParameter("office"));
int start=Util.nullToZero(request.getParameter("start"));
Pages p = new Pages(start , officeDao.getOfficeCount("officename", office),10);
String limit="limit "+((p.getCurrentPage()-1)*10)+",10";
offices = officeDao.query("officename", office,limit);
request.setAttribute("offices",offices);
request.setAttribute("office",office);
request.setAttribute("pages",p);
request.getRequestDispatcher("/doctor/patientList.jsp").forward(request,response);
}
}
@WebServlet(urlPatterns = "/orderList")
public class OrderList extends HttpServlet {
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
doGet(request,response);
}
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
request.setCharacterEncoding("UTF-8");
Patient patient= (Patient) request.getSession().getAttribute("patient");
// RecodeDao recodeDao = new RecodeDao();
// DoctorDao doctorDao=new DoctorDao();
// String where="where pid=? order by ordertime desc";
// String where1="where pid=? order by ordertime desc";
// List<Recode> Recodelist = recodeDao.query(where, new Object[]{patient.getId()});
// List<Doctor> DoctorList= doctorDao.query(where,)
// // List<HashMap<String, String>> list = recodeDao.orderList(patient.getId());
// request.setAttribute("list",list);
RecodeDao recodeDao=new RecodeDao();
List<HashMap<String, String>> list = null;
try {
list = recodeDao.orderList1(patient.getId());
} catch (SQLException e) {
@MultipartConfig
@WebServlet(urlPatterns = "/doctor/myInfo")
public class MyInfo extends HttpServlet {
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
doGet(request,response);
}
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// com.jspsmart.upload.SmartUpload su = new com.jspsmart.upload.SmartUpload();
// su.initialize(pageContext);
// su.service(request, response);
// su.setTotalMaxFileSize(100000000);
// su.setAllowedFilesList("zip,rar");
// su.setDeniedFilesList("exe,bat,jsp,htm,html,,");
// su.upload();
DoctorDao doctorDao=new DoctorDao();
Doctor doctor = (Doctor) request.getSession().getAttribute("doctor");
String action = Util.nullToString(request.getParameter("action"));
String name1 = request.getParameter("name");
String age1 = request.getParameter("age");
System.out.println("name"+name1);
System.out.println("age"+age1);
System.out.println("action"+action);
if("alter".equals(action)){
String name = request.getParameter("name");
String age = request.getParameter("age");
String description = request.getParameter("description");
doctor.setDname(name);
doctor.setAge(age);
doctor.setDescription(description);
// Part part;
String set="set dname=?,age=?,description=? where did=?";
doctorDao.update(set,o);
}
request.getRequestDispatcher("/doctor/myInfo.jsp").forward(request,response);
}
}
@WebServlet(urlPatterns = "/office")
public class OfficeManager extends HttpServlet {
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
doGet(request,response);
}
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String action = Util.nullToString(request.getParameter("action"));
String message="";
OfficeDao officeDao=new OfficeDao();
List<com.qst.bean.Office> offices;
switch (action){
case "add":
String officename = request.getParameter("officename");
String description = request.getParameter("description");
offices= officeDao.query("officename", officename,"");
if(offices.size()==0){
com.qst.bean.Office office = new com.qst.bean.Office(officename, description, 0);
if(officeDao.insert(office)){
message=officename+"添加成功!";
}else {
message=officename+"添加失败!";
}
}else {
message=officename+"已存在!";
}
request.setAttribute("message",message);
//req.getRequestDispatcher("admin/office.jsp").forward(req,resp);
break;
// // List<HashMap<String, String>> list = recodeDao.orderList(patient.getId());
// request.setAttribute("list",list);
RecodeDao recodeDao=new RecodeDao();
List<HashMap<String, String>> list = null;
try {
list = recodeDao.orderList1(patient.getId());
} catch (SQLException e) {
e.printStackTrace();
}
request.setAttribute("list",list);
request.getRequestDispatcher("orderList.jsp").forward(request,response);
}
}
@WebFilter("/*")
public class MyFilter implements Filter {
private ArrayList<String> patient;
@Override
public void init(FilterConfig filterConfig) throws ServletException {
patient=new ArrayList<>();
patient.add("/order");
patient.add("/orderList");
}
@Override
public void doFilter(ServletRequest servletRequest, ServletResponse servletResponse, FilterChain filterChain) throws IOException, ServletException {
HttpServletRequest req = (HttpServletRequest) servletRequest;
servletRequest.setCharacterEncoding("utf-8");
servletResponse.setCharacterEncoding("utf-8");
servletResponse.setContentType("text/html;charset=utf-8");
// 得到用户请求的URI
// 得到web应用程序的上下文路径
// 去除上下文路径,得到剩余部分的路径
String uri = req.getRequestURI().substring(req.getContextPath().length());//请求的页面
String url=req.getHeader("referer");//之前的页面
if(req.getSession().getAttribute("patient")==null&&patient.contains(uri)){
req.getSession().setAttribute("message","请先登录!");
req.getSession().setAttribute("url",url);
// System.out.println(req.getSession().getAttribute("url"));
HttpServletResponse resp= (HttpServletResponse) servletResponse;
String name1 = request.getParameter("name");
String age1 = request.getParameter("age");
System.out.println("name"+name1);
System.out.println("age"+age1);
System.out.println("action"+action);
if("alter".equals(action)){
String name = request.getParameter("name");
String age = request.getParameter("age");
String description = request.getParameter("description");
doctor.setDname(name);
doctor.setAge(age);
doctor.setDescription(description);
// Part part;
// part = request.getPart("pic");
// if(part.getSize()>0&&part.getSize()<1024*1024){
// System.out.println(part.getSubmittedFileName());
// String fileName = part.getSubmittedFileName();
// String jpg=fileName.substring(fileName.lastIndexOf("."));
// System.out.println(jpg);
// InputStream is=part.getInputStream();
// String realPath = this.getServletContext().getRealPath("images/docpic");
// System.out.println(realPath);
// FileOutputStream fos = new FileOutputStream(realPath+"/"+doctor.getDid()+jpg);
// byte[] bytes=new byte[1024];
// int i=0;
// while ((i=is.read(bytes))!=-1){
// fos.write(bytes,0,i);
// }
// fos.close();
// is.close();
// doctor.setPicpath("/mavenHospital/images/docpic/"+doctor.getDid()+jpg);
// System.out.println(doctor.getPicpath());
// }
Object[] o=new Object[]{
doctor.getDname(),
doctor.getAge(),
doctor.getDescription(),
doctor.getDid()};
String set="set dname=?,age=?,description=? where did=?";
@WebServlet(urlPatterns= "/patientList")
public class PatientList extends HttpServlet {
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
doGet(request,response);
}
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String action = Util.nullToString(request.getParameter("action"));
Doctor doctor = (Doctor) request.getSession().getAttribute("doctor");
String rid = Util.nullToString(request.getParameter("rid"));
String pid = Util.nullToString(request.getParameter("pid"));
RecodeDao recodeDao = new RecodeDao();
// IntegrityDao integrityDao = new IntegrityDao();
// Integrity integrity;
String set;
switch (action){
case "finish":
set = "set state ='完成' where rid=?";
recodeDao.update(set,new Object[]{rid});
// integrity = new Integrity("", pid, doctor.getDname(), doctor.getOffice(), "", "完成预约", "10");
// integrityDao.insert(integrity);
break;
case "sy":
set = "set state ='爽约' where rid=?";
recodeDao.update(set,new Object[]{rid});
// integrity = new Integrity("", pid, doctor.getDname(), doctor.getOffice(), "", "爽约", "-10");
// integrityDao.insert(integrity);
break;
}
PatientDao patientDao = new PatientDao();
ArrayList<HashMap<String, String>> list = patientDao.patientList(doctor.getDid());
request.setAttribute("list",list);
request.getRequestDispatcher("/doctor/patientList.jsp").forward(request,response);
}
}
@WebServlet(urlPatterns = "/office")
public class OfficeManager extends HttpServlet {
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
doGet(request,response);
}
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String action = Util.nullToString(request.getParameter("action"));
String message="";
OfficeDao officeDao=new OfficeDao();
List<com.qst.bean.Office> offices;
switch (action){
case "add":
String officename = request.getParameter("officename");
String description = request.getParameter("description");
offices= officeDao.query("officename", officename,"");
if(offices.size()==0){
com.qst.bean.Office office = new com.qst.bean.Office(officename, description, 0);
if(officeDao.insert(office)){
message=officename+"添加成功!";
}else {
message=officename+"添加失败!";
}
}else {
message=officename+"已存在!";
}
request.setAttribute("message",message);
//req.getRequestDispatcher("admin/office.jsp").forward(req,resp);
break;
case "query":
offices = officeDao.query("officename", "","");
JSONArray array=new JSONArray();
for(com.qst.bean.Office office:offices){
JSONObject jsonObject=new JSONObject();
jsonObject.put("officename",office.getOfficename());
jsonObject.put("description",office.getDescription());
jsonObject.put("doctornum",office.getDoctornum());
array.add(jsonObject);
}
response.setContentType("application/json; charset=utf-8");
response.getWriter().write(array.toString());
return;
}
String office= Util.nullToString(request.getParameter("office"));
int start=Util.nullToZero(request.getParameter("start"));
Pages p = new Pages(start , officeDao.getOfficeCount("officename", office),10);
String limit="limit "+((p.getCurrentPage()-1)*10)+",10";
offices = officeDao.query("officename", office,limit);
recodeDao.update(set,new Object[]{rid});
// integrity = new Integrity("", pid, doctor.getDname(), doctor.getOffice(), "", "爽约", "-10");
// integrityDao.insert(integrity);
break;
}
PatientDao patientDao = new PatientDao();
ArrayList<HashMap<String, String>> list = patientDao.patientList(doctor.getDid());
request.setAttribute("list",list);
request.getRequestDispatcher("/doctor/patientList.jsp").forward(request,response);
}
}
@WebServlet(urlPatterns = "/orderList")
public class OrderList extends HttpServlet {
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
doGet(request,response);
}
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
request.setCharacterEncoding("UTF-8");
Patient patient= (Patient) request.getSession().getAttribute("patient");
// RecodeDao recodeDao = new RecodeDao();
// DoctorDao doctorDao=new DoctorDao();
// String where="where pid=? order by ordertime desc";
// String where1="where pid=? order by ordertime desc";
// List<Recode> Recodelist = recodeDao.query(where, new Object[]{patient.getId()});
// List<Doctor> DoctorList= doctorDao.query(where,)
// // List<HashMap<String, String>> list = recodeDao.orderList(patient.getId());
// request.setAttribute("list",list);
RecodeDao recodeDao=new RecodeDao();
List<HashMap<String, String>> list = null;
public class Login extends HttpServlet{
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
doGet(request, response);
}
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
request.setCharacterEncoding("UTF-8");
String account = request.getParameter("account");
String password = request.getParameter("password");
String accounttype = request.getParameter("accounttype");
request.getSession().removeAttribute("message");
// request.getSession().setAttribute("message","");
// System.out.println(url);
switch (accounttype){
case "管理员":
AdminDao adminDao=new IAdminimpl();
List<Admin> admins = adminDao.getAdmin(account);
if(admins.size()>0){
Admin admin = admins.get(0);
//用户账号密码正确
System.out.println(admin.getPassword());
System.out.println(password);
if(admin.getPassword().equals(password)){
request.getSession().setAttribute("admin",admin);
response.sendRedirect("admin/index.jsp");
}
}
break;
case "医生":
DoctorDao doctorDao=new DoctorDao();
String where="where account =?";
List<Doctor> doctors = doctorDao.query(where, new Object[]{account});
if(doctors.size()>0){
Doctor doctor = doctors.get(0);
//医生账号密码正确
if(doctor.getPassword().equals(password)){
request.getSession().setAttribute("doctor",doctor);
response.sendRedirect("doctor/index.jsp");
return;
}
}
//用户密码错误
request.getSession().setAttribute("message","用户名或密码错误!!");
request.getRequestDispatcher("doctor/login.jsp").forward(request,response);
break;
case "患者":
PatientDao patientDao=new PatientDao();
List<Patient> patients = patientDao.query("account",account);
if(patients.size()>0){
Patient patient = patients.get(0);
}
}
@WebServlet(urlPatterns = "/DoctorSearch")
public class DoctorSearch extends HttpServlet {
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
doGet(request,response);
}
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
request.setCharacterEncoding("UTF-8");
//从前端得到数据
String office = Util.nullToString(request.getParameter("office"));
String name = Util.nullToString(request.getParameter("doctor"));
int start = Util.nullToZero(request.getParameter("start"));
DoctorDao doctorDao=new DoctorDao();
//数据库查询语句
String where="where office like ? and dname like ? ";
//获取结果数量
int total=doctorDao.getDoctorCount(where,new Object[]{Util.toLike(office),Util.toLike(name)});
//页数
Pages pages = new Pages(start , total, 6);
where+=" limit "+((pages.getCurrentPage()-1)*6)+",6";
//根据页号显示结果
}
calendar.add(Calendar.MINUTE,size);
list.add(numSource);
}
JSONArray array=new JSONArray();
for(NumSource o:list){
//用json方式设置数据
JSONObject jsonObject=new JSONObject();
jsonObject.put("date",o.getVisitdate());
jsonObject.put("ampm",o.getVisitnoon());
jsonObject.put("serialnumber",o.getSerialnumber());
jsonObject.put("state",o.getState());
jsonObject.put("time",o.getVisittime());
array.add(jsonObject);
}
//输出结果到客户端
response.setContentType("application/json; charset=utf-8");
response.getWriter().write(array.toString());
}
}
}
@MultipartConfig
@WebServlet(urlPatterns = "/doctor/myInfo")
public class MyInfo extends HttpServlet {
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
doGet(request,response);
}
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// com.jspsmart.upload.SmartUpload su = new com.jspsmart.upload.SmartUpload();
// su.initialize(pageContext);
// su.service(request, response);
// su.setTotalMaxFileSize(100000000);
writer.flush();
writer.close();
} else {
PrintWriter writer = response.getWriter();
writer.write("false");
writer.flush();
writer.close();
}
}
}
}
@WebServlet(urlPatterns ="/OfficeSearch")
public class OfficeSearch extends HttpServlet {
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
doGet(request,response);
}
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
request.setCharacterEncoding("UTF-8");
String office= Util.nullToString(request.getParameter("office"));
int start=Util.nullToZero(request.getParameter("start"));
OfficeDao officeDao=new OfficeDao();
Pages p = new Pages(start , officeDao.getOfficeCount("officename", office),10);
List<WorkDay> workDays= workDayDao.query(where,new Object[]{doctorid});
request.setAttribute("workDays",workDays);
request.setAttribute("doctor",doctors.get(0));
request.getRequestDispatcher("doctorInfo.jsp").forward(request,response);
}else {
response.getWriter().write("没有这个医生");
}
}
}
}
@WebServlet(urlPatterns = "/RegUserinfoAction")
public class RegUserinfoAction extends HttpServlet {
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
doGet(request,response);
}
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
PatientDao patientDao=new PatientDao();
// public Integer Count(String clounm,String where)
// {
// String sql="select count(*) from patient where "+clounm+" like ? ";
// return DBUtil.getCount(sql,new Object[]{"%"+where+"%"});
// }
String account=request.getParameter("account");
//判断数据库是否有相同的email
Integer count=new PatientDao().Count1(account);
if (account != "") {
Patient patient= (Patient) request.getSession().getAttribute("patient");
// RecodeDao recodeDao = new RecodeDao();
// DoctorDao doctorDao=new DoctorDao();
// String where="where pid=? order by ordertime desc";
// String where1="where pid=? order by ordertime desc";
// List<Recode> Recodelist = recodeDao.query(where, new Object[]{patient.getId()});
// List<Doctor> DoctorList= doctorDao.query(where,)
// // List<HashMap<String, String>> list = recodeDao.orderList(patient.getId());
// request.setAttribute("list",list);
RecodeDao recodeDao=new RecodeDao();
List<HashMap<String, String>> list = null;
try {
list = recodeDao.orderList1(patient.getId());
} catch (SQLException e) {
e.printStackTrace();
}
request.setAttribute("list",list);
request.getRequestDispatcher("orderList.jsp").forward(request,response);
}
}
@WebFilter("/*")
public class MyFilter implements Filter {
private ArrayList<String> patient;
@Override
public void init(FilterConfig filterConfig) throws ServletException {
patient=new ArrayList<>();
patient.add("/order");
patient.add("/orderList");
}
@Override
public void doFilter(ServletRequest servletRequest, ServletResponse servletResponse, FilterChain filterChain) throws IOException, ServletException {
HttpServletRequest req = (HttpServletRequest) servletRequest;
servletRequest.setCharacterEncoding("utf-8");
servletResponse.setCharacterEncoding("utf-8");
servletResponse.setContentType("text/html;charset=utf-8");
// 得到用户请求的URI
// 得到web应用程序的上下文路径
// 去除上下文路径,得到剩余部分的路径
String uri = req.getRequestURI().substring(req.getContextPath().length());//请求的页面
String url=req.getHeader("referer");//之前的页面
@WebServlet(urlPatterns = "/register")
public class Register extends HttpServlet {
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
doGet(request, response);
}
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
request.setCharacterEncoding("UTF-8");
String message="";
//得到密码
String password = request.getParameter("password");
String passwordCof = request.getParameter("passwordCof");
//判断两次密码是否相等
if(password!=null&&password.equals(passwordCof)){
//得到账号
String account=request.getParameter("account");
//判断账号是否为空
if(account!=null){
PatientDao patientDao=new PatientDao();
//从数据库中查找相同的账号记录
List<Patient> patients = patientDao.query("account", account);
//判断是否有相同的账号
if(patients.size()==0){
//得到姓名,邮箱
String name = request.getParameter("name");
String email = request.getParameter("email");
//存入新记录
Patient patient=new Patient(null,account,email,password,name,"100");
if(patientDao.insert(patient)){
message="注册成功,请登录!";
request.getSession().setAttribute("message",message);
// request.getSession().removeAttribute("checkCode");
response.sendRedirect("login.jsp");
return;
}else {
message="注册失败,请稍后再试!";
}