mybatis-plus - 这个mybatis的问题请问如何处理？

Question

问个基础问题噻
这个in该怎么写，怎么给参数好？
PointsMapper.java里

@Delete("DELETE FROM abc_points_temp WHERE id in #{ids} ")
void deletePointsTemp(@Param("ids") List<Long> ids);

Answer 1

最好的方法是不用mybaits这破烂玩意.

Answer 2

最终用ChatGPT提供的这种方法解决

@Delete({
        "<script>",
        "DELETE FROM abc_points_temp WHERE id IN",
        "<foreach item='id' collection='ids' open='(' separator=',' close=')'>",
        "#{id}",
        "</foreach>",
        "</script>"})
int deletePointsTemp(@Param("ids") List<Long> ids);