ibatis与存储过程(带输出参数的存储过程)
采集日期:2008-4-30作者:fy_kenny(注:本数据由系统自动采集,内容与BHCODE无关)
全部是针对Microsoft SQL Server 2000的Stored Procedure的例子:
参照《iBATIS in Action》书写:
1. max_in_example
Stored Procedure:
CREATE PROCEDURE [dbo].[max_in_example]
@a INTEGER = 0 OUTPUT,
@b INTEGER = 0 OUTPUT,
@c INTEGER = 0 OUTPUT
AS
BEGIN
IF (@a > @b)
SET @c = @a
ELSE
SET @c = @b