com.tairanchina.csp.dew.jdbc.dialect.OracleDialect Maven / Gradle / Ivy

Go to download
package com.tairanchina.csp.dew.jdbc.dialect;

public class OracleDialect implements Dialect {

    @Override
    public String paging(String sql, long pageNumber, int pageSize) {
        return "SELECT * FROM (SELECT rownum rn , originaltable.* FROM (" + sql + ") originaltable  WHERE rownum<=" + (pageNumber * pageSize) + ") WHERE rn > " + (pageNumber - 1) * pageSize;
    }

    @Override
    public String count(String sql) {
        return "SELECT COUNT(1) FROM ( " + sql + " ) ";
    }

    @Override
    public String getTableInfo(String tableName) {
        //TODO
        throw new RuntimeException("NotImplemented");
    }

    @Override
    public String getDriver() {
        return "oracle.jdbc.driver.OracleDriver";
    }

    @Override
    public DialectType getDialectType() {
        return DialectType.ORACLE;
    }


}