Search This Blog

Thursday, June 9, 2016

Sqlite - xoa dong

SQLITE sql = new SQLITE(getContext());
sql.SQL_QueryData("DELETE FROM giohang WHERE idSanPham = 1");

Tạo class SQLITE.java :



public class SQLITE extends SQLiteOpenHelper {
    public SQLITE(Context context) {
        super(context, "SQLite.sqlite", null, 1);
    }
    @Override
    public void onCreate(SQLiteDatabase db) {
    }
    public Cursor SQLite_GetData(String sql) {
        SQLiteDatabase db = getWritableDatabase();
        Cursor c = db.rawQuery(sql, null);
        return c;
    }
    public void SQL_QueryData(String sql) {
        SQLiteDatabase db = getWritableDatabase();
        db.execSQL(sql);
    }
    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
    }
}

No comments:

Post a Comment