MyBatis常用SQL
<!--批量更新同一个字段-->
<update id="updatePayStatusBatch" parameterType="java.util.List">
update sdb_ome_gasstation_settlement set status='payed'
where settlement_bn in
<foreach separator="," index="index" item="item" collection="list" close=")" open="(">
#{item}
</foreach>
</update>
<select id="selectIdByVariantOption" parameterType="java.util.Map" resultType="java.lang.Long">
SELECT
variant_id
FROM
( SELECT * FROM variant_option_value_variants t2 WHERE t2.variant_option_value_id IN
<foreach separator="," index="index" item="item" collection="templist" close=")" open="(">
#{item}
</foreach> ) t3
GROUP BY
t3.variant_id
HAVING
count( t3.variant_id ) >= #{variantOptionCounts}
</select>
<insert id="insert" parameterType="" useGeneratedKeys="true" keyProperty="settlementId" >
新增SQL语句
</insert>
<!--不等于标准写法-->
<![CDATA[ <> ]]>
< <
> >
& &
" "
<= <=
>= >=