全部是针对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 |
版权声明:本文为fy_kenny原创文章,遵循 CC 4.0 BY-SA 版权协议,转载请附上原文出处链接和本声明。