diff options
Diffstat (limited to 'src/org/traccar/database/ResultSetConverter.java')
-rw-r--r-- | src/org/traccar/database/ResultSetConverter.java | 80 |
1 files changed, 0 insertions, 80 deletions
diff --git a/src/org/traccar/database/ResultSetConverter.java b/src/org/traccar/database/ResultSetConverter.java deleted file mode 100644 index 2bac01393..000000000 --- a/src/org/traccar/database/ResultSetConverter.java +++ /dev/null @@ -1,80 +0,0 @@ -/* - * 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(); - } -} |