通过自己摸索和网上帮助 了解了VC++ 用ADO 连接mysql数据库的方法:
使用的方法是利用ADO通过建立ODBC数据源来最终达到访问MySQL的目的。
1.安装mysql数据库服务器程序,也可安装appserv-win32-2.5.9.rar 里面包含了appche ,php,mysql ,安装后者可以通过网页管理数据库。因为方便所以我才用后者。
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDJsdFlXZGxjeTlqY0hCaWJHOW5YMk52YlM5amRYSnlaVzUwTDFFeUxtcHdadz09LmpwZw%3D%3D.jpg?w=700&webp=1)
安装过程中记住密码。
2.建立数据库:
可以通过命令行 也可以通过网页建立:http://localhost/phpMyAdmin/ 输入用户名root 和密码就可通过网页管理数据库。
可以导入数据库:
-- phpMyAdmin SQL Dump
-- version 2.10.2
-- http://www.phpmyadmin.net
--
-- 主机: localhost
-- 生成日期: 2009 年 07 月 24 日 11:56
-- 服务器版本: 5.0.22
-- PHP 版本: 5.2.3
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
--
-- 数据库: `testmysql`
--
-- --------------------------------------------------------
--
-- 表的结构 `test`
--
CREATE TABLE `test` (
`id` int(4) NOT NULL auto_increment,
`name` varchar(50) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk AUTO_INCREMENT=3 ;
--
-- 导出表中的数据 `test`
--
INSERT INTO `test` VALUES (1, 'qq');
INSERT INTO `test` VALUES (2, 'ww');
3.安装MyODBC 我安装的是:MyODBC-3.51.11-2-win.exe
然后:开始菜单->设置->控制面板->管理工具->数据源(ODBC)->系统DSN->添加->选择MySQL ODBC 3.51 Driver
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDJsdFlXZGxjeTlqY0hCaWJHOW5YMk52YlM5amRYSnlaVzUwTDFFMExtcHdadz09LmpwZw%3D%3D.jpg?w=700&webp=1)
这里可以填写所有的数据 以可以在程序里面填写数据 这里 DSN 为 ADOmysql
4.所有准备工作已做完,那我们就可以开始写程序连接数据库:
程序代码: 代码来源:《Visual C++ + SQL Server 数据库应用实例 完全解析》
1
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDA1dmJtVXVaMmxtLmpwZw%3D%3D.jpg?w=700&webp=1)
// ADOConn.h: interface for the ADOConn class.
2
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDA1dmJtVXVaMmxtLmpwZw%3D%3D.jpg?w=700&webp=1)
//
3
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDBWNGNHRnVaR1ZrUW14dlkydFRkR0Z5ZEM1bmFXWT0uanBn.jpg?w=700&webp=1)
//////////////////////////////////////////////////////////////////////
4
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDA1dmJtVXVaMmxtLmpwZw%3D%3D.jpg?w=700&webp=1)
#import "c:\Program Files\Common Files\System\ado\msado15.dll" no_namespace rename("EOF","adoEOF") rename("BOF","adoBOF")
5
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDA1dmJtVXVaMmxtLmpwZw%3D%3D.jpg?w=700&webp=1)
6
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDA1dmJtVXVaMmxtLmpwZw%3D%3D.jpg?w=700&webp=1)
#if !defined(AFX_ADOCONN_H__AC448F02_AF26_45E4_9B2D_D7ECB8FFCFB9__INCLUDED_)
7
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDA1dmJtVXVaMmxtLmpwZw%3D%3D.jpg?w=700&webp=1)
#define AFX_ADOCONN_H__AC448F02_AF26_45E4_9B2D_D7ECB8FFCFB9__INCLUDED_
8
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDA1dmJtVXVaMmxtLmpwZw%3D%3D.jpg?w=700&webp=1)
9
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDA1dmJtVXVaMmxtLmpwZw%3D%3D.jpg?w=700&webp=1)
#if _MSC_VER > 1000
10
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDA1dmJtVXVaMmxtLmpwZw%3D%3D.jpg?w=700&webp=1)
#pragma once
11
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDA1dmJtVXVaMmxtLmpwZw%3D%3D.jpg?w=700&webp=1)
#endif // _MSC_VER > 1000
12
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDA1dmJtVXVaMmxtLmpwZw%3D%3D.jpg?w=700&webp=1)
13
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDA1dmJtVXVaMmxtLmpwZw%3D%3D.jpg?w=700&webp=1)
class ADOConn
14
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDBWNGNHRnVaR1ZrUW14dlkydFRkR0Z5ZEM1bmFXWT0uanBn.jpg?w=700&webp=1)
{
15
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDBsdVFteHZZMnN1WjJsbS5qcGc%3D.jpg?w=700&webp=1)
// 定义变量
16
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDBsdVFteHZZMnN1WjJsbS5qcGc%3D.jpg?w=700&webp=1)
public:
17
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDBsdVFteHZZMnN1WjJsbS5qcGc%3D.jpg?w=700&webp=1)
//添加一个指向Connection对象的指针:
18
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDBsdVFteHZZMnN1WjJsbS5qcGc%3D.jpg?w=700&webp=1)
_ConnectionPtr m_pConnection;
19
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDBsdVFteHZZMnN1WjJsbS5qcGc%3D.jpg?w=700&webp=1)
//添加一个指向Recordset对象的指针:
20
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDBsdVFteHZZMnN1WjJsbS5qcGc%3D.jpg?w=700&webp=1)
_RecordsetPtr m_pRecordset;
21
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDBsdVFteHZZMnN1WjJsbS5qcGc%3D.jpg?w=700&webp=1)
// 定义方法
22
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDBsdVFteHZZMnN1WjJsbS5qcGc%3D.jpg?w=700&webp=1)
public:
23
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDBsdVFteHZZMnN1WjJsbS5qcGc%3D.jpg?w=700&webp=1)
ADOConn();
24
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDBsdVFteHZZMnN1WjJsbS5qcGc%3D.jpg?w=700&webp=1)
virtual ~ADOConn();
25
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDBsdVFteHZZMnN1WjJsbS5qcGc%3D.jpg?w=700&webp=1)
// 初始化—连接数据库
26
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDBsdVFteHZZMnN1WjJsbS5qcGc%3D.jpg?w=700&webp=1)
void OnInitADOConn();
27
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDBsdVFteHZZMnN1WjJsbS5qcGc%3D.jpg?w=700&webp=1)
// 执行查询
28
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDBsdVFteHZZMnN1WjJsbS5qcGc%3D.jpg?w=700&webp=1)
_RecordsetPtr& GetRecordSet(_bstr_t bstrSQL);
29
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDBsdVFteHZZMnN1WjJsbS5qcGc%3D.jpg?w=700&webp=1)
// 执行SQL语句,Insert Update _variant_t
30
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDBsdVFteHZZMnN1WjJsbS5qcGc%3D.jpg?w=700&webp=1)
BOOL ExecuteSQL(_bstr_t bstrSQL);
31
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDBsdVFteHZZMnN1WjJsbS5qcGc%3D.jpg?w=700&webp=1)
void ExitConnect();
32
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDBWNGNHRnVaR1ZrUW14dlkydEZibVF1WjJsbS5qcGc%3D.jpg?w=700&webp=1)
};
33
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDA1dmJtVXVaMmxtLmpwZw%3D%3D.jpg?w=700&webp=1)
34
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDA1dmJtVXVaMmxtLmpwZw%3D%3D.jpg?w=700&webp=1)
#endif // !defined(AFX_ADOCONN_H__AC448F02_AF26_45E4_9B2D_D7ECB8FFCFB9__INCLUDED_)
35
1
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDA1dmJtVXVaMmxtLmpwZw%3D%3D.jpg?w=700&webp=1)
// ADOConn.cpp: implementation of the ADOConn class.
2
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDA1dmJtVXVaMmxtLmpwZw%3D%3D.jpg?w=700&webp=1)
//
3
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDBWNGNHRnVaR1ZrUW14dlkydFRkR0Z5ZEM1bmFXWT0uanBn.jpg?w=700&webp=1)
//////////////////////////////////////////////////////////////////////
4
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDA1dmJtVXVaMmxtLmpwZw%3D%3D.jpg?w=700&webp=1)
5
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDA1dmJtVXVaMmxtLmpwZw%3D%3D.jpg?w=700&webp=1)
#include "stdafx.h"
6
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDA1dmJtVXVaMmxtLmpwZw%3D%3D.jpg?w=700&webp=1)
#include "ADOConn.h"
7
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDA1dmJtVXVaMmxtLmpwZw%3D%3D.jpg?w=700&webp=1)
8
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDA1dmJtVXVaMmxtLmpwZw%3D%3D.jpg?w=700&webp=1)
#ifdef _DEBUG
9
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDA1dmJtVXVaMmxtLmpwZw%3D%3D.jpg?w=700&webp=1)
#undef THIS_FILE
10
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDA1dmJtVXVaMmxtLmpwZw%3D%3D.jpg?w=700&webp=1)
static char THIS_FILE[]=__FILE__;
11
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDA1dmJtVXVaMmxtLmpwZw%3D%3D.jpg?w=700&webp=1)
#define new DEBUG_NEW
12
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDA1dmJtVXVaMmxtLmpwZw%3D%3D.jpg?w=700&webp=1)
#endif
13
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDA1dmJtVXVaMmxtLmpwZw%3D%3D.jpg?w=700&webp=1)
14
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDBWNGNHRnVaR1ZrUW14dlkydFRkR0Z5ZEM1bmFXWT0uanBn.jpg?w=700&webp=1)
//////////////////////////////////////////////////////////////////////
15
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDA1dmJtVXVaMmxtLmpwZw%3D%3D.jpg?w=700&webp=1)
// Construction/Destruction
16
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDBWNGNHRnVaR1ZrUW14dlkydFRkR0Z5ZEM1bmFXWT0uanBn.jpg?w=700&webp=1)
//////////////////////////////////////////////////////////////////////
17
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDA1dmJtVXVaMmxtLmpwZw%3D%3D.jpg?w=700&webp=1)
18
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDA1dmJtVXVaMmxtLmpwZw%3D%3D.jpg?w=700&webp=1)
ADOConn::ADOConn()
19
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDBWNGNHRnVaR1ZrUW14dlkydFRkR0Z5ZEM1bmFXWT0uanBn.jpg?w=700&webp=1)
{
20
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDBsdVFteHZZMnN1WjJsbS5qcGc%3D.jpg?w=700&webp=1)
21
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDBWNGNHRnVaR1ZrUW14dlkydEZibVF1WjJsbS5qcGc%3D.jpg?w=700&webp=1)
}
22
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDA1dmJtVXVaMmxtLmpwZw%3D%3D.jpg?w=700&webp=1)
23
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDA1dmJtVXVaMmxtLmpwZw%3D%3D.jpg?w=700&webp=1)
ADOConn::~ADOConn()
24
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDBWNGNHRnVaR1ZrUW14dlkydFRkR0Z5ZEM1bmFXWT0uanBn.jpg?w=700&webp=1)
{
25
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDBsdVFteHZZMnN1WjJsbS5qcGc%3D.jpg?w=700&webp=1)
26
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDBWNGNHRnVaR1ZrUW14dlkydEZibVF1WjJsbS5qcGc%3D.jpg?w=700&webp=1)
}
27
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDA1dmJtVXVaMmxtLmpwZw%3D%3D.jpg?w=700&webp=1)
28
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDA1dmJtVXVaMmxtLmpwZw%3D%3D.jpg?w=700&webp=1)
// 初始化—连接数据库
29
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDA1dmJtVXVaMmxtLmpwZw%3D%3D.jpg?w=700&webp=1)
void ADOConn::OnInitADOConn()
30
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDBWNGNHRnVaR1ZrUW14dlkydFRkR0Z5ZEM1bmFXWT0uanBn.jpg?w=700&webp=1)
{
31
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDBsdVFteHZZMnN1WjJsbS5qcGc%3D.jpg?w=700&webp=1)
// 初始化OLE/COM库环境
32
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDBsdVFteHZZMnN1WjJsbS5qcGc%3D.jpg?w=700&webp=1)
::CoInitialize(NULL);
33
34
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDBsdVFteHZZMnN1WjJsbS5qcGc%3D.jpg?w=700&webp=1)
try
35
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDBWNGNHRnVaR1ZrVTNWaVFteHZZMnRUZEdGeWRDNW5hV1k9LmpwZw%3D%3D.jpg?w=700&webp=1)
{
36
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDBsdVFteHZZMnN1WjJsbS5qcGc%3D.jpg?w=700&webp=1)
// 创建Connection对象
37
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDBsdVFteHZZMnN1WjJsbS5qcGc%3D.jpg?w=700&webp=1)
m_pConnection.CreateInstance("ADODB.Connection");
38
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDBsdVFteHZZMnN1WjJsbS5qcGc%3D.jpg?w=700&webp=1)
m_pConnection->Open("DSN=ADOmysql;Server= localhost;Database=testmysql","root","123456",adModeUnknown);
39
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDBWNGNHRnVaR1ZrVTNWaVFteHZZMnRGYm1RdVoybG0uanBn.jpg?w=700&webp=1)
}
40
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDBsdVFteHZZMnN1WjJsbS5qcGc%3D.jpg?w=700&webp=1)
// 捕捉异常
41
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDBsdVFteHZZMnN1WjJsbS5qcGc%3D.jpg?w=700&webp=1)
catch(_com_error e)
42
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDBWNGNHRnVaR1ZrVTNWaVFteHZZMnRUZEdGeWRDNW5hV1k9LmpwZw%3D%3D.jpg?w=700&webp=1)
{
43
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDBsdVFteHZZMnN1WjJsbS5qcGc%3D.jpg?w=700&webp=1)
// 显示错误信息
44
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDBsdVFteHZZMnN1WjJsbS5qcGc%3D.jpg?w=700&webp=1)
AfxMessageBox(e.Description());
45
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDBWNGNHRnVaR1ZrVTNWaVFteHZZMnRGYm1RdVoybG0uanBn.jpg?w=700&webp=1)
}
46
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDBWNGNHRnVaR1ZrUW14dlkydEZibVF1WjJsbS5qcGc%3D.jpg?w=700&webp=1)
}
47
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDA1dmJtVXVaMmxtLmpwZw%3D%3D.jpg?w=700&webp=1)
48
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDA1dmJtVXVaMmxtLmpwZw%3D%3D.jpg?w=700&webp=1)
// 执行查询
49
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDA1dmJtVXVaMmxtLmpwZw%3D%3D.jpg?w=700&webp=1)
_RecordsetPtr& ADOConn::GetRecordSet(_bstr_t bstrSQL)
50
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDBWNGNHRnVaR1ZrUW14dlkydFRkR0Z5ZEM1bmFXWT0uanBn.jpg?w=700&webp=1)
{
51
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDBsdVFteHZZMnN1WjJsbS5qcGc%3D.jpg?w=700&webp=1)
try
52
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDBWNGNHRnVaR1ZrVTNWaVFteHZZMnRUZEdGeWRDNW5hV1k9LmpwZw%3D%3D.jpg?w=700&webp=1)
{
53
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDBsdVFteHZZMnN1WjJsbS5qcGc%3D.jpg?w=700&webp=1)
// 连接数据库,如果Connection对象为空,则重新连接数据库
54
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDBsdVFteHZZMnN1WjJsbS5qcGc%3D.jpg?w=700&webp=1)
if(m_pConnection==NULL)
55
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDBsdVFteHZZMnN1WjJsbS5qcGc%3D.jpg?w=700&webp=1)
OnInitADOConn();
56
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDBsdVFteHZZMnN1WjJsbS5qcGc%3D.jpg?w=700&webp=1)
// 创建记录集对象
57
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDBsdVFteHZZMnN1WjJsbS5qcGc%3D.jpg?w=700&webp=1)
m_pRecordset.CreateInstance(__uuidof(Recordset));
58
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDBsdVFteHZZMnN1WjJsbS5qcGc%3D.jpg?w=700&webp=1)
// 取得表中的记录
59
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDBsdVFteHZZMnN1WjJsbS5qcGc%3D.jpg?w=700&webp=1)
m_pRecordset->Open(bstrSQL,m_pConnection.GetInterfacePtr(),adOpenDynamic,adLockOptimistic,adCmdText);
60
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDBWNGNHRnVaR1ZrVTNWaVFteHZZMnRGYm1RdVoybG0uanBn.jpg?w=700&webp=1)
}
61
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDBsdVFteHZZMnN1WjJsbS5qcGc%3D.jpg?w=700&webp=1)
// 捕捉异常
62
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDBsdVFteHZZMnN1WjJsbS5qcGc%3D.jpg?w=700&webp=1)
catch(_com_error e)
63
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDBWNGNHRnVaR1ZrVTNWaVFteHZZMnRUZEdGeWRDNW5hV1k9LmpwZw%3D%3D.jpg?w=700&webp=1)
{
64
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDBsdVFteHZZMnN1WjJsbS5qcGc%3D.jpg?w=700&webp=1)
// 显示错误信息
65
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDBsdVFteHZZMnN1WjJsbS5qcGc%3D.jpg?w=700&webp=1)
AfxMessageBox(e.Description());
66
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDBWNGNHRnVaR1ZrVTNWaVFteHZZMnRGYm1RdVoybG0uanBn.jpg?w=700&webp=1)
}
67
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDBsdVFteHZZMnN1WjJsbS5qcGc%3D.jpg?w=700&webp=1)
// 返回记录集
68
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDBsdVFteHZZMnN1WjJsbS5qcGc%3D.jpg?w=700&webp=1)
return m_pRecordset;
69
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDBWNGNHRnVaR1ZrUW14dlkydEZibVF1WjJsbS5qcGc%3D.jpg?w=700&webp=1)
}
70
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDA1dmJtVXVaMmxtLmpwZw%3D%3D.jpg?w=700&webp=1)
71
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDA1dmJtVXVaMmxtLmpwZw%3D%3D.jpg?w=700&webp=1)
// 执行SQL语句,Insert Update _variant_t
72
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDA1dmJtVXVaMmxtLmpwZw%3D%3D.jpg?w=700&webp=1)
BOOL ADOConn::ExecuteSQL(_bstr_t bstrSQL)
73
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDBWNGNHRnVaR1ZrUW14dlkydFRkR0Z5ZEM1bmFXWT0uanBn.jpg?w=700&webp=1)
{
74
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDBsdVFteHZZMnN1WjJsbS5qcGc%3D.jpg?w=700&webp=1)
// _variant_t RecordsAffected;
75
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDBsdVFteHZZMnN1WjJsbS5qcGc%3D.jpg?w=700&webp=1)
try
76
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDBWNGNHRnVaR1ZrVTNWaVFteHZZMnRUZEdGeWRDNW5hV1k9LmpwZw%3D%3D.jpg?w=700&webp=1)
{
77
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDBsdVFteHZZMnN1WjJsbS5qcGc%3D.jpg?w=700&webp=1)
// 是否已经连接数据库
78
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDBsdVFteHZZMnN1WjJsbS5qcGc%3D.jpg?w=700&webp=1)
if(m_pConnection == NULL)
79
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDBsdVFteHZZMnN1WjJsbS5qcGc%3D.jpg?w=700&webp=1)
OnInitADOConn();
80
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDBsdVFteHZZMnN1WjJsbS5qcGc%3D.jpg?w=700&webp=1)
// Connection对象的Execute方法:(_bstr_t CommandText,
81
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDBsdVFteHZZMnN1WjJsbS5qcGc%3D.jpg?w=700&webp=1)
// VARIANT * RecordsAffected, long Options )
82
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDBsdVFteHZZMnN1WjJsbS5qcGc%3D.jpg?w=700&webp=1)
// 其中CommandText是命令字串,通常是SQL命令。
83
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDBsdVFteHZZMnN1WjJsbS5qcGc%3D.jpg?w=700&webp=1)
// 参数RecordsAffected是操作完成后所影响的行数,
84
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDBsdVFteHZZMnN1WjJsbS5qcGc%3D.jpg?w=700&webp=1)
// 参数Options表示CommandText的类型:adCmdText-文本命令;adCmdTable-表名
85
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDBsdVFteHZZMnN1WjJsbS5qcGc%3D.jpg?w=700&webp=1)
// adCmdProc-存储过程;adCmdUnknown-未知
86
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDBsdVFteHZZMnN1WjJsbS5qcGc%3D.jpg?w=700&webp=1)
m_pConnection->Execute(bstrSQL,NULL,adCmdText);
87
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDBsdVFteHZZMnN1WjJsbS5qcGc%3D.jpg?w=700&webp=1)
return true;
88
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDBWNGNHRnVaR1ZrVTNWaVFteHZZMnRGYm1RdVoybG0uanBn.jpg?w=700&webp=1)
}
89
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDBsdVFteHZZMnN1WjJsbS5qcGc%3D.jpg?w=700&webp=1)
catch(_com_error e)
90
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDBWNGNHRnVaR1ZrVTNWaVFteHZZMnRUZEdGeWRDNW5hV1k9LmpwZw%3D%3D.jpg?w=700&webp=1)
{
91
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDBsdVFteHZZMnN1WjJsbS5qcGc%3D.jpg?w=700&webp=1)
AfxMessageBox(e.Description());
92
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDBsdVFteHZZMnN1WjJsbS5qcGc%3D.jpg?w=700&webp=1)
return false;
93
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDBWNGNHRnVaR1ZrVTNWaVFteHZZMnRGYm1RdVoybG0uanBn.jpg?w=700&webp=1)
}
94
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDBWNGNHRnVaR1ZrUW14dlkydEZibVF1WjJsbS5qcGc%3D.jpg?w=700&webp=1)
}
95
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDA1dmJtVXVaMmxtLmpwZw%3D%3D.jpg?w=700&webp=1)
96
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDA1dmJtVXVaMmxtLmpwZw%3D%3D.jpg?w=700&webp=1)
void ADOConn::ExitConnect()
97
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDBWNGNHRnVaR1ZrUW14dlkydFRkR0Z5ZEM1bmFXWT0uanBn.jpg?w=700&webp=1)
{
98
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDBsdVFteHZZMnN1WjJsbS5qcGc%3D.jpg?w=700&webp=1)
// 关闭记录集和连接
99
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDBsdVFteHZZMnN1WjJsbS5qcGc%3D.jpg?w=700&webp=1)
if (m_pRecordset != NULL)
100
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDBsdVFteHZZMnN1WjJsbS5qcGc%3D.jpg?w=700&webp=1)
m_pRecordset->Close();
101
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDBsdVFteHZZMnN1WjJsbS5qcGc%3D.jpg?w=700&webp=1)
m_pConnection->Close();
102
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDBsdVFteHZZMnN1WjJsbS5qcGc%3D.jpg?w=700&webp=1)
// 释放环境
103
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDBsdVFteHZZMnN1WjJsbS5qcGc%3D.jpg?w=700&webp=1)
::CoUninitialize();
104
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDBWNGNHRnVaR1ZrUW14dlkydEZibVF1WjJsbS5qcGc%3D.jpg?w=700&webp=1)
}
建立本类的一个对象 然后就可访问mysql数据库了:
1
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDA1dmJtVXVaMmxtLmpwZw%3D%3D.jpg?w=700&webp=1)
ADOConn m_ADO;
2
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDA1dmJtVXVaMmxtLmpwZw%3D%3D.jpg?w=700&webp=1)
m_ADO.OnInitADOConn();
3
4
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDA1dmJtVXVaMmxtLmpwZw%3D%3D.jpg?w=700&webp=1)
//设置SELECT语句
5
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDA1dmJtVXVaMmxtLmpwZw%3D%3D.jpg?w=700&webp=1)
_bstr_t vSQL;
6
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDA1dmJtVXVaMmxtLmpwZw%3D%3D.jpg?w=700&webp=1)
vSQL = "SELECT * FROM test WHERE id = 1";
7
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDA1dmJtVXVaMmxtLmpwZw%3D%3D.jpg?w=700&webp=1)
//执行SELETE语句
8
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDA1dmJtVXVaMmxtLmpwZw%3D%3D.jpg?w=700&webp=1)
_RecordsetPtr m_pRecordset;
9
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDA1dmJtVXVaMmxtLmpwZw%3D%3D.jpg?w=700&webp=1)
m_pRecordset = m_ADO.GetRecordSet(vSQL);
10
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDA1dmJtVXVaMmxtLmpwZw%3D%3D.jpg?w=700&webp=1)
11
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDA1dmJtVXVaMmxtLmpwZw%3D%3D.jpg?w=700&webp=1)
CString name0;
12
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDA1dmJtVXVaMmxtLmpwZw%3D%3D.jpg?w=700&webp=1)
//返回各列的值
13
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDA1dmJtVXVaMmxtLmpwZw%3D%3D.jpg?w=700&webp=1)
if (!m_pRecordset->adoEOF)
14
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDBWNGNHRnVaR1ZrUW14dlkydFRkR0Z5ZEM1bmFXWT0uanBn.jpg?w=700&webp=1)
{
15
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDBsdVFteHZZMnN1WjJsbS5qcGc%3D.jpg?w=700&webp=1)
16
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDBsdVFteHZZMnN1WjJsbS5qcGc%3D.jpg?w=700&webp=1)
name0 = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("name");
17
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDBWNGNHRnVaR1ZrUW14dlkydEZibVF1WjJsbS5qcGc%3D.jpg?w=700&webp=1)
}
18
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDA1dmJtVXVaMmxtLmpwZw%3D%3D.jpg?w=700&webp=1)
//断开与数据库的连接
19
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDA1dmJtVXVaMmxtLmpwZw%3D%3D.jpg?w=700&webp=1)
m_ADO.ExitConnect();
20
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDA1dmJtVXVaMmxtLmpwZw%3D%3D.jpg?w=700&webp=1)
21
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDBsdFlXZGxjeTlQZFhSc2FXNXBibWRKYm1ScFkyRjBiM0p6TDA1dmJtVXVaMmxtLmpwZw%3D%3D.jpg?w=700&webp=1)
MessageBox(name0, L"id = 1", 0);
运行结果:
![VC++ ADO 连接 mysql VC++ ADO 连接 mysql](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmQzZDNMbU53Y0dKc2IyY3VZMjl0TDJsdFlXZGxjeTlqY0hCaWJHOW5YMk52YlM5amRYSnlaVzUwTDFFMUxtcHdadz09LmpwZw%3D%3D.jpg?w=700&webp=1)