mybatis动态sql之Map参数的讲解

<mapper namespace= "com.cn.shoje.oa.modules.logistics.dao.purcdao" >

  <select id= "findall" parametertype= "map" resulttype= "purchase" >

  select * from prod_purchase where 1 = 1

  < if test= "purc_id!=''" > and purc_id=#{purc_id}</ if >

  < if test= "prod_id!=''" > and prod_id=#{prod_id}</ if >

  < if test= "ch_id!=''" > and ch_id=#{ch_id}</ if >

  < if test= "ch_name!=''" > and ch_id in ( select ch_id from channel where ch_name

   like '%#{ch_name}%' )</ if >

  < if test= "purc_time!=''" > and purc_time=#{purc_time} order by #{purc_time} desc

  </ if >

  </select>

</mapper>

public map<string,string> parsemap(httpservletrequest req){

  map<string,string> map= new hashmap<string,string>();

  map.put( "prod_id" , prod_id);

  map.put( "purc_id" , purc_id );

  map.put( "ch_name" , ch_name );

  map.put( "ch_id" , ch_id);

  map.put( "purc_time" , purc_time);

  return map;

}

<update id= "publisht00_notice" parametertype= "map" >

update test

set createdate = #{createdate},

creator = #{creator}

where id in

<foreach collection= "ids" item= "ids" separator= "," open= "(" close= ")" >

#{ids}

</foreach>

</update>

hashmap<string,object> map = new hashmap<string, object>();

map.put( "creator" , "creator" );

map.put( "createdate" , "createdate" );

string[] ids = { "1" , "2" };

map.put( "ids" , ids );

list<weixinuserlocationlist> findweixinuserlocations( @param ( "params" ) map<string, object> map);

< if test= "params.accountid!=null" >

       and a.accountid=#{params.accountid}

     </ if >

     < if test= "params.nickname!=null and params.nickname !=''" >

       and a.nickname like '%${params.nickname}%'

     </ if >

     < if test= "params.begindate!=null and params.begindate!=''" >

       and date_format(a.createtime, '%y-%m-%d' )>=${params.begindate}

     </ if >

     < if test= "params.enddate!=null and params.enddate!=''" >

     <![cdata[  and date_format(a.createtime, '%y-%m-%d' )<=${params.enddate} ]]>  

     </ if >