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

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

 1.DAO层的函数方法 

1	Public Area selectArea(String name,String area);

对应的Mapper.xml  

?

1 2 3

<selectid="selectArea" resultMap="BaseResultMap">     select * from  area  where areaname like '%{areaname}%' and  csmcszm like '%{csmcszm}%' </select>

2.采用Map传参

Public Area selectArea(Map map);

1

对应的Mapper.xml

1 2 3

<selectid=" selectArea" resultMap="BaseResultMap" parameterType="java.until.Map">    select * from  area  where  areaname like '%{areaname}%' and  csmcszm like '%{csmcszm}% </select>

Service层调用

1 2 3 4 5

Private  Area SelectUser(){ Map paramMap=new hashMap(); paramMap.put(“areaname”,”对应具体的参数值”); paramMap.put(“csmcszm”,”对应具体的参数值”); Area ares  = xxx. selectArea(paramMap);}

3.调用函数

Dao层的函数方法

1	Public Area selectArea(@param(“areaname”)String areaname,@param(“csmcszm”)String csmcazm);

对应的Mapper.xml

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

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

</select>