📄 dept_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 deptno=null;
deptno=url.toString();
deptno=deptno.substring(50);
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 RS = Stmt.executeQuery("SELECT DeptName,DeptDesc FROM Department WHERE DeptNo='"+deptno+"'");
String tt=null;
String dname=null;
out.print("<table align=center cellpadding=10 width='60%' border=0>");
while (RS.next()) {
out.print("<tr ><td>欢迎来到<font color=#FF0000>");
dname=tt=RS.getString("DeptName");
out.print(tt);
out.print("</font>！</td></tr><tr><td>科室简介：");
tt = RS.getString("DeptDesc");
out.print(tt);
out.print("</td></tr>");
}
out.print("</table>");
RS.close();
%>
<br><br><br>
<script language="JavaScript">
function check()
{
fr = document.searchtime;
if(fr.day.value == ""||fr.time_from.value == ""||fr.time_to.value == "")
{
alert("每一项均需选择!");ost
return;
}
else if(fr.time_from.value ==fr.time_to.value)
{
alert("开始时间与终止时间不能相等！");
return;
}
fr.submit();
}
</script>
<form name="searchtime" id="searchtime" action="list_searchfrom_time.jsp" method="post">
<input type="hidden" name="DeptNo" value=<%=deptno%>>
<table align=center cellpadding=10 width='60%' border=1>
<tr>
<td colspan="2">按预约时间搜索</td>
</tr>
<tr>
<td>星期
<select name="day">
<option value="" selected="selected"> </option>
<option value="一">一</option>
<option value="二">二</option>
<option value="三">三</option>
<option value="四">四</option>
<option value="五">五</option>
<option value="六">六</option>
<option value="日">日</option>
</select>
</td>
<td>时间段：从
<select name="time_from">
<option value="" selected="selected"> </option>
<option value="8">8</option>
<option value="9">9</option>
<option value="10">10</option>
<option value="11">11</option>
<option value="12">12</option>
<option value="13">13</option>
<option value="14">14</option>
<option value="15">15</option>
<option value="16">16</option>
<option value="17">17</option>
<option value="18">18</option>
</select>:00至
<select name="time_to">
<option value="" selected="selected"> </option>
<option value="8">8</option>
<option value="9">9</option>
<option value="10">10</option>
<option value="11">11</option>
<option value="12">12</option>
<option value="13">13</option>
<option value="14">14</option>
<option value="15">15</option>
<option value="16">16</option>
<option value="17">17</option>
<option value="18">18</option>
</select>:00
</td>
</tr>
<tr>
<td colspan="2"><center><input type="button" id="button" class="button" value="提交" onClick="check()">
<input type="reset" id="reset" class="reset" value="重置">
</center></td>
</tr>
</table>
</form>
<%
String dctno=null;
RS = Stmt.executeQuery("SELECT DctNo,DctName,DctSex,DctPost,DctBg FROM Doctor WHERE DeptNo='"+deptno+"' ORDER BY DeptNo");
%>
<br><br><br>
<table align=center cellpadding=10 width="60%" border=1>
<tr><td colspan='6'><font color="#FF0000"><%=dname%></font>为您服务的医生：</td></tr>
<tr><td>医生编号</td><td>姓名</td><td>性别</td><td>职位</td><td>学历</td></tr>
<%
while (RS.next()) {
out.print("<tr><td>");
dctno=tt=RS.getString("DctNo");
out.print(tt);
out.print("</td><td>");
tt=RS.getString("DctName");
%>
<a href="dct_detail.jsp?dctno=<%=dctno%>"><%=tt%></a>
</td><td>
<%
tt=RS.getString("DctSex");
if(tt=="M")
out.print("女");
else
out.print("男");
out.print("</td><td>");
tt=RS.getString("DctPost");
out.print(tt);
out.print("</td><td>");
tt=RS.getString("DctBg");
out.print(tt);
out.print("</td><td>");
%>
<a href="dct_detail.jsp?dctno=<%=dctno%>">进入预约>></a>
</td></tr>
<%
}
out.print("</table>");
RS.close();
%>
<center><form><input type='button' value='返回上一页' onClick='backward()'></form></center>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -