EN
Java - how to load MySQL JDBC driver proper way?
14 points
Working with MySQL and JDBC in Java requires to make some steps depending of driver version we work.
Universal steps:
- download JDBC driver visit maven repository web page select some version and download
*.jarfile, - attach
*.jarfile to your project as library, - load "
com.mysql.jdbc.Driver" or "com.mysql.cj.jdbc.Driver" withClass.forName()method call if it is necessary.
Below fast descriptions how to load drivers have been described.
If bellow message will appear in console it means we have new driver.
Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.
Read more about version with API changes here.
If projects uses the newest vesion of JDBC, this approach should be used.
xxxxxxxxxx1
package com.dirask.examples;2
3
import java.sql.Connection;4
import java.sql.DriverManager;5
import java.sql.ResultSet;6
import java.sql.SQLException;7
import java.sql.Statement;8
9
public class Program {10
11
// Optionally for new version of driver:12
// private static final String JDBC_DRIVER = "com.mysql.cj.jdbc.Driver";13
14
private static final String DB_NAME = "test";15
private static final String DB_HOST = "127.0.0.1"; // 'localhost'16
private static final String DB_USER = "root";17
private static final String DB_PASSWORD = "root";18
19
private static final String DB_URL = "jdbc:mysql://" + DB_HOST + "/" + DB_NAME + "?serverTimezone=UTC";20
21
public static void main(String[] args) throws ClassNotFoundException {22
23
// Optionally new versions of driver can be loaded here:24
// Class.forName(JDBC_DRIVER);25
26
String sql = "SELECT * FROM `users`";27
28
try (29
Connection connection = DriverManager.getConnection(DB_URL, DB_USER, DB_PASSWORD); 30
Statement statement = connection.createStatement();31
) {32
try (ResultSet result = statement.executeQuery(sql)) {33
System.out.print("[id]\t[name]\t[role]\n");34
35
while (result.next()) {36
int id = result.getInt("id");37
String name = result.getString("name");38
String role = result.getString("role");39
40
System.out.print(id + "\t" + name + "\t" + role + "\n");41
}42
}43
} catch (SQLException e) {44
e.printStackTrace();45
}46
}47
}Result:
xxxxxxxxxx1
[id] [name] [role]2
1 John admin3
2 Chris moderator4
3 Kate user5
4 Denis moderator6
5 Matt moderatorNote: data preparation sql can be found here (at the end of article).
xxxxxxxxxx1
package com.dirask.examples;2
3
import java.sql.Connection;4
import java.sql.DriverManager;5
import java.sql.ResultSet;6
import java.sql.SQLException;7
import java.sql.Statement;8
9
public class Program {10
11
// old version of driver12
private static final String JDBC_DRIVER = "com.mysql.jdbc.Driver";13
14
private static final String DB_NAME = "test";15
private static final String DB_HOST = "127.0.0.1"; // 'localhost'16
private static final String DB_USER = "root";17
private static final String DB_PASSWORD = "root";18
19
private static final String DB_URL = "jdbc:mysql://" + DB_HOST + "/" + DB_NAME;20
21
public static void main(String[] args) throws ClassNotFoundException {22
23
// old versions of driver must be loaded before making connection24
Class.forName(JDBC_DRIVER);25
26
String sql = "SELECT * FROM `users`";27
28
try (29
Connection connection = DriverManager.getConnection(DB_URL, DB_USER, DB_PASSWORD);30
Statement statement = connection.createStatement();31
) {32
try (ResultSet result = statement.executeQuery(sql)) {33
System.out.print("[id]\t[name]\t[role]\n");34
35
while (result.next()) {36
int id = result.getInt("id");37
String name = result.getString("name");38
String role = result.getString("role");39
40
System.out.print(id + "\t" + name + "\t" + role + "\n");41
}42
}43
} catch (SQLException e) {44
e.printStackTrace();45
}46
}47
}Result:
xxxxxxxxxx1
[id] [name] [role]2
1 John admin3
2 Chris moderator4
3 Kate user5
4 Denis moderator6
5 Matt moderatorNote: data preparation sql can be found here (at the end of article).
