📄 rsv_detail.jsp

📁 实现了一个医院门诊预约系统

💻 JSP

字号:

<SCRIPT language="javascript">
function backward()
{
      history.back();
}
</SCRIPT>
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@ page info="database handler"%> 
<%@ page import="java.io.*"%> 
<%@ page import="java.util.*"%> 
<%@ page import="java.sql.*"%> 
<%@ page import="javax.servlet.*"%> 
<%@ page import="javax.servlet.http.*"%>

<html>
<head>
<title>医院门诊预约系统——预约单详细条目</title>
</head>

<body>
<%
    String weekname=null;
    StringBuffer url = request.getRequestURL(); 
    if (request.getQueryString() != null) 
    { 
      url.append('?');
      url.append(request.getQueryString()); 
    }
	weekname=url.toString();
	weekname=weekname.substring(51);
	byte wn[]=weekname.getBytes("ISO-8859-1");
    weekname=new String(wn);
	
	String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";  
    String sConnStr = "jdbc:odbc:HCRS";
    Connection Con = null;
    Statement Stmt = null;
 
    try
    {
    Class.forName(sDBDriver); 
     }
    catch(java.lang.ClassNotFoundException e)
    { 
   out.print("Connect to Database error: " + e.getMessage());
     }
   try 
    {
   Con = DriverManager.getConnection(sConnStr); 
     }
   catch(SQLException e)
   {
   out.print(e.toString());
    }
   
    Stmt = Con.createStatement();    /*创建JDBC声明*/   
	String tt=null;
	String time=null;
	boolean hasrow=false;
	ResultSet RS= Stmt.executeQuery("SELECT Abstime FROM DateExc WHERE Relatime='"+weekname+"'"); 
	while (RS.next()) 
    {
	    time = RS.getString("Abstime");
        time = time.substring(0,10);
	}
	RS.close();
	
     RS=Stmt.executeQuery("SELECT RsvNo,PatientName,DctName,PatientSym,PatientTel FROM Reservation,Doctor WHERE Reservation.DctNo=Doctor.DctNo AND PeriodName LIKE '%"+weekname+"%'");
	%>
	 <a align=right href="admin_log_default.jsp" id="button">返回后台主页</a>
 
	<table align=center cellpadding=10 width="80%" border=0>
   <tr><td colspan='5'>在<font color="#FF0000"> <%=time%>(<%=weekname%>)</font>已经存在的预约单信息如下：</td></tr>
   <tr><td>预约单号</td><td>患者姓名</td><td>预约医生</td><td>病症</td><td>联系电话</td></tr>
	<%
	while(RS.next())
	{
	    hasrow=true;
	   out.print("<tr><td>");
	   tt=RS.getString("RsvNo");
	   out.print(tt);
	   out.print("</td><td>");
	   tt=RS.getString("PatientName");
	   out.print(tt);
	   out.print("</td><td>");
	   tt=RS.getString("DctName");
	   out.print(tt);
	   out.print("</td><td>");
	   tt=RS.getString("PatientSym");
	   out.print(tt);
	   out.print("</td><td>");
	   tt=RS.getString("PatientTel");
	   out.print(tt);
	   out.print("</td></tr>");
	}
	RS.close();
	if(!hasrow)
	{
	   out.print("<tr><td colspan='5'align=center>暂无预约记录</td></tr>");
	   }
	%>
	</table>
	<center><form><input type='button' value='返回上一页' onClick='backward()'></form></center>
	</body>
	</html>

💿 文件大小 379 K

👤 上传用户 newyearday

📂 所属分类数据库系统

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -