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

Popular posts from this blog

django - How can I change user group without delete record -

java - Need to add SOAP security token -

java - EclipseLink JPA Object is not a known entity type -