• Home
• com.tairanchina.csp.dew
• jdbc-starter
• 1.5.1-RC
• source code
• MySQLDialect.java

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

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

package com.tairanchina.csp.dew.jdbc.dialect;

class MySQLDialect implements Dialect {

    @Override
    public String paging(String sql, long pageNumber, int pageSize) {
        return sql + " LIMIT " + (pageNumber - 1) * pageSize + ", " + pageSize;
    }

    @Override
    public String count(String sql) {
        return "SELECT COUNT(1) FROM ( " + sql + " ) _" + (Math.abs(sql.hashCode()) & 0x7fffffff);
    }

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

    @Override
    public String getDriver() {
        return "com.mysql.jdbc.Driver";
    }

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

}