Java - How to convert data from mysql database to a JSON Array?

Question

I have a mysql database with the table "trips" with some columns, it looks like this:

Table Example

Each row contains the data for one trip. And I want to search for the "asg_id" and want to get all rows(trips) with this "asg_id" .

My question is, how to convert this data with the individual trips tho a JSON Array? Or, how can I get all trips with this "asg_id"?

Raghunandan Krishnamurthy · Accepted Answer · 2014-02-05 12:03:30Z

1

JSONObject json = new JSONObject();
json .put("json", collection/object);

request.setAttribute("jsonObject", json.toString());

answered Feb 5, 2014 at 12:03

Raghunandan Krishnamurthy

6955 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Sonali8890 · Accepted Answer · 2014-02-05 12:17:31Z

Try like this:

Cursor c= dbo.rawQuery("SELECT * from trips where asg_id="
                    + id, null);
JSONObject jsonObject = new JSONObject();
JSONObject jsonObjectInner = new JSONObject();   

 if (c!= null && c.getCount() > 0) {

 c.moveToFirst();

try {
do{

jsonObjectInner.put("trip_id", c.getString(c.getColumnIndex("trip_id"));
jsonObjectInner.put("asg_id", c.getString(c.getColumnIndex("asg_id"));
jsonObjectInner.put("date_start", c.getString(c.getColumnIndex("date_start"));
jsonObjectInner.put("time_start",c.getString(c.getColumnIndex("time_start"));
jsonObjectInner.put("time_stop", c.getString(c.getColumnIndex("time_stop"));
jsonObject.put("trip", jsonObjectInner);
 }while(c.moveToNext());

}
catch (Exception e) {
        e.printStackTrace();
          }
}

Collectives™ on Stack Overflow

Java - How to convert data from mysql database to a JSON Array?

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related