You need to enable JavaScript to run this app. Hibernate命名查询customers.amountDeposit、amountWithdraw报错如何解决?
优惠活动
大模型
产品
解决方案
定价
更多

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

相关产品推荐
方舟 Agent Plan

超全模态模型 × Harness 升级,最新支持 Deepseek-V4.1-Flash、GLM-5.3 系列、Doubao-Seedream-5.0-pro、Kimi-K3 (部分), 限时 9.9 元起

最近更新时间:2026.10.08 00:12:02