<% request.setCharacterEncoding("gb2312"); int nowPages;//当前页 int pages;//请求页数 int countPerPage = 10 ; //每页显示条数 int pageCount;//总页数 int recordCount=tmessgeBean.getCounter("select count(*) from dysf_teacher ");
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"); %>