⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 getappointmentinfo_jsp.java

📁 JAVA 编写的 医院管理系统,利用ACCESS做的数据库.
💻 JAVA
字号:
🔍 
package org.apache.jsp;

import javax.servlet.*;
import javax.servlet.http.*;
import javax.servlet.jsp.*;
import org.apache.jasper.runtime.*;
import hospital.db.dboperation.*;
import hospital.db.*;
import java.sql.*;

public class getAppointmentInfo_jsp extends HttpJspBase {


  private static java.util.Vector _jspx_includes;

  static {
    _jspx_includes = new java.util.Vector(3);
    _jspx_includes.add("/patient/../include/ccs.inc");
    _jspx_includes.add("/patient/../include/head.inc");
    _jspx_includes.add("/patient/../include/patient.inc");
  }

  public java.util.List getIncludes() {
    return _jspx_includes;
  }

  public void _jspService(HttpServletRequest request, HttpServletResponse response)
        throws java.io.IOException, ServletException {

    JspFactory _jspxFactory = null;
    javax.servlet.jsp.PageContext pageContext = null;
    HttpSession session = null;
    ServletContext application = null;
    ServletConfig config = null;
    JspWriter out = null;
    Object page = this;
    JspWriter _jspx_out = null;


    try {
      _jspxFactory = JspFactory.getDefaultFactory();
      response.setContentType("text/html; charset=gbk");
      pageContext = _jspxFactory.getPageContext(this, request, response,
      			null, true, 8192, true);
      application = pageContext.getServletContext();
      config = pageContext.getServletConfig();
      session = pageContext.getSession();
      out = pageContext.getOut();
      _jspx_out = out;

      out.write("<style type=\"text/css\">\r\n");
      out.write("<!--\r\nbody,td,th {\r\n\tfont-size: 12px;\r\n\tcolor: #000033;\r\n}\r\na {\r\n\tfont-size: 12px;\r\n}\r\na:link {\r\n\ttext-decoration: none;\r\n}\r\na:visited {\r\n\ttext-decoration: none;\r\n}\r\na:hover {\r\n\ttext-decoration: none;\r\n}\r\na:active {\r\n\ttext-decoration: none;\r\n}\r\n-->\r\n");
      out.write("</style>");
      out.write("\r\n");
      out.write("\r\n");
      out.write("\r\n");
      out.write("\r\n\r\n");
      out.write("<html>\r\n");
      out.write("<head>\r\n");
      out.write("<title>医院门诊预约系统－预约信息");
      out.write("</title>\r\n\r\n");
      out.write("</head>\r\n\r\n");

Patient patient=(Patient)session.getAttribute("patient");
String _getAppointmentInfo="";
ResultSet rs=null;
int qid=0;

	if(patient==null)
		_getAppointmentInfo="请先<a href=\"/hospital/patient/login.jsp\">登录</a>";

	else{
		int g=patient.getAppointmentInfo();

		switch(g){
			case 1:
				_getAppointmentInfo="查询成功";
				rs=patient.getResultSet();
				break;
			case 0:
				_getAppointmentInfo="一般异常";
				break;
			case -1:
				_getAppointmentInfo="数据库异常";
				break;
			case -2:
				_getAppointmentInfo="用户未预约";
				break;
		}
	}

      out.write("\r\n\r\n");
      out.write("<body bgcolor=\"#FFFFFF\">\r\n");
      out.write("<table width=\"770\" height=\"423\" border=\"0\" align=\"center\" cellpadding=\"0\" cellspacing=\"1\" bgcolor=\"#000000\">\r\n\t");
      out.write("<tr>\r\n\t\t");
      out.write("<td height=\"421\" bgcolor=\"#FFFFFF\">");
      out.write("\r\n\r\n\t\t\t");
      out.write("<table width=\"770\" border=\"0\" align=\"center\" cellpadding=\"0\" cellspacing=\"0\">\r\n\t\t\t\t");
      out.write("<tr>\r\n\t\t\t\t\t");
      out.write("<td>&nbsp;");
      out.write("</td>\r\n\t\t\t\t\t");
      out.write("<td width=\"411\">&nbsp;");
      out.write("</td>\r\n\t\t\t\t");
      out.write("</tr>\r\n\t\t\t\t");
      out.write("<tr>\r\n\t\t\t\t\t");
      out.write("<td width=\"359\">");
      out.write("<img src=\"/hospital/images/LEFTBAR.GIF\" width=\"359\" height=\"39\">");
      out.write("</td>\r\n\t\t\t\t\t");
      out.write("<td align=\"right\" bgcolor=\"336CA1\">&nbsp;");
      out.write("</td>\r\n\t\t\t\t");
      out.write("</tr>\r\n\t\t\t\t");
      out.write("<tr>\r\n\t\t\t\t\t");
      out.write("<td colspan=\"2\">");
      out.write("<img src=\"/hospital/images/TOPBAR.GIF\" width=\"770\" height=\"69\">");
      out.write("</td>\r\n\t\t\t\t");
      out.write("</tr>\r\n\t\t\t\t");
      out.write("<tr>\r\n\t\t\t\t\t");
      out.write("<td colspan=\"2\">\r\n\t\t\t\t\t\t");
      out.write("<table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" background=\"IMAGES/but_bg.gif\">\r\n\t\t\t\t\t\t\t");
      out.write("<tr>\r\n\t\t\t\t\t\t\t\t");
      out.write("<td align=\"right\">&nbsp;");
      out.write("</td>\r\n\t\t\t\t\t\t\t");
      out.write("</tr>\r\n\t\t\t\t\t\t");
      out.write("</table>\r\n\t\t\t\t\t");
      out.write("</td>\r\n\t\t\t\t");
      out.write("</tr>\r\n\t\t\t");
      out.write("</table>\r\n");
      out.write("\r\n\t\t\t\t");
      out.write("<table width=\"770\" height=\"290\" border=\"0\" align=\"center\" cellpadding=\"0\" cellspacing=\"0\">\r\n\t\t\t\t\t");
      out.write("<tr>\r\n\t\t\t\t\t\t");
      out.write("\r\n\t\t\t\t\t\t");
      out.write("<td width=\"167\" height=\"290\" valign=\"top\" bgcolor=\"8FBEE8\">\r\n\t\t\t\t\t\t");
      out.write("<div align=\"center\">\r\n\t\t\t\t\t\t\t");
      out.write("<br>\r\n\t\t\t\t\t\t\t");
      out.write("<p>");
      out.write("<a href=\"/hospital/default.jsp\">返回首页");
      out.write("</a>");
      out.write("</p>\r\n\t\t\t\t\t\t\t");
      out.write("<br>\r\n\t\t\t\t\t\t\t");
      out.write("<p>");
      out.write("<a href=\"/hospital/patient/login.jsp\">登录（患者用户）");
      out.write("</a>");
      out.write("</p>\r\n\t\t\t\t\t\t\t");
      out.write("<p>");
      out.write("<a href=\"/hospital/patient/register.jsp\">注册");
      out.write("</a>");
      out.write("</p>\r\n\t\t\t\t\t\t\t");
if(session.getAttribute("patient")!=null){
      out.write("\r\n\t\t\t\t\t\t\t");
      out.write("<p>");
      out.write("<a href=\"/hospital/patient/getDoctorInfo.jsp\">查询医生信息");
      out.write("</a>");
      out.write("</p>\r\n\t\t\t\t\t\t\t");
      out.write("<p>");
      out.write("<a href=\"/hospital/patient/getDoctorInfo.jsp\">预约");
      out.write("</a>");
      out.write("</p>\r\n\t\t\t\t\t\t\t");
      out.write("<p>");
      out.write("<a href=\"/hospital/patient/getAppointmentInfo.jsp\">查询预约信息");
      out.write("</a>");
      out.write("</p>\r\n\t\t\t\t\t\t\t");
      out.write("<p>");
      out.write("<a href=\"/hospital/patient/getAppointmentInfo.jsp\">取消预约");
      out.write("</a>");
      out.write("</p>\r\n\t\t\t\t\t\t\t");
      out.write("<p>");
      out.write("<a href=\"/hospital/patient/getCurrentDoctorInfo.jsp\">查询主治医生信息");
      out.write("</a>");
      out.write("</p>\r\n\t\t\t\t\t\t\t");
      out.write("<p>");
      out.write("<a href=\"/hospital/patient/getHistory.jsp\">查询病历");
      out.write("</a>");
      out.write("</p>\r\n\t\t\t\t\t\t\t");
      out.write("<p>");
      out.write("<a href=\"/hospital/patient/logout.jsp\">注销");
      out.write("</a>");
      out.write("</p>\r\n\t\t\t\t\t\t\t");
}
      out.write("\r\n\t\t\t\t\t\t\t");
      out.write("<br>\r\n\t\t\t\t\t\t\t");
      out.write("<p>");
      out.write("<a href=\"/hospital/doctor/main.jsp\">医生用户");
      out.write("</a>");
      out.write("</p>\r\n\t\t\t\t\t\t\t");
      out.write("<p>");
      out.write("<a href=\"/hospital/admin/main.jsp\">管理员用户");
      out.write("</a>");
      out.write("</p>\r\n\t\t\t\t\t\t\t");
      out.write("<br>\r\n\t\t\t\t\t\t");
      out.write("</div>\r\n\t\t\t\t\t\t");
      out.write("</td>\r\n");
      out.write("\r\n\t\t\t\t\t\t");
      out.write("<td width=\"603\" align=\"center\" valign=\"top\">\r\n\t\t\t\t\t\t\t");
      out.write("<table width=\"100%\" height=\"100%\" border=\"0\" cellpadding=\"3\" cellspacing=\"1\" bgcolor=\"#666666\">\r\n\t\t\t\t\t\t\t\t");
      out.write("<tr>\r\n\t\t\t\t\t\t\t\t\t");
      out.write("<td width=\"100%\" height=\"257\" align=\"center\" valign=\"top\" bgcolor=\"E3EDFF\">\r\n\t\t\t\t\t\t\t\t\t");
      out.write("<p>");
      out.print(_getAppointmentInfo);
      out.write("</p>\r\n\t\t\t\t\t\t\t\t\t");
      out.write("<p align=\"left\">");
      out.write("<strong>单击预约编号取消预约");
      out.write("</strong>");
      out.write("</p>\r\n\t\t\t\t\t\t\t\t\t");
      out.write("<table width=\"100%\">\r\n\t\t\t\t\t\t\t\t\t");
      out.write("<tr>\r\n\t\t\t\t\t\t\t\t\t\t");
      out.write("<th>预约编号");
      out.write("</th>\r\n\t\t\t\t\t\t\t\t\t\t");
      out.write("<th>医生编号");
      out.write("</th>\r\n\t\t\t\t\t\t\t\t\t\t");
      out.write("<th>0－周日，1－周一，以此类推");
      out.write("</th>\r\n\t\t\t\t\t\t\t\t\t\t");
      out.write("<th>0－上午，1－下午");
      out.write("</th>\r\n\t\t\t\t\t\t\t\t\t\t");
      out.write("<th>预约日期");
      out.write("</th>\r\n\t\t\t\t\t\t\t\t\t");
      out.write("</tr>\r\n\t\t\t\t\t\t\t\t\t");
while(rs!=null && rs.next()){
      out.write("\r\n\t\t\t\t\t\t\t\t\t");
      out.write("<tr align=\"center\">\r\n\t\t\t\t\t\t\t\t\t\t");
      out.write("<td>");
      out.write("<a href=\"cancleAppointment.jsp?qid=");
      out.print((qid=rs.getInt("QID")));
      out.write("\" onclick=\"return confirm('确实要取消此预约吗?');\">\r\n\t\t\t\t\t\t\t\t\t\t");
      out.print(qid);
      out.write("</a>");
      out.write("</td>\r\n\t\t\t\t\t\t\t\t\t\t");
      out.write("<td>");
      out.print(rs.getString("Doctor"));
      out.write("</td>\r\n\t\t\t\t\t\t\t\t\t\t");
      out.write("<td>");
      out.print(rs.getInt("Day"));
      out.write("</td>\r\n\t\t\t\t\t\t\t\t\t\t");
      out.write("<td>");
      out.print(rs.getInt("AP"));
      out.write("</td>\r\n\t\t\t\t\t\t\t\t\t\t");
      out.write("<td>");
      out.print(rs.getDate("Date"));
      out.write("</td>\r\n\t\t\t\t\t\t\t\t\t");
      out.write("</tr>\r\n\t\t\t\t\t\t\t\t\t");
}
      out.write("\r\n\t\t\t\t\t\t\t\t\t");
      out.write("</table>\r\n\t\t\t\t\t\t\t\t\t");
      out.write("</td>\r\n\t\t\t\t\t\t\t\t");
      out.write("</tr>\r\n\t\t\t\t\t\t\t");
      out.write("</table>\r\n\t\t\t\t\t\t");
      out.write("</td>\r\n\t\t\t\t\t");
      out.write("</tr>\r\n\t\t\t");
      out.write("</table>");
      out.write("</td>\r\n\t");
      out.write("</tr>\r\n");
      out.write("</table>\r\n");
      out.write("</body>\r\n");
      out.write("</html>\r\n");
    } catch (Throwable t) {
      out = _jspx_out;
      if (out != null && out.getBufferSize() != 0)
        out.clearBuffer();
      if (pageContext != null) pageContext.handlePageException(t);
    } finally {
      if (_jspxFactory != null) _jspxFactory.releasePageContext(pageContext);
    }
  }
}

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -