How to insert data into oracle database using java program

Image via Wikipedia

Hey friends I am here to help you. In this tutorial we will see how to insert data into oracle data base using java program/application.

Prerequisites:

1. All configuration must me done to connect java

   Image via Wikipedia

   application to oracle before starting this task. As described in my previous tutorial 'How to connect java application with oracle database'.
   

Steps:

1. First start your oracle database and create a table of your choice. eg - create table student (id number(3), name varchar2(30),class number(2),marks number(3));
2. Now open IDE and write down the java code for the application which will connect to the oracle database and enter the data to the specific table.
3. After compilation and execution. You will get data inserted in the database.
   

Source Code for 'Inserting data into oracle database using java program/application':

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;

public class InsertRecord {

public static void main(String[] args) {

String driver="sun.jdbc.odbc.JdbcOdbcDriver";
String cs="jdbc:odbc:connect_oracle";
String user = "system";
String pwd = "tom";
String sqlstmt="INSERT INTO STUDENT VALUES(1,'Steve',5,70)";
Connection con = null;
Statement st = null;
try
{
Class.forName(driver);
}
catch(Exception e)
{
System.out.println(e);
}
System.out.println("Driver loaded");
try
{
con=DriverManager.getConnection(cs,user,pwd);
System.out.println("Connected to the Oracle Database");
st = con.createStatement();//creates a Statement object for sending SQL statements to the database.
int updatecount=st.executeUpdate(sqlstmt);//return either the row count for INSERT, UPDATE or DELETE statements, or 0 for SQL statements that return nothing
System.out.println(updatecount+" row inserted");
}
catch(Exception e)
{
System.out.println(e);
}
try
{
st.close();
con.close();
}
catch(Exception e)
{
System.out.println(e);
}
}//main()
}//class()

Output:

Driver loaded
Connected to the Oracle Database
1 record inserted


In my next post I will discuss about how to add interactively multiple records to the oracle database. Till then have a good time.