1.返回一條結(jié)果
接口定義
/**
* 根據(jù)ID查找用戶春塌，返回Map對(duì)象箱歧。
* @param id
* @return
*/
Map<String, Object> selectUserByIdForMap(Long id);
Mapper
<select id="selectUserByIdForMap" resultType="map">
select
id, user_name name, user_password password, user_phone phone, user_email email, user_info info, user_img img, create_time createTime
from
`db_user`
where
id = #{id}
</select>
測(cè)試類
@Test
public void testSelectUserByIdForMap() {
Map<String, Object> userMap = mapper.selectUserByIdForMap(2L);
String key = null;
Object value = null;
for (Map.Entry<String, Object> field : userMap.entrySet()) {
key = field.getKey();
value = field.getValue();
System.out.println(key + " : " + value);
}
}
測(cè)試結(jié)果
DEBUG [main] - Cache Hit Ratio [com.mybatis.mapper.UserMapper]: 0.0
DEBUG [main] - ==> Preparing: select id, user_name name, user_password password, user_phone phone, user_email email, user_info info, user_img img, create_time createTime from `db_user` where id = ?
DEBUG [main] - ==> Parameters: 2(Long)
TRACE [main] - <== Columns: id, name, password, phone, email, info, img, createTime
TRACE [main] - <== Row: 2, batch0, a0, 222, 123@123.com, <<BLOB>>, <<BLOB>>, 2018-08-03 11:17:52
DEBUG [main] - <== Total: 1
password : a0
img : [B@5c90e579
phone : 222
createTime : 2018-08-03 11:17:52.0
name : batch0
id : 2
email : 123@123.com
info : 222
2.返回多條結(jié)果
接口定義
/**
* 查找所有用戶，返回Map坷檩。
* @return
*/
@MapKey("id")
Map<Long, User> selectAllUserForMap();
Mapper
<select id="selectAllUserForMap" resultType="User">
select
id, user_name name, user_password password, user_phone phone, user_email email, user_info info, user_img img, create_time createTime
from
`db_user`
</select>
測(cè)試類
@Test
public void testSelectAllUserForMap() {
Map<Long, User> userMap = mapper.selectAllUserForMap();
Long key = null;
User user = null;
for (Map.Entry<Long, User> map : userMap.entrySet()) {
key = map.getKey();
user = map.getValue();
System.out.println(key + " : " + user);
}
}
測(cè)試結(jié)果
這里為了方便顯示只查詢了前10條數(shù)據(jù)。
DEBUG [main] - Cache Hit Ratio [com.mybatis.mapper.UserMapper]: 0.0
DEBUG [main] - ==> Preparing: select id, user_name name, user_password password, user_phone phone, user_email email, user_info info, user_img img, create_time createTime from `db_user` limit 10
DEBUG [main] - ==> Parameters:
TRACE [main] - <== Columns: id, name, password, phone, email, info, img, createTime
TRACE [main] - <== Row: 1, hotch1, 111, 111, 123@123.com, <<BLOB>>, <<BLOB>>, 2018-07-31 15:34:51
TRACE [main] - <== Row: 2, batch0, a0, 222, 123@123.com, <<BLOB>>, <<BLOB>>, 2018-08-03 11:17:52
TRACE [main] - <== Row: 3, batch1, a1, 222, 123@123.com, <<BLOB>>, <<BLOB>>, 2018-08-03 11:17:52
TRACE [main] - <== Row: 4, batch2, a2, 222, 123@123.com, <<BLOB>>, <<BLOB>>, 2018-08-03 11:17:52
TRACE [main] - <== Row: 5, batch3, a3, 222, 123@123.com, <<BLOB>>, <<BLOB>>, 2018-08-03 11:17:52
TRACE [main] - <== Row: 6, batch4, a4, 222, 123@123.com, <<BLOB>>, <<BLOB>>, 2018-08-03 11:17:52
TRACE [main] - <== Row: 7, batch5, a5, 222, 123@123.com, <<BLOB>>, <<BLOB>>, 2018-08-03 11:17:52
TRACE [main] - <== Row: 8, batch6, a6, 222, 123@123.com, <<BLOB>>, <<BLOB>>, 2018-08-03 11:17:52
TRACE [main] - <== Row: 9, batch7, a7, 222, 123@123.com, <<BLOB>>, <<BLOB>>, 2018-08-03 11:17:52
TRACE [main] - <== Row: 10, batch8, a8, 222, 123@123.com, <<BLOB>>, <<BLOB>>, 2018-08-03 11:17:52
DEBUG [main] - <== Total: 10
1 : User(id=1, name=hotch1, password=111, phone=111, email=123@123.com, info=111, img=[97, 118, 100], createTime=Tue Jul 31 15:34:51 CST 2018)
2 : User(id=2, name=batch0, password=a0, phone=222, email=123@123.com, info=222, img=[97, 118, 100], createTime=Fri Aug 03 11:17:52 CST 2018)
3 : User(id=3, name=batch1, password=a1, phone=222, email=123@123.com, info=222, img=[97, 118, 100], createTime=Fri Aug 03 11:17:52 CST 2018)
4 : User(id=4, name=batch2, password=a2, phone=222, email=123@123.com, info=222, img=[97, 118, 100], createTime=Fri Aug 03 11:17:52 CST 2018)
5 : User(id=5, name=batch3, password=a3, phone=222, email=123@123.com, info=222, img=[97, 118, 100], createTime=Fri Aug 03 11:17:52 CST 2018)
6 : User(id=6, name=batch4, password=a4, phone=222, email=123@123.com, info=222, img=[97, 118, 100], createTime=Fri Aug 03 11:17:52 CST 2018)
7 : User(id=7, name=batch5, password=a5, phone=222, email=123@123.com, info=222, img=[97, 118, 100], createTime=Fri Aug 03 11:17:52 CST 2018)
8 : User(id=8, name=batch6, password=a6, phone=222, email=123@123.com, info=222, img=[97, 118, 100], createTime=Fri Aug 03 11:17:52 CST 2018)
9 : User(id=9, name=batch7, password=a7, phone=222, email=123@123.com, info=222, img=[97, 118, 100], createTime=Fri Aug 03 11:17:52 CST 2018)
10 : User(id=10, name=batch8, password=a8, phone=222, email=123@123.com, info=222, img=[97, 118, 100], createTime=Fri Aug 03 11:17:52 CST 2018)
從上面的查詢結(jié)果可以看出返回的 Map 的 key 值是返回對(duì)象的 id 储狭，value 的值是對(duì)象本身行拢。那么MyBatis是怎么知道 Map 的 key 是對(duì)象的 ID 值呢晴埂？這就要從定義接口方法時(shí)添加的注釋說起了，@MapKey("id") 注釋可以指定返回 Map 的 key 值是那個(gè)屬性值聂喇，所以如果把注釋中的 id 改為 name 的話 Map 的 key 就會(huì)是對(duì)象的 name 屬性值了辖源。
