其实调用方式比较简单,主要也就是两种类型的存储过程:
1、更新类型的存储过程
2、查询类型的存储过程
下面就来看看具体的调用方式:
1、更新类型的存储过程
sp_InsertAccount:
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
CREATE PROCEDURE [dbo].[sp_InsertAccount]
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
-- Add the parameters for the stored procedure here
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
@Account_ID int,
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
@Account_FirstName varchar(32),
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
@Account_LastName varchar(32)AS
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
BEGIN
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
insert into accounts (account_id, account_firstname, account_lastname)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
values (@Account_ID,@Account_FirstName,@Account_LastName )
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
END
Map配置文件:
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
<procedure id="InsertAccountViaStoreProcedure" parameterMap="insert-params_new">
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
sp_InsertAccount
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
</procedure>
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
<parameterMap id="insert-params_new" class="Account">
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
<parameter property="Id" />
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
<parameter property="FirstName" />
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
<parameter property="LastName" />
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
</parameterMap>
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
这里要注意的就是ParameterMap中的参数个数和顺序要和sp_InsertAccount存储过程中的一致
Ado中的调用代码:
这里使用的是sqlMap.Insert的方法,为了看起来直观一点,其实使用sqlMap.QueryForObject方法的话效果也是一样的:)
2、查询类型的存储过程
GetAccountByName:
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
CREATE PROCEDURE [dbo].[GetAccountByName]
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
@name varchar(32)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
AS
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
BEGIN
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
select * from accounts where Account_FirstName like '%' + @name + '%'
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
END
Map配置文件:
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
<procedure id="GetAccountByNameViaStoreProcedure" resultMap="account-result" parameterMap="selectpro-params">
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
GetAccountByName
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
</procedure>
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
<parameterMap id="selectpro-params" class="string">
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
<parameter property="name"/>
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
</parameterMap>
这里parameterMap也是和上面的要求一样,至于property的名字在这里没有实际作用,可以任意取名的
Ado中的调用代码:
http://www.cnblogs.com/firstyi/archive/2008/01/25/1053208.html