#include \n#include <mysql/mysql.h>\n\nint main() {\n MYSQL *conn;\n MYSQL_RES *res;\n MYSQL_ROW row;\n int page = 1; // 当前页码\n int page_size = 10; // 每页数据数量\n\n // 初始化MySQL连接\n conn = mysql_init(NULL);\n if (conn == NULL) {\n std::cout << "MySQL initialization failed" << std::endl;\n return 1;\n }\n\n // 连接到数据库\n if (!mysql_real_connect(conn, "localhost", "username", "password", "database", 0, NULL, 0)) {\n std::cout << "Connection failed: " << mysql_error(conn) << std::endl;\n return 1;\n }\n\n // 构建SQL查询语句\n std::string query = "SELECT SRC_IP, SRC_MAC, DST_IP, DST_PORT, PROTO FROM test LIMIT " + std::to_string((page - 1) * page_size) + "," + std::to_string(page_size);\n\n // 执行查询\n if (mysql_query(conn, query.c_str())) {\n std::cout << "Query execution failed: " << mysql_error(conn) << std::endl;\n return 1;\n }\n\n // 获取查询结果集\n res = mysql_use_result(conn);\n\n // 遍历结果集并输出数据\n while ((row = mysql_fetch_row(res))) {\n std::cout << "SRC_IP: " << row[0] << ", SRC_MAC: " << row[1] << ", DST_IP: " << row[2] << ", DST_PORT: " << row[3] << ", PROTO: " << row[4] << std::endl;\n }\n\n // 释放结果集\n mysql_free_result(res);\n\n // 关闭数据库连接\n mysql_close(conn);\n\n return 0;\n}