Java DriverManager getConnection() Method

The getConnection(String url) method of Java DriverManager class attempts to establish a connection to the database by using the given database URL. The appropriate driver from the set of registered JDBC drivers is selected.

Syntax

Parameters

url - a database url of the form jdbc:subprotocol:subname

Returns

This method returns connections to the URL.

Exception

SQLException will be thrown, if database access occurs or url is null.

SQLTimeoutException will be thrown, when the timeout value specified by the setLoginTimeout method has been exceeded and tried to cancel the current database connection attempt.

Example

import java.sql.Connection;
import java.sql.DriverManager;
public class JavaDriverManagerGetConnectionExample1 {
		public static void main(String args[]) throws ClassNotFoundException
		{
			String url;
			Connection con = null;
			try {
				Class.forName("com.mysql.jdbc.Driver");
			url="jdbc:mysql://localhost:3306/spring";
				con = DriverManager.getConnection(url);
				System.out.println("Connection created");
				con.close();
				System.out.println("Connection closed");
				}
				catch (Exception e) {
				System.out.println(e.toString());
			}
	}
}
<!--

Test it Now-->

Output:

java.sql.SQLException: Access denied for user ''@'localhost' (using password: NO)

getConnection(String url, Properties info)

The getConnection(String url, Properties info) method of Java DriverManager class attempts to establish a connection to the database by using the given database url. The appropriate driver from the set of registered JDBC drivers is selected. Properties are implementation-defined as to which value will take precedence. For maximum portability, an application should only specify a property once.