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

📄 time_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 dctno=null;
	
    StringBuffer url = request.getRequestURL(); 
    if (request.getQueryString() != null) 
    { 
      url.append('?');
      url.append(request.getQueryString()); 
    }
    String time=null;
    time=url.toString();
	dctno=time.substring(65);
    time=time.substring(52,58);
    byte tn[]=time.getBytes("ISO-8859-1");
    time=new String(tn);
	
	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());
    }
   int i=0;
   String dctname=null;
   String schname=null;
   String tt=null;
   Stmt = Con.createStatement();    /*创建JDBC声明*/ 
   ResultSet RS = Stmt.executeQuery("SELECT DctName FROM Doctor WHERE DctNo='"+dctno+"'");
   while (RS.next()) {
   dctname=RS.getString("DctName");
   }
   RS.close();
   RS = Stmt.executeQuery("SELECT Abstime FROM DateExc WHERE Relatime='"+time+"'");
   while (RS.next()) {
   tt=RS.getString("Abstime");
   }
   RS.close();
   tt=tt.substring(0,10);
   
   RS=Stmt.executeQuery("SELECT PeriodName,PeriodCount FROM Schedule WHERE DctNo='"+dctno+"' AND PeriodState='Y' AND PeriodCount>0 AND PeriodName LIKE '%"+time+"%' ORDER BY PeriodName");
   %>
   <table align=center cellpadding=10 width="60%" border=1>
   <tr><td colspan='3'>在<font color="#FF0000"> <%=tt%>(<%=time%>)</font>您选择的<font color="#FF0000"><%=dctname%></font>医生的详细预约信息如下：</td></tr>
   <tr><td>预约时段</td><td>剩余可预约人数</td><td>预约</td></tr>
   <%
     while (RS.next())
	{
	   i=1;
	out.print("<tr><td>");
	   schname=tt=RS.getString("PeriodName");
	   out.print(tt);
	   out.print("</td><td>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;");
	  tt=RS.getString("PeriodCount");
	  out.print(tt);
	   out.print("</td><td>");
	   
	  %>
	    <a href="reserve.jsp?dctno=<%=dctno%>&schname=<%=schname%>">进入预约>></a>
        </td></tr>
	<%
	}
	RS.close();
	if(i==0)
	    out.print("<tr><td colspan='3'><center>暂无可选的预约时段</center></td></tr>");
	%>
	</table>
	<center><form><input type='button' value='返回上一页' onClick='backward()'></form></center>
	</body>
	</html>

⌨️ 快捷键说明

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