开发者

Function delete in database?

开发者 https://www.devze.com 2023-03-03 10:02 出处:网络
Can anyone help me to write the function for deleting from my database? This is my code : public class ShopsHelper extends SQLiteOpenHelper {

Can anyone help me to write the function for deleting from my database? This is my code :

public class ShopsHelper extends SQLiteOpenHelper {
    private static final String DATABASE_NAME="shops.db";
    private static final int SCHEMA_VERSION=1;
    public SQLiteDatabase db;
    public ShopsHelper(Context context) {
    super(context, DATABASE_NAME, null, SCHEMA_VERSION);
}

@Override
public void onCreate(SQLiteDatabase db) {
    db.execSQL("CREATE TABLE restaurants (_id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT, address TEXT, type TEXT, notes TEXT);");
}

@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
    // no-op, since will not be called until 2nd schema
    // version exists
}

public Cursor getAll() {
    return(getReadableDatabase().rawQuery("SELECT _id, name, addr开发者_StackOverflow社区ess, type, notes FROM restaurants ORDER BY name", null));
}

public void insert(String name, String address,String type, String notes) {
    ContentValues cv=new ContentValues();

    cv.put("name", name);
    cv.put("address", address);
    cv.put("type", type);
    cv.put("notes", notes);

    getWritableDatabase().insert("restaurants", "name", cv);
}

public String getName(Cursor c) {
    return(c.getString(1));
}

public String getAddress(Cursor c) {
    return(c.getString(2));
}

public String getType(Cursor c) {
    return(c.getString(3));
}

public String getNotes(Cursor c) {
    return(c.getString(4));
}
}


Hi, this may help to you..

 int result = db.delete("table_name",column_name=id,null);

 Toast.makeText(this,"Result"+result,2).show();

 // Sucess returns 1 else 0.


Context can be your Activity or Service.

public void deleteDatabase(Context context, String databaseName) {
    ContextWrapper wrapper = new ContextWrapper(context);
    wrapper.deleteDatabase(databaseName);
}
0

精彩评论

暂无评论...
验证码 换一张
取 消