将多个sql语句给合并成一个sql

最新推荐文章于 2024-08-28 22:30:00 发布

hunker

最新推荐文章于 2024-08-28 22:30:00 发布

阅读量918

点赞数

分类专栏： C++ 文章标签：数据库 c/c++

本文链接：https://blog.csdn.net/hunker/article/details/84117750

版权

C++ 专栏收录该内容

10 篇文章 0 订阅

订阅专栏

int CSQLMake::MergeSql(std::string &strSql, std::vector<std::string> &vctSql)
{

    int iRet = 0;
    boost::regex regEx("@@([\\d]+)");
    boost::match_flag_type flags = boost::match_default;
    std::vector<std::string>::iterator itr;
    std::string strTemp;
    std::string::const_iterator start, end;

    int iCount = 0;
    for (itr=vctSql.begin(); itr!=vctSql.end(); itr++)
    {
        boost::match_results<std::string::const_iterator> what;
        strTemp = *itr;

        while (boost::regex_search(strTemp, what, regEx, flags))
        {
            std::string str(what[1].first, what[1].second);
            int iIndex = ACE_OS::atoi(str.c_str());

            std::string::size_type stPos = strTemp.find(what[0]);
            std::string strLeft = strTemp.substr(0, stPos);
            std::string strRight = strTemp.substr(stPos + (what[0].second - what[0].first));
            strTemp = strLeft + vctSql[iIndex] + strRight;
        }
        vctSql[iCount] = strTemp;
        iCount ++;
    }
    strSql = strTemp;
    return iRet;
}