Java CQL类代码示例

import org.geotools.filter.text.cql2.CQL; //导入依赖的package包/类
/**
 * Display result.
 */
private void displayResult() {
    String result = "";
    if (rootNode instanceof ExpressionNode) {
        overallExpression = addExpression((ExpressionNode) rootNode);

        if (overallExpression != null) {
            result = overallExpression.toString();
        }
    } else if (rootNode instanceof FilterNode) {
        overallFilter = addFilter((FilterNode) rootNode);

        try {
            result = CQL.toCQL(overallFilter);
        } catch (Exception e) {
            // Do nothing
        }
    }

    textArea.setText(result);
}
 

import org.geotools.filter.text.cql2.CQL; //导入依赖的package包/类
/**
 * Display result.
 *
 * @return true, if filter is valid
 */
private boolean displayResult() {
    String result = INVALID_RESULT_STRING;
    if (rootNode instanceof FilterNode) {
        overallFilter = addFilter((FilterNode) rootNode);

        if (overallFilter == null) {
            result = "";
        } else {
            try {
                result = CQL.toCQL(overallFilter);
            } catch (Exception e) {
                // DO nothing
            }
        }
    }

    textArea.setText(result);

    return (result.compareTo(INVALID_RESULT_STRING) != 0);
}
 

import org.geotools.filter.text.cql2.CQL; //导入依赖的package包/类
static Filter createFilter(String geomField, double x0, double y0, double x1, double y1,
                           String dateField, String t0, String t1,
                           String attributesQuery)
        throws CQLException, IOException {

    // there are many different geometric predicates that might be used;
    // here, we just use a bounding-box (BBOX) predicate as an example.
    // this is useful for a rectangular query area
    String cqlGeometry = "BBOX(" + geomField + ", " +
            x0 + ", " + y0 + ", " + x1 + ", " + y1 + ")";

    // there are also quite a few temporal predicates; here, we use a
    // "DURING" predicate, because we have a fixed range of times that
    // we want to query
    String cqlDates = "(" + dateField + " DURING " + t0 + "/" + t1 + ")";

    // there are quite a few predicates that can operate on other attribute
    // types; the GeoTools Filter constant "INCLUDE" is a default that means
    // to accept everything
    String cqlAttributes = attributesQuery == null ? "INCLUDE" : attributesQuery;

    String cql = cqlGeometry + " AND " + cqlDates  + " AND " + cqlAttributes;
    return CQL.toFilter(cql);
}
 

import org.geotools.filter.text.cql2.CQL; //导入依赖的package包/类
static Filter createFilter(String geomField, double x0, double y0, double x1, double y1,
                        String dateField, String t0, String t1,
                        String attributesQuery)
        throws CQLException, IOException {

  // there are many different geometric predicates that might be used;
  // here, we just use a bounding-box (BBOX) predicate as an example.
  // this is useful for a rectangular query area
  String cqlGeometry = "BBOX(" + geomField + ", " +
          x0 + ", " + y0 + ", " + x1 + ", " + y1 + ")";

  // there are also quite a few temporal predicates; here, we use a
  // "DURING" predicate, because we have a fixed range of times that
  // we want to query
  String cqlDates = "(" + dateField + " DURING " + t0 + "/" + t1 + ")";

  // there are quite a few predicates that can operate on other attribute
  // types; the GeoTools Filter constant "INCLUDE" is a default that means
  // to accept everything
  String cqlAttributes = attributesQuery == null ? "INCLUDE" : attributesQuery;

  String cql = cqlGeometry + " AND " + cqlDates  + " AND " + cqlAttributes;
  return CQL.toFilter(cql);
}
 

import org.geotools.filter.text.cql2.CQL; //导入依赖的package包/类
private List<Expression> createExpressionList( String expressionString ) {
    List<Expression> list = new ArrayList<Expression>();

    String definition = expressionString.replaceAll("\r", "\n").replaceAll("[\n\r][\n\r]", "\n");
    for( String line : definition.split("\n") ) {
        int mark = line.indexOf("=");
        if (mark != -1) {
            String expressionDefinition = line.substring(mark + 1).trim();

            Expression expression;
            try {
                expression = CQL.toExpression(expressionDefinition);
            } catch (CQLException e) {
                throw new ModelsRuntimeException(e.toString(), this);
            }
            list.add(expression);
        }
    }
    return list;
}
 

import org.geotools.filter.text.cql2.CQL; //导入依赖的package包/类
/**
 * Create a bounding box filter from the bounds coordinates.
 * 
 * @param attribute the geometry attribute or null in the case of default "the_geom".
 * @param west western bound coordinate.
 * @param east eastern bound coordinate.
 * @param south southern bound coordinate.
 * @param north northern bound coordinate.
 * @return the filter.
 * @throws CQLException
 */
public static Filter getBboxFilter( String attribute, double west, double east, double south, double north )
        throws CQLException {

    if (attribute == null) {
        attribute = "the_geom";
    }

    StringBuilder sB = new StringBuilder();
    sB.append("BBOX(");
    sB.append(attribute);
    sB.append(",");
    sB.append(west);
    sB.append(",");
    sB.append(south);
    sB.append(",");
    sB.append(east);
    sB.append(",");
    sB.append(north);
    sB.append(")");

    Filter bboxFilter = CQL.toFilter(sB.toString());

    return bboxFilter;
}
 

import org.geotools.filter.text.cql2.CQL; //导入依赖的package包/类
private static void beforePredicate() throws Exception{
   	
   	// cql_beforePredicate start
       Before filter = (Before) CQL.toFilter("lastEarthQuake BEFORE 2006-11-30T01:30:00Z");
   	// cql_beforePredicate end
       Utility.prittyPrintFilter(filter);
       
       final SimpleFeature city = DataExamples.getInstanceOfCity();
       Expression leftExpr = filter.getExpression1();
       Expression rightExpr = filter.getExpression2();
       System.out.println("left expression value: " + leftExpr.evaluate(city));
       System.out.println("right expression value: " + rightExpr.evaluate(city));
       
       Boolean result = filter.evaluate(city);
       System.out.println("Result of filter evaluation: " + result);        
}
 

import org.geotools.filter.text.cql2.CQL; //导入依赖的package包/类
private static void afterPredicate() throws Exception{
   	
   	// cql_afterPredicate start
       After filter = (After) CQL.toFilter("lastEarthQuake AFTER 2006-11-30T01:30:00Z");
   	// cql_afterPredicate end
       Utility.prittyPrintFilter(filter);
       
       final SimpleFeature city = DataExamples.getInstanceOfCity();
       Expression leftExpr = filter.getExpression1();
       Expression rightExpr = filter.getExpression2();
       System.out.println("left expression value: " + leftExpr.evaluate(city));
       System.out.println("right expression value: " + rightExpr.evaluate(city));
       
       Boolean result = filter.evaluate(city);
       System.out.println("Result of filter evaluation: " + result);        
}
 

import org.geotools.filter.text.cql2.CQL; //导入依赖的package包/类
private static void afterPredicateGMT3() throws Exception{
   	
   	// cql_afterPredicateGMT3 start
       After filter = (After) CQL.toFilter("lastEarthQuake AFTER 2006-11-30T01:30:00+03:00");
   	// cql_afterPredicateGMT3 end
       Utility.prittyPrintFilter(filter);
       
       final SimpleFeature city = DataExamples.getInstanceOfCity();
       Expression leftExpr = filter.getExpression1();
       Expression rightExpr = filter.getExpression2();
       System.out.println("left expression value: " + leftExpr.evaluate(city));
       System.out.println("right expression value: " + rightExpr.evaluate(city));
       
       Boolean result = filter.evaluate(city);
       System.out.println("Result of filter evaluation: " + result);        
}
 

import org.geotools.filter.text.cql2.CQL; //导入依赖的package包/类
private static void duringPredicate() throws Exception{
   	
   	// cql_duringPredicate start
       During filter = (During) CQL.toFilter("lastEarthQuake DURING 1700-01-01T00:00:00/2011-01-01T00:00:00");
   	// cql_duringPredicate end
       Utility.prittyPrintFilter(filter);
       
       final SimpleFeature city = DataExamples.getInstanceOfCity();
       Expression leftExpr = filter.getExpression1();
       Expression rightExpr = filter.getExpression2();
       System.out.println("left expression value: " + leftExpr.evaluate(city));
       System.out.println("right expression value: " + rightExpr.evaluate(city));
       
       Boolean result = filter.evaluate(city);
       System.out.println("Result of filter evaluation: " + result);        
}
 

import org.geotools.filter.text.cql2.CQL; //导入依赖的package包/类
/**
    * Example using the "contains" intersection matrix.
    *  
    * @throws Exception
    */
   private static void relatePattern() throws Exception{
   	
   	// cql relatePattern start
       Filter filter = CQL.toFilter( "RELATE(geometry, LINESTRING (-134.921387 58.687767, -135.303391 59.092838), T*****FF*)");
   	// cql relatePattern end
	Utility.prittyPrintFilter(filter);
	
       SimpleFeature usa = DataExamples.getInstanceOfCountry();
	
       Boolean result = filter.evaluate(usa);
       System.out.println("Result of filter evaluation: " + result);
	
}
 

import org.geotools.filter.text.cql2.CQL; //导入依赖的package包/类
/**
 * This example shows that ECQL syntax is compatible with CQL.
 * 
 * @throws Exception
 */
static private void comparisonPredicateCQLCompatibility() throws Exception {

    // comparisonCQLCompatibility start
    Filter filter = ECQL.toFilter("POPULTATION >= 1000");
    // comparisonCQLCompatibility end

    // the same syntax, now using CQL parser will produce the same filter
    Filter filterFromCQL = CQL.toFilter("POPULTATION >= 1000");

    if (!filter.equals(filterFromCQL)) {
        throw new Exception("uncompatible ECQL Syntax");
    } else {
        System.out.println("CQL and ECQL have produced the same filter for the predicate \"POPULTATION >= 1000\"");
        Utility.prittyPrintFilter( filter );
    }
}
 

import org.geotools.filter.text.cql2.CQL; //导入依赖的package包/类
private static void example5() throws IOException, CQLException {
    System.out.println("example5 start\n");
    // example5 start
    Map<String, Serializable> params = new HashMap<String, Serializable>();
    params.put("directory", directory);
    DataStore store = DataStoreFinder.getDataStore(params);

    SimpleFeatureSource featureSource = store.getFeatureSource("example");

    Filter filter = CQL.toFilter("name = 'dave'");
    SimpleFeatureCollection features = featureSource.getFeatures(filter);
    System.out.println("found :" + features.size() + " feature");
    SimpleFeatureIterator iterator = features.features();
    try {
        while (iterator.hasNext()) {
            SimpleFeature feature = iterator.next();
            Geometry geometry = (Geometry) feature.getDefaultGeometry();
            System.out.println(feature.getID() + " location " + geometry);
        }
    } catch (Throwable t) {
        iterator.close();
    }

    // example5 end
    System.out.println("\nexample5 end\n");
}
 

import org.geotools.filter.text.cql2.CQL; //导入依赖的package包/类
@Test
public void testDisjoint()
		throws CQLException,
		TransformException,
		ParseException {

	final Filter filter = CQL.toFilter(String.format(
			"DISJOINT(%s, POLYGON((0 0, 0 25, 10 25, 10 0, 0 0)))",
			geomAttributeName));
	final Query query = new Query(
			"type",
			filter);

	final ExtractGeometryFilterVisitorResult result = (ExtractGeometryFilterVisitorResult) query
			.getFilter()
			.accept(
					visitorWithDescriptor,
					null);
	// for non-inclusive filters we can't extract query geometry and
	// predicate
	// assertTrue(Double.isNaN(result.getGeometry().getArea()));
	assertTrue(result.getCompareOp() == null);
}
 

import org.geotools.filter.text.cql2.CQL; //导入依赖的package包/类
@Before
public void setup()
		throws SchemaException,
		CQLException,
		IOException,
		GeoWavePluginException {
	dataStore = createDataStore();
	type = DataUtilities.createType(
			"geostuff",
			"geometry:Geometry:srid=4326,pop:java.lang.Long,when:Date,pid:String");

	dataStore.createSchema(type);
	query = new Query(
			"geostuff",
			CQL
					.toFilter("BBOX(geometry,27.20,41.30,27.30,41.20) and when during 2005-05-19T20:32:56Z/2005-05-19T21:32:56Z"),
			new String[] {
				"geometry",
				"pid"
			});
}