/**
* search from the table who's name like p%.
*
* @throws Exception to Junit
*/
public void testsearch_accuracy10() throws Exception {
LikeFilter filter = new LikeFilter("peopleName", "SW:p", '!');
// search depend the filter
CustomResultSet result =
(CustomResultSet) strategy.search(CONTEXT, filter, new ArrayList(), aliasMap);
List list = new ArrayList();
// get the result
while (result.next()) {
list.add(result.getString("peopleName"));
}
assertEquals("There are 9 prople with BetweenFilter", 9, list.size());
}
/**
* search from the table who's weight < 31.
*
* @throws Exception to Junit
*/
public void testsearch_accuracy5() throws Exception {
LessThanFilter lessThanFilter = new LessThanFilter("The weight", new Integer(31));
// search depend the filter
CustomResultSet result =
(CustomResultSet) strategy.search(CONTEXT, lessThanFilter, new ArrayList(), aliasMap);
List list = new ArrayList();
// get the result
while (result.next()) {
list.add(result.getString("peopleName"));
}
assertEquals("There are 4 prople with weight < 31", 4, list.size());
}
/**
* search from the table who's age = 10.
*
* @throws Exception to Junit
*/
public void testsearch_accuracy1() throws Exception {
EqualToFilter equalToFilter = new EqualToFilter("The age", new Integer(10));
// search depend the filter
CustomResultSet result =
(CustomResultSet) strategy.search(CONTEXT, equalToFilter, new ArrayList(), aliasMap);
List list = new ArrayList();
// get the result
while (result.next()) {
list.add(result.getString("peopleName"));
}
assertEquals("There are 2 prople with age = 10", 2, list.size());
}
/**
* search from the table who's age = 10 or weight > 30.
*
* @throws Exception to Junit
*/
public void testsearch_accuracy3() throws Exception {
EqualToFilter equalToFilter = new EqualToFilter("The age", new Integer(10));
GreaterThanFilter greaterThanFilter = new GreaterThanFilter("The weight", new Integer(30));
OrFilter orFilter = new OrFilter(equalToFilter, greaterThanFilter);
// search depend the filter
CustomResultSet result =
(CustomResultSet) strategy.search(CONTEXT, orFilter, new ArrayList(), aliasMap);
List list = new ArrayList();
// get the result
while (result.next()) {
list.add(result.getString("peopleName"));
}
assertEquals("There are 6 prople with age = 10 or weight > 30", 6, list.size());
}
/**
* search from the table who's name in 'p1' or 'p9'.
*
* @throws Exception to Junit
*/
public void testsearch_accuracy8() throws Exception {
List values = new ArrayList();
values.add("p1");
values.add("p9");
InFilter filter = new InFilter("peopleName", values);
// search depend the filter
CustomResultSet result =
(CustomResultSet) strategy.search(CONTEXT, filter, new ArrayList(), aliasMap);
List list = new ArrayList();
// get the result
while (result.next()) {
list.add(result.getString("peopleName"));
}
assertEquals("There are 2 prople with Infilter", 2, list.size());
}