Sping boot 当中的注解SQL查询

[di_yun_hah]

现在传一个集合到mapper当中作为一个参数，怎么让他直接作用于注解SQL
不要包成一个类写动态SQL

附带代码：

@Select("SELECT * FROM `msg` WHERE `content_id` in ")
List<MsgContentDetail> ls(List<String> ids);
查询条件该怎么写

[di_yun_hah]

不要子查询哦！太影响性能了

[Swen程序员]

我有点没有理解您的意思，可以说明白一些？

[Sunyiban]

@Select("SELECT " + "a.id as 'id',a.create_date as 'createDate',a.content as 'content'," + "a.parent_id as 'parentId',a.first_comment_id as 'firstCommentId'," + "b.id as 'fromUser.id',b.realname as 'fromUser.realname',b.avatar as 'fromUser.avatar'," + "c.id as 'toUser.id',c.realname as 'toUser.realname',c.avatar as 'toUser.avatar' " + "FROM t_demand_comment a " + "LEFT JOIN t_user b ON b.id = a.from_uid " + "LEFT JOIN t_user c ON c.id = a.to_uid " + "WHERE a.demand_id = #{demandId} " + "ORDER BY a.create_date ASC" + "LIMIT #{startNo},#{pageSize}") public List<DemandComment> listDemandComment(@Param("demandId") Long demandId, @Param("startNo") Integer pageNo, @Param("pageSize") Integer pageSize);

[逸萌]

引用 3 楼 di_yun_hah 的回复:

不要子查询哦！太影响性能了

对啊

[Amin已经存在了]

@Query("SELECT * FROM `msg` WHERE `content_id` in (:ids) ")