mybatis 批量插入oracle与mysql

来源：互联网发布：网络错误怎么办编辑：程序博客网时间：2024/05/22 02:19

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 intoblack_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 intoblack_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}fromdual</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>

0 0