mysql分页语句解释_MySQL 分页语句

private static final String QUERYPERPAGESQL = "select * from book limit ?,?";

//该sql语句实现每页显示的记录条数

//按页获取记录

public List queryPerPage(int page) {//page为当前处于第几页

List list = new ArrayList();

Connection conn = null;

PreparedStatement ps = null;

ResultSet rs = null;

int startRow = (page-1)*countPerPage;//countPerPage为每页显示的记录条数

conn = MysqlDBConn.getMysqlDBConn().getconnection();

try {

ps = conn.prepareStatement(this.QUERYPERPAGESQL);

ps.setInt(1, startRow);

ps.setInt(2, countPerPage);

rs = ps.executeQuery();

while(rs.next())

{

Book book = new Book();

book.setAuthor(rs.getString("author"));

book.setBookname(rs.getString("bookname"));

book.setDiscount(rs.getString("discount"));

book.setPrice(rs.getString("price"));

book.setId(rs.getInt("id"));

book.setPublisher(rs.getString("publisher"));

list.add(book);

}

} catch (SQLException e) {

e.printStackTrace();

throw new MyRunTimeException(e.getMessage(), e);

}finally{

colse(conn, ps, rs);

}

return list;

}