📄 dct_detail_time.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>
<%
    StringBuffer url = request.getRequestURL(); 
    if (request.getQueryString() != null) 
    { 
      url.append('?');
      url.append(request.getQueryString()); 
    }
    String dctno=null,schname=null;
    dctno=url.toString();
	schname=url.toString();
	String sub=null;
	int j;
	for(j=53;j<dctno.length()-1;j++)
	{
	   sub=dctno.substring(j,j+1);
	   if(sub.equals("&"))
	        break;
	}
    dctno=dctno.substring(53,j);
	schname=schname.substring(j+9);
	byte schn[]=schname.getBytes("ISO-8859-1");
	schname=new String(schn);
	
    
    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声明*/
   
  ResultSet RS2;
  String day=schname.substring(0,3);
	  String time=schname.substring(6);
	  String date=null;
	RS2 = Stmt.executeQuery("SELECT Abstime FROM DateExc WHERE Relatime='"+day+"'"); 
	while (RS2.next()) 
    {
	    date = RS2.getString("Abstime");
        date = date.substring(0,10);
	}
	RS2.close();
    
  ResultSet RS = Stmt.executeQuery("SELECT DctPic,DctName,DctSex,DctBirth,DctBg,DctPost,DctAchv,DctDesc,OfficeNo FROM Doctor WHERE DctNo='"+dctno+"'"); 
 while (RS.next()) {
 %>
 
  <table width="60%" border="2"  cellpadding=3 cellspacing=3 align="center">
 <tbody>
 <tr>
    <td><center><img src="<%=RS.getString("DctPic")%>" width="150" height="200"></center>
	<td><font color=#FF0000><b>医生：<%=RS.getString("DctName")%></b></font><br><br><br><b>预约时间：
	<%out.print(date+"("+day+")"+" "+time);%></b>
 <tr>
   <td width="30%" align=center>性别：
  <td width="70%"><%String dsex = RS.getString("DctSex");
                    if(dsex.equals("M")){out.print("男");}
					else if(dsex.equals("F")){out.print("女");}%>
<tr>
  <td width="30%" align=center>出生日期：
  <td width="70%"><%String birth = RS.getString("DctBirth");
                    birth=birth.substring(0,10);
					out.print(birth);%>
<tr>
  <td width="30%" align=center>学历背景：
  <td width="70%"><%=RS.getString("DctBg")%>
<tr>
  <td width="30%" align=center>职位：
  <td width="70%"><%=RS.getString("DctPost")%>
<tr>
  <td width="30%" align=center>业绩：
  <td width="70%"><%=RS.getString("DctAchv")%>
<tr>
  <td width="30%" align=center>简介：
  <td width="70%"><%=RS.getString("DctDesc")%>
<tr>
  <td width="30%" align=center>办公室：
  <td width="70%"><%=RS.getString("OfficeNo")%>
<tr>
<tr>
   <td colspan="2">
   	<center><a href="reserve.jsp?dctno=<%=dctno%>&schname=<%=schname%>">预约</a>&nbsp;&nbsp;&nbsp;<input type="button" value="返回"  id="button" class="button" onClick="backward()">
  	
    </center>
   </td>
</tr>
</table>

<%
  }
   
%>
</body>
</html>
⌨️ 快捷键说明

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