Java SQL Type createTable2()

Description

create Table

License

Apache License

Declaration

public static void createTable2() throws SQLException 

Method Source Code

//package com.java2s;
//License from project: Apache License 

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

import java.sql.SQLException;
import java.sql.Statement;

public class Main {
    private static String protocol = "jdbc:derby:";
    private static String dbName = "db";

    public static void createTable2() throws SQLException {
        Connection conn = DriverManager.getConnection(protocol + dbName + ";create=true");
        Statement st = conn.createStatement();
        String sql = "create table whore2(id bigint  primary key,obj blob)";
        st.execute(sql);/*  w  w w. j  a  va 2  s. co  m*/
        st.close();
        conn.close();
    }
}

Related

1. convertType(final int type, final String typeName)
2. createAllTypesTable(Connection conn)
3. createArrTypSql(String[] arr)
4. createSignature(Method m)
5. createSqlDataType(@Nonnull final String javaDataType)
6. createTestData()
7. decodeJavaType(Object pType)
8. deleteData(Connection conn)
9. deleteFromAllTables(Connection con)