jsp分页，包括页面刷新和无刷新

package com.pagination.dao; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.util.ArrayList; import java.util.Iterator; import java.util.List; import com.pagination.Connection.DBUtils; import com.pagination.factory.*; import com.pagination.pojo.Book; public class BookImpDAO implements BookDAO { int countPerPage=10; private static final String TotleCountSQL="select count(*) from book"; private static final String QueryPageSQL="select * from book limit ?,?"; //获取总记录数 public int getTotleCount() { int totleCount=0; Connection conn=null; PreparedStatement ps=null; ResultSet rs=null; try{ conn = new DBUtils().getConnection(); ps = conn.prepareStatement(this.TotleCountSQL); rs = ps.executeQuery(); if(rs.next()){ totleCount = rs.getInt(1); } }catch(Exception e){ e.printStackTrace(); }finally{ close(conn, ps, rs); } return totleCount; } private void close(Connection conn, PreparedStatement ps, ResultSet rs) { try{ if(rs!=null){ rs.close(); } }catch(Exception e){ e.printStackTrace(); } try{ if(ps!=null){ ps.close(); } }catch(Exception e){ e.printStackTrace(); } try{ if(conn!=null){ conn.close(); } }catch(Exception e){ e.printStackTrace(); } } //获取总页数 public int getTotlePage() { int totleCount = this.getTotleCount(); int totlePage = 0; if(totleCount%countPerPage==0) totlePage=totleCount/countPerPage; else totlePage=totleCount/countPerPage+1; //totlePage=(totleCount+countPerPage-1)/countPerPage; return totlePage; } //按页获取记录数 public List queryPerPage(int page) { List<Book> list = new ArrayList<Book>(); Connection conn=null; PreparedStatement ps=null; ResultSet rs=null; int startRow=(page-1)*countPerPage; try{ conn = new DBUtils().getConnection(); ps = conn.prepareStatement(this.QueryPageSQL); ps.setInt(1, startRow); ps.setInt(2, countPerPage); rs = ps.executeQuery(); while(rs.next()){ Book book = new Book(); book.setBookname(rs.getString("bookname")); book.setAuthor(rs.getString("author")); book.setPublisher(rs.getString("publisher")); book.setPrice(rs.getDouble("price")); book.setId(rs.getInt("id")); list.add(book); } }catch(Exception e){ e.printStackTrace(); }finally{ close(conn, ps, rs); } return list; } //设置每页显示的记录数 public void setCountPerPage(int countPerPage) { this.countPerPage=countPerPage; } public static void main(String[] args){ /* int tolteCount = DAOFactory.getBookImpDAO().getTotleCount(); System.out.println(tolteCount);*/ List list = DAOFactory.getBookImpDAO().queryPerPage(2); Iterator it = list.iterator(); while(it.hasNext()){ Book book = (Book)it.next(); System.out.println("bookname"+book.getBookname()+"\t"+"publisher"+book.getPublisher()+"\t"+"price"+book.getPrice()); } } }