isqldatasource.java

主要是航空预订系统

package com.air.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.air.exceptions.AirException;

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;
	void closeConn(Connection conn) throws AirException;
	boolean isExist(Connection conn, String sSql)throws Exception, SQLException;
}