android - 如何删除 ListView 和数据库中的项目 - Android Studio

Question

我的 Activity 代码

请帮助我如何在 Android Studio 中删除连接到数据库的 ListView 中的项目。这是我的代码:

mainListView.setOnItemLongClickListener(new AdapterView.OnItemLongClickListener() {            public boolean onItemLongClick(AdapterView parent, View view, final int position, final long id) {                final AlertDialog.Builder b = new AlertDialog.Builder(UserList.this);                b.setIcon(android.R.drawable.ic_dialog_alert);                b.setMessage("Ingin menghapus data?");                b.setPositiveButton("Ya",                        new DialogInterface.OnClickListener() {                            public void onClick(DialogInterface dialog, int whichButton) {                                IDTable = IDList.get(position);                                userList.remove(position);                                UserList.this.listAdapter.notifyDataSetChanged();                                InfoPokok info = new InfoPokok();                                info.setId(IDTable);                                System.out.println("ID : " + info.getId());                                infoPokokDao.deleteInfoPokok(info);                            }                        });                b.setNegativeButton("Tidak",                        new DialogInterface.OnClickListener() {                            public void onClick(DialogInterface dialog, int whichButton) {                                dialog.cancel();                            }                        });                b.show();                return true;            }        });

道:

public void deleteInfoPokok(InfoPokok infoPokok) {String id = infoPokok.getId() + "";        long deleteId = database.delete(MySQLiteHelper.TABLE_INFO_POKOK, MySQLiteHelper.COLUMN_ID                + " =?", new String[]{id});        Cursor cursor = database.query(MySQLiteHelper.TABLE_INFO_POKOK,                allColumns, MySQLiteHelper.COLUMN_ID + " = " + deleteId, null,                null, null, null);        cursor.moveToFirst();        cursor.close();    }

Answer 1

在你的 DISPLAYACTIVITY.JAVA 中

 btnDelete.setOnClickListener(new View.OnClickListener() {

            @Override
            public void onClick(View v) {

                DataBaseHandler db = new DataBaseHandler(DisplayImageActivity.this);

                Log.d("Delete Image: ", "Deleting.....");
                db.deleteCloth(new Cloth(imageId));

                Intent i = new Intent(DisplayImageActivity.this, MainActivity.class);
                startActivity(i);
                finish();
            }
        });

然后在 DATABASEHANDLER.JAVA 中

 public void deleteCloth(Cloth cloth) {

        SQLiteDatabase db = this.getWritableDatabase();
        db.delete(TABLE_CLOTHES, KEY_ID + " = ?", new String[] { String.valueOf(cloth.getID()) });
        db.close();
    }