JDBC Auto Increment Primary Key in oracle

 

JDBC Auto Increment Primary Key in oracle

Create table

SQL> create table stu50

     ( sid number(10) primary key,

       sname varchar2(15), 

       sadd  varchar2(15)

     );

Create a sequence.

SQL> create sequence sid_seq

     start with 1 increment by 1;

JDBC code::

=========

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

public class OracleConn {

private static final String query = "INSERT INTO STU50 VALUES(SID_SEQ.NEXTVAL,?,?)";

public static void main(String[] args) {

try {

//Connection Obj

Connection con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl","system","tiger");

PreparedStatement ps = con.prepareStatement(query);

ps.setString(1, "smith");

ps.setString(2, "pune");

int count = ps.executeUpdate();

if(count!=0) {

System.out.println("Record inserted");

}else {

System.out.println("Record not inserted");

}

con.close();

}catch(SQLException e){

System.out.println(e.getMessage());

}catch(Exception e){

System.out.println(e.getMessage());

}

}

}