Mybatis 返回Map数据

目录

• 一. 方式1
• 二. 方式2
• 三. 方式3

一. 方式1

接口

public interface UserMapper {

    List<Map<String, String>> selectTestData1();
}


<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="xxx.mapper.UserMapper">

    <select id="selectTestData1" resultType="java.util.Map">
        SELECT
          t_user.id as id,
	      t_user.email as email,
	      t_user.avatar as avatar
        FROM
	      t_user
    </select>
</mapper>

调用

@Service
public class MapTest implements CommandLineRunner {