📄 list_dept.jsp
字号:
<%@ page contentType="text/html; charset=GBK" %>
<%@ 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>
<script language="JavaScript">
function check()
{
fr = document.searchDept;
if(fr.DeptDesc.value == "")
{
alert("请填写症状关键字!");
fr.DeptDesc.focus();
return;
}
fr.submit();
}
</script>
<form name="searchDept" id="searchDept" action="Deptsearch2.jsp" method="post">
<table align=center cellpadding=10 width='60%' border=1>
<tr>
<td colspan="2">如果你还不确定你的就医科室，请输入症状关键字</td>
</tr>
<tr>
<td width="30%" align=center>症状： </td>
<td width="70%"><input type="text" name="DeptDesc"></td>
</tr>
<tr>
<td colspan="2"><center><input type="button" id="button" value="查询" onClick="check()">
<input type="reset" id="reset" value="重置">
</center></td>
</tr>
</table>
</form>
<%
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 deptno = null;
Stmt = Con.createStatement(); /*创建JDBC声明*/
ResultSet RS = Stmt.executeQuery("SELECT DeptNo,DeptName FROM Department ORDER BY DeptNo");
out.print("<center><font size=5><b>请选择科室</b></font></center><p><p>");
String tt;
out.print("<table align=center border=0>");
while (RS.next()) {
out.print("<tr ><td align=center>");
deptno = RS.getString("DeptNo");
tt = RS.getString("DeptName");
%>
<a href="dept_detail.jsp?deptno=<%=deptno%>"><%=tt%></a>
</td></tr>
<%
}
out.print("</table>");
RS.close();
%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -