Spring Boot JPA双向一对多关联REST接口输出异常问题求助

项目说明 #

使用Spring Boot、Spring Data JPA创建项目，定义Employee、Department两个实体并配置双向@ManyToOne关联，运行后得到非预期结果。

代码实现 #

员工实体：Employee.java #

@Setter
@Getter
@NoArgsConstructor
@AllArgsConstructor
public class Employee {
    @Id
    @GeneratedValue(strategy = GenerationType.AUTO)
    private Long id;
    private String firstname;
    private String lastname;
    private Long mobile;
    private String email;
    @ManyToOne
    private Department department;

    public Employee(Long id, String firstname, Department department) {
        this.id = id;
        this.firstname = firstname;
        this.department = department;
    }
} 

部门实体：Department.java #

@Getter
@Setter
@NoArgsConstructor
@AllArgsConstructor
public class Department {
    @Id
    @GeneratedValue(strategy = GenerationType.AUTO)
    private Long id;
    private String Departmentname;
    private String Address;
    @OneToMany(mappedBy = "department",fetch = FetchType.EAGER)
    private List<Employee> employees= new ArrayList<>();

    public Department(String departmentname, String address) {
        Departmentname = departmentname;
        Address = address;
    }

    public void addEmployees(Employee employee) {
        this.employees.add(employee);
    }
    public void removeEmployees(Employee employee) {
        this.employees.remove(employee);
    }
}

数据访问层：EmployeeRepository.java #

@Repository
public interface EmployeeRepositroy extends JpaRepository<Employee, Long> {

    @Query("SELECT e FROM Employee e join e.department WHERE e.firstname =:n")
    public List<Employee> getName(@Param("n") String firstname);

    @Query("SELECT e FROM Employee e")
    public List<Employee> getData();
}

控制层：EmployeeController.java #

@RestController
public class EmployeeController {
    @Autowired
    EmployeeRepositroy employeeRepositroy;
    
    @GetMapping("/record/{name}")
    public Object GetNameByRecords(@PathVariable("name") String firstname) {
        return employeeRepositroy.getName(firstname);
    }
}

问题排查与修复方案 #

• 循环序列化问题：双向关联结构会导致JSON序列化时触发无限递归，直接表现为接口返回栈溢出错误或嵌套层级过深的异常数据。可在Department类的employees属性上添加@JsonIgnore注解，打断序列化循环链。
• 懒加载配置错误：Department类的employees属性配置了FetchType.EAGER，每次查询部门时都会强制查询关联的所有员工数据，不仅带来额外性能开销，还会和自定义的关联查询产生重复查询逻辑，建议修改为默认的FetchType.LAZY，按需加载员工列表。
• 字段命名不规范：Department类的Departmentname、Address字段首字母大写，不符合Java驼峰命名规范，会导致序列化后返回的字段名和预期不符、参数绑定失败等问题，建议修改为departmentName、address。
• 关联关系维护缺失：保存双向关联数据时，需要同时维护两边的关联关系，比如给Employee设置Department后，也要调用Department的addEmployees方法将当前员工加入列表，否则会出现数据库关联字段正常，但内存中实体属性不一致的问题。

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