来自不同来源的HIbernate JPA查询没有生成正确的Jackson JSON响应

Question

我正在从多个表/POJO中检索数据。我想要JSON格式的数据。在Pojo类中，我使用@JsonProperty。但我仍然没有得到所需格式的结果Json。我的结果是：

[["2017 Sprint 1","Android development",23/12/2016,16/01/2017]]

我想要格式的结果 { “迭代”： “2017 Sprint 1”， “project”： “MDM - Core”

我的主控制器方法：

@Controller
@RequestMapping("/json/retrospective")
public class MainControllerClass 
{
    @RequestMapping(value="{userid}", method = RequestMethod.GET,produces=MediaType.APPLICATION_JSON_VALUE)
    @ResponseBody
    public List<Details> getInfoInJSON(@PathVariable int userid)
    {
        Configuration con = new Configuration();
        con.configure("hibernate.cfg.xml");
        SessionFactory SF = con.buildSessionFactory();
        Session session= SF.openSession();
        Query test=session.createQuery("select itr.iteration_name,prj.project_name,itr.isd,itr.ied from RetrospectiveInfo retro,IterationInfo itr,ProjectInfo prj where retro.retrospective_id ="+userid+" and retro.project_id = prj.project_id and retro.iteration_id = itr.iteration_id");
        List<Details> details= test.list();
        session.close();
        SF.close();
        return details;
    }
}

课程详情：

public class Details 
{
    @JsonProperty("iteration")
    private String iteration;
    @JsonProperty("project")
    private String project;
    @JsonProperty("isd")
    private Date isd;
    @JsonProperty("ied")
    private Date ied;


getter/setters

我在buildpath中有3个Jackson JAR注释、数据绑定和最新版本2.8的核心。为什么我会得到这样的结果？？我需要在代码中做哪些更改？？是否要添加任何罐子？？好心帮忙




Answer 1

主要问题是，您正在构造一个 Details 类，该类是使用不同类型的检查从 JPA 查询形成的（错误：无法为具有多个返回的查询创建 TypedQuery）

要解决这个问题，请为所需的JSON属性创建一个构造函数

package com.sof.type;

import com.fasterxml.jackson.annotation.JsonProperty;
import com.fasterxml.jackson.annotation.JsonPropertyOrder;

@JsonPropertyOrder({ "iteration", "project", "isd", "ied"})
public class Details {

    @JsonProperty
    private String iteration;

    @JsonProperty
    private String project;

    @JsonProperty
    private String isd;

    @JsonProperty
    private String ied;

    public Details(String iteration, String project, String isd, String ied) {
        this.iteration = iteration;
        this.project = project;
        this.isd = isd;
        this.ied = ied;
    }

}

那就这样用吧

@PersistenceContext
private EntityManager em;

或者

EntityManagerFactory entityManagerFactory = Persistence.createEntityManagerFactory("com.sof");
EntityManager em = entityManagerFactory.createEntityManager();

具有

List<Details> details = em.createQuery(
        "SELECT NEW  com.sof.type.Details(itr.iteration_name, prj.project_name, itr.isd, itr.ied) " +
        "FROM RetrospectiveInfo retro, " +
        "     IterationInfo itr, " + 
        "     ProjectInfo prj " +
        "WHERE retro.retrospective_id = :userId " +
        "AND retro.project_id = prj.project_id " +
        "AND retro.iteration_id = itr.iteration_id", Details.class)
    .setParameter("userId", userid)
    .getResultList();