StringBuffer pagingSelect = new StringBuffer(100); pagingSelect.append("select * from ( select row_.*, rownum rownum_ from ( "); pagingSelect.append(sql); pagingSelect.append(" ) row_ where rownum <= " + endRow + ") where rownum_ > " + startRow);startRow 是记录开始处endRow 是记录结束处举例来说：从第11条到第20条select * from (
select row_.*, rownum rownum_ from ( select person_id, chn_name, chn_firstname_py from t_pbase_info ) row_ where rownum <=20 ) where rownum_ >=11
