SQL delete
刪除資料
public class MainActivity extends AppCompatActivity {
// 資料庫名稱
private final static String db_name = "data.db";
// 資料庫 版本
private final static int version = 1;
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
SQLhelper helper = new SQLhelper(this, db_name, null, version);
SQLiteDatabase db = helper.getWritableDatabase();
//Table_name,刪除的條件,刪除的值
db.delete("user", "value = ?", new String[]{"100"});
//關閉資料庫
db.close();
setContentView(R.layout.activity_main);
}
}