odbcapi.h

SQLAPI C/C++ 连接Oracle 数据库！

    SQLINTEGER         cbSqlStrIn,
    SQLTCHAR 		  *szSqlStr,
    SQLINTEGER         cbSqlStrMax,
    SQLINTEGER 		  *pcbSqlStr);
typedef SQLRETURN (SQL_API *SQLNumParams_t)(
    SQLHSTMT           hstmt,
    SQLSMALLINT 	  *pcpar);
typedef SQLRETURN  (SQL_API *SQLNumResultCols_t)(SQLHSTMT StatementHandle,
           SQLSMALLINT *ColumnCount);
typedef SQLRETURN  (SQL_API *SQLParamData_t)(SQLHSTMT StatementHandle,
           SQLPOINTER *Value);
typedef SQLRETURN (SQL_API *SQLParamOptions_t)(
    SQLHSTMT          hstmt,
    SQLULEN		      crow,
    SQLULEN			  *pirow);
typedef SQLRETURN  (SQL_API *SQLPrepare_t)(SQLHSTMT StatementHandle,
           SQLTCHAR *StatementText, SQLINTEGER TextLength);
typedef SQLRETURN (SQL_API *SQLPrimaryKeys_t)(
    SQLHSTMT           hstmt,
    SQLTCHAR 		  *szCatalogName,
    SQLSMALLINT        cbCatalogName,
    SQLTCHAR 		  *szSchemaName,
    SQLSMALLINT        cbSchemaName,
    SQLTCHAR 		  *szTableName,
    SQLSMALLINT        cbTableName);
typedef SQLRETURN (SQL_API *SQLProcedureColumns_t)(
    SQLHSTMT           hstmt,
    SQLTCHAR 		  *szCatalogName,
    SQLSMALLINT        cbCatalogName,
    SQLTCHAR 		  *szSchemaName,
    SQLSMALLINT        cbSchemaName,
    SQLTCHAR 		  *szProcName,
    SQLSMALLINT        cbProcName,
    SQLTCHAR 		  *szColumnName,
    SQLSMALLINT        cbColumnName);
typedef SQLRETURN (SQL_API *SQLProcedures_t)(
    SQLHSTMT           hstmt,
    SQLTCHAR 		  *szCatalogName,
    SQLSMALLINT        cbCatalogName,
    SQLTCHAR 		  *szSchemaName,
    SQLSMALLINT        cbSchemaName,
    SQLTCHAR 		  *szProcName,
    SQLSMALLINT        cbProcName);
typedef SQLRETURN  (SQL_API *SQLPutData_t)(
	SQLHSTMT	StatementHandle,
    SQLPOINTER	Data,
	SQLLEN		StrLen_or_Ind);
typedef SQLRETURN  (SQL_API *SQLRowCount_t)(
	SQLHSTMT	StatementHandle, 
	SQLLEN		*RowCount);
typedef SQLRETURN  (SQL_API *SQLSetConnectAttr_t)(
	SQLHDBC		ConnectionHandle,
    SQLINTEGER	Attribute,
	SQLPOINTER	Value,
	SQLINTEGER	StringLength);
typedef SQLRETURN  (SQL_API *SQLSetConnectOption_t)(
	SQLHDBC			ConnectionHandle,
	SQLUSMALLINT	Option,
	SQLULEN			Value);
typedef SQLRETURN  (SQL_API *SQLSetCursorName_t)(SQLHSTMT StatementHandle,
           SQLTCHAR *CursorName, SQLSMALLINT NameLength);
typedef SQLRETURN  (SQL_API *SQLSetDescField_t)(SQLHDESC DescriptorHandle,
           SQLSMALLINT RecNumber, SQLSMALLINT FieldIdentifier,
           SQLPOINTER Value, SQLINTEGER BufferLength);
typedef SQLRETURN  (SQL_API *SQLSetDescRec_t)(
	SQLHDESC	DescriptorHandle,
	SQLSMALLINT RecNumber,
	SQLSMALLINT Type,
	SQLSMALLINT SubType,
	SQLLEN		Length,
	SQLSMALLINT Precision,
	SQLSMALLINT Scale,
	SQLPOINTER	Data,
	SQLLEN		*StringLength,
	SQLLEN		*Indicator);
typedef SQLRETURN  (SQL_API *SQLSetEnvAttr_t)(SQLHENV EnvironmentHandle,
           SQLINTEGER Attribute, SQLPOINTER Value,
           SQLINTEGER StringLength);
typedef SQLRETURN  (SQL_API *SQLSetParam_t)(
	SQLHSTMT		StatementHandle,
	SQLUSMALLINT	ParameterNumber,
	SQLSMALLINT		ValueType,
	SQLSMALLINT		ParameterType,
	SQLULEN			LengthPrecision,
	SQLSMALLINT		ParameterScale,
	SQLPOINTER		ParameterValue,
	SQLLEN			*StrLen_or_Ind);
typedef SQLRETURN (SQL_API *SQLSetPos_t)(
    SQLHSTMT           hstmt,
    SQLSETPOSIROW      irow,
    SQLUSMALLINT       fOption,
    SQLUSMALLINT       fLock);
typedef SQLRETURN (SQL_API *SQLSetScrollOptions_t)(    /*      Use SQLSetStmtOptions */
    SQLHSTMT           hstmt,
    SQLUSMALLINT       fConcurrency,
    SQLLEN		       crowKeyset,
    SQLUSMALLINT       crowRowset);
typedef SQLRETURN  (SQL_API *SQLSetStmtAttr_t)(SQLHSTMT StatementHandle,
           SQLINTEGER Attribute, SQLPOINTER Value,
           SQLINTEGER StringLength);
typedef SQLRETURN  (SQL_API *SQLSetStmtOption_t)(
	SQLHSTMT		StatementHandle,
	SQLUSMALLINT	Option,
	SQLULEN			Value);
typedef SQLRETURN  (SQL_API *SQLSpecialColumns_t)(SQLHSTMT StatementHandle,
           SQLUSMALLINT IdentifierType, SQLTCHAR *CatalogName,
           SQLSMALLINT NameLength1, SQLTCHAR *SchemaName,
           SQLSMALLINT NameLength2, SQLTCHAR *TableName,
           SQLSMALLINT NameLength3, SQLUSMALLINT Scope,
           SQLUSMALLINT Nullable);
typedef SQLRETURN  (SQL_API *SQLStatistics_t)(SQLHSTMT StatementHandle,
           SQLTCHAR *CatalogName, SQLSMALLINT NameLength1,
           SQLTCHAR *SchemaName, SQLSMALLINT NameLength2,
           SQLTCHAR *TableName, SQLSMALLINT NameLength3,
           SQLUSMALLINT Unique, SQLUSMALLINT Reserved);
typedef SQLRETURN (SQL_API *SQLTablePrivileges_t)(
    SQLHSTMT           hstmt,
    SQLTCHAR 		  *szCatalogName,
    SQLSMALLINT        cbCatalogName,
    SQLTCHAR 		  *szSchemaName,
    SQLSMALLINT        cbSchemaName,
    SQLTCHAR 		  *szTableName,
    SQLSMALLINT        cbTableName);
typedef SQLRETURN  (SQL_API *SQLTables_t)(SQLHSTMT StatementHandle,
           SQLTCHAR *CatalogName, SQLSMALLINT NameLength1,
           SQLTCHAR *SchemaName, SQLSMALLINT NameLength2,
           SQLTCHAR *TableName, SQLSMALLINT NameLength3,
           SQLTCHAR *TableType, SQLSMALLINT NameLength4);
typedef SQLRETURN  (SQL_API *SQLTransact_t)(SQLHENV EnvironmentHandle,
           SQLHDBC ConnectionHandle, SQLUSMALLINT CompletionType);


class SQLAPI_API odbcAPI : public saAPI
{
public:
	odbcAPI();

	SQLAllocConnect_t		SQLAllocConnect;	// 1.0
	SQLAllocEnv_t			SQLAllocEnv;		// 1.0
	SQLAllocHandle_t		SQLAllocHandle;		// 3.0
	SQLAllocStmt_t			SQLAllocStmt;		// 1.0
	SQLBindCol_t			SQLBindCol;			// 1.0
	SQLBindParameter_t		SQLBindParameter;	// 2.0
	SQLBrowseConnect_t		SQLBrowseConnect;	// 1.0
	SQLBulkOperations_t		SQLBulkOperations;	// 3.0
	SQLCancel_t				SQLCancel;			// 1.0
	SQLCloseCursor_t		SQLCloseCursor;		// 3.0
	SQLColAttribute_t		SQLColAttribute;	// 3.0
	SQLColAttributes_t		SQLColAttributes;	// 1.0
	SQLColumnPrivileges_t	SQLColumnPrivileges;// 1.0
	SQLColumns_t			SQLColumns;			// 1.0
	SQLConnect_t			SQLConnect;			// 1.0
	SQLCopyDesc_t			SQLCopyDesc;		// 3.0
	SQLDataSources_t		SQLDataSources;		// 1.0
	SQLDescribeCol_t		SQLDescribeCol;		// 1.0
	SQLDescribeParam_t		SQLDescribeParam;	// 1.0
	SQLDisconnect_t			SQLDisconnect;		// 1.0
	SQLDriverConnect_t		SQLDriverConnect;	// 1.0
	SQLDrivers_t			SQLDrivers;			// 2.0
	SQLEndTran_t			SQLEndTran;			// 3.0
	SQLError_t				SQLError;			// 1.0
	SQLExecDirect_t			SQLExecDirect;		// 1.0
	SQLExecute_t			SQLExecute;			// 1.0
	SQLExtendedFetch_t		SQLExtendedFetch;	// 1.0
	SQLFetch_t				SQLFetch;			// 1.0
	SQLFetchScroll_t		SQLFetchScroll;		// 1.0
	SQLForeignKeys_t		SQLForeignKeys;		// 1.0
	SQLFreeConnect_t		SQLFreeConnect;		// 1.0
	SQLFreeEnv_t			SQLFreeEnv;			// 1.0
	SQLFreeHandle_t			SQLFreeHandle;		// 3.0
	SQLFreeStmt_t			SQLFreeStmt;		// 1.0
	SQLGetConnectAttr_t		SQLGetConnectAttr;	// 3.0
	SQLGetConnectOption_t	SQLGetConnectOption;// 1.0
	SQLGetCursorName_t		SQLGetCursorName;	// 1.0
	SQLGetData_t			SQLGetData;			// 1.0
	SQLGetDescField_t		SQLGetDescField;	// 3.0
	SQLGetDescRec_t			SQLGetDescRec;		// 3.0
	SQLGetDiagField_t		SQLGetDiagField;	// 3.0
	SQLGetDiagRec_t			SQLGetDiagRec;		// 3.0
	SQLGetEnvAttr_t			SQLGetEnvAttr;		// 3.0
	SQLGetFunctions_t		SQLGetFunctions;	// 1.0
	SQLGetInfo_t			SQLGetInfo;			// 1.0
	SQLGetStmtAttr_t		SQLGetStmtAttr;		// 3.0
	SQLGetStmtOption_t		SQLGetStmtOption;	// 1.0
	SQLGetTypeInfo_t		SQLGetTypeInfo;		// 1.0
	SQLMoreResults_t		SQLMoreResults;		// 1.0
	SQLNativeSql_t			SQLNativeSql;		// 1.0
	SQLNumParams_t			SQLNumParams;		// 1.0
	SQLNumResultCols_t		SQLNumResultCols;	// 1.0
	SQLParamData_t			SQLParamData;		// 1.0
	SQLParamOptions_t		SQLParamOptions;	// 1.0
	SQLPrepare_t			SQLPrepare;			// 1.0
	SQLPrimaryKeys_t		SQLPrimaryKeys;		// 1.0
	SQLProcedureColumns_t	SQLProcedureColumns;// 1.0
	SQLProcedures_t			SQLProcedures;		// 1.0
	SQLPutData_t			SQLPutData;			// 1.0
	SQLRowCount_t			SQLRowCount;		// 1.0
	SQLSetConnectAttr_t		SQLSetConnectAttr;	// 3.0
	SQLSetConnectOption_t	SQLSetConnectOption;// 1.0
	SQLSetCursorName_t		SQLSetCursorName;	// 1.0
	SQLSetDescField_t		SQLSetDescField;	// 3.0
	SQLSetDescRec_t			SQLSetDescRec;		// 3.0
	SQLSetEnvAttr_t			SQLSetEnvAttr;		// 3.0
	SQLSetParam_t			SQLSetParam;		// 1.0
	SQLSetPos_t				SQLSetPos;			// 1.0
	SQLSetScrollOptions_t	SQLSetScrollOptions;// 1.0
	SQLSetStmtAttr_t		SQLSetStmtAttr;		// 3.0
	SQLSetStmtOption_t		SQLSetStmtOption;	// 1.0
	SQLSpecialColumns_t		SQLSpecialColumns;	// 1.0
	SQLStatistics_t			SQLStatistics;		// 1.0
	SQLTablePrivileges_t	SQLTablePrivileges;	// 1.0
	SQLTables_t				SQLTables;			// 1.0
	SQLTransact_t			SQLTransact;		// 1.0
};

class SQLAPI_API odbcConnectionHandles : public saConnectionHandles
{
public:
	odbcConnectionHandles();

	SQLHENV	m_hevn;
	SQLHDBC	m_hdbc;
};

class SQLAPI_API odbcCommandHandles : public saCommandHandles
{
public:
	odbcCommandHandles();

	SQLHSTMT	m_hstmt;
};

extern odbcAPI g_odbcAPI;

#endif // !defined(__ODBCAPI_H__)