Main.java Source code

Introduction

Here is the source code for Main.java

Source

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;

public class Main {
    public static void main(String[] argv) throws Exception {
        String driverName = "oracle.jdbc.driver.OracleDriver";
        Class.forName(driverName);

        String serverName = "127.0.0.1";
        String portNumber = "1521";
        String sid = "mydatabase";
        String url = "jdbc:oracle:thin:@" + serverName + ":" + portNumber + ":" + sid;
        String username = "username";
        String password = "password";
        Connection connection = DriverManager.getConnection(url, username, password);

        Statement stmt = connection.createStatement();

        stmt.execute("CREATE TYPE number_varray AS VARRAY(10) OF NUMBER(12, 2)");

        stmt.execute("CREATE TYPE my_object AS OBJECT(col_string2 VARCHAR(30), col_int2 INTEGER)");

        //    Column Name          Oracle Type             Java Type
        String sql = "CREATE TABLE oracle_all_table(" + "col_short           SMALLINT, " // short
                + "col_int             INTEGER, " // int
                + "col_float           REAL, " // float; can also be NUMBER
                + "col_double          DOUBLE PRECISION, " // double; can also be FLOAT or NUMBER
                + "col_bigdecimal      DECIMAL(13,0), " // BigDecimal
                + "col_string          VARCHAR2(254), " // String; can also be CHAR(n)
                + "col_characterstream LONG, " // CharacterStream or AsciiStream
                + "col_bytes           RAW(2000), " // byte[]; can also be LONG RAW(n)
                + "col_binarystream    RAW(2000), " // BinaryStream; can also be LONG RAW(n)
                + "col_timestamp       DATE, " // Timestamp
                + "col_clob            CLOB, " // Clob
                + "col_blob            BLOB, " // Blob; can also be BFILE
                + "col_array           number_varray, " // oracle.sql.ARRAY
                + "col_object          my_object)"; // oracle.sql.OBJECT

        stmt.executeUpdate(sql);

    }
}