Android Remote Connection Database .....
Last Update:2017-06-18
Source: Internet
Author: User
<span id="Label3"></p><p><p>It was 6.0.6 replaced by MySQL 5.1.14 driver ok ....</p></p><p><p>Put the method on new Thread () to resolve .....</p></p><p><p>The UI can only be drawn on the main thread ....</p></p><p><p>Solution ...<br>After the child thread gets the data, put the drawing UI code in the Handler.post to execute</p></p><p><p></p></p><p><p></p></p><pre>code----<span style="color: #0000ff"><span style="color: #0000ff"></span> package</span><span style="color: #000000"><span style="color: #000000">com.example.administrator.demo1;</span></span><span style="color: #0000ff"><span style="color: #0000ff">Import</span></span><span style="color: #000000"><span style="color: #000000">android.os.Handler;</span></span><span style="color: #0000ff"><span style="color: #0000ff">Import</span></span><span style="color: #000000"><span style="color: #000000">android.support.v7.app.AlertDialog;</span></span><span style="color: #0000ff"><span style="color: #0000ff">Import</span></span><span style="color: #000000"><span style="color: #000000">android.support.v7.app.AppCompatActivity;</span></span><span style="color: #0000ff"><span style="color: #0000ff">Import</span></span><span style="color: #000000"><span style="color: #000000">android.os.Bundle;</span></span><span style="color: #0000ff"><span style="color: #0000ff">Import</span></span><span style="color: #000000"><span style="color: #000000">android.util.AttributeSet;</span></span><span style="color: #0000ff"><span style="color: #0000ff">Import</span></span><span style="color: #000000"><span style="color: #000000">android.view.View;</span></span><span style="color: #0000ff"><span style="color: #0000ff">Import</span></span><span style="color: #000000"><span style="color: #000000">android.widget.FrameLayout;</span></span><span style="color: #0000ff"><span style="color: #0000ff">Import</span></span><span style="color: #000000"><span style="color: #000000">android.widget.LinearLayout;</span></span><span style="color: #0000ff"><span style="color: #0000ff">Import</span></span><span style="color: #000000"><span style="color: #000000">android.widget.TabHost;</span></span><span style="color: #0000ff"><span style="color: #0000ff">Import</span></span><span style="color: #000000"><span style="color: #000000">android.widget.TabWidget;</span></span><span style="color: #0000ff"><span style="color: #0000ff">Import</span></span><span style="color: #000000"><span style="color: #000000">android.widget.TextView;</span></span><span style="color: #0000ff"><span style="color: #0000ff">Import</span></span><span style="color: #000000"><span style="color: #000000">android.widget.Toast;</span></span><span style="color: #0000ff"><span style="color: #0000ff">Import</span></span><span style="color: #000000"><span style="color: #000000">org.whm.db.DbUtils;</span></span><span style="color: #0000ff"><span style="color: #0000ff">Import</span></span><span style="color: #000000"><span style="color: #000000">java.util.ArrayList;</span></span><span style="color: #0000ff"><span style="color: #0000ff">Import</span></span><span style="color: #000000"><span style="color: #000000">java.util.List;</span></span><span style="color: #0000ff"><span style="color: #0000ff">Import</span></span><span style="color: #000000"><span style="color: #000000">java.util.Map;</span></span><span style="color: #0000ff"><span style="color: #0000ff">Import</span></span><span style="color: #000000"><span style="color: #000000">java.util.Objects;</span></span><span style="color: #0000ff"><span style="color: #0000ff">Import</span></span><span style="color: #000000"><span style="color: #000000">java.util.jar.Attributes;</span></span><span style="color: #0000ff"><span style="color: #0000ff"></span> public</span> <span style="color: #0000ff"><span style="color: #0000ff">class</span></span>Mainactivity<span style="color: #0000ff"><span style="color: #0000ff">extends</span></span><span style="color: #000000"><span style="color: #000000">appcompatactivity {</span></span><span style="color: #008000"><span style="color: #008000">//</span></span><span style="color: #008000"><span style="color: #008000">Hook Thread</span></span>Handler Handler =<span style="color: #0000ff"><span style="color: #0000ff">NULL</span></span><span style="color: #000000"><span style="color: #000000">; @Override</span></span><span style="color: #0000ff"><span style="color: #0000ff">protected</span></span> <span style="color: #0000ff"><span style="color: #0000ff">void</span></span><span style="color: #000000"><span style="color: #000000">onCreate (Bundle Savedinstancestate) {</span></span><span style="color: #0000ff"><span style="color: #0000ff">Super</span></span><span style="color: #000000"><span style="color: #000000">. OnCreate (savedinstancestate); Setcontentview (r.layout.activity_main); </span></span><span style="color: #008000"><span style="color: #008000">//</span></span><span style="color: #008000"><span style="color: #008000">Example of a call to a native method</span></span><span style="color: #008000"><span style="color: #008000">//</span></span><span style="color: #008000"><span style="color: #008000">TextView TV = (TextView) Findviewbyid (r.id.tabhost); </span></span><span style="color: #008000"><span style="color: #008000">//</span></span><span style="color: #008000"><span style="color: #008000">tv.settext (stringfromjni ());</span></span>Tabhost Tabhost =<span style="color: #000000"><span style="color: #000000">(tabhost) Findviewbyid (r.id.tabhost); Tabhost.setup ();</span></span><span style="color: #008000"><span style="color: #008000">//</span></span><span style="color: #008000"><span style="color: #008000">framelayout framelayout = (framelayout) Findviewbyid (r.id.tabcontent);</span></span><span style="color: #008000"><span style="color: #008000">//</span></span><span style="color: #008000"><span style="color: #008000">int childCount = Framelayout.getchildcount ();</span></span>LinearLayout L1 =<span style="color: #000000"><span style="color: #000000">(linearlayout) Findviewbyid (r.id.tab1); LinearLayout L2</span></span>=<span style="color: #000000"><span style="color: #000000">(linearlayout) Findviewbyid (r.id.tab2); Handler</span></span>=<span style="color: #0000ff"><span style="color: #0000ff">New</span></span><span style="color: #000000"><span style="color: #000000">Handler (); </span></span><span style="color: #008000"><span style="color: #008000">//</span></span><span style="color: #008000"><span style="color: #008000">try not to throw exceptions in lambda .... </span></span> <span style="color: #0000ff"><span style="color: #0000ff">New</span></span>Thread (()<span style="color: #000000"><span style="color: #000000">{List</span></span><map<string, object>> list =<span style="color: #000000"><span style="color: #000000">GetData (l1); Handler.post (</span></span><span style="color: #0000ff"><span style="color: #0000ff">New</span></span>Thread (()<span style="color: #000000"><span style="color: #000000">{darwview (list, l1); })); }). Start (); Tabhost.tabspec TABSPEC1</span></span>= Tabhost.newtabspec ("tabSpec1"). setindicator ("video")<span style="color: #000000"><span style="color: #000000">). setcontent (r.id.tab1); Tabhost.tabspec TABSPEC2</span></span>= Tabhost.newtabspec ("tabSpec2"). setindicator ("live")<span style="color: #000000"><span style="color: #000000">). setcontent (r.id.tab2); Tabhost.addtab (tabSpec1); Tabhost.addtab (tabSpec2); } </span></span><span style="color: #008000"><span style="color: #008000">/**</span></span><span style="color: #008000"><span style="color: #008000">* A Native method That's implemented by the ' native-lib ' native library, * which are packaged with this appli Cation. </span></span><span style="color: #008000"><span style="color: #008000">*/</span></span> <span style="color: #0000ff"><span style="color: #0000ff"></span> public</span> <span style="color: #0000ff"><span style="color: #0000ff">native</span></span><span style="color: #000000"><span style="color: #000000">String Stringfromjni (); </span></span><span style="color: #008000"><span style="color: #008000">//</span></span><span style="color: #008000"><span style="color: #008000">getting data from a remote server</span></span> <span style="color: #0000ff"><span style="color: #0000ff">Private</span></span>list<map<string, object>><span style="color: #000000"><span style="color: #000000">getData (linearlayout l) {List</span></span><map<string, object>> list =<span style="color: #0000ff"><span style="color: #0000ff">NULL</span></span><span style="color: #000000"><span style="color: #000000">; </span></span><span style="color: #0000ff"><span style="color: #0000ff">Try</span></span><span style="color: #000000"><span style="color: #000000">{list</span></span>= Dbutils.execquery ("select * from video",<span style="color: #0000ff"><span style="color: #0000ff">NULL</span></span><span style="color: #000000"><span style="color: #000000">); } </span></span><span style="color: #0000ff"><span style="color: #0000ff">Catch</span></span><span style="color: #000000"><span style="color: #000000">(Exception E) {e.printstacktrace (); Toast.maketext (getapplicationcontext (),</span></span>"an Error has occurred"<span style="color: #000000"><span style="color: #000000">, toast.length_long). show (); } </span></span><span style="color: #0000ff"><span style="color: #0000ff">return</span></span><span style="color: #000000"><span style="color: #000000">list; } </span></span><span style="color: #008000"><span style="color: #008000">//</span></span><span style="color: #008000"><span style="color: #008000">drawing the UI</span></span> <span style="color: #0000ff"><span style="color: #0000ff">Private</span></span> <span style="color: #0000ff"><span style="color: #0000ff">void</span></span>Darwview (list<map<string, object>><span style="color: #000000"><span style="color: #000000">list, LinearLayout View) {list.foreach (map)</span></span>-<span style="color: #000000"><span style="color: #000000">{TextView TV</span></span>=<span style="color: #0000ff"><span style="color: #0000ff">New</span></span><span style="color: #000000"><span style="color: #000000">TextView (getapplicationcontext ()); Tv.settext (String) Map.get (</span></span>"title"<span style="color: #000000"><span style="color: #000000">)); View.addview (tv); }); } </span></span><span style="color: #008000"><span style="color: #008000">//</span></span><span style="color: #008000"><span style="color: #008000">used to load the ' Native-lib ' Library on application Startup.</span></span> <span style="color: #0000ff"><span style="color: #0000ff">Static</span></span><span style="color: #000000"><span style="color: #000000">{system.loadlibrary (</span></span>"native-lib"<span style="color: #000000"><span style="color: #000000">); }}</span></span></pre><p><p></p></p><p><p>Android Remote Connection Database .....</p></p></span>
