jpql查询结构，值1与预期类型不匹配

Question

你好，我有两个标签

1.人员表

2.电话号码表

我正试图实现这样的质疑

SELECT * FROM jobs.phonenumber where Person_ID='1';

但是在jpql中。

我试着做一些类似于：

String query="SELECT p1 FROM PhoneNumber p1 WHERE p1.person=:id;

下面是我的实体类的示例：

@Entity
public class PhoneNumber {
    @Id
    @GeneratedValue
    @Column(name = "phoneId")
    private long id;
    @Column(name = "phoneNumber")
    private int number;
    @ManyToOne(fetch=FetchType.LAZY)
    @JoinColumn(name = "Person_ID")
    private Person person;


@Entity
public class Person {
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    @Column(name = "personId")
    private long id;
    @Column(name = "personName")
    private String name;
    @Column(name = "personAge")
    private int age;
    @OneToMany(mappedBy = "person")
    private List<PhoneNumber> phones;

我有一个错误：参数值1与预期类型[model.Person（n/a）]不匹配

下面是我的方法：

@Path("{id}/phones")
@GET
@Produces(MediaType.TEXT_PLAIN)
public List<PhoneNumber> getPhoneNumbers(@PathParam(value = "id") long id) {
    List<PhoneNumber> resultList = new ArrayList<>();
    EntityManager createEntityManager = emf.createEntityManager();
    String query="select p1 from PhoneNumber p1 where p1.person=:id";
    TypedQuery<PhoneNumber> createNamedQuery = createEntityManager.createQuery(query, PhoneNumber.class);
    createNamedQuery.setParameter("id", id);
    try {
        resultList = createNamedQuery.getResultList();
    } catch (Exception e) {
        System.out.println("Could not retrive phone list");
    }
    return resultList;
}

谁能帮我一下，我做错了什么？

Answer 1

您需要使用person.id来查询：

String query="select p1 from PhoneNumber p1 where p1.person.id=:id";

或者先检索这个人，然后将其用作参数：

Person person = createEntityManager.find(Person.class, id);

String query="select p1 from PhoneNumber p1 where p1.person=:id";
TypedQuery<PhoneNumber> createNamedQuery = createEntityManager.createQuery(query, PhoneNumber.class);
createNamedQuery.setParameter("id", person);