#include <windows.h>
#include <iostream>
#include <mysql.h>
using namespace std;
void testConnection();
int main()
{
testConnection();
return 0;
}
void testConnection()
{
MYSQL mysql;
MYSQL_RES *result;
MYSQL_ROW sql_row;
MYSQL_FIELD *fd;
char *host = "***";
char *username = "***";
char *password = "***";
char *database = "***";
int res;
mysql_init(&mysql);
if (mysql_real_connect(&mysql, host, username, password, database, 3306, 0, 0))
{
res = mysql_query(&mysql, "select * from profiles");
if (!res)
{
result = mysql_store_result(&mysql);
if (result)
{
int idx = 1;
while(sql_row=mysql_fetch_row(result))
{
int i;
int n = mysql_num_fields(result);
printf("==== record[%d]=====\n", idx++);
for (i = 0; i < n; i++)
{
printf("sql_row[%d] = %s\n", i, sql_row[i]);
}
printf("==================\n\n");
}
}
}
}
}
VS2012+mysql
最新推荐文章于 2023-04-02 22:59:37 发布