请教如何用java把调用存储过程的返回结果取出？

fwind1982

存储过程sql语句为"Declare myVal Integer; Begin......;End;"
myVal为返回结果，如何用java把它取得

perryhg

1. This example demonstrates how to call stored procedures with IN, OUT, and IN/OUT parameters.
   
2.     CallableStatement cs;
   
3.     try {
   
4.       // Call a procedure with no parameters
   
5.         cs = connection.prepareCall("{call myproc}");
   
6.         cs.execute();
   
7.    
   
8.       // Call a procedure with one IN parameter
   
9.         cs = connection.prepareCall("{call myprocin(?)}");
   
10.    
    
11.         // Set the value for the IN parameter
    
12.         cs.setString(1, "a string");
    
13.    
    
14.         // Execute the stored procedure
    
15.         cs.execute();
    
16.    
    
17.       // Call a procedure with one OUT parameter
    
18.         cs = connection.prepareCall("{call myprocout(?)}");
    
19.    
    
20.         // Register the type of the OUT parameter
    
21.         cs.registerOutParameter(1, Types.VARCHAR);
    
22.    
    
23.         // Execute the stored procedure and retrieve the OUT value
    
24.         cs.execute();
    
25.         String outParam = cs.getString(1);     // OUT parameter
    
26.    
    
27.       // Call a procedure with one IN/OUT parameter
    
28.         cs = connection.prepareCall("{call myprocinout(?)}");
    
29.    
    
30.         // Register the type of the IN/OUT parameter
    
31.         cs.registerOutParameter(1, Types.VARCHAR);
    
32.    
    
33.         // Set the value for the IN/OUT parameter
    
34.         cs.setString(1, "a string");
    
35.    
    
36.         // Execute the stored procedure and retrieve the IN/OUT value
    
37.         cs.execute();
    
38.         outParam = cs.getString(1);            // OUT parameter
    
39.     } catch (SQLException e) {
    
40.     }

复制代码

http://www.javaalmanac.com/egs/java.sql/CallProcedure.html