c++ - 在 C++ 和 Mysql 中，从 std::sqlString 到 char const* 的转换无效

Question

con->setSchema(DATABASE);
// Query section
stmt = con->createStatement();
res = stmt->executeQuery("SELECT * FROM  `submission` WHERE  'status' = 0");
while (res->next()) {
 // Access column data by alias or column name 
 string insert = res->getString('pid');
 const char* p = insert.c_str();

  pipe = fopen(p, 'w');

  fprintf(pipe,"Successfully created");
}

如何将 res->getString('pid') 值转换为 fopen() 作为文件名。我得到错误，因为它要求 char const*

Answer 1

con->setSchema(DATABASE);
// Query section
stmt = con->createStatement();
res = stmt->executeQuery("SELECT * FROM  `submission` WHERE  'status' = 0");
while (res->next()) {
// Access column data by alias or column name 

string insert = res->getString('pid'); //changed 'pid' to "pid"

const char* p = insert.c_str();

FILE *pipe = fopen(p, 'w'); // Declared pipe as FILE

fprintf(pipe,"Successfully created");
}