How to use ADO to connect to a MySQLl database in ADO VC++
The purpose of this article is to share with you how to use ADO to connect to MySQLl database in classic VC++. The editor thinks it is very practical, so I share it with you. I hope you can get something after reading this article.
There are many ways to develop MySQL database applications through VC:
First, through the MyODBC interface
Second, through the Connector/C++l interface
Third, through the MySQL C API interface
Fourth, the third-party encapsulated MySQL class
After repeated comparison, I still chose MySQL C API to develop MySQL.
The steps to use MySQL in VC are as follows:
1. Download the server / client installation package for MySQL
The official download address is as follows:
Http://www.mysql.com/downloads/mysql-4.0.html
Since my development environment is Windows, I downloaded MySQL for Windows V4.0.12
2. Install MySQL server / client package
In general, just choose the next step.
By default, MySQL is installed under C:\ mysql.
3. Set up its development environment in VC
[options / projects / VC directory]
a. Set the include path to c:\ mysql\ include
b. Set the reference path to c:\ mysql\ include
c. Set the library path to c:\ mysql\ lib\ debug
[project Properties]
d. Set the linker-input-attach dependency to libmySQL.lib
e. Add the following line to the stdafx.h:
# include
# include "mysql.h"
4. At this point, you can use C API functions for development.
FAQ:
1. If there is an error that cannot use the type defined by mysql.h, you can regenerate the project.
two。 If there is a link error, copy the libmySQL.dll file to the current directory of the project.
MySQL provides a number of functions to manipulate the database, which can be roughly divided into the following categories:
The first part
Control class function
Mysql_init () initializes the MySQL object
Mysql_options () sets connection options
Mysql_real_connect () connects to the MySQL database
Mysql_real_escape_string () legalizes the query string
Mysql_query () issues a query string that ends with an empty character.
Mysql_real_query () issues a query string
Mysql_store_result () transmits the result at one time
Mysql_use_result () sends the result line by line
Mysql_free_result () releases the result set
Mysql_change_user () changes the user
Mysql_select_db () changes the default database
Mysql_debug () sends debugging information
Mysql_dump_debug_info () dumps debugging information
Mysql_ping () tests whether the database is active
Mysql_shutdown () request database SHUTDOWN
Mysql_close () closes the database connection
Part II
Information acquisition class function
Mysql_character_set_name () gets the default character set
Mysql_get_client_info () gets client information
Mysql_host_info () gets host information
Mysql_get_proto_info () gets the protocol information
Mysql_get_server_info () gets server information
Mysql_info () gets the additional information of some query statements
Mysql_stat () gets the database status
Mysql_list_dbs () gets the list of databases
Mysql_list_tables () gets the list of data tables
Mysql_list_fields () gets the list of fields
Part III
Row and column operation function
Mysql_field_count () gets the number of fields
Mysql_affected_rows () gets the number of affected rows
Mysql_insert_id () gets the ID value of the AUTO_INCREMENT column
Mysql_num_fields () gets the number of fields in the result set
Mysql_field_tell () gets the current field location
Mysql_field_seek () location field
Mysql_fetch_field () gets the current field
Mysql_fetch_field_direct () gets the specified field
Mysql_frtch_fields () gets an array of all fields
Mysql_num_rows () gets the number of rows
Mysql_fetch_lengths () gets the line length
Mysql_row_tell () gets the current line position
Mysql_row_seek () line positioning
Mysql_data_seek () line positioning
Mysql_fetch_row () gets the current line
The fourth part
Thread class operation function
Mysql_list_processes () returns a list of all threads
Mysql_thread_id () gets the current thread ID
Does mysql_thread_safe () support threading?
Mysql_kill () kills a thread
The fifth part
Error handling class function
Mysql_errno () gets the error number
Mysql_error () gets the error message
The above is how to use ADO to connect to MySQLl database in classic VC++. The editor believes that there are some knowledge points that we may see or use in our daily work. I hope you can learn more from this article. For more details, please follow the industry information channel.
