Package org.ujmp.jdbc.util
Class SQLUtil
java.lang.Object
org.ujmp.jdbc.util.SQLUtil
-
Nested Class Summary
Nested Classes -
Field Summary
FieldsModifier and TypeFieldDescriptionstatic final String
static final Properties
static final Properties
static final String
static final String
protected final int
static final String
static final Properties
static final String
static final String
static final String
static final String
static final String
-
Constructor Summary
Constructors -
Method Summary
Modifier and TypeMethodDescriptionstatic void
createKeyStringTable
(Connection connection, SQLUtil.SQLDialect sqlDialect, String tableName, String columnName) static void
createKeyValueByteTable
(Connection connection, SQLUtil.SQLDialect sqlDialect, String tableName, String keyColumnName, String valueColumnName) static void
createKeyValueStringTable
(Connection connection, SQLUtil.SQLDialect sqlDialect, String tableName, String keyColumnName, String valueColumnName) static Properties
createProperties
(String url, String username, String password) getColumnNames
(Connection connection, String tableName) static String
getColumnTypeSQL
(SQLUtil.SQLDialect sqlDialect, Class<?> columnClass, boolean isKeyColumn) static String
getCountSQL
(SQLUtil.SQLDialect sqlDialect, String tableName) static PreparedStatement
getCountStatement
(Connection connection, SQLUtil.SQLDialect sqlDialect, String tableName) static String
getCreateDatabaseSQL
(SQLUtil.SQLDialect sqlDialect, String databaseName) static PreparedStatement
getCreateDatabaseStatement
(Connection connection, SQLUtil.SQLDialect sqlDialect, String databaseName) static String
getCreateKeyStringTableSQL
(SQLUtil.SQLDialect sqlDialect, String tableName, String columnName) static PreparedStatement
getCreateKeyStringTableStatement
(Connection connection, SQLUtil.SQLDialect sqlDialect, String tableName, String columnName) static String
getCreateKeyValueByteTableSQL
(SQLUtil.SQLDialect sqlDialect, String tableName, String keyColumnName, String valueColumnName) static PreparedStatement
getCreateKeyValueByteTableStatement
(Connection connection, SQLUtil.SQLDialect sqlDialect, String tableName, String keyColumnName, String valueColumnName) static String
getCreateKeyValueStringTableSQL
(SQLUtil.SQLDialect sqlDialect, String tableName, String keyColumnName, String valueColumnName) static PreparedStatement
getCreateKeyValueStringTableStatement
(Connection connection, SQLUtil.SQLDialect sqlDialect, String tableName, String keyColumnName, String valueColumnName) static String
getCreateKeyValueTableSQL
(SQLUtil.SQLDialect sqlDialect, String tableName, String keyColumnName, Class<?> keyClass, String valueColumnName, Class<?> valueClass) static String
getDatabaseName
(String url) static String
getDeleteIdSQL
(SQLUtil.SQLDialect sqlDialect, String tableName, String keyColumnName) static PreparedStatement
getDeleteIdStatement
(Connection connection, SQLUtil.SQLDialect sqlDialect, String tableName, String keyColumnName) static String
getDropDatabaseSQL
(SQLUtil.SQLDialect sqlDialect, String databaseName) static PreparedStatement
getDropDatabaseStatement
(Connection connection, SQLUtil.SQLDialect sqlDialect, String databaseName) static String
getDropTableSQL
(SQLUtil.SQLDialect sqlDialect, String tableName) static PreparedStatement
getDropTableStatement
(Connection connection, SQLUtil.SQLDialect sqlDialect, String tableName) static String
getExistsSQL
(SQLUtil.SQLDialect sqlDialect, String tableName, String columnName) static PreparedStatement
getExistsStatement
(Connection connection, SQLUtil.SQLDialect sqlDialect, String tableName, String valueColumnName) static String
getInsertIdSQL
(SQLUtil.SQLDialect sqlDialect, String tableName, String columnName) static PreparedStatement
getInsertIdStatement
(Connection connection, SQLUtil.SQLDialect sqlDialect, String tableName, String columnName) static String
getInsertKeyValueSQL
(SQLUtil.SQLDialect sqlDialect, String tableName, String keyColumnName, String valueColumnName) static PreparedStatement
getInsertKeyValueStatement
(Connection connection, SQLUtil.SQLDialect sqlDialect, String tableName, String keyColumnName, String valueColumnName) static Object
getPrimaryKeyColumnNames
(Connection connection, String tableName) static String
getSelectAllLimit1SQL
(SQLUtil.SQLDialect sqlDialect, String tableName) static PreparedStatement
getSelectAllLimit1Statement
(Connection connection, SQLUtil.SQLDialect sqlDialect, String tableName) static String
getSelectIdSQL
(SQLUtil.SQLDialect sqlDialect, String tableName, String columnName) static String
getSelectIdsSQL
(SQLUtil.SQLDialect sqlDialect, String tableName, String keyColumnName) static PreparedStatement
getSelectIdsStatement
(Connection connection, SQLUtil.SQLDialect sqlDialect, String tableName, String keyColumnName) static PreparedStatement
getSelectIdStatement
(Connection connection, SQLUtil.SQLDialect sqlDialect, String tableName, String columnName) static SQLUtil.SQLDialect
getSQLDialect
(String url) static String
getTruncateTableSQL
(SQLUtil.SQLDialect sqlDialect, String tableName) static PreparedStatement
getTruncateTableStatement
(Connection connection, SQLUtil.SQLDialect sqlDialect, String tableName) static String
getUpdateKeyValueSQL
(SQLUtil.SQLDialect sqlDialect, String tableName, String keyColumnName, String valueColumnName) static PreparedStatement
getUpdateKeyValueStatement
(Connection connection, SQLUtil.SQLDialect sqlDialect, String tableName, String keyColumnName, String valueColumnName) static String
getValueForKeySQL
(SQLUtil.SQLDialect sqlDialect, String tableName, String keyColumnName, String valueColumnName) static PreparedStatement
getValueForKeyStatement
(Connection connection, SQLUtil.SQLDialect sqlDialect, String tableName, String keyColumnName, String valueColumnName) static void
loadDriver
(String url) static boolean
tableExists
(Connection connection, String tableName)
-
Field Details
-
URL
- See Also:
-
TABLENAME
- See Also:
-
DATABASENAME
- See Also:
-
KEYCOLUMNNAME
- See Also:
-
VALUECOLUMNNAME
- See Also:
-
KEYCLASS
- See Also:
-
VALUECLASS
- See Also:
-
SQLDIALECT
- See Also:
-
DEFAULTPROPERTIES
-
MYSQLPROPERTIES
-
DERBYPROPERTIES
-
MYSQLDEFAULTCHARSET
- See Also:
-
maxKeyLength
protected final int maxKeyLength- See Also:
-
-
Constructor Details
-
SQLUtil
public SQLUtil()
-
-
Method Details
-
getSQLDialect
-
loadDriver
-
createProperties
-
getDropTableSQL
-
getDropTableStatement
public static PreparedStatement getDropTableStatement(Connection connection, SQLUtil.SQLDialect sqlDialect, String tableName) throws SQLException - Throws:
SQLException
-
getTruncateTableStatement
public static PreparedStatement getTruncateTableStatement(Connection connection, SQLUtil.SQLDialect sqlDialect, String tableName) throws SQLException - Throws:
SQLException
-
getTruncateTableSQL
-
getCountStatement
public static PreparedStatement getCountStatement(Connection connection, SQLUtil.SQLDialect sqlDialect, String tableName) throws SQLException - Throws:
SQLException
-
getCountSQL
-
getDeleteIdStatement
public static PreparedStatement getDeleteIdStatement(Connection connection, SQLUtil.SQLDialect sqlDialect, String tableName, String keyColumnName) throws SQLException - Throws:
SQLException
-
getDeleteIdSQL
public static String getDeleteIdSQL(SQLUtil.SQLDialect sqlDialect, String tableName, String keyColumnName) -
getSelectIdsStatement
public static PreparedStatement getSelectIdsStatement(Connection connection, SQLUtil.SQLDialect sqlDialect, String tableName, String keyColumnName) throws SQLException - Throws:
SQLException
-
getSelectIdsSQL
public static String getSelectIdsSQL(SQLUtil.SQLDialect sqlDialect, String tableName, String keyColumnName) -
getInsertKeyValueStatement
public static PreparedStatement getInsertKeyValueStatement(Connection connection, SQLUtil.SQLDialect sqlDialect, String tableName, String keyColumnName, String valueColumnName) throws SQLException - Throws:
SQLException
-
getInsertKeyValueSQL
public static String getInsertKeyValueSQL(SQLUtil.SQLDialect sqlDialect, String tableName, String keyColumnName, String valueColumnName) -
getInsertIdStatement
public static PreparedStatement getInsertIdStatement(Connection connection, SQLUtil.SQLDialect sqlDialect, String tableName, String columnName) throws SQLException - Throws:
SQLException
-
getInsertIdSQL
public static String getInsertIdSQL(SQLUtil.SQLDialect sqlDialect, String tableName, String columnName) -
getUpdateKeyValueStatement
public static PreparedStatement getUpdateKeyValueStatement(Connection connection, SQLUtil.SQLDialect sqlDialect, String tableName, String keyColumnName, String valueColumnName) throws SQLException - Throws:
SQLException
-
getUpdateKeyValueSQL
public static String getUpdateKeyValueSQL(SQLUtil.SQLDialect sqlDialect, String tableName, String keyColumnName, String valueColumnName) -
getValueForKeyStatement
public static PreparedStatement getValueForKeyStatement(Connection connection, SQLUtil.SQLDialect sqlDialect, String tableName, String keyColumnName, String valueColumnName) throws SQLException - Throws:
SQLException
-
getValueForKeySQL
public static String getValueForKeySQL(SQLUtil.SQLDialect sqlDialect, String tableName, String keyColumnName, String valueColumnName) -
getExistsStatement
public static PreparedStatement getExistsStatement(Connection connection, SQLUtil.SQLDialect sqlDialect, String tableName, String valueColumnName) throws SQLException - Throws:
SQLException
-
getExistsSQL
public static String getExistsSQL(SQLUtil.SQLDialect sqlDialect, String tableName, String columnName) -
getDatabaseName
-
tableExists
- Throws:
SQLException
-
getCreateKeyValueStringTableStatement
public static PreparedStatement getCreateKeyValueStringTableStatement(Connection connection, SQLUtil.SQLDialect sqlDialect, String tableName, String keyColumnName, String valueColumnName) throws SQLException - Throws:
SQLException
-
getCreateKeyValueByteTableStatement
public static PreparedStatement getCreateKeyValueByteTableStatement(Connection connection, SQLUtil.SQLDialect sqlDialect, String tableName, String keyColumnName, String valueColumnName) throws SQLException - Throws:
SQLException
-
getCreateKeyValueStringTableSQL
public static String getCreateKeyValueStringTableSQL(SQLUtil.SQLDialect sqlDialect, String tableName, String keyColumnName, String valueColumnName) -
getColumnTypeSQL
public static String getColumnTypeSQL(SQLUtil.SQLDialect sqlDialect, Class<?> columnClass, boolean isKeyColumn) -
getCreateKeyValueTableSQL
-
getCreateKeyValueByteTableSQL
public static String getCreateKeyValueByteTableSQL(SQLUtil.SQLDialect sqlDialect, String tableName, String keyColumnName, String valueColumnName) -
createKeyValueStringTable
public static void createKeyValueStringTable(Connection connection, SQLUtil.SQLDialect sqlDialect, String tableName, String keyColumnName, String valueColumnName) throws SQLException - Throws:
SQLException
-
createKeyValueByteTable
public static void createKeyValueByteTable(Connection connection, SQLUtil.SQLDialect sqlDialect, String tableName, String keyColumnName, String valueColumnName) throws SQLException - Throws:
SQLException
-
getColumnNames
public static List<String> getColumnNames(Connection connection, String tableName) throws SQLException - Throws:
SQLException
-
getSelectAllLimit1Statement
public static PreparedStatement getSelectAllLimit1Statement(Connection connection, SQLUtil.SQLDialect sqlDialect, String tableName) throws SQLException - Throws:
SQLException
-
getSelectAllLimit1SQL
-
getPrimaryKeyColumnNames
public static List<String> getPrimaryKeyColumnNames(Connection connection, String tableName) throws SQLException - Throws:
SQLException
-
createKeyStringTable
public static void createKeyStringTable(Connection connection, SQLUtil.SQLDialect sqlDialect, String tableName, String columnName) throws SQLException - Throws:
SQLException
-
getCreateKeyStringTableStatement
public static PreparedStatement getCreateKeyStringTableStatement(Connection connection, SQLUtil.SQLDialect sqlDialect, String tableName, String columnName) throws SQLException - Throws:
SQLException
-
getCreateKeyStringTableSQL
public static String getCreateKeyStringTableSQL(SQLUtil.SQLDialect sqlDialect, String tableName, String columnName) -
getSelectIdStatement
public static PreparedStatement getSelectIdStatement(Connection connection, SQLUtil.SQLDialect sqlDialect, String tableName, String columnName) throws SQLException - Throws:
SQLException
-
getSelectIdSQL
public static String getSelectIdSQL(SQLUtil.SQLDialect sqlDialect, String tableName, String columnName) -
getCreateDatabaseStatement
public static PreparedStatement getCreateDatabaseStatement(Connection connection, SQLUtil.SQLDialect sqlDialect, String databaseName) throws SQLException - Throws:
SQLException
-
getCreateDatabaseSQL
-
getDropDatabaseStatement
public static PreparedStatement getDropDatabaseStatement(Connection connection, SQLUtil.SQLDialect sqlDialect, String databaseName) throws SQLException - Throws:
SQLException
-
getDropDatabaseSQL
-
getObject
public static Object getObject(ResultSet rs, int position, Class<?> objectClass) throws SQLException - Throws:
SQLException
-