如何解析JDBC网址以获取主机名，端口等? [英] How to parse a JDBC url to get hostname,port etc?

问题描述

如何解析JDBC URL(oracle或sqlserver)以获取主机名，端口和数据库名称.URL的格式不同.

How can I parse a JDBC URL (oracle or sqlserver) to get the hostname, port, and database name. The formats of the URL are different.

推荐答案

以类似这样的内容开头:

Start with something like this:

String url = "jdbc:derby://localhost:1527/netld;collation=TERRITORY_BASED:PRIMARY";
String cleanURI = url.substring(5);

URI uri = URI.create(cleanURI);
System.out.println(uri.getScheme());
System.out.println(uri.getHost());
System.out.println(uri.getPort());
System.out.println(uri.getPath());

以上内容的输出:

derby
localhost
1527
/netld;collation=TERRITORY_BASED:PRIMARY

这篇关于如何解析JDBC网址以获取主机名，端口等?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！