多条件组合查询

方法一：

//多条件组合查询
    public List<Customer> findMoreCondition(Customer customer) {
        //1-使用hibernate模板里面find方法实现
        //拼接hql语句
        String hql = "from Customer where 1=1";
        //创建list集合，如果值不为空，就把值设置到list里面
        List<Object> p = new ArrayList<Object>();
        //判断条件值是否为空，如果不为空就拼接
        if(customer.getCustName()!=null && !"".equals(customer.getCustName())){
            hql += " and custName=?";
            p.add(customer.getCustName());
        }
        if(customer.getCustLevel()!=null && !"".equals(customer.getCustLevel())){
            hql += " and custLevel=?";
            p.add(customer.getCustLevel());
        }
        if(customer.getCustSource()!=null && !"".equals(customer.getCustSource())){
            hql += " and custSource=?";
            p.add(customer.getCustSource());
        }
        System.out.println("hql:"+hql);
        System.out.println("list:"+p);
        return (List<Customer>) this.getHibernateTemplate().find(hql, p.toArray());
    }

方法二（使用较多）：

public List<Customer> findMoreCondition(Customer customer) {
        //2.使用离线对象
        DetachedCriteria criteria = DetachedCriteria.forClass(Customer.class);
        //判断条件值是否为空
        if(customer.getCustName()!=null&&!"".equals(customer.getCustName())){
            //对属性设置值
            criteria.add(Restrictions.eq("custName", customer.getCustName()));
        }
        /*if(customer.getCustLevel()!=null && !"".equals(customer.getCustLevel())){
            criteria.add(Restrictions.eq("custLevel", customer.getCustLevel()));
        }*/
        if(customer.getCustSource()!=null && !"".equals(customer.getCustSource())){
            criteria.add(Restrictions.eq("custSource", customer.getCustSource()));
        }

        return (List<Customer>) this.getHibernateTemplate().findByCriteria(criteria);
    }