Stored procedure return value

Du kan godt returnere flere result sets fra en SP.

Eksempel:

DELIMITER //
CREATE PROCEDURE test(OUT v INTEGER)
BEGIN
    -- first result set
    SELECT 1;
    -- second result set
    SELECT 2;
    -- out parameter
    SELECT 3 INTO v;
END//
DELIMITER ;

Kald fra Java:

import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Types;

public class MySP {
    public static void main(String[] args) throws Exception {
        Class.forName("com.mysql.jdbc.Driver");
        Connection con = DriverManager.getConnection("jdbc:mysql://localhost/Test", "root", "");
        CallableStatement cstmt = con.prepareCall("{CALL test(?)}");
        cstmt.registerOutParameter(1, Types.INTEGER);
        cstmt.execute();
        ResultSet rs = cstmt.getResultSet();
        while(rs.next()) {
            System.out.println(rs.getInt(1));
        }
        cstmt.getMoreResults();
        rs = cstmt.getResultSet();
        while(rs.next()) {
            System.out.println(rs.getInt(1));
        }
        System.out.println(cstmt.getInt(1));
        cstmt.close();
        con.close();
    }
}

Output:

1
2
3

Jepski - det var det... (har lige glemt at skrive tilbage - det beklager jeg)

Smid lige et svar så får du pointene..

ok