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);
}
精彩评论