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

Question

我的activity代码

请帮助我如何删除在Android Studio中连接数据库的列表视图中的项目。这是我的代码：

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中

null

 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();
            }
        });