在springboot JPA中，一对一映射响应只获得值

Question

将返回响应的控制器类的代码：

@RestController
@RequestMapping("/ProcessInfo/1.0.0")
public class RestController {
@ApiOperation(value = "getdeployments", notes = "This REST API is used to get deployments")
    @GetMapping(value = "/getdeployments")
    private List<ActivitiProcessDeployment> getdeployments() {

        return ActivitiGetDeploymentRepository.getDeployment();
    }

下面是具有一对一映射的两个实体类。

 @Entity
@NamedQueries({@NamedQuery(name="ActivitiProcessDeployment.getDeployment", query="SELECT a.id,a.name,a.category,a.tenantId,a.deployTime,b.category,b.key,b.resource_name,b.version,b.deploymentId,b.diagramResourceName,b.description,b.id,b.hasStartFormKey,b.hasGraphicalNotation_,b.suspensionState,b.tenant_id_ FROM ActivitiProcessDeployment a INNER JOIN ActivitiProcessDefinition b ON a.id=b.deploymentId ORDER BY a.id")})
@Table(name="act_re_deployment")
public class ActivitiProcessDeployment implements Serializable{

    /**
     * 
     */
    private static final long serialVersionUID = 1L;

    @Id
    @JsonProperty
    @Column(name="id_")
    private String id;

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

    @JsonProperty
    @Column(name="category_")
    private String category;

    @JsonProperty
    @Column(name="tenant_id_")
    private String tenantId;

    @JsonProperty
    @Column(name="deploy_time_")
    private Date deployTime;

    @JsonProperty
    @OneToOne( cascade = CascadeType.ALL,fetch = FetchType.LAZY)
    @JoinColumn(name="deploymentId", nullable=true)
    private ActivitiProcessDefinition activitiProcessDefinition;
    }

 @Entity
@Table(name="act_re_procdef")
public class ActivitiProcessDefinition implements Serializable {

    /**
     * 
     */
    private static final long serialVersionUID = 1L;

    @JsonProperty("process_def")
    @Id
    @Column(name="id_")
    private String id;

    @JsonIgnore
    @Column(name="rev_")
    private String rev;

    @JsonProperty
    @Column(name="category_")
    private String category;

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

    @JsonProperty
    @Column(name="key_")
    private String key;

    @JsonProperty
    @Column(name="resource_name_")
    private String resource_name;

    @JsonProperty
    @Column(name="version_")
    private String version;

    @JsonProperty
    @Column(name="deployment_id_")
    private String deploymentId;
    }

@Repository
public interface ActivitiGetDeploymentRepository extends JpaRepository<ActivitiProcessDeployment, Long> {

    public List<ActivitiProcessDeployment> getDeployment();

} 

我得到的回应是：

    [
    [
        "1",
        "ExecutionTaskListener",
        null,
        "-1234",
        "2018-10-29T07:31:48.373+0000",
        "http://www.activiti.org/test",
        "myProcess",
        "ExecutionTaskListener.bpmn20.xml",
        "1",
        "1",
        "ExecutionTaskListener.myProcess.png",
        null,
        "myProcess:1:4",
        "f",
        "t",
        "1",
        "-1234"
    ],
    [
        "13",
        "multiinstance (1)",
        null,
        "-1234",
        "2018-10-29T07:31:49.901+0000",
        "http://www.activiti.org/test",
        "multiinstance",
        "multiinstance.bpmn20.xml",
        "1",
        "13",
        "multiinstance.multiinstance.png",
        null,
        "multiinstance:1:16",
        "f",
        "t",
        "1",
        "-1234"
    ],
    [
        "23",
        "testing",
        null,
        "-1234",
        "2018-10-29T07:31:50.591+0000",
        "http://www.activiti.org/test",
        "myProcess",
        "testing.bpmn20.xml",
        "2",
        "23",
        "testing.myProcess.png",
        null,
        "myProcess:2:26",
        "f",
        "t",
        "1",
        "-1234"
    ]
]

如上面的响应所示，我只得到json值，我的意思是只得到没有列名的表值。因此，如何将json响应映射到响应协同响应键上。

Answer 1

我不太确定你在尝试做什么，实际发生了什么（以及为什么可能）。但是可以看到，JSON不是ActivitiProcessDeployment的列表，而是字符串列表。

您的命名查询不返回ActivitiProcessDeployment，而是返回列值列表。没有任何命名查询和如下所示的接口：

public interface ActivitiGetDeploymentRepository
            extends JpaRepository<ActivitiProcessDeployment, Long> {
    public List<ActivitiProcessDeployment> findAllOrderById();
}

你可能会得到更好的结果。它不会像JSON那样平坦，但ActivitiProcessDefinition将嵌套在ActivitiProcessDeployment中。

如果你需要做投影，请看这个问题和答案。