代码如下:
- public String getLimitString(String sql, boolean hasOffset);
- {
- StringBuffer pagingSelect = new StringBuffer(sql.length(); + 100);;
- if (hasOffset); {
- pagingSelect.append(
- "select * from ( select row_.*, rownum rownum_ from ( ");;
- }
- else {
- pagingSelect.append("select * from ( ");;
- }
- pagingSelect.append(sql);;
- if (hasOffset); {
- pagingSelect.append(" ); row_ where rownum <= ?); where rownum_ > ?");;
- }
- else {
- pagingSelect.append(" ); where rownum <= ?");;
- }
- return pagingSelect.toString();;
- }
- public String getLimitString(String sql, boolean hasOffset);
- {
- StringBuffer pagingSelect = new StringBuffer(sql.length(); + 100);;
- if (hasOffset); {
- pagingSelect.append(
- "select * from ( select row_.*, rownum rownum_ from ( ");;
- }
- else {
- pagingSelect.append("select * from ( ");;
- }
- pagingSelect.append(sql);;
- if (hasOffset); {
- pagingSelect.append(" ); row_ where rownum <= ?); where rownum_ > ?");;
- }
- else {
- pagingSelect.append(" ); where rownum <= ?");;
- }
- return pagingSelect.toString();;
- }
public String getLimitString(String sql, boolean hasOffset);
{
StringBuffer pagingSelect = new StringBuffer(sql.length(); + 100);;
if (hasOffset); {
pagingSelect.append(
"select * fr