php - In Android How to show message when data is Changed into Database? -

-

i need show message in android java class when data changed database. method has used this??

please me , dont have idea this.

this php code:

    <?php     $tableid=$_post['tableid'];     $status=$_post['status'];     include '../../dbconnect.php';     if($status=='all')     {     $oidquery="select orderid, orderstatus din_orders tableid=$tableid  &&      orderstatus!='pending'";     }     else     {      $oidquery="select orderid,orderstatus din_orders tableid=$tableid &&        orderstatus='$status'";     }    $result=mysql_query($oidquery);    while($ordersrow=mysql_fetch_object($result))     {    $ordersarray[]=$ordersrow;     }    echo json_encode(array('orders'=>$ordersarray));    ?>

for example: in table "orderstatus" shows "pending" later manually change "pending" "delivered". when change takes place in database should message in android java class "items delivered".

here android java code:

    public void ordersdisplay() {     string selectedstatus1 = (string) status.getselecteditem();     arraylist<namevaluepair> namevaluepairs = new arraylist<namevaluepair>();     arraylist<hashmap<string, string>> mylist = new arraylist<hashmap<string, string>>();     namevaluepairs.add(new basicnamevaluepair("tableid", tableid1));     namevaluepairs.add(new basicnamevaluepair("status", selectedstatus1));     inputstream = null;     string result = "";     jsonobject jarray = null;     try {         httpclient httpclient = new defaulthttpclient();         httppost httppost = new httppost(url + "order_status.php");         httppost.setentity(new urlencodedformentity(namevaluepairs));         httpresponse response = httpclient.execute(httppost);         httpentity entity = response.getentity();         = entity.getcontent();     } catch (exception e) {         log.e("log", "error in connection" + e.tostring());         toast.maketext(getapplicationcontext(), "error in connection",                 toast.length_short).show();      }     try {         bufferedreader reader = new bufferedreader(new inputstreamreader(                 is, "iso-8859-1"), 8);         stringbuilder sb = new stringbuilder();         string line = "";         while ((line = reader.readline()) != null) {             sb.append(line + "\n");         }         is.close();         result = sb.tostring();     } catch (exception e) {         // todo: handle exception     }      try {          jarray = new jsonobject(result);         jsonarray jsonarray = jarray.getjsonarray("orders");          (int = 0; < jsonarray.length(); i++) {             hashmap<string, string> map = new hashmap<string, string>();             jsonobject jsonobject = jsonarray.getjsonobject(i);              map.put("orders", string.valueof(i));             map.put("orderid", jsonobject.getstring("orderid"));             map.put("status", jsonobject.getstring("orderstatus"));              mylist.add(map);         }     } catch (jsonexception e) {         toast.maketext(getapplicationcontext(), "no order display",                 toast.length_long).show();          log.e("log_tag", "error parsing data " + e.tostring());     }     listadapter adapter = new simpleadapter(this, mylist,             r.layout.vieworder, new string[] { "orderid", "status" },             new int[] { r.id.item_title, r.id.item_subtitle });      setlistadapter(adapter);      final listview lv = getlistview();     lv.settextfilterenabled(true);     lv.setonitemclicklistener(new onitemclicklistener() {         public final void onitemclick(adapterview<?> parent, view view,                 int position, long id) {             @suppresswarnings("unchecked")             hashmap<string, string> o = (hashmap<string, string>) lv                     .getitematposition(position);              string orderid = o.get("orderid");             string orderstatus = o.get("status");             intent intent = new intent(getapplicationcontext(),                     din_ord_itemdisplay.class);             intent.putextra("orderid", orderid);             intent.putextra("waitername", waitername);             intent.putextra("orderstatus", orderstatus);             intent.putextra("tableid", tableid1);             intent.putextra("url", url);              startactivity(intent);          }     }); }

if inserting values in sqlite database following

contentvalues values = new contentvalues(); values.put(dbhelper.book_title,"android"); values.put(dbhelper.book_author,"abc"); database = dbhelper.getwritabledatabase(); database.insert(dbhelper.table_name, null, values);

here database.insert returns row id of newly inserted row, or -1 if error occurred.

so can have following validation.

if (database.insert(dbhelper.table_name, null, values) != -1) {   toast.maketext(this, "write success", toast.length_short).show(); } else {  toast.maketext(this, "write failure", toast.length_short).show(); }

Comments

Post a Comment

Popular posts from this blog

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

-
on website user have 1 group. , user can change group. it's made user.groups.clear() and user.groups.add(new_group) but it's not efficient, because there 2 sql query: delete, insert. how can change group update query? user , group related each other using manytomanyfield . means intersection table exists relating both entities, , if don't specify model map (using through attribute) django creates 1 you. looking @ sources django.contrib.auth.models see that's case. fortunatly, can access intermediary model using through attribute of manager (in case, user.groups.through ). can use regular model. example: >>> alice = user.objects.create_user('alice', 'alice@example.com', 'alicepw') >>> employee = group.objects.create(name='employee') >>> manager = group.objects.create(name='manager') >>> alice.groups.add(employee) >>> alice.groups.all() [<group: employee...
Read more

java - Need to add SOAP security token -

-
i need set custom soap header attribute on jax-ws generated webservice client. case webservice calls must go through proxy server requiring specific token (recieved web request header) present in soap request header. e.g.: 1 carserviceservice service = null; 2 service = new carserviceservice(new url(url), new qname(qname); 3 carserviceendpoint port = service.getcarserviceport(); it seems in line 3 wsdl retrieved , call fails due missing security token. 1 point direction on how done? a detailed example has been mentioned here: creating , deploying jax-ws web service on tomcat 6 this article shows how create , use security token .
Read more

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

-
i have strange problem eclipselink , object want persist. have 1 object (keypointlistimpl) stores object keypointimpl in list. persisting keypointimpl objects works great if try persist keypointlistimpl object java.lang.illegalargumentexception says object keypointimpl isn't known entity type. here keypointimpl code: @entity @table(name="keypoints") public class keypointimpl implements keypoint { @id @generatedvalue(strategy = generationtype.identity) private int id; @enumerated(enumtype.string) private detectortype keypointtype; private float x; private float y; private float size; private float angle; private float response; private int octave; private int classid; ... } here keypointlistimpl code: @entity @table(name="keypointlists") public class keypointlistimpl implements keypointlist { @id @generatedvalue(strategy = generationtype.identity) private int id; @onetoone(cascade={ca...
Read more