java sqlserver 获取行数,如何从Java中的数据源名称获取sqlserver数据库名称

As specified in the title, I want to get the database name in sqlserver, all info I know is datasource name, login name/password to get the Connection object, please show some pointers on how to retrieve the database name correctly, in java, thanks!

Even

解决方案

Obtain an instance of java.sql.DatabaseMetaData from the connection object.

The names of database can be obtained via getCatalogs() or getSchemas() method (It depends upon the vendor of JDBC driver).

ResultSet rs=cn.getMetaData().getSchemas();

while(rs.next()) {

System.out.println(rs.getString(1));

}

Or use Connection.getCatalog() or Connection.getSchema() method.

In case if you are interested to get host name or ip address of the Oracle database server.

ResultSet rs=st.executeQuery("select UTL_INADDR.GET_HOST_NAME from dual");

while(rs.next())

System.out.println(rs.getString(1));