mybaties 多个参数传参的三种解决方案

阳光穿透心脏的1/2处 2022-08-21 02:11 166阅读 0赞

最近项目要使用mybaties开发，遇到了传参数问题。现在有三种方案可解决：

1.DAO层的函数方法

对应的Mapper.xml

[?][Link 1]

<table style="padding:0px; margin:0px; width:660px; font-family:Consolas,'Bitstream Vera Sans Mono','Courier New',Courier,monospace!important; font-size:1em!important; height:auto!important"> 
 <tbody style="padding:0px; margin:0px"> 
  <tr style="padding:0px; margin:0px"> 
   <td style="padding:0px; margin:0px; font-size:1em!important; font-family:Consolas,'Bitstream Vera Sans Mono','Courier New',Courier,monospace!important; vertical-align:baseline!important; color:rgb(175,175,175)!important"> 
    <div style="padding:0px; margin:0px">
      1 
    </div> 
    <div style="padding:0px; margin:0px">
      2 
    </div> 
    <div style="padding:0px; margin:0px">
      3 
    </div> </td> 
   <td style="padding:0px; margin:0px; font-size:1em!important; font-family:Consolas,'Bitstream Vera Sans Mono','Courier New',Courier,monospace!important; vertical-align:baseline!important"> 
    <div style="padding:0px; margin:0px"> 
     <div style="padding:0px; margin:0px">
       &lt;selectid="selectArea" resultMap="BaseResultMap"&gt; 
     </div> 
     <div style="padding:0px; margin:0px">
       &nbsp;&nbsp;&nbsp;&nbsp;select&nbsp;*&nbsp;from &nbsp;area &nbsp;where areaname like '%{areaname}%' and 
     </div> 
     <div style="padding:0px; margin:0px">
       &nbsp;csmcszm like '%{csmcszm}%' 
     </div> 
     <div style="padding:0px; margin:0px">
       &lt;/select&gt; 
     </div> 
    </div> </td> 
  </tr> 
 </tbody> 
</table>

2.采用Map传参

Public Area selectArea(Map map);

对应的Mapper.xml

<table style="padding:0px; margin:0px; width:1042px; font-family:Consolas,'Bitstream Vera Sans Mono','Courier New',Courier,monospace!important; font-size:1em!important; height:auto!important"> 
 <tbody style="padding:0px; margin:0px"> 
  <tr style="padding:0px; margin:0px"> 
   <td style="padding:0px; margin:0px; font-size:1em!important; font-family:Consolas,'Bitstream Vera Sans Mono','Courier New',Courier,monospace!important; vertical-align:baseline!important; color:rgb(175,175,175)!important"> 
    <div style="padding:0px; margin:0px">
      1 
    </div> 
    <div style="padding:0px; margin:0px">
      2 
    </div> 
    <div style="padding:0px; margin:0px">
      3 
    </div> </td> 
   <td style="padding:0px; margin:0px; font-size:1em!important; font-family:Consolas,'Bitstream Vera Sans Mono','Courier New',Courier,monospace!important; vertical-align:baseline!important"> 
    <div style="padding:0px; margin:0px"> 
     <div style="padding:0px; margin:0px">
       &lt;selectid=" selectArea" resultMap="BaseResultMap" parameterType="java.until.Map"&gt; 
     </div> 
     <div style="padding:0px; margin:0px">
       &nbsp;&nbsp;&nbsp;select&nbsp;*&nbsp;from &nbsp;area &nbsp;where&nbsp; 
      <span style="font-size:18.0180187225342px; color:rgb(51,51,51); line-height:22.5px">areaname like '%{areaname}%' and&nbsp;</span> 
      <span style="font-size:18.0180187225342px; color:rgb(51,51,51); line-height:22.5px">csmcszm like '%{csmcszm}%</span> 
     </div> 
     <div style="padding:0px; margin:0px">
       &lt;/select&gt; 
     </div> 
    </div> </td> 
  </tr> 
 </tbody> 
</table>

Service层调用

<table style="padding:0px; margin:0px; width:613px; font-family:Consolas,'Bitstream Vera Sans Mono','Courier New',Courier,monospace!important; font-size:1em!important; height:auto!important"> 
 <tbody style="padding:0px; margin:0px"> 
  <tr style="padding:0px; margin:0px"> 
   <td style="padding:0px; margin:0px; font-size:1em!important; font-family:Consolas,'Bitstream Vera Sans Mono','Courier New',Courier,monospace!important; vertical-align:baseline!important; color:rgb(175,175,175)!important"> 
    <div style="padding:0px; margin:0px">
      1 
    </div> 
    <div style="padding:0px; margin:0px">
      2 
    </div> 
    <div style="padding:0px; margin:0px">
      3 
    </div> 
    <div style="padding:0px; margin:0px">
      4 
    </div> 
    <div style="padding:0px; margin:0px">
      5 
    </div> </td> 
   <td style="padding:0px; margin:0px; font-size:1em!important; font-family:Consolas,'Bitstream Vera Sans Mono','Courier New',Courier,monospace!important; vertical-align:baseline!important"> 
    <div style="padding:0px; margin:0px"> 
     <div style="padding:0px; margin:0px">
       Private &nbsp;Area SelectUser(){ 
     </div> 
     <div style="padding:0px; margin:0px">
       Map paramMap=new hashMap(); 
     </div> 
     <div style="padding:0px; margin:0px">
       paramMap.put(“areaname”,”对应具体的参数值”); 
     </div> 
     <div style="padding:0px; margin:0px">
       paramMap.put(“csmcszm”,”对应具体的参数值”); 
     </div> 
     <div style="padding:0px; margin:0px">
       Area ares &nbsp;= xxx. selectArea(paramMap);} 
     </div> 
    </div> </td> 
  </tr> 
 </tbody> 
</table>

3.调用函数

Dao层的函数方法

<table style="padding:0px; margin:0px; width:724px; font-family:Consolas,'Bitstream Vera Sans Mono','Courier New',Courier,monospace!important; font-size:1em!important; height:auto!important"> 
 <tbody style="padding:0px; margin:0px"> 
  <tr style="padding:0px; margin:0px"> 
   <td style="padding:0px; margin:0px; font-size:1em!important; font-family:Consolas,'Bitstream Vera Sans Mono','Courier New',Courier,monospace!important; vertical-align:baseline!important; color:rgb(175,175,175)!important"> 
    <div style="padding:0px; margin:0px">
      1 
    </div> </td> 
   <td style="padding:0px; margin:0px; font-size:1em!important; font-family:Consolas,'Bitstream Vera Sans Mono','Courier New',Courier,monospace!important; vertical-align:baseline!important"> 
    <div style="padding:0px; margin:0px"> 
     <div style="padding:0px; margin:0px">
       Public Area selectArea(@param(“areaname”)String areaname,@param(“csmcszm”)String csmcazm); 
     </div> 
    </div> </td> 
  </tr> 
 </tbody> 
</table>

对应的Mapper.xml

<selectid="selectArea" resultMap="BaseResultMap">

select \* from  area  where  areaname like '%\{areaname\}%' and  csmcszm like '%\{csmcszm\}%

</select>

[Link 1]: http://www.2cto.com/database/201409/338155.html#