The DriverManager class in the java.sql package provides the getConnection() method to establish a connection between a Java application and a database. There are three commonly used overloaded forms of getConnection().
1. Using getConnection(String url)
This method establishes a database connection using only the JDBC URL. The username and password must be handled through the URL or other driver-specific configuration.
Syntax:
Connection conn = DriverManager.getConnection(String url);
import java.sql.Connection;
import java.sql.DriverManager;
public class DatabaseConnection1 {
public static void main(String[] args) {
String url = "jdbc:mysql://localhost:3306/jdbc_demo?user=root&password=password";
try {
Connection con = DriverManager.getConnection(url);
System.out.println("Database connected successfully!");
con.close();
} catch (Exception e) {
System.out.println("Connection failed!");
e.printStackTrace();
}
}
}Execution Steps:
F:\jdbc>set classpath=F:\jdbc\mysql-connector-j-8.3.0.jar;
F:\jdbc>javac DatabaseConnection1.java
F:\jdbc>java DatabaseConnection1Code language: JavaScript (javascript)Output:
Database connected successfully!2. Using getConnection(String url, String user, String password)
This is the most commonly used method for creating a JDBC connection. It accepts the database URL, username, and password separately.
Syntax:
Connection conn = DriverManager.getConnection(String url, String user, String password);
import java.sql.Connection;
import java.sql.DriverManager;
public class DatabaseConnection2 {
public static void main(String[] args) {
String url = "jdbc:mysql://localhost:3306/jdbc_demo";
String user = "root";
String password = "password";
try {
Connection con =
DriverManager.getConnection(url, user, password);
System.out.println("Database connected successfully!");
con.close();
} catch (Exception e) {
System.out.println("Connection failed!");
e.printStackTrace();
}
}
}Execution Steps:
F:\jdbc>set classpath=F:\jdbc\mysql-connector-j-8.3.0.jar;
F:\jdbc>javac DatabaseConnection2.java
F:\jdbc>java DatabaseConnection2
Code language: JavaScript (javascript)Output:
Database connected successfully!3. Using getConnection(String url, Properties info)
This method establishes a connection using a JDBC URL and a Properties object. The Properties object can contain connection information such as username, password, and other database properties.
Syntax:
Connection conn = DriverManager.getConnection(String url, Properties info);
import java.sql.Connection;
import java.sql.DriverManager;
import java.util.Properties;
public class DatabaseConnection3 {
public static void main(String[] args) {
String url = "jdbc:mysql://localhost:3306/jdbc_demo";
Properties properties = new Properties();
properties.setProperty("user", "root");
properties.setProperty("password", "password");
try {
Connection con =
DriverManager.getConnection(url, properties);
System.out.println("Database connected successfully!");
con.close();
} catch (Exception e) {
System.out.println("Connection failed!");
e.printStackTrace();
}
}
}Execution Steps:
F:\jdbc>set classpath=F:\jdbc\mysql-connector-j-8.3.0.jar;
F:\jdbc>javac DatabaseConnection3.java
F:\jdbc>java DatabaseConnection3Code language: JavaScript (javascript)Output:
Database connected successfully!