Question

java同时访问多个sql server2000数据库

请问哪位大哥知道，用java访问多个server2000数据库的方法，能给个例子更好，先先谢谢啦！！

Answer 1

建立多个连接就行了:

public class DBUtil{

//这个记不清楚
private static final String dbUrl = "jdbc:mssql://localhost:xxx/";
//数据库名称
private static final String dbNames [] = new String [] {"db1","dbn"};
//连接各个数据库需要的用户名
private static final String usernames [] = new String [] {"db1 username","dbn ..."};
//密码
private static final String passwords [] = new String [] {"db1 password","dbn ..."};
//连接数据库需要的JDBC类，如果你是用的同一种数据库
private static final String jdbc= "com.microsoft.....";

public synchronized static Connection getConnection(int db) {
Connection con = null;
if(db > 0 && db < dbName.length) {
try {
Class.forName(jdbc);
con = DriverManager.getConnection(dbUrl + dbNames[db],usernames[db],password[db];
} catch (ClassNotFoundException x) {
System.out.println(x.getMessage());
} catch (SQLException x) {
System.out.println(x.getMessage());
}
}
return con;
}

}

如果要动态的获取数据库连接，可以直接把数据库的名称和密码直接传进来也行。

Answer 2

private static final String dbNames [] = new String [] {"db1","dbn"};
//连接各个数据库需要的用户名

Answer 3

同求~