<%@ page contentType="text/html; charset=GBK"%>
<%@ page import="java.sql.*"%>
<%
int pagesize=2;//每页显示记录数
int recordcount=0;//记录总数
int pagecount=0;//总页数
int pageid=1;//待显页码
Connection conn=null;
try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
conn=DriverManager.getConnection("jdbc:microsoft:sqlserver://192.168.0.116:1433;DatabaseName=test;encoding=gb2312","sa","123");
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
String sql="select * from book";
ResultSet rs=stmt.executeQuery(sql);
rs.last();
recordcount=rs.getRow();//取得总记录数
pagecount=(recordcount%pagesize==0?(recordcount/pagesize):(recordcount/pagesize)+1);//取得总页数
int count=1;
String strpage=request.getParameter("pageid");
if(strpage==null) pageid=1;
else pageid=Integer.parseInt(strpage);
if(pageid>recordcount) pageid=recordcount;
if(pageid>1){
rs.absolute((pageid-1)*pagesize);
}else if(pageid==1){
rs.beforeFirst();
}
while(rs.next()&&count<=pagesize){
count++;
out.print(rs.getString("bookName"));
out.print("||");
out.print(rs.getString("author"));
out.print("<br/>");
}
out.print("共");
out.print(pagecount);
out.print("页");
out.print("共");
out.print(recordcount);
out.print("条");
out.print("第");
out.print(pageid);
out.print("页");
out.print("<br/>");
if(pageid>1){
out.print("<a href=page.jsp?pageid=");
out.print(pageid-1);
out.print(">上一页</a>");
out.print("  ");
}
if(pageid<pagecount){
out.print("<a href=page.jsp?pageid=");
out.print(pageid+1);
out.print(">下一页</a>");}
out.print("<br/>");
for(int j=1;j<=pagecount;j++){
out.print("<a href=page.jsp?pageid=");
out.print(j);
out.print(">");
out.print(j);
out.print("</a>");}
stmt.close();
conn.close();
}
catch(ClassNotFoundException e){
out.println(e.getMessage());
}
catch(SQLException e) {
out.println(e.getMessage());
}
finally{
try{
if(conn != null)
conn.close();
}
catch(Exception e){}
}
%>