返回List<Map<String, String>>键值对格式

合集 - MyBatis(16)

1.resultType和resultMap的区别2018-05-262.<association>关联的结果查询2018-05-263.新增返回主键2018-05-274.<foreach/>标签原理及用法2018-05-27

5.返回List<Map<String, String>>键值对格式2018-05-26

6.<collection>映射集合结果查询2018-05-267.Mybatis的执行流程2022-06-088.MyBatis写入大量数据2020-04-169.MyBatis读取大量数据（流式读取）2020-04-0810.MyBatis Generator 自动生成工具（dao / mapping / model）2018-08-2211.MyBatisPlus怎么忽略映射字段2018-05-2712.MyBatisPlus AutoGenrator代码自动生成2018-05-2713.<resultMap/> 标签支持继承 extends2018-05-2714.SpringData JPA、Hibernate、Mybatis三者的区别2023-10-1715.Mybatis代码生成——velocity模板元素2023-10-2716.Mybatis代码生成——velocity模板语法2023-10-27

收起

只要设定resultType而不设定resultMap就可以了。

 

Java接口：

List<Map<String, String>> getMtypeList();

XML：

<select id="getMtypeList" parameterType="java.util.Map" resultType="java.util.HashMap">
    select code,`name` from jk_control_measure rs
    where rs.TYPE_ID != 1
        <if test="qKeyWord != null">
            and rs.stock_code = #{qKeyWord}
        </if>
        <if test="rsTitle != null">
            and rs.title like #{rsTitle}
        </if>
        order by rs.crt_time desc limit #{pageIndex}, #{pageSize}
</select>

输出结果：

[
    {"NAME":"地面冲洗","name":"地面冲洗","code":"one","CODE":"one"},
    {"NAME":"边界围挡","name":"边界围挡","code":"two","CODE":"two"},
    {"NAME":"垃圾覆盖","name":"垃圾覆盖","code":"three","CODE":"three"},
    {"NAME":"裸地覆盖","name":"裸地覆盖","code":"four","CODE":"four"},
    {"NAME":"洒水降尘","name":"洒水降尘","code":"five","CODE":"five"}
]