怎样让Oracle的存储过程返回结果集

Oracle存储过程:JavaEye有BUG,贴不出PL/SQL代码,只好贴图片了!!!

 

Java调用代码:

    try {
          DriverManager.registerDriver (new oracle.jdbc.OracleDriver());
          Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:ora10g", "user", "user");
          
          CallableStatement stmt = conn.prepareCall("BEGIN GETCITY(?, ?); END;");
          //CallableStatement stmt = conn.prepareCall("{ call GETCITY(?, ?) }");
          
          stmt.setString(1, "021"); 
          stmt.registerOutParameter(2, -10 /* OracleTypes.CURSOR = -10 */); //REF CURSOR(OracleTypes.CURSOR==-10)
          stmt.execute();
          ResultSet rs = (ResultSet) stmt.getObject(2);
          while (rs.next()) {
            System.out.println(rs.getString("CITY_NAME")); 
          }
          rs.close();
          rs = null;
          stmt.close();
          stmt = null;
          conn.close();
          conn = null;
        }
        catch (SQLException e) {
          System.out.println(e.getLocalizedMessage());
        }

 

评论

2 楼 DataBird 2011-01-26  

好，民工写的东西就是朴实易懂，不玩高深，呵呵。

1 楼 chengzanda 2010-07-02  

这个东西写的真好，精简实用