从mysql中检索数据并将其显示在listView中 [英] retrieve the data from mysql and display it in a listView

问题描述

我想从mysql中检索数据并将其显示在listView中。

我是初学者我尝试只检索数据但我收到了没法在emelateur。

谢谢你帮我解决了这个问题。





tierss.php

mysql_connect（127.0.0.1，root，）;

mysql_select_db（gestresor）;

$ q = mysql_query（ SELECT * FROM Tiers）;

while（$ e = mysql_fetch_assoc（$ q））

$ output [] = $ e;

print（json_encode（$ output））;

mysql_close（）;

？>





tierss.java

包com.example.login;

import android.app.Activity;

import android.os.Bundle;

import android.util.Log;

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.apache.http.message.BasicNameValuePair;

import org.json.JSONArray;

import org.json。 JSONException;

import org.json.JSONObject;

public clas s Tierss扩展活动{

/ **首次创建活动时调用。 * /

@Override

public void onCreate（Bundle icicle）{

super.onCreate（icicle）;

setContentView（R.layout.activity_tierss）;

String result =;

//要发送的年份数据

ArrayList< namevaluepair> nameValuePairs = new ArrayList< namevaluepair>（）;

//nameValuePairs.add（new BasicNameValuePair（year，1980））;

InputStream is = null;

// http post

try {

HttpClient httpclient = new DefaultHttpClient（）;

HttpPost httppost = new HttpPost（http://10.0.2.2/formation/tierss.php）;

httppost.setEntity（new UrlEncodedFormEntity（nameValuePairs））;

HttpResponse response = httpclient .execute（httppost）;

HttpEntity entity = response.getEntity（）;

is = entity.getContent（）;

} catch（例外e）{

Log.e（log_tag，http连接错误+ e.toString（））;

}

//将响应转换为string

try {

BufferedReader reader = new BufferedReader（new InputStreamReader（is，iso-8859-1），8）;

StringBuilder sb = new StringBuilder（）;

String line = null;

while（（line = reader.readLine（））！= null）{

sb.append（line +\ n）;

}

is.close（）;

result = sb .toString（）;

} catch（异常e）{

Log.e（log_tag，转换结果出错+ e.toString（））; < br $>
}

//解析json数据

尝试{

JSONArray jArray = new JSONArray（result）;

for（int i = 0; i< jarray.length（）; i ++）{>

JSONObject json_data = jArray.getJSONObject（i）;

Log.i（log_tag，id：+ json_data.getInt（Code_Tiers）+， name：+ json_data.getString（Libelle_Tiers）+，tel：+ json_data.getString（Num_Tel_Tiers）+，type：+ json_data.getString（Type_Tiers）+，adresse：+ json_data .getString（Adresse_Tiers）+，代码邮政：+ json_data.getString（Code_Postal）+，ville：+ json_data.getInt（ville））;

} < br $>
}

catch（JSONException e）{

Log.e（log_tag，解析数据时出错+ e.toString（）） ;

}

}}

Hi,
I want to retrieve the data from mysql and display it in a listView.
I am a beginner I try to retrieve only the data but I received nothing in emelateur.
thank you for helping me solve this problem.


tierss.php
mysql_connect("127.0.0.1","root","");
mysql_select_db("gestresor");
$q=mysql_query("SELECT * FROM Tiers");
while($e=mysql_fetch_assoc($q))
$output[]=$e;
print(json_encode($output));
mysql_close();
?>


tierss.java
package com.example.login;
import android.app.Activity;
import android.os.Bundle;
import android.util.Log;
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.apache.http.message.BasicNameValuePair;
import org.json.JSONArray;
import org.json.JSONException;
import org.json.JSONObject;
public class Tierss extends Activity {
/** Called when the activity is first created. */
@Override
public void onCreate(Bundle icicle) {
super.onCreate(icicle);
setContentView(R.layout.activity_tierss);
String result = "";
//the year data to send
ArrayList<namevaluepair> nameValuePairs = new ArrayList<namevaluepair>();
//nameValuePairs.add(new BasicNameValuePair("year","1980"));
InputStream is=null;
//http post
try{
HttpClient httpclient = new DefaultHttpClient();
HttpPost httppost = new HttpPost("http://10.0.2.2/formation/tierss.php");
httppost.setEntity(new UrlEncodedFormEntity(nameValuePairs));
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());
}
//convert response to string
try{
BufferedReader reader = new BufferedReader(new InputStreamReader(is,"iso-8859-1"),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());
}
//parse json data
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: "+json_data.getInt("Code_Tiers")+", name: "+json_data.getString("Libelle_Tiers")+", tel: "+json_data.getString("Num_Tel_Tiers")+", type: "+json_data.getString("Type_Tiers")+", adresse: "+json_data.getString("Adresse_Tiers")+", code postal: "+json_data.getString("Code_Postal")+", ville: "+json_data.getInt("ville"));
}
}
catch(JSONException e){
Log.e("log_tag", "Error parsing data "+e.toString());
}
} }

推荐答案

q = mysql_query（SELECT * FROM Tiers）;

while（

q=mysql_query("SELECT * FROM Tiers");
while(

e = mysql_fetch_assoc（

e=mysql_fetch_assoc(

q））

q))

这篇关于从mysql中检索数据并将其显示在listView中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！