Synchronize Listview Ids with database

Question

I’m working on a college project where I use a database and a Listview. The problem is when I need to recover the data from one of the Listview items, as I cannot synchronize the Listview Ids with the BD Ids. In this case, if I register some items in the BD and then remove them, the Listview Ids no longer match those of the BD, making it an error when removing or viewing.

Is there any way to tie Listview items to a unique ID, which does not change if the order or quantity of Listview items changes?

Answer 1

Depending on the items you have in ListView it would be better to have even associated objects. That is, each item in the list would be an object and that object would have the ID coming from the Database.

public class Objeto{

private int ID;
private ...;
...;
}

Then I’d have to create an Adptador of Object with the override of getPosition(Object o)

public class AdaptadorObjeto extends ArrayAdapter<Objeto> {

    @Override
    public int getPosition(Objeto o) {
        return super.getPosition(o);
    }
}

From there and through the current position, the touch can do what you want with the element, can delete from the database because it has the ID of the same.

Source Android Arrayadpter

I hope I’ve helped.