java 获取数据库信息_java获取数据库信息

备用：

package com.ren.test;

import org.junit.Test;

import java.sql.*;

public class GetInfo {

//获取数据库连接

public static Connection getConnection() {

Connection conn = null;

try {

Class.forName("com.mysql.jdbc.Driver");

String url = "jdbc:mysql://localhost:3306/databasename?useSSL=false";

String user = "root";

String pass = "****";

conn = DriverManager.getConnection(url, user, pass);

}

catch (ClassNotFoundException e) {

e.printStackTrace();

}

catch (SQLException e) {

e.printStackTrace();

}

return conn;

}

/**

* 获取数据库信息

*/

@Test

public void getDatebaseInfo() {

Connection con = getConnection();

DatabaseMetaData dbMetaData = null;

try {

dbMetaData = con.getMetaData();

System.out.println(dbMetaData.getDriverName());

System.out.println(dbMetaData.getURL());

System.out.println(dbMetaData.getUserName());

System.out.println("");

} catch (SQLException e) {

e.printStackTrace();

}

}

/**

* 获取某数据库所有表信息

*/

@Test

public void getTablesInfo() throws SQLException {

Connection conn = getConnection();

DatabaseMetaData dbMetaData = conn.getMetaData();