ibatis插入列表

    <insert id="sendMailFast" parameterClass="java.util.ArrayList">
        insert into mail(sender,reciver,content,type,flag,sendTime,endTime,goodId,msType,msNum) values
        <iterate conjunction=",">
        (#value[].sender#,#value[].reciver#,#value[].content#,#value[].type#,#value[].flag#,#value[].sendTime#,#value[].endTime#,#value[].goodId#,#value[].msType#,#value[].msNum#)
        </iterate>
    </insert>

    <!-- 删除指定邮件 -->
    <delete id="deleteMail" parameterClass="java.util.ArrayList">
        delete from mail where id in
        <iterate conjunction="," open="(" close=")">
            #value[]#
        </iterate>
    </delete>

 

转载于:https://www.cnblogs.com/blackckat-hm/p/3895269.html