Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>You ark two questions, the first, how to parse the sub json; second, how to display image from the net; I made a successful demo by your sample json url as follows:</p> <p>First, define a data class: Data.java</p> <pre><code> package com.example.jsonparser; import java.util.ArrayList; public class Data { private String mState; private String mImageUrl; private String mTitle; private String mSummary; private ArrayList&lt;String&gt; mAddList; private String mUrl; public Data(String mState, String mImageUrl, String mTitle, String mSummary, ArrayList&lt;String&gt; addList, String mUrl) { super(); this.mState = mState; this.mImageUrl = mImageUrl; this.mTitle = mTitle; this.mSummary = mSummary; this.mAddList = addList; this.mUrl = mUrl; } public String getmState() { return mState; } public void setmState(String mState) { this.mState = mState; } public String getmImageUrl() { return mImageUrl; } public void setmImageUrl(String mImageUrl) { this.mImageUrl = mImageUrl; } public String getmTitle() { return mTitle; } public void setmTitle(String mTitle) { this.mTitle = mTitle; } public String getmSummary() { return mSummary; } public void setmSummary(String mSummary) { this.mSummary = mSummary; } public ArrayList&lt;String&gt; getmAddress1() { return mAddList; } public void setmAddress1(ArrayList&lt;String&gt; mAddress1) { this.mAddList = mAddress1; } public String getmUrl() { return mUrl; } public void setmUrl(String mUrl) { this.mUrl = mUrl; } } </code></pre> <p>Second, define a parser class for parsing the json string: Parser.java</p> <pre><code> package com.example.jsonparser; import java.util.ArrayList; import org.json.JSONArray; import org.json.JSONException; import org.json.JSONObject; import android.util.Log; public class Parser { private ArrayList&lt;Data&gt; mDataSource = new ArrayList&lt;Data&gt;(); public Parser(String json) { jsonParser(json); } private void jsonParser(String json) { try { JSONObject obj = new JSONObject(json); JSONObject var = obj.getJSONObject("data"); JSONArray list = var.getJSONArray("product"); int len = list.length(); for (int i = 0; i &lt; len; i++) { try { JSONObject data = list.getJSONObject(i); String state = data.getString("state"); String image = data.getString("image"); String title = data.getString("title"); String summary = data.getString("summary"); String url = data.getString("url"); ArrayList&lt;String&gt; addList = new ArrayList&lt;String&gt;(); JSONArray addArray = data.getJSONArray("address"); int size = addArray.length(); /** * parser sub json */ for(int j = 0; j &lt; size; j++) { addList.add(addArray.getJSONObject(j).getString("address")); } mDataSource.add(new Data(state, image, title, summary, addList, url)); } catch (JSONException e) { // TODO Auto-generated catch block e.printStackTrace(); } } } catch (JSONException e) { // TODO Auto-generated catch block e.printStackTrace(); } } public ArrayList&lt;Data&gt; getSource() { return mDataSource; } } </code></pre> <p>Third, define a task download image by url: DownloadImageTask.java</p> <pre><code> package com.example.jsonparser; import java.io.IOException; import java.io.InputStream; import java.net.HttpURLConnection; import java.net.MalformedURLException; import java.net.URL; import android.graphics.Bitmap; import android.graphics.BitmapFactory; import android.os.AsyncTask; import android.widget.ImageView; public class DownloadImageTask extends AsyncTask&lt;Void, Void, Bitmap&gt; { private String mUrl; private ImageView mImageView = null; public DownloadImageTask(String Url, ImageView imageView) { mUrl = Url; this.mImageView = imageView; } protected void onPostExecute(Bitmap result) { super.onPostExecute(result); if (result != null) { mImageView.setImageBitmap(result); } } protected Bitmap doInBackground(Void... params) { Bitmap bitmap = getBitmap(mUrl); return bitmap; } public Bitmap getBitmap(String imageUrl) { Bitmap mBitmap = null; try { URL url = new URL(imageUrl); HttpURLConnection conn = (HttpURLConnection) url.openConnection(); InputStream is = conn.getInputStream(); mBitmap = BitmapFactory.decodeStream(is); } catch (MalformedURLException e) { e.printStackTrace(); } catch (IOException e) { e.printStackTrace(); } return mBitmap; } } </code></pre> <p>Forth, define a adapter extend BaseAdapter for displaying the data and image: Adapter.java</p> <pre><code> package com.example.jsonparser; import java.util.ArrayList; import android.app.Activity; import android.view.LayoutInflater; import android.view.View; import android.view.ViewGroup; import android.widget.AbsListView; import android.widget.AbsListView.RecyclerListener; import android.widget.BaseAdapter; import android.widget.ImageView; import android.widget.TextView; public class Adapter extends BaseAdapter { private static final String TAG = "Adapter"; private Activity mActivity; public ArrayList&lt;Data&gt; mObjects; static class ViewHolder { ImageView icon; TextView title; DownloadImageTask mTask; } public Adapter(Activity activity, ArrayList&lt;Data&gt; mObjects) { this.mActivity = (Activity) activity; this.mObjects = mObjects; } public void setObjects(ArrayList&lt;Data&gt; mObjects) { this.mObjects = mObjects; } @Override public View getView(int position, View convertView, ViewGroup parent) { Data item = mObjects.get(position); View rowView = convertView; if (rowView == null) { LayoutInflater inflater = mActivity.getLayoutInflater(); rowView = inflater.inflate(R.layout.item, parent, false); ViewHolder viewHolder = new ViewHolder(); viewHolder.icon = (ImageView) rowView.findViewById(R.id.image); viewHolder.title = (TextView) rowView.findViewById(R.id.title); rowView.setTag(viewHolder); } ViewHolder holder = (ViewHolder) rowView.getTag(); holder.title.setText(item.getmTitle()); holder.icon.setBackgroundResource(R.drawable.ic_launcher); holder.mTask = new DownloadImageTask(item.getmImageUrl(), holder.icon); if (!holder.mTask.isCancelled()) { holder.mTask.execute(); } return rowView; } @Override public int getCount() { return (this.mObjects.size()); } @Override public Object getItem(int position) { return (this.mObjects.get(position)); } @Override public long getItemId(int position) { return (position); } public AbsListView.RecyclerListener mRecyclerListener = new RecyclerListener( ){ public void onMovedToScrapHeap(View view) { ViewHolder viewHolder = (ViewHolder) view.getTag(); DownloadImageTask imagetask = viewHolder.mTask; if (imagetask != null) { imagetask.cancel(true); } } }; } </code></pre> <p>The last, use these class in activity: MainActivity.java</p> <pre><code> package com.example.jsonparser; 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.client.HttpClient; import org.apache.http.client.methods.HttpPost; import org.apache.http.impl.client.DefaultHttpClient; import android.app.Activity; import android.os.Bundle; import android.os.Handler; import android.os.Message; import android.util.Log; import android.widget.ListView; public class MainActivity extends Activity { private ListView mListView; private Adapter mAdapter; private ArrayList&lt;Data&gt; mSource = new ArrayList&lt;Data&gt;(); @Override protected void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState); setContentView(R.layout.activity_main); mListView = (ListView) findViewById(android.R.id.list); mAdapter = new Adapter(this, mSource); mListView.setAdapter(mAdapter); mListView.setRecyclerListener(mAdapter.mRecyclerListener); final String url = "http://metalgearrisingguide.com/samplejson.json"; new Thread(new Runnable() { @Override public void run() { Parser parser = new Parser(getJSONfromURL(url)); mSource = parser.getSource(); Message msg = mHandler.obtainMessage(); mHandler.sendMessage(msg); } }).start(); } private Handler mHandler = new Handler() { @Override public void handleMessage(Message msg) { mAdapter.setObjects(mSource); mAdapter.notifyDataSetChanged(); } }; public String getJSONfromURL(String url) { InputStream is = null; String result = ""; // http post try { HttpClient httpclient = new DefaultHttpClient(); HttpPost httppost = new HttpPost(url); 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()); } return result; } } </code></pre> <p>activity_main.xml</p> <pre><code> &lt;LinearLayout 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" tools:context=".MainActivity" &gt; &lt;ListView android:id="@android:id/list" android:layout_width="match_parent" android:layout_height="match_parent" android:cacheColorHint="@android:color/transparent" /&gt; &lt;/LinearLayout&gt; </code></pre> <p>item.xml</p> <pre><code> &lt;?xml version="1.0" encoding="utf-8"?&gt; &lt;LinearLayout xmlns:android="http://schemas.android.com/apk/res/android" android:layout_width="match_parent" android:layout_height="wrap_content" android:orientation="horizontal" &gt; &lt;ImageView android:id="@+id/image" android:layout_width="40dp" android:layout_height="40dp" android:layout_gravity="left|top" android:layout_marginBottom="10dp" android:layout_marginLeft="10dp" android:layout_marginTop="10dp" /&gt; &lt;TextView android:id="@+id/title" android:layout_width="wrap_content" android:layout_height="wrap_content" android:ellipsize="end" android:gravity="left|top" android:lineSpacingExtra="3.0dp" android:textColor="#ffffff" android:textSize="15sp" /&gt; &lt;/LinearLayout&gt; </code></pre> <p>that's all.</p>
    singulars
    1. This table or related slice is empty.
    1. POHow to parse Sub JSONArray and display image?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. USMejonzhan
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POHow to parse Sub JSONArray and display image?
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COWow! that works. You're a genius, it takes me 3 unsuccessful days to parse the sub jsonarray but it took you less than an hour. Thank you!
      singulars
      1. PO
      1. USOneNation
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload