Oracle java 分页

首先设置默认起始页

/** 页码 */
	private Integer pageNumber = 1;

 

// 计算当前页面
			int pageNumer = ccrInfoDao.getPageNumber();// 第几页
			int pageSize = ccrInfoDao.getPageSize();// 一页多少条
			int startRow = (pageNumer - 1) * pageSize;
			int endRow = startRow + pageSize;
			int pageNumber = total % pageSize == 0 ? total/pageSize : total/pageSize + 1;
			ccrInfoDao.setPageNumber(pageNumber);
			
			ccrInfoDao.setStartRow(startRow);
			ccrInfoDao.setEndStartRow(endRow);

sql:

select m.*
		from (select ROWNUM AS RN, t.*
		from (select distinct
		t1.company_id as companyId,
		t1.create_time as createTime,
		t1.company_name as companyName
		from ccrs_info t1
		where 1 = 1
		<if test="ccrAgentId != null and ccrAgentId !='' ">
			and t1.ccr_agentid =#{ccrAgentId}
		</if>
		and t1.is_vaild = 'Y'
		order by createTime desc) t) m
		where <![CDATA[ RN > #{startRow} and RN <=  #{endStartRow}]]>
		order by rn