Java tutorial
/** * Copyright 2008-2015 Qualogy Solutions B.V. * * 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 com.qualogy.qafe.business.integration.rdb; import java.sql.ResultSet; import java.sql.ResultSetMetaData; import java.sql.SQLException; import java.util.Map; import org.apache.commons.collections.map.CaseInsensitiveMap; import org.springframework.jdbc.core.RowMapper; import com.qualogy.qafe.core.datastore.DataMap; /** * generic implementation for mapping rows * @author mvanderwurff * */ public class MetaDataRowMapper implements RowMapper { /** * Method for mapping rows inherited from RowMapper. * Method maps rows to a Map using columnname. */ public Object mapRow(ResultSet rs, int rowNum) throws SQLException { // Map<String, Object> output = new CaseInsensitiveMap(); Map<String, Object> output = new DataMap(); ResultSetMetaData md = rs.getMetaData(); for (int i = 1; i <= md.getColumnCount(); i++) { output.put(md.getColumnName(i), rs.getObject(i)); } return output; } }