Monday, March 16, 2009

jdbc code create table



import java.sql.*;
class CreateTable
{
public static void main(String[] args)throws Exception
{
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con=DriverManager.getConnection
("jdbc:oracle:thin:@localhost:1521:xe","system","chandru");
System.out.println(" Connected 2 DB.....");

Statement stmt=con.createStatement();
String vsql="create table em3(eno number(5)
primary key,ename varchar2(12),sal number(8))";

stmt.executeUpdate(vsql);
System.out.println("Table has been created.....");
}
}



0 comments:

Post a Comment