WebRoot/admin/tech-find.jsp

微信扫码关注公众号，代码整理好后第一时间通知你。

<%@ page contentType="text/html; charset=utf-8" import="java.sql.*"%>
<html>
<jsp:useBean id="dd" scope="session" class="stu.admin"/>
<head>
<title>管理员页面</title>
<link type="text/css" rel=stylesheet href=../css/main.css >
</head>
<body>
<br><br><br>
<div align=center>
<h2>教师信息如下：</h2><hr>
<table class=table >
<% 
   request.setCharacterEncoding("utf-8");
   String id=request.getParameter("id");
   String name=request.getParameter("name");
    dd.setid(id);
    String di=dd.getid();
     
	String user="root";
	String password="root";
	String url="jdbc:mysql://localhost:3306/JSFP";
	
	Class.forName("com.mysql.jdbc.Driver");
	Connection conn=DriverManager.getConnection(url,user,password);
	Statement state=conn.createStatement();
	String sql="select * from teacher where id='"+id+"' or name='"+name+"' ";

	ResultSet rs=null;
	rs=state.executeQuery(sql);
	if(rs.next()){
	
%>
<tr><td  style="font-size:20px">工号：</td><td style="font-size:20px"><%=rs.getString("id")%></td></tr>
<tr><td  style="font-size:20px">姓名：</td><td style="font-size:20px"><%=rs.getString("name") %></td></tr>
<tr><td  style="font-size:20px">学院：</td><td style="font-size:20px"><%=rs.getString("college") %></td></tr>
<tr><td  style="font-size:20px">专业：</td><td style="font-size:20px"><%=rs.getString("sex") %></td></tr>
<tr><td  style="font-size:20px">电话：</td><td style="font-size:20px"><%=rs.getString("tel") %></td></tr>
<tr><td  style="font-size:20px" >邮箱：</td><td style="font-size:20px"><%=rs.getString("email") %></td></tr>
</table>
<br> 
<div align=center>
<a href=../admin/tech-del.jsp?id=<%=rs.getString("id")%>>删除</a>&nbsp;&nbsp;&nbsp;<a href=../admin/tech-up.jsp?id=<%=rs.getString("id") %>>修改</a>
<br></div>
<%}else
{ %>
<br><br><br><br>
<h3>该用户信息不存在！请确认后在查找！</h3>
<% 
 }
state.close();
conn.close();
rs.close();
%> 
</div>
</body>
</html>