一起学习Spring boot 2.1.X | 第十一篇：Mybatis映射

我是沐沫

于 2019-10-28 08:33:42 发布

阅读量362

点赞数

分类专栏： Spring boot 2.1.X

本文链接：https://blog.csdn.net/qq_41920732/article/details/100081570

版权

Spring boot 2.1.X 专栏收录该内容

27 篇文章 8 订阅

订阅专栏

@Results对应resultMap
@Result对应result
@ResultMap(“id”)
@Result中通过id属性引用这个resultMap

注：column：数据库字段 property: 实体类字段

@Select("SELECT id, name, password FROM user WHERE id = #{id}")
    @Results(id = "userMap", value = { @Result(column = "id", property = "id", javaType = Integer.class),
            @Result(column = "name", property = "name", javaType = String.class),
            @Result(column = "password", property = "password", javaType = String.class) })
    User findById(Integer id);

    @Select("SELECT * FROM user")
    @ResultMap("userMap")
    List<User> fingAll();