package com.nsi.persistence;

import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.List;
import java.util.Map;

import com.nsi.control.exceptions.NsiEventException;

public interface IsqlDataSource
{
	List<Map<String,String>> executeSQLstmt(Statement stmt, String sSql) throws Exception, SQLException;
	List<Map<String,String>> executeStoredProc(CallableStatement cstmt) throws Exception, SQLException;
	List<Map<String,String>> executeRetrieve(Connection conn, String sSql) throws Exception, SQLException;
	Map<String,String> retrieveSingleRow(Connection conn, String sSql) throws Exception, SQLException;
	int executeUpdate(Statement stmt, String sSql) throws Exception, SQLException;
	Connection getConnection() throws Exception, SQLException;
	Connection getConnection(String type) throws Exception, SQLException;
	void closeConn(Connection conn) throws NsiEventException;
}