oracle数据库中分页模糊查询,Oracle数据库分页技术的实现

Oracle数据库分页技术的实现

1、分页类Pagination.java

package com.qixin.util;

/**

* 用来封装分页信息

*/

public class Pagination {

private int currPage = 1; //当前页码

private int countPage = 0; //总页数

private int pageSize = 10; //每页显示记录数

private int countSize = 0; //总记录条数

public int getCurrPage() {

return currPage;

}

public void setCurrPage(int currPage) {

this.currPage = currPage;

}

public int getCountPage() {

if(countSize != 0){

if(countSize%pageSize != 0){

countPage = countSize/pageSize +1;

}else{

countPage = countSize/pageSize;