VC++连接Mysql

绝地灬酷狼 2022-10-10 11:19 126阅读 0赞

win7, vc6; 新建一个对话框工程；

添加包含目录；

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2JjYm9ibzIxY24_size_16_color_FFFFFF_t_70][]

添加库目录；

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2JjYm9ibzIxY24_size_16_color_FFFFFF_t_70 1][]

添加lib文件；

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2JjYm9ibzIxY24_size_16_color_FFFFFF_t_70 2][]

把mysql的dll和lib文件拷贝到项目文件夹；

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2JjYm9ibzIxY24_size_16_color_FFFFFF_t_70 3][]

看一下mysql的数据库；

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2JjYm9ibzIxY24_size_16_color_FFFFFF_t_70 4][]

按钮代码；

void CMysqltestDlg::OnButton1() 
    {
    	// TODO: Add your control notification handler code here
    	MYSQL mysql;
    	mysql_init(&mysql); //初始化mysql结构
     
    	if(!mysql_real_connect(&mysql,"localhost","root","kc123ab","world",3306,NULL,0))
    	{
    		//printf("\n连接数据库时发生错误!\n");
    		AfxMessageBox("连接数据库时发生错误");
    	}              
    	else
    	{
    		//printf("\n连接数据库成功!\n");
    		AfxMessageBox("连接数据库成功");
    	}
    
    	mysql_close(&mysql); //释放数据库
    }

构建；出现下图错误；无效的机器类型；lib和dll版本不对；

![20210628030921750.png][]

下载32位的lib和dll，替换前面的lib和dll；再构建，成功；运行如下；

![2021062803093180.png][]

另外需要包含mysql的头文件；

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2JjYm9ibzIxY24_size_16_color_FFFFFF_t_70 5][]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2JjYm9ibzIxY24_size_16_color_FFFFFF_t_70]: /images/20221005/1cd47f46cbf047a583909cdc41516d3d.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2JjYm9ibzIxY24_size_16_color_FFFFFF_t_70 1]: /images/20221005/f8ba464761de42a297649a3ee9ee530f.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2JjYm9ibzIxY24_size_16_color_FFFFFF_t_70 2]: /images/20221005/aadb9615f97e4c49aa42136d4663ea94.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2JjYm9ibzIxY24_size_16_color_FFFFFF_t_70 3]: /images/20221005/6b420e819c924beea32e39d310894ba4.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2JjYm9ibzIxY24_size_16_color_FFFFFF_t_70 4]: /images/20221005/19ee39ac5c5f475e91eec3e88c29ae49.png
[20210628030921750.png]: /images/20221005/9ed6bb1b61c949c788bc76cfe56a53c2.png
[2021062803093180.png]: /images/20221005/2887185fc70b4a138085b17927c73ba6.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2JjYm9ibzIxY24_size_16_color_FFFFFF_t_70 5]: /images/20221005/54a408efed9940dc96ef3e514fb279e4.png