1. mybatis的批量查询很简单,结合mybatis自有的标签<foreach>即可;
2. 批量更新,我在实际项目中遇到的配置的mybatis不支持生成多条update语句一次性执行,经过百度查到一种方式foreach和case ... when ... then ... 结合使用也可达到批量执行sql的效果:
update table_name
set column1 =
(<foreach collection = "maps" item = "item"
index = "index" separator = " " open = "case column2"
close = "end"></foreach>
when #{item.filed1} then #{item.filed2}
)
3. 批量删除 (稍后补充)