WebRoot/admin/tech-see.jsp

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

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

<%@ page contentType="text/html; charset=utf-8" import="java.sql.*"%>
<html>
<head>
<title>管理员页面</title>
<link type="text/css" rel=stylesheet href=../css/main.css >
</head>
<body>
<br><br><br>
<h2>教师信息如下：</h2>
<div align=center>

<form action=tech-find.jsp method="post" >
<table >
<tr><td>教师编号：</td><td><input name="id" type="text"></td>
<td><input name=submit type=submit value=查找教师></td>
<td>&nbsp;&nbsp;&nbsp;&nbsp;</td>

<td>教师姓名：</td><td><input name=name type="text"></td>
<td><input name=submit type=submit value=查找教师></td></tr>

</table></form></div>
<hr>
<table  class=table2 border=1>
<tr ><th>工号</th><th>姓名</th><th>性别</th><th>学院</th><th>电话</th><th>邮箱</th><th colspan=2>操作</th></tr>
<% 
    
	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);
	
	int pagesize=6;
	int totalsize;
	int totalpage;
	int currentpage;
	String nowpage=request.getParameter("page");
	int i;
	if(nowpage==null){
	currentpage=1;
	}else{
	currentpage=Integer.parseInt(nowpage);
	}
	
	Statement state=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
	String sql="select * from teacher ";
	ResultSet rs=null;
	rs=state.executeQuery(sql);
	rs.last();
	
	totalsize=rs.getRow();
	totalpage=(totalsize+pagesize-1)/pagesize;
	if(totalpage>0){
	rs.absolute((currentpage-1)*pagesize+1);
	i=0;
	while(i<pagesize&&!rs.isAfterLast()){
	String id=rs.getString("id");
%>
<tr><td><%=id%></td>