java数据库连接问题

[虽不简单]

我想建个网站，连接多个服务器上的数据库，该怎么处理阿？

[qm4050]

建多个数据源

[shawn.bug]

那就写多个JDBC connection 被

[gongzuo2011]

同意以上

[huangdaxiang0726]

同上 同

[amkaiom]

同1、2楼

[hlw_cn]

建立多个数据源，来回切换

[softroad]

	public static void main(String[] args) {
		
		// Create a variable for the connection string.
		String connectionUrl = "jdbc:sqlserver://localhost:1433;" +
			"databaseName=AdventureWorks;integratedSecurity=true;";

		// Declare the JDBC objects.
		Connection con = null;
		Statement stmt = null;
		ResultSet rs = null;
		
        	try {
        		// Establish the connection.
        		Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
            		con = DriverManager.getConnection(connectionUrl);
            
            		// Create and execute an SQL statement that returns some data.
            		String SQL = "SELECT TOP 10 * FROM Person.Contact";
            		stmt = con.createStatement();
            		rs = stmt.executeQuery(SQL);
            
            		// Iterate through the data in the result set and display it.
            		while (rs.next()) {
            			System.out.println(rs.getString(4) + " " + rs.getString(6));
            		}
        	}
        
		// Handle any errors that may have occurred.
		catch (Exception e) {
			e.printStackTrace();
		}

		finally {
			if (rs != null) try { rs.close(); } catch(Exception e) {}
	    		if (stmt != null) try { stmt.close(); } catch(Exception e) {}
	    		if (con != null) try { con.close(); } catch(Exception e) {}
		}
	}

多写几个呗。

[飓风zj]

多个数据源就可以了

[轻狂小疯]

同上！！

[EverWHL]

顶 楼上同胞

[Ade子夜]

顶！！！

[chang1984024]

写一个 可以传参数的 dao

public class StudentDAO {
String driver = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
Connection conn=null;
Statement state=null;
ResultSet rs = null;

public StudentDAO(String jx)
{
try
{
Class.forName(driver);
conn = DriverManager.getConnection("jdbc:sqlserver://localhost:1433;DatabaseName="+jx+"","sa","2008hongyu");
}
catch(Exception e)
{
e.printStackTrace();
}
}

[CaptainGan]

写个数据库连接类。