📄 del_rsv1.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>
<body>
<%
StringBuffer url = request.getRequestURL();
if (request.getQueryString() != null)
{
url.append('?');
url.append(request.getQueryString());
}
String delno=null;
delno=url.toString();
delno=delno.substring(46);
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(); /*创建JDBC声明*/
ResultSet RS = Stmt.executeQuery("SELECT PatientName,PatientSex,PatientAge,PatientId,PatientTel,RsvState,Doctor.DctNo,Doctor.DctName,PeriodName,Doctor.OfficeNo FROM Reservation,Doctor WHERE Doctor.DctNo=Reservation.DctNo AND RsvNo = '"+delno+"'");
while (RS.next()) {
%>
<form action="del_rsv2.jsp" method="post">
<input type="hidden" name="RsvNo" value="<%=delno%>">
<table width="60%" border="1" cellpadding=3 cellspacing=3 align="center">
<tr>
<td colspan="2"><h2><center>请确认你要撤销的预约:</center></h2>
</td>
</tr>
<tr>
<td width="30%" align=center>预约单号： </td>
<td width="70%"><%=delno%>
</td>
</tr>
<tr>
<td width="30%" align=center>姓名：
<td width="70%"><%=RS.getString("PatientName")%>
</tr>
<tr>
<td width="30%" align=center>性别：
<td width="70%"><%=RS.getString("PatientSex")%>
</tr>
<tr>
<td width="30%" align=center>年龄：
<td width="70%"><%=RS.getString("PatientAge")%>
</tr>
<tr>
<td width="30%" align=center>身份证号：
<td width="70%"><%=RS.getString("PatientId")%>
</tr>
<tr>
<td width="30%" align=center>电话：
<td width="70%"><%=RS.getString("PatientTel")%>
</tr>
<tr>
<td width="30%" align=center>预约状态：
<td width="70%"><%=RS.getString("RsvState")%>
</tr>
<tr>
<td width="30%" align=center>医生姓名：
<td width="70%"><%String dctno=RS.getString("DctNo");
String dctname=RS.getString("DctName");
out.print(dctname);%>
<tr>
<td width="30%" align=center>预约时间：
<td width="70%"><%String pername=RS.getString("PeriodName");
out.print(pername);%>
</tr>
<tr>
<td width="30%" align=center>办公室号：
<td width="70%"><%=RS.getString("OfficeNo")%>
</tr>
<tr>
<td colspan="2"><center> <input type="hidden" name="DctNo" value="<%=dctno%>">
<input type="hidden" name="PeriodName" value="<%=pername%>"><input type="submit" value="删除"> <input type="button" id="button" onClick="backward()" value="返回上一步"/></center></td>
</tr>
</table>
<%
}
RS.close();
%>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -