e250. creating a sqlserver table to store java types.txt

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

This example creates a SQLServer table called sqlserver_all_table to store Java types. 
    try {
        Statement stmt = connection.createStatement();
    
        //     Column Name          SQLServer Type           Java Type
        String sql = "CREATE TABLE sqlserver_all_table("
            + "col_boolean          BIT, "                // boolean
            + "col_byte             TINYINT, "            // byte
            + "col_short            SMALLINT, "           // short
            + "col_int              INTEGER, "            // int
            + "col_float            REAL, "               // float
            + "col_double           DOUBLE PRECISION, "   // double
            + "col_bigdecimal       DECIMAL(13,0), "      // BigDecimal; can also be NUMERIC(p,s)
            + "col_string           VARCHAR(254), "       // String
            + "col_date             DATETIME, "           // Date
            + "col_time             DATETIME, "           // Time
            + "col_timestamp        TIMESTAMP, "          // Timestamp
            + "col_characterstream  TEXT, "               // CharacterStream or AsciiStream (< 2 GBytes)
            + "col_binarystream     IMAGE)";              // BinaryStream (< 2 GBytes)
    
        stmt.executeUpdate(sql);
    } catch (SQLException e) {
    }