1、更新类型的存储过程
2、查询类型的存储过程
下面就来看看具体的调用方式&＃xff1a;
1、更新类型的存储过程
sp_InsertAccount&＃xff1a;
CREATE PROCEDURE [dbo].[sp_InsertAccount] -- Add the parameters for the stored procedure here &＃64;Account_ID int, &＃64;Account_FirstName varchar(32), &＃64;Account_LastName varchar(32)ASBEGINinsert into accounts (account_id, account_firstname, account_lastname) values (&＃64;Account_ID,&＃64;Account_FirstName,&＃64;Account_LastName )END <procedure id&＃61;"InsertAccountViaStoreProcedure" parameterMap&＃61;"insert-params_new"> sp_InsertAccount procedure> <parameterMap id&＃61;"insert-params_new" class&＃61;"Account"> <parameter property&＃61;"Id" /> <parameter property&＃61;"FirstName" /> <parameter property&＃61;"LastName" /> parameterMap>这里要注意的就是ParameterMap中的参数个数和顺序要和sp_InsertAccount存储过程中的一致
Ado中的调用代码&＃xff1a;
public void InsertAccountViaStoreProcedure(Account account)
{
try
{ sqlMap.Insert("InsertAccountViaStoreProcedure", account);
} catch (DataAccessException ex) { throw new DataAccessException("Error executing InsertAccountViaStoreProcedure. Cause :" &＃43; ex.Message, ex); }
}这里使用的是sqlMap.Insert的方法&＃xff0c;为了看起来直观一点&＃xff0c;其实使用sqlMap.QueryForObject方法的话效果也是一样的:)
2、查询类型的存储过程
GetAccountByName&＃xff1a;
CREATE PROCEDURE [dbo].[GetAccountByName] &＃64;name varchar(32)ASBEGINselect * from accounts where Account_FirstName like &＃39;%&＃39; &＃43; &＃64;name &＃43; &＃39;%&＃39;ENDMap配置文件&＃xff1a;
<procedure id&＃61;"GetAccountByNameViaStoreProcedure" resultMap&＃61;"account-result" parameterMap&＃61;"selectpro-params"> GetAccountByName procedure> <parameterMap id&＃61;"selectpro-params" class&＃61;"string"> <parameter property&＃61;"name"/> parameterMap>Ado中的调用代码&＃xff1a;
public ArrayList GetAccountByNameViaStoreProcedure(string strName) { try { ArrayList list &＃61; (ArrayList)sqlMap.QueryForList("GetAccountByNameViaStoreProcedure", strName); return list; } catch (DataAccessException ex) { throw new DataAccessException("Error executing SqlAccountViaSqlMapDao.GetAccountById. Cause :" &＃43; ex.Message, ex); } }
京公网安备 11010802041100号