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

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

1.DAO层的函数方法

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

对应的Mapper.xml

         <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

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

Service层调用

         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> 
  