android - Show immediate changes when data deleted from database -
view database xml file:
<?xml version="1.0" encoding="utf-8"?> <linearlayout xmlns:android="http://schemas.android.com/apk/res/android" android:layout_width="match_parent" android:layout_height="match_parent" android:orientation="vertical" android:background="@drawable/wood_bg" > <textview android:layout_width="wrap_content" android:layout_height="wrap_content" android:layout_gravity="center_horizontal" android:layout_marginbottom="10dp" android:layout_margintop="10dp" android:text="daily fruit log" android:textappearance="?android:attr/textappearancelarge" android:textstyle="bold"/> <tablelayout android:layout_width="fill_parent" android:layout_height="wrap_content" > <tablerow> <textview android:layout_width="110dp" android:layout_height="fill_parent" android:text="name of fruit" android:layout_weight="1" android:textstyle="bold"/> <textview android:layout_width="wrap_content" android:layout_height="fill_parent" android:text="no of fruit" android:layout_weight="1" android:textstyle="bold"/> <textview android:layout_width="fill_parent" android:layout_height="fill_parent" android:text="total calories" android:layout_weight="1" android:textstyle="bold"/> </tablerow> </tablelayout> <tablelayout android:layout_width="fill_parent" android:layout_height="wrap_content" android:layout_margintop="10dp"> <tablerow> <textview android:id="@+id/view" android:layout_width="110dp" android:layout_height="wrap_content" android:text="food" android:layout_weight="1" /> <textview android:id="@+id/view1" android:layout_width="fill_parent" android:layout_height="fill_parent" android:text="1" android:layout_weight="1"/> <textview android:id="@+id/view2" android:layout_width="fill_parent" android:layout_height="fill_parent" android:text="20" android:layout_weight="1"/> </tablerow> </tablelayout> <button android:id="@+id/bdelete" android:layout_width="wrap_content" android:layout_height="wrap_content" android:text="clear log" android:layout_gravity="center" android:layout_margintop="30dp" />
java class of view database page:
public class fruitlog extends activity { @override protected void oncreate(bundle savedinstancestate) { super.oncreate(savedinstancestate); setcontentview(r.layout.fruitlog); textview tv = (textview) findviewbyid(r.id.view); textview tv1 = (textview) findviewbyid(r.id.view1); textview tv2 = (textview) findviewbyid(r.id.view2); fruitdb info = new fruitdb(this); info.open(); string data = info.getname(); string data1 = info.getnum(); string data2 = info.getcal(); info.close(); tv.settext(data); tv1.settext(data1); tv2.settext(data2); button save = (button) findviewbyid(r.id.bdelete); save.settextcolor(color.blue); save.setonclicklistener(new view.onclicklistener(){ public void onclick(view v) { // todo auto-generated method stub fruitdb info = new fruitdb(fruitlog.this); info.open(); info.deleteall(); info.close(); } }); }
i have edited code, can delete data in page, issue that, have navigate , enter fruitlog page see changes (all rows deleted). want see immediate result when user click 'clear log' button without navigating , front.
this method in db class:
public boolean deleteall() { // returns true if number of deleted rows larger 0; return mdb.delete(database_table, null, 1) > 0; }
in onclicklistener:
public void onclick(view v) { fruitdb db = new fruitdb(yourclass.this); db.open(); db.deleteall(); db.close(); }
Comments
Post a Comment