GRAILS中Criteria的OR的写法

发布时间：2020-12-14 16:51:31 所属栏目：大数据来源：网络整理

导读：Java代码 ? Person.withCriteria?{??? ????or?{??? ????????and?{??? ????????????eq? 'lastName' ,? 'Winter' ??? ????????????eq? 'firstName' ,? 'Johnny' ??? ????????}??? ????????and?{??? ????????????eq? 'lastName' ,? 'Brown' ??? ????????????eq?

Java代码 ?

收藏代码

Person.withCriteria?{???
????or?{???
????????and?{???
????????????eq?'lastName',?'Winter'???
????????????eq?'firstName',?'Johnny'???
????????}???
????????and?{???
????????????eq?'lastName',?'Brown'???
????????????eq?'firstName',?'Jeff'???
????????}???
????}???
}???

上面的语言将对应如下SQL语句

Sql代码 ?

收藏代码

select???
????this_.id?as?id0_0_,???
????this_.version?as?version0_0_,???
????this_.last_name?as?last3_0_0_,???
????this_.first_name?as?first4_0_0_???
from???
????person?this_???
where???
????(???
????????(???
????????????this_.last_name='Winter'???
????????????and?this_.first_name='Johnny'???
????????)???
????????or?(???
????????????this_.last_name='Brown'???
????????????and?this_.first_name='Jeff'???
????????)???
????) ??

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!