org.ibatis.client.SqlMapExecutor2 Maven / Gradle / Ivy

Go to download
Show more of this group Show more artifacts with this name
Show all versions of jbatis Show documentation
The jBATIS persistence framework will help you to significantly reduce the amount of Java code that you normally need to access a relational database. iBATIS simply maps JavaBeans to SQL statements using a very simple XML descriptor.
The newest version!
/*-
 * Copyright (c) 2007-2008 Owlgroup.
 * All rights reserved. 
 * SqlMapExecutor.java
 * Date: 2008-10-7
 * Author: Song Sun
 */
package org.ibatis.client;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.List;
import java.util.Map;

import com.ibatis.sqlmap.client.event.RowHandler;

/**
 * SqlMapExecutor2 supply var-args api for users.
 * 
 * Date: 2008-10-7
 * 
 * @author Song Sun
 * @version 1.0
 */
public interface SqlMapExecutor2 {

    /**
     * Do insert operation by var-args paramenters as #1# to #n#
     * 
     * @see com.ibatis.sqlmap.client.SqlMapExecutor#insert(String, Object)
     */
     T insertArgs(String id, Object... args) throws SQLException;

    /**
     * Do update operation by var-args paramenters as #1# to #n#
     * 
     * @see com.ibatis.sqlmap.client.SqlMapExecutor#update(String, Object)
     */
    int updateArgs(String id, Object... args) throws SQLException;

    /**
     * Do delete operation by var-args paramenters as #1# to #n#
     * 
     * @see com.ibatis.sqlmap.client.SqlMapExecutor#delete(String, Object)
     */
    int deleteArgs(String id, Object... args) throws SQLException;

    /**
     * Do queryForList operation by var-args paramenters as #1# to #n#
     * 
     * @see com.ibatis.sqlmap.client.SqlMapExecutor#queryForList(String, Object)
     */
     List queryForListArgs(String id, Object... args) throws SQLException;

    /**
     * Do queryForList operation by var-args paramenters as #1# to #n#
     * 
     * @see com.ibatis.sqlmap.client.SqlMapExecutor#queryForList(String, Object, int, int)
     */
     List queryForListArgs(int skip, int max, String id, Object... args) throws SQLException;

    /**
     * Do queryForMap operation by var-args paramenters as #1# to #n#
     * 
     * @see com.ibatis.sqlmap.client.SqlMapExecutor#queryForMap(String, Object, String)
     */
     Map queryForMapArgs(String id, String keyProp, Object... args) throws SQLException;

    /**
     * Do queryForMap operation by var-args paramenters as #1# to #n#
     * 
     * @see com.ibatis.sqlmap.client.SqlMapExecutor#queryForMap(String, Object, String, String)
     */
     Map queryForMapArgs(String id, String keyProp, String valueProp, Object... args) throws SQLException;

    /**
     * Do queryForMap operation by var-args paramenters as #1# to #n#
     * 
     * @see com.ibatis.sqlmap.client.SqlMapExecutor#queryForMap(String, Object, String, Class, String, Class)
     */
     Map queryForMapArgs(String id, String keyProp, Class keyType, String valueProp, Class valueType,
        Object... args) throws SQLException;

    /**
     * Do queryForObject operation by var-args paramenters as #1# to #n#
     * 
     * @see com.ibatis.sqlmap.client.SqlMapExecutor#queryForObject(String, Object)
     */
     T queryForObjectArgs(String id, Object... args) throws SQLException;

    /**
     * Do queryForPage operation by var-args paramenters as #1# to #n#
     * 
     * @see com.ibatis.sqlmap.client.SqlMapExecutor#queryForPage(List, String, Object, int, int)
     */
     int queryForPageArgs(List page, String id, int skip, int max, Object... args) throws SQLException;

    /**
     * Do queryForFirst operation by var-args paramenters as #1# to #n#
     * 
     * @see com.ibatis.sqlmap.client.SqlMapExecutor#queryForList(String, Object)
     */
     T queryForFirstArgs(String id, Object... args) throws SQLException;

    /**
     * Do queryForFirst operation by var-args paramenters as #1# to #n#
     * 
     * @see com.ibatis.sqlmap.client.SqlMapExecutor#queryForList(String)
     */
     T queryForFirst(String id) throws SQLException;

    /**
     * Do queryForFirst operation by var-args paramenters as #1# to #n#
     * 
     * @see com.ibatis.sqlmap.client.SqlMapExecutor#queryForList(String, Object)
     */
     T queryForFirst(String id, Object parameterObject) throws SQLException;

    /**
     * Do queryWithRowHandler operation by var-args paramenters as #1# to #n#
     * 
     * @see com.ibatis.sqlmap.client.SqlMapExecutor#queryWithRowHandler(String, Object, RowHandler)
     */
    void queryWithRowHandlerArgs(String id, RowHandler rowHandler, Object... args) throws SQLException;

    /**
     * Do queryForResultSet operation by var-args paramenters as #1# to #n#
     * 
     * @see #queryForResultSet(String, Object)
     */
    ResultSet queryForResultSetArgs(String id, Object... args) throws SQLException;

    /**
     * Execute the query and return a cached result set.
     * 
     * @param id
     *            the statement id.
     * @return the cached result set
     * @see javax.sql.CachedRowSet
     */
    ResultSet queryForResultSet(String id) throws SQLException;

    /**
     * Execute the query and return a cached result set.
     * 
     * @param id
     *            the statement id.
     * @param parameterObject
     *            the parameter object.
     * @return the cached result set
     * @see javax.sql.CachedRowSet
     */
    ResultSet queryForResultSet(String id, Object parameterObject) throws SQLException;

}