MyBatis日常应用

动态参数查询 ${XXXXX} 普通参数查询#{XXXXX}

 

<insert id="insertBatch" parameterType="java.util.List">
    insert into wy_banktemp(bkareacode, bankmc)
    <foreach close=")" collection="list" index="index" item="lhh" open="(" separator="union all">
      select #{lhh.bkareacode,jdbcType=VARCHAR}, #{lhh.bankmc,jdbcType=VARCHAR} from dual
    </foreach>
  </insert>

 

<update id="updateLhhBatch" parameterType="java.util.List">
    <foreach close=";end;" collection="list" index="index" item="lhh" open="begin" separator=";">
      update WY_LHH
      set BANKMC = #{lhh.bankmc,jdbcType=VARCHAR}
      where BANKLHH = #{lhh.banklhh,jdbcType=VARCHAR}
    </foreach>
  </update>

 

<delete id="deleteBatch" parameterType="java.util.List">
    delete from WY_LHH
    where bankmc in
    <foreach close=")" collection="list" index="index" item="lhh" open="(" separator=",">
      #{lhh.bankmc}
    </foreach>
  </delete>