Insert record into a table by using PreparedStatement

Introduction 

 
In this blog, we will know how to insert records in a table using PreparedStatement of JDBC (Java Database Connectivity) in the console window.
Here we use Type-1 driver (JDBC-ODBC bridge)
 

Creation of dsn(database source name) for Oracle

 
Start-Control panel- Administrative Tools- Data Sources (ODBC)-go to system DSN tab-click add button-select a driver for which you want to set up a data source (for Oracle- Oracle in XE)-select it and click finish-give any name in the data source name textbox-then click ok button.
 
Note: - Here Username=system, Password=pintu and Dsn name=dsn1
 
Ex:- To insert a record into a table by using PreparedStatement
 

Table Creation 

  1. create table employee(empno int,empname varchar(50),sal int)  
  1. import java.sql.*;  
  2. import java.util.*;  
  3. public class prepareDemo  
  4. {  
  5.  public static void main(String args[]) throws Exception   
  6.  {  
  7.   Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");  
  8.   Connection con = DriverManager.getConnection("jdbc:odbc:dsn1""system""pintu");  
  9.   PreparedStatement pstmt = con.prepareStatement("insert into employee(empno,empname,sal) values(?,?,?)");  
  10.   Scanner sc = new Scanner(System.in);  
  11.   System.out.print("Enter the Employee Number : ");  
  12.   int empno = sc.nextInt();  
  13.   System.out.print("Enter the Employee Name : ");  
  14.   String empname = sc.next();  
  15.   System.out.print("Enter the Employee's salary : ");  
  16.   int sal = sc.nextInt();  
  17.   pstmt.setInt(1, empno);  
  18.   pstmt.setString(2, empname);  
  19.   pstmt.setInt(3, sal);  
  20.   pstmt.executeUpdate();  
  21.   System.out.println("record inserted");  
  22.   con.close();  
  23.  }  
  24. }  

Compile

 
Javac prepareDemo.java
Java prepareDemo