All Downloads are FREE. Search and download functionalities are using the official Maven repository.
  • Log In
  • Register

    • org.devocative.adroit.sql.result.ResultSetProcessor Maven / Gradle / Ivy

    package org.devocative.adroit.sql.result;

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

public class ResultSetProcessor {

	public static void processRowAsList(ResultSet rs, IRowAsList asList) throws SQLException {
		processRowAsList(rs, rs.getMetaData(), asList);
	}

	public static void processRowAsList(ResultSet rs, ResultSetMetaData metaData, IRowAsList asList) throws SQLException {
		int size = metaData.getColumnCount();

		while (rs.next()) {
			List row = new ArrayList<>();
			for (int i = 1; i <= size; i++) {
				row.add(getValue(rs, i, metaData.getColumnType(i)));
			}
			asList.onRowResult(row);
		}
	}

	public static void processRowAsMap(ResultSet rs, IRowAsMap asMap, EColumnNameCase nameCase) throws SQLException {
		processRowAsMap(rs, rs.getMetaData(), asMap, nameCase);
	}

	public static void processRowAsMap(ResultSet rs, ResultSetMetaData metaData, IRowAsMap asMap, EColumnNameCase nameCase) throws SQLException {
		int size = metaData.getColumnCount();

		while (rs.next()) {
			Map row = new LinkedHashMap<>();
			for (int i = 1; i <= size; i++) {
				String colName = getColumnName(metaData, i, nameCase);
				row.put(colName, getValue(rs, i, metaData.getColumnType(i)));
			}
			asMap.onRowResult(row);
		}
	}

	public static QueryVO process(ResultSet rs, EColumnNameCase nameCase) throws SQLException {
		ResultSetMetaData metaData = rs.getMetaData();
		QueryVO result = new QueryVO();

		for (int i = 1; i <= metaData.getColumnCount(); i++) {
			String colName = getColumnName(metaData, i, nameCase);
			result.addHeader(colName);
		}

		processRowAsList(rs, metaData, result::addRow);

		return result;
	}

	public static Object getValue(ResultSet rs, int colIndex, int colType) throws SQLException {
		Object value;
		switch (colType) {
			case Types.DATE:
				value = rs.getDate(colIndex);
				break;
			case Types.TIME:
				value = rs.getTime(colIndex);
				break;
			case Types.TIMESTAMP:
				value = rs.getTimestamp(colIndex);
				break;
			case Types.CLOB:
				value = rs.getString(colIndex);
				break;
			default:
				value = rs.getObject(colIndex);
		}
		return value;
	}

	// ------------------------------

	private static String getColumnName(ResultSetMetaData metaData, int idx, EColumnNameCase nameCase) throws SQLException {
		String colName = metaData.getColumnName(idx);
		switch (nameCase) {
			case LOWER:
				colName = colName.toLowerCase();
				break;
			case UPPER:
				colName = colName.toUpperCase();
				break;
		}

		return colName;
	}
}
    
    
    
    

    




    
    
    © 2015 - 2025 Weber Informatics LLC | Privacy Policy