C + + Connect Oracle

Here is an ADO way to connect to Oracle's applet part of the code ...

First is the configuration of Oracle, located under the Oracle installation path: Oracle\network\admin\tnsnames.ora file, configure the connection configuration

[Plain]View plain copy

1. BOSS =
2. (DESCRIPTION =
3. (Address_list =
4. (ADDRESS = (PROTOCOL = TCP) (HOST = xx.xx.xx.xx) (PORT = 1521))
5. )
6. (Connect_data =
7. (service_name = boss)
8. )
9. )

Create a new header file, named CDBOperation.h:

[CPP]View plain copy

2. #pragma once
4. #import "C:\Program Files\Common Files\system\ado\msado15.dll" No_namespace rename ("EOF", "adoeof")
6. Class Cdboperation
8. {
10. Public
12. //Initialize objects required for database operations
14. Cdboperation (void);
16. ~cdboperation (void);
20. //Connect to database
22. bool Conntodb (char *connectionstring, char *userid, char *password);
26. //Database operation function
28. //Query operation delete and add
30. _RecordsetPtr executewithressql (const char *);
34. Private
36. void Printerrorinfo (_com_error &);
40. Private
42. //Initialize database connections, commands, recordset
44. _connectionptr createconnptr ();
46. _commandptr createcommptr ();
48. _RecordsetPtr createrecsetptr ();
52. Private
54. //connection required for database connection, command action object
56. _connectionptr m_pconnection;
58. _commandptr M_pcommand;
60. };

Create a new C + + source file named CDBOperation.cpp:

[CPP]View plain copy

2. #include "stdafx.h"
4. #include "DBOperation.h"
6. Cdboperation::cdboperation (void)
8. {
10. CoInitialize (NULL);
12. M_pconnection = Createconnptr ();
14. M_pcommand = Createcommptr ();
16. }
18. Cdboperation::~cdboperation (void)
20. {
22. M_pconnection->close ();
24. }
26. BOOL Cdboperation::conntodb (char *connectionstring, char *userid, char *password)
28. {
30. if (NULL = = m_pconnection)
32. {
34. printf ("Failed to create connection\n");
36. return false;
38. }
40. Try
42. {
44. HRESULT hr = M_pconnection->open (ConnectionString, UserID, Password, NULL);
46. if (TRUE = = FAILED (hr))
48. {
50. return false;
52. }
54. M_pcommand->activeconnection = m_pconnection;
56. return true;
58. }
60. catch (_com_error &e)
62. {
64. Printerrorinfo (e);
66. return false;
68. }
70. }
72. _RecordsetPtr cdboperation::executewithressql (const char *sql)
74. {
76. Try
78. {
80. M_pcommand->commandtext = _bstr_t (sql);
82. _RecordsetPtr pRst = M_pcommand->execute (null, NULL, adCmdText);
84. return pRst;
86. }
88. catch (_com_error &e)
90. {
92. Printerrorinfo (e);
94. return NULL;
96. }
98. }
100. void Cdboperation::P rinterrorinfo (_com_error &e)
102. {
104. printf ("Error infomation is as follows\n");
106. printf ("Errorno:%d\nerror message:%s\nerror source:%s\nerror description:%s\n", E.error (), E.errormessage (), (  LPCTSTR) E.source (), (LPCTSTR) e.description ());
108. }
112. _connectionptr cdboperation::createconnptr ()
114. {
116. HRESULT HR;
118. _connectionptr connptr;
120. hr = Connptr.createinstance (__uuidof (Connection));
122. if (FAILED (hr) = = TRUE)
124. {
126. return NULL;
128. }
130. return connptr;
132. }
136. _commandptr cdboperation::createcommptr ()
138. {
140. HRESULT HR;
142. _commandptr commptr;
144. hr = Commptr.createinstance (__uuidof (Command));
146. if (FAILED (hr) = = TRUE)
148. {
150. return NULL;
152. }
154. return commptr;
156. }
160. _RecordsetPtr Cdboperation::createrecsetptr ()
162. {
164. HRESULT HR;
166. _RecordsetPtr recsetptr;
168. hr = Recsetptr.createinstance (__uuidof (Command));
170. if (FAILED (HR) ==true)
172. {
174. return NULL;
176. }
178. return recsetptr;
180. }

My code is placed in the MFC one button click event:

Remember to import the header file in the CPP file that handles the event: #include "DBOperation.h"

[CPP]View plain copy

2. Cdboperation Dboper;
4. bool Bconn = Dboper.conntodb ("PROVIDER=ORAOLEDB.ORACLE.1;  Persist Security info=true;data Source=boss ", " username "," password ");
6. if (false = = Bconn)
8. {
10. MessageBox ((lpctstr)"Connection Database Error", 0,0);
12. return;
14. }
18. //Enquiry
20. _RecordsetPtr pRst;
22. char sql[255] = {0};
24. strcpy (SQL, "SELECT * from boss_test_table2 where rownum = 1");
26. pRst = dboper.executewithressql (sql);
28. if (NULL = = pRst)
30. {
32. MessageBox (_t ("Query data Error!  "), 0,0);
34. return;
36. }
38. if (prst->adoeof)
40. {
42. Prst->close ();
44. MessageBox ((lpctstr)"There is no records in this table\0", 0,0);
46. return;
48. }
50. _variant_t Vsno, VName;
52. While (!prst->adoeof)
54. {
56. //prst->movefirst ();//record set pointer moved to the front of the query result set
58. Vsno = Prst->getcollect (_variant_t ("U_number"));
60. VName = Prst->getcollect (_variant_t ("Users_name"));
62. MessageBox ((lpctstr) (_bstr_t) vsno,0,0);
64. Prst->movenext ();
66. }
70. strcpy (SQL, "INSERT into Boss_test_table2 (U_number, Users_name, Users_phone, status, customno_id) VALUES (' 0001 ', ' C  +ttt+ ', ' 13999000000 ', 2, ' bpppppppppp ');
72. pRst = dboper.executewithressql (sql);
74. if (NULL! = pRst)
76. {
78. AfxMessageBox (_t ("Insert data succeeded \ n"));
80. }
82. //Execute DELETE statement
84. sprintf (SQL, "Delete boss_test_table2 where U_number = '%s '", "009");
86. pRst = dboper.executewithressql (sql);
88. if (NULL! = pRst)
90. {
92. MessageBox (_t ("delete data successfully"), 0,0);
94. }
96. //Execute UPDATE statement
98. sprintf (SQL, "Update boss_test_table2 set users_name = '%s '", " C + + anti-Human, MFC anti-social");
100. pRst = dboper.executewithressql (sql);
102. if (NULL! = pRst)
104. {
106. MessageBox (_t ("Update data successfully"), 0,0);
108. }

C + + Connect Oracle