(User.class).field("id").equal(1306907246519L), uo, true).getUpdatedCount());
user.setId(1306907246518L);
print("updateFirst: " + ds.updateFirst(ds.createQuery(User.class).field("id").equal(1306907246518L), user, true).getUpdatedCount());
user.setId(1306916670518L);
// 合并
print("merge: " + ds.merge(user).getId());
this.query();
//删除
print("delete: " + ds.delete(ds.createQuery(User.class).field("id").equal(1306907246518L)).getN());
print("delete: " + ds.delete(ds.find(User.class, "age", 29).get()).getN());
//print("delete: " + ds.delete(User.class, 1306911594631L).getN());
//print("delete: " + ds.delete(User.class, users).getN());
//ds.delete(ds.createQuery(User.class));
this.query();
}
3、Find查询操作
/**
* function: find查询
* @author hoojo
* @createDate 2012-2-16 下午10:45:55
*/
@Test
public void testFind() {
print("find: " + ds.find(User.class).asList());
//like
print("find-contains: " + ds.find(User.class).field("name").contains("test-1").asList());
//忽略大小写
print("find-containsIgnoreCase: " + ds.find(User.class).field("name").containsIgnoreCase("ja").asList());
print("find-endsWith: " + ds.find(User.class).field("name").endsWith("22").asList());
print("find-endsWithIgnoreCase: " + ds.find(User.class).field("name").endsWithIgnoreCase("CK").asList());
//过滤null或是没有name属性的
print("find-doesNotExist: " + ds.find(User.class).field("name").doesNotExist().asList());
//查询name有值的数据
print("find-doesNotExist: " + ds.find(User.class).field("name").exists().asList());
//age > 48
print("find-greaterThan: " + ds.find(User.class).field("age").greaterThan(66).asList());
//age >= 48
print("find-greaterThan: " + ds.find(User.class).field("age").greaterThanOrEq(66).asList());
List ageList = new ArrayList();
ageList.add(22);
ageList.add(55);
ageList.add(66);
//all
print("find-hasAllOf: " + ds.find(User.class).field("age").hasAllOf(ageList).asList());
//in
print("find-hasAnyOf: " + ds.find(User.class).field("age").hasAnyOf(ageList).asList());
//not in
print("find-hasNoneOf: " + ds.find(User.class).field("age").hasNoneOf(ageList).asList());
//elemMatch
//print("find-hasThisElement: " + ds.find(User.class).field("age").hasThisElement(55).asList());
print("find-hasThisOne: " + ds.find(User.class).field("age").hasThisOne(55).asList());
print("find-in: " + ds.find(User.class).field("age").in(ageList).asList());
print("find-lessThan: " + ds.find(User.class).field("age").lessThan(20).asList());
print("find-lessThanOrEq: " + ds.find(User.class).field("age").lessThanOrEq(18).asList());
//print("find-lessThanOrEq: " + ds.find(User.class).field("age").near(.2, .8).asList());
print("find: " + ds.find(User.class, "id", 1306813979609L).get());
print("find: " + ds.find(User.class, "age", 28, 1, 2).asList());
print("findAndDelete: " + ds.findAndDelete(ds.createQuery(User.class).field("id").equal(1306813979609L)));
print("find: " + ds.find(User.class).asList());
}
4、Query查询操作
/**
* function: query查询
* @author hoojo
* @ |