sql和mapper实现批量插入示例

mysql：

insert into t_check_item (id,ext_type,sort_no,result,create_by,create_time,remark) values
('1','',2,'是','admin',sysdate(),''),
('1','',2,'是','admin',sysdate(),'');

mybatis mapper写法：

<insert id="insertCheckItems" parameterType="list">
        insert into t_check_item (id,ext_id,ext_type,sort_no,result,create_by,create_time,remark) values
        <foreach collection="list" item="checkItem" separator=",">
            (#{checkItem.id},#{checkItem.extType},#{checkItem.sortNo},#{checkItem.result},
            #{checkItem.createBy},#{checkItem.createTime},#{checkItem.remark})
        </foreach>
    </insert>

*****//*****//*****//*****//*****//*****

oracle: