CreateTableWithAllDataTypesInMySQL.java Source code

Introduction

Here is the source code for CreateTableWithAllDataTypesInMySQL.java

Source

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();
        }
    }
}