I'm new to android and I got a problem with refreshing my listview after deleting items from it. I've tried everything and cant get it to work so I'm asking for help. I know that I gotta use notifyDataSetChanged on my adapter but I just have no clue where to put it. Thanks in advance guys. Whole project uploaded on zippyshare:http://www6.zippyshare.com/v/TZVGTFJp/file.html
public class MainActivity extends AppCompatActivity {
DBHandler handler;
Context context = this;
ListView listView;
ArrayAdapter arrayAdapter;
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);
Toolbar toolbar = (Toolbar) findViewById(R.id.toolbar);
setSupportActionBar(toolbar);
EditText etName = (EditText) findViewById(R.id.etNameID);
EditText etPhone = (EditText) findViewById(R.id.etPhoneID);
handler = new DBHandler(this);
printDatabase();
if (listView != null) {
listView.setOnItemLongClickListener(new AdapterView.OnItemLongClickListener() {
@Override
public boolean onItemLongClick(AdapterView<?> parent, View view, final int position, final long id) {
PopupMenu popup = new PopupMenu(context, view);
popup.getMenuInflater().inflate(R.menu.menu_delete_popup, popup.getMenu());
popup.show();
popup.setOnMenuItemClickListener(new PopupMenu.OnMenuItemClickListener() {
@Override
public boolean onMenuItemClick(MenuItem item) {
switch (item.getItemId()) {
case R.id.deleteItemID:
handler.deleteContact(id);
printDatabase();
break;
}
return true;
}
});
return true;
}
});
}
}
@Override
public boolean onCreateOptionsMenu(Menu menu) {
// Inflate the menu; this adds items to the action bar if it is present.
getMenuInflater().inflate(R.menu.menu_main, menu);
return true;
}
@Override
public boolean onOptionsItemSelected(MenuItem item) {
// Handle action bar item clicks here. The action bar will
// automatically handle clicks on the Home/Up button, so long
// as you specify a parent activity in AndroidManifest.xml.
int id = item.getItemId();
//noinspection SimplifiableIfStatement
if (id == R.id.action_settings) {
return true;
}
if (id == R.id.addContactID) {
openAddDialog();
}
return super.onOptionsItemSelected(item);
}
public void printDatabase() {
ArrayList array_list = handler.getAllCotacts();
arrayAdapter = new ArrayAdapter(this, android.R.layout.simple_list_item_1, array_list);
listView = (ListView) findViewById(R.id.listView);
listView.setAdapter(arrayAdapter);
}
public void openAddDialog() {
android.app.AlertDialog.Builder makeDialog = new android.app.AlertDialog.Builder(this);
LayoutInflater li = getLayoutInflater();
View v = li.inflate(R.layout.contacts_add_dialog, null);
makeDialog.setView(v);
//tu idu varijable
final EditText etName = (EditText) v.findViewById(R.id.etNameID);
final EditText etPhone = (EditText) v.findViewById(R.id.etPhoneID);
makeDialog.setPositiveButton("Save", new DialogInterface.OnClickListener() {
@Override
public void onClick(DialogInterface dialog, int which) {
String textFromEtName = etName.getText().toString();
String textFromEtPhone = etPhone.getText().toString();
handler.insertContact(textFromEtName, textFromEtPhone);
printDatabase();
}
});
makeDialog.setNegativeButton("Cancel", new DialogInterface.OnClickListener() {
@Override
public void onClick(DialogInterface dialog, int which) {
dialog.cancel();
}
});
android.app.AlertDialog ad = makeDialog.create();
ad.show();
}
}
Here is the DBHandler code:
public class DBHandler extends SQLiteOpenHelper {
public static final String DATABASE_NAME = "MyDBName.db";
public static final String CONTACTS_TABLE_NAME = "contacts";
public static final String CONTACTS_COLUMN_ID = "id";
public static final String CONTACTS_COLUMN_NAME = "name";
public static final String CONTACTS_COLUMN_PHONE = "phone";
public DBHandler(Context context)
{
super(context, DATABASE_NAME , null, 1);
}
@Override
public void onCreate(SQLiteDatabase db) {
// TODO Auto-generated method stub
db.execSQL(
"CREATE TABLE contacts " +
"(id INTEGER PRIMARY KEY, name TEXT,phone TEXT,email TEXT, street TEXT,place TEXT)"
);
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
// TODO Auto-generated method stub
db.execSQL("DROP TABLE IF EXISTS contacts");
onCreate(db);
}
public boolean insertContact (String name, String phone)
{
SQLiteDatabase db = this.getWritableDatabase();
ContentValues contentValues = new ContentValues();
contentValues.put("name", name);
contentValues.put("phone", phone);
db.insert("contacts", null, contentValues);
return true;
}
public Cursor getData(int id){
SQLiteDatabase db = this.getReadableDatabase();
Cursor res = db.rawQuery( "select * from contacts where id="+id+"", null );
return res;
}
public int numberOfRows(){
SQLiteDatabase db = this.getReadableDatabase();
int numRows = (int) DatabaseUtils.queryNumEntries(db, CONTACTS_TABLE_NAME);
return numRows;
}
public boolean updateContact (Integer id, String name, String phone)
{
SQLiteDatabase db = this.getWritableDatabase();
ContentValues contentValues = new ContentValues();
contentValues.put("name", name);
contentValues.put("phone", phone);
db.update("contacts", contentValues, "id = ? ", new String[] { Integer.toString(id) } );
return true;
}
public void deleteContact(long id) {
SQLiteDatabase db = this.getWritableDatabase();
db.delete(CONTACTS_TABLE_NAME, CONTACTS_COLUMN_ID + " = ?",
new String[] { String.valueOf(id) });
db.close();
}
public ArrayList<String> getAllCotacts()
{
ArrayList<String> array_list = new ArrayList<String>();
//hp = new HashMap();
SQLiteDatabase db = this.getReadableDatabase();
Cursor res = db.rawQuery( "select * from contacts", null );
res.moveToFirst();
while(res.isAfterLast() == false){
array_list.add(res.getString(res.getColumnIndex(CONTACTS_COLUMN_NAME)));
res.moveToNext();
}
return array_list;
}
}
