de.mhus.lib.sql.MutableResult Maven / Gradle / Ivy

Go to download
/**
 * Copyright 2018 Mike Hummel
 *
 * 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 de.mhus.lib.sql;

import java.io.InputStream;
import java.math.BigDecimal;
import java.sql.Date;
import java.sql.Time;
import java.sql.Timestamp;
import java.util.Collections;
import java.util.Iterator;
import java.util.LinkedList;
import java.util.List;
import java.util.Map;

import de.mhus.lib.core.MCast;
import de.mhus.lib.core.MDate;

public class MutableResult extends DbResult {

    private LinkedList> list = new LinkedList>();
    private Map current = null;
    private LinkedList columnList = new LinkedList();
    private List roColumnNames = Collections.unmodifiableList(columnList);
    private Iterator> iterator;

    public void add(Map row) {
        list.add(row);
    }

    public void reset() {
        iterator = list.iterator();
    }

    public void addColumnName(String name) {
        columnList.add(name);
    }

    @Override
    public void close() {
        list = null;
    }

    @Override
    public String getString(String columnLabel) throws Exception {
        return String.valueOf(current.get(columnLabel));
    }

    @Override
    public boolean next() throws Exception {
        boolean has = iterator.hasNext();
        if (!has) return false;
        current = iterator.next();
        return true;
    }

    @Override
    public InputStream getBinaryStream(String columnLabel) throws Exception {
        return (InputStream) current.get(columnLabel);
    }

    @Override
    public boolean getBoolean(String columnLabel) throws Exception {
        return MCast.toboolean(getString(columnLabel), false);
    }

    @Override
    public int getInt(String columnLabel) throws Exception {
        return MCast.toint(getString(columnLabel), 0);
    }

    @Override
    public long getLong(String columnLabel) throws Exception {
        return MCast.tolong(getString(columnLabel), 0);
    }

    @Override
    public float getFloat(String columnLabel) throws Exception {
        return MCast.tofloat(getString(columnLabel), 0);
    }

    @Override
    public double getDouble(String columnLabel) throws Exception {
        return MCast.todouble(getString(columnLabel), 0);
    }

    @Override
    public Date getDate(String columnLabel) throws Exception {
        return getMDate(columnLabel).toSqlDate();
    }

    @Override
    public MDate getMDate(String columnLabel) throws Exception {
        return new MDate(getString(columnLabel));
    }

    @Override
    public List getColumnNames() throws Exception {
        return roColumnNames;
    }

    @Override
    public Time getTime(String columnLabel) throws Exception {
        return getMDate(columnLabel).toSqlTime();
    }

    @Override
    public Timestamp getTimestamp(String columnLabel) throws Exception {
        return getMDate(columnLabel).toSqlTimestamp();
    }

    @Override
    public Object getObject(String columnLabel) throws Exception {
        return current.get(columnLabel);
    }

    @Override
    public BigDecimal getBigDecimal(String columnLabel) throws Exception {
        return MCast.toBigDecimal(current.get(columnLabel), BigDecimal.ZERO);
    }
}