- Oracle JDBC Insert Row


How to insert a row of data into a table in Oracle using the ojdbc Oracle Driver? I want to see a Java program example.



Here is a Java example that shows you how to insert a row of data into a table in Oracle using the ojdbc Oracle Driver:

// Copyright (c)
import java.sql.DriverManager;
import java.sql.Connection;
import java.sql.Statement;
import java.sql.ResultSet;

// Example of ojdbc Oracle Driver to insert data rows to a table
public class OracleInsertRow {
   public static void main(String [] args) throws Exception {

      // Oracle JDBC connection URL with required elements
      String url = "jdbc:oracle:thin:SYS AS SYSDBA/fyicenter@//localhost/XE";
      Connection con = DriverManager.getConnection(url);
      System.out.println("JDBC connection URL: "+url); 
      System.out.println("   Connected to: "+con.getCatalog()); 
      // Create a new table "Profile"
      String sql = "CREATE TABLE Profile (ID INTEGER, Name VARCHAR(80))";
      Statement st = con.createStatement();
      st = con.createStatement();

      // Insert data row to table "Profile"
      sql = "INSERT INTO Profile (ID, Name) VALUES (1, 'Donald Trump')";
      int n = st.executeUpdate(sql);
      System.out.println("   Rows inserted: "+n); 
      // Query data from table "Profile"
      System.out.println("   Query result: "); 
      sql = "SELECT * FROM Profile";
      ResultSet rs = st.executeQuery(sql);
      while ( {
         System.out.println("      "+rs.getInt("ID")+", "
      // Drop the new table
      st.execute("DROP TABLE Profile");

You can compile and run the above example in a command window as shown below:


   -cp .;\fyicenter\Oracle-\ojdbc6.jar 

JDBC connection URL: jdbc:oracle:thin:SYS AS SYSDBA/fyicenter@//localhost/XE
   Connected to: null
   Rows inserted: 1
   Query result:
      1, Donald Trump


Examples for ojdbc.jar - JDBC Driver for Oracle

⇒⇒FAQ for ojdbc.jar - JDBC Driver for Oracle

2018-03-28, 431👍, 0💬