TheOldDriver
9/21/2017 - 2:50 AM

MyBatis-常用操作

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[ <> ]]>
&lt;  < 
&gt;  >  
&amp; & 
&quot;  "
&lt;=   <=
&gt;=   >=