📄 doctorsearch.jsp
字号:
<%@ page contentType="text/html; charset=gb2312"%>
<%@ page import="java.sql.*"%>
<%@ page import="java.util.Vector"%>
<%@ page import="com.hospital.web.psearch"%>
<%@ page session="true" %>
<%
String use=(String)session.getAttribute("username");
if ( use == null || use.equals("") ){
response.sendRedirect("login.jsp");
}
%>
<jsp:useBean id="link" scope="session" class="com.hospital.util.DBConnection" />
<jsp:useBean id="ps" scope="page" class="com.hospital.web.psearch" />
<html>
<head>
<title>患者页面</title>
ID号：<%=use%>
<script language=javascript>
function checkform1(){
if(document.form1.name1.value==0&&document.form1.section.value==0&&document.form1.level.value==0&&document.form1.sp.value==0)
{
alert("您没有选择查询方式!");
return false;
}
else if(document.form1.name1.value!=0&&document.form1.name2.value==""){
alert("请填写查询姓名");
return false;
}
return true;
}
function openScript(url,name, width, height){
var Win = window.open(url,name,'width=' + width + ',height=' + height + ',resizable=1,scrollbars=yes,menubar=no,status=yes' );
}
</script>
</head>
<body >
<td align="left" width="23%" valign="center">
<table width="100%" border="0" cellspacing="2" cellpadding="2">
<tr>
<td> </td>
</tr>
<tr>
<td align="left"><a href="main.jsp">回病人首页</a></td>
</tr>
<tr>
<td align="left"><a href="updateinfo.jsp">修改个人信息</a></td>
</tr>
<tr>
<td align="left"><a href="doctorsearch.jsp">医生预约查询</a></td>
</tr>
<tr>
<td align="left"><a href="app_cancel.jsp">患者预约信息</a></td>
</tr>
<tr>
<td align="left"><a href="logout.jsp">退出</a></td>
</tr>
</table>
</td>
<table align=center>
<form action="doctorsearch.jsp" method="post" name="form1" align=center>
姓名：
<select name="name1">
<option value=0 selected>
<option value=1 >姓氏
<option value=2 >全名
</select>
<input type="text" name="name2" size=5>  
科室：
<%
Connection conn_s = null;
Statement stmt_s = null;
ResultSet rs_s = null;
String sqlStr_s = "";
conn_s = link.getConnection();
stmt_s = conn_s.createStatement();
sqlStr_s="select * from section";
rs_s = stmt_s.executeQuery(sqlStr_s);
%>
<select name="section">
<option value=0 selected>
<%
while(rs_s.next()){
%>
<option value=<%=rs_s.getString("name")%>><%=rs_s.getString("name")%>
<%
;}
%>
</select>  
职称：
<%
Connection conn_l = null;
Statement stmt_l = null;
ResultSet rs_l = null;
String sqlStr_l = "";
conn_l = link.getConnection();
stmt_l = conn_l.createStatement();
sqlStr_l="select * from level";
rs_l = stmt_l.executeQuery(sqlStr_l);
%>
<select name="level">
<option value=0 selected>
<%
while(rs_l.next()){
%>
<option value=<%=rs_l.getString("lname")%>><%=rs_l.getString("lname")%>
<%
;}
%>
</select>  
<select name="sp">
<option value=0 selected>
<option value=2 >是
<option value=1 >不是
</select>专家号
<input type="submit" name="submit1" value="查询" onclick="javascript:return(checkform1());">
<input type="reset" name="reset1" value="重置"><br>
</form>
</table>
<table width="40%" border="1" cellspacing="1" cellpadding="1" align=center>
<tr align="center">
<td>Doctor ID</td>
<td>姓名</td>
<td>性别</td>
<td>科室</td>
<td>职称</td>
<td>是否为专家号</td>
<td>操作</td>
</tr>
<%
String mesf="";
String str1="";
String str2="";
int j=0;
String name2="";
int name1=0;
String section="";
String level="";
int sp=0;
if(request.getParameter("submit1")!=null){
name1=Integer.parseInt(request.getParameter("name1"));
name2=ps.unicodeGbk(request.getParameter("name2"));
section=ps.unicodeGbk(request.getParameter("section"));
level=ps.unicodeGbk(request.getParameter("level"));
sp=Integer.parseInt(request.getParameter("sp"));
ps.setIc(use);%>3<%
mesf=ps.doctorsearch(name1,name2,section,level,sp);
if(mesf==""){%>1<%
for(j=0;j<ps.getSearchlist_2().size();j++){
psearch dlist=(psearch)ps.getSearchlist_2().elementAt(j);
if(dlist.getSpa()==1)
str1="是";
else
str1="否";
%>
2
<tr>
<td align=center><%=dlist.getDid()%></td>
<td align=center><%=dlist.getName()%></td>
<td align=center><%=dlist.getSex()%></td>
<td align=center><%=dlist.getSection()%></td>
<td align=center><%=dlist.getLevel()%></td>
<td align=center><%=str1%></td>
<td align=center><a href="#" onclick="openScript('showdoctorapp.jsp','showdoctorapp',450,500)">预约信息</a>
</tr>
<%
}
}
}
%>
</table>
<%=mesf%>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -