<resultMap  id="UsersMap" type="com.wang.test.demo.entity.User">
    <id property="id" column="id" jdbcType="INTEGER"/>
    <result property="username" column="username" jdbcType="VARCHAR"/>
    <result property="password" column="password" jdbcType="VARCHAR"/>
    <result property="role" column="role" jdbcType="VARCHAR"/>
    <result property="addTime" column="add_time" jdbcType="TIMESTAMP"/>
</resultMap>

@Data
//書(shū)籍
public class Book {
    private String id;
    private String name;
    private String author;
    private Double price;
    private Integer del;
    private Date publishdate;
    private String info;
    //把出版社對(duì)象當(dāng)作屬性
    private Publisher pub;//------重點(diǎn)在這里一本書(shū)對(duì)應(yīng)一個(gè)出版社,這是一個(gè)出版社對(duì)象
}

@Data
//出版社
public class Publisher {
    private String id;
    private String name;
    private String phone;
    private String address;
}

<resultMap id="rMap_book" type="com.wang.test.demo.entity.Book">
	<!-- 主鍵  property為實(shí)體類屬性 column為數(shù)據(jù)庫(kù)字段 jdbcType為實(shí)體類對(duì)應(yīng)的jdbc類型-->
    <id property="id" column="b_id" jdbcType="VARCHAR"></id>
    <!-- 普通屬性  property為實(shí)體類屬性 column為數(shù)據(jù)庫(kù)字段  jdbcType為實(shí)體類對(duì)應(yīng)的jdbc類型-->
    <result property="name" column="b_name" jdbcType="VARCHAR"></result>
    <result property="author" column="author" jdbcType="VARCHAR"></result>
    <result property="price" column="price" jdbcType="VARCHAR"></result>
    <result property="del" column="del" jdbcType="NUMERIC"></result>
    <result property="publisherid" column="publisher_id" jdbcType="VARCHAR"></result>
    <result property="publishdate" column="publish_date" jdbcType="TIMESTAMP"></result>
    <!--一對(duì)一映射association property 為實(shí)體類book中的屬性名字 javaType為實(shí)體類屬性的類型 -->
    <association property="pub" javaType="com.wang.test.demo.entity.Publisher">
        <id property="id" column="p_id" jdbcType="VARCHAR"></id>
        <result property="name" column="name" jdbcType="VARCHAR"></result>
        <result property="phone" column="phone" jdbcType="VARCHAR"></result>
        <result property="address" column="address" jdbcType="VARCHAR"></result>
    </association>
</resultMap>

@Data
//班級(jí)類
public class Class {

    private String id;
    private String name;
    private List<Student> students;//----重點(diǎn)在這里,一個(gè)班級(jí)對(duì)應(yīng)多個(gè)學(xué)生

}

@Data
public class Student {

    private int id;
    private String name;
    private int age;
}

<resultMap id="rMap_class" type="com.wang.test.demo.entity.Class">
    <id property="id" column="id" jdbcType="VARCHAR"></id>
    <result property="name" column="name" jdbcType="VARCHAR"></result>
    <!--一對(duì)多映射用這個(gè)  ofTyp是一對(duì)多的集合的所存放的實(shí)體類  javaType實(shí)體類的屬性類型-->
    <collection property="students" ofType="com.wang.test.demo.entity.Student" javaType="list">
        <id property="id" column="id" jdbcType="INTEGER"></id>
        <result property="name" column="name" jdbcType="VARCHAR"></result>
        <result property="age" column="age" jdbcType="INTEGER"></result>
    </collection>
</resultMap>