批量添加数据库数据:
Mapper方法:
int batchInsert(List<Account> accountList);
Sql:
<insert id="batchInsert" parameterType="java.util.List">
insert into tb_account(account_no, account_name, account_province, account_city, account_district, account_address, create_time) values
<foreach collection="list" item="item" separator=",">
(#{item.accountNo},#{item.accountName},#{item.accountProvince},#{item.accountCity},#{item.accountDistrict},#{item.accountAddress},now())
</foreach>
</insert>