Showing posts with label insert record in java jdbc and oracle 11g database. Show all posts
Showing posts with label insert record in java jdbc and oracle 11g database. Show all posts

Sunday, June 10, 2018

Insert Record in Java JDBC and Oracle 11g Database

In this article I would like to share with you how to insert or add a record using Java JDBC and Oracle 11g database express edition that code is very simple and easy to understand.

I am currently accepting programming work, it project, school 

programming projects , thesis and capstone projects, IT consulting 

work and web development work kindly contact me in the following email address for further details.  If you want to advertise in my website kindly contact me also in my email address also. Thank you.
My email address are the following jakerpomperada@gmail.com and jakerpomperada@yahoo.com.

My mobile number here in the Philippines is 09173084360.

My telephone number at home here in Bacolod City, Negros Occidental Philippines is  +63 (034) 4335675.








Sample Program Output

Program Listing

InsertRecord.java

/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
package oraclecon;

import java.sql.*;

/**
 *
 * @author Jake Pomperada
 */
public class InsertRecord {
    public static void main(String args[])
    {
        int Id = 6;
        String Name = "JULIANNA";
        int Age=4;
        String Address ="BACOLOD";
         
        try
        {
            Class.forName("oracle.jdbc.driver.OracleDriver");
            Connection con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe", "system", "hr");
            Statement stmt = con.createStatement();
             
            // Inserting data in database
            String q1 = "INSERT INTO hr.customers VALUES('" +Id+ "', '" +Name+ 
                                  "', '" +Age+ "', '" +Address+ "')";
            int x = stmt.executeUpdate(q1);
            if (x > 0)            
                System.out.println("Successfully Inserted");            
            else           
                System.out.println("Insert Failed");
             
            con.close();
        }
        catch(Exception e)
        {
            System.out.println(e);
        }
    }
}