各位同道：oracle9i用遊標返回記錄集,在 java/jsp 中怎樣接收?!!謝謝!!

Question

(ResultSet)stmt.getObject?(1)；

Answer 1

see
http://osi.oracle.com/~tkyte/ResultSets/index.htmlimport java.sql.*; 
import java.io.*; 
import oracle.jdbc.driver.*; 
  class curvar 
{ 
  public static void main (String args []) 
                     throws SQLException, ClassNotFoundException 
  { 
      String driver_class = "oracle.jdbc.driver.OracleDriver"; 
      String connect_string = "jdbc:oracle:thin:@slackdog:1521:oracle8";       String query = "begin :1 := sp_listEmp; end;"; 
      Connection conn;       Class.forName(driver_class); 
      conn = DriverManager.getConnection(connect_string, "scott", "tiger");       CallableStatement cstmt = conn.prepareCall(query); 
      cstmt.registerOutParameter(1,OracleTypes.CURSOR); 
      cstmt.execute(); 
      ResultSet rset = (ResultSet)cstmt.getObject(1);       while (rset.next ()) 
        System.out.println( rset.getString (1) ); 
      cstmt.close(); 
  } 
}