The code below helps you to get some product information about the database that you use in creating your program. You can retrieve database information such at the major and minor version of the product, the database product name and its release version.
package org.kodejava.jdbc;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.DatabaseMetaData;
import java.sql.SQLException;
public class DatabaseProductInfo {
private static final String URL = "jdbc:mysql://localhost/kodejava";
private static final String USERNAME = "root";
private static final String PASSWORD = "";
public static void main(String[] args) {
try (Connection connection =
DriverManager.getConnection(URL, USERNAME, PASSWORD)) {
DatabaseMetaData metadata = connection.getMetaData();
String productName = metadata.getDatabaseProductName();
String productVersion = metadata.getDatabaseProductVersion();
int majorVersion = metadata.getDatabaseMajorVersion();
int minorVersion = metadata.getDatabaseMinorVersion();
System.out.println("Product Name = " + productName);
System.out.println("Product Version = " + productVersion);
System.out.println("Major Version = " + majorVersion);
System.out.println("Minor Version = " + minorVersion);
} catch (SQLException e) {
e.printStackTrace();
}
}
}
And here are the result:
Product Name = MySQL
Product Version = 5.7.18
Major Version = 5
Minor Version = 7
Maven dependencies
<dependency>
<groupId>com.mysql</groupId>
<artifactId>mysql-connector-j</artifactId>
<version>8.0.32</version>
</dependency>
Latest posts by Wayan (see all)
- How do I get the number of processors available to the JVM? - March 29, 2023
- How do I show Spring transaction in log / console? - March 29, 2023
- How do I build simple search page using ZK and Spring Boot? - March 8, 2023