Skip to content
Related Articles

Related Articles

Java Program to Insert Details in a Table using JDBC
  • Last Updated : 22 Dec, 2020

Java Database Connectivity is basically a standard API(application interface) between the java programming language and various databases like Oracle, SQL, Postgress, SQL, etc. It connects the front end(for interacting with the users ) with the backend( for storing data).

Algorithm: Search/ Insert/ Delete/ Update in JDBC

In order to deal with JDBC standard 7 steps are supposed to be followed:

  1. Import the database
  2. Load and register drivers
  3. Create a connection
  4. Create a statement
  5. Execute the query
  6. Process the results
  7. Close the connection

Procedure:

  1. Creating a database irrespective of SQL or NoSQL. Creating a database using sqlyog and creating some tables in it and fill data inside it in order to search for the contents of a table. For example, the database is named “hotelman” and table names are “cuslogin” & “adminlogin”.
  2. Create a connection: Open any IDE where the java executable file can be generated following the standard methods. Creating a package further creating a class. Inside the package, open a new java file and type the below code for JDBC connectivity and save the filename with connection.java.
  3. Inserting details in a table using JDBC in the input sample image with parameters as follows
    • “cuslogin” table has columns namely –
      • name
      • password
      • email
      • address
      • phone
      • id
    • Need is to insert new details inside the “cuslogin” table.

Input sample Image: 



3.1: Initialize a string with the SQL query as follows

String sql=”insert into  cuslogin values(‘geeksforgeeks’,’gfg’,’geeks@email.com’,’flat 1′,’1239087474′,10)”;

3.2: Initialize the below objects of Connection class, PreparedStatement class(needed for JDBC ) and connect with the database as follows

Connection con=null;
PreparedStatement p=null;
con=connection.connectDB();

3.3: Now, add the SQL query of step 3.1 inside PrepareStatement and execute it as follows

p =con.prepareStatement(sql);
p.execute();

3.4: Open a new java file (here, its result.java) inside the same package and type the full code (shown below) for inserting the details of the customer in table “cuslogin”.

Note: Both the file’s viz result.java and connection.java should be inside the same package, else the program won’t give the desired output.

Implementation : 

  • Example 1 is Connection class of JDBC
  • Example 2 is App(Main) class where connection class is used as calling object of Connection class in main class.

Example 1: Connection class



Java




// Java Program to Insert Details in a Table using JDBC
// Connections class
  
// Importing all SQL classes
import java.sql.*;
  
public class connection {
  
    // object of Connection class
    // initially assigned NULL
    Connection con = null;
  
    public static Connection connectDB()
  
    {
  
        try {
  
            // Step 2 is involved among 7 in Connection
            // class i.e Load and register drivers
  
            // 2(a) Loading drivers using forName() method
            // name of database here is mysql
            Class.forName("com.mysql.jdbc.Driver");
  
            // 2(b) Registering drivers using DriverManager
            Connection con = DriverManager.getConnection(
                "jdbc:mysql://localhost:3306/hotelman",
                "root", "1234");
            // For DB here (custom sets)
            // root is the username, and
            // 1234 is the password
  
            // returning the object of Connection class
            // to be used in main class (Example2)
            return con;
        }
  
        // Catch block to handle the exceptions
        catch (SQLException | ClassNotFoundException e) {
  
            // Print the exceptions
            System.out.println(e);
  
            return null;
        }
    }
}

Example 2: App/Main Class where the program is compiled and run calling the above connection class object

Java




// Java Program to Insert Details in a Table using JDBC
// Main class
  
// Step 1: Importing DB classes
// DB is SQL here
import java.sql.*;
  
// Maiin/App class of above Connection class
public class GFG {
  
    // MAin driver method
    public static void main(String[] args)
    {
        // Step 2: Shownin above Connection class i.e
        // loading and registering drivers
  
        // Initially assigning NULL parameters
        // to object of Connection class
        Connection con = null;
        PreparedStatement ps = null;
  
        // Step 3: Establish the connection
        con = connection.connectDB();
  
        // Try block to check if exception/s occurs
        try {
  
            // Step 4: Create a statemet
            String sql = "insert into  cuslogin values('geeksforgeeks','gfg','geeks@email.com','flat 1','1239087474',10)";
  
            // Step 5: Execute the querry
            ps = con.prepareStatement(sql);
  
            // Step 6: Process the results
            ps.execute();
        }
  
        // Optional but recommanded
        // Step 7: Close the connection
  
        // Catch block to handle the exception/s
        catch (Exception e) {
  
            // Print the exception
            System.out.println(e);
        }
    }
}

Output:

Details added here: “geeksforgeeks” named customer details have been added.

Attention reader! Don’t stop learning now. Get hold of all the important Java Foundation and Collections concepts with the Fundamentals of Java and Java Collections Course at a student-friendly price and become industry ready. To complete your preparation from learning a language to DS Algo and many more,  please refer Complete Interview Preparation Course.

My Personal Notes arrow_drop_up
Recommended Articles
Page :