Hint

This article is generated by AI translation.

Receive Data with List/Map

List/Map is a collection composed of multiple maps. It is a common structure to represent datasets with varying shapes.

Example

Map<String, Object> data = null;

data = jdbc.queryForMap("select * from users where name = 'Bob'");
data = jdbc.queryForMap("select * from address");

How to Use

Example: Programmatic API

List<Map<String, Object>> result = jdbc.queryForList("select * from users");

Example: Declarative API

@SimpleMapper
public interface UserMapper {
    @Query(value = "select * from users where id > #{id}")
    List<Map> listUsers(@Param("id") long searchId);
}

Example: Builder

List<Map<String, Object>> result = adapter.queryByEntity(User.class)
                                          .le(User::getId, 100) // match IDs <= 100
                                          .queryForMapList();   // return List/Map

Example: Mapper File

<select id="queryListByAge" resultType="map">
    select * from users where age = #{age}
</select>

resultType options

• map: uses the built-in Map strategy and respects column case-sensitivity settings; default is LinkedCaseInsensitiveMap.
• hashmap: uses HashMap
• linkedmap: uses LinkedHashMap
• caseinsensitivemap: uses LinkedCaseInsensitiveMap