时间:2021-07-01 10:21:17 帮助过:49人阅读
#define _CRT_SECURE_NO_WARNINGS#include #include #include #include #include #include #pragma comment(lib,"libmysql64.lib")//连接MysQL需要的库 #pragma comment(lib,"libmysql.lib")//连接MysQL需要的库 using namespace std;int main(){ const char user[] = "VISUAL_STUDIO1"; //username const char pswd[] = "ligh123456789"; //password const char host[] = "118.192.151.230"; //or"127.0.0.1" const char table[] = "testdb"; //database unsigned int port = 3306; //server port MYSQL myCont; MYSQL_RES *result; MYSQL_ROW sql_row; MYSQL_FIELD *fd; char column[32][32]; int res; mysql_init(&myCont); if (mysql_real_connect(&myCont, host, user, pswd, table, port, NULL, 0)) { cout << "connect succeed!" << endl; mysql_query(&myCont, "SET NAMES GBK"); //设置编码格式,否则在cmd下无法显示中文 res = mysql_query(&myCont, "select * from uc");//查询 if (!res) { result = mysql_store_result(&myCont);//保存查询到的数据到result if (result) { int i, j; cout << "number of result: " << (unsigned long)mysql_num_rows(result) << endl; for (i = 0; fd = mysql_fetch_field(result); i++)//获取列名 { strcpy(column[i], fd->name); } j = mysql_num_fields(result); for (i = 0; i
为什么运行结果会有这个::::::
错误 1 error LNK1104: 无法打开文件“libmysql64.lib” d:\用户目录\我的文档\Visual Studio 2013\Projects\MySQL\MySQL\LINK