使用mysql连接器将数据从mysql数据库存储到C ++变量中 [英] Store data from a mysql database into a C++ variable using mysql connector

问题描述

所以我从 http://dev.mysql.com/下载了c ++ / mysql连接器downloads / connector / cpp /

现在我想将从数据库检索到的数据存储到变量中。这是我已经得到的。

So I downloaded the c++/mysql connector from http://dev.mysql.com/downloads/connector/cpp/
Now I want to store data that I've retrieved from the database to a variable. This is as far as I've gotten.

string str;
/////////////////////////////////get data from database////////////////////////////////////////////////////////
  sql::Driver *driver;
  sql::Connection *con;
  sql::Statement *stmt;
  sql::ResultSet *res;

  /* Create a connection */
  driver = get_driver_instance();
  con = driver->connect("tcp://127.0.0.1:3306", "root", "");
  /* Connect to the MySQL test database */
  con->setSchema("awesome");

  stmt= con->createStatement();

      res = stmt->executeQuery(

"SELECT * FROM master where choice='Y'");

/////////////////////////////Store it somewhere/////////////////////////////// 
          str= res->getString("rfid");

欢迎任何和所有帮助

推荐答案

下面的代码应该有助于至少更好地理解错误：

While it is not that easy to guess what is happening without rest of the code and database data, following code should help to at least get better understanding on what went wrong:

  try
  {
    while (res->next())
    {
          str= res->getString("rfid");
    }
  }
  catch (std::exception &e)
  {
    std::cerr << e.what();
  }

这篇关于使用mysql连接器将数据从mysql数据库存储到C ++变量中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！