根据idList集合查询对应的实体类按照对应的id顺序

最新推荐文章于 2023-10-03 11:08:22 发布

Petrichor_Lhc

最新推荐文章于 2023-10-03 11:08:22 发布

阅读量742

点赞数

分类专栏： MySql

本文链接：https://blog.csdn.net/Petrichor_Lhc/article/details/114634155

版权

MySql 专栏收录该内容

4 篇文章 0 订阅

订阅专栏

<select id="getMyFoodWebList" resultType="com.jusekj.zml.dto.search.MyFoodSearchDto">
        select id,food_name,food_measure,food_unit,food_calorie,img,seq
        from wx_food where id in
        <foreach collection="list" open="(" close=")" index="index" separator="," item="item">
            #{ item }
        </foreach>
        ORDER BY FIELD
        <foreach collection="list" item="styleNumId" separator="," open="(id," close=")">
            #{styleNumId}
        </foreach>
    </select>