oracle proc/c++ 和 oci to mysql_Linux下使用C/C++访问数据库——Oracle之OCI篇

最新推荐文章于 2022-07-27 12:49:00 发布
最新推荐文章于 2022-07-27 12:49:00 发布
阅读量183 收藏
点赞数
文章标签： oracle proc/c++ 和 oci to mysql
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/weixin_36236823/article/details/113644069
版权

/*

* OCIDB.cpp

*

*    Created .: Mar 1, 2009

*            Author: Steven Wee

*/

#include "OCIDB.h"

#include "OCIException.h"

#include "OCIError.h"

OCIDB::OCIDB()

{

strcpy(this ->m_sUser, "webtest");

strcpy(this ->m_sPwd, "ns0528AO");

strcpy(this ->m_sDBName, "NSTEST");

this ->BindInitVars();

}

OCIDB::~OCIDB()

{

}

int OCIDB::Single_Conn()

{

try

{

sword errno;

/*

* OCIEnvCreate(&envhp, mode, (const dvoid *)0, 0, 0, 0, (size_t)0, (dvoid **)0 );

*/

errno = OCIEnvCreate( &this ->m_pOCIEnv, OCI_OBJECT, (dvoid *)0, (dvoid *(*)(dvoid *, size_t))0, (dvoid *(*)(dvoid *, dvoid *, size_t))0, (void (*)(dvoid *, dvoid *))0, (size_t)0, (dvoid **)0);

if(errno)

{

throw OCIException(errno, (char *)"OCIDB::Single_Conn OCIEnvCreate");

}

/* Create Error Handle */

errno = OCIHandleAlloc( (dvoid *)this ->m_pOCIEnv, (dvoid **)&this ->m_pOCIError, OCI_HTYPE_ERROR, (size_t)0, (dvoid **)0);

if(errno)

{

throw OCIException(errno, (char *)"OCIDB::Single_Conn OCIHandleAlloc");

}

/* Login */

errno = OCILogon(this ->m_pOCIEnv, this ->m_pOCIError, &this ->m_pOCISvcCtx, (const OraText*)this ->m_sUser,

strlen(this ->m_sUser), (const OraText*)this ->m_sPwd, strlen(this ->m_sPwd), (const OraText*)this ->m_sDBName,

strlen(this ->m_sDBName));

if(errno)

{

throw OCIException(errno, this ->m_pOCIError, (char *)"OCIDB::Single_Conn OCILogin2");

}

return 0;

}

catch ( OCIException &ex)

{

std::cout << ex.GetErrFunc() << ex.GetErrMsg() << std::endl;

return -1;

}

}

void OCIDB::Single_Disc()

{

sword errno;

/* Log off */

errno = OCILogoff(m_pOCISvcCtx, this ->m_pOCIError);

if ( errno )

{

OCIError::PrintError(errno, (char *)"OCIDB::Single_Disc OCILogoff");

}

/* Free errno */

errno = OCIHandleFree((dvoid *)this ->m_pOCIError, (ub4)OCI_HTYPE_ERROR);

if ( errno )

{

OCIError::PrintError(errno, (char *)"OCIDB::Single_Disc OCIHandleFree");

}

/* Free Env Handle */

errno = OCIHandleFree((dvoid *)this ->m_pOCIEnv, (ub4)OCI_HTYPE_ENV);

if ( errno )

{

OCIError::PrintError(errno, (char *)"OCIDB::Single_Disc OCIHandleFree");

}

}

int OCIDB::Multiple_Conn()

{

try

{

sword errno;

errno = OCIInitialize( (ub4)OCI_DEFAULT, (dvoid *)0, (dvoid *(*)(dvoid *, size_t))0, (dvoid *(*)(dvoid *, dvoid *, size_t))0, (void (*)(dvoid *, dvoid *))0 );

if ( errno )

{

throw OCIException(errno, (char *)"OCIDB::Multiple_Conn OCIInitialize");

}

errno = OCIEnvInit( (OCIEnv **)&this ->m_pOCIEnv, OCI_DEFAULT, (size_t)0, (dvoid **)0);

if ( errno )

{

throw OCIException(errno, (char *)"OCIDB::Multiple_Conn OCIEnvInit");

}

/* Allocate Error Handle */

errno = OCIHandleAlloc( (dvoid *)this ->m_pOCIEnv, (dvoid **)&this ->m_pOCIError, OCI_HTYPE_ERROR, (size_t)0, (dvoid **)0);

if ( errno )

{

throw OCIException(errno, (char *)"OCIDB::Multiple_Conn OCIHandleAlloc Error");

}

/* Allocate Server Context Handle */

errno = OCIHandleAlloc( (dvoid *)this ->m_pOCIEnv, (dvoid **)&this ->m_pOCISvcCtx, OCI_HTYPE_SVCCTX, (size_t)0, (dvoid **)0);

if ( errno )

{

throw OCIException(errno, (char *)"OCIDB::Multiple_Conn OCIHandleAlloc SvcCtx");

}

/* Allocate Server Handle */

errno = OCIHandleAlloc( (dvoid *)this ->m_pOCIEnv, (dvoid **)&this ->m_pOCIServer, OCI_HTYPE_SERVER, (size_t)0, (dvoid **)0);

if ( errno )

{

throw OCIException(errno, (char *)"OCIDB::Multiple_Conn OCIHandleAlloc Server");

}

/* Set Server into ServerContext */

errno = OCIAttrSet( (dvoid *)this ->m_pOCISvcCtx, OCI_HTYPE_SVCCTX, (dvoid *)this ->m_pOCIServer, 0, OCI_ATTR_SERVER, (OCIError *)this ->m_pOCIError);

if ( errno )

{

throw OCIException(errno, (char *)"OCIDB::Multiple_Conn OCIAttrSet Server");

}

/* Attach Server */

errno = OCIServerAttach(this ->m_pOCIServer, this ->m_pOCIError, (text *)this ->m_sDBName, strlen(this ->m_sDBName), OCI_DEFAULT);

if ( errno )

{

throw OCIException(errno, (char *)"OCIDB::Multiple_Conn OCIServerAttach");

}

/* Allocate Session Handle */

errno = OCIHandleAlloc( (dvoid *)this ->m_pOCIEnv, (dvoid **)&this ->m_pOCISession, (ub4)OCI_HTYPE_SESSION, (size_t)0, (dvoid **)0);

if ( errno )

{

throw OCIException(errno, (char *)"OCIDB::Multiple_Conn OCIHandleAlloc Session");

}

/* Set Session into ServerContext */

errno = OCIAttrSet( (dvoid *)this ->m_pOCISvcCtx, (ub4)OCI_HTYPE_SVCCTX, (dvoid *)this ->m_pOCISession, (ub4)0, (ub4)OCI_ATTR_SESSION, (OCIError *)this ->m_pOCIError);

if ( errno )

{

throw OCIException(errno, (char *)"OCIDB::Multiple_Conn OCIAttrSet Session");

}

/* Set Session UserName */

errno = OCIAttrSet( (dvoid *)this ->m_pOCISession, OCI_HTYPE_SESSION, (dvoid *)this ->m_sUser, strlen(this ->m_sUser), OCI_ATTR_USERNAME, (OCIError *)this ->m_pOCIError);

if ( errno )

{

throw OCIException(errno, (char *)"OCIDB::Multiple_Conn OCIAttrSet UserName");

}

/* Set Session Password */

errno = OCIAttrSet( (dvoid *)this ->m_pOCISession, OCI_HTYPE_SESSION, (dvoid *)this ->m_sPwd, (ub4)strlen(this ->m_sPwd), (ub4)OCI_ATTR_PASSWORD, (OCIError *)this ->m_pOCIError);

if ( errno )

{

throw OCIException(errno, (char *)"OCIDB::Multiple_Conn OCIAttrSet Password");

}

/* Session Begin */

errno = OCISessionBegin(this ->m_pOCISvcCtx, this ->m_pOCIError, this ->m_pOCISession, OCI_CRED_RDBMS, OCI_DEFAULT);

if ( errno )

{

throw OCIException(errno, this ->m_pOCIError, (char *)"OCIDB::Multiple_Conn OCISessionBegin");

}

return 0;

}

catch (OCIException &ex)

{

std::cout << ex.GetErrFunc() << ex.GetErrMsg() << std::endl;

return -1;

}

}

void OCIDB::Multiple_Disc()

{

sword errno;

/* End Session */

errno = OCISessionEnd(this ->m_pOCISvcCtx, this ->m_pOCIError, this ->m_pOCISession, (ub4)OCI_DEFAULT);

if ( errno )

{

OCIError::PrintError(errno, (char *)"OCIDB::Multiple_Disc OCISessionEnd");

}

/* Free Session */

errno = OCIHandleFree( (dvoid *)this ->m_pOCISession, (ub4)OCI_HTYPE_SESSION );

if ( errno )

{

OCIError::PrintError(errno, (char *)"OCIDB::Multiple_Disc OCIHandleFree Session");

}

/* Detach Server */

errno = OCIServerDetach(this ->m_pOCIServer, this ->m_pOCIError, OCI_DEFAULT);

if ( errno )

{

OCIError::PrintError(errno, (char *)"OCIDB::Multiple_Disc OCIServerDetach");

}

/* Free Server */

errno = OCIHandleFree( (dvoid *)this ->m_pOCIServer, (ub4)OCI_HTYPE_SERVER );

if ( errno )

{

OCIError::PrintError(errno, (char *)"OCIDB::Multiple_Disc OCIHandleFree Server");

}

/* Free ServerContext */

errno = OCIHandleFree( (dvoid *)this ->m_pOCISvcCtx, (ub4)OCI_HTYPE_SVCCTX );

if ( errno )

{

OCIError::PrintError(errno, (char *)"OCIDB::Multiple_Disc OCIHandleFree ServerContext");

}

/* Free Error */

errno = OCIHandleFree( (dvoid *)this ->m_pOCIError, (ub4)OCI_HTYPE_ERROR );

if ( errno )

{

OCIError::PrintError(errno, (char *)"OCIDB::Multiple_Disc OCIHandleFree Error");

}

/* Free Env */

errno = OCIHandleFree( (dvoid *)this ->m_pOCIEnv, (ub4)OCI_HTYPE_ENV );

if ( errno )

{

OCIError::PrintError(errno, (char *)"OCIDB::Multiple_Disc OCIHandleFree Env");

}

}

int OCIDB::ExcuteSQL(char * sql)

{

sword errno;

try

{

/* Allocate Stmt */

errno = OCIHandleAlloc( (dvoid *)this ->m_pOCIEnv, (dvoid **)&this ->m_pOCIStmt, OCI_HTYPE_STMT, (size_t)0, (dvoid **)0);

if ( errno )

{

OCIError::PrintError(errno, (char *)"OCIDB::ExcuteSQL OCIHandleAlloc");

}

errno = OCIStmtPrepare(this ->m_pOCIStmt, this ->m_pOCIError, (const OraText *)sql, (ub4)strlen(sql), (ub4)OCI_NTV_SYNTAX, (ub4)OCI_DEFAULT);

if ( errno )

{

OCIError::PrintError(errno, (char *)"OCIDB::ExcuteSQL OCIStmtPrepare");

}

errno = OCIStmtExecute(this ->m_pOCISvcCtx, this ->m_pOCIStmt, this ->m_pOCIError, (ub4)1, (ub4)0, (const OCISnapshot *)NULL, (OCISnapshot *)NULL, OCI_DEFAULT);

if ( errno )

{

OCIError::PrintError(errno, (char *)"OCIDB::ExcuteSQL OCIStmtExecute");

}

errno = OCITransCommit( this ->m_pOCISvcCtx, this ->m_pOCIError, 0);

if ( errno )

{

OCIError::PrintError(errno, (char *)"OCIDB::ExcuteSQL OCITransCommit");

}

errno = OCIHandleFree( (dvoid *)this ->m_pOCIStmt, (ub4)OCI_HTYPE_STMT );

if ( errno )

{

OCIError::PrintError(errno, (char *)"OCIDB::ExcuteSQL OCIHandleFree");

}

return 0;

}

catch (OCIException &ex)

{

/* Rollback */

errno = OCITransRollback( this ->m_pOCISvcCtx, this ->m_pOCIError, 0);

if ( errno )

{

OCIError::PrintError(errno, (char *)"OCIDB::ExcuteSQL OCITransRollback");

}

/* Free Stmt */

errno = OCIHandleFree( (dvoid *)this ->m_pOCIStmt, (ub4)OCI_HTYPE_STMT);

if ( errno )

{

OCIError::PrintError(errno, (char *)"OCIDB::ExcuteSQL OCIHandleFree");

}

std::cout << ex.GetErrFunc() << ex.GetErrMsg() << std::endl;

return -1;

}

}

void OCIDB::BindInitVars()

{

int i;

for( i = 0 ; i < MAX_BINDVAR_COUNT - 1 ; i++ )

{

this ->m_BindVars[i].VarType = 0;

this ->m_BindVars[i].VarName = 0;

this ->m_BindVars[i].VarLen = 0;

this ->m_BindVars[i].ValueChar = 0;

}

this ->m_iBindVarsCount = 0;

}

void OCIDB::BindClearVars()

{

int i;

for( i = 0 ; i < m_iBindVarsCount - 1 ; i++ )

{

delete [] this ->m_BindVars[i].VarName;

if ( this ->m_BindVars[i].VarType == SQLT_STR )

delete [] this ->m_BindVars[i].ValueChar;

if ( this ->m_BindVars[i].VarType == SQLT_INT )

delete [] this ->m_BindVars[i].ValueInt;

this ->m_BindVars[i].VarType = 0;

this ->m_BindVars[i].VarName = 0;

this ->m_BindVars[i].VarLen = 0;

this ->m_BindVars[i].ValueChar = 0;

}

this ->m_iBindVarsCount = 0;

}

void OCIDB::BindAddVar(char * name, char * value)

{

if ( this ->m_iBindVarsCount >= MAX_BINDVAR_COUNT )

return;

this ->m_BindVars[this ->m_iBindVarsCount].VarType = SQLT_STR;

this ->m_BindVars[this ->m_iBindVarsCount].VarName = new char[strlen(name) + 1];

strcpy( this ->m_BindVars[this ->m_iBindVarsCount].VarName, name);

this ->m_BindVars[this ->m_iBindVarsCount].ValueChar = new char[strlen(value) + 1];

strcpy( this ->m_BindVars[this ->m_iBindVarsCount].ValueChar, value);

this ->m_BindVars[this ->m_iBindVarsCount].VarLen = strlen(value) + 1;

this ->m_iBindVarsCount++;

}

void OCIDB::BindAddVar(char * name, int * value)

{

if ( this ->m_iBindVarsCount >= MAX_BINDVAR_COUNT )

return;

this ->m_BindVars[this ->m_iBindVarsCount].VarType = SQLT_INT;

this ->m_BindVars[this ->m_iBindVarsCount].VarName = new char[strlen(name) + 1];

strcpy( this ->m_BindVars[this ->m_iBindVarsCount].VarName, name);

this ->m_BindVars[this ->m_iBindVarsCount].ValueInt = new int;

this ->m_BindVars[this ->m_iBindVarsCount].ValueInt = value;

this ->m_BindVars[this ->m_iBindVarsCount].VarLen = sizeof(int);

this ->m_iBindVarsCount++;

}

int OCIDB::BindSQL(char * sql)

{

if( this ->m_iBindVarsCount == 0 )

return -1;

sword errno;

try

{

/* Allocate Stmt */

errno = OCIHandleAlloc( (dvoid *)this ->m_pOCIEnv, (dvoid **)&this ->m_pOCIStmt, OCI_HTYPE_STMT, (size_t)0, (dvoid **)0);

if ( errno )

{

throw OCIException(errno, (char *)"OCIDB::BindSQL OCIHandleAlloc Stmt");

}

/* Prepare Stmt */

errno = OCIStmtPrepare( this ->m_pOCIStmt, this ->m_pOCIError, (const OraText *)sql, (ub4)strlen(sql), (ub4)OCI_NTV_SYNTAX, (ub4)OCI_DEFAULT );

if ( errno )

{

throw OCIException(errno, (char *)"OCIDB::BindSQL OCIStmtPrepare");

}

/* Bind Vars */

int i;

for ( i = 0 ; i < m_iBindVarsCount - 1 ; i++ )

{

/* Bind By Name */

errno = OCIBindByName( this ->m_pOCIStmt, &this ->m_pOCIBind, this ->m_pOCIError, (text *)this ->m_BindVars[i].VarName, -1,

(dvoid *)this ->m_BindVars[i].ValueChar, this ->m_BindVars[i].VarLen, this ->m_BindVars[i].VarType, (dvoid *)0, (ub2 *)0, (ub2 *)0, (ub4)0, (ub4 *)0, OCI_DEFAULT);

if ( errno )

{

throw OCIException(errno, this ->m_pOCIError, (char *)"OCIDB::BindSQL OCIBindByName");

}

/*

errno = OCIBindByPos( this ->m_pOCIStmt, &this ->m_pOCIBind, this ->m_pOCIError, i + 1, (dvoid *)this ->m_BindVars[i].ValueChar,

this ->m_BindVars[i].VarLen, this ->m_BindVars[i].VarType, (dvoid *)0, (ub2 *)0, (ub2 *)0, (ub4)0, (ub4 *)0, OCI_DEFAULT);

if ( errno )

{

throw OCIException(errno, this ->m_pOCIError, (char *)"OCIDB::BindSQL OCIBindByPos");

}

*/

}

/* Execute SQL */

errno = OCIStmtExecute( this ->m_pOCISvcCtx, this ->m_pOCIStmt, this ->m_pOCIError, (ub4)1, (ub4)0, (const OCISnapshot *)NULL, (OCISnapshot *)NULL, OCI_DEFAULT);

if ( errno )

{

throw OCIException(errno, this ->m_pOCIError, (char *)"OCIDB::BindSQL OCIStmtExecute");

}

/*  Commit */

errno = OCITransCommit( this ->m_pOCISvcCtx, this ->m_pOCIError, 0);

if ( errno )

{

throw OCIException(errno, this ->m_pOCIError, (char *)"OCIDB::BindSQL OCITransCommit");

}

/* Free Stmt */

errno = OCIHandleFree( (dvoid *)this ->m_pOCIStmt, (ub4)OCI_HTYPE_STMT );

if ( errno )

{

throw OCIException(errno, this ->m_pOCIError, (char *)"OCIDB::BindSQL OCIHandleFree");

}

/* Clear Vars */

this ->BindClearVars();

return 0;

}

catch ( OCIException &ex )

{

/* Rollback */

errno = OCITransRollback( this ->m_pOCISvcCtx, this ->m_pOCIError, 0);

if ( errno )

{

OCIError::PrintError(errno, (char *)"OCIDB::BindSQL OCITransRollback");

}

/* Free Stmt */

errno = OCIHandleFree( (dvoid *)this ->m_pOCIStmt, (ub4)OCI_HTYPE_STMT);

if ( errno )

{

OCIError::PrintError(errno, (char *)"OCIDB::BindSQL OCIHandleFree");

}

this ->BindClearVars();

std::cout << ex.GetErrFunc() << ex.GetErrMsg() << std::endl;

return -1;

}

}

int OCIDB::UserPrepare(char * sql)

{

sword errno;

try

{

/* Allocate Stmt */

errno = OCIHandleAlloc( (dvoid *)this ->m_pOCIEnv, (dvoid **)&this ->m_pOCIStmt, OCI_HTYPE_STMT, (size_t)0, (dvoid **)0 );

if ( errno )

{

throw OCIException(errno, (char *)"OCIDB::UserPrepare OCIHandleAlloc");

}

/* Prepare Stmt */

errno = OCIStmtPrepare( this ->m_pOCIStmt, this ->m_pOCIError, (const OraText *)sql, (ub4)strlen(sql), (ub4)OCI_NTV_SYNTAX, (ub4)OCI_DEFAULT );

if ( errno )

{

throw OCIException(errno, (char *)"OCIDB::UserPrepare OCIStmtPrepare");

}

return 0;

}

catch ( OCIException &ex )

{

/* Free Stmt */

errno = OCIHandleFree( (dvoid *)this ->m_pOCIStmt, (ub4)OCI_HTYPE_STMT );

if ( errno )

{

OCIError::PrintError(errno, (char *)"OCIDB::UserPrepare Ex OCIHandleFree");

}

std::cout << ex.GetErrFunc() << ex.GetErrMsg() << std::endl;

return -1;

}

}

int OCIDB::UserFree()

{

sword errno;

/* Free Stmt */

errno = OCIHandleFree( (dvoid *)this ->m_pOCIStmt, (ub4)OCI_HTYPE_STMT );

if ( errno )

{

OCIError::PrintError(errno, (char *)"OCIDB::UserFree OCIHandleFree");

return -1;

}

return 0;

}

int OCIDB::UserBind(char * name, char * value)

{

sword errno;

try

{

errno = OCIBindByName( this ->m_pOCIStmt, &this ->m_pOCIBind, this ->m_pOCIError, (text *)name, -1,

(dvoid *)value, strlen(value) + 1, SQLT_STR, (dvoid *)0, (ub2 *)0, (ub2 *)0, (ub4)0, (ub4 *)0, OCI_DEFAULT );

if ( errno )

{

throw OCIException(errno, this ->m_pOCIError, (char *)"OCIDB::UserBind OCIBindByName");

}

return 0;

}

catch ( OCIException &ex )

{

/* Free Stmt */

errno = OCIHandleFree( (dvoid *)this ->m_pOCIStmt, (ub4)OCI_HTYPE_STMT );

if ( errno )

{

OCIError::PrintError(errno, (char *)"OCIDB::UserBind Ex OCIHandleFree");

}

std::cout << ex.GetErrFunc() << ex.GetErrMsg() << std::endl;

return -1;

}

}

int OCIDB::UserBind(char * name, int value)

{

sword errno;

try

{

int val = value;

errno = OCIBindByName( this ->m_pOCIStmt, &this ->m_pOCIBind, this ->m_pOCIError, (text *)name, -1,

(dvoid *)&val, sizeof(int), SQLT_INT, (dvoid *)0, (ub2 *)0, (ub2 *)0, (ub4)0, (ub4 *)0, OCI_DEFAULT );

if ( errno )

{

throw OCIException(errno, this ->m_pOCIError, (char *)"OCIDB::UserBind OCIBindByName");

}

return 0;

}

catch ( OCIException &ex )

{

/* Free Stmt */

errno = OCIHandleFree( (dvoid *)this ->m_pOCIStmt, (ub4)OCI_HTYPE_STMT );

if ( errno )

{

OCIError::PrintError(errno, (char *)"OCIDB::UserBind Ex OCIHandleFree");

}

std::cout << ex.GetErrFunc() << ex.GetErrMsg() << std::endl;

return -1;

}

}

int OCIDB::UserExecute()

{

sword errno;

try

{

errno = OCIStmtExecute( this ->m_pOCISvcCtx, this ->m_pOCIStmt, this ->m_pOCIError, (ub4)1, (ub4)0,

(const OCISnapshot *)NULL, (OCISnapshot *)NULL, OCI_DEFAULT );

if ( errno )

{

throw OCIException(errno, this ->m_pOCIError, (char *)"OCIDB::UserExecute OCIBindByName");

}

return 0;

}

catch ( OCIException &ex )

{

/* Free Stmt */

errno = OCIHandleFree( (dvoid *)this ->m_pOCIStmt, (ub4)OCI_HTYPE_STMT );

if ( errno )

{

OCIError::PrintError(errno, (char *)"OCIDB::UserExecute Ex OCIHandleFree");

}

std::cout << ex.GetErrFunc() << ex.GetErrMsg() << std::endl;

return -1;

}

}

int OCIDB::UserCommit()

{

sword errno;

errno = OCITransCommit( this ->m_pOCISvcCtx, this ->m_pOCIError, 0);

if ( errno )

{

OCIError::PrintError(errno, (char *)"OCIDB::UserCommit OCITransCommit");

return -1;

}

return 0;

}

int OCIDB::UserSelect(char * sql)

{

sword errno;

try

{

/* Allocate Stmt */

errno = OCIHandleAlloc( (dvoid *)this ->m_pOCIEnv, (dvoid **)&this ->m_pOCIStmt, OCI_HTYPE_STMT, (size_t)0, (dvoid **)0 );

if ( errno )

{

throw OCIException(errno, this ->m_pOCIError, (char *)"OCIDB::UserSelect OCIHandleAlloc");

}

/* Prepare Stmt */

errno = OCIStmtPrepare( this ->m_pOCIStmt, this ->m_pOCIError, (const OraText *)sql, (ub4)strlen(sql), (ub4)OCI_NTV_SYNTAX, (ub4)OCI_DEFAULT );

if ( errno )

{

throw OCIException(errno, this ->m_pOCIError, (char *)"OCIDB::UserSelect OCIStmtPrepare");

}

/* Execute Stmt */

errno = OCIStmtExecute( this ->m_pOCISvcCtx, this ->m_pOCIStmt, this ->m_pOCIError, (ub4)0, (ub4)0, (OCISnapshot *)NULL, (OCISnapshot *)NULL, OCI_DEFAULT );

if ( errno )

{

throw OCIException(errno, this ->m_pOCIError, (char *)"OCIDB::UserSelect OCIStmtExecute");

}

errno = OCIAttrGet( this ->m_pOCIStmt, (ub4)OCI_HTYPE_STMT, (dvoid *)&this ->m_iSelectVarsCount, (ub4 *)0, (ub4)OCI_ATTR_PARAM_COUNT, this ->m_pOCIError );

if ( errno )

{

throw OCIException(errno, this ->m_pOCIError, (char *)"OCIDB::UserSelect OCIAttrGet");

}

int iLen;

char * sName;

ub2 iSize, iPrecision, iType;

ub1 iScale, iIsNull;

int i;

for ( i = 0 ; i < this ->m_iSelectVarsCount ; i++ )

{

sName = 0;

errno = OCIParamGet( this ->m_pOCIStmt, OCI_HTYPE_STMT, this ->m_pOCIError, (dvoid **)&this ->m_pOCIParam, i+ 1 );

if ( errno )

{

throw OCIException(errno, this ->m_pOCIError, (char *)"OCIDB::UserSelect OCIParamGet");

}

//  Column Name

errno = OCIAttrGet( (dvoid *)this ->m_pOCIParam, OCI_DTYPE_PARAM, (dvoid **)&sName, (ub4 *)&iLen, OCI_ATTR_NAME, this ->m_pOCIError );

if ( errno )

{

throw OCIException(errno, this ->m_pOCIError, (char *)"OCIDB::UserSelect OCIAttrGet Column Name");

}

strncpy( this ->m_SelectVars[i].VarName, sName, iLen );

this ->m_SelectVars[i].VarName[iLen] = 0;

//  Data Size;

errno = OCIAttrGet( (dvoid *)this ->m_pOCIParam, OCI_DTYPE_PARAM, (dvoid *)&iSize, (ub4 *)0, OCI_ATTR_DATA_SIZE, this ->m_pOCIError );

if ( errno )

{

throw OCIException(errno, this ->m_pOCIError, (char *)"OCIDB::UserSelect OCIAttrGet Data Size");

}

this ->m_SelectVars[i].VarSize = iSize;

//  Data Precision

errno = OCIAttrGet( (dvoid *)this ->m_pOCIParam, OCI_DTYPE_PARAM, (dvoid *)&iPrecision, (ub4 *)0, OCI_ATTR_PRECISION, this ->m_pOCIError );

if ( errno )

{

throw OCIException(errno, this ->m_pOCIError, (char *)"OCIDB::UserSelect OCIAttrGet Data Precision");

}

this ->m_SelectVars[i].VarPrecision = iPrecision;

//  Data Scale

errno = OCIAttrGet( (dvoid *)this ->m_pOCIParam, OCI_DTYPE_PARAM, (dvoid *)&iScale, (ub4 *)0, OCI_ATTR_SCALE, this ->m_pOCIError );

if ( errno )

{

throw OCIException(errno, this ->m_pOCIError, (char *)"OCIDB::UserSelect OCIAttrGet Data Scale");

}

this ->m_SelectVars[i].VarScale = iScale;

//  Data Is Null

errno = OCIAttrGet( (dvoid *)this ->m_pOCIParam, OCI_DTYPE_PARAM, (dvoid *)&iIsNull, (ub4 *)0, OCI_ATTR_IS_NULL, this ->m_pOCIError );

if ( errno )

{

throw OCIException(errno, this ->m_pOCIError, (char *)"OCIDB::UserSelect OCIAttrGet Data Is Null");

}

this ->m_SelectVars[i].VarIsNull = iIsNull;

//  Data Type

errno = OCIAttrGet( (dvoid *)this ->m_pOCIParam, OCI_DTYPE_PARAM, (dvoid *)&iType, (ub4 *)0, OCI_ATTR_DATA_TYPE, this ->m_pOCIError );

if ( errno )

{

throw OCIException(errno, this ->m_pOCIError, (char *)"OCIDB::UserSelect OCIAttrGet Data Type");

}

this ->m_SelectVars[i].VarType = iType;

switch ( this ->m_SelectVars[i].VarType )

{

case SQLT_NUM:

if ( this ->m_SelectVars[i].VarScale == 0 )

{

this ->m_SelectVars[i].ValueInt = new int;

this ->m_SelectVars[i].VarType = TYPE_INT;

errno = OCIDefineByPos( this ->m_pOCIStmt, &this ->m_pOCIDefine, this ->m_pOCIError, i + 1,

(dvoid *)this ->m_SelectVars[i].ValueInt,  sizeof(int), SQLT_INT, this ->indp, (ub2 *)0, (ub2 *)0, OCI_DEFAULT );

if ( errno )

{

throw OCIException(errno, this ->m_pOCIError, (char *)"OCIDB::UserSelect OCIDefineByPos");

}

}

else

{

this ->m_SelectVars[i].ValueFloat = new float;

this ->m_SelectVars[i].VarType = TYPE_FLOAT;

errno = OCIDefineByPos( this ->m_pOCIStmt, &this ->m_pOCIDefine, this ->m_pOCIError, i + 1,

(dvoid *)this ->m_SelectVars[i].ValueFloat,  sizeof(float), SQLT_FLT, this ->indp, (ub2 *)0, (ub2 *)0, OCI_DEFAULT );

if ( errno )

{

throw OCIException(errno, this ->m_pOCIError, (char *)"OCIDB::UserSelect OCIDefineByPos");

}

}

break;

case SQLT_CHR:

this ->m_SelectVars[i].ValueChar = new char[this ->m_SelectVars[i].VarSize + 1];

this ->m_SelectVars[i].VarType = TYPE_STRING;

errno = OCIDefineByPos( this ->m_pOCIStmt, &this ->m_pOCIDefine, this ->m_pOCIError, i + 1,

(dvoid *)this ->m_SelectVars[i].ValueChar,  this ->m_SelectVars[i].VarSize + 1, SQLT_STR, this ->indp, (ub2 *)0, (ub2 *)0, OCI_DEFAULT );

if ( errno )

{

throw OCIException(errno, this ->m_pOCIError, (char *)"OCIDB::UserSelect OCIDefineByPos");

}

break;

case SQLT_BLOB:

/* Allocate lobLocator */

errno = OCIDe.orAlloc( (dvoid *)this ->m_pOCIEnv, (dvoid **)&this ->m_SelectVars[i].lobLocator, (ub4)OCI_DTYPE_LOB, (size_t)0, (dvoid **)0 );

if ( errno )

{

throw OCIException(errno, this ->m_pOCIError, (char *)"OCIDB::UserSelect OCIDe.orAlloc");

}

this ->m_SelectVars[i].VarType = TYPE_BLOB;

errno = OCIDefineByPos( this ->m_pOCIStmt, &this ->m_pOCIDefine, this ->m_pOCIError, (ub4)i + 1, (dvoid *)&this ->m_SelectVars[i].lobLocator, (sb4)0,

(ub2)SQLT_BLOB, this ->indp, (ub2 *)0, (ub2 *)0, (ub4)OCI_DEFAULT);

if ( errno )

{

throw OCIException(errno, this ->m_pOCIError, (char *)"OCIDB::UserSelect OCIDefineByPos");

}

break;

case SQLT_CLOB:

/* Allocate lobLocator */

errno = OCIDe.orAlloc( (dvoid *)this ->m_pOCIEnv, (dvoid **)&this ->m_SelectVars[i].lobLocator, (ub4)OCI_DTYPE_LOB, (size_t)0, (dvoid **)0 );

if ( errno )

{

throw OCIException(errno, this ->m_pOCIError, (char *)"OCIDB::UserSelect OCIDe.orAlloc");

}

this ->m_SelectVars[i].VarType = TYPE_BLOB;

errno = OCIDefineByPos( this ->m_pOCIStmt, &this ->m_pOCIDefine, this ->m_pOCIError, (ub4)i + 1, (dvoid *)&this ->m_SelectVars[i].lobLocator, (sb4)0,

(ub2)SQLT_BLOB, this ->indp, (ub2 *)0, (ub2 *)0, (ub4)OCI_DEFAULT);

if ( errno )

{

throw OCIException(errno, this ->m_pOCIError, (char *)"OCIDB::UserSelect OCIDefineByPos");

}

break;

}

}

return 0;

}

catch ( OCIException &ex )

{

/* Free Stmt */

errno = OCIHandleFree( (dvoid *)this ->m_pOCIStmt, (ub4)OCI_HTYPE_STMT );

if ( errno )

{

OCIError::PrintError(errno, (char *)"OCIDB::UserExecute Ex OCIHandleFree");

}

std::cout << ex.GetErrFunc() << ex.GetErrMsg() << std::endl;

return -1;

}

}

int OCIDB::UserFetch()

{

sword errno;

try

{

errno = OCIStmtFetch( this ->m_pOCIStmt, this ->m_pOCIError, 1, OCI_FETCH_NEXT, OCI_DEFAULT );

if ( errno && errno != OCI_NO_DATA )

{

throw OCIException(errno, this ->m_pOCIError, (char *)"OCIDB::UserFetch OCIStmtFetch");

}

if ( errno == OCI_NO_DATA )

return 1;

return 0;

}

catch ( OCIException &ex )

{

std::cout << ex.GetErrFunc() << ex.GetErrMsg() << std::endl;

return -1;

}

}

int OCIDB::UserSelectFree()

{

int i;

for ( i = 0 ; i < this ->m_iSelectVarsCount ; i++ )

{

switch ( this ->m_SelectVars[i].VarType )

{

case TYPE_STRING:

delete [] this ->m_SelectVars[i].ValueChar;

break;

case TYPE_FLOAT:

delete this ->m_SelectVars[i].ValueFloat;

break;

case TYPE_INT:

delete this ->m_SelectVars[i].ValueInt;

break;

}

}

return this ->UserFree();

}

int OCIDB::UserGetInt(int index)

{

switch ( this ->m_SelectVars[index].VarType )

{

case TYPE_FLOAT:

return (int)*m_SelectVars[index].ValueFloat;

break;

case TYPE_INT:

return *m_SelectVars[index].ValueInt;

break;

default:

return 0;

}

}

int OCIDB::UserGetInt(char * name)

{

int i;

for ( i = 0 ; i < this ->m_iSelectVarsCount ; i++ )

{

if ( this ->StrCmp(m_SelectVars[i].VarName, name) )

{

switch ( this ->m_SelectVars[i].VarType )

{

case TYPE_FLOAT:

return (int)*m_SelectVars[i].ValueFloat;

break;

case TYPE_INT:

return *m_SelectVars[i].ValueInt;

break;

default:

return 0;

}

}

}

return 0;

}

float OCIDB::UserGetFloat(int index)

{

switch ( this ->m_SelectVars[index].VarType )

{

case TYPE_FLOAT:

return *m_SelectVars[index].ValueFloat;

break;

case TYPE_INT:

return (float)*m_SelectVars[index].ValueInt;

break;

default:

return 0;

}

}

float OCIDB::UserGetFloat(char * name)

{

int i;

for ( i = 0 ; i < this ->m_iSelectVarsCount ; i++ )

{

if ( this ->StrCmp(m_SelectVars[i].VarName, name) )

{

switch ( this ->m_SelectVars[i].VarType )

{

case TYPE_FLOAT:

return *m_SelectVars[i].ValueFloat;

break;

case TYPE_INT:

return (float)*m_SelectVars[i].ValueInt;

break;

default:

return 0;

}

}

}

return 0;

}

char * OCIDB::UserGetString(int index)

{

if ( this ->m_SelectVars[index].VarType == TYPE_STRING )

{

return this ->m_SelectVars[index].ValueChar;

}

else

{

return 0;

}

}

char * OCIDB::UserGetString(char * name)

{

int i;

for ( i = 0 ; i < this ->m_iSelectVarsCount ; i++ )

{

if ( this ->StrCmp(m_SelectVars[i].VarName, name) )

{

if ( this ->m_SelectVars[i].VarType == TYPE_STRING )

{

return this ->m_SelectVars[i].ValueChar;

}

}

}

return 0;

}

char * OCIDB::UserGetBlob(int index)

{

if ( this ->m_SelectVars[index].VarType == TYPE_BLOB )

{

return this ->m_SelectVars[index].ValueChar;

}

else

{

return 0;

}

}

char * OCIDB::UserGetBlob(char * name)

{

int i;

for ( i = 0 ; i < this ->m_iSelectVarsCount ; i++ )

{

if ( this ->StrCmp(m_SelectVars[i].VarName, name) )

{

if ( this ->m_SelectVars[i].VarType == TYPE_BLOB )

{

return this ->m_SelectVars[i].ValueChar;

}

}

}

return 0;

}

vector< vector > OCIDB::getResult()

{

int i;

vector objectValue;

StringTools stringTools;

while ( this ->UserFetch() == 0 )

{

objectValue.clear();

for ( i = 0 ; i < this ->m_iSelectVarsCount ; i++ )

{

switch ( this ->m_SelectVars[i].VarType )

{

case TYPE_STRING:

objectValue.push_back(this ->UserGetString(i));

break;

case TYPE_FLOAT:

objectValue.push_back(stringTools.ToString(this ->UserGetFloat(i)));

break;

case TYPE_INT:

objectValue.push_back(stringTools.ToString(this ->UserGetInt(i)));

break;

case TYPE_BLOB:

break;

}

}

resultList.push_back(objectValue);

}

return resultList;

}

void inline OCIDB::StrUpper(char * str)

{

int i;

int sLen = strlen(str);

for ( i = 0 ; i < sLen ; i++ )

{

str[i] = toupper(str[i]);

}

}

bool inline OCIDB::StrCmp(const char * ori, const char * des)

{

int iLenOri, iLenDes;

int j;

iLenOri = strlen(ori);

iLenDes = strlen(des);

if ( iLenOri != iLenDes )

return false;

for ( j = 0 ; j < iLenOri ; j++ )

{

if ( toupper(ori[j]) != toupper(des[j]) )

{

return false;

}

}

return true;

}

韩站长
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
C/C++访问数据库——Oracle之OCI篇
ykqiu的专栏
11-10 3988
<br />Linux下使用C/C++访问数据库——Oracle之OCI篇  一、什么是OCI？开发基于Oracle数据库的应用程序，我们可以选择多种工具，不仅可以用一般的数据库开发技术，诸如ADO（ActiveX Data Objects）、ODBC（Open DataBase Connectivity）等等，同时，也可以用Oracle公司提供的专门的开发工具，诸如Pro C_C++，OCI（Oracle Call Intedace）等等。比较这几种方式，前者因为是通用技术，开发起来比较容易，但是有一个致
C++ oci操作oracle数据库
07-10
C++ oci操作oracle数据库代码
OCI连接oracle数据库（c++）实现
07-29
OCI连接oracle数据库（c++）实现 已经封装好的c++实现的Oci
mysql的oci
03-19
mysql的oci.dll，给那些需要连接navicat报错的同学看看
oci连接mysql_Oracle Call Interface (OCI)
weixin_35662417的博客
01-28 275
Oracle 调用接口可靠 — Oracle 数据库通过 OCI 执行 SQL 语句。Oracle 调用接口 (OCI) 是最全面、性能最高、基于原生“C”语言的 Oracle 数据库接口，它可以提供 Oracle 数据库的全部功能。OCI 为构建各种语言专用接口(如 Oracle JDBC-OCI、ODP.Net、Oracle 预编译器、Oracle ODBC 和 Oracle C++ Call...
oci连接mysql_PLSQL Developer配置OCI连接远程数据库
weixin_42498163的博客
02-08 297
一、当前环境本机系统：win10 64位PLSQL版本：10 32位数据库版本：11g 位数不详instantclient版本：12.x 32位二、下载文件1、下载plsq10链接：https://pan.baidu.com/s/1RuDAyywhUr-yMEMLuD1UnA提取码：eb0j解压后，运行plsqldev.exe2、下载instantclient：链接...
Oracle编程Oci_ProC_odbc简易入门
07-04
Oracle编程涉及多个层面，本文将重点讲解Oci(Oracle Call Interface)、Pro*C及ODBC(Open Database Connectivity)的基础知识，这些都是在Oracle数据库环境中进行应用开发的重要工具。 首先，Oracle Call Interface ...
proc*c/c++简介
HelloWorld
07-16 9766
一、概述 1. 概念 通过在过程化编程语言C/C++中嵌入SQL语句而开发出的应用程序。在通用编程语言中使用的SQL称为嵌入式SQL。 在SQL标准中定义了多种语言的嵌入式SQL ，各个厂商对嵌入式SQL的具体实现不同。 在C/C++语言中嵌入SQL语句而开发出的应用程序称为Pro*C/C++程序。 目的：使c/c++这种高效率语言成为访问数据库的工具。 嵌入式SQL的载体是宿主...
CentOS7安装Oracle数据库的全流程
m0_67403076的博客
07-27 2332
如果本机安装有Oracle数据库，用PLSQLDev连接数据库自然没有什么问题，但是如果本机没有安装oracle客户端，要连接非本地机的oracleDB，那么一种方法就是在本地也安装Oracle，或者安装类似oracledevelop10g开发套件，这些安装方法比较麻烦，安装下来占用磁盘空间和系统资源，特别是oracle数据库启动的时候大量占用系统服务和资源，不是理想的方法。用户可直接登录到system用户以创建其他用户，因为system具有创建别的用户的权限。...
小写金额转换为大写金额程序,select case的应用,小写金额转换为大写金额，当输入数字时就会对应产生大写金额。(VB6.0源代码编写)
12-16
小写金额转换为大写金额程序,select case的应用,小写金额转换为大写金额，当输入数字时就会对应产生大写金额。(VB6.0源代码编写)
OTL （Oracle Template Library）
04-12
支持 oracle 的OCI 支持DB2的CLI 支持ODBC(通过ODBC,可支持SQL SERVER,MySQL等) 跨OS平台: 标准C++语言,支持 unix/linux/windows 使用简单: 只有一个头文件 接口简洁.otl_stream, otl_connect, otl_...
oci连接mysql_利用OCI连接Oracle数据库并查询数据
weixin_39849418的博客
01-28 209
1//OracleCallInterface.cpp:Definestheentrypointfortheconsoleapplication.2//34#include"stdafx.h"5#include"oci.h"6#include7#include8#include910typedefstruct11{12charempno[10];13cha...
oci连接mysql_使用 OCILIB 连接并操作 Oracle 数据库
weixin_28929303的博客
02-02 364
OCILIB是一个跨平台的Oracle驱动程序，可提供非常快速和可靠地访问Oracle数据库。它提供了一个丰富，功能齐全，并易于使用的APIOCILIB是一个跨平台的Oracle驱动程序，，可提供非常快速和可靠地访问Oracle数据库。它提供了一个丰富，功能齐全，并易于使用的API 。OCILIB 支持运行的所有Oracle平台。#include "ocilib.h"int main(int ar...
oci连接mysql_PLSQL Developer 连接远程数据库 OCI客户端安装方法
weixin_39601642的博客
01-21 103
注：本文为原创，作为学习交流使用，转载请标明作者及出处，作者保留追究法律责任的权力。PLSQL Developer 是最常用的Oracle数据库集成开放环境，功能、性能优越的标配Oracle工具。如果本机安装有Oracle数据库，用PLSQL Dev 连接数据库自然没有什么问题，但是如果本机没有安装oracle 客户端，要连接非本地机的oracle DB，那么一种方法就是在本地也安装Oracle，...
pro c 访问 MySQL_Pro*C  OCI  OCCI  及OCI介绍
weixin_39797686的博客
02-28 496
Pro*C OCIOCCI 这三种都是C/C++访问数据库的手段。Pro*C：内嵌SQL,预编译后把内嵌SQL处理为ORACLE标准运行库的调用，然后再象编译一般的C程序一样进行编译、连接、运行。1.proc XXX.pc2.gcc/g++ XXX.c –lclntsh(PRO*C的预编译，也可直接MAKEFILE搞定)OCI/OCCI：oracle提供的访问oracle数据库的API,比较繁...
mysql复杂查询需求总结
qq_33017507的博客
11-03 314
问题一：分组后将两条记录合并、列值变成字段 (case when then else end) as 和group by连用 栗子： id, name, type, value '1', '张三', 'height', '180' '2', '张三', 'weight', '72' '3', '李四', 'height', '175' '4', '李四', 'weight', '62' 想将其变为 name, height, weight '张三', '180', '72' '李四', '175',
一个oci例子
wylsjz的专栏
04-03 962
最小运行环境instantclient-basic-win32-10.1.0.5-20060419.zip中的oci.dll,oraociei10.dllInstant Client Package下载地址：http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/winsoft.html  #i
C++使用ocilib访问oracle的函数
szy的博客
04-22 2476
C++使用ocilib访问oracle的函数
Oracle PROC/C++ 连接本地数据库教程
"这篇文档介绍了如何使用Oracle PROC编程来连接本地数据库，特别是在C/C++环境中。PROC编程允许在过程化编程语言中嵌入SQL语句，以创建高效地访问数据库的应用程序。文中提供了两种不同的方法来存储和使用用户名及...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值