mybatis plus使用 in 语句

记录一下使用mybatis plus 查询时使用in关键字的坑@Select({"<script>","SELECT round( ifnull( sum( cny_pirce ), 0 ), 2 ) AS total","FROM `data` WHERE id IN ","<foreach item='item' index='index' collection='dataI

周全全

2232人浏览 · 2022-03-27 23:20:31

周全全 · 2022-03-27 23:20:31 发布

记录一下使用mybatis plus 查询时使用in关键字的坑

@Select({"<script>",
        "SELECT round( ifnull( sum( cny_pirce ), 0 ), 2 ) AS total",
        "FROM `data` WHERE id IN ",
        "<foreach item='item' index='index' collection='dataIdListStr' open='(' separator=',' close=')'>",
        "#{item}",
        "</foreach>",
        "</script>"
})
Double getCurrentOrderFee(@Param("dataIdListStr") Integer[] dataIdList);