上一章我们介绍了
mybatis各种查询功能5 - 查询所有数据并返回多个map集合https://blog.csdn.net/m0_53753920/article/details/124217303本章我们将介绍如何查询所有数据并且返回map类型的集合。
目录
1.接口
加入mapKey, 作为map的主键
@MapKey("id")
Map<String, Object> getAllUserToMap();
2.mapper映射文件
<select id="getAllUserToMap" resultType="Map">
select * from t_user
</select>
3.测试类
@Test
public void testAllUserToMap() {
SqlSession sqlSession = SqlSessionUtils.getSqlSession();
SelectMapper mapper = sqlSession.getMapper(SelectMapper.class);
try{
Map<String, Object> allUserToMap = mapper.getAllUserToMap();
System.out.println(allUserToMap);
}catch (NullPointerException e){
e.printStackTrace();
System.out.println("db is null");
}
}
4. 结果