C++ 连接Mysql数据库实现查询功能

使用clion 工具

1.创建 mysqlTool 工程

2.安装MYSQL 数据库

机器已安装好，并确保服务已启动

3.工程配置 MYSQL 信息

cmake_minimum_required(VERSION 3.10)

project(mysqlTool)
set(CMAKE_CXX_STANDARD 11)


#第三方库dll加载
#设置头文件路径
set(INC_DIR D://mysql8//mysql-8.0.25-winx64//include)

#设置链接库路径
set(LINK_DIR D://mysql8//mysql-8.0.25-winx64//lib)

#引入头文件
include_directories(${INC_DIR})

#引入库文件
link_directories(${LINK_DIR})

add_executable(mysqlTool main.cpp)

target_link_libraries(mysqlTool libmysql.dll)

4.实现程序

#include <stdio.h>
#include <iostream>
#include "mysql.h"

using namespace std;

int main() {
    MYSQL connect;
    MYSQL_RES *res;
    MYSQL_ROW  row;

    //连接
    mysql_init(&connect);
    //连接到数据库库
    if(!mysql_real_connect(&connect,"127.0.0.1","root","abc.123","testdb",3306,NULL,0)){
        cout<<"连接信息:"<<mysql_error(&connect)<<endl;
        exit(1);
    }

    //设置字符集
    //mysql_query(&connect,"set names utf-8");

    //查询
    char sqls[] = "select * from user";
    if(mysql_query(&connect,sqls)){
        cout<< "错误信息:" <<mysql_error(&connect) << endl;
        exit(1);
    }

    //结果集
    res = mysql_use_result(&connect);

    //遍历结果
    while ((row=mysql_fetch_row(res))!=NULL){
        cout << row[0] << " " << row[1] << " "<< row[2] << " "<< row[3]<< " "<< row[4]<< endl;
    }

    //释放资源并关闭连接
    mysql_free_result(res);
    mysql_close(&connect);

    return 0;
}