mybatis向oracle中添加list xml写法

<?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="transData.mapper.dao.destEmplyMapper" >

<resultMap id="BaseResultMap" type="transData.mapper.show.destEmply" >

<result column="SCHCODE" property="schCode"/>

<result column="SNO" property="sno"/>

<result column="NAME" property="name"/>

<result column="SEX" property="sex"/>

<result column="PIDCODE" property="pidCode"/>

<result column="AREACODE" property="areaCode"/>

<result column="DEPTCODE" property="deptCode"/>

<result column="MOBILE" property="mobile"/>

<result column="CLASS" property="CLASS"/>

<result column="NO" property="no"/>

<result column="OPENFLAG" property="openFlag"/>

</resultMap>

<insert id="creatNewEmply" parameterType="java.util.List">

INSERT INTO

PB_IDINFORMATION

(NO,SCHCODE,SNO,NAME,SEX,PIDCODE,AREACODE,DEPTCODE,MOBILE,CLASS,OPENFLAG)

 

select

lpad(PB_IDIFATION.nextval,12,'0'),

A.*

from

(

<foreach item="item" collection="emplyList" separator="union" index="index">

select

#{item.schCode},

#{item.sno},

#{item.name},

#{item.sex},

#{item.pidCode},

#{item.areaCode},

#{item.deptCode},

#{item.mobile},

#{item.CLASS},

#{item.openFlag}

from dual

</foreach>

)A

</insert>

<insert id="creatOne" parameterType="transData.mapper.show.destEmply">

INSERT INTO

PB_IDINFORMATION

(SCHCODE,SNO,NAME,SEX,PIDCODE,AREACODE,DEPTCODE,MOBILE,CLASS,NO,OPENFLAG)

VALUES

(#{schCode},#{sno},#{name},#{sex},#{pidCode},#{areaCode},#{deptCode},#{mobile},#{CLASS},lpad(PB_IDIFATION.nextval,12,'0'),#{openFlag})

</insert>

</mapper>