package org.speedframework.engine;

import java.sql.*;
import java.util.*;

import org.speedframework.exception.SpeedException;

/**
 * <p>
 * Title: SpeedFrameworkWork持久層框架
 * </p>
 * 
 * <p>
 * Description: 數據訪問持久層執行接口
 * </p>
 * 
 * <p>
 * Copyright: Copyright (c) 2006
 * </p>
 * 
 * <p>
 * Company: SpeedFrameworkWork team
 * </p>
 * 
 * @author 李志峰 電話：13824431576 程偉杰 電話：
 * @version 1.0
 */
public interface Execute {

	/**
	 * <B>持久層刪除方法</B>
	 * 
	 * @version 1.1Released
	 * @param con
	 *            Connection 連接，需要事務
	 * @param SQL
	 *            String sql語句
	 * @param param
	 *            String[] 參數，與sql語句'?'位置對應
	 * @param useCache
	 *            boolean
	 * @throws SpeedException
	 */
	public void delete( String SQL, Object[] param,
			boolean useCache) throws SpeedException;

	/**
	 * <B>持久層刪除方法</B>
	 * 
	 * @version 1.0beta
	 * @param con
	 *            Connection 連接，需要事務
	 * @param SQL
	 *            String sql語句
	 * @param entity
	 *            Object 參數，javabean
	 * @param useCache
	 *            boolean
	 * @throws SpeedException
	 */
	public void delete( String SQL, Object entity,
			boolean useCache) throws SpeedException;

	/**
	 * <B>持久層插入方法</B>
	 * 
	 * @version 1.1Released
	 * @param con
	 *            Connection 連接，需要事務
	 * @param SQL
	 *            String sql語句
	 * @param param
	 *            String[]參數，與sql語句'?'位置對應
	 * @param useCache
	 *            boolean
	 * @throws SpeedException
	 * @return List
	 */
	public List insert(String SQL, Object[] param,
			boolean useCache) throws SpeedException;

	/**
	 * <B>持久層插入方法</B>
	 * 
	 * @version 1.0beta
	 * @param con
	 *            Connection 連接
	 * @param SQL
	 *            String sql字符串
	 * @param entity
	 *            Object 插入對象,javabean
	 * @param useCache
	 *            boolean
	 * @throws SpeedException
	 * @return List
	 */
	public List insert( String SQL, Object entity,
			boolean useCache) throws SpeedException;

	/**
	 * <B>持久層列表方法</B>
	 * 
	 * @version 1.1Released
	 * @param con
	 *            Connection 連接
	 * @param SQL
	 *            String sql語句
	 * @param parmvalue
	 *            String[] 參數，與sql語句'?'位置對應
	 * @param voclass
	 *            Class 承載值對象，如為null直接返回HashMap承載
	 * @param useCache
	 *            boolean
	 * @throws SpeedException
	 * @return List
	 */
	public List select( String SQL, Object[] parmvalue,
			Class voclass, boolean useCache) throws SpeedException;

	/**
	 * <B>持久層列表方法</B>
	 * 
	 * @version 1.0beta
	 * @param con
	 *            Connection 連接
	 * @param SQL
	 *            String sql語句
	 * @param entity
	 *            Object 參數，javabean
	 * @param voclass
	 *            Class 承載值對象，如為null直接返回HashMap承載
	 * @param useCache
	 *            boolean
	 * @throws SpeedException
	 * @return List
	 */
	public List select( String SQL, Object entity,
			Class voclass, boolean useCache) throws SpeedException;

	/**
	 * <B>持久層更新方法</B>
	 * 
	 * @version 1.1Released
	 * @param con
	 *            Connection 連接，需要事務
	 * @param SQL
	 *            String sql語句
	 * @param param
	 *            String[]參數，與sql語句'?'位置對應
	 * @param useCache
	 *            boolean
	 * @throws SpeedException
	 */
	public void update( String SQL, Object[] param,
			boolean useCache) throws SpeedException;

	/**
	 * <B>持久層更新方法</B>
	 * 
	 * @version 1.0beta
	 * @param con
	 *            Connection 連接，需要事務
	 * @param SQL
	 *            String sql語句
	 * @param entity
	 *            Object 參數，javabean
	 * @param useCache
	 *            boolean
	 * @throws SpeedException
	 */
	public void update( String SQL, Object entity,
			boolean useCache) throws SpeedException;

	/**
	 * 批處理接口
	 * 
	 * @param con
	 *            Connection
	 * @param SQL
	 *            String
	 * @param params
	 *            List 承載javabean對象
	 * @param useCache
	 *            boolean
	 * @throws SpeedException
	 */
	public void executeBatch( String SQL, Object[][] params,
			boolean useCache) throws SpeedException;

	/**
	 * 批處理接口
	 * 
	 * @param con
	 *            Connection
	 * @param SQL
	 *            String
	 * @param list
	 *            String[][]
	 * @throws SpeedException
	 */
	public void executeBatch( String SQL, List list)
			throws SpeedException;

	/**
	 * 統計總記錄數
	 * 
	 * @param con
	 *            Connection
	 * @param SQL
	 *            String
	 * @param params
	 *            String[]
	 * @param useCache
	 *            boolean
	 * @throws SpeedException
	 * @return int
	 */
	public int getDataCount( String SQL, Object[] params,
			boolean useCache) throws SpeedException;

	/**
	 * 存儲過程
	 * 
	 * @param con
	 *            Connection
	 * @param SQL
	 *            String
	 * @param params
	 *            Object[]
	 * @param voclass
	 *            Class
	 * @param useCache
	 *            boolean
	 * @throws SpeedException
	 * @return List
	 */
	public List executeCall( String SQL, Object[] params,
			Class voclass, boolean useCache) throws SpeedException;
	
	
	
	/**
	 * 存儲函數
	 * @param con
	 * @param SQL
	 * @param params
	 * @param returnType
	 * @param voclass
	 * @param useCache
	 * @return
	 * @throws SpeedException
	 */
	public Object executeFunction( String SQL, Object[] params,int returnType,
			Class voclass, boolean useCache) throws SpeedException;
	
	/**
	 * @param con
	 * @param SQL
	 * @param voclass
	 * @param useCache
	 * @return
	 * @throws SpeedException
	 */
	public List select( String SQL, Class voclass,
			boolean useCache) throws SpeedException;

}