static void |
SQLUtil.createKeyStringTable(java.sql.Connection connection,
SQLUtil.SQLDialect sqlDialect,
java.lang.String tableName,
java.lang.String columnName) |
|
static void |
SQLUtil.createKeyValueByteTable(java.sql.Connection connection,
SQLUtil.SQLDialect sqlDialect,
java.lang.String tableName,
java.lang.String keyColumnName,
java.lang.String valueColumnName) |
|
static void |
SQLUtil.createKeyValueStringTable(java.sql.Connection connection,
SQLUtil.SQLDialect sqlDialect,
java.lang.String tableName,
java.lang.String keyColumnName,
java.lang.String valueColumnName) |
|
static java.lang.String |
SQLUtil.getColumnTypeSQL(SQLUtil.SQLDialect sqlDialect,
java.lang.Class<?> columnClass,
boolean isKeyColumn) |
|
static java.lang.String |
SQLUtil.getCountSQL(SQLUtil.SQLDialect sqlDialect,
java.lang.String tableName) |
|
static java.sql.PreparedStatement |
SQLUtil.getCountStatement(java.sql.Connection connection,
SQLUtil.SQLDialect sqlDialect,
java.lang.String tableName) |
|
static java.lang.String |
SQLUtil.getCreateDatabaseSQL(SQLUtil.SQLDialect sqlDialect,
java.lang.String databaseName) |
|
static java.sql.PreparedStatement |
SQLUtil.getCreateDatabaseStatement(java.sql.Connection connection,
SQLUtil.SQLDialect sqlDialect,
java.lang.String databaseName) |
|
static java.lang.String |
SQLUtil.getCreateKeyStringTableSQL(SQLUtil.SQLDialect sqlDialect,
java.lang.String tableName,
java.lang.String columnName) |
|
static java.sql.PreparedStatement |
SQLUtil.getCreateKeyStringTableStatement(java.sql.Connection connection,
SQLUtil.SQLDialect sqlDialect,
java.lang.String tableName,
java.lang.String columnName) |
|
static java.lang.String |
SQLUtil.getCreateKeyValueByteTableSQL(SQLUtil.SQLDialect sqlDialect,
java.lang.String tableName,
java.lang.String keyColumnName,
java.lang.String valueColumnName) |
|
static java.sql.PreparedStatement |
SQLUtil.getCreateKeyValueByteTableStatement(java.sql.Connection connection,
SQLUtil.SQLDialect sqlDialect,
java.lang.String tableName,
java.lang.String keyColumnName,
java.lang.String valueColumnName) |
|
static java.lang.String |
SQLUtil.getCreateKeyValueStringTableSQL(SQLUtil.SQLDialect sqlDialect,
java.lang.String tableName,
java.lang.String keyColumnName,
java.lang.String valueColumnName) |
|
static java.sql.PreparedStatement |
SQLUtil.getCreateKeyValueStringTableStatement(java.sql.Connection connection,
SQLUtil.SQLDialect sqlDialect,
java.lang.String tableName,
java.lang.String keyColumnName,
java.lang.String valueColumnName) |
|
static java.lang.String |
SQLUtil.getCreateKeyValueTableSQL(SQLUtil.SQLDialect sqlDialect,
java.lang.String tableName,
java.lang.String keyColumnName,
java.lang.Class<?> keyClass,
java.lang.String valueColumnName,
java.lang.Class<?> valueClass) |
|
static java.lang.String |
SQLUtil.getDeleteIdSQL(SQLUtil.SQLDialect sqlDialect,
java.lang.String tableName,
java.lang.String keyColumnName) |
|
static java.sql.PreparedStatement |
SQLUtil.getDeleteIdStatement(java.sql.Connection connection,
SQLUtil.SQLDialect sqlDialect,
java.lang.String tableName,
java.lang.String keyColumnName) |
|
static java.lang.String |
SQLUtil.getDropDatabaseSQL(SQLUtil.SQLDialect sqlDialect,
java.lang.String databaseName) |
|
static java.sql.PreparedStatement |
SQLUtil.getDropDatabaseStatement(java.sql.Connection connection,
SQLUtil.SQLDialect sqlDialect,
java.lang.String databaseName) |
|
static java.lang.String |
SQLUtil.getDropTableSQL(SQLUtil.SQLDialect sqlDialect,
java.lang.String tableName) |
|
static java.sql.PreparedStatement |
SQLUtil.getDropTableStatement(java.sql.Connection connection,
SQLUtil.SQLDialect sqlDialect,
java.lang.String tableName) |
|
static java.lang.String |
SQLUtil.getExistsSQL(SQLUtil.SQLDialect sqlDialect,
java.lang.String tableName,
java.lang.String columnName) |
|
static java.sql.PreparedStatement |
SQLUtil.getExistsStatement(java.sql.Connection connection,
SQLUtil.SQLDialect sqlDialect,
java.lang.String tableName,
java.lang.String valueColumnName) |
|
static java.lang.String |
SQLUtil.getInsertIdSQL(SQLUtil.SQLDialect sqlDialect,
java.lang.String tableName,
java.lang.String columnName) |
|
static java.sql.PreparedStatement |
SQLUtil.getInsertIdStatement(java.sql.Connection connection,
SQLUtil.SQLDialect sqlDialect,
java.lang.String tableName,
java.lang.String columnName) |
|
static java.lang.String |
SQLUtil.getInsertKeyValueSQL(SQLUtil.SQLDialect sqlDialect,
java.lang.String tableName,
java.lang.String keyColumnName,
java.lang.String valueColumnName) |
|
static java.sql.PreparedStatement |
SQLUtil.getInsertKeyValueStatement(java.sql.Connection connection,
SQLUtil.SQLDialect sqlDialect,
java.lang.String tableName,
java.lang.String keyColumnName,
java.lang.String valueColumnName) |
|
static java.lang.String |
SQLUtil.getSelectAllLimit1SQL(SQLUtil.SQLDialect sqlDialect,
java.lang.String tableName) |
|
static java.sql.PreparedStatement |
SQLUtil.getSelectAllLimit1Statement(java.sql.Connection connection,
SQLUtil.SQLDialect sqlDialect,
java.lang.String tableName) |
|
static java.lang.String |
SQLUtil.getSelectIdSQL(SQLUtil.SQLDialect sqlDialect,
java.lang.String tableName,
java.lang.String columnName) |
|
static java.lang.String |
SQLUtil.getSelectIdsSQL(SQLUtil.SQLDialect sqlDialect,
java.lang.String tableName,
java.lang.String keyColumnName) |
|
static java.sql.PreparedStatement |
SQLUtil.getSelectIdsStatement(java.sql.Connection connection,
SQLUtil.SQLDialect sqlDialect,
java.lang.String tableName,
java.lang.String keyColumnName) |
|
static java.sql.PreparedStatement |
SQLUtil.getSelectIdStatement(java.sql.Connection connection,
SQLUtil.SQLDialect sqlDialect,
java.lang.String tableName,
java.lang.String columnName) |
|
static java.lang.String |
SQLUtil.getTruncateTableSQL(SQLUtil.SQLDialect sqlDialect,
java.lang.String tableName) |
|
static java.sql.PreparedStatement |
SQLUtil.getTruncateTableStatement(java.sql.Connection connection,
SQLUtil.SQLDialect sqlDialect,
java.lang.String tableName) |
|
static java.lang.String |
SQLUtil.getUpdateKeyValueSQL(SQLUtil.SQLDialect sqlDialect,
java.lang.String tableName,
java.lang.String keyColumnName,
java.lang.String valueColumnName) |
|
static java.sql.PreparedStatement |
SQLUtil.getUpdateKeyValueStatement(java.sql.Connection connection,
SQLUtil.SQLDialect sqlDialect,
java.lang.String tableName,
java.lang.String keyColumnName,
java.lang.String valueColumnName) |
|
static java.lang.String |
SQLUtil.getValueForKeySQL(SQLUtil.SQLDialect sqlDialect,
java.lang.String tableName,
java.lang.String keyColumnName,
java.lang.String valueColumnName) |
|
static java.sql.PreparedStatement |
SQLUtil.getValueForKeyStatement(java.sql.Connection connection,
SQLUtil.SQLDialect sqlDialect,
java.lang.String tableName,
java.lang.String keyColumnName,
java.lang.String valueColumnName) |
|