一、编写代码
注:以下代码来自OTL示例
文本查看复制代码打印关于
# /*
# *otl_test.cpp
# *
# */
#include <iostream>
using namespace std;
#include <cstdio>
#define OTL_ORA10G_R2 // Compile OTL4.0/OCI10gR2
#include <otlv4.h> // include the OTL4.0 header file
otl_connect db; // connect object
void insert()
// insert rows into table
{
otl_stream o(50, // buffer size
"insert into test_tabvalues(:f1<int>,:f2<char[31]>)",
// SQL statement
db // connect object
);
o.set_commit(0); // turn off stream's "auto-commit"
char tmp[32];
for (int i = 1; i <= 123; ++i) {
sprintf(tmp, "Name%d", i);
o << i << tmp;
}
o.flush(); // flush the stream's dirty buffer:
// execute the INSERT for the rows
// that are still in the stream buffer
db.commit_nowait(); // commit with no wait (new feature of Oracle10.2)
}
void select() {
otl_stream i(50, // buffer size
"select * from test_tab where f1>=:f<int> andf1<=:f*2",
// SELECT statement
db // connect object
);
// create select stream
float f1;
char f2[31];
i<< 8; // assigning :f = 8
// SELECT automatically executes when all input variables are
// assigned. First portion of output rows is fetched to the buffer
while (!i.eof()) { // while not end-of-data
i >> f1 >> f2;
cout << "f1=" << f1 << ", f2="<< f2 << endl;
}
i<< 4; // assigning :f = 4
// SELECT automatically executes when all input variables are
// assigned. First portion of output rows is fetched to the buffer
while (!i.eof()) { // while not end-of-data
i >> f1 >> f2;
cout << "f1=" << f1 << ", f2="<< f2 << endl;
}
}
int main() {
otl_connect::otl_initialize(); // initialize OCI environment
try {
db.rlogon("xuanyuan/xuanyuan"); // connect to Oracle
otl_cursor::direct_exec(db, "drop table test_tab",
otl_exception::disabled //disable OTL exceptions
); // drop table
otl_cursor::direct_exec(db,
"create table test_tab(f1number, f2 varchar2(30))"); // create table
insert(); // insert records into table
select(); // select records from table
}
catch (otl_exception& p) { // intercept OTL exceptions
cerr << p.msg << endl; // print out error message
cerr << p.stm_text << endl; // print out SQL that caused theerror
cerr << p.var_info << endl;// print out the variable that caused the error
}
db.logoff(); // disconnect from Oracle
return 0;
}
二、编译代码
g++ -o"otl_test" otl_test.cpp-lclntsh -I"$ORACLE_HOME/rdbms/public"
三、运行程序otl_test
$ ./otl_test
结果如下:
f1=8, f2=Name8
f1=9, f2=Name9
f1=10, f2=Name10
f1=11, f2=Name11
f1=12, f2=Name12
f1=13, f2=Name13
f1=14, f2=Name14
f1=15, f2=Name15
f1=16, f2=Name16
f1=4, f2=Name4
f1=5, f2=Name5
f1=6, f2=Name6
f1=7, f2=Name7
f1=8, f2=Name8