Skip navigation links
MySQL 5.4 Reference Manual :: 20 Connectors and APIs :: 20.5 MySQL Connector/C++ :: 20.5.5 MySQL Connector/C++ Getting Started: Usage Examples
20.5.5.1 MySQL Connector/C++ Connecting to MySQL »
Section Navigation      [Toggle]

20.5.5. MySQL Connector/C++ Getting Started: Usage Examples

[+/-]

20.5.5.1. MySQL Connector/C++ Connecting to MySQL
20.5.5.2. MySQL Connector/C++ Running a simple query
20.5.5.3. MySQL Connector/C++ Fetching results
20.5.5.4. MySQL Connector/C++ Using Prepared Statements
20.5.5.5. MySQL Connector/C++ Complete Example 1
20.5.5.6. MySQL Connector/C++ Complete Example 2

The download package contains usage examples in the directory examples/. The examples explain the basic usage of the following classes:

  • Connection

  • Driver

  • PreparedStatement

  • ResultSet

  • ResultSetMetaData

  • Statement

The examples cover:

  • Using the Driver class to connect to MySQL

  • Creating tables, inserting rows, fetching rows using (simple) statements

  • Creating tables, inserting rows, fetching rows using prepared statements

  • Hints for working around prepared statement limitations

  • Accessing result set meta data

The examples in this document are only code snippets. The code snippets provide a brief overview on the API. They are not complete programs. Please check the examples/ directory of your MySQL Connector/C++ installation for complete programs. Please also read the README file in the examples/ directory. Note to test the example code you will first need to edit the examples.h file in the examples/ directory, to add your connection information. Then simply rebuild the code by issuing a make command.

The examples in the examples/ directory include:

  • examples/connect.cpp:

    How to create a connection, insert data into MySQL and handle exceptions.

  • examples/connection_meta_schemaobj.cpp:

    How to obtain meta data associated with a connection object, for example, a list of tables, databases, MySQL version, connector version.

  • examples/debug.cpp:

    How to activate and deactivate the MySQL Connector/C++ debug protocol.

  • examples/exceptions.cpp:

    A closer look at the exceptions thrown by the connector and how to fetch error information.

  • examples/prepared_statements.cpp:

    How to run Prepared Statements including an example how to handle SQL commands that cannot be prepared by the MySQL Server.

  • examples/resultset.cpp:

    How to fetch data and iterate over the result set (cursor).

  • examples/resultset_meta.cpp:

    How to obtain meta data associated with a result set, for example, number of columns and column types.

  • examples/resultset_types.cpp:

    Result sets returned from meta data methods - this is more a test than much of an example.

  • examples/standalone_example.cpp:

    Simple standalone program not integrated into regular CMake builds.

  • examples/statements.cpp:

    How to run SQL commands without using Prepared Statements.

  • examples/cpp_trace_analyzer.cpp:

    This example shows how to filter the output of the debug trace. Please see the inline comments for further documentation. This script is unsupported.