/* * Hibernate, Relational Persistence for Idiomatic Java * * License: GNU Lesser General Public License (LGPL), version 2.1 or later. * See the lgpl.txt file in the root directory or <http://www.gnu.org/licenses/lgpl-2.1.html>. */ package org.hibernate.criterion; import java.util.Locale; import org.hibernate.Criteria; import org.hibernate.HibernateException; import org.hibernate.dialect.Dialect; import org.hibernate.engine.spi.TypedValue; /** * A criterion representing a "like" expression * * @author Scott Marlow * @author Steve Ebersole */ public class LikeExpression implements Criterion { private final String propertyName; private final Object value; private final Character escapeChar; private final boolean ignoreCase; protected LikeExpression( String propertyName, String value, Character escapeChar, boolean ignoreCase) { this.propertyName = propertyName; this.value = value; this.escapeChar = escapeChar; this.ignoreCase = ignoreCase; } protected LikeExpression(String propertyName, String value) { this( propertyName, value, null, false ); } @SuppressWarnings("UnusedDeclaration") protected LikeExpression(String propertyName, String value, MatchMode matchMode) { this( propertyName, matchMode.toMatchString( value ) ); } protected LikeExpression( String propertyName, String value, MatchMode matchMode, Character escapeChar, boolean ignoreCase) { this( propertyName, matchMode.toMatchString( value ), escapeChar, ignoreCase ); } @Override public String toSqlString(Criteria criteria,CriteriaQuery criteriaQuery) { final Dialect dialect = criteriaQuery.getFactory().getDialect(); final String[] columns = criteriaQuery.findColumns( propertyName, criteria ); if ( columns.length != 1 ) { throw new HibernateException( "Like may only be used with single-column properties" ); } final String escape = escapeChar == null ? "" : " escape \'" + escapeChar + "\'"; final String column = columns[0]; if ( ignoreCase ) { if ( dialect.supportsCaseInsensitiveLike() ) { return column +" " + dialect.getCaseInsensitiveLike() + " ?" + escape; } else { return dialect.getLowercaseFunction() + '(' + column + ')' + " like ?" + escape; } } else { return column + " like ?" + escape; } } @Override public TypedValue[] getTypedValues(Criteria criteria, CriteriaQuery criteriaQuery) { final String matchValue = ignoreCase ? value.toString().toLowerCase(Locale.ROOT) : value.toString(); return new TypedValue[] { criteriaQuery.getTypedValue( criteria, propertyName, matchValue ) }; } }