<sql id="selectCondition">
<if test="storeCode != null and storeCode != '' ">
AND store_code = #{storeCode}
</if>
<if test="saleDates != null and saleDates.size() > 0 ">
AND sale_date in
<foreach collection="saleDates" open="(" close=")" separator="," item="saleDate">
#{saleDate}
</foreach>
</if>
</sql>
<select id="selectBaseEvaluationData" resultMap="storeMainSkuEvaluationResultMap">
SELECT
<include refid="selectField"/>
FROM ${tableName}
<where>
<include refid="selectCondition"/>
</where>
</select>
list集合的查找数据的 sql,当判断 list != ‘ ’ 时,会引起集合与Stirng类型的比较,报错invalid comparison: java.util.ArrayList and java.lang.String
mybatis 查询判空
最新推荐文章于 2023-05-25 20:46:36 发布