java 获取mysql_【java 获取数据库信息】获取MySQL或其他数据库的详细信息

1 packagecom.sxd.mysqlInfo.test;2

3 importjava.sql.DriverManager;4 importjava.sql.ResultSet;5 importjava.sql.SQLException;6

7 importorg.junit.Test;8

9 importcom.mysql.jdbc.Connection;10 importcom.mysql.jdbc.DatabaseMetaData;11

12 public classMysqlInfo {13

14 private final String DRIVER = "com.mysql.jdbc.Driver";15 private final String URL = "jdbc:mysql://localhost:3306/";16 private final String USERNAME = "root";17 private final String PASSWORD = "root";18

19 @Test20 public void just4MySQLInfo() throwsClassNotFoundException, SQLException{21 Class.forName(DRIVER);22 Connection con =(Connection) DriverManager.getConnection(URL,USERNAME,PASSWORD);23 DatabaseMetaData metaData =(DatabaseMetaData) con.getMetaData();24

25 /**

26 * 1.返回数据库的相关信息27 */

28 System.out.println("数据库已知的用户: "+metaData.getUserName());2