mybatis中批量插入、批量更新

一、mapper.xml中批量插入

<insert id="batchInsert">
    INSERT INTO t_order(order_no, member_id, member_name, member_phone, pay_amt, create_time)
    VALUES
    <foreach collection="list" item="e" separator=",">
        (#{
   e.orderNo},#{
   e.memberId