Create a MySQL Table to Store Java Types (Using Statement Objects)? : MySQL « Database « Java Tutorial

1. Java Tutorial
2. Database
3. MySQL

StringBuffer tableString = new StringBuffer("CREATE TABLE mysql_all_types(");
    //                    Column Name          MySQL Type          Java Type
    tableString.append("column_boolean       BOOL, ");              // boolean
    tableString.append("column_byte          TINYINT, ");           // byte
    tableString.append("column_short         SMALLINT, " );         // short
    tableString.append("column_int           INTEGER, " );          // int
    tableString.append("column_long          BIGINT, " );           // long
    tableString.append("column_float         FLOAT, "    );         // float
    tableString.append("column_double        DOUBLE PRECISION, ");  // double
    tableString.append("column_bigdecimal    DECIMAL(13,0), "   );  // BigDecimal
    tableString.append("column_string        VARCHAR(254), "    );  // String
    tableString.append("column_date          DATE, "            );  // Date
    tableString.append("column_time          TIME, "             ); // Time

    tableString.append("column_timestamp     TIMESTAMP, "         );// Timestamp
    tableString.append("column_asciistream1  TINYTEXT, "  );  // Clob (< 2^8 bytes)
    tableString.append("column_asciistream2  TEXT, "       ); // Clob (< 2^16 bytes)
    tableString.append("column_asciistream3  MEDIUMTEXT, " ); // Clob (< 2^24 bytes)
    tableString.append("column_asciistream4  LONGTEXT, "   ); // Clob (< 2^32 bytes)
    tableString.append("column_blob1         TINYBLOB, "  );  // Blob (< 2^8 bytes)
    tableString.append("column_blob2         BLOB, "      );  // Blob (< 2^16 bytes)
    tableString.append("column_blob3         MEDIUMBLOB, " ); // Blob (< 2^24 bytes)
    tableString.append("column_blob4         LONGBLOB)"   ); // Blob (< 2^32 bytes)

    stmt.executeUpdate(tableString.toString());

//From Book: JDBC Recipes A Problem-Solution Approach