📄 adminsearchteacher.jsp

📁 这是一个在线教育系统
💻 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+"%' "; 
out.print("<SCRIPT language=JavaScript>alert('"+sql+"');</SCRIPT>");
 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: #69C37C
}
.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>
<%}
%>
⌨️ 快捷键说明

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