📄 dct_detail.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;
dctno=url.toString();
dctno=dctno.substring(48);
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());
}
String tt=null;
String dctname=null;
Stmt = Con.createStatement(); /*创建JDBC声明*/
ResultSet RS2;
ResultSet RS = Stmt.executeQuery("SELECT DctPic,DctName,DctSex,DctBirth,DctPost,DctBg,DctAchv,OfficeLoc,DctDesc FROM Doctor,Office WHERE DctNo='"+dctno+"' AND Doctor.OfficeNo=Office.OfficeNo ");
while (RS.next()) {
%>
<table align=center cellpadding=2 width="60%" border=0>
<tr><td rowspan='7' width="22%"><img border=2 width="150" height="210"src="<%=RS.getString("DctPic")%>" /></td>
<%
dctname=RS.getString("DctName");
%>
<td>姓名：<%=dctname%></td></tr>
<%
tt=RS.getString("DctSex");
if(tt=="M")
tt="女";
else
tt="男";
%>
<tr><td>性别：<%=tt%></td></tr>
<%
tt=RS.getString("DctBirth");
tt=tt.substring(0,10);
%>
<tr><td>出生日期：<%=tt%></td></tr>
<tr><td>职位：<%=RS.getString("DctPost")%></td></tr>
<tr><td>学历：<%=RS.getString("DctBg")%></td></tr>
<tr><td>嘉奖：<%=RS.getString("DctAchv")%></td></tr>
<tr><td>办公地点：<%=RS.getString("OfficeLoc")%></td></tr>
<tr><td colspan="2"><p></td></tr>
<tr><td colspan="2"><p></td></tr>
<tr><td colspan="2"><p></td></tr>
<tr><td colspan="2"><p></td></tr>
<tr><td colspan="2">简介：<%=RS.getString("DctDesc")%></td></tr>
<%
}
out.print("</table>");
RS.close();
RS = Stmt.executeQuery("SELECT Abstime,Relatime FROM DateExc ORDER BY Abstime");
int i=0;
String[] time=new String[7];
String[] weekname=new String[7];
while (RS.next())
{
time[i]=RS.getString("Abstime");
time[i]=time[i].substring(0,10);
weekname[i]=RS.getString("Relatime");
i++;
}
RS.close();
%>
<br><br><br>
<table align=center cellpadding=10 width="60%" border=1>
<tr><td colspan='3'>在未来一周<font color="#FF0000"><%=dctname%></font>医生的预约信息：</td></tr>
<tr><td>预约日期</td><td>当天可预约人数</td><td>预约</td></tr>
<%
String total=null;
i=0;
while (i<7)
{
out.print("<tr><td>");
out.print(time[i]+"(");
out.print(weekname[i]+")");
out.print("</td><td> ");
RS2=Stmt.executeQuery("SELECT SUM(PeriodCount) TotalCount FROM Schedule WHERE DctNo='"+dctno+"' AND PeriodState='Y' AND PeriodName LIKE '%"+weekname[i]+"%'");
while(RS2.next())
{
total=RS2.getString("TotalCount");
if(total==null)
total="0";
out.print(total);
out.print("</td><td>");
}
RS2.close();
%>
<a href="time_detail.jsp?weekname=<%=weekname[i]%>&dctno=<%=dctno%>">进入预约>></a>
</td></tr>
<%
i++;
}
%>
</table>
<center><form><input type='button' value='返回上一页' onClick='backward()'></form></center>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -