top.jfunc.common.db.page.OraclePageBuilder Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of common-db Show documentation

db builder, queryer.

The newest version!

package top.jfunc.common.db.page;

import top.jfunc.common.db.query.SqlUtil;

/**
 * @author xiongshiyan at 2020/9/15 , contact me with email [email protected] or phone 15208384257
 */
public class OraclePageBuilder implements PageBuilder {
    private static final PageBuilder PAGE_BUILDER = new OraclePageBuilder();
    public static PageBuilder getInstance() {
        return PAGE_BUILDER;
    }
    @Override
    public String sqlWithPage(String selectClause, String sqlExceptSelect, int pageNumber, int pageSize) {
        int start = (pageNumber - 1) * pageSize;
        int end = pageNumber * pageSize;
        return  "select * from ( select row_.*, rownum rownum_ from (  " +
                SqlUtil.middleBlank(selectClause , sqlExceptSelect) +
                " ) row_ where rownum <= " + end + ") table_alias where table_alias.rownum_ > " + start;
    }
}