OCI8程序例子

最新推荐文章于 2021-03-09 19:31:39 发布

aaajj

最新推荐文章于 2021-03-09 19:31:39 发布

阅读量1.8k

点赞数

分类专栏： oracle数据库 C/C++ Linux/Unix 文章标签： null sql query string delete server

本文链接：https://blog.csdn.net/aaajj/article/details/5972750

版权

C/C++ 同时被 3 个专栏收录

74 篇文章 1 订阅

订阅专栏

Linux/Unix

39 篇文章 1 订阅

订阅专栏

oracle数据库

23 篇文章 0 订阅

订阅专栏

初步封装

// Connection.cpp: implementation of the CConnection class. // // #include "Connection.h" // // Construction/Destruction // CConnection::CConnection() { } CConnection::~CConnection() { } //ServerAddr ip //vsp dbname at the server machine int CConnection::connect(char *ServerAddr,char *vsp,char *user,char *passwd) { char connect_str[1024] = {0}; int i = 0; try { sprintf(connect_str, "(DESCRIPTION= (ADDRESS= (PROTOCOL= TCP)(HOST= %s)(PORT= 1521))(CONNECT_DATA= (SERVICE_NAME= %s)))",ServerAddr,vsp); i = connect(connect_str, user, passwd); } catch(...) { printf("catch a error!/n"); } return i; } int CConnection::connect(char *Server, char *user,char *passwd) { // char connect_str[1024] = {0}; sword status; try { OCIEnvCreate(&myenvhp, OCI_DEFAULT|OCI_THREADED, (dvoid *)0, 0, 0, 0, (size_t)0, (dvoid **)0); OCIInitialize(OCI_THREADED|OCI_OBJECT, NULL, NULL, NULL, NULL); OCIEnvInit(&myenvhp, OCI_DEFAULT, 0, NULL); OCIHandleAlloc((dvoid*)myenvhp, (dvoid**)&myerrhp, OCI_HTYPE_ERROR, (size_t)0, (dvoid**) 0); OCIHandleAlloc((dvoid *)myenvhp, (dvoid**)&mystmthp, OCI_HTYPE_STMT, (size_t)0, (dvoid**)0); // sprintf(connect_str, "(DESCRIPTION= (ADDRESS= (PROTOCOL= TCP)(HOST= %s)(PORT= 1521))(CONNECT_DATA= (SERVICE_NAME= %s)))",ServerAddr,vsp); OCIHandleAlloc((dvoid*)myenvhp, (dvoid**)&mysrvhp, OCI_HTYPE_SERVER, (size_t)0, (dvoid**) 0); OCIHandleAlloc((dvoid*)myenvhp, (dvoid**)&mysvchp, OCI_HTYPE_SVCCTX, (size_t)0, (dvoid**) 0); status = OCIServerAttach(mysrvhp, myerrhp, (text*)Server, strlen(Server), OCI_DEFAULT); if (status != OCI_SUCCESS) { sb4 errcodep; char errbuf[1024] = {0}; OCIErrorGet(myerrhp, (ub4)1, NULL, &errcodep, (text*)errbuf, (ub4)sizeof(errbuf), (ub4)OCI_HTYPE_ERROR); printf("OCIServerAttach error[%s]!/n",errbuf); OCIHandleFree(mysrvhp, OCI_HTYPE_SERVER); return -2; } OCIAttrSet((dvoid*)mysvchp, OCI_HTYPE_SVCCTX, (dvoid*)mysrvhp, (ub4)0, OCI_ATTR_SERVER, myerrhp); OCIHandleAlloc((dvoid*)myenvhp, (dvoid**)&myusrhp, OCI_HTYPE_SESSION, (size_t)0, (dvoid**) 0); OCIAttrSet((dvoid*)myusrhp, OCI_HTYPE_SESSION, (dvoid*)user, (ub4)strlen(user), OCI_ATTR_USERNAME, myerrhp); OCIAttrSet((dvoid*)myusrhp, OCI_HTYPE_SESSION, (dvoid*)passwd, (ub4)strlen(passwd), OCI_ATTR_PASSWORD, myerrhp); status = OCISessionBegin(mysvchp, myerrhp, myusrhp, OCI_CRED_RDBMS, OCI_DEFAULT); if (status != OCI_SUCCESS) { sb4 errcodep; char errbuf[1024] = {0}; OCIErrorGet(myerrhp, (ub4)1, NULL, &errcodep, (text*)errbuf, (ub4)sizeof(errbuf), (ub4)OCI_HTYPE_ERROR); printf("OCISessionBegin error[%s]!/n",errbuf); printf("OCISessionBegin failed!/n"); OCIServerDetach(mysrvhp, myerrhp, OCI_DEFAULT); OCIHandleFree(myusrhp, OCI_HTYPE_SESSION); OCIHandleFree(mysvchp, OCI_HTYPE_SVCCTX); OCIHandleFree(mysrvhp, OCI_HTYPE_SERVER); return -1; } OCIAttrSet((dvoid*)mysvchp, OCI_HTYPE_SVCCTX, (dvoid*)myusrhp, (ub4)0, OCI_ATTR_SESSION, myerrhp); OCIHandleAlloc((dvoid *)myenvhp, (dvoid**)&mytxnhp, OCI_HTYPE_TRANS, (size_t)0, (dvoid**)0); OCIAttrSet((dvoid*)mysvchp, OCI_HTYPE_SVCCTX, (dvoid*)mytxnhp, (ub4)0, OCI_ATTR_TRANS, myerrhp); } catch(...) { printf("catch a error!/n"); } return 1; } int CConnection::rollback() { sword status = 0; status = OCITransRollback(mysvchp, myerrhp, OCI_DEFAULT); if (status != OCI_SUCCESS) { printf("OCITransCommit error !/n"); return -3; } return 1; } int CConnection::commit() { sword status = 0; status = OCITransCommit(mysvchp, myerrhp, OCI_DEFAULT); if (status != OCI_SUCCESS) { printf("OCITransCommit error !/n"); return -3; } return 1; } int CConnection::execute(char *query) { sword status; ub2 stType; // ub4 parmub4; if (stord_sql_stmt) { // free(stord_sql_stmt); delete stord_sql_stmt; stord_sql_stmt = NULL; } // stord_sql_stmt = (char*)malloc(strlen(query)+16); stord_sql_stmt = new char[strlen(query)+16]; memset(stord_sql_stmt, 0, strlen(query)+16); strcpy(stord_sql_stmt, query); try { status = OCIStmtPrepare(mystmthp, myerrhp, (text*)stord_sql_stmt, (ub4)strlen(stord_sql_stmt), OCI_NTV_SYNTAX, OCI_DEFAULT); if (status != OCI_SUCCESS) { // free(stord_sql_stmt); delete stord_sql_stmt; stord_sql_stmt = NULL; printf("DBCON_QUERY_ERROR failed/n"); return -1; } OCIAttrGet((dvoid*)mystmthp, OCI_HTYPE_STMT, (dvoid*)&stType, (size_t *)0, OCI_ATTR_STMT_TYPE, myerrhp); status = OCIStmtExecute(mysvchp, mystmthp, myerrhp, 1, 0, NULL, NULL, OCI_DEFAULT); // if status < 0, error if (status != OCI_SUCCESS) { // free(stord_sql_stmt); delete stord_sql_stmt; stord_sql_stmt = NULL; printf("OCIStmtExecute no select !/n"); // return -2; } } catch(...) { printf("An exception was thrown./n"); } // free(stord_sql_stmt); delete stord_sql_stmt; stord_sql_stmt = NULL; return 1; } int CConnection::disconnect() { sword status; try { status = OCISessionEnd(mysvchp, myerrhp, myusrhp, OCI_DEFAULT); if (status != OCI_SUCCESS) { printf("DBCON_ERROR_DISCONNECTING failed!/n"); } OCIServerDetach(mysrvhp, myerrhp, OCI_DEFAULT); OCIHandleFree(mytxnhp, OCI_HTYPE_TRANS); OCIHandleFree(myusrhp, OCI_HTYPE_SESSION); OCIHandleFree(mysrvhp, OCI_HTYPE_SERVER); OCIHandleFree(mysvchp, OCI_HTYPE_SVCCTX); OCIHandleFree(myerrhp, OCI_HTYPE_ERROR); OCIHandleFree(myenvhp, OCI_HTYPE_ENV); myerrhp = NULL; myenvhp = NULL; mytxnhp = NULL; mysrvhp = NULL; myusrhp = NULL; mysvchp = NULL; } catch(...) { printf("DBCON_ERROR_DISCONNECTING failed/n"); } return 0; }

/// // Connection.h: interface for the CConnection class. // // #if !defined(AFX_CONNECTION_H__4381555C_32AD_4F54_9240_9FD5A00EA2AB__INCLUDED_) #define AFX_CONNECTION_H__4381555C_32AD_4F54_9240_9FD5A00EA2AB__INCLUDED_ #if _MSC_VER > 1000 #pragma once #endif // _MSC_VER > 1000 #include <stdio.h> #include <string.h> #include <ctype.h> #include <oci.h> enum DBFieldType { FT_NULL, FT_BIT, FT_CHAR, FT_STRING, FT_WSTRING, //Wide String for unicode. FT_BLOB, FT_TIMESTAMP, FT_DATE, FT_TIME, FT_DATETIME, FT_FLOAT, FT_DOUBLE, FT_INTEGER, FT_SMALLINT, FT_WORD, FT_BOOLEAN }; class CConnection { public: CConnection(); virtual ~CConnection(); int connect(char *ServerAddr,char *vsp,char *user,char *passwd); int disconnect(); int initial(); int execute(char *query); int getFieldsInfo(char *para); int Rtrim(char *para); int ConvertFeild(char *src,int srctype,char *dst,int length); // int disconnect(); int getFields(char *para); int connect(char *Server, char *user,char *passwd); int commit(); int rollback(); public: OCIEnv *myenvhp; /* the environment handle */ OCIError *myerrhp; /* the error handle */ OCIServer *mysrvhp; /* the server handle */ OCISession *myusrhp; /* user session handle */ OCISvcCtx *mysvchp; /* the service handle */ OCIStmt *mystmthp; /* the statment handle */ OCITrans *mytxnhp; /* the transaction handle */ char *stord_sql_stmt; int fieldCount; //列数 int iRecord; char ValueList[1000][512]; private: char errMsg[1024]; }; #endif // !defined(AFX_CONNECTION_H__4381555C_32AD_4F54_9240_9FD5A00EA2AB__INCLUDED_)

// // Record.cpp: implementation of the Record class. // // #include "Record.h" // // Construction/Destruction // Record::Record() { pConn = NULL; for (int i = 0; i < 256; i++) { fieldValue[ i ] = NULL; } } Record::~Record() { for (int i = 0; i < 256; i++) { if (fieldValue[ i ] != NULL) { delete fieldValue[ i ]; } } } int Record:: SetConn(CConnection* conn) { pConn = conn; return 1; } void Record:: SetBatSize(int size) { batsize = size; } int Record::Next() { sword status = 0; for (int i = 0; i < fieldCount; i++) { memset(fieldValue[ i ], 0, col_len[ i ]); } status = OCIStmtFetch(pConn->mystmthp, pConn->myerrhp, 1, OCI_FETCH_NEXT, OCI_DEFAULT); if (status == OCI_NO_DATA) { return -1; printf("no find data!/n"); } return 1; } double Record::GetFieldDouble(int i) { return *(double*)fieldValue[ i ]; } char* Record::GetFieldString(int i) { return fieldValue[ i ]; } int Record::Bind() { int i = 0; int status = 0; OCIParam *mypard = NULL; ub2 dtype; // ub2 col_len ; // char *fieldValue[200]; ub2 fieldType[200] = {0}; int fieldlen[200] = {0}; OCIDefine *dfnhp[200]; ub2 external_type; text acNode[513] = {0}; char fname[100] = {0}; char* szName; ub4 sizep = 100; //fun("mv ") for (i = 0; i < fieldCount; i++) { OCIParamGet((dvoid*)pConn->mystmthp, OCI_HTYPE_STMT, pConn->myerrhp, (dvoid**)&mypard, (ub4)i+1); // OCIAttrGet((dvoid*)mypard, OCI_DTYPE_PARAM, (dvoid**)&colname, &colname_len, OCI_ATTR_NAME, myerrhp); // strncpy(fieldName[ i ], (char*)colname, colname_len); OCIAttrGet((dvoid*)mypard, OCI_DTYPE_PARAM, (dvoid**)&dtype, 0, OCI_ATTR_DATA_TYPE, pConn->myerrhp); //get the field length OCIAttrGet((dvoid*)mypard, OCI_DTYPE_PARAM, (dvoid*)&col_len[ i ], 0, OCI_ATTR_DATA_SIZE, pConn->myerrhp); col_len[ i ] += 2; // get the field name //cout the field name 2010-10-12 but it cannot work well //This is so suck that using char arrary is wrong // OCIAttrGet((dvoid*)mypard, OCI_DTYPE_PARAM, (text**)&fname, &sizep, OCI_ATTR_NAME, pConn->myerrhp); // use the char pointer szName can work well, why ? 2010-10-28 OCIAttrGet((dvoid*)mypard, OCI_DTYPE_PARAM, (text **)&szName, &sizep, OCI_ATTR_NAME, pConn->myerrhp); strncpy(fname, szName, sizep); printf("field name is %s/n --%d/n", (const char*)fname, sizep); fieldValue[ i ] = new char[sizeof(char)*col_len[ i ]]; memset(fieldValue[ i ],0x00,sizeof(char)*col_len[ i ]); fieldlen[ i ] = col_len[ i ]; switch (dtype) { case 1: //VARCHAR2, NVARCHAR2 fieldType[ i ] = FT_STRING; external_type = SQLT_CHR; break; case SQLT_NUM: //NUMBER case SQLT_FLT: case SQLT_PDN: fieldType[ i ] = FT_INTEGER; external_type = SQLT_FLT; break; case 11: //ROWID fieldType[ i ] = FT_STRING; external_type = SQLT_STR; break; case 12: //DATE fieldType[ i ] = FT_DATE; external_type = SQLT_ODT; break; case 96: //CHAR, NCHAR fieldType[ i ] = FT_STRING; external_type = SQLT_STR; break; default: continue; } if (external_type == SQLT_FLT) { status = OCIDefineByPos(pConn->mystmthp, &dfnhp[ i ], pConn->myerrhp, i+1, (dvoid*)fieldValue[ i ], (sb4)sizeof(double), external_type, 0, 0, 0, OCI_DEFAULT); } else { status = OCIDefineByPos(pConn->mystmthp, &dfnhp[ i ], pConn->myerrhp, i+1, (dvoid*)fieldValue[ i ], (sb4)col_len[ i ], external_type, 0, 0, 0, OCI_DEFAULT); } if (status != OCI_SUCCESS) { printf("select error!/n"); return -1; } } return 1; } int Record:: Query(char* sql) { sword status; ub2 stType; ub4 parmub4; int i = 0; try { status = OCIStmtPrepare(pConn->mystmthp, pConn->myerrhp, (text*)sql, (ub4)strlen(sql), OCI_NTV_SYNTAX, OCI_DEFAULT); if (status != OCI_SUCCESS) { printf("DBCON_QUERY_ERROR failed/n"); return -1; } OCIAttrGet((dvoid*)pConn->mystmthp, OCI_HTYPE_STMT, (dvoid*)&stType, (size_t *)0, OCI_ATTR_STMT_TYPE, pConn->myerrhp); if (stType == OCI_STMT_SELECT) { //设置一次执行取数据的行数 OCIAttrSet(pConn->mystmthp,OCI_HTYPE_STMT,(void *)&batsize,sizeof(ub4), OCI_ATTR_PREFETCH_ROWS, pConn->myerrhp); status = OCIStmtExecute(pConn->mysvchp, pConn->mystmthp, pConn->myerrhp, 0, 0, NULL, NULL, OCI_DEFAULT); if (status != OCI_SUCCESS) { printf("DBCON_QUERY_ERROR failed!/n"); return -1; } //get the number of the fields be selected OCIAttrGet((dvoid*)pConn->mystmthp, OCI_HTYPE_STMT, (dvoid*)&parmub4, (size_t *)0, OCI_ATTR_PARAM_COUNT, pConn->myerrhp); fieldCount = parmub4; i = Bind(); if (i < 0) { return -1; } i = Next(); if (i < 0) { return -1; } } } catch(...) { printf("An exception was thrown./n"); } return 1; }

上面的程序有些问题，打印字符串数据的时候有乱码

作了些修改，还添加了点处理clob和long类型数据的功能

// Record.cpp: implementation of the Record class. // // #include "Record.h" // // Construction/Destruction // Record::Record() { pConn = NULL; for (int i = 0; i < 256; i++) { fieldValue[ i ] = NULL; } //ub2* rlenp; defined in the .h file rlenp = NULL; } Record::~Record() { for (int i = 0; i < 256; i++) { if (fieldValue[ i ] != NULL) { delete fieldValue[ i ]; } } if (rlenp != NULL) { delete [] rlenp; } } int Record:: SetConn(CConnection* conn) { pConn = conn; return 1; } void Record:: SetBatSize(int size) { batsize = size; } int Record::Next() { sword status = 0; for (int i = 0; i < fieldCount; i++) { memset(fieldValue[ i ], 0, col_len[ i ]); } status = OCIStmtFetch(pConn->mystmthp, pConn->myerrhp, 1, OCI_FETCH_NEXT, OCI_DEFAULT); if (status == OCI_NO_DATA) { return -1; printf("no find data!/n"); } return 1; } double Record::GetFieldDouble(int i) { return *(double*)fieldValue[ i ]; } char* Record::GetFieldString(int i) { return fieldValue[ i ]; } int Record::Bind() { int i = 0; int status = 0; OCIParam *mypard = NULL; ub2 dtype; // ub2 col_len ; // char *fieldValue[200]; ub2 fieldType[200] = {0}; int fieldlen[200] = {0}; OCIDefine *dfnhp[200]; ub2 external_type; text acNode[513] = {0}; char fname[100] = {0}; char* szName; ub4 sizep = 100; //fun("mv ") for (i = 0; i < fieldCount; i++) { OCIParamGet((dvoid*)pConn->mystmthp, OCI_HTYPE_STMT, pConn->myerrhp, (dvoid**)&mypard, (ub4)i+1); // OCIAttrGet((dvoid*)mypard, OCI_DTYPE_PARAM, (dvoid**)&colname, &colname_len, OCI_ATTR_NAME, myerrhp); // strncpy(fieldName[ i ], (char*)colname, colname_len); OCIAttrGet((dvoid*)mypard, OCI_DTYPE_PARAM, (dvoid**)&dtype, 0, OCI_ATTR_DATA_TYPE, pConn->myerrhp); //get the field length // if the field is clob type, the lenth is 4000 default OCIAttrGet((dvoid*)mypard, OCI_DTYPE_PARAM, (dvoid*)&col_len[ i ], 0, OCI_ATTR_DATA_SIZE, pConn->myerrhp); col_len[ i ] += 2; // get the field name //cout the field name 2010-10-12 but it cannot work well //This is so suck that using char array is wrong // OCIAttrGet((dvoid*)mypard, OCI_DTYPE_PARAM, (text**)&fname, &sizep, OCI_ATTR_NAME, pConn->myerrhp); // use the char pointer szName can work well, why ? 2010-10-28 OCIAttrGet((dvoid*)mypard, OCI_DTYPE_PARAM, (text **)&szName, &sizep, OCI_ATTR_NAME, pConn->myerrhp); strncpy(fname, szName, sizep); printf("field name is %s/n --%d/n", (const char*)fname, sizep); fieldValue[ i ] = new char[sizeof(char)*col_len[ i ]]; memset(fieldValue[ i ],0x00,sizeof(char)*col_len[ i ]); fieldlen[ i ] = col_len[ i ]; switch (dtype) { case 1: //VARCHAR2, NVARCHAR2 fieldType[ i ] = FT_STRING; external_type = SQLT_CHR; break; case SQLT_NUM: //NUMBER case SQLT_FLT: case SQLT_PDN: fieldType[ i ] = FT_INTEGER; external_type = SQLT_FLT; break; case 11: //ROWID fieldType[ i ] = FT_STRING; external_type = SQLT_STR; break; case 12: //DATE fieldType[ i ] = FT_DATE; external_type = SQLT_ODT; break; case 96: //CHAR, NCHAR fieldType[ i ] = FT_STRING; external_type = SQLT_STR; break; // 接收clob类型的数据，直接这样使用有个限制，程度不能超过4000 //2010-11-11 case SQLT_CLOB://112 fieldType[ i ] = FT_STRING; external_type = SQLT_STR; break; case SQLT_LNG://8 long type delete [] fieldValue[ i ]; col_len[ i ] = 8 * 1024;// this is the length you want fieldValue[ i ] = new char[sizeof(char)*col_len[ i ]]; memset(fieldValue[ i ],0x00,sizeof(char)*col_len[ i ]); fieldlen[ i ] = col_len[ i ]; fieldType[ i ] = FT_STRING; external_type = SQLT_STR; break; default: fieldType[ i ] = FT_STRING; external_type = SQLT_STR; // continue; break; } if (external_type == SQLT_FLT) { status = OCIDefineByPos(pConn->mystmthp, &dfnhp[ i ], pConn->myerrhp, i+1, (dvoid*)fieldValue[ i ], (sb4)sizeof(double), external_type, 0, 0, 0, OCI_DEFAULT); } else { status = OCIDefineByPos(pConn->mystmthp, &dfnhp[ i ], pConn->myerrhp, i+1, (dvoid*)fieldValue[ i ], (sb4)col_len[ i ], external_type, 0, &rlenp[i], 0, OCI_DEFAULT); } if (status != OCI_SUCCESS) { printf("select error!/n"); return -1; } } return 1; } int Record:: Query(char* sql) { sword status; ub2 stType; ub4 parmub4; int i = 0; try { status = OCIStmtPrepare(pConn->mystmthp, pConn->myerrhp, (text*)sql, (ub4)strlen(sql), OCI_NTV_SYNTAX, OCI_DEFAULT); if (status != OCI_SUCCESS) { printf("DBCON_QUERY_ERROR failed/n"); return -1; } OCIAttrGet((dvoid*)pConn->mystmthp, OCI_HTYPE_STMT, (dvoid*)&stType, (size_t *)0, OCI_ATTR_STMT_TYPE, pConn->myerrhp); if (stType == OCI_STMT_SELECT) { //设置一次执行取数据的行数 OCIAttrSet(pConn->mystmthp,OCI_HTYPE_STMT,(void *)&batsize,sizeof(ub4), OCI_ATTR_PREFETCH_ROWS, pConn->myerrhp); status = OCIStmtExecute(pConn->mysvchp, pConn->mystmthp, pConn->myerrhp, 0, 0, NULL, NULL, OCI_DEFAULT); if (status != OCI_SUCCESS) { printf("DBCON_QUERY_ERROR failed!/n"); return -1; } //get the number of the fields be selected OCIAttrGet((dvoid*)pConn->mystmthp, OCI_HTYPE_STMT, (dvoid*)&parmub4, (size_t *)0, OCI_ATTR_PARAM_COUNT, pConn->myerrhp); fieldCount = parmub4; rlenp = new ub2[fieldCount]; i = Bind(); if (i < 0) { return -1; } i = Next(); if (i < 0) { return -1; } } } catch(...) { printf("An exception was thrown./n"); } return 1; }

// Record.h: interface for the Record class. // // #if !defined(AFX_RECORD_H__8BC577D4_040D_4A79_8702_C8C8002036F5__INCLUDED_) #define AFX_RECORD_H__8BC577D4_040D_4A79_8702_C8C8002036F5__INCLUDED_ #if _MSC_VER > 1000 #pragma once #endif // _MSC_VER > 1000 #include "Connection.h" class Record { public: Record(); virtual ~Record(); int SetConn(CConnection* conn); void SetBatSize(int size); int Query(char* sql); int Next(); int Bind(); double GetFieldDouble(int i); char* GetFieldString(int i); CConnection* pConn; int batsize; private: int fieldCount; char *fieldValue[256]; ub2 col_len[256]; ub2* rlenp; }; #endif // !defined(AFX_RECORD_H__8BC577D4_040D_4A79_8702_C8C8002036F5__INCLUDED_)

调用

进行批量插入的一个例子,没有封装，演示出了怎么使用 2010-11-1

#include "Connection.h" #include <iostream.h> #include <stdlib.h> #include "Record.h" #if defined(WIN32) #pragma comment(lib,"oci.lib") #endif int main() { CConnection conn; conn.connect("102_db", "test", "test"); // conn.execute("select * from test9"); Record rec; int i = 0; rec.SetBatSize(100); rec.SetConn(&conn); // i = rec.Query("select * from t2 where rownum < 5"); i = rec.Query("select * from FCT_VIP_USER where rownum < 5"); if (i < 0) { return -1; } while (i > 0 ) { // cout << rec.GetFieldDouble(0) << " " << rec.GetFieldString(1) << endl; cout << rec.GetFieldString(0) << " " << rec.GetFieldString(1) << endl; i = rec.Next(); } // 测试绑定数据插入，每次插入1条数据 int id[3]={3,2,5}; char name[88] = "test"; sb2 nu[3] = {0,0,-1}; sb2* pp= nu; OCIBind *bnd1p = (OCIBind *) 0; /* the first bind handle */ OCIBind *bnd2p = (OCIBind *) 0; /* the second bind handle */ char * ins = "insert into student (id, name) values (:ID, :NAME)"; OCIStmtPrepare(conn.mystmthp, conn.myerrhp, (const unsigned char * )ins, (ub4) strlen((char *) ins), (ub4) OCI_NTV_SYNTAX, (ub4) OCI_DEFAULT); // OCIBindByName(conn.mystmthp, &bnd1p, conn.myerrhp, (text *) ":id", // -1, (dvoid *) &id, // (sword) sizeof(int), SQLT_INT, (dvoid *) 0, // (ub2 *) 0, (ub2 *) 0, (ub4) 0, (ub4 *) 0, OCI_DEFAULT); // // OCIBindByName(conn.mystmthp, &bnd2p, conn.myerrhp, (text *) ":NAME", // -1, (dvoid *) name, // 32, SQLT_STR, (dvoid *) 0, // (ub2 *) 0, (ub2 *) 0, (ub4) 0, (ub4 *) 0, OCI_DEFAULT); // OCIBindByName(conn.mystmthp, &bnd1p, conn.myerrhp, (text *) ":id", -1, (dvoid *) id, (sword) sizeof(int) , SQLT_INT, (dvoid *) pp,//pp if the value is -1, the column value is NULL，we can use //this parameter to set a column NULL . (ub2 *) 0, (ub2 *) 0, (ub4) 3, (ub4 *) 0, OCI_DEFAULT); OCIBindByName(conn.mystmthp, &bnd2p, conn.myerrhp, (text *) ":NAME", -1, (dvoid *) name, 32 , SQLT_STR, (dvoid *) pp, (ub2 *) 0, (ub2 *) 0, (ub4) 3, (ub4 *) 0, OCI_DEFAULT); id[0]=1;id[1]=2; //这里一次可以插入2行数据 OCIStmtExecute(conn.mysvchp, conn.mystmthp, conn.myerrhp, 2, 0, NULL, NULL, OCI_DEFAULT); //在批量执行的时候，为了保证可以插入 kx + c 行记录，可以循环调用OCIStmtExecute，给第4个参数传入这次实际要导入的行数 // for (i = 0; i < 10000; i++) // { // id = i; // OCIStmtExecute(conn.mysvchp, conn.mystmthp, conn.myerrhp, 1, 0, NULL, NULL, OCI_DEFAULT); // // } // conn.execute(); conn.commit(); conn.disconnect(); return 0; }