Developing Database Applications Using MySQL Connector/C++

[Nytro]

Developing Database Applications Using MySQL Connector/C++

This tutorial will show you the essential steps to build and install MySQL Connector/C++ driver, with simple examples to connect, insert, and retrieve data from a MySQL database. Because the focus is on database connectivity from a C++ application, this document assumes that some kind of MySQL database is already up and accessible from the client machine.

Application developers who are new to MySQL Connector/C++ but not to C++ programming and MySQL database, are the target audience of this tutorial.

Listed below are the tools and technologies used to compile, build and run the examples in this tutorial.

Database MySQL Server 5.1.24-rc

C++ Driver MySQL Connector/C++ 1.0.5

MySQL Client Library MySQL Connector/C 6.0

Compiler Sun Studio 12 C++ compiler

Make CMake 2.6.3

Operating System OpenSolaris 2008.11 32-bit

CPU / ISA Intel Centrino / x86

Hardware Toshiba Tecra M2 Laptop

CONTENTS

    MySQL C++ Driver Based on JDBC 4.0 Specification
    Installing MySQL Connector/C++
    Runtime Dependencies
    IDE for Developing C++ Applications
    Create the City Table in the test Database for Code Examples
    Testing the MySQL Database Connectivity With the Connector/C++
    Using Prepared Statements
    Using Transactions
    Accessing Result Set Metadata
    Accessing Database Metadata
    Accessing Parameter Metadata from a PreparedStatement Object
    Catching Exceptions
    Debug Tracing with MySQL Connector/C++
    For More Information

Tutorial:

http://dev.mysql.com/tech-resources/articles/mysql-connector-cpp.html