当前页面: 开发资料首页 → J2EE 专题 → 怎样通过java.sql.*连接sqlserver和oracle数据库？

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

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

通过odbc我知道了，可如果要直接连接sqlserver和oracle该怎么写呢？

String url = "jdbc:odbc:AddressBook";
String username = "";
String password = "";
//加载驱动程序以连接数据库
try {
Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" );
connection = DriverManager.getConnection(
url, username, password );
}
//捕获加载驱动程序异常
catch ( ClassNotFoundException cnfex ) {
System.err.println(
"装载 JDBC/ODBC 驱动程序失败。" );
cnfex.printStackTrace();
System.exit( 1 ); // terminate program
}

---

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();

}
都是一样的

---

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

---

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"
大概是这样
上网搜找一下

---