All Downloads are FREE. Search and download functionalities are using the official Maven repository.

org.efaps.db.query.CachedResult Maven / Gradle / Ivy

Go to download

eFaps is a framework used to map objects with or without attached files to a relational database and optional file systems (only for attaches files). Configurable access control can be provided down to object and attribute level depending on implementation and use case. Depending on requirements, events (like triggers) allow to implement business logic and to separate business logic from user interface. The framework includes integrations (e.g. webdav, full text search) and a web application as 'simple' configurable user interface. Some best practises, example web application modules (e.g. team work module) support administrators and implementers using this framework.

There is a newer version: 3.2.0
Show newest version
/*
 * Copyright 2003 - 2012 The eFaps Team
 *
 * 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.
 *
 * Revision:        $Rev: 7483 $
 * Last Changed:    $Date: 2012-05-11 11:57:38 -0500 (Fri, 11 May 2012) $
 * Last Changed By: $Author: [email protected] $
 */

package org.efaps.db.query;

import java.math.BigDecimal;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.sql.Timestamp;
import java.util.ArrayList;
import java.util.Date;
import java.util.HashMap;
import java.util.Iterator;
import java.util.List;
import java.util.Map;

import org.efaps.admin.EFapsSystemConfiguration;
import org.efaps.util.EFapsException;
import org.joda.time.DateTime;
import org.joda.time.DateTimeZone;
import org.joda.time.chrono.ISOChronology;

/**
 * The class is used to cache all results from a eFaps search query. Multiple
 * database selects could be added to one instance. The class simulates the
 * class {@link javax.sql.rowset.JoinRowSet}, because the original classes do
 * not work with Oracle JDBC drivers.
 *
 * @author The eFaps Team
 * @version $Id: CachedResult.java 7483 2012-05-11 16:57:38Z [email protected] $
 * TODO: description
 */
//CHECKSTYLE:OFF
@Deprecated
public class CachedResult
{
    /**
     * Used to cache for given key (Object) the list of values (List).
     */
    private final Map> cache = new HashMap>();

    /**
     * The variable stores the same values than in {@link #cache}, but without
     * key. The order is not changed, the order is the same than the result of
     * select statement.
     */
    private final List> rows = new ArrayList>();

    private Iterator> iter = null;

    /**
     * The instance variable is a pointer to the current row in the cached
     * result table list.
     *
     * @see #beforeFirst
     * @see #next
     * @see #gotoKey
     */
    private List currentRow = null;

    private boolean multiple = false;

    public CachedResult()
    {
    }

    /**
     * Moves the cursor to the front of this cached result object, just before
     * the first row. This method has no effect if the cached result contains no
     * rows. Attention! After that, method {@link #next} must be called to get
     * first row!
     *
     * @see #next
     */
    public void beforeFirst()
    {
        this.iter = this.rows.iterator();
    }

    /**
     * Moves the cursor down one row from its current position. A cached result
     * cursor is initially positioned before the first row; the first call to
     * the method next makes the first row the current row; the second call
     * makes the second row the current row, and so on.
     *
     * @return true if the new current row is valid; false if
     *         there are no more rows
     */
    public boolean next()
    {
        if (this.iter == null) {
            beforeFirst();
        }
        final boolean ret = this.iter.hasNext();
        if (ret) {
            this.currentRow = this.iter.next();
        }
        return ret;
    }

    /**
     * Moves the cursor to the row defined with given key.
     *
     * @param _key key defing next row
     * @return true if a row for the key exists, otherwise false>
     */
    public boolean gotoKey(final Object _key)
    {
        this.currentRow = this.cache.get(_key);
        return (this.currentRow != null);
    }

    /**
     * All values in the result set are added to the cached result. The column
     * in the result set specified with parameter _keyIndex is used
     * to identify the row in the cached result. This column is compared to the
     * key in the cached result. The column set specified with parameter
     * _subKeyIndex is used to identify a subrow in case of an
     * expand, where the result can be more than one row for one value.

     * The method does not set the cursor of the result set to the first row! In
     * other words, the method estimates that the result set is on the first
     * row!
     *
     * @param _rs result set with values to add to this cached result instance
     * @param _keyIndex index in the result set used as key to found the values
     *            in the cache
     */
    public void populate(final ResultSet _rs, final int _keyIndex, final int _subKeyIndex) throws SQLException
    {
        final ResultSetMetaData metaData = _rs.getMetaData();
        final int columnCount = metaData.getColumnCount();

        if (_subKeyIndex > 0) {
            this.multiple = true;
        }

        if (this.cache.size() == 0) {
            while (_rs.next()) {
                final List list = new ArrayList(columnCount);
                for (int i = 1; i <= columnCount; i++) {
                    switch (metaData.getColumnType(i)) {
                    case java.sql.Types.TIMESTAMP:
                        list.add(_rs.getTimestamp(i));
                        break;
                    default:
                        list.add(_rs.getObject(i));
                    }
                }
                if (this.multiple) {
                    List mulitple = this.cache.get(_rs.getObject(_keyIndex));
                    if (mulitple == null) {
                        mulitple = new ArrayList();
                        this.cache.put(_rs.getObject(_keyIndex), mulitple);
                        this.rows.add(mulitple);
                    }
                    mulitple.add(list);
                } else {
                    this.cache.put(_rs.getObject(_keyIndex), list);
                    this.rows.add(list);
                }
            }
        } else {
            // TODO multiple muss hier auch noch mit abgedeckt werden
            while (_rs.next()) {
                final List list = this.cache.get(_rs.getObject(_keyIndex));
                if (list != null) {
                    for (int i = 1; i <= columnCount; i++) {
                        if (i != _keyIndex) {
                            switch (metaData.getColumnType(i)) {
                            case java.sql.Types.TIMESTAMP:
                                list.add(_rs.getTimestamp(i));
                                break;
                            default:
                                list.add(_rs.getObject(i));
                            }
                        }
                    }
                }
            }
        }
    }

    /**
     * @param _index column index
     * @return object on given column index
     * @see #currentRow
     */
    public Object getObject(final int _index)
    {
        Object ret;
        if (this.multiple) {
            final List tmp = new ArrayList();
            for (final Object obj : this.currentRow) {
                tmp.add(((List) obj).get(_index - 1));
            }
            ret = tmp;
        } else {
            ret = this.currentRow.get(_index - 1);
        }
        return ret;
    }

    public List> getObjectList(final List _indexes)
    {
        final List> ret = new ArrayList>();
        if (this.multiple) {
            for (final Object obj : this.currentRow) {
                final List tmp = new ArrayList();
                for (final Integer idx : _indexes) {
                    tmp.add(((List) obj).get(idx - 1));
                }
                ret.add(tmp);
            }
        }
        return ret;
    }

    /**
     * @param _index column index
     * @return string representation for the object on given column index
     * @see #currentRow
     */
    public String getString(final int _index)
    {
        final Object obj = getObject(_index);

        return obj == null ? null : obj.toString();
    }

    /**
     * Returns the long representation for the object on given column index. If
     * the object on the given column index is not an instance of class
     * {@link java.lang.Number} (if it is a number, the long value is used), the
     * value is converted in a string and then parsed as long.

     * In the case that the result was a multiple result only the first value
     * will be returned!
     *
     * @param _index column index
     * @return long representation for the object on given column index;
     *         null if no value is defined
     * @see #currentRow
     */
    public Long getLong(final int _index)
    {
        Long ret = null;
        Object obj = getObject(_index);
        if (obj instanceof List) {
            obj = ((List) obj).get(0);
        }
        if (obj instanceof Number) {
            ret = ((Number) obj).longValue();
        } else if (obj != null) {
            ret = Long.parseLong(obj.toString());
        }
        return ret;
    }

    /**
     * Returns the double representation for the object on given column index.
     * If the object on the given column index is not an instance of class
     * {@link java.lang.Number} (if it is a number, the double value is used),
     * the value is converted in a string and then parsed as double.
     *
     * @param _index column index
     * @return double representation for the object on given column index;
     *         null if no value is defined
     * @see #currentRow
     */
    public Double getDouble(final int _index)
    {
        Double ret = null;
        final Object obj = getObject(_index);
        if (obj instanceof Number) {
            ret = ((Number) obj).doubleValue();
        } else if (obj != null) {
            ret = Double.parseDouble(obj.toString());
        }
        return ret;
    }

    /**
     * Returns the boolean representation for the object on given column index.
     * If the object on the given column index is not an instance of class
     * Boolean. The value is interpreteded as number and converted to an eequal
     * boolen.
     *
     * @param _index column index
     * @return boolean representation for the object on given column index;
     *         null if no value is defined
     * @see #currentRow
     */
    public Boolean getBoolean(final int _index)
    {
        Boolean ret = null;
        final Object obj = getObject(_index);
        if (obj instanceof Boolean) {
            ret = (Boolean) obj;
        } else if (obj instanceof Number) {
            final Integer intvalue = ((Number) obj).intValue();
            if ((intvalue != null) && (intvalue != 0)) {
                ret = true;
            } else {
                ret = false;
            }
        }
        return ret;
    }

    /**
     * Get an DateTime instance from an index position. The DateTime will be
     * always with the ISO8601 Calendar and the Timezone as defined ins system
     * attribute Admin_Common_DataBaseTimeZone.
     *
     * @param _index column index
     * @return time stamp representation for the object on given column index
     *         for time stamp and date instances, otherwise null
     * @see #currentRow
     */
    public DateTime getDateTime(final int _index)
    {
        DateTime ret = null;
        final Object obj = getObject(_index);
        if (obj instanceof Timestamp || obj instanceof Date) {
            // reads the Value from "Admin_Common_DataBaseTimeZone"
            String timezoneID;
            try {
                timezoneID = EFapsSystemConfiguration.KERNEL.get().getAttributeValue("DataBaseTimeZone");

                final ISOChronology chron;
                if (timezoneID != null) {
                    final DateTimeZone timezone = DateTimeZone.forID(timezoneID);
                    chron = ISOChronology.getInstance(timezone);
                } else {
                    chron = ISOChronology.getInstanceUTC();
                }
                ret = new DateTime(obj, chron);
            } catch (final EFapsException e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            }

        }
        return ret;
    }

    public boolean isMultiple()
    {
        return this.multiple;
    }

    /**
     * @param intValue
     * @return
     */
    public BigDecimal getDecimal(final int _index)
    {
        BigDecimal ret = null;
        final Object obj = getObject(_index);
        if (obj instanceof BigDecimal) {
            ret = (BigDecimal) obj;
        } else if (obj != null) {
            ret = new BigDecimal(obj.toString());
        }
        return ret;
    }
}
    

    

    

            

    

            



    
    






    
© 2015 - 2024 Weber Informatics LLC | Privacy Policy