在javaBean中实现对Oracle的分页方法

    //分页结果集  条件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;
    }