怎样在JAVA里实现获取指定服务器上所有可用数据库的列表??

怎样在JAVA里实现获取指定服务器上所有可用数据库的列表??
---------------------------------------------------------------

public class MyJDBC
{
public static void main(String[] args) throws java.sql.SQLException
{
try
{
java.lang.Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch (java.lang.ClassNotFoundException e1)
{
System.err.print("ClassNotFoundException: ");
System.err.println(e1.getMessage());
}
//java.lang.Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
java.sql.Connection ConnectionX = java.sql.DriverManager.getConnection("jdbc:ODBC:DSNNorthwind","sa", "");
java.sql.DatabaseMetaData DatabaseMetaDataX =ConnectionX.getMetaData();
java.sql.ResultSet ResultSetX;
ResultSetX = DatabaseMetaDataX.getCatalogs();
while (ResultSetX.next())
{
System.out.println (ResultSetX.getString("TABLE_CAT") );

}
//java.sql.ResultSet ResultSetX;
}
}
---------------------------------------------------------------

/*
前期工作:用odbc建一个SQL连接,我这里连接名为:MyDataTest
/
import java.sql.
;
public class Lookup {
public static void main(String[] args) {
try {
Class.forName(
"sun.jdbc.odbc.JdbcOdbcDriver");
Connection c = DriverManager.getConnection(
"jdbc:odbc:MyDataTest","sa","");
Statement s = c.createStatement();
ResultSet r =
s.executeQuery("sp_helpdb");
while(r.next()) {
System.out.println(
r.getString("name") + ", "
+ r.getString("db_size")
+ ": " + r.getString("owner")
+ ": " + r.getString("dbid")
+ ": " + r.getString("created")
+ ": " + r.getString("status")
+ ": " + r.getString("compatibility_level"));
}
s.close();
} catch(Exception e) {
e.printStackTrace();
}
}
}

Published At
Categories with 数据库类
Tagged with
comments powered by Disqus