mysql,mybatis常用小知识点

1：模糊查询sql注入

<if test="changeObj != null" >
      AND change_obj like '%${changeObj}%'
    </if>

2：日期时间段查询

<if test="startDate != null">
      and  #{startDate} <![CDATA[ <= ]]> create_date
    </if>

    <if test="endDate  != null">
      and create_date <![CDATA[ <= ]]> #{endDate }
    </if>

3：遍历

<delete id="delByTableIds" parameterType="java.util.List">
    DELETE FROM meta_log WHERE table_id IN
    (
    <foreach collection="list" item="item" index="index"  separator="," >
      #{item.tableId,jdbcType=INTEGER}
    </foreach>
    )
  </delete>