Java StringPath类代码示例

import com.mysema.query.types.path.StringPath; //导入依赖的package包/类
private List<Tuple> datasetColumnAliases(Transaction tx, Expression<?> datasetRel, NumberPath<Integer> datasetRelId, StringPath datasetRelName, int datasetId) {
	final QSourceDatasetVersionColumn sourceDatasetVersionColumnSub = new QSourceDatasetVersionColumn("source_dataset_version_column_sub");
	final QSourceDatasetVersion sourceDatasetVersionSub = new QSourceDatasetVersion("source_dataset_version_sub");
	
	return tx.query().from(datasetRel)
		.join(dataset).on(dataset.id.eq(datasetRelId))
		.join(sourceDatasetVersionColumn).on(sourceDatasetVersionColumn.name.eq(datasetRelName))
		.join(sourceDatasetVersion).on(sourceDatasetVersion.id.eq(sourceDatasetVersionColumn.sourceDatasetVersionId)
			.and(dataset.sourceDatasetId.eq(sourceDatasetVersion.sourceDatasetId)))
		.where(datasetRelId.eq(datasetId))
		.where(new SQLSubQuery().from(sourceDatasetVersionColumnSub)
			.join(sourceDatasetVersionSub).on(sourceDatasetVersionSub.id.eq(sourceDatasetVersionColumnSub.sourceDatasetVersionId))
			.where(sourceDatasetVersionColumnSub.name.eq(sourceDatasetVersionColumn.name))
			.where(sourceDatasetVersionColumnSub.sourceDatasetVersionId.gt(sourceDatasetVersionColumn.sourceDatasetVersionId))
			.where(sourceDatasetVersionSub.sourceDatasetId.eq(dataset.sourceDatasetId))
			.notExists())
		.where(sourceDatasetVersionColumn.alias.isNotNull())
		.orderBy(sourceDatasetVersionColumn.index.desc())
		.list(sourceDatasetVersionColumn.name, sourceDatasetVersionColumn.alias);
}
 

import com.mysema.query.types.path.StringPath; //导入依赖的package包/类
@Test
@Transactional
public void testQuery() throws Exception {

	springfieldQueryTemplateRepository.save(new SpringfieldQueryTemplate("a", 1));
	springfieldQueryTemplateRepository.save(new SpringfieldQueryTemplate("b", 2));
	springfieldQueryTemplateRepository.save(new SpringfieldQueryTemplate("c", 3));
	
	List<SpringfieldQueryTemplate> result = springfieldQueryTemplateRepository.execute(
		new TemplateCallback<List<SpringfieldQueryTemplate>, EntityManager>() {
			public List<SpringfieldQueryTemplate> doInTemplate(EntityManager em) {

				//Using QueryDsl
				SpringfieldQueryTemplate alias = Alias.alias(SpringfieldQueryTemplate.class, "foo");
				EntityPath<SpringfieldQueryTemplate> foo = Alias.$(alias);
				StringPath fooName = Alias.$(alias.getName());
				NumberPath<Integer> fooAge = Alias.$(alias.getAge());
				
				JPAQuery query = new JPAQuery(em);
				query.from(foo);
				query.where(fooName.eq("a"));
				query.where(fooAge.eq(1));

				return query.list(foo);
			}
	});
	Assert.assertEquals(result.size(), 1);
}
 

import com.mysema.query.types.path.StringPath; //导入依赖的package包/类
/**
 * @param path
 * @param builder
 * @param tuple
 * @return
 */
private BooleanExpression handleSearchType(StringPath path,
		G_SearchTuple<String> tuple) {
	BooleanExpression b = null;
	switch (tuple.getSearchType()) {
	case COMPARE_CONTAINS:
		b = path.contains(tuple.getValue());
		break;
	case COMPARE_STARTSWITH:
		b = path.startsWith(tuple.getValue());
		break;
	case COMPARE_ENDSWITH:
		b = path.endsWith(tuple.getValue());
		break;
	case COMPARE_EQUALS:
		b = path.eq(tuple.getValue());
		break;
	case COMPARE_REGEX:
		b = path.matches(tuple.getValue());
		break;
	case COMPARE_SIMPLE:
		b = path.like("%" + tuple.getValue() + "%");
		break;
	default:
		b = path.contains(tuple.getValue());
		break;
	}
	if (b == null) {
		logger.error("Could not make a boolean expression for search type "
				+ tuple.getSearchType());
	}
	return b;
}
 

import com.mysema.query.types.path.StringPath; //导入依赖的package包/类
@Test
public void stringPath() {
	SimplePath<Tuple> aaa = PathExpressions.simplePath("aaa");
	StringPath bbb = PathExpressions.stringPath(aaa, "bbb");
	assertEquals(String.class, bbb.getType());
	assertEquals("bbb", bbb.getMetadata().getName());
	assertEquals(aaa, bbb.getMetadata().getParent());
}
 

import com.mysema.query.types.path.StringPath; //导入依赖的package包/类
StructureProcessor(
	StringPath styleIdentificationPath, 
	StringPath styleNamePath,
	StringPath childLayerIdentificationPath,
	StringPath parentLayerIdentificationPath,
	NumberPath<Integer> layerOrderPath,
	BooleanPath cyclePath) {
	
	this.styleIdentificationPath = styleIdentificationPath;
	this.styleNamePath = styleNamePath;
	this.childLayerIdentificationPath = childLayerIdentificationPath;
	this.parentLayerIdentificationPath = parentLayerIdentificationPath;
	this.layerOrderPath = layerOrderPath;
	this.cyclePath = cyclePath;
}
 

import com.mysema.query.types.path.StringPath; //导入依赖的package包/类
/**
 * 文字列カラムに相当するパスを取得する。
 * 
 * @param parent テーブルのパス。
 * @param property カラムの別名。
 * @return カラムのパス。
 */
public static StringPath stringPath(Path<?> parent, String property) {
	return Expressions.stringPath(parent, property);
}