#include <iostream>
#include <vector>
#include <mysql++/query.h>
#include <mysql++/result.h>
using namespace std;
const char * db_name = "mysql_cpp_data";
const char * host = "localhost";
const char * username = "root";
const char * password = "passwd";
struct stock {
int item;
int num;
float weight;
int price;
string sdate;
};
int main(int argc, char *argv[])
{
#if 1
try {
// Establish the connection to the database server.
mysqlpp::Connection con(mysqlpp::use_exceptions);
if (!con.connect(db_name, host, username, password)) {
return 1;
}
mysqlpp::Query query = con.query();
query << "select * from stock";
cout << "Query: " << query.preview() << endl;
mysqlpp::Result rest = query.store();
mysqlpp::Result::iterator i = rest.begin();
mysqlpp::Row row = *i;
cout << "Result:" << endl;
for (int j = 0; j < row.size(); j++) {
cout << rest.field_name(j);
cout << setw(20);
}
cout << endl;
for (i = rest.begin(); i != rest.end(); i++) {
cout << setw(0);
row = *i;
for (int j = 0; j < row.size(); j++) {
cout << row.at(j);
cout << setw(20);
}
cout << endl;
}
query << "insert into stock(num, weight, price, sdate)\
values(8 ,98, 132, '2005-5-10 12:12:12')";
query.execute();
}
catch (const mysqlpp::BadQuery& er) {
// Handle any query errors
cerr << "Query error: " << er.what() << endl;
return -1;
}
catch (const mysqlpp::BadConversion& er) {
// Handle bad conversions; e.g. type mismatch populating 'stock'
cerr << "Conversion error: " << er.what() << endl <<
"\tretrieved data size: " << er.retrieved <<
", actual size: " << er.actual_size << endl;
return -1;
}
catch (const mysqlpp::Exception& er) {
// Catch-all for any other MySQL++ exceptions
cerr << "Error: " << er.what() << endl;
return -1;
}
#endif
return 0;
}
mysql++使用实例
精选 转载文章标签 mysql++ 简单使用例子 文章分类 MySQL 数据库
提问和评论都可以,用心的回复会被更多人看到
评论
发布评论
相关文章
-
记录flink sql实时同步mysql数据表到mysql
关于大数据实时数据同步flink部分测试实验
flink mysql bc -
Linux环境下Mysql++安装及操作深入详解
题记:之前项目中使用OTL连接操作Oracle数据库,对于Mysql有用,但没有总结。目前常用
mysql++ linux 安装 使用 详解