android sqlite數(shù)據(jù)庫(kù) 刪除數(shù)據(jù)
- where后跟條件表達(dá)式 =,!=,>,<,>=,<=
- 多條件 and or
直接看代碼
/**
* 方法刪除數(shù)據(jù)庫(kù)數(shù)據(jù)
*/
public void deletePersonData(PersonModel model)
{
//where后跟條件表達(dá)式 =,!=,>,<,>=,<=
//多條件 and or
//刪除數(shù)據(jù)庫(kù)里的model數(shù)據(jù) 因?yàn)開id具有唯一性。
getWritableDatabase().delete(TABLE_NAME_PERSON,VALUE_ID+"=?",new String[]{""+model.getId()});
//刪除數(shù)據(jù)庫(kù)里 _id = 1 的數(shù)據(jù)
getWritableDatabase().delete(TABLE_NAME_PERSON,VALUE_ID+"=?",new String[]{"1"});
//刪除 age >= 18 的數(shù)據(jù)
getWritableDatabase().delete(TABLE_NAME_PERSON,VALUE_AGE+">=?",new String[]{"18"});
//刪除 id > 5 && age <= 18 的數(shù)據(jù)
getWritableDatabase().delete(TABLE_NAME_PERSON,VALUE_ID+">?"+" and "+VALUE_AGE +"<=?",new String[]{"5","18"});
//刪除 id > 5 || age <= 18 的數(shù)據(jù)
getWritableDatabase().delete(TABLE_NAME_PERSON,VALUE_ID+">?"+" or "+VALUE_AGE +"<=?",new String[]{"5","18"});
//刪除數(shù)據(jù)庫(kù)里 _id != 1 的數(shù)據(jù)
getWritableDatabase().delete(TABLE_NAME_PERSON,VALUE_ID+"!=?",new String[]{"1"});
//刪除所有 _id >= 7 的男生
getWritableDatabase().delete(TABLE_NAME_PERSON,VALUE_ISBOY+"=?"+" and "+VALUE_ID+">=?",new String[]{"1","7"});
//刪除所有 _id >= 7 和 _id = 3 的數(shù)據(jù)
getWritableDatabase().delete(TABLE_NAME_PERSON,VALUE_ID+">=?"+" or "+VALUE_ID+"=?",new String[]{"7","3"});
}
/**
* sql刪除數(shù)據(jù)庫(kù)數(shù)據(jù)
*/
public void deletePersonDataSql(PersonModel model)
{
//條件表達(dá)式 =,!=,>,<,>=,<=
//語(yǔ)法格式 delete from 表名 where 字段 條件表達(dá)式 '值'
//語(yǔ)法示例 delete from person where _id='2'
//多條件 delete from person where _id>'10' and age>'100'
//多條件 delete from person where _id>'10' or _id<'5'
//刪除數(shù)據(jù)庫(kù)里的model數(shù)據(jù) 因?yàn)開id具有唯一性羡忘。
String sql1 = "delete from "+TABLE_NAME_PERSON+" where "+
VALUE_ID+"="+"'"+model.getId()+"'";
//刪除數(shù)據(jù)庫(kù)里 _id = 1 的數(shù)據(jù)
String sql2 = "delete from "+TABLE_NAME_PERSON+" where "+
VALUE_ID+"="+"'"+1+"'";
//刪除 age >= 18 的數(shù)據(jù)
String sql3 = "delete from "+TABLE_NAME_PERSON+" where "+
VALUE_AGE+">="+"'"+18+"'";
//刪除 id > 5 && age <= 18 的數(shù)據(jù)
String sql4 = "delete from "+TABLE_NAME_PERSON+" where "+
VALUE_ID+">"+"'"+5+"'"+" and "+
VALUE_AGE+"<="+"'"+18+"'";
////刪除 id > 5 || age <= 18 的數(shù)據(jù)
String sql5 = "delete from "+TABLE_NAME_PERSON+" where "+
VALUE_ID+">"+"'"+5+"'"+" or "+
VALUE_AGE+"<="+"'"+18+"'";
//刪除數(shù)據(jù)庫(kù)里 _id != 1 的數(shù)據(jù)
String sql6 = "delete from "+TABLE_NAME_PERSON+" where "+
VALUE_ID+"!="+"'"+1+"'";
//刪除所有 _id >= 7 的男生
String sql7 = "delete from "+TABLE_NAME_PERSON+" where "+
VALUE_ID+">="+"'"+7+"'"+" and "+
VALUE_ISBOY +"="+"'"+1+"'";
//刪除所有 _id >= 7 和 _id = 3 的數(shù)據(jù)
String sql8 = "delete from "+TABLE_NAME_PERSON+" where "+
VALUE_ID+">="+"'"+7+"'"+" and "+
VALUE_ID+"="+"'"+3+"'";
Log.e(TAG, ""+sql7 );
getWritableDatabase().execSQL(sql7);
}
刪除表中全部數(shù)據(jù)
getWritableDatabase().delete(TABLE_NAME_PERSON, null, null);
刪除表
getWritableDatabase().execSQL(“DROP TABLE ”+TABLE_NAME_PERSON);
sqlite也無(wú)非就創(chuàng)建山卦、增蚣常、刪佩憾、改宇挫、查肩榕、更新塘雳。
