📄 deptsearch2.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>
<%
String tname=request.getParameter("DeptDesc");
byte tn[]=tname.getBytes("ISO-8859-1");
tname=new String(tn);
String sqlname ="";
if(!tname.equals(""))
{sqlname = "DeptDesc LIKE '%"+tname+"%'";}
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();
ResultSet RS = Stmt.executeQuery("SELECT DeptNo,DeptName,DeptDesc FROM Department WHERE "+sqlname);
String tt;
out.print("<h2><center>有相应症状的科室：</center><h2><p><p>");
out.print("<table align=center cellpadding=10 width='60%' border=0>");
out.print("<tr><td align=center>科室名称</td><td align=center>科室描述</td><tr>");
boolean hasrow= false ;
while (RS.next()) {
hasrow= true ;
out.print("<tr><td width=30% align=center>");
deptno=RS.getString("DeptNo");
tt = RS.getString("DeptName");
out.print("<a href='dept_detail.jsp?deptno="+deptno+"'>"+tt+"</a>");
out.print("</td><td width=70% align=center>");
tt = RS.getString("DeptDesc");
out.print(tt);
out.print("</td>");
%>
</td><tr>
<%
}
if(!hasrow)
{
out.print("<tr><td align=center colspan=2>暂无法提供符合你要求的科室，你可继续查询或直接致电咨询！</td></tr>");
}
out.print("<tr><td colspan=2><br></td></tr><tr><td align=center colspan=12><div ><form action='Deptsearch1.jsp'><input type='submit' id='submit' value='返回继续搜索'></form></div></td></tr>");
out.print("</table>");
RS.close();
%>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -