mybatis的mapper返回map结果集

https://blog.csdn.net/huanyinghanlang/article/details/79194005

 

通过MapKey指定map的key值

1. @MapKey("id")

2. Map<Long, UserInfo> getUserInfoMap();

3.  

4. @MapKey("id")

5. Map<Long, Map<String,Object>> getUserValueMap();

map的value为java类

1. <resultMap id="UserResultMap" type="com.xixicat.domain.UserInfo">

2. <result property="id" column="id" />

3. <result property="username" column="username" />

4. <result property="sex" column="sex" />

5. </resultMap>

6. <select id="getUserInfoMap" resultMap="UserResultMap">

7. select id,username,sex from user_info

8. </select>

map的value为map

1. <select id="getUserValueMap" resultType="map" >

2. select id,username,sex from user_info

3. </select>