net.sf.aguacate.context.spi.sql.impl.SentenceSqlSelectSingleRow Maven / Gradle / Ivy

Go to download
package net.sf.aguacate.context.spi.sql.impl;

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

import org.apache.logging.log4j.LogManager;
import org.apache.logging.log4j.Logger;

public class SentenceSqlSelectSingleRow extends AbstractSentenceSqlSelect {

	private static final Logger LOGGER = LogManager.getLogger(SentenceSqlSelectSingleRow.class);

	public SentenceSqlSelectSingleRow(String name, String table, List methods, List required,
			List optional, String outputName) {
		super(name, table, methods, required, optional, outputName);
	}

	@Override
	Object extract(String[] optional, ResultSet resultSet) throws SQLException {
		if (resultSet.next()) {
			Map data = new HashMap<>();
			for (String parameter : optional) {
				data.put(parameter, resultSet.getObject(parameter));
			}
			if (resultSet.next()) {
				LOGGER.warn("multiple results");
			}
			return data;
		} else {
			return null;
		}
	}

}