Recent Posts

Monday, 12 November 2018

JDBC - Insert a record into table

     This tutorial provides an example on how to insert a record into 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 = "insert into emp values(100,'Ashok Kumar',45000,'Bhimavaram')"; 
      Class.forName("oracle.jdbc.OracleDriver"); 
      Connection con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:XE","scott","tiger"); 
      Statement st = con.createStatement();
      int updateCount = st.executeUpdate(sqlQuery);
      System.out.println("The number of rows inserted :"+updateCount);
      con.close();
   }
}
Note
     From SQL Plus Command Prompt, if we are performing any Database Operations then compulsory we should perform Commit Operation explicitly because Auto Commit Mode is not enabled. From JDBC Application if we perform any Database Operations then the Results will be committed automatically and we are not required to Commit explicitly, because in JDBC Auto Commit is enabled by default.

Insert Multiple Records into Table
import java.sql.*;
/**
 * 
 * @author ashok.mariyala
 *
 */
public class InsertRecordDemo { 
   public static void main(String[] args) throws Exception {
      String sqlQuery = "insert into emp values(100,'Ashok Kumar',45000,'Bhimavaram')"; 
      Class.forName("oracle.jdbc.OracleDriver"); 
      Connection con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:XE","scott","tiger"); 
      Statement st = con.createStatement();
      Scanner sc = new Scanner(System.in);
      while(true) {
         System.out.println("Employee Number:");
         int eno=sc.nextInt();
         System.out.println("Employee Name:"); 
         String ename=sc.next(); 
         System.out.println("Employee Sal:"); 
         double esal=sc.nextDouble();
         System.out.println("Employee Address:");
         String eaddr=sc.next(); 
         String sqlQuery=String.format("insert into employees values(%d,'%s',%f,'%s')",eno,ename,esal,eaddr);
         st.executeUpdate(sqlQuery);
         System.out.println("Record Inserted Successfully"); 
         System.out.println("Do U want to Insert one more record[Yes/No]:"); 
         String option = sc.next(); 
         if(option.equalsIgnoreCase("No")) {
            break;
         }
      }
      con.close();
   }
}

Next Tutorial : JDBC - Update a record in the table

Previous Tutorial : JDBC - Delete a Table

No comments:

Post a Comment