create table t_company
(
id NUMBER(12) not null,
name VARCHAR2(128),
code VARCHAR2(32),
address VARCHAR2(256),
telephone VARCHAR2(18)
)
create table t_employee
(
id NUMBER(12) not null,
name VARCHAR2(48),
sex NUMBER(1),
job VARCHAR2(48),
salary NUMBER(12,2),
company_id NUMBER(12)
)
@Data
public class Company implements Serializable {
private Integer id;
private String name;
private String code;
private String address;
private String telephone;
private List<Employee> employees;
}
@Data
public class Employee implements Serializable {
private Integer id;
private String name;
private int sex;
private String job;
private double salary;
private Integer companyID;
}
输出各个公司以及所属员工信息:
<!--mothod one -->
<resultMap id="companyOne" type="com.example.mybatis01.entity.Company">
<id column="id" property="id"></id>
<result column="name" property="name"></result>
<result column="code" property="code"></result>
<result column="address" property="address"></result>
<result column="telephone" property="telephone"></result>
<collection property="employees" ofType="com.example.mybatis01.entity.Employee"
javaType="java.util.ArrayList