gethistory.jsp

来自「jsp+mysql医院门诊系统源码。admin, doctor, images,」· JSP 代码 · 共 87 行

JSP
87
字号
<%@ page contentType="text/html; charset=gbk"%><%@ include file = "../include/ccs.inc" %>
<%@ page import="hospital.db.dboperation.*" %>
<%@ page import="hospital.db.*" %>
<%@ page import="java.sql.*" %>
<%@ include file = "../include/ccs.inc" %>

<html>
<head>
<title>医院门诊预约系统-病历查询</title>
</head>

<%
Patient patient=(Patient)session.getAttribute("patient");
String _getHistory="";
ResultSet rs=null;

if(patient==null)
	_getHistory="请先<a href=\"/hospital/patient/login.jsp\">登录</a>";
else{
int g=patient.getHistory();
switch(g){
	case 1:
		_getHistory="查询成功";
		rs=patient.getResultSet();
		break;
	case 0:
		_getHistory="一般异常";
		break;
	case -1:
		_getHistory="数据库异常";
		break;
}
}
%>

<body bgcolor="#ffffff">

<table width="770" height="423" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#000000">
	<tr>
		<td height="421" bgcolor="#FFFFFF">
			<%@ include file = "../include/head.inc" %>
			<table width="770" height="290" border="0" align="center" cellpadding="0" cellspacing="0">
				<tr>
					<%@ include file = "../include/patient.inc" %>
					<td width="603" align="center" valign="top">
						<table width="100%" height="85%" border="0" cellpadding="3" cellspacing="1" bgcolor="#666666">
							<tr>
								<td width="100%" height="257" align="center" valign="top" bgcolor="E3EDFF">
								<br>
								<p><strong><%=_getHistory%></strong></p>
								<table width="100%">
									<tr>
										<th>医生编号</th>
										<th>症状</th>
										<th>诊断</th>
										<th>处方</th>
										<th>治疗是否结束</th>
										<th>治疗开始时间</th>
										<th>治疗结束时间</th>
									</tr>
									<%while(rs!=null && rs.next()){%>
									<tr align="center">
									<td><%=rs.getString("Doctor")%></td>
									<td><%=Util.decode(rs.getString("Description"))%></td>
									<td><%=Util.decode(rs.getString("Diagnose"))%></td>
									<td><%=Util.decode(rs.getString("Rx"))%></td>
									<td><%=rs.getInt("Finished")%></td>
									<td><%=rs.getDate("SDate")%></td>
									<td><%=rs.getDate("FDate")%></td>
									</tr>
									<%}%>
									</table>
									</td>
								</tr>
							</table>
						</td>
					</tr>
			</table></td>
	</tr>
</table>
</body>
</html>
<%
if(patient!=null)
	patient.closeConnection();
%>

⌨️ 快捷键说明

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