📄 list_searchdoc.jsp

📁 实现了一个医院门诊预约系统
💻 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("DoctorName");
    byte tn[]=tname.getBytes("ISO-8859-1");
    tname=new String(tn);
  /*out.print(tname);*/
    String sqlname ="";
    if(!tname.equals(""))
     {sqlname = "Doctor.DctName LIKE'%"+tname+"%'";} 
    
    String cate=request.getParameter("Category");
    byte ca[]=cate.getBytes("ISO-8859-1");
    cate=new String(ca);
  /*out.print(cate);*/
    String sqlcate ="";
    if(!cate.equals(""))
     {sqlcate = "Department.DeptName='"+cate+"'";} 
     
    String tpost=request.getParameter("DoctorPost");
    byte tp[]=tpost.getBytes("ISO-8859-1");
    tpost=new String(tp);
  /* out.print(tpost);*/
    String sqlpost ="";
    if(!tpost.equals(""))
     {sqlpost = "Doctor.DctPost LIKE'%"+tpost+"%'";} 
  %>
 
<%    
    String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";  
    String sConnStr = "jdbc:odbc:HCRS";
    Connection Con = null;
    Statement Stmt = null;
    ResultSet RS=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();
  if(sqlname.equals(""))
  {
    if(!sqlpost.equals("")&&!sqlcate.equals(""))
       { RS= Stmt.executeQuery("SELECT DctNo,DctName,DctSex,DctBg,DctPost,DctAchv,OfficeLoc,DeptName FROM Doctor,Office,Department WHERE Department.DeptNo=Doctor.DeptNo AND Doctor.OfficeNo=Office.OfficeNo AND "+sqlcate+" AND "+sqlpost); }
    else  if(!sqlpost.equals(""))
    	{
    	   RS= Stmt.executeQuery("SELECT DctNo,DctName,DctSex,DctBg,DctPost,DctAchv,OfficeLoc,DeptName FROM Doctor,Office,Department WHERE Department.DeptNo=Doctor.DeptNo AND Doctor.OfficeNo=Office.OfficeNo AND "+sqlpost); 
    	}  
    else
    	   RS= Stmt.executeQuery("SELECT DctNo,DctName,DctSex,DctBg,DctPost,DctAchv,OfficeLoc,DeptName FROM Doctor,Office,Department WHERE Department.DeptNo=Doctor.DeptNo AND Doctor.OfficeNo=Office.OfficeNo AND "+sqlcate); 
    	
  }
  else
  { RS= Stmt.executeQuery("SELECT DctNo,DctName,DctSex,DctBg,DctPost,DctAchv,OfficeLoc FROM Doctor,Office WHERE Office.OfficeNo=Doctor.OfficeNo AND "+sqlname);}
  	  
  	   
 String tt;
 String Dctno;
 
 out.print(" <a align=right href='admin_log_default.jsp' id='button'>返回后台主页</a>");
 out.print("<center><div id='text-head'>符合搜索的医生列表</div></center><p><p>");
 out.print("<hr color=#cc0000 size=3 width=100%/><p>");
 out.print("<table align=center border=0 cellpadding=2 cellspacing=3>");
 
 if(sqlname.equals(""))
  { out.print("<td align=center>科室</td>");}
 out.print("<td align=center>医生编号</td><td align=center>医生姓名</td><td align=center>性别</td><td align=center>学历</td><td align=center>职位</td><td align=center>办公地点</td></tr>");
 
 boolean hasrow= false ;
   while (RS.next()) {
   hasrow= true ;
   if(sqlname.equals(""))  
   {
      out.print("</td><td align=center>");
      out.print(cate);
    }
 
   out.print("</td><td align=center>");
   tt=RS.getString("DctNo");
   Dctno=tt;
   out.print(tt);
  
   out.print("</td><td align=center width=90>");
   tt = RS.getString("DctName");
   out.print(tt);
   
   out.print("</td><td align=center>"); 
   tt=RS.getString("DctSex");
   out.print(tt);
   
   out.print("</td><td align=center >");
   tt=RS.getString("DctBg");
   out.print(tt);
   
   
   out.print("</td><td align=center >");
   tt=RS.getString("DctPost");
   out.print(tt);
   
   out.print("</td><td align=center >");
   tt=RS.getString("OfficeLoc");
   out.print(tt);
 %>

  
   <td align=center>
   <a href="del_doc_iden.jsp?delno=<%=Dctno%>"><span>删除</span></a>
   <a href="upd_doc_iden.jsp?updno=<%=Dctno%>"><span>修改</span></a>
   </td><tr>
	<%
 }
 if(!hasrow)
 {
   out.print("<tr><td align=center colspan=12>暂无符合你要求的记录</td></tr>");
   
 }
    
 out.print("<tr><td colspan=12><br></td></tr><tr><td align=center colspan=12><div id='sheet'><form action='ser_doctor.jsp'><input type='submit' id='submit' class='submit' value='返回继续搜索'></form></div></td></tr>");
 out.print("</table>");
 
 RS.close();
 

%>
💿 文件大小 379 K
👤 上传用户 newyearday
📂 所属分类数据库系统
⌨️ 快捷键说明

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