将动态列添加到实体，而不将其保存到表中

Question

我有一个模型类，如下所示：

package com.example.model;
import java.util.Map;

import javax.persistence.Column;
import javax.persistence.Convert;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;

import com.example.helpers.StringMapConverter;
@Entity
@Table(name = "buildingcompanies")

public class Buildcompanies {
    @Id
    @GeneratedValue(strategy = GenerationType.AUTO)
    private int id;
    @Column(name = "shortname")
    private String shortname;
    @Column(name = "fullname")
    private String fullname;
    @Column(name = "address")
    private String address;
    @Column(name = "telephone")
    private String telephone;
    @Column(name = "website")
    private String website;
    @Column(name = "sociallinks")
      @Convert(converter = StringMapConverter.class)

    private  Map<String, String> sociallinks;
    @Column(name = "foundationyear")
    private String foundationyear;
    
    public Buildcompanies() {

    }

    public Buildcompanies(String shortname, String fullname, String address, String telephone, String website,
            Map<String, String> map, String foundationyear) {
        this.shortname = shortname;
        this.fullname = fullname;
        this.address = address;
        this.telephone = telephone;
        this.website = website;
        this.sociallinks = map;
        this.foundationyear = foundationyear;
    }

    public int getId() {
        return id;
    }

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

    public String getShortname() {
        return shortname;
    }

    public void setShortname(String shortname) {
        this.shortname = shortname;
    }

    public String getFullname() {
        return fullname;
    }

    public void setFullname(String fullname) {
        this.fullname = fullname;
    }

    public String getAddress() {
        return address;
    }

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

    public String getTelephone() {
        return telephone;
    }

    public void setTelephone(String telephone) {
        this.telephone = telephone;
    }

    public String getWebsite() {
        return website;
    }

    public void setWebsite(String website) {
        this.website = website;
    }

    

    public Map<String, String> getSociallinks() {
        return sociallinks;
    }

    public void setSociallinks(Map<String, String> sociallinks) {
        this.sociallinks = sociallinks;
    }

    public String getFoundationyear() {
        return foundationyear;
    }

    public void setFoundationyear(String foundationyear) {
        this.foundationyear = foundationyear;
    }
    
    
    
    
    
    
}

以及控制器中显示输出的方法：

public ResponseEntity<List<Buildcompanies>> getAllCompanies(@RequestParam(required = false) String name) {
      try {
        List<Buildcompanies> companies = new ArrayList<Buildcompanies>();
        int test=0;
        if (name == null)
        {
            buildcompaniesRepository.findAll().forEach(companies::add);
            
        }
        else
          buildcompaniesRepository.findByShortnameContaining(name).forEach(companies::add);

        if (companies.isEmpty()) {
          return new ResponseEntity<>(HttpStatus.NO_CONTENT);
        }

        return new ResponseEntity<>(companies, HttpStatus.OK);
      } catch (Exception e) {
        return new ResponseEntity<>(null, HttpStatus.INTERNAL_SERVER_ERROR);
      }
    }

它确实显示了一个输出，一切都很好：

[
    {
        "id": 81,
        "shortname": "testing",
        "fullname": "test",
        "address": "addrtest",
        "telephone": "380979379992",
        "website": "www.site.com",
        "sociallinks": {
            "facebook": "fb.com"
        },
        "foundationyear": "1991"
    }

]

我想计算每个公司的评级，同时向最终用户显示数据。因此，输出应如下所示：

[
    {
        "id": 81,
        "shortname": "testing",
        "fullname": "test",
        "address": "addrtest",
        "telephone": "380979379992",
        "website": "www.site.com",
        "sociallinks": {
            "facebook": "fb.com"
        },
        "foundationyear": "1991",
"rating": "1.5"
    }
]

是否可以将评级列动态添加到公司列表中，或者我应该在数据库中创建评级列，在控制器中更新其方法，迭代findAll（）结果，并在用户每次尝试访问/列表endpoint时调用它？

Answer 1

您有两个选择：

>

为此，您可以在buildcompanys类中引入一个新属性，并用@Transient注释它。这将表示该属性不需要在DB中持久化，并且JPA不会尝试在表中创建列。

推荐的方法是不使用实体类作为响应对象。理想情况下，您应该有一个域对象，数据库响应应该映射到这个对象。在映射时，您可以应用想要添加到其中的任何自定义详细信息。