In this article, we will see how can we perform operations with database using JDBC. We will then cover how to create a table in MySQL database and how to insert, update, and delete the rows using the JDBC program. crud MySQL You can find a video below with my step-by-step process. youtube https://www.youtube.com/watch?v=fUBoDErcDHA&embedable=true&transcript=true Let’s dive straight into the code Insert Class import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
public class Insert {
    public static void main(String[] args) {
        //load the driver
        try {
            Class.forName("com.mysql.cj.jdbc.Driver");
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        }
        try (Connection con = DriverManager.getConnection("jdbc:mysql://@localhost:3306/new_schema", "root", "root"); Statement st = con.createStatement();) {
            String query = "INSERT INTO EMP(EID,ENAME) values(1,'Ram')";
            int count = st.executeUpdate(query);
            if (count == 0) {
                System.out.println("Record not inserted");
            } else {
                System.out.println("Record Inserted");
            }
        } catch (SQLException se) {
            se.printStackTrace();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
} Delete Class import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
public class Delete {
    public static void main(String[] args) {
        // load the driver
        try {
            Class.forName("com.mysql.cj.jdbc.Driver");
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        }
        try (Connection con = DriverManager.getConnection("jdbc:mysql://@localhost:3306/new_schema", "root", "root"); Statement st = con.createStatement();) {
            String query = "DELETE FROM EMP WHERE EID=1";
            int count = st.executeUpdate(query);
            if (count != 0) {
                System.out.println("Record Deleted");
            } else {
                System.out.println("Record Not Deleted");
            }
        } catch (SQLException se) {
            se.printStackTrace();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
} Update Class import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
public class Update {
    public static void main(String[] args) {
        // load the driver
        try {
            Class.forName("com.mysql.cj.jdbc.Driver");
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        }
        try (Connection con = DriverManager.getConnection("jdbc:mysql://@localhost:3306/new_schema", "root", "root"); Statement st = con.createStatement();) {
            String query = "UPDATE EMP SET ENAME='SAM' WHERE EID=1";
            int count = st.executeUpdate(query);
            if (count != 0) {
                System.out.println("Record UPDATED");
            } else {
                System.out.println("Record Not UPDATED");
            }
        } catch (SQLException se) {
            se.printStackTrace();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
} /Select Class import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class Select {
    public static void main(String[] args) {
        // load the driver
        try {
            Class.forName("com.mysql.cj.jdbc.Driver");
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        }
        try (Connection con = DriverManager.getConnection("jdbc:mysql://@localhost:3306/new_schema", "root", "root"); Statement st = con.createStatement();) {
            String query = "SELECT EID,ENAME FROM EMP";
            ResultSet rs = st.executeQuery(query);
            while (rs.next()) {
                System.out.println(rs.getInt(1) + " " + rs.getString(2));
            }
        } catch (SQLException se) {
            se.printStackTrace();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
} The lead image for this article was generated by HackerNoon's AI Image Generator via the prompt "database".

Walkthroughs, tutorials, guides, and tips. This story will teach you how to do something new or how to do something better.

Dockerizing a Spring Boot 3 Application

Building a Travel Mobile App using Flutter

Read My Stories

Too Long; Didn't Read

Make resilience your competitive advantage

Mastering Java JDBC CRUD Operations in Eclipse Using MySQL

About Author

Comments

TOPICS

THIS ARTICLE WAS FEATURED IN

Related Stories

Untitled Story

Building a Currency Converter in Flutter

All the Firebase Functions you Need to Build Your Next Serverless Application

Build a FullStack Tinder Clone Without Writing A Single Line Of Code

Build a Job Application Tracker in 10 minutes Using ToolJet's Low Code Tool

Building a CRUD RESTful API/Web Service with Spring Boot [A How-To Guide]

Building a Currency Converter in Flutter

All the Firebase Functions you Need to Build Your Next Serverless Application

Build a FullStack Tinder Clone Without Writing A Single Line Of Code

Build a Job Application Tracker in 10 minutes Using ToolJet's Low Code Tool

Building a CRUD RESTful API/Web Service with Spring Boot [A How-To Guide]

Light-Mode

Classic

Newspaper

Dark-Mode

Neon Noir

Minty

HN StartUps