inList.add(new Integer("1"));
inList.add(new Integer("2"));
inList.add(new Integer("3"));
query.setFilter(CompositeFilterOperator.and(
new PropertyFilter("col1", FilterOperator.EQUAL, new Integer("1")),
new PropertyFilter("col1", FilterOperator.GREATER_THAN, new Integer("1")),
new PropertyFilter("col1", FilterOperator.GREATER_THAN_OR_EQUAL, new Integer("1")),
new PropertyFilter("col1", FilterOperator.LESS_THAN, new Integer("1")),
new PropertyFilter("col1", FilterOperator.LESS_THAN_OR_EQUAL, new Integer("1")),
new PropertyFilter("col1", FilterOperator.NOT_EQUAL, new Integer("1")),
new PropertyFilter("col1", FilterOperator.IN, inList),
new CompositeFilter(
CompositeFilterOperator.OR,
Arrays.<Filter>asList(new PropertyFilter("col1", FilterOperator.EQUAL, new Integer("1")),
new PropertyFilter("col1", FilterOperator.LESS_THAN_OR_EQUAL, new Integer("1"))))));
jdbcRepository.get(query);
}