转自:
http://zhangmin.blog.51cto.com/3150069/590782
//查询语句 hql.append("from TripBusAppoinInfo busAppoin where (1=1)"); //设置查询条件 if(!name.equals("")){ hql.append("and lower(busAppoin.busAppoinName) like lower(?) "); param.add("%"+name+"%"); } if(!cardNber.equals("")){ hql.append("and busAppoin.busAppoinMemberNumber = ? "); param.add(cardNber); } hql.append(" Order by busAppoin.busAppoinTime");//排序条件