SQLite 通过id删除与修改

删除

ListView 点击弹出弹框确定删除

mAddressLv.setOnItemClickListener(new AdapterView.OnItemClickListener() { @Override public void onItemClick(AdapterView<?> parent, View view, final int position, long id) { final AlertDialog.Builder builder = new AlertDialog.Builder(AddressActivity.this); builder.setTitle("是否删除"); builder.setCancelable(false); builder.setPositiveButton("确定", new DialogInterface.OnClickListener() { @Override public void onClick(DialogInterface dialog, int which) { int id1 = mList.get(position).getId(); String sql = "delete from address where id = " + id1; writableDatabase.execSQL(sql); mList.clear(); getData(); changer(); } }); builder.setNegativeButton("取消", new DialogInterface.OnClickListener() { @Override public void onClick(DialogInterface dialog, int which) { dialog.dismiss(); } }); builder.show(); } });

修改

长按通过SharedPreferences携带数据跳转到修改页面

mAddressLv.setOnItemLongClickListener(new AdapterView.OnItemLongClickListener() { @Override public boolean onItemLongClick(AdapterView<?> parent, View view, final int position, long id) { SharedPreferences sp = getSharedPreferences("addressid", MODE_APPEND); SharedPreferences.Editor edit = sp.edit(); edit.putInt("id", mList.get(position).getId()); edit.putInt("img", mList.get(position).getImg()); edit.putString("name", mList.get(position).getName()); edit.putString("phone", mList.get(position).getPhone()); edit.apply(); Intent intent = new Intent(AddressActivity.this, AddressUpdateActivity.class); startActivity(intent); finish(); return false; } });

修改页面获取数据并显示

SharedPreferences sp = getSharedPreferences("addressid", MODE_APPEND); SharedPreferences.Editor edit = sp.edit(); id = sp.getInt("id", 0); int img = sp.getInt("img", 0); String name = sp.getString("name", ""); String phone = sp.getString("phone", ""); mAddressUpdateName.setText(name); mAddressUpdatePhone.setText(phone); mAddressUpdateImg.setImageResource(img);

点击修改并返回主页面

String name = mAddressUpdateName.getText().toString().trim(); String phone = mAddressUpdatePhone.getText().toString().trim(); if (TextUtils.isEmpty(name)) { Toast.makeText(getApplicationContext(), "请输入姓名", Toast.LENGTH_SHORT).show(); return; } if (TextUtils.isEmpty(phone)) { Toast.makeText(getApplicationContext(), "请输入电话号码", Toast.LENGTH_SHORT).show(); return; } ContentValues values = new ContentValues(); values.put("name", name); values.put("phone", phone); values.put("img", imgList[imgId]); writableDatabase.update("address", values, "id=?", new String[]{id + ""}); Intent intent1 = new Intent(AddressUpdateActivity.this, AddressActivity.class); startActivity(intent1); finish();