You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.

32 lines
1.0 KiB

#import "c:\program files\common files\system\ado\msado15.dll" no_namespace rename("EOF","adoEOF")
class ado
{
/**
* 带输入参数的查询SQL语句.
* @param SQL - <I> SQL语句
* @param inputValueCount - <I> 输入参数数量
* @param inputValue - <I> 输入参数值
* @param outputColumn - <O> 输出表的列的数量
* @param outputValueCount - <O> 输出表的行的数量
* @param outputValue - <O> 输出表内容
* @return - OCI_OK or error code
*
* ORACLE 数据库的连接与封装函数
*/
public:
bool open(char* UserName, char* Pwd, const char* CnnStr);
bool open(char* username, char* password, char* dbname, char* ip);
bool execute(char * sql);
int ado::ado_QuerySQL(char *SQL, int inputValueCount, char ** inputValue);
int ado::ado_QuerySQLNoInputParam(char *SQL);
bool ado::executeInsert(char* selectSql, char * insertSqll, int result);
bool execute2(char* selectSql, char * updatesql, int result);
bool close();
private:
_ConnectionPtr m_pConnection;
_RecordsetPtr m_pRecordSet;
HRESULT hr;
};