java - 参数不作为命名参数存在

Question

我的查询是这样的:

Query query1 = session.createQuery("select c.email from Contact c where c.contactNo =:contactNo");
    query1.setInteger("contactNo", 22);

我得到的错误是:

Exception in thread "main" java.lang.IllegalArgumentException: Parameter contactNo does not exist as a named parameter in [select c.email from Contact c where c.contactNo = ?]

它工作正常

Query query = session.createQuery("select c.email from Contact c where c.contactNo = ?");
    query.setInteger(0, 22);

为什么第一个查询不起作用？

Answer 1

Query query1 = session.createQuery("select c.email from Contact c where c.contactNo =:contactNo");
query.setParameter("contactNo", 22);

尝试使用 setParameter 而不是 setInteger