how can send results of wifi scan sql/mysql database have created populate values ssid, bssid , rssi using json? have far been able output these results list (see below code).
package com.example.wifiscanner8; import java.util.list; import android.app.activity; import android.content.broadcastreceiver; import android.content.context; import android.content.intent; import android.content.intentfilter; import android.net.wifi.scanresult; import android.net.wifi.wifimanager; import android.os.bundle; import android.view.keyevent; import android.view.menu; import android.view.menuitem; import android.widget.textview; public class mainactivity extends activity { textview textstatus; textview textstate; wifimanager mainwifi; wifireceiver receiverwifi; list<scanresult> wifilist; //stringbuilder sb = new stringbuilder(); public void oncreate(bundle savedinstancestate) { super.oncreate(savedinstancestate); setcontentview(r.layout.activity_main); //enable wifi on application start wifimanager wifimanager = (wifimanager) getbasecontext() .getsystemservice(context.wifi_service); wifimanager.setwifienabled(true); textstatus = (textview) findviewbyid(r.id.textstatus); mainwifi = (wifimanager) getsystemservice(context.wifi_service); receiverwifi = new wifireceiver(); registerreceiver(receiverwifi, new intentfilter(wifimanager.scan_results_available_action)); mainwifi.startscan(); //maintext.settext("starting scan..."); } public boolean oncreateoptionsmenu(menu menu) { menu.add(0, 0, 0, "refresh"); return super.oncreateoptionsmenu(menu); } public boolean onmenuitemselected(int featureid, menuitem item) { mainwifi.startscan(); //maintext.settext("starting scan"); return super.onmenuitemselected(featureid, item); } // upon pressing button exit app, wireless function set disable public boolean onkeydown(int keycode, keyevent event){ if(keycode == keyevent.keycode_back) { wifimanager wifimanager = (wifimanager) getbasecontext() .getsystemservice(context.wifi_service); wifimanager.setwifienabled(false); this.finish(); } return super.onkeydown(keycode, event); } protected void onpause() { unregisterreceiver(receiverwifi); super.onpause(); } protected void onresume() { registerreceiver(receiverwifi, new intentfilter(wifimanager.scan_results_available_action)); super.onresume(); } class wifireceiver extends broadcastreceiver { @override public void onreceive(context context, intent intent) { if (intent.getaction().equalsignorecase(wifimanager.scan_results_available_action)) { handlescanresultsavailable(); } } private void handlescanresultsavailable() { list<scanresult> results = mainwifi.getscanresults(); int size = results.size(); //stringbuilder sb = new stringbuilder(); (int i=0; i<size; i++){ scanresult scanresult = mainwifi.getscanresults().get(i); string bssid = scanresult.bssid; string ssid = scanresult.ssid; int rssi = scanresult.level; string rssistring = string.valueof(rssi); textstatus.append(bssid + "," + ssid + "," + rssistring); textstatus.append("\n"); } // getting json object // note create product url accepts post method //jsonobject json = jsonparser.makehttprequest(url_wifi_scan_result, // "post", reading); // check log cat response // log.d("create response", json.tostring()); } } }
your question bit unclear in doesn't specify db resides stu whyte pointed out. if using native sqlite db on device need sqlhelper, read here.
if instead database resides on server need serialize results in middleware format json or xml , transfer data web server, manage database connection . can use org.apache.http library natively included allow post/put data web service normal web form. documentation here.
Comments
Post a Comment