JSON String to JSON in Java

Question

I have a couple of txt files that gets some information from android's (call,messages,etc) database and stores it as a Cursor object.

I then convert the Cursor onto a JSON object which is then stored on a txt file on an SD card on the device. When I read from the file I get lines as a String like this one:

{"date":1332969098495,"duration":0,"number":"7038673588","Device_ID":"streak"}

I have to store the values of the String onto a MySQL table. Is there a way that I can convert this back onto a JSON or maybe a Map?

I thought about editing the String so the values are surrounded by a single quote and use the MySQL syntax to simply load the fields on the file.

Thanks!

sathishpaul · Accepted Answer · 2012-08-10 16:03:06Z

1

You can create a JSONObject from the string that you have. That will pretty much give the same functionality as that of java.util.Map. For e.g,

String jsonStr = "json representation of your data";
JSONObject jObj = new JSONObject(jsonStr);
jObj.get(yourKeyString);
//do more with your jObj here...

Hope this helps. Refer the JSONObject documentation for more details.

answered Aug 10, 2012 at 16:03

sathishpaul

1228 bronze badges

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

Comments

user370305 · Accepted Answer · 2012-08-10 15:21:01Z

1

You need to use JSon-lib (or) GSon libraries for this purpose.

Example GSon code would be:

YourObject obj = gson.fromJson(inputJson, YourObject.class);

Note: YourObject is java class with getter/setter.

edited Aug 10, 2012 at 15:21

user370305

109k23 gold badges167 silver badges153 bronze badges

answered Aug 10, 2012 at 15:17

kosa

66.7k15 gold badges134 silver badges170 bronze badges

1 Comment

Clocker Over a year ago

I added a buffered reader that reads from the file, used the gson.FromJson(reader, JSONOBject.class). It seems like the code is just hanging after those statements.

HJW · Accepted Answer · 2012-08-10 16:06:48Z

0

Here is an tutorial of using GSON library to achieve typed object conversion.

http://java.sg/parsing-a-json-string-into-an-object-with-gson-easily/

answered Aug 10, 2012 at 16:06

HJW

23.5k51 gold badges147 silver badges218 bronze badges

Comments

Eddy K · Accepted Answer · 2012-08-10 16:21:07Z

0

Sathishpaul is correct but just to clarify :

JSONObject obj =  new JSONObject(YourJSONString);
Long date = obj.getLong("date");
int duration = obj.getInt("duration");

etc..

answered Aug 10, 2012 at 16:21

Eddy K

8746 silver badges12 bronze badges

Collectives™ on Stack Overflow

JSON String to JSON in Java

4 Answers 4

Comments

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related