mapper.xml
<!-- 批量插入 -->
<insert id="insertSalesChannel" parameterType="java.util.List">
insert into saleschannel(userid,screenname,referralcode,statisticsDate,visitCount,payCount,modifyTime)
values
<foreach collection="list" item="item" index="index" separator=",">
( #{item.userid},#{item.screenname},#{item.referralcode},#{item.statisticsDate},#{item.visitCount},#{item.payCount},#{item.modifyTime} )
</foreach>
</insert>
mappser.java
public Integer insertSalesChannel(List<Map<String, Object>> userList) throws Exception;
serviceImp.java
@Override
public Integer insertSalesChannel(List<Map<String, Object>> userList) throws Exception {
// TODO Auto-generated method stub
return mapper.insertSalesChannel(userList);
}
service.java
public Integer insertSalesChannel(List<Map<String, Object>> userList) throws Exception;