---
title: "在javaBean中实现对Oracle的分页方法"
author: "fanjava"
date: "2006-08-26T18:36:00Z"
tags: []
slug: "javabean-oracle"
draft: false
lastmod: "2006-08-26T18:36:00Z"
id: 601669
url: "https://fanjava.iteye.com/blog/601669"
---

//分页结果集 条件tj 排序px当前页 page每页记录数pagesize

public ResultSet getPageRs(String tabname,String tj ,String px,int page,int pagesize) throws Exception {  
try {  
if(px.equals("") || px==null){  
px="id";  
}  
if (tj==null){  
tj="";  
}  
//tj为条件 px为排序  
int qpage=(page-1)\*pagesize;//当前页的第一条记录  
int hpage=qpage+pagesize;//最后一条  
dbsql="select * from (select A.* ,rownum r from (select * from "+tabname+  
" where 1=1 "+tj+  
" order by "+px+") A where rownum&lt;="+hpage+") B where r&gt;"+qpage;  
rs = st.executeQuery(dbsql);  
} catch (Exception e) {  
System.out.println("查询错误！！！" + e.toString());  
throw new ConnectError();  
}  
return rs;  
}