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

📄 reserve_iden.jsp

📁 实现了一个医院门诊预约系统
💻 JSP
字号:
🔍 
<SCRIPT language="javascript">
function backward()
{
      history.back();
}
</SCRIPT>
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<html>
<head>
<title>医院门诊预约系统——预约信息确认<</title>
</head>

<body>
	<%    	
	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 dctname = null;
    String dctno = request.getParameter("dctno");
	ResultSet RS = Stmt.executeQuery("SELECT DctName FROM Doctor WHERE DctNo='"+dctno+"'"); 
    while (RS.next()) 
    {
	    dctname = RS.getString("DctName");
	}
	RS.close();
    
	String date = null;
    String schname = request.getParameter("schname");
    byte sch[] = schname.getBytes("ISO-8859-1");
    schname = new String(sch);
	String day = schname.substring(0,3);
	String time = schname.substring(6);
    RS = Stmt.executeQuery("SELECT Abstime FROM DateExc WHERE Relatime='"+day+"'"); 
	while (RS.next()) 
    {
	    date = RS.getString("Abstime");
        date = date.substring(0,10);
	}
	RS.close();
    
    String pname = request.getParameter("PatientName");
    byte pn[] = pname.getBytes("ISO-8859-1");
    pname = new String(pn);
	
	String psym = request.getParameter("PatientSym");
    byte ps[] = psym.getBytes("ISO-8859-1");
    psym = new String(ps);
	
	String pid = request.getParameter("PatientId");
	    
	String psex = request.getParameter("PatientSex");
    
	String pages = request.getParameter("PatientAge");
	
	String ptel = request.getParameter("PatientTel");
%>
<form action="reserve_succ.jsp" method="post">
<input type="hidden" name="dctno" value="<%=dctno%>">
<input type="hidden" name="schname" value="<%=schname%>">
<input type="hidden" name="PatientName" value="<%=pname%>">
<input type="hidden" name="PatientSym" value="<%=psym%>">
<input type="hidden" name="PatientId" value="<%=pid%>">
<input type="hidden" name="PatientSex" value="<%=psex%>">
<input type="hidden" name="PatientAge" value="<%=pages%>">
<input type="hidden" name="PatientTel" value="<%=ptel%>">

 <table width="60%" border="2" cellpadding=3 cellspacing=3  align="center">
<tbody>
<tr>
<td colspan="2" align="center"><h2>请认真检查下面的预约信息:</h2></td>
<tr>
  <td width="30%" align=center>您预约的医生：
  <td width="70%"><%=dctname%>
<tr>
  <td width="30%" align=center>您预约的时间段：
  <td width="70%"><%=date+" "+time%>
<tr>
  <td width="30%" align=center>姓名：
  <td width="70%"><%=pname%>
<tr>
  <td width="30%" align=center>症状：
  <td width="70%"><%=psym%>
<tr>
  <td width="30%" align=center>身份证号：
  <td width="70%"><%=pid%>
<tr>
  <td width="30%" align=center>性别：
  <td width="70%"><%if(psex.equals("M"))
                        out.print("男");
					else 
					    out.print("女");%>
<tr>
  <td width="30%" align=center>年龄：
  <td width="70%"><%=pages%>
<tr>
  <td width="30%" align=center>联系电话：
  <td width="70%"><%=ptel%>
<tr>
   <td colspan="2"><center><input type="submit" id="submit" class="submit"value="确认">&nbsp;&nbsp;&nbsp;<input type="button" id="button" class="button" onClick="backward()" value="返回上一步"></center></td>

<tr>
   </td>
</tr>
</table>
</div>
</form>
</body>
</html>

⌨️ 快捷键说明

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