SpringBootGET方法回傳具有StackOverFlow錯誤的重復值

我正在使用 Spring Boot 構建一個 RESTful API GET 方法，以從資料庫中以 JSON 形式回傳 Bill 物體。預期不會回傳，因為它有許多重復值和 StackOverFlowError。

[{"id":1,"date":"2022-05-20","time":"16:48:06","total":330000.0,"billDetails":[{"billMenuItemID":{"billId":1,"menuItemId":1},"bill":{"id":1,"date":"2022-05-20","time":"16:48:06","total":330000.0,"billDetails":[{"billMenuItemID":{"billId":1,"menuItemId":1},"bill":{"id":1,"date":"2022-05-20","time":"16:48:06","total":330000.0,"billDetails":[{"billMenuItemID":{"billId":1,"menuItemId":1},"bill":{"id":1,"date":"2022-05-20","time":"16:48:06","total":330000.0,"billDetails":[{"billMenuItemID":{"billId":1,"menuItemId":1},"bill":{"id":1,"date":"2022-05-20","time":"16:48:06","total":330000.0,"billDetails":[{"billMenuItemID":{"billId":1,"menuItemId":1},"bill":{"id":1,"date":"2022-05-20","time":"16:48:06","total":330000.0,"billDetails":[{"billMenuItemID":{"billId":1,"menuItemId":1},"bill":{"id":1,"date":"2022-05-20","time":"16:48:06","total":330000.0,"billDetails":[{"billMenuItemID":{"billId":1,"menuItemId":1},"bill":
//continues for eternity

休眠日志：

Hibernate: 
    select
        bill0_.bill_id as bill_id1_0_,
        bill0_.date as date2_0_,
        bill0_.time as time3_0_,
        bill0_.total as total4_0_ 
    from
        bill bill0_
Hibernate: 
    select
        billdetail0_.bill_id as bill_id1_1_0_,
        billdetail0_.menu_item_id as menu_ite2_1_0_,
        billdetail0_.bill_id as bill_id1_1_1_,
        billdetail0_.menu_item_id as menu_ite2_1_1_,
        billdetail0_.quantity as quantity3_1_1_,
        billdetail0_.subtotal as subtotal4_1_1_,
        menuitem1_.menu_item_id as menu_ite1_2_2_,
        menuitem1_.description as descript2_2_2_,
        menuitem1_.img_url as img_url3_2_2_,
        menuitem1_.name as name4_2_2_,
        menuitem1_.price as price5_2_2_,
        menuitem1_.status as status6_2_2_,
        menuitem1_.type as type7_2_2_ 
    from
        bill_detail billdetail0_ 
    inner join
        menu_item menuitem1_ 
            on billdetail0_.menu_item_id=menuitem1_.menu_item_id 
    where
        billdetail0_.bill_id=?

我怎樣才能得到這樣的賬單的回報：

{
  "billId": 1,
  "date": 2022-05-20,
  "time": 16:48:06,
  "total": 330000,
  "billDetails": [
    {
      "menuItem": {
        "id": 1,
        "name": Rice,
        // other attributes of MenuItem
      },
      "quantity": 2
      "subtotal": 90000
    },
    {
      "menuItem": {
        "id": 2
        "name": Wine
        // other attributes of MenuItem
      },
      "quantity": 4
      "subtotal": 240000
    }
    ]
}

這是我的課程和相關功能

班級法案

@Entity(name = "bill")
@Table(name = "bill")
public class Bill {

    @Id
    @GeneratedValue(
            strategy = GenerationType.IDENTITY
    )
    @Column(name = "bill_id")
    private Long id;

    private LocalDate date;
    private LocalTime time;
    private Double total;

    @OneToMany(mappedBy = "bill", cascade = CascadeType.ALL)
    private List<BillDetail> billDetails = new ArrayList<>();

類 MenuItem

@Entity
@Table(name = "menuItem",
        uniqueConstraints = {
                @UniqueConstraint(name = "menu_item_name_unique", columnNames = "name")
        }
)
public class MenuItem {

    @Id
    @GeneratedValue(
            strategy = GenerationType.IDENTITY
    )
    @Column(name = "menu_item_id")
    private Long id;
    private ItemType type;
    private String name;
    private String description;
    private String imgUrl;
    private Double price;
    private MenuItemStatus status = MenuItemStatus.ENABLED;

    @OneToMany(mappedBy = "menuItem", cascade = CascadeType.ALL)
    private List<BillDetail> billDetails = new ArrayList<>();

班級賬單詳情

@Entity
@Table(name = "bill_detail")
public class BillDetail {
    @EmbeddedId
    private BillMenuItemID billMenuItemID = new BillMenuItemID();

    @ManyToOne
    @MapsId("billId")
    @JoinColumn(name = "bill_id")
    private Bill bill;

    @ManyToOne
    @MapsId("menuItemId")
    @JoinColumn(name = "menu_item_id")
    private MenuItem menuItem;

    @Column
    private Long quantity;

    @Column
    private Double subtotal;

獲取方法

@GetMapping
    public List<Bill> getMenuItems() {
        return billService.getBills();
    }

public List<Bill> getBills() {
        return billRepository.findAll();
    }

public interface BillRepository extends JpaRepository<Bill, Long> {
}

資料庫 資料庫

uj5u.com熱心網友回復：

在類中MenuItem，您應該添加注釋@JsonIgnore以防止回傳的 JSON 格式的無限回圈；一個賬單有一個 BillDetails ，一個 BillDetails 有一個 MenuItem ，一個 MenuItem 有一個 BillDetails ，每個 BillDetail 都有一個 MenuItem 串列 ...

@Entity
@Table(name = "menuItem",
        uniqueConstraints = {
                @UniqueConstraint(name = "menu_item_name_unique", columnNames = "name")
        }
)
public class MenuItem {

    @Id
    @GeneratedValue(
            strategy = GenerationType.IDENTITY
    )
    @Column(name = "menu_item_id")
    private Long id;
    private ItemType type;
    private String name;
    private String description;
    private String imgUrl;
    private Double price;
    private MenuItemStatus status = MenuItemStatus.ENABLED;
    
    // ADD JSON IGNORE ANNOTATION HERE :
    @JsonIgnore
    @OneToMany(mappedBy = "menuItem", cascade = CascadeType.ALL)
    private List<BillDetail> billDetails = new ArrayList<>(); 

標籤：爪哇 弹簧靴 休息 jpa 得到

上一篇：更新物體springjpa時的分離物體問題

下一篇：在SpringBoot中將用戶ID插入患者