c web mysql数据库,如何使用C ++连接mySQL数据库

I'm trying to connect the database from my website and display some rows using C++.

So bascily I'm trying to make an application that does a select query from a table from my site database. Now, this must be possible because I've seen tons of applications doing it.

How do I do this? Can some one make an example and tell me what libraries I should be using?

解决方案

Clearly, you've not been looking in the right corners of the Internet, because I found an example in a few seconds:

/* Standard C++ includes */

#include

#include

/*

Include directly the different

headers from cppconn/ and mysql_driver.h + mysql_util.h

(and mysql_connection.h). This will reduce your build time!

*/

#include "mysql_connection.h"

#include

#include

#include

#include

using namespace std;

int main(void)

{

cout << endl;

cout << "Running 'SELECT 'Hello World!' »

AS _message'..." << endl;

try {

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", "root");

/* Connect to the MySQL test database */

con->setSchema("test");

stmt = con->createStatement();

res = stmt->executeQuery("SELECT 'Hello World!' AS _message"); // replace with your statement

while (res->next()) {

cout << "\t... MySQL replies: ";

/* Access column data by alias or column name */

cout << res->getString("_message") << endl;

cout << "\t... MySQL says it again: ";

/* Access column fata by numeric offset, 1 is the first column */

cout << res->getString(1) << endl;

}

delete res;

delete stmt;

delete con;

} catch (sql::SQLException &e) {

cout << "# ERR: SQLException in " << __FILE__;

cout << "(" << __FUNCTION__ << ") on line " »

<< __LINE__ << endl;

cout << "# ERR: " << e.what();

cout << " (MySQL error code: " << e.getErrorCode();

cout << ", SQLState: " << e.getSQLState() << " )" << endl;

}

cout << endl;

return EXIT_SUCCESS;

}