mybatis查询返回多条数据

返回User类型的list

<select id="queryAllUser" resultType="org.example.entity.User">
        select * from t_user
</select>
public interface UserMapper {

    public void addUser();

    public List<User> queryAllUser();

    public User queryUserByid(@Param("name") String name);
}
@Test
    public void queryAllUser(){
        SqlSession sqlSession = SqlSessionUtil.getSqlSession();
        UserMapper mapper = sqlSession.getMapper(UserMapper.class);
        List<User> users = mapper.queryAllUser();
        System.out.println(users);
    }

 

查询所有用户信息为map集合(方法1)

    <select id="queryAllUser" resultType="map">
        select * from t_user
    </select>
复制代码
public interface UserMapper {

    public void addUser();

    public User queryUserByid(@Param("name") String name);

    public List<Map<String, Object>> queryAllUser();

}
复制代码
@Test
    public void queryAllUser(){
        SqlSession sqlSession = SqlSessionUtil.getSqlSession();
        UserMapper mapper = sqlSession.getMapper(UserMapper.class);
        List<Map<String, Object>> maps = mapper.queryAllUser();
        System.out.println(maps);
    }

[{gender=男, name=tom, id=1, age=20, email=123123@qq.com}, {gender=女, name=luccy, id=2, age=10, email=22222@qq.com}]

 

查询所有用户信息为map集合(方法2)

 <select id="queryAllUser" resultType="map">
        select * from t_user
 </select>
复制代码
public interface UserMapper {

    public void addUser();

    public User queryUserByid(@Param("name") String name);

    @MapKey("id")//设置id为map集合的key
    public Map<String, Object> queryAllUser();

}
复制代码
 @Test
    public void queryAllUser(){
        SqlSession sqlSession = SqlSessionUtil.getSqlSession();
        UserMapper mapper = sqlSession.getMapper(UserMapper.class);
        Map<String, Object> maps = mapper.queryAllUser();
        System.out.println(maps);
    }

{1={gender=男, name=tom, id=1, age=20, email=123123@qq.com}, 2={gender=女, name=luccy, id=2, age=10, email=22222@qq.com}}

 

posted @   iTao0128  阅读(438)  评论(0编辑  收藏  举报
相关博文:
阅读排行:
· 微软正式发布.NET 10 Preview 1:开启下一代开发框架新篇章
· 没有源码,如何修改代码逻辑?
· DeepSeek R1 简明指南:架构、训练、本地部署及硬件要求
· NetPad:一个.NET开源、跨平台的C#编辑器
· 面试官:你是如何进行SQL调优的?
历史上的今天:
2022-02-27 v-slot
2022-02-27 具名插槽
2022-02-27 插槽基本用法
2022-02-27 子组件访问父组件$parent,$root
2022-02-27 父组件访问子组件$children,$refs
2022-02-27 watch属性
点击右上角即可分享
微信分享提示