3.4. Steps to Connect to a Database Using JDBC

1. Load the JDBC Driver

Class.forName("com.mysql.cj.jdbc.Driver");

Before a Java application can connect to a MySQL database, it needs to load the JDBC driver. The line Class.forName("com.mysql.cj.jdbc.Driver"); is used for this purpose. It tells the Java program to load the MySQL database driver class specified in the string. If the driver is not found, a ClassNotFoundException will be thrown, indicating that the JDBC driver is not available on the classpath.

Think of loading the JDBC driver as finding the right key to unlock a door. Without the correct key (the driver), you won't be able to enter the building (connect to the database).

2. Establish the Connection

Connection con = DriverManager.getConnection(
"jdbc:mysql://localhost:3306/testdb", "root", "password");

After loading the driver, the next step is to establish a connection to the database. The DriverManager.getConnection method is called with three parameters: the database URL, username, and password. The URL jdbc:mysql://localhost:3306/testdb specifies that we're connecting to a MySQL database named 'testdb' running on the local machine (localhost) on port 3306. If the connection is successful, it returns a Connection object that can be used to interact with the database.

Establishing a connection is like opening a door to your friend's house. You need to know the address (URL), and you need the right keys (username and password) to gain entry.

3. Create a Statement

Statement stmt = con.createStatement();

Once the connection is established, the application can create a Statement object using con.createStatement(). This object is used to send SQL queries to the database. It allows the programmer to execute static SQL statements and retrieve results.

Creating a statement is like preparing a form that you will fill out and present to your school to request a change in your schedule. The statement is your form through which you communicate with the database.

4. Execute the Query

ResultSet rs = stmt.executeQuery("SELECT * FROM employees");

With a Statement object in hand, you can now execute queries. The line stmt.executeQuery("SELECT * FROM employees"); sends a SQL SELECT statement to the database to retrieve all records from the 'employees' table. The results are stored in a ResultSet object, which allows you to navigate through the returned data.

Executing a query is similar to sending a request to a restaurant for a menu item. You ask for a specific dish (SQL command), and the restaurant brings back the order (data) for you to enjoy.

5. Process the Result

while(rs.next()) {
System.out.println(rs.getInt(1) + " " + rs.getString(2));
}

After executing the query, the next step is to process the Results. The while(rs.next()) loop iterates through each record in the ResultSet. Inside the loop, you can access the data. The methods rs.getInt(1) and rs.getString(2) retrieve the first integer and second string from the current record, respectively. This is how you can display or manipulate the data retrieved from the database.

Processing the result is like reviewing the receipts at a store after making a purchase. You check each item (record) one by one to see what you've bought and how much it costs.

6. Close the Connection

con.close();

The last step in connecting to a database is to close the connection using con.close();. This is important for freeing up database resources. If connections are not closed properly, it can lead to memory leaks and eventually exhaust the available connections to the database.

Closing the connection is like locking the door of your house when you leave. It secures your home (database) and makes sure no one can enter without permission.

--