mybatis 批量插入oracle与mysql

mybatis 单个和批量插入mysql与oracle配置说明

1. mysql

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="cn.mysql.Mapper.BlackListMapper">

	<resultMap id="BlackListMap"
		type="cn.mysql.entity.BlackListDO">
		<result property="id" column="id" />
		<result property="uuid" column="uuid" />
		<result property="type" column="tupe" />
		<result property="value" column="value" />
		<result property="deleteFlag" column="delete_flag" />
		<result property="gmtCreate" column="gmt_create" />
		<result property="gmtModified" column="gmt_modified" />
	</resultMap>

	<insert id="insert" parameterType="cn.mysql.entity.BlackListDO">
		insert into
		black_list(uuid,type,value,delete_flag,gmt_create,gmt_modified)
		values
		(#{uuid:VARCHAR},#{type:VARCHAR},#{value:VARCHAR},
		#{deleteFlag:INTEGER},#{gmtCreate:DATE},#{gmtModified:DATE})
	</insert>

	<insert id="insertBatch" parameterType="List">
		insert into black_list
		(uuid,type,value,delete_flag,gmt_create,gmt_modified) values
		<foreach collection="list" item="item" index="index"
			separator=",">
			(#{item.uuid},#{item.type},#{item.value}
			#{item.deleteFlag},#{item.gmtCreate},#{item.gmtModified})
		</foreach>
	</insert>

</mapper>

2. oracle

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="cn.oracle.Mapper.BlackListMapper">

	<resultMap id="BlackListMap"
		type="cn.oracle.entity.BlackListDO">
		<result property="id" column="id" />
		<result property="uuid" column="uuid" />
		<result property="type" column="tupe" />
		<result property="value" column="value" />
		<result property="deleteFlag" column="delete_flag" />
		<result property="gmtCreate" column="gmt_create" />
		<result property="gmtModified" column="gmt_modified" />
	</resultMap>

	<insert id="insert" parameterType="cn.oracle.entity.BlackListDO">
		<selectKey resultType="Long" order="BEFORE" keyProperty="id">
			select seq_black_list.nextval from dual
		</selectKey>
		insert into
		black_list(id,uuid,type,value,delete_flag,gmt_create,gmt_modified)
		values
		(#{id:DECIMAL},#{uuid:VARCHAR},#{type:VARCHAR},#{value:VARCHAR},
		#{deleteFlag:INTEGER},#{gmtCreate:DATE},#{gmtModified:DATE})
	</insert>

	<insert id="insertBatch">
		<selectKey keyProperty="id" resultType="Long" order="BEFORE">
			select seq_black_list.nextval as id from dual
		</selectKey>
		insert into black_list
		(id,uuid,type,value,delete_flag,gmt_create,gmt_modified)
		select seq_black_list.nextval, A.* FROM (
		<foreach collection="list" item="item" index="index"
			separator="union all">
			select
			#{item.uuid,jdbcType=VARCHAR},
			#{item.type,jdbcType=VARCHAR},
			#{item.value,jdbcType=VARCHAR},
			#{item.deleteFlag,jdbcType=INTEGER},
			#{item.gmtCreate,jdbcType=DATE},
			#{item.gmtModified,jdbcType=DATE}
			from
			dual
		</foreach>
		) A
	</insert>

</mapper>

模糊匹配查询

	<select id="queryByParams" resultMap="ResultMap" parameterType="Map">
		select * from table_name
		<where>
			<if test="description!= null">
			   AND description like CONCAT(CONCAT('%', #{description}), '%') 
			</if>
		</where>
	</select>