📄 list_doctor.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.*"%>
<%@ page import="java.util.Date" %>

<html>
<head>
<title>医院门诊预约系统--医生管理</title>
</head>


<%    String  sDBDriver="sun.jdbc.odbc.JdbcOdbcDriver";
      String  sConnStr="jdbc:odbc:HCRS";
      String  username="";
      String  pwd1="";
      Connection connWeb=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 
    {
     connWeb=DriverManager.getConnection(sConnStr,username,pwd1);
     }
     catch(SQLException e)
    {
      out.print(e.toString());
    }
   Stmt=connWeb.createStatement(); 
%>
    
<%

  RS= Stmt.executeQuery("SELECT DctNo,DctName,DctSex,DctBirth,DctPost,DctAchv,OfficeLoc FROM Doctor,Office  WHERE Doctor.OfficeNo=Office.OfficeNo ORDER BY Doctor.DctNo" ); 
  String tt=null;
  String tid=null;
 /*java.util.Date now1=new java.util.Date(); */
/*  SimpleDateFormat fmt=new SimpleDateFormat("yyyy-mm-dd");*/
   
  out.print(" <a align=right href='admin_log_default.jsp' id='button'>返回后台主页</a>");
  out.print("<center>所有医生信息列表</center><p><p>");
  out.print("<center><hr color=#cc0000 size=3 width=100%/></center><p>");
  out.print("<table align=center border=0 cellpadding=5 cellspacing=3>");
  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><td align=center>办公地点</td><tr>");
  while (RS.next()) {
  
  out.print("<tr ><td align=center>");
  tt=RS.getString("DctNo");
  out.print(tt);
  
  out.print("</td><td align=center >");
  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("DctBirth");
  tid=tt.substring(0,10);
  out.print(tid);
  
  
  out.print("</td><td align=center >"); 
  tt=RS.getString("DctPost");
  out.print(tt);
  
  out.print("</td><td align=center>");
  tt=RS.getString("DctAchv");
  out.print(tt);
  
  out.print("</td><td align=center>");
  tt=RS.getString("OfficeLoc");
  out.print(tt);
  
   out.print("</td><tr>");
 }
 
 out.print("</table>");
 
 RS.close();
 

%>


</html>

💿 文件大小 379 K

👤 上传用户 newyearday

📂 所属分类数据库系统

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -