2021-07-22学习笔记 一对多关系

1。新建两个实体类

package com.pro.domain;

public class Status {
    private int statusId;
    private String status;

    public int getStatusId() {
        return statusId;
    }

    public void setStatusId(int statusId) {
        this.statusId = statusId;
    }

    public String getStatus() {
        return status;
    }

    public void setStatus(String status) {
        this.status = status;
    }
}

package com.pro.domain;

public class Product {
    private int productId;
    private String productName;
    private double price;

    private Category category;

    public int getProductId() {
        return productId;
    }

    public void setProductId(int productId) {
        this.productId = productId;
    }

    public String getProductName() {
        return productName;
    }

    public void setProductName(String productName) {
        this.productName = productName;
    }

    public double getPrice() {
        return price;
    }

    public void setPrice(double price) {
        this.price = price;
    }

    public Category getCategory() {
        return category;
    }

    public void setCategory(Category category) {
        this.category = category;
    }
}

---

2.编写info1.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="zjhsxl">
    <resultMap id="info1Map" type="com.pro.domain.Info1">
        <id property="stu.stuId" column="stuId"/>
        <result property="stu.stuName" column="stuName"/>
        <result property="stu.sex" column="sex"/>
        <result property="status.statusId" column="statusId"/>
        <result property="status.status" column="status"/>
    </resultMap>
    <select id="selectInfo1" resultMap="info1Map">
        select s.*,s1.* from Student s,status s1 where s.statusId=s1.statusId
    </select>
</mapper>

---

3.添加test方法

 @Test
    public void testSelectInfo1() throws IOException {
        List<Info1> infoList = sqlSession.selectList("zjhsxl.selectInfo1");
        for(Info1 info: infoList){
            System.out.println(info.getStu().getStuName()+","+info.getStatus().getStatus());
        }
        sqlSession.commit();
        System.out.println(infoList.size());
    }