Hibernate不区分大小查询函数(lower)

转自：

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");//排序条件