Delete item from listview (using sqlite delete query)

Question

I would like to delete item from my listview by ItemlongClickListener. display items are column value of my database. database queries are written in a separate file and listview code is in separate file. I tried but my app getting stopped.. My ListView page code are as follows:

fav_quote.setOnItemLongClickListener(new OnItemLongClickListener() {
        public boolean onItemLongClick(AdapterView<?> parent, View v, int position, long id) {
            Log.w("DELETED", " DELETED");

            String position1 =  adapt.getItem(position);

           Fav del = new Fav(this);
           del.deleteEntry(position1);
           del.close();
          return false;              
        }

Database Code

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
        // TODO Auto-generated method stub
        db.execSQL("DROP TABLE IF EXIST " + DATABASE_TABLE);
        onCreate(db);
    }       
}

public Fav(Context c) {

    ourContext = c;
}

public Fav(OnItemLongClickListener onItemLongClickListener) {
    Context c1 = null;
    ourContext = c1;
    // TODO Auto-generated constructor stub
}

public Fav open() throws SQLException {
ourHelper = new DbHelper(ourContext);
ourDatabase = ourHelper.getWritableDatabase();
return this; 
}
public void close (){

    ourHelper.close();
}

public long createEntry(String header, String quote_value) {
    // TODO Auto-generated method stub
    ContentValues cv = new ContentValues();
    cv.put(KEY_HEADER, header);
    cv.put(KEY_QUOTE_VALUE, quote_value);
    return ourDatabase.insert(DATABASE_TABLE, null, cv);
}

public String getData() {
    // TODO Auto-generated method stub
    String[] columns = new String []{KEY_ROWID, KEY_HEADER, KEY_QUOTE_VALUE};       

    Cursor c = ourDatabase.query(DATABASE_TABLE, columns, null, null, null, null, null);
    String result = "";     
    int iRow = c.getColumnIndex(KEY_ROWID);
    int iHeader = c.getColumnIndex(KEY_HEADER);
    int iQuote_value = c.getColumnIndex(KEY_QUOTE_VALUE);

    for (c.moveToFirst(); !c.isAfterLast(); c.moveToNext()){
        result = result + c.getString(iRow)+ "." +c.getString(iHeader)+ ":" +c.getString(iQuote_value)+ ":";
    }       
    return result;              
}

public void deleteEntry(String position1) {
    // TODO Auto-generated method stub
    ourDatabase.delete(DATABASE_TABLE, KEY_ROWID + "=" + position1 , null);
}

andy · Accepted Answer · 2013-05-08 07:02:24Z

1

Are the values deleted from Database? If yes then either remove that entry from your adaptor call method

    notifyDataSetChanged();

If no you have some problem with the database.

answered May 8, 2013 at 7:02

andy

2081 silver badge7 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Saad · Accepted Answer · 2013-05-08 06:59:31Z

0

In deleteEntry class you have to initialize the sqlite like.

public void deleteEntry(String position1) {
// TODO Auto-generated method stub
 SQLiteDatabase ourDatabase = this.getWritableDatabase();
ourDatabase.delete(DATABASE_TABLE, KEY_ROWID + "=" + position1 , null);
}

answered May 8, 2013 at 6:59

Saad

3092 gold badges9 silver badges21 bronze badges

Comments

Hoan Nguyen · Accepted Answer · 2013-05-08 07:10:27Z

0

Try

Fav del = new Fav(NameOfActivityClass.this);

answered May 8, 2013 at 7:10

Hoan Nguyen

18.2k3 gold badges52 silver badges56 bronze badges

Collectives™ on Stack Overflow

Delete item from listview (using sqlite delete query)

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related