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

来源:百度知道 编辑:UC知道 时间:2024/04/27 14:47:32
请问哪位大哥知道,用java访问多个server2000数据库的方法,能给个例子更好,先先谢谢啦!!

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

建立多个连接就行了:

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.getCon