blocks|key|709662|text|Connection有返回DatabaseMetaData的getMetaData()。DatabaseMetaData具有返回此数据库管理系统的getURL()的URL。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|709663|entityMap|0|LINK|mutability|MUTABLE|url|http://download.oracle.com/javase/6/docs/api/java/sql/Connection.html|1|http://download.oracle.com/javase/6/docs/api/java/sql/DatabaseMetaData.html|2^0|0|A|D|G|U|D|18|G|21|8|0|A|0|D|G|1|18|G|2|0^^$0|@$1|2|3|4|5|6|7|Q|8|@$9|R|A|S|B|C]|$9|T|A|U|B|C]|$9|V|A|W|B|C]|$9|X|A|Y|B|C]|$9|Z|A|10|B|C]]|D|@$9|11|A|12|1|13]|$9|14|A|15|1|16]|$9|17|A|18|1|19]]|E|$]]|$1|F|3|-4|5|6|7|1A|8|@]|D|@]|E|$]]]|G|$H|$5|I|J|K|E|$L|M]]|N|$5|I|J|K|E|$L|O]]|P|$5|I|J|K|E|$L|O]]]]

<a href="http://download.oracle.com/javase/6/docs/api/java/sql/Connection.html" rel="noreferrer"><code>Connection</code></a> has the <code>getMetaData()</code> to return <a href="http://download.oracle.com/javase/6/docs/api/java/sql/DatabaseMetaData.html" rel="noreferrer"><code>DatabaseMetaData</code></a> . <a href="http://download.oracle.com/javase/6/docs/api/java/sql/DatabaseMetaData.html" rel="noreferrer"><code>DatabaseMetaData</code></a> has the <code>getURL()</code> to return the URL for this DBMS.

blocks|key|709671|text|我相信您可以使用Connection中的DatabaseMetaData对象，然后获取网址。尝试：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|709672|DatabaseMetaData+dmd+=+connection.getMetaData();
String+url+=+dmd.getURL();|code-block|syntax|javascript|709673|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

I believe you can use the DatabaseMetaData object from the Connection and then get the URL. Try:

<pre><code>DatabaseMetaData dmd = connection.getMetaData();
String url = dmd.getURL();
</code></pre>

blocks|key|925921|text|在Connection对象内部，有一个DatabaseMetaData类型的对象，它包含大量关于数据库的信息。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|925922|Lucas+de+Oliveira给了你一个很好的代码示例。|925923|下面是该对象的文档：Interface+DatabaseMetaData|offset|length|925924|entityMap|0|LINK|mutability|MUTABLE|url|http://docs.oracle.com/javase/6/docs/api/java/sql/DatabaseMetaData.html^0|0|0|A|Q|0|0^^$0|@$1|2|3|4|5|6|7|P|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|Q|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|R|8|@]|9|@$F|S|G|T|1|U]]|A|$]]|$1|H|3|-4|5|6|7|V|8|@]|9|@]|A|$]]]|I|$J|$5|K|L|M|A|$N|O]]]]

Inside the Connection object, you have an object of type DatabaseMetaData, it contains a lot of information about the database.

Lucas de Oliveira gave you a good example of code.

And here is the documentation of the object :
<a href="http://docs.oracle.com/javase/6/docs/api/java/sql/DatabaseMetaData.html" rel="nofollow">Interface DatabaseMetaData</a>

blocks|key|925943|text|connection.getClientInfo()拥有与连接相关的所有细节。它返回一个属性对象。您可以检索"+password“属性的值，以获取用于连接对象的密码。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|925944|如果这解决了你的问题，请让我知道。|925945|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

connection.getClientInfo() has all the details related to connection. It returns a properties object. You can retrieve the value of "password" property to fetch the password that was used for the connection object.

Please let me know if this solves your problem.

For given <a href="http://download.oracle.com/javase/1.4.2/docs/api/java/sql/Connection.html" rel="noreferrer"><code>Connection</code></a> instance how do I find out url that the <code>Connection</code> uses to connect the database ? Is it somewhere in <code>Properties</code> returned by <a href="http://download.oracle.com/javase/6/docs/api/java/sql/Connection.html#getClientInfo%28%29" rel="noreferrer"><code>Connection.getClientInfo()</code></a> method?

If there you need me to provide clearer description all comments are welcome. Thank you

How to get database url from java.sql.Connection?

数据库管理系统

数据库管理

数据库

对于给定的实例，如何找到Connection用来连接数据库的url？它是否在方法返回的Properties中的某个位置？如果你需要我提供更清晰的描述，欢迎所有评论。谢谢

问如何从java.sql.Connection获取数据库url？
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何从java.sql.Connection获取数据库url？EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何从java.sql.Connection获取数据库url？
EN