Spring Boot+MySQL员工追踪器实体关联配置报错求助

错误原因分析 #

你遇到的Use of @OneToMany or @ManyToMany targeting an unmapped class错误，根源有以下几点：

• Company实体未标记为JPA实体：缺少@Entity注解，导致JPA无法识别该类为持久化实体。
• 一对多关联方向完全搞反：一个公司对应多个员工，应该是Company（一方）持有@OneToMany关联到Employee（多方），而Employee（多方）通过@ManyToOne关联回Company。你当前在Employee里加了@OneToMany，逻辑完全错误。
• Employee主键字段命名混乱：把自身主键命名为companyId，不仅语义错误，还会和外键字段混淆。
• 缺少外键映射配置：Employee里的company_id字段没有通过@JoinColumn配置为关联Company的外键。

修正后的代码 #

1. Company实体类（修正版） #

添加@Entity注解，并配置@OneToMany关联Employee：

package employeeapps.com.example.EmployeeTracker.model;

import javax.persistence.*;
import java.util.Set;

@Entity
@Table(name = "company")
public class Company {

    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private long id;

    @Column(name = "name")
    private String name;

    // 一对多关联：一个公司对应多个员工，mappedBy指向Employee里的company属性
    @OneToMany(mappedBy = "company", cascade = CascadeType.ALL, fetch = FetchType.LAZY)
    private Set<Employee> employees;

    public Company() {
    }

    public Company(String name) {
        this.name = name;
    }

    // Getter和Setter
    public long getId() {
        return id;
    }

    public void setId(long id) {
        this.id = id;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public Set<Employee> getEmployees() {
        return employees;
    }

    public void setEmployees(Set<Employee> employees) {
        this.employees = employees;
    }
}

2. Employee实体类（修正版） #

修正主键命名，添加@ManyToOne关联Company，并配置外键company_id：

package employeeapps.com.example.EmployeeTracker.model;

import javax.persistence.*;

@Entity
@Table(name = "employees")
public class Employee {

    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private long id; // 修正主键名称为id，符合语义

    @Column(name = "first_name")
    private String firstName;

    @Column(name = "last_name")
    private String lastName;

    @Column(name="address")
    private String address;

    @Column(name="salary")
    private Double salary;

    @Column(name = "email_id")
    private String emailId;

    // 多对一关联：多个员工属于一个公司
    @ManyToOne(fetch = FetchType.LAZY)
    @JoinColumn(name = "company_id") // 指定数据库外键字段为company_id
    private Company company;

    // 默认构造函数
    public Employee() {
    }

    // 带参数构造函数（不含主键和关联对象）
    public Employee(String firstName, String lastName, String emailId, String address, Double salary) {
        this.firstName = firstName;
        this.lastName = lastName;
        this.emailId = emailId;
        this.salary = salary;
        this.address = address;
    }

    // Getter和Setter
    public long getId() {
        return id;
    }

    public void setId(long id) {
        this.id = id;
    }

    public String getFirstName() {
        return firstName;
    }

    public void setFirstName(String firstName) {
        this.firstName = firstName;
    }

    public String getLastName() {
        return lastName;
    }

    public void setLastName(String lastName) {
        this.lastName = lastName;
    }

    public String getEmailId() {
        return emailId;
    }

    public void setEmailId(String emailId) {
        this.emailId = emailId;
    }

    public String getAddress() {
        return address;
    }

    public void setAddress(String address) {
        this.address = address;
    }

    public Double getSalary() {
        return salary;
    }

    public void setSalary(Double salary) {
        this.salary = salary;
    }

    public Company getCompany() {
        return company;
    }

    public void setCompany(Company company) {
        this.company = company;
    }
}

3. 其他注意事项 #

• 确保你的Repository接口（比如employeeRepository）继承JpaRepository<Employee, Long>，CompanyRepository继承JpaRepository<Company, Long>。
• 启动类上添加@EnableJpaRepositories和@EntityScan（如果需要），确保Spring能扫描到实体类和Repository。

内容的提问来源于stack exchange，提问作者Paul