Databases
StackOverflow2013
Postsdbo
POJson array with null values
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POJson array with null values
    primarykey
    data
    text
    <p>I have trouble with a JSON array, and I really hope there is someone who can help me.</p> <p>Lets say I have a class with JSON data and I'm sending "intent putextra" to another activity.</p> <p>How can I change the value of null before I send it to another activity? I did a few prints to discover the null values and they are different, example : </p> <pre><code> Monday : null Tuesday : 08:30 - 18:00 Wednesday : 09:00 - 17:00 **and so on.** </code></pre> <p><strong>The problem</strong> is that --> I have all json data and I parsing them into objects, but I would like to before "intent.putextra" and send them to another activity finds null and replace them with "Closed"</p> <p>so it will look like</p> <pre><code> Monday : Closed Tuesday : 08:30 - 18:00 Wednesday : 09:00 - 17:00 </code></pre> <p><strong>EDIT</strong></p> <pre><code>public class LocationBased extends ListActivity{ // JSON Node names private static final String TAG_Location = "location_id"; private static final String TAG_Company = "company_id"; private static final String TAG_NAME = "name"; private static final String TAG_ADDRESS = "address"; private static final String TAG_PLACE = "place"; private static final String TAG_POSTAL = "postal"; private static final String TAG_CITY = "city"; private static final String TAG_MONDAY = "monday"; private static final String TAG_TUESDAY = "tuesday"; private static final String TAG_WEDNESDAY = "wednesday"; private static final String TAG_THURSDAY = "thursday"; private static final String TAG_FRIDAY = "friday"; private static final String TAG_SATURDAY = "saturday"; private static final String TAG_SUNDAY = "sunday"; private static final String TAG_TYPE = "type"; private static final String TAG_LAT = "lat"; private static final String TAG_LNG = "lng"; private static final String TAG_NOCAR = "nocar"; private static final String TAG = "Debug of Project"; // private String a; private String b; @Override public void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState); setContentView(R.layout.main); SQLiteDatabase db = openOrCreateDatabase("mydb.db", Context.MODE_PRIVATE, null); db.execSQL("CREATE TABLE IF NOT EXISTS gps_kordinater (ID INTEGER PRIMARY KEY AUTOINCREMENT, Latitude REAL, Longitude REAL);"); String query = "SELECT Latitude,Longitude FROM gps_kordinater WHERE Id = (SELECT MAX(Id) FROM gps_kordinater)"; Cursor cursor = db.rawQuery(query, null); if(cursor != null) { cursor.moveToFirst(); a = cursor.getString(0); b = cursor.getString(1); } String url = "http://webservice.XXX.XX/webservice/getLocationList.php?lat="+ a +"&amp;lng="+ b +""; Log.d(TAG, "Leyth URL = Lat : " + a +" Long : " + b); // now enabled if disabled = ingen support for jb aka 4.0 if (android.os.Build.VERSION.SDK_INT &gt; 9) { StrictMode.ThreadPolicy policy = new StrictMode.ThreadPolicy.Builder().permitAll().build(); StrictMode.setThreadPolicy(policy); } ArrayList&lt;HashMap&lt;String, String&gt;&gt; contactList = new ArrayList&lt;HashMap&lt;String, String&gt;&gt;(); JSONParser jParser = new JSONParser(); JSONArray json = jParser.getJSONFromUrl(url); try { for(int i = 0; i &lt; json.length(); i++){ JSONObject c = json.getJSONObject(i); String location_id = c.getString(TAG_Location); String company_id = c.getString(TAG_Company); String name = c.getString(TAG_NAME); String address = c.getString(TAG_ADDRESS); String place = c.getString(TAG_PLACE); String postal = c.getString(TAG_POSTAL); String city = c.getString(TAG_CITY); String monday = c.getString(TAG_MONDAY); String tuesday = c.getString(TAG_TUESDAY); String wednesday = c.getString(TAG_WEDNESDAY); String thursday = c.getString(TAG_THURSDAY); String friday = c.getString(TAG_FRIDAY); String saturday = c.getString(TAG_SATURDAY); String sunday = c.getString(TAG_SUNDAY); String type = c.getString(TAG_TYPE); String lat = c.getString(TAG_LAT); String lng = c.getString(TAG_LNG); String nocar = c.getString(TAG_NOCAR); // creating new HashMap HashMap&lt;String, String&gt; map = new HashMap&lt;String, String&gt;(); // adding each child node to HashMap key =&gt; value map.put(TAG_Location, location_id); map.put(TAG_Company, company_id); map.put(TAG_NAME, name); map.put(TAG_ADDRESS, address); map.put(TAG_PLACE, place); map.put(TAG_POSTAL, postal); map.put(TAG_CITY, city); map.put(TAG_MONDAY, monday); map.put(TAG_TUESDAY, tuesday); map.put(TAG_WEDNESDAY, wednesday); map.put(TAG_THURSDAY, thursday); map.put(TAG_FRIDAY, friday); map.put(TAG_SATURDAY, saturday); map.put(TAG_SUNDAY, sunday); map.put(TAG_TYPE, type); map.put(TAG_LAT, lat); map.put(TAG_LNG, lng); map.put(TAG_NOCAR, nocar); // Log.d(TAG, "Leyth Days = Mandag : " + monday +" Onsdag : " + wednesday); // adding HashList to ArrayList contactList.add(map); } } catch (JSONException e) { e.printStackTrace(); Log.e("JSON Parser", "Error parsing data " + e.toString()); } /** * Updating parsed JSON data into ListView * */ ListAdapter adapter = new SimpleAdapter(this, contactList, R.layout.list_item, new String[] { TAG_LAT, TAG_LNG, TAG_POSTAL }, new int[] { R.id.name, R.id.email, R.id.mobile }); setListAdapter(adapter); // selecting single ListView item ListView lv = getListView(); // Launching new screen on Selecting Single ListItem lv.setOnItemClickListener(new OnItemClickListener() { @Override public void onItemClick(AdapterView&lt;?&gt; parent, View view, int position, long id) { // getting values from selected ListItem String name = ((TextView) view.findViewById(R.id.name)).getText().toString(); String cost = ((TextView) view.findViewById(R.id.email)).getText().toString(); String description = ((TextView) view.findViewById(R.id.mobile)).getText().toString(); String mandag = ((TextView) view.findViewById(R.id.mandag)).getText().toString(); String tirsdag = ((TextView) view.findViewById(R.id.tirsdag)).getText().toString(); String onsdag = ((TextView) view.findViewById(R.id.onsdag)).getText().toString(); String torsdag = ((TextView) view.findViewById(R.id.torsdag)).getText().toString(); String fredag = ((TextView) view.findViewById(R.id.fredag)).getText().toString(); String lordag = ((TextView) view.findViewById(R.id.lordag)).getText().toString(); String sondag = ((TextView) view.findViewById(R.id.sondag)).getText().toString(); // Starting new intent Intent in = new Intent(getApplicationContext(), dk.mitaffald.maps.MainActivity.class); in.putExtra(TAG_LAT, name); in.putExtra(TAG_LNG, cost); in.putExtra(TAG_Company, description); in.putExtra(TAG_MONDAY, mandag); in.putExtra(TAG_TUESDAY, tirsdag); in.putExtra(TAG_WEDNESDAY, onsdag); in.putExtra(TAG_THURSDAY, torsdag); in.putExtra(TAG_FRIDAY, fredag); in.putExtra(TAG_SATURDAY, lordag); in.putExtra(TAG_SUNDAY, sondag); startActivity(in); } }); } </code></pre> <p>}</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USRich
    1. USTirolel
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POJson array with null values
      1. This table or related slice is empty.
      1. VTApproveEditSuggestion
    1. COhere is the updated code Mr.Me
      singulars
      1. POJson array with null values
      1. USTirolel
    2. COcheck my answer
      singulars
      1. POJson array with null values
      1. USPragnani
    3. COHave you tried my solution...?
      singulars
      1. POJson array with null values
      1. USPragnani
 

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