Android关系型数据库应用——电话（短信）黑名单

1.打开数据库，创建数据表；

2.对数据进行crud（Create Read Update Delete）；

1.打开数据库，创建数据表；

           1.SQLiteOpenHelper

           2.SQLiteDatabase

                          .execSQL("create table blacknumber (_id integer primary key autoincrement, number varchar(20))");

2.对数据进行crud（Create Read Update Delete）；

           1.增：db.execSQL("insert into blacknumber (number) values(?)", new Object[]{number});

           2.删：db.execSQL("delete from blacknumber where number = ?", new Object[]{number});

           3.改：db.execSQL("update blacknumber set number = ? where number = ?", new Object[]{newnumber,oldnumber})

           4.查：Cursor cursor = db.rawQuery("select * from bl