第14章 《数据》Page56~57，“流”方式组装SQL语句

#include <iostream>
#include <mysql++/mysql++.h>

using namespace std;

//打印查询结果
void output_result(mysqlpp::StoreQueryResult const& result)
{
    size_t row_count = result.num_rows();
    if(row_count == 0)
    {
        cout << "查无记录。" << endl;
        return;
    }

    for(size_t i = 0; i < row_count; ++ i)
    {
        cout << result[i]["id"]
             << setw(6) << "=>" << setw(12)
             << result[i]["name"] << endl;
    }
}

int main()
{
    mysqlpp::Connection con;
    con.set_option(new mysqlpp::SetCharsetNameOption("gbk"));

    try
    {
        con.connect("d2school", "127.0.0.1", "root", "mysql_d2school");

        while(true)
        {
            mysqlpp::Query Q = con.query();//每次新建一个“查询”对象
            string name;
            cout << "请输入用户名： ";
            getline(cin, name);

            Q << "SELECT * FROM user WHERE name = "
              << mysqlpp::quote << name;

            mysqlpp::StoreQueryResult res = Q.store();
            output_result(res);
        }
    }
    catch(mysqlpp::Exception const& e)
    {
        cerr << "ERROR!" << e.what() << endl;
        return -1;
    }

}