Java连接oracle

最新推荐文章于 2023-04-20 10:14:06 发布

fobgochod

最新推荐文章于 2023-04-20 10:14:06 发布

阅读量370

点赞数

分类专栏： Java

本文链接：https://blog.csdn.net/fobgochod/article/details/47959501

版权

Java 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

1、采用JDBC-ODBC Bridge连接oracle数据库

package zhou.xiao;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

/**
 * 1、采用JDBC-ODBC Bridge连接oracle数据库
 * 
 * @author Zhou Xiao
 * 
 */
public class ConnOdbc {
	
	public static void main(String[] args) throws SQLException {
		
		Connection ct = null;
		Statement sm = null;
		ResultSet rs =null;
		try {
			// 1、加载驱动
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			// 2、得到连接
			ct = DriverManager.getConnection("jdbc:odbc:oracle10g", "zhou", "xiao");
			// 3、测试
			sm = ct.createStatement();

			rs = sm.executeQuery("select id,loginid from users");
			while (rs.next()) {
				System.out.println("用户ID：" + rs.getInt(1) + "\t用户帐号：" + rs.getString(2));
			}
		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			rs.close();
			sm.close();
			ct.close();
		}
	}
}

2、使用JDBC连接oracle数据库

package zhou.xiao;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

/**
 * 2、使用JDBC连接oracle数据库
 * 
 * @author Zhou Xiao
 * 
 */
public class ConnJdbc {

	public static void main(String[] args) throws SQLException {

		Connection ct = null;
		Statement sm = null;
		ResultSet rs = null;
		try {
			// 1、加载驱动
			Class.forName("oracle.jdbc.driver.OracleDriver");
			// 2、得到连接
			ct = DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:orcl", "zhou", "xiao");
			// 3、测试
			sm = ct.createStatement();

			rs = sm.executeQuery("select id,loginid from users");
			while (rs.next()) {
				System.out.println("用户ID：" + rs.getInt(1) + "\t用户帐号：" + rs.getString(2));
			}
		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			rs.close();
			sm.close();
			ct.close();
		}
	}
}