Java CriteriaQuery类代码示例

import org.hibernate.criterion.CriteriaQuery; //导入依赖的package包/类
@Override
public String toSqlString(Criteria criteria, CriteriaQuery criteriaQuery) throws HibernateException
{
	StringBuilder buffer = new StringBuilder();
	buffer.append('(');
	int i = 0;
	for( Criterion crit : criterion )
	{
		if( i != 0 )
		{
			buffer.append(' ');
			buffer.append(op);
			buffer.append(' ');
		}
		buffer.append(crit.toSqlString(criteria, criteriaQuery));
		i++;
	}
	buffer.append(')');
	return buffer.toString();
}
 

import org.hibernate.criterion.CriteriaQuery; //导入依赖的package包/类
public String toSqlString(Criteria criteria, CriteriaQuery criteriaQuery) throws HibernateException {
    Dialect dialect = criteriaQuery.getFactory().getDialect();
    String[] columns = criteriaQuery.getColumnsUsingProjection(criteria, propertyName);
    if (columns.length != 1) {
        throw new HibernateException("rlike may only be used with single-column properties");
    }

    if (dialect instanceof MySQLDialect) {
        return columns[0] + " rlike ?";
    }

    if (isOracleDialect(dialect)) {
        return " REGEXP_LIKE (" + columns[0] + ", ?)";
    }

    if (dialect instanceof PostgreSQL81Dialect) {
        return columns[0] + " ~* ?";
    }

    if (dialect instanceof H2Dialect) {
        return columns[0] + " REGEXP ?";
    }

    throw new HibernateException("rlike is not supported with the configured dialect " + dialect.getClass().getCanonicalName());
}
 

import org.hibernate.criterion.CriteriaQuery; //导入依赖的package包/类
public String toSqlString( Criteria c, CriteriaQuery q )
{
    String initial_hql = query.getQueryString();
    
    //  default query selects whole GlycanSequence objects, which
    //  aren't needed if the Criterion we're returning is just 
    //  going to be used in a subselect.
    int i = initial_hql.indexOf("from ");
    assert i != -1 : initial_hql;
    
    //  so, narrow the select clause:
    // String hql = "select gs.id " + initial_hql.substring( i );
    String hql = "select gs.glycan_sequence_id " + initial_hql.substring( i );
    
    //  translate to SQL
    String subquery_expr_sql = hql; //translateHql2Sql( hql );

    String sql = propertyName 
               + " in ("
               + subquery_expr_sql
               + ")";
               
    return sql;
}
 

import org.hibernate.criterion.CriteriaQuery; //导入依赖的package包/类
@Test
   public void testProjectionOrderShouldTakeAscOrderIntoAccount() {
CriteriaQuery criteriaQuery = EasyMock.createMock(CriteriaQuery.class);
String[] projectionAlias = { "colProjalias" };
EasyMock.expect(
	criteriaQuery.getColumnsUsingProjection((Criteria) EasyMock
		.anyObject(), EasyMock.eq(alias))).andReturn(
	projectionAlias).once();
EasyMock.expect(
	criteriaQuery.getSQLAlias((Criteria) EasyMock.anyObject()))
	.andReturn("this_alias").once();
EasyMock.replay(criteriaQuery);
ProjectionOrder dorder = new ProjectionOrder(alias, true);
String sqlString = dorder.toSqlString(null, criteriaQuery);
assertTrue(sqlString.contains("asc"));
EasyMock.verify(criteriaQuery);
   }
 

import org.hibernate.criterion.CriteriaQuery; //导入依赖的package包/类
@Test
   public void testProjectionOrderShouldHaveAscOrderByDefault() {
CriteriaQuery criteriaQuery = EasyMock.createMock(CriteriaQuery.class);
String[] projectionAlias = { "colProjalias" };
EasyMock.expect(
	criteriaQuery.getColumnsUsingProjection((Criteria) EasyMock
		.anyObject(), EasyMock.eq(alias))).andReturn(
	projectionAlias).once();
EasyMock.expect(
	criteriaQuery.getSQLAlias((Criteria) EasyMock.anyObject()))
	.andReturn("this_alias").once();
EasyMock.replay(criteriaQuery);
ProjectionOrder dorder = new ProjectionOrder(alias);
String sqlString = dorder.toSqlString(null, criteriaQuery);
assertTrue(sqlString.contains("asc"));
EasyMock.verify(criteriaQuery);
   }
 

import org.hibernate.criterion.CriteriaQuery; //导入依赖的package包/类
@Test
   public void testProjectionOrderShouldTakeDescOrderIntoAccount() {
CriteriaQuery criteriaQuery = EasyMock.createMock(CriteriaQuery.class);
String[] projectionAlias = { "colProjalias" };
EasyMock.expect(
	criteriaQuery.getColumnsUsingProjection((Criteria) EasyMock
		.anyObject(), EasyMock.eq(alias))).andReturn(
	projectionAlias).once();
EasyMock.expect(
	criteriaQuery.getSQLAlias((Criteria) EasyMock.anyObject()))
	.andReturn("this_alias").once();
EasyMock.replay(criteriaQuery);
ProjectionOrder dorder = new ProjectionOrder(alias, false);
String sqlString = dorder.toSqlString(null, criteriaQuery);
assertTrue(sqlString.contains("desc"));
EasyMock.verify(criteriaQuery);
   }
 

import org.hibernate.criterion.CriteriaQuery; //导入依赖的package包/类
@Test
   public void testDistanceRestrictionPointDoubleBooleanShouldUseIndexIfUseIndexTrue() {
CriteriaQuery criteriaQuery = EasyMock.createMock(CriteriaQuery.class);
EasyMock.expect(
	criteriaQuery.getColumn((Criteria) EasyMock.anyObject(),
		EasyMock.eq(GisFeature.LOCATION_COLUMN_NAME)))
	.andReturn("").once();
EasyMock.expect(
	criteriaQuery.getSQLAlias((Criteria) EasyMock.anyObject()))
	.andReturn("").once();
EasyMock.replay(criteriaQuery);
DistanceRestriction dr = new DistanceRestriction(GisgraphyTestHelper
	.createPoint(3F, 4F), 4D, true);
String sqlString = dr.toSqlString(null, criteriaQuery);
assertTrue(sqlString.contains(" && "));
EasyMock.verify(criteriaQuery);
   }
 

import org.hibernate.criterion.CriteriaQuery; //导入依赖的package包/类
@Override
public String toSqlString(Criteria criteria, CriteriaQuery criteriaQuery) {

	String[] columns = criteriaQuery.findColumns(getPropiedad(), criteria);
	if (columns.length != 1) {
		throw new HibernateException(
				"NumberLike may only be used with single-column properties");
	}
	SessionFactoryImplementor factory = criteriaQuery.getFactory();

	if (factory.getDialect() instanceof H2Dialect) {
		return "cast(cast(" + columns[0] + " as int) as VARCHAR) "
				+ "like ?";
	} else {
		// XXX ver consistencia entre bases de datos
		return columns[0] + "::text like ?";
	}
}
 

import org.hibernate.criterion.CriteriaQuery; //导入依赖的package包/类
@Override
public String toSqlString(Criteria criteria, CriteriaQuery criteriaQuery) {

	String[] columns = criteriaQuery.findColumns(getPath(), criteria);
	if (columns.length != 1) {
		throw new HibernateException(
				"Regex may only be used with single-column properties");
	}
	SessionFactoryImplementor factory = criteriaQuery.getFactory();

	if (factory.getDialect() instanceof H2Dialect) {
		return columns[0] + " regexp ?";
	} else {
		// XXX ver consistencia entre bases de datos
		return columns[0] + " ~ ?";
	}
}
 

import org.hibernate.criterion.CriteriaQuery; //导入依赖的package包/类
@Override
public String toSqlString(Criteria criteria, CriteriaQuery criteriaQuery) throws HibernateException {
	final String[] lhsColumns = criteriaQuery.findColumns( propertyName, criteria );
	final String[] rhsColumns = criteriaQuery.findColumns( otherPropertyName, criteria );

	List<String> comparisons = new ArrayList<String>(); 
	for (int i = 0; i<lhsColumns.length; i++) {
		String comp = formatExpr(lhsColumns[0], rhsColumns[0], mode);
		comparisons.add(comp);
		
	}
	if ( comparisons.size() > 1 ) {
		return '(' + StringHelper.join( " and ", comparisons.toArray(new String[comparisons.size()]) ) + ')';
	} else {
		return comparisons.get(0);
	}
}
 

import org.hibernate.criterion.CriteriaQuery; //导入依赖的package包/类
/**
 * Private helper method to construct component ids with an optional alias.
 *
 * @param sb
 *            a {@link StringBuffer}
 * @param componentType
 *            the {@link ComponentType}
 * @param criteriaQuery
 *            the {@link CriteriaQuery}
 * @param criteria
 *            the {@link Criteria}
 * @param position
 *            the position of the alias, appened if >= 0
 */
private void appendComponentIds(final StringBuffer sb,
		final ComponentType componentType, final CriteriaQuery criteriaQuery,
		final Criteria criteria, final Integer position)
{
	final String[] idProperties = componentType.getPropertyNames();
	int currPos = position != null ? position.intValue() : -1;
	for (int i = 0; i < idProperties.length; i++)
	{
		sb.append(criteriaQuery.getColumn(criteria, groupByProperty + "."
				+ idProperties[i]));

		if (currPos >= 0)
		{
			sb.append(" as y").append(currPos).append('_');
			currPos++;
		}

		if (i + 1 < idProperties.length)
		{
			sb.append(", ");
		}
	}
}
 

import org.hibernate.criterion.CriteriaQuery; //导入依赖的package包/类
@Override
public TypedValue[] getTypedValues(Criteria criteria, CriteriaQuery criteriaQuery) throws HibernateException
{
	List<TypedValue> values = new ArrayList<TypedValue>();
	for( Criterion crit : criterion )
	{
		values.addAll(Arrays.asList(crit.getTypedValues(criteria, criteriaQuery)));
	}
	return values.toArray(new TypedValue[values.size()]);
}
 

import org.hibernate.criterion.CriteriaQuery; //导入依赖的package包/类
public CriteriaQueryTranslator(
		final SessionFactoryImplementor factory,
        final CriteriaImpl criteria,
        final String rootEntityName,
        final String rootSQLAlias,
        CriteriaQuery outerQuery) throws HibernateException {
	this( factory, criteria, rootEntityName, rootSQLAlias );
	outerQueryTranslator = outerQuery;
}
 

import org.hibernate.criterion.CriteriaQuery; //导入依赖的package包/类
public CustomCriteriaQueryTranslator(
		final SessionFactoryImplementor factory,
		final CustomCriteriaImpl criteria,
		final String rootEntityName,
		final String rootSQLAlias,
		CriteriaQuery outerQuery) throws HibernateException {
	this( factory, criteria, rootEntityName, rootSQLAlias );
	outerQueryTranslator = outerQuery;
}
 

import org.hibernate.criterion.CriteriaQuery; //导入依赖的package包/类
public String toSqlString(Criteria criteria, CriteriaQuery criteriaQuery)
    throws HibernateException {
String columnName = criteriaQuery.getColumn(criteria,
	GisFeature.LOCATION_COLUMN_NAME);
StringBuffer result = new StringBuffer("( st_distance_sphere(").append(
	columnName).append(", ?) <=").append(this.distance).append(")");
return useIndex ? result.append(" AND ").append(
		GisHelper.getBoundingBox(criteriaQuery.getSQLAlias(criteria), this.point
		.getY(), this.point.getX(), distance)).toString()
	: result.toString();

   }