当前页面: 开发资料首页 → 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"
大概是这样
上网搜找一下