Android: Affichage des données de mysql dans un ListeView

Version imprimable

Bonjour tout le monde :D

je veux récuperer les donnes de mysql et l'afficher dans un listView

j’essaye de récupérer le données avec un code que je trouve dans un tutorial sur internet mais j'ai rien recu rien dans l'emelateur

et d’après le logcat : j’espère que j'ai deux problèmes 1- HttpResponse reponse = client.execute(requete);
2- JSONArray jArray = new JSONArray(stringB.toString());
lorsque je fait le test de code php sur le navigateur sous http://192.168.56.1/testAff/testAff.php il affiche correctement

Est ce que quelqu'un peut m'aider svp :(

Et merci d'avance

code:

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
 
package com.example.lenovo.mysecondetest;
 
import android.os.Bundle;
import android.support.design.widget.FloatingActionButton;
import android.support.design.widget.Snackbar;
import android.support.v7.app.AppCompatActivity;
import android.support.v7.widget.Toolbar;
import android.view.View;
import android.widget.ListView;
import android.widget.TextView;
 
import org.apache.http.HttpEntity;
import org.apache.http.HttpResponse;
import org.apache.http.client.ClientProtocolException;
import org.apache.http.client.HttpClient;
import org.apache.http.client.methods.HttpGet;
import org.apache.http.client.methods.HttpPost;
import org.apache.http.impl.client.DefaultHttpClient;
import org.json.JSONArray;
import org.json.JSONException;
 
import java.io.BufferedReader;
import java.io.IOException;
import java.io.InputStream;
import java.io.InputStreamReader;
import java.net.URI;
import java.net.URISyntaxException;
import java.util.ArrayList;
 
import java.io.BufferedReader;
import java.io.InputStream;
import java.io.InputStreamReader;
import java.util.ArrayList;
import org.apache.http.HttpEntity;
import org.apache.http.HttpResponse;
import org.apache.http.NameValuePair;
import org.apache.http.client.HttpClient;
import org.apache.http.client.entity.UrlEncodedFormEntity;
import org.apache.http.client.methods.HttpPost;
import org.apache.http.impl.client.DefaultHttpClient;
import org.json.JSONArray;
import org.json.JSONException;
import org.json.JSONObject;
import android.app.ListActivity;
import android.net.ParseException;
import android.os.Bundle;
import android.util.Log;
import android.widget.ArrayAdapter;
import android.widget.Toast;
 
 
public class CdesNonTraiteActivity extends AppCompatActivity {
 
    CdesNonTraite cdesNonTraite;
    ArrayList<CdesNonTraite> cdesNonTraites;
    private ArrayAdapter<String> listAdapter;
 
    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_cdes_non_traite);
        Toolbar toolbar = (Toolbar) findViewById(R.id.toolbar);
        setSupportActionBar(toolbar);
 
 
        StringBuffer stringB = new StringBuffer("");
        BufferedReader bufR = null;
 
        try {
            HttpClient client = new DefaultHttpClient();
            HttpGet requete = new HttpGet();
            URI uri = new URI("http://192.168.56.1/Affichage/afficheC11.php");
            requete.setURI(uri);
            HttpResponse reponse = client.execute(requete);
            InputStream is = reponse.getEntity().getContent();
            bufR = new BufferedReader(new InputStreamReader(is));
            String ligneLue = bufR.readLine();
            while (ligneLue != null) {
 
                stringB.append(ligneLue);
                stringB.append("\n");
                ligneLue = bufR.readLine();
 
            }
 
 
        } catch (Exception e) {
 
            e.printStackTrace();
        } finally {
            if (bufR != null) {
                try {
                    bufR.close();
                } catch (IOException ioe) {
                    ioe.printStackTrace();
                }
            }
        }
        try {
            JSONArray jArray = new JSONArray(stringB.toString());
            for (int i = 0; i < jArray.length(); i++) {
                cdesNonTraite = new CdesNonTraite();
                cdesNonTraite.setNumOf(jArray.getJSONObject(i).getString("T1").toString());
                cdesNonTraite.setDate(jArray.getJSONObject(i).getString("T2").toString());
                cdesNonTraite.setClient(jArray.getJSONObject(i).getString("T3").toString());
                cdesNonTraite.setModele(jArray.getJSONObject(i).getString("T4").toString());
                cdesNonTraite.setQte(jArray.getJSONObject(i).getString("T5").toString());
                cdesNonTraite.setLance(jArray.getJSONObject(i).getString("T6").toString());
                cdesNonTraite.setDateLance(jArray.getJSONObject(i).getString("T7").toString());
                cdesNonTraite.setCoupe(jArray.getJSONObject(i).getString("T8").toString());
                cdesNonTraite.setDateCoupe(jArray.getJSONObject(i).getString("T9").toString());
 
                this.cdesNonTraites.add(cdesNonTraite);
            }
        } catch (JSONException jex) {
            jex.printStackTrace();
        }
 
        if (cdesNonTraites != null) {
            CdesNonTraiteAdapter adapter = new CdesNonTraiteAdapter(this, cdesNonTraites);
            ListView cdVueTraite = (ListView) findViewById(R.id.list_Tab);
            cdVueTraite.setAdapter(adapter);
 
        }
 
 
    }
}

afficheC11.php:

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
 
<?php
 
$base = mysql_connect ('localhost', 'root', '');
mysql_select_db ('database', $base) ;
 
 
$sql = "SELECT * FROM `titrecol` WHERE `id`=1";
 
$req = mysql_query($sql) ;
 
 while ($row=mysql_fetch_assoc($req)) {    
    $output[]=$row;    
} 
 
print(json_encode($output));
 
 
 ?>

13/02/2016, 13h22
dimass

toujours dans le même problème

logcat:

02-13 12:16:59.255 23950-24061/com.example.lenovo.mysecondetest W/EGL_emulation: eglSurfaceAttrib not implemented
02-13 12:16:59.255 23950-24061/com.example.lenovo.mysecondetest W/OpenGLRenderer: Failed to set EGL_SWAP_BEHAVIOR on surface 0xb136e700, error=EGL_SUCCESS
02-13 12:18:02.135 23950-23956/com.example.lenovo.mysecondetest W/art: Suspending all threads took: 14.216ms
02-13 12:18:12.659 23950-23950/com.example.lenovo.mysecondetest W/System.err: android.os.NetworkOnMainThreadException
02-13 12:18:12.659 23950-23950/com.example.lenovo.mysecondetest W/System.err: at android.os.StrictMode$AndroidBlockGuardPolicy.onNetwork(StrictMode.java:1273)
02-13 12:18:12.660 23950-23950/com.example.lenovo.mysecondetest W/System.err: at libcore.io.BlockGuardOs.connect(BlockGuardOs.java:110)
02-13 12:18:12.660 23950-23950/com.example.lenovo.mysecondetest W/System.err: at libcore.io.IoBridge.connectErrno(IoBridge.java:137)
02-13 12:18:12.660 23950-23950/com.example.lenovo.mysecondetest W/System.err: at libcore.io.IoBridge.connect(IoBridge.java:122)
02-13 12:18:12.660 23950-23950/com.example.lenovo.mysecondetest W/System.err: at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:183)
02-13 12:18:12.660 23950-23950/com.example.lenovo.mysecondetest W/System.err: at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:452)
02-13 12:18:12.692 23950-23950/com.example.lenovo.mysecondetest W/System.err: at java.net.Socket.connect(Socket.java:884)
02-13 12:18:12.692 23950-23950/com.example.lenovo.mysecondetest W/System.err: at org.apache.http.conn.scheme.PlainSocketFactory.connectSocket(PlainSocketFactory.java:124)
02-13 12:18:12.692 23950-23950/com.example.lenovo.mysecondetest W/System.err: at org.apache.http.impl.conn.DefaultClientConnectionOperator.openConnection(DefaultClientConnectionOperator.java:149)
02-13 12:18:12.692 23950-23950/com.example.lenovo.mysecondetest W/System.err: at org.apache.http.impl.conn.AbstractPoolEntry.open(AbstractPoolEntry.java:169)
02-13 12:18:12.692 23950-23950/com.example.lenovo.mysecondetest W/System.err: at org.apache.http.impl.conn.AbstractPooledConnAdapter.open(AbstractPooledConnAdapter.java:124)
02-13 12:18:12.692 23950-23950/com.example.lenovo.mysecondetest W/System.err: at org.apache.http.impl.client.DefaultRequestDirector.execute(DefaultRequestDirector.java:366)
02-13 12:18:12.692 23950-23950/com.example.lenovo.mysecondetest W/System.err: at org.apache.http.impl.client.AbstractHttpClient.execute(AbstractHttpClient.java:560)
02-13 12:18:12.692 23950-23950/com.example.lenovo.mysecondetest W/System.err: at org.apache.http.impl.client.AbstractHttpClient.execute(AbstractHttpClient.java:492)
02-13 12:18:12.693 23950-23950/com.example.lenovo.mysecondetest W/System.err: at org.apache.http.impl.client.AbstractHttpClient.execute(AbstractHttpClient.java:470)
02-13 12:18:12.693 23950-23950/com.example.lenovo.mysecondetest W/System.err: at com.example.lenovo.mysecondetest.CdesNonTraiteActivity.onCreate(CdesNonTraiteActivity.java:51)
02-13 12:18:12.693 23950-23950/com.example.lenovo.mysecondetest W/System.err: at android.app.Activity.performCreate(Activity.java:6237)
02-13 12:18:12.693 23950-23950/com.example.lenovo.mysecondetest W/System.err: at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1107)
02-13 12:18:12.693 23950-23950/com.example.lenovo.mysecondetest W/System.err: at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2369)
02-13 12:18:12.693 23950-23950/com.example.lenovo.mysecondetest W/System.err: at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:2476)
02-13 12:18:12.694 23950-23950/com.example.lenovo.mysecondetest W/System.err: at android.app.ActivityThread.-wrap11(ActivityThread.java)
02-13 12:18:12.694 23950-23950/com.example.lenovo.mysecondetest W/System.err: at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1344)
02-13 12:18:12.694 23950-23950/com.example.lenovo.mysecondetest W/System.err: at android.os.Handler.dispatchMessage(Handler.java:102)
02-13 12:18:12.694 23950-23950/com.example.lenovo.mysecondetest W/System.err: at android.os.Looper.loop(Looper.java:148)
02-13 12:18:12.694 23950-23950/com.example.lenovo.mysecondetest W/System.err: at android.app.ActivityThread.main(ActivityThread.java:5417)
02-13 12:18:12.694 23950-23950/com.example.lenovo.mysecondetest W/System.err: at java.lang.reflect.Method.invoke(Native Method)
02-13 12:18:12.694 23950-23950/com.example.lenovo.mysecondetest W/System.err: at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:726)
02-13 12:18:12.694 23950-23950/com.example.lenovo.mysecondetest W/System.err: at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:616)
02-13 12:18:12.694 23950-23950/com.example.lenovo.mysecondetest W/System.err: org.json.JSONException: End of input at character 0 of
02-13 12:18:12.695 23950-23950/com.example.lenovo.mysecondetest W/System.err: at org.json.JSONTokener.syntaxError(JSONTokener.java:449)
02-13 12:18:12.695 23950-23950/com.example.lenovo.mysecondetest W/System.err: at org.json.JSONTokener.nextValue(JSONTokener.java:97)
02-13 12:18:12.695 23950-23950/com.example.lenovo.mysecondetest W/System.err: at org.json.JSONArray.<init>(JSONArray.java:92)
02-13 12:18:12.695 23950-23950/com.example.lenovo.mysecondetest W/System.err: at org.json.JSONArray.<init>(JSONArray.java:108)
02-13 12:18:12.695 23950-23950/com.example.lenovo.mysecondetest W/System.err: at com.example.lenovo.mysecondetest.CdesNonTraiteActivity.onCreate(CdesNonTraiteActivity.java:78)
02-13 12:18:12.695 23950-23950/com.example.lenovo.mysecondetest W/System.err: at android.app.Activity.performCreate(Activity.java:6237)
02-13 12:18:12.695 23950-23950/com.example.lenovo.mysecondetest W/System.err: at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1107)
02-13 12:18:12.695 23950-23950/com.example.lenovo.mysecondetest W/System.err: at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2369)
02-13 12:18:12.695 23950-23950/com.example.lenovo.mysecondetest W/System.err: at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:2476)
02-13 12:18:12.695 23950-23950/com.example.lenovo.mysecondetest W/System.err: at android.app.ActivityThread.-wrap11(ActivityThread.java)
02-13 12:18:12.695 23950-23950/com.example.lenovo.mysecondetest W/System.err: at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1344)
02-13 12:18:12.696 23950-23950/com.example.lenovo.mysecondetest W/System.err: at android.os.Handler.dispatchMessage(Handler.java:102)
02-13 12:18:12.696 23950-23950/com.example.lenovo.mysecondetest W/System.err: at android.os.Looper.loop(Looper.java:148)
02-13 12:18:12.696 23950-23950/com.example.lenovo.mysecondetest W/System.err: at android.app.ActivityThread.main(ActivityThread.java:5417)
02-13 12:18:12.696 23950-23950/com.example.lenovo.mysecondetest W/System.err: at java.lang.reflect.Method.invoke(Native Method)
02-13 12:18:12.696 23950-23950/com.example.lenovo.mysecondetest W/System.err: at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:726)
02-13 12:18:12.696 23950-23950/com.example.lenovo.mysecondetest W/System.err: at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:616)
02-13 12:18:12.804 23950-24061/com.example.lenovo.mysecondetest W/EGL_emulation: eglSurfaceAttrib not implemented
02-13 12:18:12.805 23950-24061/com.example.lenovo.mysecondetest W/OpenGLRenderer: Failed to set EGL_SWAP_BEHAVIOR on surface 0xa19afbc0, error=EGL_SUCCESS
02-13 12:18:13.208 23950-24061/com.example.lenovo.mysecondetest E/Surface: getSlotFromBufferLocked: unknown buffer: 0xa1a871c0
13/02/2016, 14h51
Hephaistos007

Citation:

Envoyé par dimass

02-13 12:18:12.659 23950-23950/com.example.lenovo.mysecondetest W/System.err: android.os.NetworkOnMainThreadException

Encore et toujours le même problème : NetworkOnMainThreadException

Explication & solution possible avec une AsyncTask : http://olegoaer.developpez.com/tutos...oid/rpc/#LII-A