public class OracleDemo { @Test public void javaCallOracle() throws Exception { Class.forName("oracle.jdbc.driver.OracleDriver"); Connection connection = DriverManager.getConnection("jdbc:oracle:thin:@192.168.80.10:1521:orcl", "scott", "tiger"); //预编译对象 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(); } /** * 调用存储过程 * {call <procedure-name>[(<arg1>,<arg2>, ...)]}存储过程 * * @throws Exception */ @Test public void javaCallProcedure() throws Exception { Class.forName("oracle.jdbc.driver.OracleDriver"); Connec
oracle访问数据库,调用存储过程,存储函数
最新推荐文章于 2022-07-12 00:49:54 发布
![](https://img-home.csdnimg.cn/images/20240711042549.png)