Introducción:
¿Hola que tal? vamos a ver como, generar una consulta Mysql a un servidor Hostinger, recibir la respuesta en Json, decodificarla en Android y Generar un ListView, para poder implementar lo dicho.
MySQL Database.
Estructura proyecto.
Permisos INTERNET en AndroidManifest.xml
Archivos PHP e conexión.
Implementar JSONParser y MainActivity.
Implementar XML.
Finalmente compilar.
1. MySQL database.
CREATE TABLE IF NOT EXISTS `producto` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`nombre` varchar(150) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
2.Estructura proyecto
AndroidManifest.xml
JSONParser
MainActivity
activity_main.xml
single_post.xml
3.Permisos INTERNET.
En el archivo principal AndroidManifest.xml , pondremos este codigo.
<uses-permission android:name="android.permission.INTERNET"
android:maxSdkVersion="18"/>
4.Archivos PHP
Archivos necesarios para tu servidor web aqui
db_config.php
Productos.php
5.Implementar JSONParser y MainActivity
JSONParser
import android.util.Log;
import org.apache.http.HttpEntity;
import org.apache.http.HttpResponse;
import org.apache.http.client.ClientProtocolException;
import org.apache.http.client.entity.UrlEncodedFormEntity;
import org.apache.http.client.methods.HttpGet;
import org.apache.http.client.methods.HttpPost;
import org.apache.http.client.utils.URLEncodedUtils;
import org.apache.http.impl.client.DefaultHttpClient;
import org.json.JSONException;
import org.json.JSONObject;
import java.io.BufferedReader;
import java.io.IOException;
import java.io.InputStream;
import java.io.InputStreamReader;
import java.io.UnsupportedEncodingException;
import java.util.List;
public class JSONParser {
static InputStream is = null;
static JSONObject jObj = null;
static String json = "";
// constructor
public JSONParser() {
}
// function get json from url
// by making HTTP POST or GET mehtod
public JSONObject makeHttpRequest(String url, String method, List params) {
// Making HTTP request
try {
// check for request method
if (method.equals("POST") {
// request method is POST
// defaultHttpClient
DefaultHttpClient httpClient = new DefaultHttpClient();
HttpPost httpPost = new HttpPost(url);
httpPost.setEntity(new UrlEncodedFormEntity(params));
HttpResponse httpResponse = httpClient.execute(httpPost);
HttpEntity httpEntity = httpResponse.getEntity();
is = httpEntity.getContent();
} else if (method.equals("GET") {
// request method is GET
DefaultHttpClient httpClient = new DefaultHttpClient();
String paramString = URLEncodedUtils.format(params, "utf-8";
url += "?" + paramString;
HttpGet httpGet = new HttpGet(url);
HttpResponse httpResponse = httpClient.execute(httpGet);
HttpEntity httpEntity = httpResponse.getEntity();
is = httpEntity.getContent();
}
} catch (UnsupportedEncodingException e) {
e.printStackTrace();
} catch (ClientProtocolException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
}
try {
BufferedReader reader = new BufferedReader(new InputStreamReader(
is, "iso-8859-1", 8);
StringBuilder sb = new StringBuilder();
String line;
while ((line = reader.readLine()) != null) {
sb.append(line + "n";
}
is.close();
json = sb.toString();
} catch (Exception e) {
Log.e("Buffer Error", "Error converting result " + e.toString());
}
// try parse the string to a JSON object
try {
jObj = new JSONObject(json);
} catch (JSONException e) {
Log.e("JSON Parser", "Error parsing data " + e.toString());
}
// return JSON String
return jObj;
}
}
----------------------------
MainActivity
import android.app.ProgressDialog;import android.os.AsyncTask;import android.support.v7.app.ActionBar;import android.support.v7.app.ActionBarActivity;import android.os.Bundle;import android.util.Log;import android.view.MenuItem;import android.widget.ListAdapter;import android.widget.ListView;import android.widget.SimpleAdapter;import org.json.JSONArray;import org.json.JSONException;import org.json.JSONObject;import java.util.ArrayList;import java.util.HashMap;import java.util.List;
public class MainActivity extends ActionBarActivity {
// Progress Dialog private ProgressDialog pDialog;
// Creating JSON Parser object JSONParser jParser = new JSONParser();
ArrayList<HashMap<String, String>> productesList;
// JSON Node names private static final String TAG_SUCCESS = "success"; private static final String TAG_PRODUCTS = "productos"; private static final String TAG_NAME = "nombre";
// products JSONArray JSONArray products = null;
ListView lista;
@Override public void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState); setContentView(R.layout.activity_main);
// Hashmap para el ListView productesList = new ArrayList<>();
// Cargar los productos en el Background Thread new LoadAllProducts().execute(); lista = (ListView) findViewById(R.id.listAllProducts);
ActionBar actionBar = getSupportActionBar(); actionBar.setDisplayHomeAsUpEnabled(true);
}//fin onCreate
@Override public boolean onOptionsItemSelected(MenuItem item) {
switch (item.getItemId()) { // Respond to the action bar's Up/Home button case android.R.id.home: finish(); return true; } return super.onOptionsItemSelected(item); } class LoadAllProducts extends AsyncTask<String, String, String> {
/** * Antes de empezar el background thread Show Progress Dialog * */ @Override protected void onPreExecute() { super.onPreExecute(); pDialog = new ProgressDialog(MainActivity.this); pDialog.setMessage("Cargando..."; pDialog.setIndeterminate(false); pDialog.setCancelable(false); pDialog.show(); }
/** * obteniendo todos los productos * */ protected String doInBackground(String... args) { // Building Parameters List params = new ArrayList(); // getting JSON string from URL String url_all_empresas = "http://pruevasandroid.esy.es/Productos.php"; JSONObject json = jParser.makeHttpRequest(url_all_empresas, "GET", params);
// Check your log cat for JSON reponse Log.d("All Products: ", json.toString());
try { // Checking for SUCCESS TAG int success = json.getInt(TAG_SUCCESS);
if (success == 1) { // products found // Getting Array of Products products = json.getJSONArray(TAG_PRODUCTS);
// looping through All Products //Log.i("ramiro", "produtos.length" + products.length()); for (int i = 0; i < products.length(); i++) { JSONObject c = products.getJSONObject(i);
// Storing each json item in variable String prod = c.getString(TAG_NAME);
// creating new HashMap HashMap<String, String> map = new HashMap<>();
// adding each child node to HashMap key => value
map.put(TAG_NAME, prod);
productesList.add(map); } } } catch (JSONException e) { e.printStackTrace(); } return null; }
/** * After completing background task Dismiss the progress dialog * **/ protected void onPostExecute(String file_url) { // dismiss the dialog after getting all products pDialog.dismiss(); // updating UI from Background Thread runOnUiThread(new Runnable() { public void run() { /** * Updating parsed JSON data into ListView * */ ListAdapter adapter = new SimpleAdapter( MainActivity.this, productesList, R.layout.single_post, new String[] { TAG_NAME, }, new int[] { R.id.nombre,
}); // updating listview //setListAdapter(adapter); lista.setAdapter(adapter); } }); } }}
6.Implementar XML
Activity_main.xml
<RelativeLayout xmlns:android="http://schemas.android.com/apk/res/android" xmlns:tools="http://schemas.android.com/tools" android:layout_width="match_parent" android:layout_height="match_parent" android:paddingLeft="@dimen/activity_horizontal_margin" android:paddingRight="@dimen/activity_horizontal_margin" android:paddingTop="@dimen/activity_vertical_margin" android:paddingBottom="@dimen/activity_vertical_margin" tools:context=".MainActivity" android:id="@+id/main" android:clickable="false">
<ListView android:id="@+id/listAllProducts" android:layout_width="fill_parent" android:layout_height="wrap_content" android:dividerHeight="3dp" android:background="#fff"/></RelativeLayout>
----------------------------------
single_post.xml
<?xml version="1.0" encoding="utf-8"?><LinearLayout xmlns:android="http://schemas.android.com/apk/res/android" android:layout_width="fill_parent" android:layout_height="match_parent" android:background="#f0f0f0" android:orientation="vertical" >
<TextView
android:text="nombre" android:id="@+id/nombre" android:layout_width="wrap_content" android:layout_height="wrap_content" android:layout_gravity="bottom" android:paddingBottom="2dip" android:padding="10dp" android:textColor="#333" android:textSize="12dp" android:textStyle="bold" android:layout_column="0"
android:background="#ffff9000" />
</LinearLayout>
7.Compilar
El resultado al compilar.
Espero que les ayude, gracias y hasta la próxima.
¿Hola que tal? vamos a ver como, generar una consulta Mysql a un servidor Hostinger, recibir la respuesta en Json, decodificarla en Android y Generar un ListView, para poder implementar lo dicho.
MySQL Database.
Estructura proyecto.
Permisos INTERNET en AndroidManifest.xml
Archivos PHP e conexión.
Implementar JSONParser y MainActivity.
Implementar XML.
Finalmente compilar.
1. MySQL database.
CREATE TABLE IF NOT EXISTS `producto` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`nombre` varchar(150) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
2.Estructura proyecto
AndroidManifest.xml
JSONParser
MainActivity
activity_main.xml
single_post.xml
3.Permisos INTERNET.
En el archivo principal AndroidManifest.xml , pondremos este codigo.
<uses-permission android:name="android.permission.INTERNET"
android:maxSdkVersion="18"/>
4.Archivos PHP
Archivos necesarios para tu servidor web aqui
db_config.php
Productos.php
5.Implementar JSONParser y MainActivity
JSONParser
import android.util.Log;
import org.apache.http.HttpEntity;
import org.apache.http.HttpResponse;
import org.apache.http.client.ClientProtocolException;
import org.apache.http.client.entity.UrlEncodedFormEntity;
import org.apache.http.client.methods.HttpGet;
import org.apache.http.client.methods.HttpPost;
import org.apache.http.client.utils.URLEncodedUtils;
import org.apache.http.impl.client.DefaultHttpClient;
import org.json.JSONException;
import org.json.JSONObject;
import java.io.BufferedReader;
import java.io.IOException;
import java.io.InputStream;
import java.io.InputStreamReader;
import java.io.UnsupportedEncodingException;
import java.util.List;
public class JSONParser {
static InputStream is = null;
static JSONObject jObj = null;
static String json = "";
// constructor
public JSONParser() {
}
// function get json from url
// by making HTTP POST or GET mehtod
public JSONObject makeHttpRequest(String url, String method, List params) {
// Making HTTP request
try {
// check for request method
if (method.equals("POST") {
// request method is POST
// defaultHttpClient
DefaultHttpClient httpClient = new DefaultHttpClient();
HttpPost httpPost = new HttpPost(url);
httpPost.setEntity(new UrlEncodedFormEntity(params));
HttpResponse httpResponse = httpClient.execute(httpPost);
HttpEntity httpEntity = httpResponse.getEntity();
is = httpEntity.getContent();
} else if (method.equals("GET") {
// request method is GET
DefaultHttpClient httpClient = new DefaultHttpClient();
String paramString = URLEncodedUtils.format(params, "utf-8";
url += "?" + paramString;
HttpGet httpGet = new HttpGet(url);
HttpResponse httpResponse = httpClient.execute(httpGet);
HttpEntity httpEntity = httpResponse.getEntity();
is = httpEntity.getContent();
}
} catch (UnsupportedEncodingException e) {
e.printStackTrace();
} catch (ClientProtocolException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
}
try {
BufferedReader reader = new BufferedReader(new InputStreamReader(
is, "iso-8859-1", 8);
StringBuilder sb = new StringBuilder();
String line;
while ((line = reader.readLine()) != null) {
sb.append(line + "n";
}
is.close();
json = sb.toString();
} catch (Exception e) {
Log.e("Buffer Error", "Error converting result " + e.toString());
}
// try parse the string to a JSON object
try {
jObj = new JSONObject(json);
} catch (JSONException e) {
Log.e("JSON Parser", "Error parsing data " + e.toString());
}
// return JSON String
return jObj;
}
}
----------------------------
MainActivity
import android.app.ProgressDialog;import android.os.AsyncTask;import android.support.v7.app.ActionBar;import android.support.v7.app.ActionBarActivity;import android.os.Bundle;import android.util.Log;import android.view.MenuItem;import android.widget.ListAdapter;import android.widget.ListView;import android.widget.SimpleAdapter;import org.json.JSONArray;import org.json.JSONException;import org.json.JSONObject;import java.util.ArrayList;import java.util.HashMap;import java.util.List;
public class MainActivity extends ActionBarActivity {
// Progress Dialog private ProgressDialog pDialog;
// Creating JSON Parser object JSONParser jParser = new JSONParser();
ArrayList<HashMap<String, String>> productesList;
// JSON Node names private static final String TAG_SUCCESS = "success"; private static final String TAG_PRODUCTS = "productos"; private static final String TAG_NAME = "nombre";
// products JSONArray JSONArray products = null;
ListView lista;
@Override public void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState); setContentView(R.layout.activity_main);
// Hashmap para el ListView productesList = new ArrayList<>();
// Cargar los productos en el Background Thread new LoadAllProducts().execute(); lista = (ListView) findViewById(R.id.listAllProducts);
ActionBar actionBar = getSupportActionBar(); actionBar.setDisplayHomeAsUpEnabled(true);
}//fin onCreate
@Override public boolean onOptionsItemSelected(MenuItem item) {
switch (item.getItemId()) { // Respond to the action bar's Up/Home button case android.R.id.home: finish(); return true; } return super.onOptionsItemSelected(item); } class LoadAllProducts extends AsyncTask<String, String, String> {
/** * Antes de empezar el background thread Show Progress Dialog * */ @Override protected void onPreExecute() { super.onPreExecute(); pDialog = new ProgressDialog(MainActivity.this); pDialog.setMessage("Cargando..."; pDialog.setIndeterminate(false); pDialog.setCancelable(false); pDialog.show(); }
/** * obteniendo todos los productos * */ protected String doInBackground(String... args) { // Building Parameters List params = new ArrayList(); // getting JSON string from URL String url_all_empresas = "http://pruevasandroid.esy.es/Productos.php"; JSONObject json = jParser.makeHttpRequest(url_all_empresas, "GET", params);
// Check your log cat for JSON reponse Log.d("All Products: ", json.toString());
try { // Checking for SUCCESS TAG int success = json.getInt(TAG_SUCCESS);
if (success == 1) { // products found // Getting Array of Products products = json.getJSONArray(TAG_PRODUCTS);
// looping through All Products //Log.i("ramiro", "produtos.length" + products.length()); for (int i = 0; i < products.length(); i++) { JSONObject c = products.getJSONObject(i);
// Storing each json item in variable String prod = c.getString(TAG_NAME);
// creating new HashMap HashMap<String, String> map = new HashMap<>();
// adding each child node to HashMap key => value
map.put(TAG_NAME, prod);
productesList.add(map); } } } catch (JSONException e) { e.printStackTrace(); } return null; }
/** * After completing background task Dismiss the progress dialog * **/ protected void onPostExecute(String file_url) { // dismiss the dialog after getting all products pDialog.dismiss(); // updating UI from Background Thread runOnUiThread(new Runnable() { public void run() { /** * Updating parsed JSON data into ListView * */ ListAdapter adapter = new SimpleAdapter( MainActivity.this, productesList, R.layout.single_post, new String[] { TAG_NAME, }, new int[] { R.id.nombre,
}); // updating listview //setListAdapter(adapter); lista.setAdapter(adapter); } }); } }}
6.Implementar XML
Activity_main.xml
<RelativeLayout xmlns:android="http://schemas.android.com/apk/res/android" xmlns:tools="http://schemas.android.com/tools" android:layout_width="match_parent" android:layout_height="match_parent" android:paddingLeft="@dimen/activity_horizontal_margin" android:paddingRight="@dimen/activity_horizontal_margin" android:paddingTop="@dimen/activity_vertical_margin" android:paddingBottom="@dimen/activity_vertical_margin" tools:context=".MainActivity" android:id="@+id/main" android:clickable="false">
<ListView android:id="@+id/listAllProducts" android:layout_width="fill_parent" android:layout_height="wrap_content" android:dividerHeight="3dp" android:background="#fff"/></RelativeLayout>
----------------------------------
single_post.xml
<?xml version="1.0" encoding="utf-8"?><LinearLayout xmlns:android="http://schemas.android.com/apk/res/android" android:layout_width="fill_parent" android:layout_height="match_parent" android:background="#f0f0f0" android:orientation="vertical" >
<TextView
android:text="nombre" android:id="@+id/nombre" android:layout_width="wrap_content" android:layout_height="wrap_content" android:layout_gravity="bottom" android:paddingBottom="2dip" android:padding="10dp" android:textColor="#333" android:textSize="12dp" android:textStyle="bold" android:layout_column="0"
android:background="#ffff9000" />
</LinearLayout>
7.Compilar
El resultado al compilar.
Espero que les ayude, gracias y hasta la próxima.