<?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>