001/* 
002 * JKNIV, whinstone one contract to access your database.
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.whinstone.jdbc.commands;
021
022import java.sql.Connection;
023import java.sql.PreparedStatement;
024
025import net.sf.jkniv.whinstone.Queryable;
026
027/**
028 * 
029 * @author Alisson Gomes
030 * @since 0.6.0
031 */
032public class AddSequenceKeyJdbcCommand extends AbstractJdbcCommand
033{
034    @SuppressWarnings("rawtypes")
035    public AddSequenceKeyJdbcCommand(Queryable queryable, Connection conn)
036    {
037        super(queryable, conn);
038    }
039
040    @Override
041    public <T> T execute()
042    {
043        Integer affected = 0;
044        PreparedStatement stmt_off = null;
045        try
046        {
047            // first get sequence after execute insert
048            stmt.bindKey();
049            queryable.bind(stmt).on();
050            affected = stmt.execute();
051        }
052        catch (Exception e)
053        {
054            handlerException.handle(e);
055        }
056        finally
057        {
058            stmt.close();
059            close(stmt_off);
060        }
061        return (T) affected;
062    }
063    
064}