C + + Connect Oracle's OCCI (Windows)

In the previous section we talked about ADO connecting to Oracle, which we tried to connect to the Oracle database under the Windows platform in a Occi way, and the next section discussed connecting the remote Oracle database in a Linux environment by OCCI.

First of all, Oracle C + + callinterface (OCCI) is a set of Oracle's own application programming interfaces that allow C + + programs to interact with one or more Oracle databases, although the OCI is much more difficult to develop, but it is extremely fast, It is also an underlying interface that can manipulate almost any object in an Oracle database.

Environment: Windows7 64bit

Ide:vs 2010

Service side: winserver2008 Oracle 12c

Download the development package:

First download the corresponding Cilent development package on the Oracle website, which contains some necessary library files. Be sure to download the relative version of the client development package. I put my development kit under the D-Drive.

http://download.csdn.net/detail/u012139536/9561994

Occi to access the Oracle database, a few parts of the file: include header files, Lib library files, dll files, in fact, the basic steps are how to find these files.

To get these files, you need to download several packages on the Oracle website:

1:Instant Client package-basic: All files required to run OCI, OCCI, and JDBC-OCI applications

2:Instant Client package-sdk: Additional header files and an example makefile for developing Oracle application S with Instant Client

3:occi interface: Oracle C + + call Interface

Download each of these three packages separately:

1:instant client Package-basic, Instant client package-sdk Two-pack: http://www.oracle.com/technetwork/topics/ Winsoft-085727.html (Other platforms: http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html)

With a version selected, the selected version needs to be higher than the version of the Oracle database, and the versions of the two packages are consistent.

2:occi Interface: http://www.oracle.com/technetwork/database/occidownloads-083553.html

Select a version to match the version of the first two packages. As can be seen from the table in this download page, VS2010 provides a zip package, whereas the previous VS version requires an Oracle client to access the database, so it's much easier to use vs2010, just the appropriate library file.

When the download is complete:

Unzip each of the three packages:

1: Required include header file under Instantclient-sdk-nt-11.2.0.4.0\instantclient_11_2\sdk\include path (Instant Client PACKAGE-SDK package)

The 2:lib file is in the Occi interface package: Oraocci11.lib or Oraocci11d.lib (the Lib file is also available in the SDK package, but the test discovery is not used)

3:dll files in the Occi interface package: Oraocci11.dll or Oraocci11d.dll, and instant Client Package-basic package: Oraociei11.dll, Oci.dll, Orannzsbb11.dll (if Orannzsbb11 not also can, the package of other DLLs, sym, EXE files without the tube, as to the specific role has not yet been studied).

Set Environment variables:

Then set the system variable in the environment variable, advanced system settings, right-click Properties, Computer

Path=d:\instantclient-basic-nt-12.1.0.2.0\instantclient_12_1

Nls_lang=american_america. Zhs16gbk

Configuration VS2010:

Create an empty project first occiconnectoracle

1. Add Library file directory:

Solution Right-occiconnectoracle-> property->c/c++-> General-, add-in directory, inbound directory address: D:\instantclient-sdk-nt-12.1.0.2.0\ Instantclient_12_1\sdk\include

2. Add header file directory:

Additional Library directories, general-----linker, properties, and more: D:\INSTANTCLIENT-SDK-NT-12.1.0.2.0\INSTANTCLIENT_12_1\SDK\LIB\MSVC\VC10

3. Add a library file:

Properties, linker, input, Additional dependencies: Here are oraocci12.lib and oraocci12d.lib two files, which are used when Oraocci12.lib is in release mode and oraocci12d.lib for debug mode.

Code section:

2. /*************************** uses Oracle itself to provide a occi way to operate the database *******************/
6. The purpose of the code is to verify that the Oracle header and Lib file paths in makefile are correct.
8. #include <iostream>
10. #define WIN32COMMON//Avoid function redefinition errors
12. #include <occi.h>
14. Using namespace std;
16. Using namespace Oracle::occi;
22. int main ()
24. {
26. System ("pause");
28. //Create OCCI Context environment
30. Environment *env = environment::createenvironment ();
32. if (NULL = = env) {
34. printf ("Createenvironment error.\n");
36. return-1;
38. }
40. Else
42. cout << "Success" << Endl;
46. String name = "System";
48. String pass = "123";
50. String srvname = "192.168.26.74:1521/ORCL";
54. Try
56. {
58. //Create a database connection
60. Connection *conn = env->createconnection (name, pass, srvname); //username, password, database name
62. if (NULL = = conn) {
64. printf ("CreateConnection error.\n");
66. return-1;
68. }
70. Else
72. cout << "conn Success" << Endl;
76. Data manipulation, creating statement objects
78. Statement *pstmt = NULL; //Statement Object
80. pstmt = Conn->createstatement ();
82. if (NULL = = pstmt) {
84. printf ("createstatement error.\n");
86. return-1;
88. }
92. //Query database time
94. Std::string strtemp;
96. ResultSet *prs = Pstmt->executequery (
98. "Select To_char (sysdate, ' Yyyy-mm-dd HH24:MI:SS ') from DUAL");
100. While (Prs->next ()) {
102. strtemp = prs->getstring (1);
104. printf ("db time:%s.\n", Strtemp.c_str ());
106. //int type value with Getint ()
108. Break ;
110. }
112. Pstmt->closeresultset (PRs);
116. //--------inserting---------
118. //Specify DML as auto-commit
120. Pstmt->setautocommit (TRUE);
122. //Set SQL statement to execute
124. //pstmt->setsql ("INSERT into TA (ID, NAME) VALUES (1, ' ZS ')");
126. Pstmt->setsql ("INSERT into Table_test_wang (NAME, NUM, age) VALUES (' Deng Chao ', ' 99 ', ' 41 ')");
130. //Execute SQL statement
132. unsigned int nret = Pstmt->executeupdate ();
134. if (nret = = 0) {
136. printf ("executeupdate insert error.\n");
138. }
142. //Terminate statement object
144. Conn->terminatestatement (PSTMT);
148. Close connection
150. Env->terminateconnection (conn);
152. //Penv->terminateconnection (Pconn);
154. }
156. catch (SQLException e)
158. {
160. cout << e.what () << Endl;
162. System ("pause");
164. return-1;
166. }
172. Releasing the OCCI context environment
174. Environment::terminateenvironment (env);
176. cout << "end!" << Endl;
178. System ("pause");
180. return 0;
182. }

：

The program displays the upload data successfully, and uses SQL developer to view the database data

You can see that the database already exists and the upload is successful.

C + + Connect Oracle's OCCI (Windows)