📄 list_searchfrom_time.jsp

📁 实现了一个医院门诊预约系统
💻 JSP
字号:
<SCRIPT language="javascript">
function backward()
{
      history.back();
}
</SCRIPT>
<%@ 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 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();
	
	String day=request.getParameter("day");
	byte dn[]=day.getBytes("ISO-8859-1");
	day=new String(dn);
    String sqlday ="";
    if(!day.equals(""))
    {sqlday = "星期"+day+" ";}

    String ftime=request.getParameter("time_from");
	int from = Integer.parseInt(ftime);
    String ttime=request.getParameter("time_to");
	int to = Integer.parseInt(ttime);
    String sqltime ="";
	int n = to - from;
	String tt;
    out.print("<h2><center>符合搜索的医生列表</center></h2><p><p>");
	out.print("<hr size=3 width=70%/><p>");
    out.print("<table align=center cellpadding=10 width='60%' border=0>");
    out.print("<tr><td align=center>时间段</td><td align=center>医生姓名</td><tr>");
	String editno1 = null;
	String editno2 = null; 
 	String deptno =request.getParameter("DeptNo");
	boolean hasrow = false ;
	int f;
	int t;
	
	for(int i = 0;i < n;i ++)
	{	
	    int mark = 0;
	    f = from + i;
		t = f + 1;
		String time1 = Integer.toString(f);
		String time2 = Integer.toString(t);
	    sqltime = time1 + ":00-" + time2 + ":00";
		String sql = sqlday + sqltime;
        ResultSet RS = Stmt.executeQuery("SELECT d.DctNo,d.DctName,s.PeriodName FROM Doctor d,Schedule s WHERE d.DeptNo='"+deptno+"' AND d.DctNo=s.DctNo AND s.PeriodState='Y' AND s.PeriodCount>0 AND s.PeriodName='"+sql+"'"); 
			
        while (RS.next()) 
		{
		    hasrow= true ;
            out.print("<tr ><td align=center width=200>");
            if(mark == 0)
			{
			    out.print(sql);
				mark++;
			}
            out.print("</td><td align=center>");
            editno1=RS.getString("DctNo");
			String sub=null;
	        int j;
	        for(j=0;j<editno1.length()-1;j++)
	       {
	          sub=editno1.substring(j,j+1);
	          if(sub.equals(" "))
	            break;
        	}
			editno1=editno1.substring(0,j);
			
			tt = RS.getString("DctName");
            editno2=RS.getString("PeriodName");         
            out.print("<a href='dct_detail_time.jsp?dctno="+editno1+"&schname="+editno2+"'>"+tt+"");
			out.print("</a></td><tr>");
		}
		if(!hasrow)
        {
		    out.print("<tr ><td align=center>");
			out.print(sql);
			out.print("</td><td align=center>");
            out.print("暂无符合你要求的医生坐诊</td></tr>");   
        }
		hasrow = false;    
		RS.close();
	}
%>
    </table>
    <center><form><input type='button' value='返回继续搜索' onClick='backward()'></form></center>


</body>
</html>
⌨️ 快捷键说明

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