简单的数据库增删改查语句

      DBHelper.dh=new DBHelper(con);

     SQLiteDatabase sr= dh.getWritableDatabase();

1.增

               sr.execSQL("insert into student  values(?,?,?)",new String[]{String.valueOf(u.getId()),u.getName(),u.getAge()});

               db.execSQL("insert into student (name,age)values('李四',26)");

                ContentValues cs = new ContentValues();
cs.put("name", "王五");
cs.put("age", 22);
db.insert("student", null, cs);

2.删

              db.delete("student", "id%2=0", null);

3.改

               db.execSQL("update student set age=age+7 where id=2");
ContentValues values=new ContentValues();
values.put("name", "刘欣茹美女");
values.put("age", 16);

4.查

               Cursor rawQuery = db.rawQuery("select *from student",null);
 ArrayList<student> l = new ArrayList<student>();
while(rawQuery.moveToNext()){
s = new student(rawQuery.getInt(0),rawQuery.getString(1), rawQuery.getInt(2));
l.add(s);
}