mybatis常用

为什么80%的码农都做不了架构师？>>>   

<if test="listMemberids != null">
            and memberid in
            <foreach collection="listMemberids" index="index" item="item" open="(" separator="," close=")">
                #{item,jdbcType=VARCHAR}
            </foreach>

</if>

<if test="mallname != null and mallname != ''">
                and storename LIKE CONCAT('%',#{mallname,jdbcType=CHAR},'%') 
</if>

<![CDATA[ ORDER BY i.memberid ]]>

转载于:https://my.oschina.net/jj2050/blog/910318