- 论坛徽章:
- 0
|
#include "util.h"
#include <mysql++.h>
#include <iostream>
#include <iomanip>
using namespace std;
int
main(int argc, char *argv[])
{
// Connect to the sample database.
mysqlpp::Connection con(false);
if (!connect_to_db(argc, argv, con)) {
return 1;
}
// Retrieve a subset of the sample stock table set up by resetdb
mysqlpp: uery query = con.query();
query << "select item from stock";
mysqlpp::Result res = query.store();
// Display the result set
cout << "We have:" << endl;
if (res) {
char buf[100];
mysqlpp::Row row;
mysqlpp::Row::size_type i;
for (i = 0; row = res.at(i); ++i) {
cout << '\t' << utf8trans(row.at(0), buf, sizeof(buf)) << endl;
}
}
else {
cerr << "Failed to get item list: " << query.error() << endl;
return 1;
}
return 0;
}
如果要访问mysql中的表是不是就将
其中红色字中mysql++.h换成mysql.h行了?
谢谢!!! |
|