实体类
Dept类
public class Dept implements Serializable
{
private Long departmentId;
private String departmentCode;
private String departmentName;
private Long managerId;
private Long locationId;
private Location location;
}
Emp类
public class Emp implements Serializable
{
private Long employeeId;
private String employeeNum;
private String firstName;
private String lastName;
private String sex;
private String phone_num;
private String email;
private String hire_date;
private Long departmentId;
private Long status_code;
private Dept dept;
}
Location类
public class Location implements Serializable {
private Long locationId;
private String country;
private String province;
private String city;
private String address;
}
数据库
departments表
employees表
locations表
employees表和dep