昨天所做:实现主页面的长按删除操作
代码是冲刺完才粘的,可能会和所说的有所不同
//删除账单 public void delete(int id) { Log.i("delete","删除开始 id= "+id); String whereClause = "_id=?"; String[] args = {String.valueOf(id)}; mDB.delete(TABLE_NAME, whereClause, args); Log.i("delete","删除成功"); }
private void showDeleteDialog(final int position) { AlertDialog.Builder builder = new AlertDialog.Builder(this); builder.setTitle("提示"); builder.setMessage("您确定要删除该条记录吗?"); builder.setPositiveButton("确定",new DialogInterface.OnClickListener() { @Override public void onClick(DialogInterface dialog, int which) { db.delete(billlist.get(position).getId()); /* int isOK = db.delete(billlist.get(position).getId()); if (isOK>0) { Toast.makeText(MainActivity.this, "删除成功", Toast.LENGTH_LONG).show(); } else { Toast.makeText(MainActivity.this, "删除失败", Toast.LENGTH_LONG).show(); }*/ Toast.makeText(MainActivity.this, "删除成功", Toast.LENGTH_LONG).show(); dialog.dismiss(); message = mHandler.obtainMessage(); message.what=1; message.arg1=0; message.obj="倒计时:"; mHandler.sendMessage(message); } }); builder.setNegativeButton("取消",new DialogInterface.OnClickListener() { @Override public void onClick(DialogInterface dialog, int which) { dialog.dismiss(); } }); builder.create().show(); }
今天将做:添加“帮助”等到导航栏,并添加它们的点击时间
遇到问题:
mDB.delete(TABLE_NAME,"id=?",args);
中"id=?"报错
后发现因修改过建表语句,SQLite中是_id而不是id
数据删除后没有刷新
添加语句