Debian下使用C++连接MySQL。

首先，安装libmysql++。

然后，基本用法如下：

点击(此处)折叠或打开

1. #include <mysql++.h>
   
2. 
   
3. #include <iostream>
4. 
   
5. using namespace std;
   
6. 
   
7. int main(int argc, char *argv[])
   
8. {
   
9.     mysqlpp::Connection conn;
   
10. 
    
11.     conn.set_option(new mysqlpp::SetCharsetNameOption("utf8"));
    
12. 
    
13.     if (conn.connect("db_name", "db_server", "db_user_name", "db_user_pass"))
    
14.     {
    
15.         mysqlpp::Query query_01 = conn.query("select * from issuer_sector_table order by issuer_sector_id");
    
16.         mysqlpp::StoreQueryResult res_01 = query_01.store();
    
17. 
    
18.         if (res_01)
    
19.         {
    
20.             for (size_t i = 0; i < res_01.num_rows(); i++)
    
21.             {
    
22.                 cout << res_01[i]["issuer_sector_id"] << "\t" << res_01[i]["issuer_sector"]<< endl;
    
23.             }
    
24.         }
    
25.         else {
    
26.             cerr << "Failed to get stock table: " << query_01.error() << endl;
    
27.             return 1;
    
28.         }
    
29. 
    
30.         mysqlpp::Query query_02 = conn.query("insert into issuer_sector_table (issuer_sector) values ('---')");
    
31.         mysqlpp::SimpleResult res_02 = query_02.execute();
    
32. 
    
33.         cout << res_02.insert_id() << endl;
    
34. 
    
35.         return 0;
    
36.     }
    
37.     else {
    
38.         cerr << "DB connection failed: " << conn.error() << endl;
    
39.         return 1;
    
40.     }
    
41. }

注意：要设定编码。