001/* 
002 * JKNIV, SQLegance keeping queries maintainable.
003 * 
004 * Copyright (C) 2017, the original author or authors.
005 *
006 * This library is free software; you can redistribute it and/or
007 * modify it under the terms of the GNU Lesser General Public
008 * License as published by the Free Software Foundation; either
009 * version 2.1 of the License.
010 * 
011 * This library is distributed in the hope that it will be useful,
012 * but WITHOUT ANY WARRANTY; without even the implied warranty of
013 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
014 * Lesser General Public License for more details.
015 * 
016 * You should have received a copy of the GNU Lesser General Public
017 * License along with this library; if not, write to the Free Software Foundation, Inc., 
018 * 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301  USA
019 */
020package net.sf.jkniv.sqlegance.statement;
021
022import java.sql.ResultSet;
023
024/**
025 * Flags to indicate the type of <code>ResultSet</code> objects with the given holdability.
026 * 
027 * @author Alisson Gomes
028 * @see java.sql.ResultSet
029 * @since 0.6.0
030 *
031 */
032public enum ResultSetHoldability
033{
034    /** Open ResultSet objects with this holdability will be closed when the current transaction is commited. */
035    DEFAULT(ResultSet.CLOSE_CURSORS_AT_COMMIT),
036    /** Open ResultSet objects with this holdability will be closed when the current transaction is commited. */
037    HOLD_CURSORS_OVER_COMMIT(ResultSet.CLOSE_CURSORS_AT_COMMIT), 
038    /**  open ResultSet objects with this holdability will remain open when the current transaction is commited. */
039    CLOSE_CURSORS_AT_COMMIT(ResultSet.HOLD_CURSORS_OVER_COMMIT);    
040    
041    private int value;
042
043    private ResultSetHoldability(int value)
044    {
045        this.value = value;
046    }
047    /**
048     * @param type String that represent enum ignoring case
049     * @return the value of <code>type</code>, type of not found return <code>DEFAULT</code> enum. 
050     */
051    public static ResultSetHoldability get(String type)
052    {
053        ResultSetHoldability rs = ResultSetHoldability.DEFAULT;
054        for (ResultSetHoldability r : ResultSetHoldability.values())
055        {
056            if (String.valueOf(type).equalsIgnoreCase(r.name()))
057            {
058                rs = r;
059                break;
060            }
061        }
062        return rs;
063    }
064
065    public int getHoldability()
066    {
067        return this.value;
068    }
069}