mybatis写sql

批量查询

 <select id="getPreIds" resultType="java.lang.String"
            parameterType="java.util.List">
        SELECT  pre_batch_id  FROM public.mine_data_quality_check_record  WHERE deleted=0

        <if test="list != null">
            AND pre_batch_id in (
            <foreach collection="list" item="id" separator=",">
                #{id}
            </foreach>
            )
        </if>
        GROUP BY pre_batch_id HAVING count(*)>2 ORDER BY pre_batch_id ASC

    </select>
1
2
3
4
5
6
7
8
9
10
11
12
13
14

返回值类型不应该写List,抽象接口处写