mybatis mysql delete in操作只能删除第一条数据
mybatis xml
<!-- 根据ID列表批量删除记录 -->
<delete id="deleteFileByIds" parameterType="java.util.List"> (其中参数类型也试过java.util.map)
DELETE FROM tbs_file WHERE fileId in
<foreach collection="list" item="fileId" index="index" open="(" close=")" separator=",">
#{fileId}
</foreach>
</delete>
mapper.java中:deleteFileByIds(List<String> fileIdList);
运行时后台打印:
==> Executing: DELETE FROM tbs_file WHERE fileId in ( ? )
==> Parameters: 58,59(String)
把sql粘出来在navicat中执行,可以全部删除(fileId是主键)
但是在应用中就只能删除58这一条记录;
就是,我传1,2,3,4,5 就只删1
实在解决不了了,已经换其他方式了,望高手有时间就看下
另对论坛比较失望,就没解决过问题。。。。分数全部就这么多了,全部奉上