티스토리 뷰

Computer/Databases

[MySQL] Create Table With All Data Types In MySQL

인생이글케쉬우냐 2009. 12. 31. 17:33

출처 : http://blog.naver.com/gaeean/60050661562 Create Table With All Data Types In MySQL|작성자 레인보우


import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;

public class CreateTableWithAllDataTypesInMySQL {
  public static Connection getConnection() throws Exception {
    String driver = "org.gjt.mm.mysql.Driver";
    String url = "jdbc:mysql://localhost/databaseName";
    String username = "root";
    String password = "root";
    Class.forName(driver);
    Connection conn = DriverManager.getConnection(url, username, password);
    return conn;
  }

  public static void main(String[] args) throws Exception{
    PreparedStatement pstmt = null;
    Connection conn = null;
    try {
      StringBuffer sql = new StringBuffer("CREATE TABLE tableWithAllTypes(");
      sql.append("column_boolean       BOOL, ");                // boolean
      sql.append("column_byte          TINYINT, ");             // byte
      sql.append("column_short         SMALLINT, ");            // short
      sql.append("column_int           INTEGER, ");             // int
      sql.append("column_long          BIGINT, ");              // long
      sql.append("column_float         FLOAT, ");               // float
      sql.append("column_double        DOUBLE PRECISION, ");    // double
      sql.append("column_bigdecimal    DECIMAL(13,0), ");       // BigDecimal
      sql.append("column_string        VARCHAR(254), ");        // String
      sql.append("column_date          DATE, ");                // Date
      sql.append("column_time          TIME, ");                // Time
      sql.append("column_timestamp     TIMESTAMP, ");           // Timestamp
      sql.append("column_asciistream1  TINYTEXT, ");            // Clob ( 2^8 bytes)
      sql.append("column_asciistream2  TEXT, ");                // Clob ( 2^16 bytes)
      sql.append("column_asciistream3  MEDIUMTEXT, ");          // Clob (2^24 bytes)
      sql.append("column_asciistream4  LONGTEXT, ");            // Clob ( 2^32 bytes)
      sql.append("column_blob1         TINYBLOB, ");            // Blob ( 2^8 bytes)
      sql.append("column_blob2         BLOB, ");                // Blob ( 2^16 bytes)
      sql.append("column_blob3         MEDIUMBLOB, ");          // Blob ( 2^24 bytes)
      sql.append("column_blob4         LONGBLOB)");             // Blob ( 2^32 bytes)

      conn = getConnection();
      pstmt = conn.prepareStatement(sql.toString());
      pstmt.executeUpdate();
    } catch (Exception e) {
      e.printStackTrace();
    } finally {
      conn.close();
    }
  }
}
mysql의 데이터 유형을 찾아보던 중에 검색한 소스.나중에 기억하기 좋게 여기에 복사~
반응형