isqlexecutor.java

《j2ee开发全程实录》随书源码

package com.cownew.PIS.framework.common.services;

import java.sql.ResultSet;
import java.sql.SQLException;

import com.cownew.PIS.framework.common.ITxService;

import com.cownew.PIS.framework.common.multisql.TargetDBEnum;

public interface ISQLExecutor extends ITxService
{
	public ResultSet execute(String sql,Object[] params) throws SQLException;
	public ResultSet execute(String sql) throws SQLException;
	
	/**
	 * 执行方言SQL
	 * @param sql
	 * @
	 * @throws SQLException
	 */
	public ResultSet executeDialect(String sql) throws SQLException;
	
	/**
	 * 执行方言SQL
	 * @throws SQLException
	 */
	public ResultSet executeDialect(String sql,Object[] params) throws SQLException;
	
	
	public void batchExecute(String[] sqlArray) throws SQLException;
	
	/**
	 * 批量执行sql
	 * @param sqlArray 批量sql
	 * @param paramsArray 二维参数列表
	 * @
	 * @throws SQLException
	 */
	public void batchExecute(String[] sqlArray, Object[][] paramsArray) throws SQLException;
	
	/**
	 * 翻译SQL语句,用当前帐套的数据库作为目标库
	 * 
	 * @param sql
	 * @return
	 * @
	 */
	public String translateSQL(String sql) ;
	/**
	 * 翻译SQL语句
	 * 
	 * @param sql
	 * @param targetDB
	 *            目标数据库
	 * @return
	 * @
	 */
	public String translateSQL(String sql, TargetDBEnum targetDB) ;
}