Create Procedure [DBO]. [Sp_insertstudent] (@ Name Char (10), @ Age int, @ id int output) Asinsert Into Students ([Name], [AGE]) VALUES (@ Name, @ agn) select @ id = @@ identity - Test output parameter Return 30 - Test Returns 30GO
??? Try {????? pstmt = con.prepareCall ("{? = call sp_insertstudent (?,?,?)}"); ????? pstmt.setstring (2, "zengqingsong");? ???? pstmt.setint (3, 22);
????? pstmt.registeroutparameter (4, types.integer); ????? pstmt.registeroutparameter (1, types.integer); ????? int REGER); ????? int REGER); // Execute Row number
????? int RET2 = PSTMT.GETINT (1); // Return parameter (output parameter) ????? int ID = PSTMT.GETINT (4); // Output parameter ????? system.out .println (re); ????? system.out.println (RET2); ????? system.out.println (id); ???}