⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 getpatienthistory.jsp

📁 经典的“医疗门诊查询系统”JSP源代码
💻 JSP
字号:
<%@ page contentType="text/html; charset=gbk"%><%@ include file = "../include/ccs.inc" %>
<%@ page import="hospital.db.dboperation.*" %>
<%@ page import="hospital.db.*" %>
<%@ page import="java.sql.*" %>

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

</head>
<%
String _getPatientHistory="";
Doctor doctor=(Doctor)session.getAttribute("doctor");
ResultSet rs=null;

if(doctor==null)
	_getPatientHistory="请先<a href=\"/hospital/doctor/login.jsp\">登录</a>";

else{
int g=doctor.getPatientsHistory(null);
switch(g){
	case 1:
		_getPatientHistory="查询成功";
		rs=doctor.getResultSet();
		break;
	case 0:
		_getPatientHistory="一般异常";
		break;
	case -1:
		_getPatientHistory="数据库异常";
		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/doctor.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">
										<p><%=_getPatientHistory%></p>
<table width="100%">
	<tr>
		<th></th>
		<th></th>
		<th>姓名</th>
		<th>年龄</th>
		<th>性别</th>
		<th>地址</th>
		<th>电话</th>
		<th>症状</th>
		<th>诊断</th>
		<th>处方</th>
		<th>开始时间</th>
		<th>结束时间</th>
	</tr>
<%while(rs!=null && rs.next()){%>
<tr align="center">
	<td><a href="updateHistory.jsp?hid=<%=rs.getInt("HID")%>">更改</a></td>
	<td><a href="finishHistory.jsp?hid=<%=rs.getInt("HID")%>">结束</a></td>
	<td><%=Util.decode(rs.getString("Name"))%></td>
	<td><%=rs.getInt("Age")%></td>
	<td><%=rs.getInt("Sex")%></td>
	<td><%=Util.decode(rs.getString("Address"))%></td>
	<td><%=rs.getString("Phone")%></td>
	<td><%=Util.decode(rs.getString("Diagnose"))%></td>
	<td><%=Util.decode(rs.getString("Description"))%></td>
	<td><%=Util.decode(rs.getString("Rx"))%></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(doctor!=null)
	doctor.closeConnection();
%>

⌨️ 快捷键说明

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