PrepareStmtInput

import java.io.*;
import java.sql.*;
class PrepareStmtInput
{
public static void main(String[] args) throws Exception
{
BufferedReader br=new BufferedReader(new InputStreamReader(System.in));
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
Connection con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","system","system");
PreparedStatement pstmt=con.prepareStatement("insert into emp3 values(?,?)");
System.out.println("Enteer emp no");
int empno=Integer.parseInt(br.readLine());
pstmt.setInt(1,empno);
System.out.println("enter emp name");
String empname=br.readLine();
pstmt.setString(2,"empname");
int a=pstmt.executeUpdate();
System.out.println("insert record is with Prepare Statement......"+a);
}
}