📄 pat_search_result.jsp

📁 实现了一个医院门诊预约系统
💻 JSP
字号:
<%@ page contentType="text/html; charset=GBK" %>
<%@ 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 tRsvNo = request.getParameter("RsvNo");
    String sqlRsvNo = "";
    sqlRsvNo = "RsvNo='"+tRsvNo+"'";
    
    String cId = request.getParameter("PatientId");
    String sqlId = "";
    sqlId = "PatientId='"+cId+"'";    
    
    String sql=null;
    sql=sqlRsvNo+" AND "+sqlId;
 
    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());
    }
  boolean hasrow = false;
  String editno = null;
  Stmt = Con.createStatement();
  ResultSet rs = Stmt.executeQuery("SELECT PatientName,PatientSex,PatientAge,PatientSym,PatientTel,RsvState,Doctor.DctName,PeriodName,Doctor.OfficeNo FROM Reservation,Doctor WHERE Doctor.DctNo=Reservation.DctNo AND "+sql); 



while(rs.next())
{	
	hasrow = true ;
	String PatientName = rs.getString("PatientName");
	String PatientSex = rs.getString("PatientSex");
	String PatientAge = rs.getString("PatientAge");
	String PatientSym = rs.getString("PatientSym");
	String PatientTel = rs.getString("PatientTel");
	String RsvState = rs.getString("RsvState");
	String DctName = rs.getString("DctName");
	String PeriodName = rs.getString("PeriodName");
	String OfficeNo = rs.getString("OfficeNo");	
%>
	<table align=center cellpadding=5 width='60%' border=0>
	<tr><td colspan="2"><h2>以下为您的预约单：</h2></td></tr>
	<tr>
		<td width="30%">预约单号:</td>
		<td width="70%"><%=tRsvNo%></td>
	</tr>
	<tr>
		<td width="30%">姓名:</td>
		<td width="70%"><%=PatientName%></td>
	</tr>
	<tr>
		<td width="30%">性别:</td>
		<td width="70%"><%=PatientSex%></td>
	</tr>
	<tr>
		<td width="30%">年龄:</td>
		<td width="70%"><%=PatientAge%></td>
	</tr>
		<tr>
		<td width="30%">症状:</td>
		<td width="70%"><%=PatientSym%></td>
	</tr>
	<tr>
		<td width="30%">身份证号:</td>
		<td width="70%"><%=cId%></td>
	</tr>
	<tr>
		<td width="30%">您的电话:</td>
		<td width="70%"><%=PatientTel%></td>
	</tr>
	<tr>
		<td width="30%">是否已会诊:</td>
		<td width="70%"><%=RsvState%></td>
	</tr>
	<tr>
		<td width="30%">医生姓名:</td>
		<td width="70%"><%=DctName%></td>
	</tr>
	<tr>
		<td width="30%">预约时间:</td>
		<td width="70%"><%=PeriodName%></td>
	</tr>
	<tr>
		<td width="30%">就医办公室:</td>
		<td width="70%"><%=OfficeNo%></td>
	</tr>
	<tr>

<td align=center>
  <a href="del_rsv1.jsp?RsvNo=<%=tRsvNo%>">撤销预约</a></td><td>
 <a href="pat_search_rsv.jsp">继续搜索</a>
   </td><tr>
<%
}
rs.close();

 if(!hasrow)
 {
 out.print("<table align=center cellpadding=10 width='60%' border=0>");
   out.print("<tr><td align=center>抱歉，没有您的此项预约记录！<br><br><br>请检查你的填入信息，或是进入首页重新预约！</td></tr>");
   
   
    out.print("<tr><td><br></td></tr><tr><td align=center><a href='pat_search_rsv.jsp'><span>继续搜索</a>&nbsp;&nbsp;&nbsp;<a href='index.html'><span>进入首页</a></td></tr>");
	}
 out.print("</table>");
%>
</body>
</html>
💿 文件大小 379 K
👤 上传用户 newyearday
📂 所属分类数据库系统
⌨️ 快捷键说明

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