SQLite Database in Java (Intellij Setup)

Code Discussed in Video:

Main.java

package org.example;
import org.example.models.ConnectDB;
import java.sql.*;
public class Main {
    public static void main(String[] args) {
        ConnectDB db = new ConnectDB();
        Connection connection = db.getConnection();
        if (connection != null) {
            try {
                Statement statement = connection.createStatement();
                String createTable=“CREATE TABLE IF NOT EXISTS students (id INTEGER PRIMARY KEY, name TEXT)”;
                // Create table if not exists
//                Operation:C
                statement.executeUpdate(createTable);
                // Insert data
                statement.executeUpdate(“INSERT INTO students (name) VALUES (‘John’)”);
                statement.executeUpdate(“INSERT INTO students (name) VALUES (‘Alice’)”);
                System.out.println(“Data Inserted”);
//                Operation:R
                // Display data
                ResultSet resultSet = statement.executeQuery(“SELECT * FROM students”);
                System.out.println(“ID\tName”);
                while (resultSet.next()) {
                    int id = resultSet.getInt(“id”);
                    String name = resultSet.getString(“name”);
                    System.out.println(id + “\t“ + name);
                }
//                Operation:U
                // Update data
                statement.executeUpdate(“UPDATE students SET name = ‘Johnny’ WHERE id = 1”);
                System.out.println(“Data Updated”);
                // Display updated data
                resultSet = statement.executeQuery(“SELECT * FROM students”);
                System.out.println(“ID\tName”);
                while (resultSet.next()) {
                    int id = resultSet.getInt(“id”);
                    String name = resultSet.getString(“name”);
                    System.out.println(id + “\t“ + name);
                }
//                Operation:D
//                 Delete data
                statement.executeUpdate(“DELETE FROM students WHERE id = 2”);
                // Close resources
                resultSet.close();
                statement.close();
            } catch (SQLException e) {
                e.printStackTrace();
            } finally {
                db.closeConnection();
            }
        } else {
            System.out.println(“Connection failed.”);
        }
    }
}

models/ConnectDB.java

package org.example.models;
// Uncomment line 3 to import all classes from java.sql.* for database operations.
//import java.sql.*;
// Alternatively, import only the necessary classes.
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class ConnectDB {
    private Connection connection;
    public ConnectDB() {
        String url = “jdbc:sqlite:mydb.db”; // Specify your database URL
        try {
            connection = DriverManager.getConnection(url);
            System.out.println(“Connection Successful”);
        } catch (SQLException e) {
            System.out.println(“Error Connecting to Database”);
            e.printStackTrace();
        }
    }
    public Connection getConnection() {
        return connection;
    }
    public void closeConnection() {
        try {
            if (connection != null) {
                System.out.println(“Connection Closed”);
                connection.close();
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}

Introduction:

In the realm of Java development, managing databases efficiently is essential for building robust and scalable applications. SQLite, a lightweight and self-contained database engine, offers an excellent solution for integrating databases into Java projects. Coupled with the powerful IntelliJ IDEA IDE, developers gain a seamless environment for coding and database management. In this comprehensive guide, we’ll walk you through the process of setting up a SQLite database for Java in IntelliJ IDEA, covering installation, configuration, and CRUD operations.

Section 1: Understanding SQLite Database and IntelliJ IDEA

SQLite is a popular embedded relational database engine known for its simplicity and flexibility. In this section, we’ll introduce you to SQLite and explain why it’s an excellent choice for Java development. We’ll also discuss the features and benefits of IntelliJ IDEA IDE, highlighting its role in facilitating efficient coding and database management.

Section 2: Installation and Setup

Getting started with SQLite and IntelliJ IDEA is easy. In this section, we’ll guide you through the installation process of IntelliJ IDEA and show you how to set up a new Java project. We’ll provide detailed instructions on adding the SQLite JDBC dependency to your project and configuring the database connection.

Section 3: Writing Database Connection Code

Once your project is set up, it’s time to establish a connection to the SQLite database. In this section, we’ll walk you through writing the code to connect to the SQLite database using JDBC. We’ll cover essential concepts such as loading the JDBC driver, creating a connection, and handling exceptions.

Section 4: Performing CRUD Operations

With the database connection established, you’ll learn how to perform CRUD operations in SQLite using Java. We’ll demonstrate how to create, read, update, and delete records in the database using JDBC. You’ll gain a deeper understanding of SQL queries and learn how to execute them programmatically in your Java application.

Conclusion:

Congratulations! You’ve now mastered the art of setting up a SQLite database for Java in IntelliJ IDEA. By following the steps outlined in this guide, you’ve gained valuable insights into SQLite database integration and IntelliJ IDEA IDE. Armed with this knowledge, you’re ready to tackle more complex database tasks and build powerful Java applications with confidence.

With SQLite and IntelliJ IDEA at your disposal, the possibilities are endless. Whether you’re developing a small personal project or a large-scale enterprise application, the combination of SQLite and IntelliJ IDEA provides a robust and efficient platform for Java development. Happy coding!

TrachitZ - Youtube

These are some recent videos in my YouTube channel. You can visit my channel to watch similar videos.

One Response

reddit fitspresso says:

March 17, 2024 at 2:48 PM

Thank you for creating such valuable content. Your hard work and dedication are appreciated by so many.

Reply