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

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

(ResultSet)stmt.getObject?(1)；

---------------------------------------------------------------

see
http://osi.oracle.com/~tkyte/ResultSets/index.html

import 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();
}
}