📄 reserve.jsp
字号:
<SCRIPT language="javascript">
function backward()
{
history.back();
}
</SCRIPT>
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<html>
<head>
<title>医院门诊预约系统——预约信息填写</title>
</head>
<script language="JavaScript">
function check()
{
fr = document.reserve;
if(fr.PatientName.value == "")
{
alert("患者姓名必须要填写！");
fr.PatientName.focus();
return;
}
if(fr.PatientSym.value == "")
{
alert("病症必须要填写！");
fr.PatientAge.focus();
return;
}
if(fr.PatientId.value == "")
{
alert("患者身份证号必须要填写！");
fr.PatientId.focus();
return;
}
if(fr.PatientSex.value == "")
{
alert("患者性别必须要填写！");
fr.PatientSex.focus();
return;
}
if(fr.PatientAge.value == "")
{
alert("患者年龄必须要填写！");
fr.PatientAge.focus();
return;
}
if(fr.PatientTel.value == "")
{
alert("患者联系电话必须要填写！");
fr.PatientTel.focus();
return;
}
else
{
if(!isnum(fr.PatientTel.value))
{
alert("联系电话只能由数字构成！");
fr.PatientTel.focus();
return;
}
}
fr.submit();
}
function isnum(theStr)
{
var flag = true;
var len = theStr.length;
for(var i = 0; i < len; i++)
{
if((theStr.charAt(i)>'9') || (theStr.charAt(i) <'0'))
flag = false;
}
return flag;
}
</script>
<body>
<%
StringBuffer url = request.getRequestURL();
if (request.getQueryString() != null)
{
url.append('?');
url.append(request.getQueryString());
}
String dctno=null,schname=null;
dctno=url.toString();
schname=url.toString();
String sub=null;
int j;
for(j=45;j<dctno.length()-1;j++)
{
sub=dctno.substring(j,j+1);
if(sub.equals("&"))
break;
}
dctno=dctno.substring(45,j);
schname=schname.substring(j+9);
byte schn[]=schname.getBytes("ISO-8859-1");
schname=new String(schn);
String day=schname.substring(0,3);
String time=schname.substring(6);
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 DctName FROM Doctor WHERE DctNo='"+dctno+"'");
while (RS.next())
{
%>
<form name="reserve" id="reserve" action="reserve_iden.jsp" method="post">
<table width="60%" border="2" cellpadding=3 cellspacing=3 align="center">
<tr>
<td colspan="2" height="80">您预约的医生及时间段为：<font color=#FF0000><b><%=RS.getString("DctName")%>
<%
}
RS.close();
RS = Stmt.executeQuery("SELECT Abstime FROM DateExc WHERE Relatime='"+day+"'");
while (RS.next())
{
String date=RS.getString("Abstime");
date=date.substring(0,10);
out.print(date+"("+day+")"+" "+time);
}%></b></font>
</td>
</tr>
<%
RS.close();
%>
<tr>
<td colspan="2"><h3>请填写您的详细信息：</h3></td>
</tr>
<tr>
<td width="30%" align=center>患者姓名</td>
<td width="70%"><input type="text" class="text" name="PatientName"> *</td>
</tr>
<tr>
<td width="30%" align=center>患者身份证号</td>
<td width="70%"><input type="text" class="text" name="PatientId"> *</td>
</tr>
<tr>
<td width="30%" align=center>患者性别</td>
<td width="70%"><input type="radio" name="PatientSex" value="M" checked="checked">男
<input type="radio" name="PatientSex" value="F">女</td>
</tr>
<tr>
<td width="30%" align=center>患者年龄</td>
<td width="70%"><input type="text" class="text" name="PatientAge">岁 *</td>
</tr>
<tr>
<td width="30%" align=center>联系电话</td>
<td width="70%"><input type="text" class="text" name="PatientTel"> *</td>
</tr>
<tr>
<td width="30%" align=center>症状</td>
<td width="70%"><textarea name="PatientSym" rows=10 cols=60></textarea> *</td>
</tr>
<tr>
<td colspan="2"><center>
<input type="hidden" name="dctno" value=<%=dctno%>><input type="hidden" name="schname" value=<%=schname%>><input type="button" id="button" class="button" value="确定" onClick="check()"> <input type="reset" id="reset" class="reset" value="重置"> <input type='button' value='返回' onClick='backward()'></form>
</center></td>
</tr>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -