Use OCCI to connect to Oracle databases in Linux

OCCI(Oracle C ++ Call Interface):C ++Program andOracleThe database implements interactive application interfaces, which are provided to users in the form of dynamic connection libraries.OCCIPairOCIImplements object-level encapsulation, and its underlying layer is stillOCI

OCCIConnectionLinuxUnderOracleDatabase:

1InstallLinuxUnderOracleClient

2Download the correspondingOracle-instantclient-basic-10.2.0.4-1.i386.zipCopy itLinuxOfOracleAnd decompress itInstantclient_10_2Directory

ImplementationOCCISix steps:

1Create Environment VariablesEnvironment

2Create a connection objectConnection

3CreateSQLStatement execution objectStatement

4RunSQLStatement (Execute() Function,ExecuteUpdate ()Function,ExecuteQuery() Function)

5Processing result setResultSet(Query results)

6Close connection

 

InLinuxOfOracleCreate a table under the database for operations

Create table user_info

(

User_id int not null primary key,

User_name varchar2 (100)

);

 

 

1. // AddOcci. cc
2. # Include <iostream>
3. # Include <string>
4. # Include "occi. h"
5. Using NamespaceStd;
6. Using NamespaceOracle: occi;
8. /******************************* 
9. * Add a record to the database 
10. *******************************/
12. IntMain ()
13. {
14. // Create an environment variable
15. // Environment
16. Environment * env = Environment: createEnvironment (Environment: OBJECT );
18. // Username is the username of oracle
19. // Userpass is the oracle Password
20. // Connstr is the connection string of oracle.
21. String username ="Hahaya";
22. String userpass ="Hahaya";
23. String connstr =& Quot; 192.168.0.6: 1521/orcl & quot";
24. // Create a connection
25. // Connection
26. Connection * conn = env-> createConnection (username, userpass, connstr );
28. If(Conn = NULL)
29. {
30. Cout <"Access oracle failed ..."<Endl;
31. Return0;
32. }
34. // Create an SQL statement execution object
35. // Statement
36. Statement * st = conn-> createStatement ();
37. St-> setSQL ("Insert into user_info values (1, 'hahaay ')");
38. St-> executeUpdate ();
40. // Close the connection
41. Env-> terminateConnection (conn );
42. Environment: terminateEnvironment (env );
44. Return0;
45. }

1 2 Next Page