How can MyBatis return a list of a single field?

9 months ago

Noah Thompson

1 minute

In MyBatis, ResultMap can be used to return a list of a field. Here is an example:

Firstly, in the mapper xml file, define a ResultMap to specify the fields to be returned.

<resultMap id="fieldListMap" type="java.lang.String">
    <id property="fieldName" column="field_name"/>
</resultMap>

Then use ResultMap in the SQL statement to return the list of fields.

<select id="getFieldList" resultMap="fieldListMap">
    SELECT field_name
    FROM your_table
</select>

Finally, in the Java code, call this query and retrieve the returned list.

List<String> fieldList = sqlSession.selectList("getFieldList");

This way, you can obtain the list of returned fields.