全部是针对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
RETURN @c
END
GO
|
SqlMap:
<
parameterMap
id
=
"pm_in_example"
class
=
"java.util.Map"
>
<
parameter
property
=
"c"
javaType
=
"int"
jdbcType
=
"INTEGER"
mode
=
"OUT"
/>
<
parameter
property
=
"a"
javaType
=
"int"
jdbcType
=
"INTEGER"
/>
<
parameter
property
=
"b"
javaType
=
"int"
jdbcType
=
"INTEGER"
/>
</
parameterMap
|