一、批量删除
delete from table
where id IN (
#{item.stuId,jdbcType=VARCHAR}
)
二、批量增加
insert into table (id, age, name) values
(
#{item.id,jdbcType=VARCHAR},
#{item.stuName,jdbcType=VARCHAR},
#{item.stuAge,jdbcType=VARCHAR}
)
一、批量删除
delete from table
where id IN (
#{item.stuId,jdbcType=VARCHAR}
)
二、批量增加
insert into table (id, age, name) values
(
#{item.id,jdbcType=VARCHAR},
#{item.stuName,jdbcType=VARCHAR},
#{item.stuAge,jdbcType=VARCHAR}
)