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