android之sqlite增删改查

来源：互联网发布：truelicense源码编辑：程序博客网时间：2024/05/21 07:03
public Uri insert(Uri uri, ContentValues values) {    SQLiteDatabase db=dBhelper.getWritableDatabase();    long rowid=db.insert("student",null,values);    Uri uri2= ContentUris.withAppendedId(uri,rowid);    return uri2;}@Overridepublic int delete(Uri uri, String selection, String[] selectionArgs) {    SQLiteDatabase db=dBhelper.getWritableDatabase();    selection="name=?";    selectionArgs=new String[]{"jack"};    db.delete("student",selection,selectionArgs);    return 0;}@Overridepublic int update(Uri uri, ContentValues values, String selection, String[] selectionArgs) {    SQLiteDatabase db=dBhelper.getWritableDatabase();    ContentValues contentValues=new ContentValues();    contentValues.put("name","gaojiaxin");    selection="name=?";    selectionArgs=new String[]{"mateng"};    db.update("student", contentValues, selection, selectionArgs);    return 0;}@Nullable@Overridepublic Cursor query(Uri uri, String[] projection, String selection, String[] selectionArgs, String sortOrder) {    SQLiteDatabase db=dBhelper.getWritableDatabase();    Cursor c=db.query("student",null,null,null,null,null,null);    return c;}
<------------------------------分隔线----------------------------------------->
测试增删改查代码如下
public void testadd(){    ContentValues values=new ContentValues();    values.put("name", "mateng");    getContext().getContentResolver().insert(contactProvider.connect_uri, values);}public  void testdelete(){   getContext().getContentResolver().delete(contactProvider.connect_uri, null, null);}public void testupdate(){    getContext().getContentResolver().update(contactProvider.connect_uri, null, null, null);}public void testquery(){    Cursor c=getContext().getContentResolver().query(contactProvider.connect_uri,null,null,null,null);    c.moveToFirst();    for(int i=0;i<c.getCount();i++){        c.move(i);        String name = c.getString(c.getColumnIndex("name"));        System.out.println(name);    }}
0 0