SQLITE sql = new SQLITE(getContext());
sql.SQL_QueryData("UPDATE giohang SET SoLuong = 1 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