<insert id="insertSelectivelist">
insert into LOGIN_SU (
IDKEY,
LOGIN_NAME,
PHONE_NUM ,
IDENTITY,
USER_STATUS,
IP_ADDR,
SEX,
USER_NAME,
USER_PWD,
INST_ID,
CREATE_BY,
CREATE_TIME,
CREATE_NAME,
UPDATE_NAME,
UPDATE_BY,
UPDATE_TIME,
PWD_UPDATE_TIME,
ATTR_1,
ATTR_2,
ATTR_3
)
select a.* from(
<foreach collection="list" item="item" index="index" close=")" open="(" separator="union">
SELECT
#{item.idkey,jdbcType=VARCHAR},
#{item.loginName,jdbcType=VARCHAR},
#{item.phoneNum,jdbcType=VARCHAR},
#{item.identity,jdbcType=VARCHAR},
#{item.userStatus,jdbcType=VARCHAR},
#{item.ipAddr,jdbcType=VARCHAR},
#{item.sex,jdbcType=VARCHAR},
#{item.userName,jdbcType=VARCHAR},
#{item.userPwd,jdbcType=VARCHAR},
#{item.instId,jdbcType=VARCHAR},
#{item.createBy,jdbcType=VARCHAR},
#{item.createTime,jdbcType=DATE},
#{item.createName,jdbcType=VARCHAR},
#{item.updateName,jdbcType=VARCHAR},
#{item.updateBy,jdbcType=VARCHAR},
#{item.updateTime,jdbcType=DATE},
#{item.pwd_update_time,jdbcType=DATE},
#{item.attr1,jdbcType=VARCHAR},
#{item.attr2,jdbcType=VARCHAR},
#{item.attr3,jdbcType=VARCHAR}
FROM DUAL
</foreach>
) a
</insert>