使用元模型区分大小写条件的JPA 2 Criteria API [英] JPA 2 Criteria API using metamodel case sensitive condition

问题描述

我有以下代码行来获得基于使用Hibernate 4 API的like语句的结果

I have the following line of code to get the results based on like statement using Hibernate 4 API

Predicate predicate = cb.like(emp.get(EmployeeDetail_.empName),
                empName+"%");

生成的sql语句是

The generated sql statement is

 select employeede0_.EMPLOYEE_NAME as EMPLOYEE1_0_ from EMPLOYEES employeede0_ 
        where employeede0_.EMPLOYEE_NAME like 'smith%'

如何修改我的java代码使EMPLOYEE_NAME小写？生成的sql输出应该如下所示：

How can I modify my java code to have EMPLOYEE_NAME in lower case? The generated sql output should be like the following

select employeede0_.EMPLOYEE_NAME as EMPLOYEE1_0_ from EMPLOYEES employeede0_ 
    where lower(employeede0_.EMPLOYEE_NAME) like lower('smith%')

获取结果的完整代码

   CriteriaBuilder cb = entityManager.getCriteriaBuilder();
        CriteriaQuery<Employee> c = cb.createQuery(Employee.class);
        Root<Employee> emp = c.from(Employee.class);
        c.select(emp);
        List<Predicate> criteria = new ArrayList<Predicate>();
        ParameterExpression<String> pexp = cb.parameter(String.class,
                "empName");
        Predicate predicate = cb.like(emp.get(Employee_.empName),
                empName+"%");
        criteria.add(predicate);

        if (criteria.size() == 1) {
            c.where(criteria.get(0));
        } else if (criteria.size() > 1) {
            c.where(cb.and(criteria.toArray(new Predicate[0])));
        }
        TypedQuery<EmployeeDetail> q = entityManager.createQuery(c);
        data.setResult(q.getResultList());

推荐答案

使用 CriteriaBuilder＃lower（）： / b>

Use CriteriaBuilder#lower():

Predicate predicate = cb.like(cb.lower(emp.get(EmployeeDetail_.empName)),
            empName.toLowerCase() + "%");

这篇关于使用元模型区分大小写条件的JPA 2 Criteria API的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！