📄 dct_resv.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@page pageEncoding="gb2312"%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312"/>
<title>我的预约患者</title>
</head>
<body>
<%
String DctNo=(String)session.getValue("DctNo");
if(DctNo==null||DctNo=="")
{%>
<div align="center"><p>对不起，您还没有登陆 </p></div>
<div align="center"><p><a href="dct_log_default.jsp">返回登陆页 </a></p></div>
<%}
else
{
// out.print(DctNo);
String weekdate=request.getParameter("weekdate");
byte[] tmpbyte=weekdate.getBytes("8859_1");
weekdate=new String(tmpbyte,"gb2312");
// out.print(weekdate);
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String driver = "jdbc:odbc:HCRS";
Connection conn = DriverManager.getConnection(driver,"sa","605605");
Statement stmt = conn.createStatement();
String sql1=null;
ResultSet rs1=null;
sql1="select Abstime from DateExc where Relatime like '"+weekdate+"'";
rs1=stmt.executeQuery(sql1);
rs1.next();
String Abstime = rs1.getString("Abstime");
Abstime = Abstime.substring(0,10);
String sql=null;
ResultSet rs=null;
sql="select PeriodName,PatientName,PatientSex,PatientAge,PatientSym,RsvState,RsvNo from Reservation where DctNo = '"+DctNo+"' and PeriodName like '"+weekdate+"%' order by PeriodName";
rs=stmt.executeQuery(sql);
boolean hasrow= false;
%>
<div align="center">
<table border='1' >
<tr><%=Abstime%><%=weekdate%></tr>
<tr>
<td align="center">时间段 </td><td>患者姓名 </td><td>患者性别 </td><td>患者年龄 </td><td>患者病症 </td><td>处理状态 </td><td></td>
</tr>
<%
while(rs.next())
{
hasrow= true;
String PeriodName = rs.getString("PeriodName");
PeriodName=PeriodName.substring(3);
String PatientName = rs.getString("PatientName");
String PatientSex = rs.getString("PatientSex");
String sex=new String("F");
if(PatientSex.equals(sex)==true)
PatientSex=new String("男");
else
PatientSex=new String("女");
String PatientAge = rs.getString("PatientAge");
String PatientSym = rs.getString("PatientSym");
String RsvState = rs.getString("RsvState");
String state=new String("Y");
if(RsvState.equals(state)==true)
RsvState=new String("是");
else
RsvState=new String("否");
String RsvNo = rs.getString("RsvNo");
%>
<tr>
<td> <%=PeriodName%> </td>
<td> <%=PatientName%> </td>
<td> <%=PatientSex%> </td>
<td> <%=PatientAge%> </td>
<td> <%=PatientSym%> </td>
<td> <%=RsvState%> </td>
<%if(RsvState.equals("否")==true)
{%>
<td><form action="dct_set_state.jsp">
<input type="hidden" name="RsvNo" value="<%=RsvNo%>">
<input type="submit" value="修改处理状态">
</form>
</td>
<%}%>
</tr>
<%
}
%>
</table>
</div>
<%
if(hasrow)
{%>
<div align="center">
<table border='0'>
<tr><td><form action="dct_set_state.jsp">
<input type="hidden" name="weekdate" value="<%=weekdate%>">
<input type="submit" value="全部设置成已处理">
</form>
</td></tr>
</table>
</div>
<%}
%>
<%
if(!hasrow)
{%>
<div align="center"><p>对不起,没有您要的信息@_@</p></div>
<%}
rs.close();
}
%>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -