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

📄 getcurrentdoctorinfo.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>

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

if(patient==null)
	_getCurrentDoctorInfo="请先<a href=\"/hospital/patient/login.jsp\">登录</a>";
else{
	int g=patient.getCurrentDoctorInfo();
	switch(g){
		case 1:
			_getCurrentDoctorInfo="查询成功";
			rs=patient.getResultSet();
			break;
		case 0:
			_getCurrentDoctorInfo="一般异常";
			break;
		case -1:
			_getCurrentDoctorInfo="数据库异常";
			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">
									<p><%=_getCurrentDoctorInfo%></p>
									<table width="100%">
									<tr>
										<th>医生姓名</td>
										<th>年龄</th>
										<th>性别</th>
										<th>职称</th>
										<th>科室</th>
										<th>特长</th>
										<th>电话</th>
									</tr>
									<%while(rs!=null && rs.next()){%>
									<tr align="center">
									<td><%=Util.decode(rs.getString("Name"))%></td>
									<td><%=rs.getInt("Age")%></td>
									<td><%=rs.getInt("Sex")%></td>
									<td><%=Util.decode(rs.getString("Level"))%></td>
									<td><%=Util.decode(rs.getString("Section"))%></td>
									<td><%=Util.decode(rs.getString("Specialism"))%></td>
									<td><%=rs.getString("Phone")%></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 + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -