mfc mysql类

#include "stdafx.h"
#include "mysql.h" // 引入MySQL类库头文件

// 连接数据库
MYSQL mysql;
mysql_init(&mysql);
if (!mysql_real_connect(&mysql, "localhost", "username", "password", "database", 3306, NULL, 0)) {
    printf("Failed to connect to database: %s\n", mysql_error(&mysql));
    return;
}

// 执行SQL语句
if (mysql_query(&mysql, "SELECT * FROM table_name")) {
    printf("Failed to execute SQL statement: %s\n", mysql_error(&mysql));
    return;
}

// 处理结果集
MYSQL_RES *result = mysql_store_result(&mysql);
if (result) {
    MYSQL_ROW row;
    while ((row = mysql_fetch_row(result))) {
        // 处理每一行数据
        for (int i = 0; i < mysql_num_fields(result); i++) {
            printf("%s ", row[i] ? row[i] : "NULL");
        }
        printf("\n");
    }
    mysql_free_result(result);
}

// 关闭数据库连接
mysql_close(&mysql);