%@ 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();
}
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
