Recent Posts

Monday, 12 November 2018

JDBC - Create a Table

     This tutorial provides an example on how to create a table using JDBC application.

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.*;
/**
 * 
 * @author ashok.mariyala
 *
 */
public class CreateTableDemo { 
   public static void main(String[] args) throws Exception {
      String sqlQuery = "create table emp(eno number,ename varchar2(20),esal number,eaddr varchar2(50))"; 
      Class.forName("oracle.jdbc.OracleDriver"); 
      Connection con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:XE","scott","tiger"); 
      Statement st = con.createStatement();
      ResultSet rs = st.executeUpdate(sqlQuery);
      System.out.println("Table Created Successfully");
      con.close();
   }
}

Next Tutorial : JDBC - Delete a Table Example

Previous Tutorial : Working With Type-5 Driver 
 

No comments:

Post a Comment