📄 reserve_succ.jsp
字号:
<%@ 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>
</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(); /*创建JDBC声明*/
String Guidstr=(java.util.UUID.randomUUID()).toString();
String rsvid=Guidstr.substring(0,8);
String dctname = null;
String offno = null;
String dctno = request.getParameter("dctno");
ResultSet RS = Stmt.executeQuery("SELECT DctName,OfficeNo FROM Doctor WHERE DctNo='"+dctno+"'");
while (RS.next())
{
dctname = RS.getString("DctName");
offno = RS.getString("OfficeNo");
}
RS.close();
String date = null;
String schname = request.getParameter("schname");
byte sch[] = schname.getBytes("ISO-8859-1");
schname = new String(sch);
String day = schname.substring(0,3);
String time = schname.substring(6);
RS = Stmt.executeQuery("SELECT Abstime FROM DateExc WHERE Relatime='"+day+"'");
while (RS.next())
{
date = RS.getString("Abstime");
date = date.substring(0,10);
}
RS.close();
String pname = request.getParameter("PatientName");
byte pn[] = pname.getBytes("ISO-8859-1");
pname = new String(pn);
String psym = request.getParameter("PatientSym");
byte ps[] = psym.getBytes("ISO-8859-1");
psym = new String(ps);
String pid = request.getParameter("PatientId");
String psex = request.getParameter("PatientSex");
String age = request.getParameter("PatientAge");
int pages=java.lang.Integer.parseInt(age);
String ptel = request.getParameter("PatientTel");
int hasrec=0;
RS=Stmt.executeQuery("SELECT RsvNo FROM Reservation WHERE PatientId='"+pid+"' AND PeriodName='"+day+" "+time+"'");
while(RS.next())
{
hasrec=1;
}
RS.close();
String count=null;
RS=Stmt.executeQuery("SELECT COUNT(RsvNo) RsvCount FROM Reservation WHERE PatientId='"+pid+"' AND PeriodName LIKE '"+day+"%'");
while(RS.next())
{
count=RS.getString("RsvCount");
}
RS.close();
if(hasrec==0&&!count.equals("2"))
{
String sql = "INSERT INTO Reservation(RsvNo,PatientName,PatientSex,PatientAge,PatientId,PatientSym,PatientTel,DctNo,PeriodName,OfficeNo) VALUES('"+rsvid+"','"+pname+"','"+psex+"',"+pages+",'"+pid+"','"+psym+"','"+ptel+"','"+dctno+"','"+day+" "+time+"','"+offno+"')";
Stmt.executeUpdate(sql);
String sql2 = "UPDATE Schedule SET PeriodCount=PeriodCount-1 WHERE DctNo='"+dctno+"' AND PeriodName='"+day+" "+time+"'";
Stmt.executeUpdate(sql2);
%>
<table width="60%" border=0 cellpadding=10 align="center">
<tr><td align="center">预约成功！</td><tr>
<tr><td align="center"><font color=#FF0000>请您务必牢记以下信息！看病当天请凭预约单号获得预约挂号单，<br><br>我们真心的祝愿您早日康复！</font></td></tr>
</table>
<br><br><br>
<%
String offloc=null;
RS = Stmt.executeQuery("SELECT OfficeLoc FROM Office WHERE OfficeNo='"+offno+"'");
while(RS.next())
{
offloc= RS.getString("OfficeLoc");
}
RS.close();
%>
<table width="60%" border="2" cellpadding=3 cellspacing=3 align="center">
<tbody>
<tr>
<td width="30%" align=center>预约单号：
<td width="70%"><font color=#FF0000><b><%=rsvid%></b></font>
<tr>
<td width="30%" align=center>您预约的医生：
<td width="70%"><%=dctname%>
<tr>
<td width="30%" align=center>您预约的时间段：
<td width="70%"><%=date+" "+time%>
<tr>
<td width="30%" align=center>您的就医地点：
<td width="70%"><%=offloc%>
<tr>
<tr>
<td colspan="2"><center><a href="index.html">返回首页</center></td>
<tr>
</td>
</tr>
</table>
<%}
else
{
if(hasrec==1)
{
%>
<table width="60%" border="0" cellpadding=3 cellspacing=3 align="center">
<tr height="300"><td align="center"><font color=#FF0000>抱歉，我们无法受理你的预约！</font><br><br><br>你已经在相同的时间进行了预约，请选择其他时段！</td></tr>
<tr>
<td><center><a href="index.html">返回首页</center></td>
</tr></table>
<%}
else
{
%>
<table width="60%" border="0" cellpadding=3 cellspacing=3 align="center">
<tr height="300"><td align="center"><font color=#FF0000>抱歉，我们无法受理你的预约！</font><br><br><br>你在同一天已经预约了两次，<br><br>考虑到他人的就医要求和防止恶意预约，<br><br>请你撤销你已经存在的预约后再进行预约！</td></tr>
<tr>
<td><center><a href="index.html">返回首页</center></td>
</tr></table>
<%}
}
%>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -