Android上的Symfony3 JSONResponse

Question

因此，我使用createQuery连接到我的symfony数据库，其原则如下

// JSON ACTION
public function jsonAction()
{
$em = $this->getDoctrine()->getEntityManager();
$query = $em->createQuery('SELECT pa FROM CBMedBundle:Patients pa');
$myArray = $query->getArrayResult();
return new JsonResponse($myArray);
}

在url:http://localhost/symfony/web/app_dev.php/json，现在我要在Android（eclipse Android）上导出结果(jsonreponse)，并在那里显示响应！我怎么能那么做？

我在google上找到了这段关于在Android上显示json代码的代码，但我不知道如何适应我的问题。谢谢

    public class MainActivity extends Activity {
        TextView t;
        @Override
        public void onCreate(Bundle savedInstanceState) {
            super.onCreate(savedInstanceState);
            setContentView(R.layout.activity_main);
            t = (TextView) findViewById(R.id.text1);
         StrictMode.ThreadPolicy policy = new StrictMode.ThreadPolicy.Builder().permitAll().build();
         StrictMode.setThreadPolicy(policy);
         t.setText(getServerData(strURL));
        }
         public static final String strURL = "http://10.0.2.2/connexion.php";

         private String getServerData(String returnString) {
             InputStream is = null;
             String result ="";

             ArrayList<NameValuePair> nameValuePaires = new ArrayList<NameValuePair>();
             nameValuePaires.add(new BasicNameValuePair("tblville","tblville"));
             // Envoie de la commande Http
             try{
                 HttpClient httpclient = new DefaultHttpClient();
                 HttpPost httppost = new HttpPost(strURL);
                 httppost.setEntity(new UrlEncodedFormEntity(nameValuePaires));
                 HttpResponse response = httpclient.execute(httppost);
                 HttpEntity entity = response.getEntity();
                 is = entity.getContent();
         }
         catch(Exception e){
          Log.e("log_tag","Error in http connection "+e.toString());
           }


         //conversion de la réponse en chaine de caractère
            try
            {
             BufferedReader reader = new BufferedReader(new InputStreamReader(is,"UTF-8"));

             StringBuilder sb  = new StringBuilder();

             String line = null;

             while ((line = reader.readLine()) != null) 
             {
                  sb.append(line + "\n");
             }

             is.close();

             result = sb.toString();
            }
            catch(Exception e)
            {
             Log.e("log_tag","Error converting result"+e.toString());
            }
            //recuperation des donnees json
            try{
              JSONArray jArray = new JSONArray(result);

                 for(int i=0;i<jArray.length();i++)
                 {

                       JSONObject json_data = jArray.getJSONObject(i);
                       Log.i("log_tag","ID_ville : "+json_data.getString("ID_ville")+" , Nom_ville : "+json_data.getString("Nom_ville")
                               );
                        returnString += "\n\t" + jArray.getJSONObject(i);

                }
            }
                catch(JSONException e){
                 Log.e("log_tag","Error Parsing data"+e.toString());
                } 
                return returnString;

    }
    }

[{"id":1,"nom":"Kane","prenom":"Samba","DateNaissance":{"date":"1995-03-08     00:00:00","timezone_type":3,"timezone":"Europe\/Paris"},"LieudeNaissance":"Nouakchott","sexe":"Homme","adresse":"Tunis","profession":"Etudiant","NumerodeTel":"[phone]","Email":"[e-mail]","SituationFamilial":"Mari\u00e9"},{"id":2,"nom":"Bebeskho","prenom":"AllStar","DateNaissance":{"date":"1995-02-08 00:00:00","timezone_type":3,"timezone":"Europe\/Paris"},"LieudeNaissance":"Bamako","sexe":"Homme","adresse":"Tunis","profession":"Cuisinier","NumerodeTel":"[phone]","Email":"[e-mail]","SituationFamilial":"C\u00e9libataire"},{"id":3,"nom":"Vecenzo","prenom":"Gaimno","DateNaissance":{"date":"1995-01-01 00:00:00","timezone_type":3,"timezone":"Europe\/Paris"},"LieudeNaissance":"Tunis","sexe":"Homme","adresse":"Ariana","profession":"Etudiant","NumerodeTel":"[phone]","Email":"vecenzogo","SituationFamilial":"Mari\u00e9"},{"id":4,"nom":"Diara","prenom":"Bakary","DateNaissance":{"date":"1995-06-10 00:00:00","timezone_type":3,"timezone":"Europe\/Paris"},"LieudeNaissance":"Dakar","sexe":"Homme","adresse":"Dakar Sacr\u00e9 Coeur","profession":"Etudiant","NumerodeTel":"[phone]","Email":"[e-mail]","SituationFamilial":"C\u00e9libataire"}]

Answer 1

为了使代码适合您的目的，您需要更改URL以指向您的服务器。将public static final String strURL=“http://10.0.2.2/connexion.php”；更改为http:// /symfony/web/app_dev.php/JSON （假设HTTP-GET请求返回粘贴的JSON数组）。然后修改JSON处理代码以提取JSON文件中包含的详细信息，如下所示：

    for(int i=0;i<jArray.length();i++)
     {

        JSONObject personJSONData= jArray.getJSONObject(i);
        String id = personJSONData.getString("id");
        String nom = personJSONData.getString("nom");
        //do the same for the other attributes
        //note that according to your JSON file, DateNaissance is a JSONObject - so you have to do something like
       JSONObject dateNaissanceObject = personJSONData.getJSONObject("DateNaissance");

 }

但是我确实建议您使用类似Gson的方法将传入的JSON有效负载解析为一个“Person”对象列表。作为一个示例，假设您已经创建了一个Person类，您将执行以下操作：

list persons=gson.fromjson(result,new typeToken >(){}.gettype（））； 。这里是一个很好的例子--这里是另一个使用Gson的很好的例子--这里还有一个很好的教程。