mybatis 的特殊使用

insert时将id输出

useGeneratedKeys="true" keyProperty="id"

根据你输入的列表进行排序

ORDER BY FIELD(g.id,
            <foreach collection="gids" separator="," index="index" item="gid">
                #{gid}
            </foreach>
        )
        

mybatis里面使用set

<select id="getPublicGroupByGids" parameterType="collection" resultType="int" >
        SELECT id FROM `group` WHERE visibility=0 AND id IN (
        <foreach collection="collection" index="index" item="gid"  separator=",">
            #{gid}
        </foreach>
        )
        ORDER BY id ASC
    </select>