怎样通过java.sql.*连接sqlserver和oracle数据库？

Question

private static void link() throws ClassNotFoundException, Exception {
Connection connection = null; String driver = ("oracle.jdbc.OracleDriver");
String url = ("jdbc:oracle:thin:@192.168.0.240:1521:test");
String user = ("scott");
String pswd = ("tiger"); Class.forName(driver);
ConnectionFactory conFactory = new DriverManagerConnectionFactory(url,
user, pswd);
connection = conFactory.createConnection(); StringBuffer sb = new StringBuffer();
sb.append("SELECT                        \n");
sb.append("*      \n");
sb.append("FROM                      \n");
sb.append("Dept                        \n");
sb.append("order by                  \n");
sb.append("deptno              \n"); PreparedStatement stmt = connection.prepareStatement(sb.toString());
ResultSet set = stmt.executeQuery(); while (set.next()) {
System.out.println(set.getInt(1));
System.out.println(set.getString(2));
System.out.println(set.getString(3)); }
stmt.close();
connection.close();

}
都是一样的

Answer 1

sqlserver的话是不是只要将 “oracle”字符串全部替换成“sqlserver”？

Answer 2

String driver = ("oracle.jdbc.OracleDriver");
String url = ("jdbc:oracle:thin:@192.168.0.240:1521:test");这两个都要改驱动器类名字肯定不一样
url也不一样"com.inet.tds.TdsDriver"
value="jdbc:inetdae7:localhost?database=airline"
大概是这样
上网搜找一下