1. 批量插入:
<insert id="insertBatchItem" parameterType="java.util.List">
insert into item(item_id, create_time, update_time) values
<foreach collection="list" index="index" item="item" separator=",">
(#{item.itemId},#{item.createTime},#{item.updateTime})
</foreach>
</insert>
2. 插入数据返回主键;(formId是实体类的字段)
<insert id="createBaseInfoEntryPage" useGeneratedKeys="true" keyProperty="formId" parameterType="com.lejr.credit.configcenter.dto.ConfigDynamicFormInfoReqDTO">
insert into config_dynamic_form_info (form_id, create_time, update_time)
values (#{formId,jdbcType=BIGINT}, #{createTime,jdbcType=TIMESTAMP}, #{updateTime,jdbcType=TIMESTAMP})
</insert>
3. like模糊查询
<if test="formName!=null and formName!=''">
AND form_name LIKE CONCAT('%',#{formName,jdbcType = VARCHAR},'%')
</if>
4. 取某一个时间段
<if test="filingStarTime != null"> AND update_time <![CDATA[>=]]> #{filingStarTime} </if> <if test="filingEndTime != null"> AND update_time <![CDATA[<=]]> #{filingEndTime} </if>