Creating Connections with DataSource Class

JDBC for MySQL - Herong's Tutorial Examples

∟Creating Connections with DataSource Class

This section describes how to create connection objects with the DataSource class.

It is recommended now that connection objects are created by the DataSource implementation class, com.mysql.cj.jdbc.MysqlDataSource (or com.mysql.jdbc.jdbc2.optional.MysqlDataSource for older versions of the MySQL JDBC driver). Here is a sample program that creates a connection object using the DataSource class:

/* MySqlDataSource.java
 * Copyright (c) HerongYang.com. All Rights Reserved.
 */
import java.sql.*;
import javax.sql.*;
public class MySqlDataSource {
  public static void main(String [] args) {
    Connection con = null;
    try {

// Setting up the DataSource object - newer version
      com.mysql.cj.jdbc.MysqlDataSource ds
        = new com.mysql.cj.jdbc.MysqlDataSource();

// Setting up the DataSource object - older version
      // com.mysql.jdbc.jdbc2.optional.MysqlDataSource ds
      //   = new com.mysql.jdbc.jdbc2.optional.MysqlDataSource();

      ds.setServerName("localhost");
      ds.setPortNumber(3306);
      ds.setDatabaseName("HerongDB");
      ds.setUser("Herong");
      ds.setPassword("TopSecret");
      ds.setServerTimezone(java.util.TimeZone.getDefault().getID());

// Getting a connection object
      con = ds.getConnection();

// Getting database info
      DatabaseMetaData meta = con.getMetaData();
      System.out.println("Server name: "
        + meta.getDatabaseProductName());
      System.out.println("Server version: "
        + meta.getDatabaseProductVersion());

// Closing the connection
      con.close();
    } catch (Exception e) {
      System.err.println("Exception: "+e.getMessage());
    }
  }
}

The output confirms that I got a good connection. Remember to include the JDBC driver JAR file in the classpath for both compilation and execution:

herong> javac -cp .:mysql-connector-java.jar MySqlDataSource.java

herong> java -cp .:mysql-connector-java.jar MySqlDataSource
Server name: MySQL
Server version: 8.0.17