aboutsummaryrefslogtreecommitdiff
path: root/src/org/traccar/database/ResultSetConverter.java
blob: 2bac013932520322221b0be4f49e9b4e551424da (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
/*
 * Copyright 2015 Anton Tananaev (anton.tananaev@gmail.com)
 *
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 *     http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */
package org.traccar.database;

import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import javax.json.Json;
import javax.json.JsonArray;
import javax.json.JsonArrayBuilder;
import javax.json.JsonObjectBuilder;

public class ResultSetConverter {

    public static JsonArray convert(ResultSet rs) throws SQLException {

        JsonArrayBuilder json = Json.createArrayBuilder();
        ResultSetMetaData rsmd = rs.getMetaData();

        while (rs.next()) {

            int numColumns = rsmd.getColumnCount();
            JsonObjectBuilder obj = Json.createObjectBuilder();

            for (int i = 1; i <= numColumns; i++) {

                String columnName = rsmd.getColumnName(i).toLowerCase();

                switch (rsmd.getColumnType(i)) {
                    case java.sql.Types.BIGINT:
                        obj.add(columnName, rs.getInt(columnName));
                        break;
                    case java.sql.Types.BOOLEAN:
                        obj.add(columnName, rs.getBoolean(columnName));
                        break;
                    case java.sql.Types.DOUBLE:
                        obj.add(columnName, rs.getDouble(columnName));
                        break;
                    case java.sql.Types.FLOAT:
                        obj.add(columnName, rs.getFloat(columnName));
                        break;
                    case java.sql.Types.INTEGER:
                        obj.add(columnName, rs.getInt(columnName));
                        break;
                    case java.sql.Types.NVARCHAR:
                        obj.add(columnName, rs.getNString(columnName));
                        break;
                    case java.sql.Types.VARCHAR:
                        obj.add(columnName, rs.getString(columnName));
                        break;
                    case java.sql.Types.DATE:
                        obj.add(columnName, ObjectConverter.dateFormat.format(rs.getDate(columnName)));
                        break;
                    case java.sql.Types.TIMESTAMP:
                        obj.add(columnName, ObjectConverter.dateFormat.format(rs.getTimestamp(columnName)));
                        break;
                    default:
                        break;
                }
            }

            json.add(obj.build());
        }

        return json.build();
    }
}