我想实现的sql : firstname = ?0 and lastname = ?1) or (firstname = ?2 and lastname = ?3)
我的代码:
cb.or(
cb.and(
cb.equal(userJoin.get(User_.NAME), userName1),
cb.equal(userJoin.get(User_.NAME), userName2)
),
cb.and(
cb.equal(userJoin.get(User_.NAME), userName3),
cb.equal(userJoin.get(User_.NAME), userName4)
)
)
以上代码产生的sql:
firstname = ?0 and lastname = ?1 or firstname = ?2 and lastname = ?3
导致了目前条件筛选不正确