Mybatis+Oracle --批量插入

触发器：

CREATE OR REPLACE TRIGGER TRIGGER_ROLE_OBJECT 
BEFORE INSERT ON SYS_RIGHT_ROLE_OBJECT FOR EACH ROW
BEGIN
  SELECT ROLE_OBJECT_SEQ.nextval into :new.ROLE_OBJECT_ID from dual;
END;

Mybatis ：

    <insert id="insertSelectiveByList" parameterType="java.util.List">
        insert into
        SYS_RIGHT_ROLE_OBJECT (ROLE_CODE,
        OBJECT_CODE,
        POLICY_ID, PERMISSION)
        <foreach collection="list" item="item" index="index"  open="(" close=")" separator="UNION ALL">
            SELECT #{item.roleCode} AS ROLE_CODE,
            #{item.objectCode} AS OBJECT_CODE,
            #{item.policyId} AS POLICY_ID, #{item.permission} AS PERMISSION  FROM dual
        </foreach>
    </insert>

Mybatis+Oracle --批量插入

标签：bsp   .net   details   creat   数据库   order   oracle数据库   mission   log