基于Java web的医院在线预约挂号系统(含数据库脚本).zip

package com.action; import org.apache.struts.action.ActionMapping; import org.apache.struts.action.ActionForm; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import org.apache.struts.action.ActionForward; import com.actionForm.RegisterForm; import org.apache.struts.action.Action; import com.dao.RegisterDAO; import com.actionForm.DepartmentForm; import com.dao.DepartmentDAO; import java.util.Date; import java.text.SimpleDateFormat; import java.text.ParseException; import java.util.*; public class Register extends Action { private RegisterDAO registerDAO = null; public Register() { this.registerDAO = new RegisterDAO(); } public ActionForward execute(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response)throws ParseException { String action =request.getParameter("action"); System.out.println("\nregister*********************action="+action); if(action==null||"".equals(action)){ request.setAttribute("error"," 您的操作有误！"); return mapping.findForward("error"); }else if("registerAdd".equals(action)){ return registerAdd(mapping,form,request,response); }else if("registerQuery".equals(action)){ return registerQuery(mapping,form,request,response); }else if("registerifQuery".equals(action)){ return registerifQuery(mapping,form,request,response); } else if("registerDel".equals(action)){ return registerDel(mapping,form,request,response); } request.setAttribute("error","操作失败！"); return mapping.findForward("error"); } /***********************添加挂号信息**************************/ private ActionForward registerAdd(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response)throws ParseException { RegisterForm registerForm = (RegisterForm) form; registerForm.setTelephoneNum(registerForm.getTelephoneNum()); registerForm.setDepartmentNum(registerForm.getDepartmentNum()); registerForm.setDate(registerForm.getDate()); DepartmentDAO departmentDAO = new DepartmentDAO(); DepartmentForm departmentForm=departmentDAO.query(registerForm.getDepartmentNum()); SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd"); String mydateStr=registerForm.getDate(); Date mydate=sdf.parse(mydateStr); Date nowdate = new Date(); long time1 = 0; long time2 = 0; try{ time1 = mydate.getTime(); time2 = nowdate.getTime(); }catch(Exception e){ e.printStackTrace(); } long between_days=(time1-time2)/(1000*3600*24); //计算 相隔天数 System.out.println(between_days); if(between_days<0||between_days>2) { request.setAttribute("error","不在预订日期内"); return mapping.findForward("error"); } if(registerForm.getTelephoneNum()=="") { if(departmentForm.getRemainNum()>0) { request.setAttribute("success","有剩余预约号，请输入手机号！"); return mapping.findForward("success"); }else // { request.setAttribute("error","暂无预约号！"); return mapping.findForward("error"); } } else { int a=registerDAO.insert(registerForm); if(a==1){ int flag=departmentDAO.update(registerForm.getDepartmentNum(),departmentForm.getRemainNum()-1); //成功预约 修改部门剩余量 // departmentForm.setRemainNum(0); //int flag=departmentDAO.update(departmentForm); // System.out.println("update="+flag+""); // request.setAttribute("success","预约成功！"); // request.setAttribute("success","有剩余预约号，请输入手机号！"); request.setAttribute("success","预约成功！"); return mapping.findForward("success"); } else if(a==2){ request.setAttribute("error","该预约已存在！"); return mapping.findForward("error"); }else{ request.setAttribute("error","预约失败！"); return mapping.findForward("error"); } } } /***********************查询全部部门信息**************************/ private ActionForward registerQuery(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response){ String str=null; request.setAttribute("register",registerDAO.query(str)); //将查询结果保存到book中 return mapping.findForward("registerQuery"); //转到显示部门信息列表页面 } /***********************条件查询部门信息**************************/ private ActionForward registerifQuery(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response){ String str=null; if(request.getParameter("f")!=null){ str = request.getParameter("f") + " like '%" + request.getParameter("key") + "%"; } request.setAttribute("ifregister",registerDAO.query(str)); System.out.print("条件查询部门信息时的str:"+str); return mapping.findForward("registerifQuery"); } /***********************删除部门信息**************************/ private ActionForward registerDel(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response){ RegisterForm registerForm=(RegisterForm)form; // registerForm.setRegisterNum(Integer.valueOf(request.getParameter("RegisterNum"))); String TelephoneNum=registerForm.getTelephoneNum(); Collection coll_register=(Collection)registerDAO.queryM(TelephoneNum); // 通过手机号 找到预约记录 进而找到 部门编号 删除预约记录时 要把部门剩余量同时修改 Iterator it=coll_register.iterator(); //int ret=registerDAO.delete(registerForm); int ret=registerDAO.delete(TelephoneNum); if(ret==0){ request.setAttribute("error","无效号码或此号码尚未预约！"); return mapping.findForward("error"); }else{ while(it.hasNext()){ RegisterForm registerForm1=(RegisterForm)it.next(); int departmentnum=registerForm1.getDepartmentNum(); DepartmentDAO departmentDAO = new DepartmentDAO(); DepartmentForm departmentForm=departmentDAO.query(departmentnum); int flag=departmentDAO.update(registerForm1.getDepartmentNum(),departmentForm.getRemainNum()+1); System.out.print("update:"+flag+" departmentnum"+departmentnum); }