package cn.edu.buaa.ieguam.logmanage;

import java.sql.ResultSet;


/**
 * 完成各種數據庫連接的接口
 * @author tongxiaodong
 * Creation time:Apr 23, 2007 10:37:30 PM
 */

public interface DBConnection  
{
	 
	
	/**
	 * Getting and setting methods
	 * @return
	 */
	
	public ResultSet getResultSet();
	
	public void setResultSet(ResultSet resultSet);
	
	/**
	 * 構建數據庫連接
	 *
	 */
	public void connect() throws Exception;
	
	
    /**
     * 關閉數據庫連接
     * @throws Exception
     */	
	public void closeConnec() throws Exception;
	
	/**
	 * 執行查詢操作
	 * @param querySql
	 */
	public void executeQuery(String querySql) throws Exception;
	
	/**
	 * 執行插入操作
	 * @param queryInsert
	 */
	public int executeInsert(String insertSql) throws Exception;
	
	/**
	 * 執行刪除操作
	 * @param deleteSql
	 */
	public int executeDelete(String deleteSql) throws Exception;
	
	/**
	 * 執行更新操作
	 * @param updateSql
	 */
	public int executeUpdate(String updateSql) throws Exception;

}