fork download
  1. #include <iostream>
  2. #include <sstream>
  3. using namespace std;
  4.  
  5. int main() {
  6. std::wstring email = L"test@gmail.com";
  7. std::wstring strategy = L"TestStrategy1";
  8. std::wstring CP = L"C";
  9. std::wstring watchListDate = L"2023-04-08";
  10.  
  11. std::wstring watchListString = L"test1-930,test2-1045,test3-1500";
  12. std::wstring create_date = L"2023-05-10";
  13.  
  14. std::wstringstream result1(L"Insert into watchList(emailID,strategy,CP,watchList_Date,watchList,create_date) values(");
  15. result1 << "'" << email << "\',\'" << strategy << "\',\'" << CP << "\',\'" << watchListDate << "\',\'" << watchListString << "\',\'" << create_date << "\')";
  16. std::wstring sqlString = result1.str();
  17.  
  18. std::wcout << sqlString << std::endl;
  19.  
  20. return 0;
  21. }
Success #stdin #stdout 0.01s 5432KB
stdin
Standard input is empty
stdout
'test@gmail.com','TestStrategy1','C','2023-04-08','test1-930,test2-1045,test3-1500','2023-05-10')