Mega Code Archive

 

Categories / Java Tutorial / Database

 

Create a MySQL Table to Store Java Types (Using Statement Objects)

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