mysql 动态sql标签

if

        <if test="vo.searchName != null and vo.searchName != ''">
          and    (fault_code like CONCAT('%',#{vo.searchName},'%') or fault_name like CONCAT('%',#{vo.searchName},'%'))
        </if>

if和foreach标签

        <if test=" list != null and list.size > 0">
            and di.type_id in
            <foreach collection="list" item="id" separator="," open="(" close=")">
                #{id}
            </foreach>
        </if>