mapping.xml --------
1、
<select id="get" resultMap="ReturnMap" >
SELECT
a.id,
a.userid as "UserId",
s.name as "user.name"
FROM user a
LEFT JOIN log_user s ON
a.userid=s.id
</select>
<resultMap id="ReturnMap" type="User">
<result property="id" column="id" />
<result property="UserId" column="userid" />
<result property="user.name" column="user.name" />
</resultMap>
---dao层
@MapKey("user.name")
public Map<String,User> get();
2、
@MapKey("id")
Map<Long, Map<String,Object>> getValueMap();
map的value为map
<select id="getValueMap" resultType="map" >
select id,username,sex from user_info
from user_info
</select>
Mapping返回值map
最新推荐文章于 2024-06-17 20:30:05 发布