LiteORM的使用(2)
(3)在LiteOrm_Manager类中定义对进行数据各种操作的函数:
public <T> int save(Collection<T> list) {
LiteOrm l_orm = lite_orm.single();
return l_orm.save(list);
}
public <T> ArrayList<T> query(Class<T> clazz) {
LiteOrm l_orm = lite_orm.single();
return l_orm.query(clazz);
}
public <T> int delete(T t) {
LiteOrm l_orm = lite_orm.single();
return l_orm.delete(t);
}
public <T> int update(T t) {
LiteOrm l_orm = lite_orm.single();
return l_orm.update(t);
}
public <T> long save(T t) {
LiteOrm l_orm = lite_orm.single();
return l_orm.save(t);
}
public <T> int delete(Class<T> clazz) {
LiteOrm l_orm = lite_orm.single();
return l_orm.delete(clazz);
}
public <T> int delete_all(Class<T> clazz) {
LiteOrm l_orm = lite_orm.single();
return l_orm.deleteAll(clazz);
}
public long query_count(QueryBuilder var1) {
LiteOrm l_orm = lite_orm.single();
return l_orm.queryCount(var1);
}
public <T> int delete_by_where_builder(Class<T> clazz, String column, Object value) {
LiteOrm l_orm = lite_orm.single();
return l_orm.delete(new WhereBuilder(clazz).equals(column, value));
}
public <T> int delete_by_where_builder(Class<T> clazz, String column, Object value, String column1, Object value1) {
LiteOrm l_orm = lite_orm.single();
return l_orm.delete(new WhereBuilder(clazz).equals(column, value).and().equals(column1, value1));
}
public <T> int delete_where_builder_by_and_equals(Map<String, Object> where_args, Class<T> clazz) {
LiteOrm l_orm = lite_orm.single();
WhereBuilder builder = new WhereBuilder(clazz);
for (Map.Entry<String, Object> entry : where_args.entrySet()) {
builder.andEquals(entry.getKey(), entry.getValue());
}
return l_orm.delete(builder);
}
public <T> ArrayList<T> query_builder_by_append_and_equal(Map<String, Object> whereArgs, String ascKey, Class<T> clazz) {
LiteOrm l_orm = lite_orm.single();
QueryBuilder builder = new QueryBuilder(clazz);
for (Map.Entry<String, Object> entry : whereArgs.entrySet()) {
builder.whereAppendAnd().whereEquals(entry.getKey(), entry.getValue());
}
if (!TextUtils.isEmpty(ascKey))
builder.appendOrderDescBy(ascKey);
return l_orm.query(builder);
}
public <T> long save_object(T t, Class<T> clazz) {
LiteOrm l_orm = lite_orm.single();
l_orm.delete(clazz);
return save(t);
}
public <T extends Object> T query_object(Class<T> clazz) {
ArrayList<T> list = query(clazz);
if (list != null && list.size() > 0) {
return list.get(0);
}
return null;
}
public <T> ArrayList<T> query_by_equal(String column, Object keyword, Class<T> clazz) {
LiteOrm l_orm = lite_orm.single();
return l_orm.query(new QueryBuilder<>(clazz).whereEquals(column, keyword).appendOrderDescBy("id"));
}
public <T extends Object> T query_object_by_equal(String name, Object keyword, Class<T> clazz) {
ArrayList<T> list = query_by_equal(name, keyword, clazz);
if (list != null && list.size() > 0) {
return list.get(0);
} else {
return null;
}
}
public <T> ArrayList<T> query_by_equal(String column, Object keyword, Class<T> clazz, boolean asc, String ascKey) {
LiteOrm l_orm = lite_orm.single();
if (TextUtils.isEmpty(ascKey)) {
return l_orm.query(new QueryBuilder<>(clazz).whereEquals(column, keyword));
}
if (asc) {
return l_orm.query(new QueryBuilder<>(clazz).whereEquals(column, keyword).appendOrderAscBy(ascKey));
} else {
return l_orm.query(new QueryBuilder<>(clazz).whereEquals(column, keyword).appendOrderDescBy(ascKey));
}
}
public <T> ArrayList<T> query_by_equal(String column, Object keyword, String column1, Object keyword1, Class<T> clazz) {
LiteOrm l_orm = lite_orm.single();
return l_orm.query(new QueryBuilder<>(clazz).where(column + "=?", keyword).whereAnd(column1 + "=?", keyword1));
}

浙公网安备 33010602011771号