#include <tchar.h>
#include <iostream>
using namespace std;
#include <cppconn/driver.h>
#include <cppconn/statement.h>
#include <cppconn/prepared_statement.h>
#include <cppconn/resultset.h>
#include <cppconn/exception.h>

int _tmain(int argc, _TCHAR* argv[])
{

  sql::Driver	    *driver;
  sql::Connection	*con;
  sql::PreparedStatement *pstmt;
  sql::ResultSet  *res;

  driver = get_driver_instance();
  con = NULL;
  try
  {
    con = driver->connect("localhost", "*******", "******");
    con->setSchema("test");
  }
  catch(sql::SQLException &e)
  {
    cout << "Cannot connect";
    return -1;
  }
  pstmt = con->prepareStatement("SELECT NOW(6)");
  res = pstmt->executeQuery();

  while (res->next())
  {
    cout << "time = " << res->getString(1) << "\n";
  }

  con->close();

  delete res;
  delete pstmt;
  delete con;

	return 0;
}