Class SQLUtil


  • public abstract class SQLUtil
    extends java.lang.Object
    • Field Detail

      • 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
    • Constructor Detail

      • SQLUtil

        public SQLUtil()
    • 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