Update BD after insert record

Question

I use the following code to enter a record in sqlite:

    public void InsereSenha(String Nome, String Senha, String Dica, String Anotacao) {
    String sql = "INSERT INTO Senha (Nome, Senha, Dica, Anotacao) VALUES (?, ?, ?, ?)";
    try
    {
        database.execSQL(sql, new String[]{Nome, Senha, Dica, Anotacao});
    }
    catch (Exception ex)
    {

    }

}

It inserts the record, but when giving the select to take all the records of this table and show in a listview, the new registration, which I just registered, does not appear. How to give a "refresh" in the comic book to get the new record?

Edit 1:

The Adapter that was supposed to display the records I just entered:

        final DatabaseAccess databaseAccess = DatabaseAccess.getInstance(this);
    databaseAccess.open();
    List<Senha> senhas = databaseAccess.getSenha();
    databaseAccess.close();

    CustomAdapter adapter = new CustomAdapter(getApplicationContext(), senhas);

    Lista.setAdapter(adapter);

Edit 2:

Based on Márcio Oliveira’s answer, I redid the code. That’s how it’s working:

public class MainActivity extends AppCompatActivity {

ListView Lista;
List<Senha> senhas;
CustomAdapter adapter;
final DatabaseAccess databaseAccess = DatabaseAccess.getInstance(this);


@Override
protected void onCreate(Bundle savedInstanceState) {
    super.onCreate(savedInstanceState);
    setContentView(R.layout.activity_main);

    Lista = (ListView)findViewById(R.id.Lista_Senhas);

    databaseAccess.open();
    senhas = databaseAccess.getSenha();
    databaseAccess.close();

    if (adapter == null) {
        adapter = new CustomAdapter(getApplicationContext(), senhas);
    }else {
        adapter.notifyDataSetChanged();
    }

    Lista.setAdapter(adapter);

}

}

Answer 1

In the database you don’t have to do anything. The way you implemented it, just reload your password list (List<Senha> senhas) and notify Adapter that the list has been updated with a adapter.notifyDataSetChanged().

Consider using a Cursorloader/Cursoradapter in the listview to access the database directly instead of loading data each time to an array. Depending on the amount of data, you can slow down or crash the interface.