19.5. Connecting to a Database: Example

Let’s connect to a MySQL database.

import java.sql.*;
public class DBConnect {
public static void main(String[] args) {
String url = "jdbc:mysql://localhost:3306/college";
String username = "root";
String password = "admin";
try {
// Load Driver (optional from JDBC 4.0 onward)
Class.forName("com.mysql.cj.jdbc.Driver");
// Establish Connection
Connection con = DriverManager.getConnection(url, username,
password);
System.out.println("Connected successfully!");
con.close();
} catch (Exception e) {
e.printStackTrace();
}
}
}```

In this chunk, we are learning how to connect a Java application to a MySQL database. First, we import the JDBC library to access database functionalities. We specify the URL of the database, the username, and the password needed to log in. In the try block, we load the MySQL JDBC driver, which is necessary to communicate with the database. We then establish a connection using DriverManager.getConnection, which creates a connection object. If successful, we print a success message and close the connection. If there’s an issue, the catch block captures the error and prints the stack trace.

Think of the process of connecting to a database like making a phone call. The database URL serves as the 'phone number', the username is like the 'caller ID', and the password is your 'PIN'. Just like you need to dial the correct number and use your PIN to access the other person, you use the correct database URL and provide your credentials to access the database.

// Load Driver (optional from JDBC 4.0 onward) Class.forName("com.mysql.cj.jdbc.Driver");

Here, we are loading the MySQL JDBC driver using Class.forName(). This step is actually optional in JDBC 4.0 and later versions because the DriverManager can automatically find the appropriate driver in the classpath. Still, some developers prefer to include this line to make the code clearer about which driver is being used, ensuring that it is loaded into memory.

Consider loading a driver like loading a specific app on your smartphone. If you want to use a particular feature (like a navigation app), you first need to ensure that the app is installed. Loading the driver ensures that your Java application is ready to use the specific database features, just as you would open an app to navigate to a location.

Connection con = DriverManager.getConnection(url, username, password); System.out.println("Connected successfully!"); con.close();

In this part, we use the DriverManager.getConnection method to establish a connection to the specified database using the provided URL, username, and password. If the connection is successful, we print a confirmation message. Finally, we close the connection to release the resources back to the system, which is essential for maintaining good performance and preventing memory leaks.

Imagine you’ve connected to a Wi-Fi network on your laptop. When you successfully connect, you receive a notification stating that you’re connected. After using the internet, you disconnect to save battery and resources. Similarly, after establishing a database connection, it's crucial to close it when done.

--