How to create a JSON file getting out data with Java from database?

Question

I am working on tablet web app project, but I don't know how to create JSON file getting out info with Java connecting to database. Info is getting through of Store Procedure and data return with List<Object obj> or with ResultSet. Thanks.

sergiofbsilva · Accepted Answer · 2012-07-20 22:03:38Z

1

You should use a library called json-simple

answered Jul 20, 2012 at 22:03

sergiofbsilva

1,59615 silver badges20 bronze badges

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

Comments

Thimmayya · Accepted Answer · 2012-07-20 22:17:46Z

1

Use Jackson library to convert any Java model object into JSON.

ObjectMapper mapper = new ObjectMapper();
mapper.writeValue(new File("c:\\modelObj.json"), modelObj);

or

String s = mapper.writeValueAsString(modelObj);

answered Jul 20, 2012 at 22:17

Thimmayya

2,0642 gold badges18 silver badges20 bronze badges

Comments

plasma147 · Accepted Answer · 2012-07-20 22:19:27Z

1

A json file is text - so retrieve just as you would any string. If you were using a result set you could use ResultSet.getString(). Then you probably will want to deserialize it into either a domain object or some form of json object using a json parsing library.

There are lots of different libraries out there for doing this, for instance Jackson or Gson. I personally prefer gson - probably just because I'm more familiar with it and I find the API quite straight forward.

answered Jul 20, 2012 at 22:19

plasma147

2,21122 silver badges35 bronze badges

Collectives™ on Stack Overflow

How to create a JSON file getting out data with Java from database?

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related