Java database resultset to JSON implementation

There are now a lot of JSON-related Java tools, such as Json-lib, Gson, and so on, which can convert javabean directly into JSON format.

In development, it is possible to get data from the database and want to go directly to the JSON array, not through the bean.

For example, perform the following conversions:

Data sheet:

Id

Name

Age

1

Xxg

23

2

Xiaoming

20

Convert to JSON array:

[
            {
                "id": "1",
                 "name": "Xxg",
                 "Age": "All"
            },
            {
                "id": "2",
                 "name": "Xiaoming",
                 "Age": "
"             }
]

The implementation is simple, that is, the query results resultset every piece of data into a JSON object, the column name and value of each column in the data form a key-value pair, placed in the object, and finally organized into a JSON array.

[Java] view Plaincopyprint?

2. Public String Resultsettojson (ResultSet rs) throws Sqlexception,jsonexception
4. {
6. JSON array
8. Jsonarray array = new Jsonarray ();
12. Get Number of columns
14. ResultSetMetaData metaData = Rs.getmetadata ();
16. int columnCount = Metadata.getcolumncount ();
20. Traverse each piece of data in the ResultSet
22. while (Rs.next ()) {
24. Jsonobject jsonobj = new Jsonobject ();
28. Iterate through each column
30. for (int i = 1; I <= columnCount; i++) {
32. String columnName =metadata.getcolumnlabel (i);
34. String value = rs.getstring (ColumnName);
36. Jsonobj.put (columnName, value);
38. }
40. Array.put (Jsonobj);
42. }
46. return array.tostring ();
48. }

    Public String Resultsettojson (ResultSet rs) throws Sqlexception,jsonexception    {       //JSON array       jsonarray array = new Jsonarray ();             Gets the number of columns       resultsetmetadata metaData = Rs.getmetadata ();       int columnCount = Metadata.getcolumncount ();             Traverse each data in the ResultSet        while (Rs.next ()) {            Jsonobject jsonobj = new Jsonobject ();                       Traverse each column for            (int i = 1; I <= columnCount; i++) {                String columnName =metadata.getcolumnlabel (i);                String value = rs.getstring (columnName);                Jsonobj.put (columnName, value);            }             Array.put (jsonobj);         }             return array.tostring ();    }

The above code only needs to use the Org.json jar package, which can be downloaded anywhere on the web.

Fork Brother reproduced please indicate the source: http://blog.csdn.net/xiao__gui/article/details/8612503

Java database resultset to JSON implementation