Implementation of converting Java Database resultset to JSON

Http://blog.csdn.net/xiao__gui/article/details/8612503

 

There are many JSON-related Java tools, such as JSON-lib and gson. They can directly convert Javabean to JSON format.

During development, data may be retrieved from the database and directly converted into a JSON array without passing beans.

 

For example, perform the following conversion:

 

Data Table:

ID	Name	Age
1	XxG	23
2	Xiaoming	20

 

Convert to a JSON array:

[

{

"ID": "1 ",

"Name": "xxG ",

"Age": "23"

},

{

"ID": "2 ",

"Name": "Xiaoming ",

"Age": "20"

}

]

 

The implementation is very simple, that is, converting each piece of data in the resultset of the query result into a JSON object. The column names and values of each column in the data form a key-Value Pair and place it in the object, finally, the object is organized into a JSON array.

 

 

[Java]View plaincopy

 

1. Public String resultsettojson (resultset RS) throws sqlexception, jsonexception
2. {
3. // JSON Array
4. Jsonarray array = new jsonarray ();
6. // Obtain the number of Columns
7. Resultsetmetadata metadata = Rs. getmetadata ();
8. Int columncount = metadata. getcolumncount ();
10. // Traverse each data entry in the resultset
11. While (Rs. Next ()){
12. Jsonobject jsonobj = new jsonobject ();
14. // Traverse each column
15. For (INT I = 1; I <= columncount; I ++ ){
16. String columnname = metadata. getcolumnlabel (I );
17. String value = Rs. getstring (columnname );
18. Jsonobj. Put (columnname, value );
19. }
20. Array. Put (jsonobj );
21. }
23. Return array. tostring ();
24. }

 

 

The above Code only needs to use the jar package of org. JSON, which can be downloaded anywhere on the Internet.