- // 调用存储过程
- public static void testPro(){
- String driver = "oracle.jdbc.OracleDriver";
- String url = "jdbc:oracle:thin:@localhost:1521:orcl";
- Connection conn = null;
- CallableStatement cs = null;
- try { Class.forName(driver);
- conn = DriverManager.getConnection(url, "scott", "tiger");
- cs = conn.prepareCall("{call countyearsal(?,?)}");
- cs.setInt(1, 7369);
- // 注册 oracle 输出参数的类型
- cs.registerOutParameter(2, OracleTypes.NUMBER);
- cs.execute();
- int ysal = cs.getInt(2);
- System.out.println(ysal);
- } catch (Exception e) {
- e.printStackTrace();
- }finally {
- try {
- if(cs != null){
- cs.close();
- }
- if(conn != null){
- conn.close();
- }
- } catch (SQLException e) {
- e.printStackTrace();
- }
- }
- }
- // 调用存储函数
- public static void testFun(){
- String driver = "oracle.jdbc.OracleDriver";
- String url = "jdbc:oracle:thin:@localhost:1521:orcl";
- Connection conn = null;
- CallableStatement cs = null;
- try {
- Class.forName(driver);
- conn = DriverManager.getConnection(url, "scott", "tiger");
- cs = conn.prepareCall("{?=call countysal(?)}");
- cs.setInt(2, 7369);
- // 注册 oracle 输出参数的类型
- cs.registerOutParameter(1, OracleTypes.NUMBER);
- cs.execute();
- int ysal = cs.getInt(1);
- System.out.println(ysal);
- } catch (Exception e) {
- e.printStackTrace();
- }finally {
- try {
- if(cs != null){
- cs.close();
- }
- if(conn != null){
- conn.close();
- }
- } catch (SQLException e) {
- e.printStackTrace();
- }
- }
- }
来源: http://www.bubuko.com/infodetail-2737079.html