com.nfwork.dbfound.db.dialect.OracleDialect Maven / Gradle / Ivy
Go to download
Show more of this group Show more artifacts with this name
Show all versions of dbfound Show documentation
Show all versions of dbfound Show documentation
dbfound development platform
package com.nfwork.dbfound.db.dialect;
public class OracleDialect implements SqlDialect {
public String getPagerSql(String sql, int pagerSize, long startWith) {
String pagersql = "select * from (select v.*, rownum d_p_rm from (" + sql
+ ") v where rownum<=" + (startWith + pagerSize)
+ ") where d_p_rm >= " + (startWith + 1);
return pagersql;
}
public String getWhenSql(String when) {
String pagersql = "select 1 from dual where " + when;
return pagersql;
}
public String parseSql(String sql) {
return sql;
}
}