android典型代码系列(二)------sqlite数据库操作高级

0_sqlite数据库操作高级:
1. 增加：

create table blacknumber(  _id INTEGER PRIMARY KEY AUTOINCREMENT,  //必须是INTEGER  blacknumber varchar(15),    name varchar(15),   interceptCall INTEGER,  interceptSms INTEGER)

1. 删除：

delete from sms where address='15196651388'delete from sms where address like '%3%'resolver.delete(sms_uri, "address like ?", new String[]{"%"+realNumber+"%"});

3.改动：

update blacknumber set blacknumber="1",name="fanjuan" where blacknumber="15196651388"

4.查找：
4.1 模糊查询

      String condition="%"+contant+"%";    Cursor cursor = db.rawQuery("select blacknumber from blacknumber where blacknumber like ?",new String[]{condition});

4.2 模糊查询

    resolver.delete(sms_uri, "address like ?", new String[]{"%"+realNumber+"%"});