ibatis批量处理

唯一键没有则插入有则更新（批量插入）0

<insert id="insertPos" parameterClass="map">
    INSERT INTO HBT_OperationPower
    (LoginNumber,PowerID,Valid,OperationName,Email,UpdateTime)
    VALUES
    <iterate property="operationPowerPOs" conjunction=",">
        (#operationPowerPOs[].loginNumber#,
        #operationPowerPOs[].powerId#,
        #operationPowerPOs[].valid#,
        #operationPowerPOs[].name#,
        #operationPowerPOs[].email#,
        NOW())
    </iterate>
    ON DUPLICATE KEY UPDATE Valid = VALUES(Valid)
</insert>

唯一键有则忽略，没有则插入

<!--插入运营人员数据-->
<insert id="insert" parameterClass="map">
    <![CDATA[
    INSERT IGNORE INTO HBT_OperationPower
    (
    LoginNumber,
    PowerID,
    Valid,
    OperationName,
    Email,
    UpdateTime
    )
    VALUES(
    #hbtOperationPower.loginNumber#,
    #hbtOperationPower.powerId#,
    #hbtOperationPower.valid#,
    #hbtOperationPower.name#,
    #hbtOperationPower.email#,
    #hbtOperationPower.updateTime#)
    ]]>
    <selectKey resultClass="java.lang.Integer" keyProperty="id">
        SELECT @@IDENTITY AS id
    </selectKey>
    ON DUPLICATE KEY UPDATE Valid = VALUES(Valid)
</insert>