在上一篇里面我们知道了什么是IbatisNet,并且知道了如何用IbatisNet进行简单的增删改查的操作,在这一篇文章里面我们主要介绍一下IbatisNet操作存储过程。

我们一般把存储过程分为两种类型:

1,查询类型的存储过程

也就是所谓的select语句

2,修改类型的存储过程

例如,insert,update,delete修改数据库数据的操作。

下面首先我们介绍一下查询类型的存储过程,为了使用我们建一个存储过程(以前很少用过现场百度的…………如果写的不好或者不对欢迎指正)

 create procedure pt_SelectByTj
@classes_name varchar(),
@classes_description varchar()
as
if(@classes_name is not null and @classes_description is not null)
begin
select * from dbo.calsses where classes_name like '%'+@classes_name+'%' and classes_description like '%'+@classes_description+'%';
end
if(@classes_name is not null and @classes_description is null)
begin
select * from dbo.calsses where classes_name like '%'+@classes_name+'%';
end
if(@classes_name is null and @classes_description is not null)
begin
select * from dbo.calsses where classes_description like '%'+@classes_description+'%';
end
if(@classes_name is null and @classes_description is null)
begin
select * from dbo.calsses;
end

查询的存储过程

然后我们要到xml里面去配置,在statements节点下面加一个procedure表示执行的是存储过程。其中parameterMap="swapParas"(swapParas的来历看下面的配置)

是参数类型 resultMap="SelectAllResult"(SelectAllResult的来历看下面的配置)是返回结果

   <statements>
<procedure id="GetClassesListByTj" parameterMap="swapParas" resultMap="SelectAllResult">
pt_SelectByTj
</procedure>
</statements>

代码

我们来看一下如何配置存储过程的参数条件(需要注意的是:这里面的顺序一定要和你在存储过程里面的顺序一样)

   <parameterMaps>
<parameterMap id="swapParas" class="Model.Calsses">
<parameter property="Name" column="classes_name" />
<parameter property="Description" column="classes_description" />
</parameterMap>
</parameterMaps>

代码

简单介绍这些属性的含义

parameterMap节点表示参数的集合,可以是一个实体,也可以是Hashtable,HashMap等数据结构。

parameter节点就是你的参数节点,property是你Hashtable里面的key值,column是你存储过程里面变量的名字,如果key值跟存储过程里面变量的名字相同的话column

可以为空。

下面介绍一下 resultMap="SelectAllResult"中SelectAllResult的来历

   <resultMaps>
<resultMap id="SelectAllResult" class="classes">
<result property="Id" column="calsses_id" />
<result property="Name" column="classes_name" />
<result property="Description" column="classes_description" />
</resultMap>
</resultMaps>

代码

在这里每一张表都对应一个实体,但是有时候我们的实体里面的属性跟我们的数据库字段对应不上,所以我们就在这里配置一下方便后面的使用。

看一下我们service类面的方法还是和以前一样调用

    /// <summary>
/// 根据条件查询全部额班级信息
/// </summary>
/// <param name="ht">参数</param>
/// <returns>查询的结果</returns>
public IList<Calsses> GetClassesListByTj(Hashtable ht)
{
return SqlMap.QueryForList<Calsses>("GetClassesListByTj", ht);
}

代码

下面是aspx.cs里面的方法

 protected void btn_select_Click(object sender, EventArgs e)
{
Hashtable table = new Hashtable();
table.Add("Name", txt_name.Text);
table.Add("Description", txt_name.Text);
gdv_list.DataSource = service.GetClassesListByTj(table);
gdv_list.DataBind();
}

代码

界面如下:

aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAfIAAACfCAIAAACN7sy3AAAbsElEQVR4nO2d3aplV1bH11PkDfIWeQARctnkFRSkQchtohe5UVAErwJ60zZ6FxWkxYsmgoog2N1IJ6L5rqQqlTqnTp2POpVKVcXlRZntYo4x/uM/5lzfa/zYyD5zzTnGmOPjf/bZXd12fZIkSbIjuqUDSJIkScYkZT1JkmRXpKwnSZLsipT1JEmSXZGyniRJsitMWe+SJElo5pStBINkfc445mGXl9oiWYidkQVdFSnryQJkIXZGFnRV1Mg6+TdXxZ9mxRHGQugPw0Wab7p01R0cJmepP59XqwKL9La0Ztlf7dcd64zqsDiyrgolKaPuftUp6H4rTn4Apm6+mdNVHORji54dnUWcyhjmLBbIvHoELC5VNcDa4jk41Kf1aEeq66E+JqcrFEA/V/PNk65iJ5MrKzbm4LjMUwiG2YoVdaTW4rQyT5l4VhVMMrmsq40I+pjcgBfBZrlzdOZJF3jE7wfCMSnrUYGpi9UFsQLDIS3OOqM6LJPIurpBnQF5RG1x15c7JPJS0zFDukhrxaKVIsbXuMzjhWGpYrmOip2gfGtgPZEkfVTWZT/J3rI6D7Q+btwR+3ie5ps6XWADTlHUxXTM7A4wT7Gkfb5q0kLlVadknVEdFkfWZR9jCgvDldARt33rApu6+WZLF9jMhNdXycqIzOzOimGeYhV7QoFZLppvPzIrDOnIjP9pXV1nDsqn7qjgGPClpmOedGEL1gbVLMjtRMzpCzNbsVRHEsbLzMViWFs8Bycg60VfDh/Js27jul3r9n1xlrrtjLI+abrU43xURWw4vVMwmyOXeYrFuChOqY9UI2tgVcEksU/r8kfQ+nKFb0p3cpid6mbgdCxmSxe+uxqDDIZxNDrzeGGYulg4ycBddP+yrCeSpJ9I1qUpVUrwfgts313EoY7C1OmqzokVjHwzNetRgdl6u0iyRbG/MbzZWE8kSV/xJQzoM2khdAS3OxgY4B1cajrmSRd+6q4PN1jvp2OeQjDMVqxo5q0GXk/qhqwzqsPiyLrbuLLPinZX91tHpAUwdc7FjKkgj9cxT7rk8eg6iCqU5GpmcMHEMGex1FMg81YDryF1knVGdVioT+vDxWFrSqz96nHLb8iF5c6KBxwfndnSxeeK8TsDM7tjmLpYrv3hQbeOa2MTQR6HgKxHO0xt0+LHwqDcUzxyA8DDMGfzzZAu4IVcX0o71qYCkxarWHFLA2qkUnXjkVlJGMlLWFmvbqCoHrUDLM/WfKtNl7SziDSsSgVmKNZ69Hci9n27zRH7Embr7PJSWyQLsTOyoKsiZT1ZgCzEzsiCrgrnn1gkSZIwzClbCSY/rScLkIXYGVnQVZGynixAFmJnZEFXRcr6VKYqfLWE14l/etHiqz1RU9tfOdUXPH2hwXzLIRenS+zBC7otDi3rjV8Uuo0+uk28efij69H9NcDkChyx3lsr+yOUQHUFWFNtql5a4nfB4SVLcXRZZ7adFvlGl29UI6RrNyr1PR9/cVZaU2+E4+mEZpHX3A0VCQRCaW2WR8bNLQ4SLyZLEfivI00fzOSQlxqxcYFHKXyq1OLfBFg4yMCY+zLBqDGoUQ0XpUHLeB28NSnELZFUJBAUxW0kt6DVMJbH9Zg04st6Y3OvCjwqeL2Q2uKRVCV1hismxJJFEj0Rwd8B6n5Gtqx43EKQUZGR89aKzeOGAd7gVumNzqkrPRMqjwwvWZyjf1rnR0LOFTM/xQbrPVhUJ4cpR7Gfn1L1XjKMaIeA+MGtQ7R3KagX77cugb1XslAY7akIMbO7BHNoWa8+y8/PSShPP4JBxQpuPbWkOXQj96nlSMbGxLNmWe+NVEf9hhJ42hCNFhAypd6CN96e+WREjivreCRA43a2hGF3bmwdVECmBGSZmLG3NuCD5MC73XVKBdYadVFdV2OQR4oSWC5cv9bF8fqwB1SwKVAayyB2wV8BuE7m57iyzj8abiAbum4+8eiSEbpEJYNXATUGKz/uKfXi+GC1DElfRbkr/IYSOHQH7kveYixa6p4sSMq6/6jYEMpMSNTkVFt+sVJY42fNpBqntc29rysB4I7kBnBBKyp3pVgvauEmlnHa2wlUSw/itKJyMx+iPZ/JIhxR1t1hUAejGHi5Djwyi6oLNYCQr16oORmStULqRSgtrncrD2QtgMLiKuOkufbVFZlAte5RmQZmq2HmYixfyYgcUdatdXJshsPJtDs/n3ha3BKQNQoNaqcpjhWqixWqKxMyDNIOXsf2hzFjC+rTaALVRb6mcjN5lqQiA8lSpKxT0jmcyVAqyOlV16MlCEmAu2iJGpmKkApUeCftAPvqj6SsM34rElgh66oX8JuDwf31PISMM5kTfyzVKm4UZmzUa1YPTLWsy/fzy7r6iJxk8qnVXacrWwWyelLaseyr2qSGIY+oNyITBRLIrFihymjVg9W0lDuZmcpPWxtFTqm1rZh26ziWGH4bcGStyKdkyUIhgSAZm5aXXXYXCbj7qY5uAqOW21nQdRLliLLOqFhUWHk71aYqHPE7G49H2WV3kbiyPoXldlLWN8QRZT1ZnCzEzsiCroqU9WQBshA7Iwu6KpCsJ0mSkMwpWwkmP60nC5CF2BlZ0FWRsp4sQBZiZ2RBV0XK+lSmKny1hFecbQyvPVFT21851Rc8faHBfMshF6dL7MELui0OLeuNXxS6jT66Tbx5+KPr0f01wOQKHLHeWyv7I5RAdQVYU22qXipCBQGD+BlHyTwcXdaZbadFvtHlG9UI6dqNSn3Px1+cldbUG+F4OqFZ5DV3Q0UCgVBam+UR0NVM64KQrBXgNFkESkTc2m8FUlxGbFzg0cpwIbV49rBwkIEx9yWFAIiXFao0OG6n8daKnY09X5FAUBS3kdyCVsNYHtdj0ogv67i9tgV5FyBY6kCqqqTOcMWEWLJIoici+DtA3c/IlhWPWwgyKjJy3lqxedwwwBvcKr3ROXWlZ0LlkeEli3N0WedHQs4VMz/FBus9WFQLwVSh2M9PqXovGUa0MUD84NYh2psT1Iv3W5fA3itZKIz2VISY2V2Cob6EwYsboiX+kDoXT4eTDAYVK7j11JLm0I3cp5YjGRsTz5plvTdSHfUbSuBpQzRaQMhU1L7c2e4uGQtW1sdqlGXpPEFkGrezJQy7c2ProAIy+SdrxFTT2oAPkgNv3bFYsbIqE24VwiqNdaQogeXC9WtdHK8Pe0AFmyKrz8NfYXTXSQv5ad1/NNzAy1bFfOLRJSN0iUqGtZ8RGisqV4+GxodP8cFqGZK+inJX+A0lcOgO3Je8xVi01D1ZkLDMbbp+IHj3XuSEM2axpriK0xN/aqjjZ82kGqe1zb2vKwHgjuQGcEErKnelWC9q4SaWcdrbCVRLD+K0onIzH6I9n8kiHFHW3WFQB6MYeLkOPDKLqgs1gJCvXqg5GZK1QupFKC2udysPZC2AwuIq46S59tUVmUC17lGZBmarYeZiLF/JiPiyPnqvLAgee3JshsPJtDs/n3ha3MyTpQkNqmwDK1dAAqQLt6msDfggn1hrQxGk5ZexH02gusjXVG4mz5L7W54mMxOT9a0Xz50lVxeAKNd5BOvRKQ1JgLtoiRqZipAKVHgn7QD76o+krDN+KxJYIeuqF6nyzu/bAaHNVn6SZaHGsijhdmHGRr0pGJioR3BcHX7eKRkVGZI1seQkk09VjegHV7YKpJ6SR4B9VZvUMOQR9UZkokACmRUrVBmterCalnInM1P5aWujyCm1thXTbh3HEsNvA46sFfmULFkoJBAkY9PyssvuIgF3P9XRTWDUcjsLuk6iHFHWGRWLCitvp9pUhSN+Z+PxKLvsLhJX1qew3E7K+oY4oqwni5OF2BlZ0FWRsp4sQBZiZ2RBVwWS9SRJEpI5ZSvB5Kf1ZAGyEDsjC7oqUtaTBchC7Iws6KpIWZ/KVIWvlvCKs43htSdqavsrp/qCpy80mG855OJ0iT14QbfFoWW98YtCt9FHt4k3D390Pbq/BphcgSPWe2tlf4QSqK4Aa6pN1UtL/C44vGQpji7rzLbTIt/o8o1qhHTtRqW+5+Mvzkpr6o1wPJ3QLPKau6EigUAorc3ySHv3Mn6ZxWQpwiIyZTCTQ4rLiHcHHqXwqVKLBw8LBxkYc9+oCmAVGy5Kg5bxOnhrxU5wTdKaNF5RTffHU7dYmxthLI/rMWkkIOvjDtsi4FHB64XUFo+kKqkzXDEhliyS6IkI/g5Q9zOyZcXjFoKMioyct1ZsHjcM8Aa3Sm90Tl3pmVB5ZHjJ4rCyrrba5pCX4kdCzhUzP8UG6z1YVCeHKUSxn59S9V4yDGsDGQ8+W9dp7f0J6sX7rUtg75UsFEZ7KkLM7C7BULIOGnFbtMQfUufi6TCBYFCxgltPLWkO3ch9ajmSsTHx4B/J+N2Yqy1EG17dFkrgaUM0WkDIVNS+3NnuLhmL48o6HgnQuJ0tYdidG1sHFZBJPlkgZuytDfggOfDWHYsVK6sy4VYhrNJYR4oSWC5cv9bF8fqwB1SwKbc0mFCo5M5kEXxZL5p48oimBMTvXq0YeHywbj7x6JIRukQlI6QFfH7cU0wHunbIqKSvotwVfkMJHLoD9yVvMRYtdU8WJGXdf1RsCM1SSNTkVFt+sVJY42fNpBqntc29rysB4I7kBnBBKyp3pVgvauEmlnHa2wlUSw/itKJyMx+iPZ/JIlCyPm6vLMhpeHiKsz0hSe5TUlOKnW7mgdnhXciQrBWyB0Jpcb1beSBrYV3ZrTJOmmtfXZEJVOuOu9G6jhtVCGYuxvKVjEjs0+vWi4fHnhyb4XAy7c7PJ54WN/lkdUKD2mmKY4XqYoXqyoQMg7SD17H9YczYgvo0mkB1ka+p3EyeJanIQLIUKeuUdA5nMpSEUBrrNIvfEArJEjUyFSEVqPBO2gH21R9JWWf8ViSwQtZVL+A3B4P763kIGWcyJ+xYykJuEWZs1DtWD0y1rMv388u6+oicZPKpqhH94MpWgayGlHYs+6o2qWHII+qNyESBBDIrVqgyWnW/i+oORMI8TWamsoobRU6pta2Yduu4OxWh4QkNvHxKliw6z0wktGjkhzt091Md3QRGLbezoOskyhFlnVGxqLDydqpNVTjidzYej7LL7iJxZX0Ky+2krG+II8p6sjhZiJ2RBV0VKevJAmQhdkYWdFUgWU+SJCGZU7YSTH5aTxYgC7EzsqCrImU9WYAsxM7Igq6KlPWpTFX4agmvONsYXnuipra/cqovePpCg/mWQy5Ol9iDF3RbHFrWG78odBt9dJt48/BH16P7a4DJFThivbdW9kcogeoKsKbaVL0A77igof1qeMlSHF3WmW2nRb7R5RvVCOnajUp9z8dfnJXW1BvheDqhWeQ1d0NFAoFQWpvlEbevQHPig6FtyYL4ImIp1xYhxWXExgUepfCpUouTz4yrGxhzXyYYNQY1Kqu7hovuFUh4a8XOxoavSCAoittIuKBMn1g3dVsFrCeLQMn6XMFMTkUfF4vqQKqqpM5wxYRYskiiJyJeX7mfkS0rHrcQZFRk5Ly1YvO4YYA3uFV6o3P40lvHrQh5VFPJshxd1pmRkGdPg2dtLlwAIzjC3igEU5RiPz+l6r1kGNYGMh58tq7r2nsV1Iv3W5fA3itZKAyQ4eoKkq6TxTm0rFef5Sf/JJSnH8GgYgW3nlrSHLqR+9RyJGNj4nEFpa5S7b0q61XtN5TA04ZotAArGOt2ahUY4+rZZEFYWa/ouRXSeYLING5nSxh258bWQQVk8k/WiKmmtQEfJAeeERQrTjXhViGs0lhHihJYLly/1sXx+rAHVLApUBq1FckqMFcgGy+ZB0rWrT7YHGTfgw28bFXMJx5dMkKXqGRY+xmhsaJiBEW9OD5YLUPSV1HuCr+hBA7dgfuSt8DB8Mdb6p4sSFjmNl0/pu/dDfwsWU+xpriK0xN/aqjjZ82kGqe1zb2vKwHgjuQGcEErKnelWC9q4SaWcdrbCVRLD+K0orKC7LQukhZI79E4k5k5oqy7wxAdDNcjs6i6UAMI+eqFmpMhWSuWMJHBqE9d71YeyFpYV3arjJPm2ldXZALVuuNutK5jBVBch7wFMxfW2WRBYn+1yR+3BR57cmyGw8m0Oz+feFrczJOlCQ2qbAMrV0ACpAu3qawN+CCfWGtDEaTll7EfTaC6yNdUbrbugo1M8TSZmZisb7147iy5usCMR8gjWCc1i98QCskSNTIVIRWo8E7aAfbVH0lZZ/xWJLBC1lUvUuWZ3igCI+HtJ7NBjWVRwu3CjI16UzAwUY/guDWHpNPRZV19RE4y+VTViH5wZatA6il5BNhXtUkNQx5Rb0QmCiSQWbFCldGq+zGqLxwJ8zSZmcpPWxtFTqm1rZh267g7GKH5CQ28fEqWrGKk3UhI1QAXPA7g7qc6ugmss1wdWOPTZGaOKOuMikWFlbdTbarCEb+z8XiUXXYXSaP41lluJ2V9QxxR1pPFyULsjCzoqkhZTxYgC7EzsqCrAsl6kiQJyZyylWDy03qyAFmInZEFXRUp68kCZCF2RhZ0VaSsT2WqwldLeMXZxvDaEzW1/ZVTfcHTFxrMtxxycbrEHryg2+LQst74RaHb6KPbxJuHP7oe3V8DTK7AEeu9tbI/QglUV4A11abqBXh3q8kfOUJBN8TRZZ3ZdlrkG12+UY2Qrt2o1Pd8/MVZaU29EY6nE5pFXnM3VCQQCKW1WR5hcsvnHwdZYTCZAVZEgBJtCFJcRmxc4FEKnyq1+DcBFg4yMOa+TDBqDGpUw0VpcNxO461JIW6JpCKBoChuI7kFBdb4zdbBEeuVtEPJekgv1gweFbxeSG3xSKqSOsMVE2LJIomeiHhN5X5Gtqx43EKQUZGR89aKzeOGAd7gVumNzqkrvTQun/IwBpOZGW3sN4EcFX4k5FyR86MOpAzGWlQLwRSl2M9PqXovGYa1gYwHn63ruvZeBfXi/dYlsPdKFgrDbUvXWojRDSYtHFrWq89G52eYTDCoWMGtp5Y0h27kPrUcydiYePCPZPxuzNUWos2vbgsl8LQhGi2ADBjs5I23Zz4ZEVbWK3puhXSeIDKN29kSht25sXVQAZn8kzViqmlt4PUC7LfuWKxYWZUJtwphlcY6UpTAcuH6tS6O14c9oIJNuaUBREMldyaLQMm62uVbBMTvXq0YeHywbj7x6JIRukQlIyQHfH7cU+rF8cFqGZK+inJX+A0lcOgO3Je8BYY/1VL3ZEHYT+tyfYvgDibPhhISEjU51ZZfrBTW+FkzqcZpbXPv60oAuCO5AVzQispdKdaLWriJZZz2dgLV0oM4rajczEubwEV7PpNFOKKsu8OgDkZdQviBV12oAYR89ULNyZCsFaAXTDDqU9e7lQeyFkBhcZVx0lz76opMoFp33I3Wddyo5Dowy8yFaySZnyPKurVOjs1wOJl25+cTT4ubebI0oUGVbWDlCkiAdOE2lbUBH+QTa20ogrT8MvajCVQX+ZrKzWQ2Qi7qniYzQ/39RTb3+nFnyZ0EIMp1HsF6dPxa5tOSafmUTEVIBSq8k3aAffVHUtYZvxUJrJB11Qv4zQGCLwIjIeNM5oQdy6icrRNmbNSbkgPDeATHLf0inY4u6+ojcpLJp6pG9IMrWwVST8kjwL6qTWoY8oh6IzJRIIHMihWqjFaN3EV1ByJhniYzU1nFjSJ73dpWTLt13J2K0PCEBl4+JUsWnWcmElo08sMduvupjm4Co5bbWdB1EuWIss6oWFRYeTvVpioc8Tsbj0fZZXeRuLI+heV2UtY3xBFlPVmcLMTOyIKuipT1ZAGyEDsjC7oqkKwnSZKQzClbCSaLkSRJQvHixfPbm6vry/OrR2eNr7P7dypep+PXl+c3Vxe3N1cvXjyXcW5e1n/vz/8hX/t4Ld1KrSyewHyN9bJKfHtzdf3o/lvvvvfqG+90r7254OuV19/+7T/86ePrs2fffSvjnOTfPwz/KJv6rzNQg2RDMHUsemn4I3jErI9CtuI+AHW8ubp46933fvTWT/7xl5/MGZLkg8/u/+itn7z97l83fVpn5kH9li1lPWEYV9bVldPiRD2ZrbgPsKy/+sY77//i4/9Znu/f/8VHr77xjhpnQNbJ/5xEzt6k/+lKztI+mELWgdZPoezZivsA1PH68rx77c3vv3/x/fcvXrx48eLF86Vez58/e/L4unvtTTXOMf/r5uo6+TGqmpylfQDqKD8TMP8eI9S0o5CtuA/wp/XutTefPXv27Nl3/KvrOnfd2mO8nt4+vr68eFAv6+R4qAMmPxyNPlc5S/tg9E/rw0f835otZCvuA1fWnz799unTJ9YL9NuJ4ebiDfP69tvbm6uLhw/uVcq6KsfuCOHj45KztA94WY/25HBPflpPXFxZf/Lk8ZMnj588uWFeJykntw2xNt/eXl9dnp3dv1Mj6+qHIzwYw8mJTl0dOUv7gJR1Xr6t7s1WTDCErL+U12v31XVd8X/BNmbx5ev29urq8sHZ/S+avlv//93c/46gFPTpxilnaR+EvoQBf97KzcMfmY8m1WQr7gNC1q9vb69vb6/wq+s6683L9yfkj8Xm4vX48eXlo28efP15q6wzuqxOztTjlLO0D9w6Mn8Iuu9VC2ORrbgPXFk/aav1Ah87XjLc6b6Rr5ubR48u7n9zr0HWcXzDbcWbfjCK1jgxvy0wOUv7wP2XMD3xrTrTkOr7Plsx+QFX1k/ail9d1/ErQ1G1Np9e19cXFw+/vn/3s7CsD4Xband1PfQpKWcpeclEX8LIflPf99mKyQ8Qsv7o8eNHNzcX+KX2p9zjvpGv6+uHFw/v3b/76fj/bt1aj35KaiRnaR9EZV0ugvd4cSyyFfeBK+snbcWvruv4FfBGvq6uzh+e3/36q0/mlnXyU1J+REpesrisZysmL3Fl/fr64vr64urqIX6pn9bVPcXm0yPL8uXl+fnZ3XtfNsu6+zfvcDO52OcsJT8w7pcwp88WfHdlKyYvIWT9/z4yt7+6rqt4dHl5dn721b0vP17gS5jhj40DA8hZ2ge4jkUX4YaUHRj6XFJNtuI+cGX9pK3qC/fbS6yzQwtgw6NH35w9+PLunY/G+XfrDHJUptP0PmdpLzD/wHGeSKrJVtwHrqxfXp5dXj5Y8PXo4v6D+198dee/5pP1mclZ2gc7qOMOrpD0hKyfn907O7t7dnb3/Ozu+dm9mV9nZ3e/uf/FV3f++/NPfp2ynqyaHdRxB1dIeljHx9ePXnn97ff/9d/ufPbh55/++otPP7jz2Yczv7749IPPPv6Pj/7z33/285+/8vrbapwp68kq2EEdd3CFpId1/Pb25rf+4Ke/+bt/+hfv/d2Hv/qXRV4f/OqfP/jlP/3t3//sN378J7/zR3+pxrkHWc/XPl5Lt1IriycwX2O9rBI/f/7su6c3v/9nf7OG/1+mP/7jv3r27FaNc/OyniRJkgxJWU+SJNkVKetJkiS7ImU9SZJkV/wvijHoWfva56EAAAAASUVORK5CYII=" alt="" />

好了,对于存储过程就先到这儿,这里面只写了一个查询的小例子,关于增删改的例子,就请读者自己去实现了,边学边练习才能学的更深入。

由于我也是初学者,如果文章中有什么不对或者遗漏的地方,欢迎大家指正………………

关于Ibatisnet的简单操作可以参照我的上一篇博客 跟初学者学习IbatisNet第一篇

本来还想在这一篇里面介绍一下Log4net呢,后来一想,还是留在下一篇来单独介绍一下如何用log4net记录日志吧。

源码下载:http://download.csdn.net/detail/woaixiaozhi/5826535

最新文章

  1. 谈谈JS的观察者模式(自定义事件)
  2. PHP+Mysql+jQuery实现地图区域数据统计-展示数据
  3. 【转】 Nginx深入详解之多进程网络模型
  4. oracle查询锁和杀锁
  5. [zz] pgpool-II load balancing from FAQ
  6. Jquery获得控件值的方法
  7. Webservice学习之——即时发布与定制发布
  8. hdu 4751
  9. Sql Server使用技巧
  10. Node.JS + MongoDB技术浅谈
  11. NOIP2012模拟试题【圆圈舞蹈( circle)
  12. point类型&#183;
  13. Git Compare with base,比较大文件时,长时间等待,无法加载
  14. docker container 互联
  15. Confluence 6 Windows 中以服务方式自动重启的原因
  16. JAVA第三周学习总结
  17. 【论文笔记】Zero-shot Recognition via semantic embeddings and knowledege graphs
  18. 八、springboot(五)配置定时器
  19. 将Spring-boot应用部署到Docker容器
  20. 【jmeter】jmeter 压力测试

热门文章

  1. Eclipse的ant调用maven
  2. Coursera:一流大学免费在线课程平台
  3. python实战之爬取喜玛拉雅专辑信息
  4. 开发原生安卓cordova插件(有原生界面)
  5. python pandas 中 loc &amp; iloc 用法区别
  6. Implicit Animations 默认动画 读书笔记
  7. Thrift入门及Java实例演示【转】
  8. Chrome开发者工具关于网络请求的一个隐藏技能
  9. svn批处理语句
  10. uva1608 Non-boring sequences