/*

   Basic example of an application using JDBC API of Connector/C++

*/

/* Standard C++ includes */

#include <stdlib.h>

#include <iostream>

#include <sstream>

#include <stdexcept>

/*

  Note: Boost must be in the include path to build code which uses the

  JDBC API.

*/

#include <boost/scoped_ptr.hpp>

#include <jdbc/mysql_connection.h>

#include <jdbc/mysql_driver.h>

#include <jdbc/cppconn/resultset.h>

#include <jdbc/cppconn/statement.h>

#define DEFAULT_URI "tcp://127.0.0.1"

#define EXAMPLE_USER "root"

#define EXAMPLE_PASS ""

#define EXAMPLE_DB "test"

using namespace std;

/*

  Usage example for Driver, Connection, (simple) Statement, ResultSet

*/

int main(int argc, const char **argv)

{

  const char   *url = (argc >  ? argv[] : DEFAULT_URI);

  const string user(argc >=  ? argv[] : EXAMPLE_USER);

  const string pass(argc >=  ? argv[] : EXAMPLE_PASS);

  const string database(argc >=  ? argv[] : EXAMPLE_DB);

  cout << endl;

  cout << "Connector/C++ standalone program example..." << endl;

  cout << endl;

  try {

    sql::Driver * driver = sql::mysql::get_driver_instance();

    /* Using the Driver to create a connection */

    cout << "Creating session on " << url << " ..."

         << endl << endl;

    boost::scoped_ptr< sql::Connection >

      con(driver->connect(url, user, pass));

    con->setSchema(database);

    boost::scoped_ptr< sql::Statement > stmt(con->createStatement());

    boost::scoped_ptr< sql::ResultSet >

      res(stmt->executeQuery("SELECT 'Welcome to Connector/C++' AS _message"));

    cout << "\t... running 'SELECT 'Welcome to Connector/C++' AS _message'"

         << endl;

    while (res->next())

    {

      cout << "\t... MySQL replies: " << res->getString("_message") << endl;

      cout << "\t... say it again, MySQL" << endl;

      cout << "\t....MySQL replies: " << res->getString() << endl;

    }

  }

  catch (sql::SQLException &e)

  {

    /*

      The JDBC API throws three different exceptions:

    - sql::MethodNotImplementedException (derived from sql::SQLException)

    - sql::InvalidArgumentException (derived from sql::SQLException)

    - sql::SQLException (derived from std::runtime_error)

    */

    cout << "# ERR: SQLException in " << __FILE__;

    cout << "(" << "EXAMPLE_FUNCTION" << ") on line " << __LINE__ << endl;

    /* Use what() (derived from std::runtime_error) to fetch the error message */

    cout << "# ERR: " << e.what();

    cout << " (MySQL error code: " << e.getErrorCode();

    cout << ", SQLState: " << e.getSQLState() << " )" << endl;

    return EXIT_FAILURE;

  }

  cout << endl;

  cout << "... find more at http://www.mysql.com" << endl;

  cout << endl;

  return EXIT_SUCCESS;

}