jongo.handler.ResultSetMetaDataHandler.java Source code

Introduction

Here is the source code for jongo.handler.ResultSetMetaDataHandler.java

Source

/**
 * Copyright (C) 2011, 2012 Alejandro Ayuso
 *
 * This file is part of Jongo.
 * Jongo is free software: you can redistribute it and/or modify
 * it under the terms of the GNU General Public License as published by
 * the Free Software Foundation, either version 3 of the License, or
 * any later version.
 * 
 * Jongo is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU General Public License for more details.
 * 
 * You should have received a copy of the GNU General Public License
 * along with Jongo.  If not, see <http://www.gnu.org/licenses/>.
 */

package jongo.handler;

import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

import jongo.rest.xstream.Row;

import org.apache.commons.dbutils.ResultSetHandler;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;

/**
 *
 * @author Alejandro Ayuso 
 */
public class ResultSetMetaDataHandler implements ResultSetHandler<List<Row>> {

    private static final Logger l = LoggerFactory.getLogger(ResultSetMetaDataHandler.class);

    @Override
    public List<Row> handle(ResultSet rs) throws SQLException {
        List<Row> results = new ArrayList<Row>();
        int rowId = 0;
        ResultSetMetaData metaData = rs.getMetaData();
        Map<String, String> map = null;
        for (int i = 1; i <= metaData.getColumnCount(); i++) {
            map = new HashMap<String, String>(2);
            map.put("tableName", metaData.getTableName(i));
            map.put("columnName", metaData.getColumnName(i));
            map.put("columnLabel", metaData.getColumnLabel(i));
            map.put("columnType", metaData.getColumnTypeName(i));
            map.put("columnSize", String.valueOf(metaData.getColumnDisplaySize(i)));
            map.put("precision", String.valueOf(metaData.getPrecision(i)));
            map.put("scale", String.valueOf(metaData.getScale(i)));

            //            map.put("catalog_name", metaData.getCatalogName(i));
            //            map.put("column_class_name", metaData.getColumnClassName(i));
            //            map.put("schema_name", metaData.getSchemaName(i));
            //            map.put("column_type", String.valueOf(metaData.getColumnType(i)));

            if (map != null)
                results.add(new Row(rowId++, map));
        }
        return results;
    }
}