@Select("<script> SELECT * FROM tablename where used =1 and sid in "
+ "<foreach item='item' index='index' collection='ids' open='(' separator=',' close=')'>"
+ "#{item} </foreach>" + "</script>")
List<Map<String, Object>> getStationstateByIds(@Param("ids") List<Integer> ids);
@Select sql语句in list的情况
于 2024-09-05 14:23:51 首次发布