c++ mysql 实例教程_C++操作MySQL的实现示例

Windows版本：

将libmysql.dll、libmysql.lib、mysql.h复制粘贴到项目文件中，或者项目设置里的包含目录和库目录添加路径

#include

#include

#include "winsock.h"

#include "mysql.h"

#pragma comment(lib,"libmySQL.lib")

using namespace std;

int main()

{

MYSQL* m_sqlCon;

MYSQL_RES* res_set;

MYSQL_ROW row;

MYSQL_FIELD* field;

m_sqlCon = mysql_init((MYSQL*)0);

if (!mysql_real_connect(m_sqlCon, "localhost", "root", "123456", "test", 3306, NULL, 0))

{

cerr << "Failed to connect to database: Error: " << mysql_error(m_sqlCon) << endl;

}

else

{

cerr << "Successfully connected to Database." << endl;

cout << endl;

string pQuery = "select * from my_table";

int status = mysql_real_query(m_sqlCon, pQuery.c_str(), (UINT)strlen(pQuery.c_str())); //输入命令

res_set = mysql_store_result(m_sqlCon);

field = mysql_fetch_fields(res_set); //获取所有列名

int field_count = mysql_field_count(m_sqlCon); //获取列数

for (int i = 0; i < field_count; i++) //输出所有列名

{

cout << setw(15) << field[i].name; //总共占15格

}

cout << endl;

int row_count = mysql_num_rows(res_set); //获取行数

while (row = mysql_fetch_row(res_set)) //输出所有行数据

{

for (int i = 0; i < field_count; i++)

{

cout << setw(15) << row[i];

}

cout << endl;

}

}

mysql_close(m_sqlCon);

system("pause"