【JSP开源代码栏目提醒】:网学会员为需要JSP开源代码的朋友们搜集整理了adminsearchteacher.jsp相关资料,希望对各位网友有所帮助!
<%@ include file="conn.jsp"%>
<%@ include file="fenlei.jsp"%>
<%@ include file="isadmin.jsp"%>
<%
request.setCharacterEncoding("GB2312");
String fenlei1=request.getParameter("fenlei1");
String fenlei2=request.getParameter("fenlei2");
String teacher=request.getParameter("teacher");
String id=request.getParameter("id");
String strquery1 = "";
sql="select * from scott.teacher where fenlei1 like '%"+fenlei1+"%' and fenlei2 like '%"+fenlei2+"%' and teacher like '%"+teacher+"%' and teacherid like '%"+id+"%' ";
rs=stmt.executeQuery(sql);
if(!rs.next()){
out.print("<SCRIPT language=JavaScript>alert('没有找到符合条件的教师!');");
out.print("history.go(-1);</SCRIPT>");
}else{
sql="select * from scott.teacher where fenlei1 like '%"+fenlei1+"%' and fenlei2 like '%"+fenlei2+"%' and teacher like '%"+teacher+"%' and teacherid like '%"+id+"%' ";
rs=stmt.executeQuery(sql);
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<STYLE>TD {
FONT-SIZE: 9pt; LINE-HEIGHT: 140%
}
BODY {
FONT-SIZE: 9pt; LINE-HEIGHT: 140%
}
A:link {
COLOR: #0033cc; TEXT-DECORATION: none
}
A:visited {
COLOR: #0033cc; TEXT-DECORATION: none
}
A:active {
COLOR: #ff0000; TEXT-DECORATION: none
}
A:hover {
COLOR: #000000; TEXT-DECORATION: underline
}
.header {
font-family: Tahoma, Verdana; font-size: 9pt; color: #FFFFFF; background-color: #00CCCC
}
.category{
font-family: Tahoma, Verdana; font-size: 9pt; color: #000000; background-color: #EFEFEF
}
</STYLE>
<title>教师管理</title>
</head>
<body text=#000000 bgColor=#ffffff leftMargin=0 topMargin=0>
<br>
<table style="BORDER-COLLAPSE: collapse" borderColor=#808080 width="500" border="1" align="center" cellpadding=1>
<tr>
<td align="center" class="header" colspan=7>搜索到的教师列表 <a href="addteacher.jsp">添加</a></td>
</tr>
<tr>
<td>ID</td>
<td>教师</td>
<td>教师所属<%=strfenlei1%></td>
<td>教师所属<%=strfenlei2%></td>
<td>编辑</td>
<td>资料列表</td>
<td>删除</td>
</tr>
<%
while(rs.next()){
out.print( "<tr>");
out.print( "<td>"+rs.getString("teacherid")+"</td>");
out.print( "<td><a href=teacherinfo.jsp?id="+rs.getString("teacherid")+">"+rs.getString("teacher")+"</a></td>");
out.print("<td>"+rs.getString("fenlei1")+"</td>");
out.print( "<td>"+rs.getString("fenlei2")+"</td>");
out.print( "<td><a href=editteacher.jsp?id="+rs.getString("teacherid")+">编辑</a></td>");
out.print( "<td><a href=adminlist.jsp?teacherid="+rs.getString("teacherid")+">资料列表</a></td>");
out.print( "<td><a href=delteacher.jsp?id="+rs.getString("teacherid")+">删除</a></td>");
out.print( "</tr>");
}
%>
</table>
</body>
</html>
<%}
%>
上一篇:
adminsave.jsp
下一篇:
ASP小区停车管理系统(Access)(含录像)