To develop a Java standalone application that connects to a MySQL database using Eclipse

and performs CRUD operations (Create, Read, Update, Delete) on a database table, follow
these steps.

Prerequisites:

MySQL: Ensure that MySQL is installed and running on your machine, and that MySQL
Workbench is set up.

Eclipse IDE: Make sure you have Eclipse IDE installed on your system.

JDBC Driver: You will need to download the MySQL JDBC driver (Connector/J), or use Maven to
handle it.

Steps to Implement the Java Standalone Application:

1. Set Up the Database Table

1.1 Create a Database and Table in MySQL:

Use MySQL Workbench or MySQL command line to create a database and a users table.

-- Create the database

CREATE DATABASE testdb;

-- Use the database

USE testdb;

-- Create the table 'users'

CREATE TABLE users (

id INT AUTO_INCREMENT PRIMARY KEY,

name VARCHAR(255) NOT NULL,

email VARCHAR(255) NOT NULL

);

-- Insert sample data

INSERT INTO users (name, email) VALUES ('John Doe', 'john.doe@example.com');

2. Set Up the Eclipse Project

2.1 Create a New Java Project in Eclipse:

Open Eclipse IDE.

Go to File > New > Java Project.

Name your project, e.g., DatabaseCRUDApp.

Click Finish.

2.2 Add the MySQL JDBC Driver to the Project:

Option 2: (Manual Method)

Download the MySQL JDBC driver from MySQL Downloads.

Right-click on your project in Eclipse and select Properties.

Go to Java Build Path > Libraries > Add External JARs.

Select the downloaded mysql-connector-java-x.x.x.jar file and add it.

3. Java Code for CRUD Operations

3.1 Create a Java Class for CRUD Operations:

Right-click on the src folder in Eclipse.

Select New > Class and name it DatabaseCRUDOperations.

Copy the following code into your DatabaseCRUDOperations.java file.

import java.sql.*;

public class DatabaseCRUDOperations {

// Database connection credentials

static final String URL = "jdbc:mysql://localhost:3306/testdb"; // Your MySQL URL

static final String USER = "root"; // MySQL username

public static void main(String[] args) {

// Perform CRUD operations

createUser("Alice", "alice@example.com");

readUsers();

updateUser(1, "John Smith", "john.smith@example.com");

deleteUser(2);

readUsers(); // Check the updated data

// CREATE operation: Insert new user

public static void createUser(String name, String email) {

try (Connection connection = DriverManager.getConnection(URL, USER, PASSWORD);

PreparedStatement preparedStatement = connection.prepareStatement(

"INSERT INTO users (name, email) VALUES (?, ?)")) {

preparedStatement.setString(1, name);

preparedStatement.setString(2, email);

int rowsAffected = preparedStatement.executeUpdate();

if (rowsAffected > 0) {

System.out.println("User added successfully: " + name);

} catch (SQLException e) {
 e.printStackTrace();

// READ operation: Retrieve all users

public static void readUsers() {

try (Connection connection = DriverManager.getConnection(URL, USER, PASSWORD);

Statement statement = connection.createStatement();

ResultSet resultSet = statement.executeQuery("SELECT * FROM users")) {

System.out.println("Users in the database:");

while (resultSet.next()) {

int id = resultSet.getInt("id");

String name = resultSet.getString("name");

String email = resultSet.getString("email");

System.out.println("ID: " + id + ", Name: " + name + ", Email: " + email);

} catch (SQLException e) {

e.printStackTrace();

// UPDATE operation: Update user details

public static void updateUser(int userId, String newName, String newEmail) {

PreparedStatement preparedStatement = connection.prepareStatement(

"UPDATE users SET name = ?, email = ? WHERE id = ?")) {

preparedStatement.setString(1, newName);

preparedStatement.setString(2, newEmail);

preparedStatement.setInt(3, userId);

int rowsAffected = preparedStatement.executeUpdate();

if (rowsAffected > 0) {

System.out.println("User with ID " + userId + " updated successfully.");

} catch (SQLException e) {

e.printStackTrace();

// DELETE operation: Delete user by ID

public static void deleteUser(int userId) {

try (Connection connection = DriverManager.getConnection(URL, USER, PASSWORD);

PreparedStatement preparedStatement = connection.prepareStatement(

"DELETE FROM users WHERE id = ?")) {

preparedStatement.setInt(1, userId);
 int rowsAffected = preparedStatement.executeUpdate();

if (rowsAffected > 0) {

System.out.println("User with ID " + userId + " deleted successfully.");

} catch (SQLException e) {

e.printStackTrace();

4. Running the Application in Eclipse

4.1 Run the Program:

Right-click on the DatabaseCRUDOperations.java file.

Select Run As > Java Application.

4.2 Sample Output:

If everything is set up correctly, the output should look like this:

User added successfully: Alice

Users in the database:

ID: 1, Name: John Doe, Email: john.doe@example.com

ID: 2, Name: Jane Doe, Email: jane.doe@example.com

ID: 3, Name: Alice, Email: alice@example.com

User with ID 1 updated successfully.

User with ID 2 deleted successfully.

ID: 1, Name: John Smith, Email: john.smith@example.com

ID: 3, Name: Alice, Email: alice@example.com