我有一個名為“員工”的實體,它與自己有聯系。聯接表示誰是該員工的經理。當我查詢記錄時,我得到了員工的整個層次結構。我希望實現的是只獲取經理的幾個字段,而不希望獲取員工的經理的經理。我嘗試使用但無法獲得預期的輸出來執行此操作。也使用過。@NamedEntityGraphProjections我還嘗試了這里提到的方法JPA 使用連接表進行自連接自加盟春聯歡注意 - 我不想使用注釋@Query@Entitypublic class Employee { @Id @Column(name = "employeeId", nullable = false) private String employeeId; @Column(name = "firstName", nullable = false) private String firstName; @Column(name = "lastName", nullable = false) private String lastName; @Column(name = "middleName") private String middleName; @Column(name = "dateOfJoining", nullable = false) private LocalDate dateOfJoining; @ManyToOne(cascade = CascadeType.ALL) @JoinColumn(name = "line_manager_id") private Employee manager;}實際結果 -{ "firstName":"Super", "lastName":"Manager", "middleName":"", "dateOfJoining":"2012-12-31", "manager":{ "firstName":"Super", "lastName":"Manager", "middleName":"", "dateOfJoining":"2012-12-31", "manager":{ "firstName":"Admin", "lastName":"User", "middleName":"", "dateOfJoining":"2012-12-31", "manager":{ "firstName":"Admin", "lastName":"User", "middleName":"", "dateOfJoining":"2012-12-31", "manager": null, "employeeId":"P67" }, "employeeId":"P68" }, "employeeId":"P69" }, "employeeId":"P70"}預期成果{ "firstName":"Super", "lastName":"Manager", "middleName":"", "dateOfJoining":"2012-12-31", "manager":{ "firstName":"Super", "lastName":"Manager", "employeeId":"P69" }, "employeeId":"P70"}
添加回答
舉報
0/150
提交
取消