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