java连Oracle数据库

oracle数据库版本对应的jar包：
—oracle10g ojdbc14.jar
—oracle11g ojdbc6.jar

    @Test
    public void javaCallOracle() throws Exception {
        //加载数据库驱动
        Class.forName("oracle.jdbc.driver.OracleDriver");
        //得到Connection链接
        Connection connection = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl", "hehe", "hehe");

        //得到预编译得Statement对象
        PreparedStatement pstm = connection.prepareStatement("select * from emp where empno=?");
        pstm.setObject(1,7788);
        //执行数据库操作
        ResultSet rs = pstm.executeQuery();
        //输出结果
        while(rs.next()){
            System.out.println(rs.getString("ename"));
        }
        //释放资源
        rs.close();
        pstm.close();
        connection.close();
    }