mybatis 如何查找表里的某一个字段，然后返回它们的结果集list ?

单个字段的list映射

取自: https://blog.csdn.net/weixin_30723433/article/details/95642002?biz_id=102&utm_term=mybatis%20%20%E6%

<!--    问题类型-->
    <select id="getQuestionSubjects" parameterType="list" resultType="string">
    	select subject from question GROUP BY subject
    </select>

多个字段的list映射

@Data
@ToString
public class SelectQuestion {
    private String putUser;
    private Long qid;
    private String question;
    private String answer;
    private String subject;
    private List<String> selections; //Selection
}

	<resultMap id="SQuestion" type="SelectQuestion">
        <result property="qid" column="qid"></result>
        <result property="putUser" column="name"></result>
        <collection property="selections" javaType="ArrayList" ofType="SelectionEntity" select="getSelectMsgById" column="qid"/>
    </resultMap>
    <select id="getSelectMsgById" resultType="String">
        select  selection from  toanswer.selection where qid=#{qid}
    </select>
   <select id="getSelectQuestionByKeywords"   resultMap="SQuestion">
        SELECT  * from view_select_question where question like concat('%',#{keywords},'%')
    </select>

简单查询

     <select id="getDiscussByUid"  resultType="DiscussSimpleEntity">
        select did,content from discuss where uid=#{uid} and is_deleted=0;
   </select>