mybatis 常见问题 - 一泓清波

字符串切割

<if test="monthId !=null and monthId !='' ">
	and month_id in
<foreach item="key" collection="monthId.split(',')" open="(" separator="," close=")" >
	#{key}
	</foreach>
</if>

list循环

#{key}

when otherwise

<if test="repairContent !=null and repairContent !='' ">
			and 
			<foreach item="key" collection="repairContent.split(',')" open="(" separator="or" close=")" >
			 <choose>
                    <when test='key == "NONE" '>
                        f.repair_content is null
                    </when>
                    <otherwise>
	                     f.repair_content =#{key} 
	                </otherwise>
                    </choose>
		   </foreach>
       </if>

key Entity

@MapKey("id")
Map<Long, Entity>  findByIds(@Param("ids") List<Long>  ids);