站内搜索: 请输入搜索关键词

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


↑返回目录
前一篇: 书中的例子 现在有点错误 ,怎样更改
后一篇: 求教javascript和session通讯的问题