如何解析JDBC URL(oracle或sqlserver),以获取主机名、端口和数据库名称,URL的格式是不同的。
如何解析JDBC URL(oracle或sqlserver),以获取主机名、端口和数据库名称,URL的格式是不同的。
从这个开始:
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
这对我没有起作用。我基于一个假设提出了以下方法,即主机名和端口号总是由冒号连接在一起。这个假设适用于我工作中处理的所有数据库(Oracle、Vertica、MySQL等),但它可能无法适用于某些不使用网络端口的东西。
String url = null; // set elsewhere in the class
final public String regexForHostAndPort = "[.\\w]+:\\d+";
final public Pattern hostAndPortPattern = Pattern.compile(regexForHostAndPort);
public String getHostFromUrl() {
Matcher matcher = hostAndPortPattern.matcher(url);
matcher.find();
int start = matcher.start();
int end = matcher.end();
if(start >= 0 && end >= 0) {
String hostAndPort = url.substring(start, end);
String [] array = hostAndPort.split(":");
if(array.length >= 2)
return array[0];
}
throw new IllegalArgumentException("couldn't find pattern '" + regexForHostAndPort + "' in '" + url + "'");
}
public int getPortFromUrl() {
Matcher matcher = hostAndPortPattern.matcher(url);
matcher.find();
int start = matcher.start();
int end = matcher.end();
if(start >= 0 && end >= 0) {
String hostAndPort = url.substring(start, end);
String [] array = hostAndPort.split(":");
if(array.length >= 2)
return Integer.parseInt(array[1]);
}
throw new IllegalArgumentException("couldn't find pattern '" + regexForHostAndPort + "' in '" + url + "'");
}
String jdbcUrl = "jdbc:jtds:sqlserver://ABC_XYZ:1433/Database";
String cleanURI = jdbcUrl.substring("jdbc:jtds:".length());
URI uri = URI.create(cleanURI);
String host = uri.getHost();
int port = uri.getPort();
if(host == null){
String regex = ".*://(\\w*):(\\d++)/.*";
Pattern p = Pattern.compile(regex);
Matcher matcher = p.matcher(jdbcUrl);
if(matcher.find()){
host = matcher.group(1);
port = Integer.valueOf(matcher.group(2));
} else {
// handle fail
}
}
System.out.println("host = " + host);
System.out.println("port = " + port);
我在我的项目中使用这个类。 使用起来非常简单。
/**
* Split di una url JDBC nei componenti.
* Estrae i componenti di una uri JDBC del tipo: <br>
* String url = "jdbc:derby://localhost:1527/netld;collation=TERRITORY_BASED:PRIMARY"; <br>
* nelle rispettive variabili pubbliche.
* @author Nicola De Nisco
*/
public class JdbcUrlSplitter
{
public String driverName, host, port, database, params;
public JdbcUrlSplitter(String jdbcUrl)
{
int pos, pos1, pos2;
String connUri;
if(jdbcUrl == null || !jdbcUrl.startsWith("jdbc:")
|| (pos1 = jdbcUrl.indexOf(':', 5)) == -1)
throw new IllegalArgumentException("Invalid JDBC url.");
driverName = jdbcUrl.substring(5, pos1);
if((pos2 = jdbcUrl.indexOf(';', pos1)) == -1)
{
connUri = jdbcUrl.substring(pos1 + 1);
}
else
{
connUri = jdbcUrl.substring(pos1 + 1, pos2);
params = jdbcUrl.substring(pos2 + 1);
}
if(connUri.startsWith("//"))
{
if((pos = connUri.indexOf('/', 2)) != -1)
{
host = connUri.substring(2, pos);
database = connUri.substring(pos + 1);
if((pos = host.indexOf(':')) != -1)
{
port = host.substring(pos + 1);
host = host.substring(0, pos);
}
}
}
else
{
database = connUri;
}
}
}