JDBCDebug.java

package common;

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

public class JDBCDebug {
	
	public static Map<String, Object> getEmptyRow(ResultSet rs) throws SQLException {
		ResultSetMetaData metaData = rs.getMetaData();
		int colCount = metaData.getColumnCount();

		Map<String, Object> columns = new HashMap<String, Object>();
		for (int i = 1; i <= colCount; i++) {
			columns.put(metaData.getColumnLabel(i), "");
		}
		return columns;
	}
	
	public static Map<String, Object> getRow(ResultSet rs, Map<String, Object> row) throws SQLException {
		for (String key : row.keySet()) {
			row.put(key, rs.getObject(key));
		}
		return row;
	}
	
	public static Map<String, Object> getRow(ResultSet rs) throws SQLException {
		return getRow(rs, getEmptyRow(rs));
	}
	
}