1 /*
  2 * A simple OCCI test application
  3 * This file contains the Employees class declaration
  4 */
  5 
  6 #include <occi.h>
  7 #include <iostream>
  8 #include <iomanip>
  9 
 10 using namespace oracle::occi;
 11 using namespace std;
 12 
 13 class Employees {
 14 public:
 15   Employees();
 16   virtual ~Employees();
 17 
 18   void List();
 19 
 20 private:
 21   Environment *env;
 22   Connection  *con;
 23 
 24   string user;
 25   string passwd;
 26   string db;
 27 };
 28 
 29 In Solution Explorer, right-click Source Files, select Add, select New Item…
 30 
 31 In Add New Item, select C++ File (.cpp), enter Employees.cpp (or any name you prefer) in Name, and click Add.
 32 
 33 Here's the content of the file on my system:
 34 
 35 /*
 36 * A simple OCCI test application
 37 * This file contains the Employees class implementation
 38 */
 39 
 40 #include "Employees.h"
 41 
 42 using namespace std;
 43 using namespace oracle::occi;
 44 
 45 int main (void)
 46 {
 47   /*
 48    * create an instance of the Employees class,
 49    * invoke the List member, delete the instance,
 50    * and prompt to continue...
 51 */
 52 
 53   Employees *pEmployees = new Employees();
 54 
 55   pEmployees->List();
 56 
 57   delete pEmployees;
 58 
 59   cout << "ENTER to continue...";
 60 
 61   cin.get();
 62 
 63   return 0;
 64 }
 65 
 66 Employees::Employees()
 67 {
 68   /*
 69    * connect to the test database as the HR
 70    * sample user and use the EZCONNECT method
 71    * of specifying the connect string. Be sure
 72    * to adjust for your environment! The format
 73    * of the string is host:port/service_name
 74 */
 75 
 76   user = "hr";
 77   passwd = "hr";
 78   db = "oel01:1521/OEL11GR1.SAND";
 79 
 80   env = Environment::createEnvironment(Environment::DEFAULT);
 81 
 82   try
 83   {
 84     con = env->createConnection(user, passwd, db);
 85   }
 86   catch (SQLException& ex)
 87   {
 88     cout << ex.getMessage();
 89 
 90     exit(EXIT_FAILURE);
 91   }
 92 }
 93 
 94 Employees::~Employees()
 95 {
 96   env->terminateConnection (con);
 97 
 98   Environment::terminateEnvironment (env);
 99 }
100 
101 void Employees::List()
102 {
103   /*
104    * simple test method to select data from
105    * the employees table and display the results
106 */
107 
108   Statement *stmt = NULL;
109   ResultSet *rs = NULL;
110   string sql = "select employee_id, first_name, last_name " \
111                "from employees order by last_name, first_name";
112 
113   try
114   {
115     stmt = con->createStatement(sql);
116   }
117   catch (SQLException& ex)
118   {
119     cout << ex.getMessage();
120   }
121 
122   if (stmt)
123   {
124     try
125     {
126       stmt->setPrefetchRowCount(32);
127 
128       rs = stmt->executeQuery();
129     }
130     catch (SQLException& ex)
131     {
132       cout << ex.getMessage();
133     }
134 
135     if (rs)
136     {
137       cout << endl << setw(8) << left << "ID"
138            << setw(22) << left << "FIRST NAME"
139            << setw(27) << left << "LAST NAME"
140            << endl;
141       cout << setw(8) << left << "======"
142            << setw(22) << left << "===================="
143            << setw(27) << left << "========================="
144            << endl;
145 
146       while (rs->next()) {
147         cout << setw(8) << left << rs->getString(1)
148              << setw(22) << left << (rs->isNull(2) ? "n/a" : rs->getString(2))
149              << setw(27) << left << rs->getString(3)
150              << endl;
151       }
152 
153       cout << endl;
154 
155       stmt->closeResultSet(rs);
156     }
157 
158     con->terminateStatement(stmt);
159   }
160 }