<%@ page contentType="text/html; charset=gb2312" language="java"%>
<%@ page import = "java.util.*"%>
<%@ page import = "java.io.*"%>
<%@ page import = "java.sql.*"%>
<html>
<head>
<title>教师信息查询</title>
<style type="text/css">
<!--
.style1 {
font-family: "华文行楷";
color: #FFFFFF;
}
-->
</style>
<link href="default.css" rel="stylesheet" type="text/css">
<style type="text/css">
<!--
.style6 {
color: #000000;
font-size: 24px;
}
.style9 {font-size: 24px}
-->
</style>
</head>
<body bgcolor="#ffffff">
<%session.getAttribute("a_name");%>
<h1 align="center" class="style1 style6 style9">教师信息查询</h1>
<hr />
<jsp:useBean id="tmessgeBean" scope="page" class="computer.sqlbean"/>
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr align="center" bgcolor="#00FFFF">
<td colspan="5" bgcolor="#666666" class="style4"><div align="right"><a href="index.html">返回首页</a></div></td>
</tr>
<tr align="center" bgcolor="#999999">
<td class="style4">教号</td>
<td class="style4">姓名</td>
<td class="style4">系别</td>
<td class="style4">专业</td>
<td class="style4">操作选项</td>
</tr>
<%
request.setCharacterEncoding("gb2312");
int nowPages;//当前页
int pages;//请求页数
int countPerPage = 10 ; //每页显示条数
int pageCount;//总页数
int recordCount=tmessgeBean.getCounter("select count(*) from dysf_teacher ");
pageCount = (int)Math.ceil((recordCount + countPerPage-1) / countPerPage);//算出总页数
if(request.getParameter("pages") == null){
pages = 1;
}else{
pages = new Integer(request.getParameter("pages")).intValue();
}
if(pages > pageCount){
nowPages = 1;
}else{
nowPages = pages;
}
ResultSet rs = tmessgeBean.executeQuery("Select top "+ countPerPage +" * from dysf_teacher where id not in (select top "+ (nowPages-1)*countPerPage +" id from dysf_teacher order by id desc) order by id desc ");
while(rs.next()){
String ID = rs.getString("id");
String tdepartment = rs.getString("department");
String tspecial = rs.getString("special");
String tname = rs.getString("name");
%>
<tr>
<td width="20%" align="center"><%= ID %></td>
<td width="20%"><div align="center"></div>
<div align="center"><%= tname %></div></td>
<td width="20%"><div align="center"></div>
<div align="center"><%= tdepartment %></div></td>
<td width="20%"><div align="center"></div>
<div align="center"><%= tspecial %></div></td>
<td align="center"><a href="atdelete.jsp?ID=<%= ID %>">删除</a></td>
</tr>
<%
}
rs.close();
%>
<tr align="right">
<td colspan="5">共有<font color=red><%= recordCount %></font>条记录 当前<font color=red><%= nowPages %>/<%= pageCount %></font>页
<% if(pageCount > 1){ %>
<% if(pages > 1){%>
<a href="">首页</a>
<%}if(pages < pageCount){%>
<a href="?pages=<%= nowPages+1 %>">下一页</a>
<%}if(pages != 1){%>
<a href="?pages=<%= nowPages - 1 %>">上一页</a>
<%}%>
<a href="?pages=<%= pageCount %>">尾页</a>
<% } %>跳转到
<select name="pages" onChange="javascript:this.form.submit();">
<% for(int i=1;i<=pageCount;i++){%>
<option value="<%= i %>" <% if(nowPages == i){%>selected<% } %>><%= i %></option>
<% } %>
</select>页</td>
</tr>
</table>
<hr />
</body>
</html>
