public class MainActivity extends Activity {
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);
// 建库
DbUtils db = DbUtils.create(this, "user1");
try {
// 建表
db.createTableIfNotExist(User.class);
User u = new User();
u.setAge(18);
u.setName("加雷斯");
// 增加
//db.save(u);
//db.save(u);
//db.save(u);
// 修改
User u1 = new User();
u1.setId(2);
u1.setAge(20);
u1.setName("朗拿度");
// 更新单个数据,对象一定设置ID
//db.update(u1);
//db.update(u1, "age", "name");
// 根据条件更新数据
User u2 = new User();
u2.setAge(28);
u2.setName("詹姆斯");
WhereBuilder wb = WhereBuilder.b("age", ">=", 19);
db.update(u2, wb, "age","name");
// 删除
WhereBuilder wb1 = WhereBuilder.b("age", ">=", 19);
wb1.and("name", "like", "%姆%");
db.delete(User.class, wb1);
// 根据条件查询
Selector s = Selector.from(User.class);
s.where("age", "<", 20);
s.or("id", ">", 3);
//db.findAll(s);
// 查询所有
List
l = db.findAll(s);
for (User user : l) {
Log.i("user", user + "");
}
} catch (DbException e) {
e.printStackTrace();
}
}
}
DbUtils
最新推荐文章于 2016-06-01 16:09:08 发布