1.第一种方式： 将任意多个 id 拼接成字符串，以参数形式传递进去，通过 in 函数 的方式来删除 ①首先定义接口类 //通过id所组成的字符串实现批量删除 public void d
将任意多个 id 拼接成字符串，以参数形式传递进去，通过 in 函数 的方式来删除
①首先定义接口类
//通过id所组成的字符串实现批量删除 public void deleteId(@Param("ids") String ids);②在实现类中配置Mapper.xml
delete from accounts where id in (${ids}) ③测试类
@Test public void testDeleteIds() { ad.deleteId("25,26,27"); sqlSession.commit(); mybatisUtil.close(sqlSession); }④结果
DEBUG [main] - Logging initialized using 'org.apache.ibatis.logging.log4j.Log4jImpl' adapter.DEBUG [main] - PooledDataSource forcefully closed/removed all connections.DEBUG [main] - PooledDataSource forcefully closed/removed all connections.DEBUG [main] - PooledDataSource forcefully closed/removed all connections.DEBUG [main] - PooledDataSource forcefully closed/removed all connections.DEBUG [main] - Openning JDBC ConnectionDEBUG [main] - Created connection 331510866.DEBUG [main] - ooo Using Connection [com.mysql.jdbc.JDBC4Connection@13c27452]DEBUG [main] - ==> Preparing: delete from accounts where id in (25,26,27) DEBUG [main] - ==> Parameters: DEBUG [main] - Committing JDBC Connection [com.Mysql.jdbc.JDBC4Connection@13c27452]DEBUG [main] - Resetting autocommit to true on JDBC Connection [com.mysql.jdbc.JDBC4Connection@13c27452]DEBUG [main] - Closing JDBC Connection [com.mysql.jdbc.JDBC4Connection@13c27452]DEBUG [main] - Returned connection 331510866 to pool.注意： #{}中字符串类型会使用单引号，${} 则无需。这里只能使用${}方式，不能使用#{}
使用 foreach 标签来进行删除
①首先定义接口类
// 通过list集合实现批量删除 public void deleteByIds(@Param("ids") List ids); ②在实现类中配置Mapper.xml
③测试类
@Test public void testDeleteByIds() throws IOException { List List = new ArrayList<>(); List.add(22); List.add(23); List.add(24); ad.deleteByIds(List); sqlSession.commit(); MyBatisUtil.close(sqlSession); } ④结果
DEBUG [main] - Logging initialized using 'org.apache.ibatis.logging.log4j.Log4jImpl' adapter.DEBUG [main] - PooledDataSource forcefully closed/removed all connections.DEBUG [main] - PooledDataSource forcefully closed/removed all connections.DEBUG [main] - PooledDataSource forcefully closed/removed all connections.DEBUG [main] - PooledDataSource forcefully closed/removed all connections.DEBUG [main] - Openning JDBC ConnectionDEBUG [main] - Created connection 249155636.DEBUG [main] - ooo Using Connection [com.mysql.jdbc.JDBC4Connection@ed9d034]DEBUG [main] - ==> Preparing: delete from accounts where id in ( ? , ? , ? ) DEBUG [main] - ==> Parameters: 28(Integer), 29(Integer), 30(Integer)DEBUG [main] - Resetting autocommit to true on JDBC Connection [com.mysql.jdbc.JDBC4Connection@ed9d034]DEBUG [main] - Closing JDBC Connection [com.mysql.jdbc.JDBC4Connection@ed9d034]DEBUG [main] - Returned connection 249155636 to pool.总结：两种方式均可，可根据自身熟悉度进行选择
来源地址：https://blog.csdn.net/qq_35260388/article/details/126853562
--结束END--
本文标题: Mybatis实现批量删除（两种常用方法）
本文链接: https://lsjlt.com/news/409934.html(转载时请注明来源链接)
有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341
2024-04-01
2024-04-03
2024-04-03
2024-01-21
2024-01-21
2024-01-21
2024-01-21
2023-12-23
回答
回答
回答
回答
回答
回答
回答
回答
回答
回答
官方手机版
微信公众号
商务合作
0