当前位置:Gxlcms > mysql > visualstudio-MySQL连接不到libmysqllib

visualstudio-MySQL连接不到libmysqllib

时间:2021-07-01 10:21:17 帮助过:49人阅读

visual studiomysql数据

 #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

人气教程排行