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