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

📄 getappointmentinfo.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 _getAppointmentInfo="";
ResultSet rs=null;
int qid=0;

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

	else{
		int g=patient.getAppointmentInfo();

		switch(g){
			case 1:
				_getAppointmentInfo="查询成功";
				rs=patient.getResultSet();
				break;
			case 0:
				_getAppointmentInfo="一般异常";
				break;
			case -1:
				_getAppointmentInfo="数据库异常";
				break;
			case -2:
				_getAppointmentInfo="用户未预约";
				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="100%" border="0" cellpadding="3" cellspacing="1" bgcolor="#666666">
								<tr>
									<td width="100%" height="257" align="center" valign="top" bgcolor="E3EDFF">
									<p><%=_getAppointmentInfo%></p>
									<p align="left"><strong>单击预约编号取消预约</strong></p>
									<table width="100%">
									<tr>
										<th>预约编号</th>
										<th>医生编号</th>
										<th>0-周日,1-周一,以此类推</th>
										<th>0-上午,1-下午</th>
										<th>预约日期</th>
									</tr>
									<%while(rs!=null && rs.next()){%>
									<tr align="center">
										<td><a href="cancleAppointment.jsp?qid=<%=(qid=rs.getInt("QID"))%>" onclick="return confirm('确实要取消此预约吗?');">
										<%=qid%></a></td>
										<td><%=rs.getString("Doctor")%></td>
										<td><%=rs.getInt("Day")%></td>
										<td><%=rs.getInt("AP")%></td>
										<td><%=rs.getDate("Date")%></td>
									</tr>
									<%}%>
									</table>
									</td>
								</tr>
							</table>
						</td>
					</tr>
			</table></td>
	</tr>
</table>
</body>
</html>

⌨️ 快捷键说明

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