<insert id="batchInsert">
INSERT INTO swiping_card_customer
(PosId,PosName,PosCreateId,PosCreateTs,PosUpdateId,PosUpdateTs,
PosTs,respcode,respmsg,signature,agent_num,merno,posno,pos_type,mer_name,
show_legalcerno,show_linkphone,createDate,status
)
value
<foreach collection="list" item="item" index="index" separator=",">
(
#{item.PosId},#{item.PosName},#{item.PosCreateId},#{item.PosCreateTs},#{item.PosUpdateId},
#{item.PosUpdateTs},#{item.PosTs},#{item.respcode},#{item.respmsg},#{item.signature},
#{item.agent_num},#{item.merno},#{item.posno},#{item.pos_type},#{item.mer_name},#{item.show_legalcerno},
#{item.show_linkphone},#{item.createDate},#{item.status}
)
</foreach>
</insert>
只需要在controller接受一个list集合即可
public String batchInsert(@RequestBody List<swipingCardCustomer> list, HttpSession session) {
}