MySQL Connector/C++ 简单例子

#include <stdio.h>#include <string>#include <sstream>#include <driver/mysql_connection.h>  #include <driver/mysql_driver.h>  #include <cppconn/statement.h> #include <driver/mysql_public_iface.h>using namespace sql;  using namespace std;  void MySQLExample()   {  Driver*driver;//驱动Connection*connection;//连接Statement*statement;//用于向 MySQL 服务器发送 SQL 语句  ResultSet*resultSet;//存放查询结果// 初始化驱动  driver = sql::mysql::get_mysql_driver_instance();// 建立链接  string strAddress= "tcp://172.16.6.128:3306";string strName= "duan";string strPassword= "123456";connection = driver->connect(strAddress, strName, strPassword);// 连接并登陆账户// 获取Statement对象statement = connection->createStatement();// 使用 test 库statement->execute("use test");// 执行 SQL 语句ostringstream ostream;ostream << "select * from pxz";string strSQL = ostream.str();resultSet = statement->executeQuery(strSQL);// executeQuery用于产生单个结果集的语句// executeUpdate用于执行 INSERT、UPDATE 或 DELETE 语句以及 SQL DDL（数据定义语言）语句// execute用于执行返回多个结果集、多个更新计数或二者组合的语句// 取出结果 while(resultSet->next())  {  intid= resultSet->getInt("id");stringname= resultSet->getString("name");stringsex= resultSet->getString("sex"); doubledegree= resultSet->getDouble("degree");cout << id << " " << name << " "<< sex << " " << degree << endl;  }  delete statement;  delete connection;  } int main(){MySQLExample();getchar();return 0;}