com.ecfront.easybi.dbutils.inner.dialect.H2Dialect Maven / Gradle / Ivy
package com.ecfront.easybi.dbutils.inner.dialect;
import java.sql.SQLException;
import java.util.Map;
public class H2Dialect implements Dialect {
@Override
public String paging(String sql, long pageNumber, long pageSize) throws SQLException {
return sql + " limit " + pageSize + " offset " + (pageNumber - 1) * pageSize;
}
@Override
public String count(String sql) throws SQLException {
return "select count(1) from ( " + sql + " ) ";
}
@Override
public String createTableIfNotExist(String tableName, Map fields, String pk) throws SQLException {
StringBuilder sb = new StringBuilder("CREATE TABLE IF NOT EXISTS " + tableName + " ( ");
for (Map.Entry field : fields.entrySet()) {
String f = field.getValue().toLowerCase();
String t;
if (f.equals("int") || f.equals("integer")) {
t = "INT";
} else if (f.equals("long")) {
t = "BIGINT";
} else if (f.equals("short")) {
t = "SMALLINT";
} else if (f.equals("string")) {
t = "VARCHAR(65535)";
} else if (f.equals("bool") || f.equals("boolean")) {
t = "BOOLEAN";
} else if (f.equals("float")) {
t = "FLOAT";
} else if (f.equals("double")) {
t = "DOUBLE";
} else if (f.equals("char")) {
t = "CHAR";
} else if (f.equals("date")) {
t = "TIMESTAMP";
} else if (f.equals("uuid")) {
t = "UUID";
} else if (f.equals("decimal")) {
t = "DECIMAL";
} else {
throw new SQLException("Not support type:" + f);
}
sb.append(field.getKey() + " " + t + " ,");
}
if (pk != null && pk.trim() != "") {
return sb.append("primary key(" + pk.trim() + ") )").toString();
} else {
return sb.substring(0, sb.length() - 1).toString()+")";
}
}
}