JPA 原生sql多条件查询

 

 

public List<OrgCustomize> findByNameLike(String name, String customerId,Integer type) {

        StringBuilder sb = new StringBuilder();
        StringBuilder condition = new StringBuilder();
        sb.append("select e.* from org_customize e left join org_customize_ref t on t.org_customize_id = e.id where 1 = 1  ");
        if (!StringUtils.isEmpty(customerId)) {
            condition.append("and t.customer_id = '" + customerId + "' ");
        }
        if (!StringUtils.isEmpty(name)) {
            condition.append("and e.name like '%" + name + "%' ");
        }
        if (StringUtils.isEmpty(type)) {
            condition.append("and t.type = "+type+" ");
        }
        sb.append(condition).append(" order by id desc  ");

        Query query = entityManager.createNativeQuery(sb.toString(),OrgCustomize.class);
        List<OrgCustomize> list = query.getResultList();
        return list;
}