CallableStatement如何获取SQL2000中存储过程的返回列表

Question

存储过程如下:
CREATE PROCEDURE  getEmployeeByID
  
    @employeeID  char(4) ASRETURN SELECT  EmployeeID, EmployeeName ,DeptID,Duty,Sex,Birthday,Married,Nationality,EmployStyle,WageStyle ,Wage,TechTitle ,BeginWorkTime,JoinCompTime,PoliVisage ,Idcard,EmployTerm,EmployBeginTime,DimissionTime,Speciality,OfficeTele,MobiTele,Email ,Address,CommuAddr,Postalcode,HomeTele,NativePlace,UrgencyLinkman,UrgencyLinkTele,AccountBank,Accounts,
EndowInsurNum,HospiInsurNum,TempDwell,GraduateSchool,Specialty,Degree,GraduateTime,ForeignLanguage,
ComputLevel,OtherEduInfo,Resume,Memo,FacePath FROM Employee WHERE EmployeeID=@employeeID
GO 各位高手,接分

Answer 1

和一般的statement是一样的cstmt.getResult();

Answer 2

加入存储过程没有输入参数只有一个返回参数 即rs对象 那么调用该存储过程如下
CallableStatement proc = null;      proc = conn.prepareCall("{ call 包.名称(?) }");      proc.registerOutParameter(1,oracle.jdbc.OracleTypes.CURSOR);      proc.execute();      rs = (ResultSet)proc.getObject(1);       while(rs.next())      {          System.out.println("<tr><td>" + rs.getString(1) + "</td><td>"+rs.getString(2)+"</td></tr>");      }

Answer 3

我把Sql 2000的调用方法写到blog里面了,参考下面的地址http://www.blogjava.net/sunfruit/archive/2006/06/15/52916.html