java 数据库多条件查询_sql如何实现多个条件查询自由动态拼接

假如我有5个输入框，代表5个查询条件，怎样才能实现根据用户自由输入一个或多个条件的不同而得到不同的查询结果呢？？

public List getCstServiceByPage(int page, int everypage,

CstService ser, String d1, String d2, String status) {

String hql = "select s,c.custName from CstService s,CstCustomer c where s.cstCustomer.custNo=c.custNo and s.svrStatus='"

+ status + "'";

if (ser.getSvrCustName() != null && !ser.getSvrCustName().equals("")) {

hql += " and s.svrCustName like '%" + ser.getSvrCustName() + "%'";

}

if (ser.getSvrTitle() != null && !ser.getSvrTitle().equals("")) {

hql += " and s.svrTitle='" + ser.getSvrTitle() + "'";

}

if (ser.getSvrType() != null && !ser.getSvrType().equals("")) {

if (ser.getSvrType().equals("全部")) {

hql = hql;

} else {

hql += " and s.svrType='" + ser.getSvrType() + "'";

}

}

if (!d1.equals("") && d1 != null && !d2.equals("") && d2 != null) {

hql += " and s.svrCreateDate between to_date('" + d1

+ "','yyyy-mm-dd') and to_date('" + d2 + "','yyyy-mm-dd')";

}

List list = HibernateBaseDao.bypage(hql, page, everypage);

Iterator iter = list.iterator();

List list2 = new ArrayList();

while (iter.hasNext()) {

Object[] obj = (Object[]) iter.next();

CstService service = (CstService) obj[0];

String custName = obj[1].toString();

CstCustomer c = new CstCustomer();

c.setCustName(custName);

service.setCstCustomer(c);

list2.add(service);

}

return list2;

}

穿个对象进去