测试数据库连接类－－初步修改-优快云博客

本文链接：https://blog.youkuaiyun.com/yi_jun_jun/article/details/2904868

本文介绍了一个使用C++实现的MySQL数据库连接示例，并展示了如何从数据库中获取表的字段和行数据，同时输出了客户端和服务端的相关信息。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

 
 #include "connection.hpp"
#include "table.hpp"
#include <iostream>
#include <string>
#include <vector>
#include <boost/foreach.hpp>
#include <exception>
#include <functional>
#include <algorithm>
#include <map>
int main(int argc, char* argv[])
{
  try
    {
      sqlpp::Connection conn("mysql","Localhost","root","yi_jun_jun");
      if (conn.is_open())
      {
    std::cout<<"connect is ok"<<std::endl;
      }
      sqlpp::Table table("select * from user", conn);
 
      table.download();
      sqlpp::Table::field_list my_fields = table.get_fields();
      BOOST_FOREACH(std::string name, my_fields)
    {
      std::cout<<name<<std::endl;
    }
      sqlpp::Table::rows my_rows = table.get_rows<sqlpp::Table::row>();
      std::cout<<"Host/t/tUser/t/tPassword"<<std::endl;
      sqlpp::Table::row this_row;
      BOOST_FOREACH( this_row,my_rows)
      {
      std::cout<<this_row["Host"]<<"/t/t"<<this_row["User"]<<"/t/t"<<this_row["Password"]<<std::endl;
      }
      std::cout<<"client info:"<<conn.get_client_info()<<std::endl;
      std::cout<<"client version:"<<conn.get_client_version()<<std::endl;
      std::cout<<"host info:"<<conn.get_host_info()<<std::endl;
      std::cout<<"server info:"<<conn.get_server_info()<<std::endl;
      std::cout<<"server version:"<<conn.get_server_version()<<std::endl;
      std::cout<<"protocol version:"<<conn.get_protocol_version()<<std::endl;
      std::cout<<"user:"<<conn.get_user()<<std::endl;
      std::cout<<"database:"<<conn.get_database()<<std::endl;
      std::cout<<"server:"<<conn.get_server()<<std::endl;
      std::cout<<"password:"<<conn.get_password()<<std::endl;
            
    }
  catch(const std::exception& e)
    {
      std::cout<<e.what()<<std::endl;
    }
  return 0;
}
    
 