how to convert data from the database in json?

Question

i am using eclipse with tomcat v7. I need to display a datatable. The data are taken from mysql database. I am using java to retrive data from database. but i need to convert this data into json format. Datatable use only json data. so please help me to convert data into json format.

i need data in this format

String json = "{ \"aaData\":[[\"First Name1\",\"Last Name1\",\"Address1\",\"Address2\"],[\"First Name\",\"Last Name\",\"Address\",\"sdfsdf\"]]}";

Create a class with the structure you mentioned, populate the values and use [Gson](http://code.google.com/p/google-gson/) to convert that object to a json. — Rahul, Nov 22 '13 at 10:31

score 0 · Answer 1 · answered Nov 22 '13 at 10:32

0

Try with Json with Jakson library

Check this

ObjectWriter ow = new ObjectMapper().writer().withDefaultPrettyPrinter();

String json = ow.writeValueAsString(object);

answered Nov 22 '13 at 10:32

Murali Murugesan

22,423
17
73
120

score 0 · Answer 2 · edited May 23 '17 at 10:25

0

you can use JPA annotations to directly fetch data into a POJO you can refer this for the same

after fetching the same you can use JAXB or any other API to convert that into JSON directly for JAXB you can refer this for json conversion

edited May 23 '17 at 10:25

Community

1
1

answered Nov 22 '13 at 10:36

dev2d

4,245
3
31
54

score 0 · Answer 3 · answered Nov 22 '13 at 10:49

0

Try below code.

String json = "{ \"aaData\":[[\"First Name1\",\"Last Name1\",\"Address1\",\"Address2\"],[\"First Name\",\"Last Name\",\"Address\",\"sdfsdf\"]]}";

JSONParser parser=new JSONParser();

Object myJson = parser.parse(json);

answered Nov 22 '13 at 10:49

Bhavesh Parekh

212
2
11

how to convert data from the database in json?

3 Answers3