Hibernate命名查询customers.amountDeposit、amountWithdraw报错如何解决?
报错原因
- 语法错误(核心启动报错原因):你编写的HQL语句WHERE子句不符合语法规则,当前写的
where :customerAccNo只是单纯传入参数,没有指定字段匹配规则,正确写法应该是where customerAccNo = :customerAccNo。 - 参数不匹配错误:你的命名查询中并没有定义
:customerBalance这个参数,但在DAO层代码中调用了query.setParameter("customerBalance",...)传入了不存在的参数,也会导致查询校验失败。 - 额外注意:如果要执行更新类的HQL,需要在对应调用方法上加
@Modifying注解,标识这是一个写操作,否则执行阶段也会抛出异常。
修复方案
1. 修正NamedQueries定义
@NamedQueries({ @NamedQuery(name = "customers.amountWithdraw", query = "update Customer set customerBalance = customerBalance - :amount where customerAccNo = :customerAccNo"), @NamedQuery(name = "customers.amountDeposit", query = "update Customer set customerBalance = customerBalance + :amount where customerAccNo = :customerAccNo") })
注意:HQL中使用的是实体类名(上面示例中的Customer要和你实际的实体类名保持一致),不是数据库表名,如果你之前写的是表名customers也要同步修正
2. 修正DAO层代码,删除多余的参数设置
public Customer amountWithdraw(Customer customer,double amount) { customer=(Customer) session.get(Customer.class, customer.getCustomerAccNo()); if(customer!=null) { Query query = session.getNamedQuery("customers.amountWithdraw"); // 删除不存在的customerBalance参数设置行 query.setParameter("amount", amount ); query.setParameter("customerAccNo",customer.getCustomerAccNo()); query.executeUpdate(); customer=getCustomerByAccNo(customer.getCustomerAccNo()); return customer; } return null; } public Customer amountDeposit(Customer customer, double amount) { customer=(Customer) session.get(Customer.class, customer.getCustomerAccNo()); if(customer!=null) { Query query = session.getNamedQuery("customers.amountDeposit"); // 删除不存在的customerBalance参数设置行 query.setParameter("amount", amount ); query.setParameter("customerAccNo",customer.getCustomerAccNo()); query.executeUpdate(); customer=getCustomerByAccNo(customer.getCustomerAccNo()); return customer; } return null; }
内容的提问来源于stack exchange,提问作者user16675338
相关产品推荐
相关产品推荐

