📄 list_schedule.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 cate=request.getParameter("deptname");
    byte ca[]=cate.getBytes("ISO-8859-1");
    cate=new String(ca);
   /*out.print(cate);*/
   String sqlcate ="";
   if(!cate.equals(""))
     {sqlcate = "Department.DeptName='"+cate+"'";} 
    
    
    String tno=request.getParameter("doctorNo");
    byte tdctno[]=tno.getBytes("ISO-8859-1");
    tno=new String(tdctno);
   /* out.print(tno);*/
    String sqlno ="";
    if(!tno.equals(""))
     { sqlno = "Schedule.DctNo='"+tno+"'"; } 
     
   /*  out.print(sqlno);*/
     
     
	  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 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("")&&sqlno.equals(""))
  {
    RS= Stmt.executeQuery("SELECT PeriodNo,Doctor.DctNo,Doctor.DctName,PeriodName,PeriodState,PeriodCount,Schedule.PeriodMax FROM Schedule,Department,Doctor WHERE Schedule.DctNo=Doctor.DctNo AND Department.DeptNo=Doctor.DeptNo AND "+sqlcate); 
  }
  else if(sqlno.equals(""))
  	{ RS= Stmt.executeQuery("SELECT PeriodNo,Doctor.DctNo,Doctor.DctName,PeriodName,PeriodState,PeriodCount,Schedule.PeriodMax FROM Schedule,Doctor WHERE Schedule.DctNo=Doctor.DctNo AND "+sqlname);} 
  else
  	{ RS= Stmt.executeQuery("SELECT PeriodNo,Doctor.DctNo,Doctor.DctName,PeriodName,PeriodState,PeriodCount,Schedule.PeriodMax FROM Schedule,Doctor WHERE Schedule.DctNo=Doctor.DctNo AND "+sqlno);} 
  	
%>

<%  
   String tt;
   String DctNo;
   String DctName;
   String PeriodNo;
  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("")&&sqlno.equals(""))
  { 
   out.print("<tr align=center>");out.print( cate);out.print("</tr>");}
   out.print("<tr><td align=center>时段号</td><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 ;
   
   out.print("</td><td align=center>"); 
   tt=RS.getString("PeriodNo");
   PeriodNo=tt;
   out.print(tt);
   
   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");
   DctName=tt;
   out.print(tt);
   
  
   out.print("</td><td align=center >");
   tt=RS.getString("PeriodName");
   out.print(tt);
   
   
   out.print("</td><td align=center >");
   tt=RS.getString("PeriodState");
   if(tt.equals("Y")||tt.equals("y"))
   { tt="是";}else {tt="否";}
     out.print(tt);
   
   out.print("</td><td align=center >");
   tt=RS.getString("PeriodCount");
   out.print(tt);
   
   out.print("</td><td align=center >");
   tt=RS.getString("PeriodMax");
   out.print(tt);
   
   %>

  
  <!-- <td align=center>
   	
   <form action='del_schedule.jsp'>
   	<input type="hidden" name="DctNo" value="<%=DctNo%>">
   	<input type='submit' id='submit' class='submit' value="删除">
   	</form>
  </td>
  <td>-->
  
  <td align=center>
   	
   <form action='upd_schedule.jsp'>
   	<input type="hidden" name="DctNo" value="<%=DctNo%>">
   	<input type="hidden" name="PeriodNo" value="<%=PeriodNo%>">
   	<input type='submit' id='submit' class='submit' value="修改">
   	</form>
   	
   </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='schedule_search.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 + -