使用正则表达式来分割sql语句！
int CSQLMake::SplitSql(std::string &strSql, std::vector<std::string> &vctSql){ int iRet = 0; boost::regex regEx("\\(select[\\w\\s='<>!#,.@]*\\)"); std::string::const_iterator start, end; boost::match_results<std::string::const_iterator> what; boost::match_flag_type flags = boost::match_default; int iCount = -1; while (boost::regex_search(strSql, what, regEx, flags)) { std::string strTemp(what[0].first, what[0].second); vctSql.push_back(strTemp); iCount ++; std::string strFlag = "@@" + toString(iCount); std::string::size_type stPos = strSql.find(what[0]); std::string strLeft = strSql.substr(0, stPos); std::string strRight = strSql.substr(stPos + (what[0].second - what[0].first)); strSql = strLeft + strFlag + strRight; flags |= boost::match_prev_avail; flags |= boost::match_not_bob; } vctSql.push_back(strSql); return iRet;}