public class ConnectionStringParser {
public static void parseConnectionString(String connectionString) {
String ip = null;
int port = 1433; // 默认 SQL Server 端口
String[] parameters = connectionString.split(";");
for (String parameter : parameters) {
if (parameter.startsWith("Data Source=")) {
String dataSource = parameter.substring("Data Source=".length());
if (dataSource.contains(",")) {
String[] parts = dataSource.split(",");
ip = parts[0];
port = Integer.parseInt(parts[1]);
} else {
ip = dataSource;
}
}
}
System.out.println("IP Address: " + ip);
System.out.println("Port: " + port);
}
public static void main(String[] args) {
String connectionString = "Data Source=10.0.1.11;Initial Catalog=123;user ID=456;password=789;Max Pool Size=10;Connect Timeout=60";
parseConnectionString(connectionString);
}
}
ConnectionStringParser
最新推荐文章于 2024-06-30 20:23:11 发布