java里case when_java-如何在Hibernate Where子句中使用CASE WHEN

Plase给出了在HQL中使用CASE WHEN的示例.

我在代码中使用了以下查询.

int receiptNumber = 100;

String hql = "SELECT b FROM OOPExtract as b "

+"WHERE "

+" b.tranStatId =" +receiptNumber+ " AND "

+" b.orderType IN ('EMERGENCY', 'PLENARY', 'PETITION','EXTENSION','MOTION') AND "

+" CASE WHEN b.orderType == 'MOTION' " `enter code here`

+ "THEN "

+" b.status = 'MOTION_SIGNED' "

+" ELSE "

+" b.status LIKE '%%' "

+" END "

+" ORDER BY b.oopExtractId DESC";

但是运行时会生成以下异常

org.hibernate.hql.ast.QuerySyntaxException: unexpected token: = …..

解决方法:

这也适用于Hibernate 4 / JPA和Spring 4！

select

limite

from

Limite limite

join

fetch limite.limiteEnqs enq

join

fetch enq.limiteValors valor

where

limite.id = :limiteId

and :dataReferencia between valor.dtIniVig and valor.dtFimVig

and enq.vrAtributo1 = case limite.atributoId1

when 8 then :produtoId

else enq.vrAtributo1

end

标签：hibernate,hql,java,mysql

来源： https://codeday.me/bug/20191120/2042565.html