有时需要根据产品名称选择对应的SqlHandle
换了数据库后怎么知道数据库的产品名称呢?
以达梦数据库为例,代码如下:(其他数据库替换对应的驱动以及链接串即可)
输出内容为:
Connection established......
Name of the underlying database: DM DBMS
package com.songxinfeng;
import java.sql.Connection;
import java.sql.DatabaseMetaData;
import java.sql.DriverManager;
import java.sql.SQLException;
public class DatabaseMetaData_getDatabaseProductName {
public static void main(String args[]) throws SQLException {
//注册驱动程序
DriverManager.registerDriver(new dm.jdbc.driver.DmDriver());
//获得连接
String mysqlUrl = "jdbc:dm://127.0.0.1:5236";
Connection con = DriverManager.getConnection(mysqlUrl, "sysdba", "sysdba123");
System.out.println("Connection established......");
//检索元数据对象
DatabaseMetaData metaData = con.getMetaData();
//检索数据库的名称
String product_name = metaData.getDatabaseProductName();
System.out.println("Name of the underlying database: "+product_name);
}
}