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;
023
024import net.sf.jkniv.whinstone.Queryable;
025
026/**
027 * Default Command execute simple {@code INSERT}, {@code UPDATE} and {@code DELETE} SQL instructions.
028 * <p><b>Note: </b>
029 *  <ul>
030 *   <li> {@code SELECT} are handle by {@link DefaultJdbcQuery}</li>
031 *   <li> Bulk operations are handle by {@link BulkJdbcCommand}</li>
032 *  </ul>
033 *  
034 * @author Alisson Gomes
035 * @since 0.6.0
036 *
037 */
038@SuppressWarnings({"unchecked"})
039public class DefaultJdbcCommand extends AbstractJdbcCommand
040{
041    public DefaultJdbcCommand(Queryable queryable, Connection conn)
042    {
043        super(queryable, conn);
044    }
045    
046    public <T> T execute()
047    {
048        Integer rowsAffected = 0;
049        try
050        {
051            rowsAffected = simpleExecute();
052        }
053        finally
054        {
055            stmt.close();
056        }
057        return (T) rowsAffected;
058    }
059}