How to delete a row from database, When click a button named deletest can click the id of given java can be automatically get it and delete that row,help me,, I am Beginner in this field and study English language so please don't reject me.
Java Class
Button deletest;
del=(TextView)findViewById(R.id.del);
deletest.setOnClickListener(new View.OnClickListener() {
public void onClick(View v) {
// TODO Auto-generated method stub
DBUserAdapter dbUser = new DBUserAdapter(getApplicationContext());
dbUser.open();
String data=del.getText().toString();
dbUser.delete(data);
return;
}
});
eg:- Inserted a Students details in a database include Name, Id, Email and phone and its shown in list view when a click list view its go to next page updated this students details that time we want to delete that students details, Please
DB Helper Class
public Cursor delete(String data) throws SQLException {
// TODO Auto-generated method stub
// db = DBHelper.getWritableDatabase();
Cursor mCursor = db.rawQuery(
"DELETE * FROM addresstable where studentid=" + data, null);
return mCursor;
}
Aucun commentaire:
Enregistrer un commentaire