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






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

1.jdbc:odbc bridge
2.JdbcOdbc Connect
3.jdbc odbc bridge connection string
4.Simple example of JDBC-ODBC functionality
5.Using a PreparedStatement through sun.jdbc.odbc.JdbcOdbcDriver
6.Creating and using a stored procedure with sun.jdbc.odbc.JdbcOdbcDriver
7.Retrieving a ResultSet from JdbcOdbcDriver
8.Getting an output parameter from a stored procedure
9.Opening an updatable ResultSet
10.Using ResultSetMetaData from jdbc:odbc
11.Using INSERT with JdbcOdbcDriver
12.Using UPDATE with JdbcOdbcDriver
13.Creating and dropping indexes
14.Using DSN-less connection