//分页结果集 条件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<="+hpage+") B where r>"+qpage;
rs = st.executeQuery(dbsql);
} catch (Exception e) {
System.out.println("查询错误!!!" + e.toString());
throw new ConnectError();
}
return rs;
}