executehelper.java

Speedframework--基于类型元数据的羽量级ORM.完全基于Java类型元数据和反射机制同时不需要任何对象关系映射配置文件的轻量级ORM框架,它充分利用了类型本身的信息,使用Metadata

package org.speedframework.execute;

import java.sql.CallableStatement;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.List;

import org.speedframework.exception.ConnectionException;
import org.speedframework.exception.ParamException;

public interface ExecuteHelper {

	/**
	 * ���PreparedStatement����
	 * 
	 * @param ps
	 *            PreparedStatement
	 * @param SQL
	 *            String
	 * @param parm
	 *            String[]
	 * @throws SQLException
	 * @return int
	 */
	public abstract int setExecuteUpdate(PreparedStatement ps,
			String SQL, Object[] parmvalue) throws SQLException,
			ConnectionException, ParamException;

	/**
	 * ���PreparedStatement����
	 * 
	 * @param ps
	 *            PreparedStatement
	 * @param parm
	 *            String[]
	 * @throws SQLException
	 * @return ResultSet
	 */
	public abstract ResultSet setExecuteQuery(PreparedStatement ps,
			Object[] parmvalue) throws SQLException;

	/**
	 * executeInsert
	 * 
	 * @param con
	 *            Connection
	 * @param ps
	 *            PreparedStatement
	 * @param SQL
	 *            String
	 * @param parmvalue
	 *            Object[]
	 * @throws ParamException
	 * @throws ConnectionException
	 * @throws SQLException
	 * @return List
	 */
	public abstract List executeInsert(PreparedStatement ps,
			String SQL, Object[] parmvalue) throws ParamException,
			ConnectionException, SQLException;

	/**
	 * ����ִ��
	 * 
	 * @param con
	 *            Connection
	 * @param SQL
	 *            String
	 * @param params
	 *            Object[][]
	 * @throws ParamException
	 * @throws ConnectionException
	 * @throws SQLException
	 * @return int[]
	 */
	public abstract int[] executeBatch(String SQL,
			Object[][] params) throws ParamException, ConnectionException,
			SQLException;

	/**
	 * setExecuteCall
	 * 
	 * @param con
	 *            Connection
	 * @param ps
	 *            PreparedStatement
	 * @param SQL
	 *            String
	 * @param parmvalue
	 *            Object[]
	 * @throws SQLException
	 * @throws ConnectionException
	 * @throws ParamException
	 * @return int
	 */
	public abstract boolean setExecuteCall(
			CallableStatement proc, String SQL, Object[] parmvalue)
			throws SQLException, ConnectionException, ParamException;

	/**
	 * setFunctionCall
	 * @param con
	 * @param proc
	 * @param SQL
	 * @param parmvalue
	 * @param returnType
	 * @return
	 * @throws SQLException
	 * @throws ConnectionException
	 * @throws ParamException
	 */
	public Object setFunctionCall(CallableStatement proc,
			String SQL, Object[] parmvalue, int returnType)
			throws SQLException, ConnectionException, ParamException;

}