<%@ 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");
复制本页网址和标题,发送给你QQ/Msn的好友一起分享
上一篇:
jdk1.6环境搭建netbeans的中文乱码
下一篇:
实用技术分析:JSP连接数据库程序代码