Creating a table using JdbcOdbcDriver : JDBC ODBC « Database SQL JDBC « Java

1. Java
2. Database SQL JDBC
3. JDBC ODBC

Creating a table using JdbcOdbcDriver

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

public class TableMaker {
  static String jdbcDriver = "sun.jdbc.odbc.JdbcOdbcDriver";

  static String dbName = "Contacts";

  static String url = "jdbc:odbc:";

  static String SQLCreate = "CREATE TABLE CONTACT_INFO ("
      + "CONTACT_ID    INTEGER      NOT NULL   PRIMARY KEY,"
      + "ZIP           VARCHAR(10)  NOT NULL" + ");";

  public static void main(String[] args) throws Exception {
    Class.forName(jdbcDriver);
    url += dbName;
    Connection con = null;
    Statement stmt = null;
    con = DriverManager.getConnection(url);
    stmt = con.createStatement();
    stmt.execute(SQLCreate);
    con.close();
    if (con != null) {
      con.close();
    }
    if (stmt != null) {
      stmt.close();
    }

  }
}

   
  

Related examples in the same category