ACI操作简单的代码

#include <iostream>
#include <oscar/aci.h>
#include <string.h>
#include <vector>
ACIEnv *m_penv = NULL;
ACIError *m_perr = NULL;
ACIServer *m_psrv = NULL;
ACISvcCtx *m_psvc = NULL;
ACISession *m_pses = NULL;
ACIStmt *m_pstmt = NULL;
ACIBind *m_pbnd = NULL;
ACIDefine *m_pdef = NULL;
int main()
{
    sword r = ACI_SUCCESS;
    ub1 errbuf[64] = {0};   // 获取错误信息的缓冲区
    ub1 sqlstate[64] = {0}; // ACIErroGet() 的第三个参数变量
    sb4 ercodep = 0;
    ub2 *rlp = NULL, rcodep = NULL;
    char dsql[] = "drop table tt";

    char createSql[] = "create table tt(Profession text)"; // 创建表
    char insql[] = "insert into tt values(:1)";            // 插入数据
    char ssql[] = "select * from tt";                      // 查询数据
    char *m_dblink = (char *)"127.0.0.1:2003/OSRDB";
    char *m_dbuser = (char *)"SYSDBA";
    char *m_dbpwd = (char *)"szoscar55";
    // 初始化环境句柄
    r = ACIInitialize(ACI_DEFAULT, NULL, NULL, NULL, NULL);
    r = ACIEnvInit(&m_penv, ACI_DEFAULT, 0, 0);
    // 分配并初始化各类句柄
    ACIHandleAlloc(m_penv, (void **)&m_perr, ACI_HTYPE_ERROR, 0, 0);
    ACIHandleAlloc(m_penv, (void **)&m_psrv, ACI_HTYPE_SERVER, 0, 0);
    ACIHandleAlloc(m_penv, (void **)&m_psvc, ACI_HTYPE_SVCCTX, 0, 0);
    ACIHandleAlloc(m_penv, (void **)&m_pses, ACI_HTYPE_SESSION, 0, 0);
    ACIHandleAlloc(m_penv, (void **)&m_pstmt, ACI_HTYPE_STMT, 0, 0);
    // 连接数据库
    r = ACILogon(m_penv, m_perr, &m_psvc, (const OraText *)m_dbuser, strlen(m_dbuser),
                 (const OraText *)m_dbpwd, strlen(m_dbpwd), (const OraText *)m_dblink, strlen(m_dblink));
    //    r = ACIStmtPrepare(m_pstmt, m_perr, (OraText *)dsql, strlen(dsql), ACI_HTYPE_ERROR, ACI_DEFAULT);
    r = ACIStmtExecute(m_psvc, m_pstmt, m_perr, 1, 0, 0, 0, ACI_DEFAULT);
    // 创建数据库
    r = ACIStmtPrepare(m_pstmt, m_perr, (OraText *)createSql, strlen(createSql), ACI_HTYPE_ERROR, ACI_DEFAULT);
    r = ACIStmtExecute(m_psvc, m_pstmt, m_perr, 1, 0, 0, 0, ACI_DEFAULT);
    // 插入数据


    r = ACIStmtPrepare(m_pstmt, m_perr, (OraText *)insql, strlen(insql), ACI_NTV_SYNTAX, ACI_DEFAULT);
    std::vector<std::string> data = {"小品演员", "歌手", "相声演员", "演员、歌手", "演员、歌手"};

//    std::vector<const char*> dataPtrs;
//    for (const std::string& str : data) {
//        dataPtrs.push_back(str.c_str());
//    }
    ACIBind* bindp; // 创建新的绑定对象
    for (size_t i = 0; i < data.size(); i++) {

        r = ACIBindByPos(m_pstmt, &bindp, m_perr, 1, (void*)data[i].c_str(), data[i].length() + 1, SQLT_STR, nullptr, nullptr, nullptr, 0, nullptr, ACI_DEFAULT);
        if (r != ACI_SUCCESS) {
            // 处理绑定错误
            std::cerr << "Error binding data: " << r << std::endl;
            // 释放资源
        }
        // 绑定数组的结构
        r = ACIBindArrayOfStruct(bindp, m_perr, data[i].length() + 1, sizeof(char), sizeof(ub2), 0);
        if (r != ACI_SUCCESS) {
            // 处理绑定错误
            std::cerr << "Error binding array of struct: " << r << std::endl;
            // 释放资源
//            ACIHandleFree(bindp, ACI_HTYPE_BIND);
//            ACIHandleFree(m_pstmt, ACI_HTYPE_STMT);
            // 可能需要进行其他错误处理操作
//             return 0;
        }
        // 执行语句
        r = ACIStmtExecute(m_psvc, m_pstmt, m_perr, 1 , 0, nullptr, nullptr, ACI_DEFAULT);

        if (r != ACI_SUCCESS) {
            // 处理执行错误
            std::cerr << "Error executing statement: " << r << std::endl;
            // 释放资源
//            ACIHandleFree(bindp, ACI_HTYPE_BIND);
//            ACIHandleFree(m_pstmt, ACI_HTYPE_STMT);
            // 可能需要进行其他错误处理操作
//             return 0;
        }
        // 释放资源
        ACIHandleFree(bindp, ACI_HTYPE_BIND);
    }

    r = ACITransCommit(m_psvc, m_perr, ACI_DEFAULT);
    if (r != ACI_SUCCESS) {
        // 处理提交错误
        std::cerr << "Error committing transaction: " << r << std::endl;
        // 可能需要进行其他错误处理操作
    }

    return 0;
}

神通数据库对string类型的数据写入，具体使用ACIStmtExecute，ACIBindByPos函数可以参考文档
具体使用场景，使用ACI操作神通数据库，c++代码