vc mysql utf8_C/C++ 连接 MySQL (VC 版)

#pragma once

#include "targetver.h"

#include

#include

#include

#include

#include

visitsql.cpp 添加 main 函数内容(这段代码来自网上，修改了一下)：

#include "stdafx.h"

using namespace std;

int _tmain(int argc, _TCHAR* argv[])

{

char *host = "localhost";

char *user = "root";

char *pass = "12345";

char *db = "mysql";

MYSQL *sock;

MYSQL_RES *results;

MYSQL_ROW record;

sock = mysql_init(0);

if (sock)

cout << "sock handle ok!" << endl;

else

{

cout << "sock handle failed!" << mysql_error(sock) << endl;

}

//connection

if (mysql_real_connect(sock, host, user, pass, db, 0, NULL, 0))

cout << "connection ok!" << endl;

else

{

cout << "connection fail: " << mysql_error(sock) << endl;

}

mysql_set_character_set(sock,"utf8");

//connection character set

cout << "connection character set: " << mysql_character_set_name(sock) << endl;

//wait for posibility to check system/mysql sockets

if(mysql_query(sock,"select * from user"))

{

cout<

}

results=mysql_store_result(sock);

printf("主机\t用户名\n");

while(record = mysql_fetch_row(results))

{

printf("%s\t%s \n",record[0],record[1]);

}

mysql_free_result(results);

//system("PAUSE");

//closing connection

mysql_close(sock);

return EXIT_SUCCESS;

//return 0;

}

4、打开 visitsql 项目属性，链接器——输入添加：

libmysql.lib

mysqlclient.lib

根据需要，可以添加 lib\debug 中的其它 lib 文件。

5、当选择 Release 版本时，必须再次配置 visitsql 项目属性，重做第4步。

因为，Release 版没有配置这两个库。

运行后，返回结果：

sock handle ok!

connection ok!

connection character set: utf8

主机    用户名

localhost       root

分享到：

2008-12-01 10:14

浏览 5948

评论