Create Table JDBC Example

Create Table JDBC

In the following Create Table JDBC code, a new Employee table in Oracle database is created. The Employee table with fields empid, empname and empsal is created using DSN snrao.

Note: Before going into the program, it is advised to go through JDBC Programming Basic Steps where the meaning of Connection, Statement etc. are discussed.

import java.sql.*;
public class CreateTable
{
  public static void main(String args[])
  { 
    Connection con = null;
    Statement stmt = null;

    try
    {			                             // load the driver
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
                                                     // establish the connection
      con = DriverManager.getConnection("jdbc:odbc:snrao",  "scott", "tiger");
                                                     // create Statement object
      stmt = con.createStatement();
                                                     // send sql command
      stmt.executeUpdate("create table Employeee(empid number, empname varchar2(15), empsal number(6, 2))");  // Create Table JDBC

      System.out.println("Table created");
    }
    catch(ClassNotFoundException e)
    {
      System.err.println("Driver is not found. " + e);
    }
    catch(SQLException e)
    {
      System.err.println("Some problem in creating connection. " + e);
    }
    finally
    {                                                // close the database connection
      try
      {
        stmt.close();
        con.close();
      }
      catch(SQLException e)
      {
        System.err.println("Unable to close. " + e);
      }
    }
  }
} 

The above program can be simplified by throwing the exception. This approach is not used in realtime. Of course, realtime varies a lot where connection pooling and Hibernate are used; but knowledge of this JDBC code is required to understand Hibernate framework.

import java.sql.*;
public class CreateTable
{
  public static void main(String args[]) throws Exception
  {                                                  // load the driver
    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
                                                     // establish the connection
    Connection con = DriverManager.getConnection("jdbc:odbc:snrao",  "scott", "tiger");
                                                     // create Statement object
    Statement stmt = con.createStatement();
                                                     // send sql command
    stmt.executeUpdate("create table Employee(empid number, empname varchar2(15), empsal number(6, 2))");  // Create Table JDBC

    System.out.println("Table created");
                                                     // close the database connection
    stmt.close();
    con.close();
  }
}

In all our subsequent programs, this approach is used.