mapper.xml修改:
//批量插入
<insert id="insertList" parameterType="java.util.List">
insert into demo_table (ID, NAME)
values
<foreach collection="list" item="item" index="index" separator="," >
(#{item.id,jdbcType=VARCHAR}, #{item.name,jdbcType=VARCHAR})
</foreach>
</insert>
dao修改
int insertList(List<Student> list);
//批量删除
int deleteBathById(List<String> list);
<delete id="deleteBathById" parameterType="java.lang.String">
delete from demo_table where id in
<foreach item="item" index="index" collection="list" open="(" separator="," close=")">
#{item}
</foreach>
</delete&g