Mybatis中ResultMap映射-优快云博客

本文链接：https://blog.youkuaiyun.com/zhoufeiy/article/details/106696461

这篇博客详细介绍了Mybatis中的ResultMap映射，如何通过ResultMap将数据库查询结果映射到对应的实体类属性上，包括id和result的用法，以及如何处理一对多关联关系，如User和BlogType的映射。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

Mapper中的代码
<resultMap id="BlogMap" type="com.zy.entity.Blog">
    
    <id property="id" column="id"></id>
    <result property="insertTime" column="insertTime"></result>
    <result property="insertUser" column="insertUser"></result>
    <result property="updateTime" column="updateTime"></result>
    <result property="title" column="title1"></result>
    <result property="content" column="content"></result>
    <association property="user" javaType="com.zy.entity.User">
        <result property="avatar" column="avatar"></result>
    </association>
    <association property="blogType" javaType="com.zy.entity.BlogType">
        <result property="title" column="title2"></result>
    </association>

</resultMap>

实体类中的属性：

public class Blog {
    public int id;
    public User user;
    public String title;
    public String content;
    public BlogType blogType;
    public Date insertTime;
    public String insertUser;
    public Date updateTime;
    public int views;

}

User属性：

public class User {
    private int id;
    private String email;
    private String pwd;
    private String userName;
    private String nickName;
    private  String avatar;
    private int age;
    private  String introduction;
    Date registTime;
    Date updateTime;}

BlogType属性：

public class BlogType {
    public int id;
    User user;
    public String title;
    public Date insertTime;
    public Date updateTime;
}