JPA - Criteria Query - 使用"like"搜索整数

// 定义一个实体类
@Entity
public class Customer {
    @Id
    private Long id;
    private String name;
    private Integer age;

    // getters and setters
}

// 定义一个 CriteriaQuery 接口实现类
public class CustomerCriteriaQuery {
    public CriteriaQuery<Customer> createCriteriaQuery() {
        CriteriaBuilder builder = entityManager.getCriteriaBuilder();
        CriteriaQuery<Customer> criteriaQuery = builder.createQuery();
        Root<Customer> root = criteriaQuery.from(Customer.class);

        // 添加一个 "like" 模糊搜索条件
        criteriaQuery.where(builder.like(root.get("name"), "%" + searchTerm + "%"));

        // 定义排序条件
        criteriaQuery.orderBy(builder.asc(root.get("name")));

        return criteriaQuery;
    }
}

// 调用 CriteriaQuery 实现类进行查询
public List<Customer> getCustomersBySearchTerm(String searchTerm) {
    CustomerCriteriaQuery customerCriteriaQuery = new CustomerCriteriaQuery();
    return customerCriteriaQuery.createCriteriaQuery().getResultList();
}