DbUtils

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();
		}
	}
}