Oracle数据库添加 更新 游标 过程 Java Project

package com.InAndOut; import java.sql.CallableStatement; import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; public class InAndOutMany { public boolean inAndOutMany() { boolean flag = false; try { // 加载驱动 Class.forName("oracle.jdbc.driver.OracleDriver"); // 得到连接 Connection conn = DriverManager.getConnection( "jdbc:oracle:thin:@127.0.0.1:1521:ORA9I", "SCOTT", "tiger"); // 创建CallableStatement CallableStatement cs = conn .prepareCall("{call sp_pro13(?,?,?)}"); cs.setInt(1, 7788); cs.registerOutParameter(2,oracle.jdbc.OracleTypes.VARCHAR); cs.registerOutParameter(3, oracle.jdbc.OracleTypes.NUMBER); // 执行 flag = cs.execute(); //取出返回值 String name= cs.getString(2); System.out.println(name); int sal= cs.getInt(3); System.out.println(sal); // 关闭资源 cs.close(); conn.close(); } catch (SQLException e) { e.printStackTrace(); } catch (ClassNotFoundException e) { e.printStackTrace(); } return flag; } /** * @param args */ public static void main(String[] args) { InAndOutMany inAndOut=new InAndOutMany(); inAndOut.inAndOutMany(); } }