4

case R.id.btn update: //修改数据
dbmyHelper.getWritableDatabase():
//要修的数据
values =new ContentValues();
values.put(“phone”, phone =mEtPhone.getText0.toString()); db.update(“information”, values,“name-?”",
new String[](mEtName.getText() toString()));//更新并得到行数 Toast.makeText(this，“信息已修改，Toast.LENGTH_SHORT).show(); db.close(); break;
case R.id.btn delete: //删除数据
dbmyHelpergetWritableDatabase(); db delete “information”,null,null);
Toast.makeText(this,“信息已册除”，Toast.LENGTH_SHORT).show(); mTvShow.setText(”"); db.close(); break;
}
class MyHelper extends SQLiteOpenHelper{
public MyHelper(Context context){
super(context,“itcast.db”,null,1);
@Override
public void onCreate(SQLiteDatabase db){
db.execSQL(“CREATE TABLE information( id INTEGER PRIMARY
KEY AUTOINCREMENT,name VARCHAR(20), phone VARCHAR(20))”);
@Override
Directory
public void onUpgrade(SQLiteDatabase db, int oldversion, int newVersion){
通讯录