⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 del_doc_iden.jsp

📁 实现了一个医院门诊预约系统
💻 JSP
字号:
🔍 
<SCRIPT language="javascript">
function backward()
{
      history.back();
}
</SCRIPT>
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@ 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>


<%
    String delno=null;
    delno=request.getParameter("delno");
    
   /*if(delno==null)
    {
    StringBuffer url = request.getRequestURL(); 
    if (request.getQueryString() != null) 
    { 
      url.append('?');
      url.append(request.getQueryString()); 
    }
    delno=url.toString();
    delno=delno.substring(62);
    }*/
    
    String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";  
    String sConnStr = "jdbc:odbc:HCRS";
    Connection Con = null;
    Statement Stmt = null;
    ResultSet RS;
 
    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());
    }
   
   /*out.print(delno);*/
  Stmt = Con.createStatement();    /*创建JDBC声明*/ 
  RS= Stmt.executeQuery("SELECT DctNo,DctName,DctSex,DctBg,DctPost,DctAchv,OfficeLoc FROM Doctor,Office WHERE Office.OfficeNo=Doctor.OfficeNo AND DctNo='"+delno+"' ");
 while (RS.next()) {
 %>
 <form action="del_doc_query.jsp" method="post">
 	<input type="hidden" name="DctNo" value="<%=delno%>">
  <table width="80%" border="2" cellpadding=3 cellspacing=3  align="center">
  <tr>
 <td colspan="2"><center><div id="sheet-head">请确认你要删除的医生信息:</div></center>
 <tr>
   <td width="30%" align=center>医生编号:
   <td width="70%"><%=RS.getString("DctNo")%>
 <tr>
   <td width="30%" align=center>医生姓名:
  <td width="70%"><%=RS.getString("DctName")%>
<tr>
  <td width="30%" align=center>学历：
  <td width="70%"><%=RS.getString("DctBg")%>

<tr>
  <td width="30%" align=center>职位:
  <td width="70%"><%=RS.getString("DctPost")%>

<tr>
  <td width="30%" align=center>主要成就：
  <td width="70%"><%=RS.getString("DctAchv")%>
  	
<tr>
  <td width="30%" align=center>办公地点：
  <td width="70%"><%=RS.getString("OfficeLoc")%>
<tr>
   <td colspan="2"><center><input type="submit" id="submit" class="submit" value="删除">&nbsp;&nbsp;&nbsp;<input type="button" id="button" class="button" onClick="backward()" value="返回上一步"></center></td>

</tr>
</tr>
</tr>
</tr>
</tr>
</tr>
</tr>
</tr>
</table>
</form>

<%
  }
   
%>


</body>
</html>

⌨️ 快捷键说明

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