Java连接Oracle（基础篇）

 

JDBC 编程的基本步骤：

(1) 向系统注册所需的JDBC驱动程序（加载驱动程序）

(2) 建立到指定数据库德连接

(3) 提交数据库查询

(4) 取得查询结果

 

具体代码如下：

public class JDBCDemo {
    public static final String DBDRIVER = "oracle.jdbc.driver.OracleDriver";
	public static final String DBURL = "jdbc:oracle:thin:@localhost:1521:demo";
	public static final String DBUSER = "scott";
	public static final String DBPASSWORD = "tiger";

    public static void main(String[] args) throws Exception {
        Connection conn = null;
        PreparedStatement ps = null;
        ResultSet rs = null;
        String sql = "select empno, ename from emp";

        Class.forName(DBDRIVER);
        conn = DriverManager.getConnection(DBURL, DBUSER, DBPASSWORD);
        ps = conn.prepareStatement(sql);
        rs = ps.executeQuery();

        while (rs.next()) {
            int empno = rs.getInt(1);
            String ename = rs.getString(2);

            System.out.println(empno + "\t" + ename);
        }

        rs.close();
        ps.close();
        conn.close();
    }
}