e290. listing available sql types used by a database.txt

来自「这里面包含了一百多个JAVA源文件」· 文本 代码 · 共 55 行

This example retrieves the SQL data types supported by a database and driver. 
    try {
        // Get database meta data
        DatabaseMetaData dbmd = connection.getMetaData();
    
        // Get type info
        ResultSet resultSet = dbmd.getTypeInfo();
    
        // Retrieve type info from the result set
        while (resultSet.next()) {
            // Get the database-specific type name
            String typeName = resultSet.getString("TYPE_NAME");
    
            // Get the java.sql.Types type to which this database-specific type is mapped
            short dataType = resultSet.getShort("DATA_TYPE");
    
            // Get the name of the java.sql.Types value.
            // This method is implemented in e291 Getting the Name of a JDBC Type
            String jdbcTypeName = getJdbcTypeName(dataType);
        }
    } catch (SQLException e) {
    }

Here's an example of output for the MySQL database: 
    MySQL Type Name, JDBC Type Name
    
    TINYINT, TINYINT
    BIGINT, BIGINT
    MEDIUMBLOB, LONGVARBINARY
    MEDIUMTEXT, LONGVARBINARY
    LONGBLOB, LONGVARBINARY
    LONGTEXT, LONGVARBINARY
    BLOB, LONGVARBINARY
    TEXT, LONGVARBINARY
    TINYBLOB, VARBINARY
    TINYTEXT, VARBINARY
    CHAR, CHAR
    NUMERIC, NUMERIC
    DECIMAL, DECIMAL
    INT, INTEGER
    MEDIUMINT, INTEGER
    SMALLINT, SMALLINT
    FLOAT, FLOAT
    DOUBLE, DOUBLE
    DOUBLE PRECISION, DOUBLE
    REAL, DOUBLE
    VARCHAR, VARCHAR
    ENUM, VARCHAR
    SET, VARCHAR
    DATE, DATE
    TIME, TIME
    DATETIME, TIMESTAMP
    TIMESTAMP, TIMESTAMP