![]() |
The Java Developers Almanac 1.4Order this book from Amazon. |
e248. Creating a MySQL Table to Store Java TypesThis example creates a MySQL table calledmysql_all_table
to store Java types.
try { Statement stmt = connection.createStatement(); String sql = "CREATE TABLE mysql_all_table(" + "col_boolean BOOL, " // boolean + "col_byte TINYINT, " // byte + "col_short SMALLINT, " // short + "col_int INTEGER, " // int + "col_long BIGINT, " // long + "col_float FLOAT, " // float + "col_double DOUBLE PRECISION, " // double + "col_bigdecimal DECIMAL(13,0), " // BigDecimal + "col_string VARCHAR(254), " // String + "col_date DATE, " // Date + "col_time TIME, " // Time + "col_timestamp TIMESTAMP, " // Timestamp + "col_asciistream TEXT, " // AsciiStream (< 2^16 bytes) + "col_binarystream LONGBLOB, " // BinaryStream (< 2^32 bytes) + "col_blob BLOB)"; // Blob (< 2^16 bytes) stmt.executeUpdate(sql); } catch (SQLException e) { }
e246. Deleting a Database Table e247. Listing All Table Names in a Database e249. Creating an Oracle Table to Store Java Types e250. Creating a SQLServer Table to Store Java Types © 2002 Addison-Wesley. |