otl3_examples.htm

otl是c++数据库封装好的一个数据库接口

<hr style="width: 100%; height: 2px;">
<ul>
  <ul>
&nbsp;
  </ul>
  <li> <a name="MYODBC"></a><b><font size="+1">MyODBC for MySQL</font></b></li>
  <br>
&nbsp;
  <ul>
    <li> <b><a href="otl3_ex78.htm">Example 78 (Simple
Insert/Select/Update, MyODBC 2.50)</a></b></li>
    <li> <b><a href="otl3_ex79.htm">Example 79 ("Incompatible
datatypes
in stream operation" exception, MyODBC 2.50)</a></b></li>
    <li> <b><a href="otl3_ex80.htm">Example 80 (otl_datetime container
and datetime/date table columns, MyODBC 2.50)</a></b></li>
    <li> <b><a href="otl3_ex81.htm">Example 81 (otl_long_string
container and LONGTEXT column, MyODBC 2.50)</a></b></li>
    <li> <b><a href="otl3_ex82.htm">Example 82 (otl_long_string
container and LONGBLOB column, MyODBC 2.50)</a></b></li>
    <li> <b><a href="otl3_ex83.htm">Example 83 (std::string and
STL-compliant stream iterators, MyODBC 2.50)</a></b></li>
    <li> <b><a href="otl3_ex84.htm">Example 84
(otl_stream::describe_select() with a simple Select, MyODBC 2.50)</a></b></li>
    <br>
&nbsp; <li> <a name="MyODBC35"></a><b><a href="otl3_ex225.htm">Example
225 (Simple Insert/Select/Update, MyODBC 3.50)</a></b></li>
    <li> <b><a href="otl3_ex226.htm">Example 226 ("Incompatible
datatypes in stream operation" exception, MyODBC 3.50)</a></b></li>
    <li> <b><a href="otl3_ex227.htm">Example 227 (otl_datetime
container and datetime/date table columns, MyODBC 3.50)</a></b></li>
    <li> <b><a href="otl3_ex228.htm">Example 228 (otl_long_string
container and LONGTEXT column, MyODBC 3.50)</a></b></li>
    <li> <b><a href="otl3_ex229.htm">Example 229 (otl_long_string
container and LONGBLOB column, MyODBC 3.50)</a></b></li>
    <li> <b><a href="otl3_ex230.htm">Example 230 (std::string and
STL-compliant stream iterators, MyODBC 3.50)</a></b></li>
    <li> <b><a href="otl3_ex231.htm">Example 231
(otl_stream::describe_select() with a simple Select, MyODBC 3.50)</a></b></li>
  </ul>
</ul>
<b><br>
</b>
<hr style="width: 100%; height: 2px;"><b></b>
<ul>
  <li> <a name="DB2_CLI"></a><b><font size="+1">DB2 Call Level
Interface (CLI)</font></b></li>
  <br>
&nbsp;
  <ul>
    <li> <b><a href="otl3_ex89.htm">Example 89 (Simple
Insert/Select/Update)</a></b></li>
    <li> <b><a href="otl3_ex90.htm">Example 90 ("Incompatible
datatypes
in stream operation" exception)</a></b></li>
    <li> <b><a href="otl3_ex91.htm">Example 91 (otl_datetime container
and DATE/TIME/TIMESTAMP table columns)</a></b></li>
    <li> <b><a href="otl3_ex92.htm">Example 92 (otl_long_string
container and CLOB column)</a></b></li>
    <li> <b><a href="otl3_ex93.htm">Example 93 (otl_long_string
container and BLOB column)</a></b></li>
    <li> <b><a href="otl3_ex94.htm">Example 94 (std::string and
STL-compliant stream iterators)</a></b></li>
    <li> <b><a href="otl3_ex95.htm">Example 95
(otl_stream::describe_select() with a simple Select)</a></b></li>
    <li> <b><a href="otl3_ex96.htm">Example 96 (otl_stream and NULLs)</a></b></li>
  </ul>
</ul>
<b><br>
</b>
<hr style="width: 100%; height: 2px;"><b></b>
<ul>
  <li> <a name="INTERBASE"></a><b><font size="+1"><a
 href="http://firebird.sourceforge.net/">FireBird Database / ODBC</a><a
 href="http://www.xtgsystems.com/ib6odbc.php3"></a></font></b></li>
</ul>
<ul>
  <ul>
    <li> <b><a href="otl4_ex133.htm">Example 133 (Simple
Insert/Select/Update)</a></b></li>
    <li> <b><a href="otl4_ex134.htm">Example 134 ("Incompatible
datatypes in stream operation" exception)</a></b></li>
    <li> <b><a href="otl4_ex135.htm">Example 135 (otl_datetime
container and DATE/TIME/TIMESTAMP&nbsp; table columns)</a></b></li>
    <li> <b><a href="otl4_ex136.htm">Example 136 (otl_long_string
container and a BLOB column)</a></b></li>
    <li> <b><a href="otl4_ex137.htm">Example 137 (std::string and
STL-compliant stream iterators)</a></b></li>
    <li> <b><a href="otl4_ex138.htm">Example 138
(otl_stream::describe_select() with a simple Select)</a></b></li>
    <li> <b><a href="otl4_ex139.htm">Example 139 (otl_stream and NULLs)</a></b></li>
  </ul>
</ul>
<b><br>
</b>
<hr style="width: 100%; height: 2px;"><b></b>
<ul>
  <li> <a name="POSTGRESQL"></a><b><font size="+1"><a
 href="http://www.postgresql.org">PostgreSQL</a> / <a
 href="http://odbc.postgresql.org">PostgreSQL ODBC</a></font></b></li>
</ul>
<ul>
  <ul>
    <li> <b><a href="otl4_ex140.htm">Example 140 (Simple
Insert/Select/Update)</a></b></li>
    <li> <b><a href="otl4_ex141.htm">Example 141 ("Incompatible
datatypes in stream operation" exception)</a></b></li>
    <li> <b><a href="otl4_ex142.htm">Example 142 (otl_datetime
container and DATE/TIME/TIMESTAMP&nbsp; table columns)</a></b></li>
    <li> <b><a href="otl4_ex143.htm">Example 143 (otl_long_string
container and a TEXT column)</a></b></li>
    <li> <b><a href="otl4_ex144.htm">Example 144 (std::string and
STL-compliant stream iterators)</a></b></li>
    <li> <b><a href="otl4_ex145.htm">Example 145
(otl_stream::describe_select() with a simple Select)</a></b></li>
    <li> <b><a href="otl4_ex146.htm">Example 146 (otl_stream and NULLs)</a></b></li>
  </ul>
</ul>
<b><br>
</b>
<hr style="width: 100%; height: 2px;"><b></b>
<ul>
  <ul>
&nbsp;
  </ul>
</ul>
<ul>
  <li> <b><font size="+1">Miscellaneous</font></b></li>
&nbsp;
  <ul>
    <li> <b><a href="otl3_ex35.htm">Example 35 (otl_nocommit_stream in
Oracle 7)</a></b></li>
    <li> <b><a href="otl3_ex36.htm">Example 36 (otl_nocommit_stream in
Oracle 8)</a></b></li>
    <li> <b><a href="otl3_ex37.htm">Example 37 (otl_nocommit_stream in
ODBC)</a></b></li>
    <br>
&nbsp; <li> <b><a href="otl3_ex38.htm">Examle 38 (otl_datetime in
Oracle 7)</a></b></li>
    <li> <b><a href="otl3_ex39.htm">Examle 39 (otl_datetime in Oracle
8)</a></b></li>
    <li> <b><a href="otl3_ex40.htm">Examle 40 (otl_datetime in ODBC)</a></b></li>
    <br>
&nbsp; <li> <b><a href="otl3_ex41.htm">Example 41
(Insert/Update/Select with CLOB in Oracle 8)</a></b></li>
    <li> <b><a href="otl3_ex42.htm">Example 42 (ODBC, OCI: LONG ==&gt;
CLOB. How to use OTL namespaces)</a></b></li>
    <br>
&nbsp; <li> <b><a href="otl3_ex43.htm">Example 43 (Get Rows Processed
Count in Oracle 7)</a></b></li>
    <li> <b><a href="otl3_ex44.htm">Example 44 (Get Rows Processed
Count in Oracle 8)</a></b></li>
    <li> <b><a href="otl3_ex45.htm">Example 45 (Get Rows Processed
Count in ODBC)</a></b></li>
    <br>
&nbsp; <li> <b><a href="otl3_ex46.htm">Example 46 ("Auto-commit every
SQL statement / commit-on-success" mode in Oracle 7)</a></b></li>
    <li> <b><a href="otl3_ex47.htm">Example 47 ("Auto-commit every SQL
statement / commit-on-sucess" mode in Oracle 8)</a></b></li>
    <li> <b><a href="otl3_ex48.htm">Example 48 ("Auto-commit every SQL
statement / commit-on-sucess" mode in ODBC)</a></b></li>
    <br>
&nbsp; <li> <b><a href="otl3_ex49.htm">Example 49 (PL/SQL tables as
parameters, Oracle 7)</a></b></li>
    <li> <b><a href="otl3_ex50.htm">Example 50 (PL/SQL tables as
parameters, Oracle 8)</a></b></li>
    <li> <b><a href="otl3_ex51.htm">Example 51 (PL/SQL table of DATEs
as parameter, Oracle 7)</a></b></li>
    <li> <b><a href="otl3_ex52.htm">Example 52 (PL/SQL table of DATEs
as parameter, Oracle 8)</a></b></li>
    <br>
&nbsp; <li> <b><a href="otl3_ex53.htm">Example 53 (Datatype override
in SELECT, Oracle 7)</a></b></li>
    <li> <b><a href="otl3_ex54.htm">Example 54 (Datatype override in
SELECT, Oracle 8)</a></b></li>
    <li> <b><a href="otl3_ex55.htm">Example 55 (Datatype override in
SELECT, MS SQL Server)</a></b></li>
    <br>
&nbsp; <li> <b><a href="otl3_ex56.htm">Example 56
(Insert/Update/Select with Oracle 8 CLOB in stream mode)</a></b></li>
    <li> <b><a href="otl3_ex57.htm">Example 57 (Insert/Update/Select
with Oracle 8 BLOB in stream mode)</a></b></li>
    <br>
&nbsp; <li> <b><a href="otl3_ex58.htm">Example 58 (Using OTL/OCI7 in
Pro*C/C++ environment)</a></b></li>
    <li> <b><a href="otl3_ex59.htm">Example 59 (Using OTL/OCI8 in
Pro*C/C++ environment)</a></b></li>
    <br>
&nbsp; <li> <b><a href="otl3_ex60.htm">Example 60 (Using OTL/OCI8:
server_attach/detach and session_begin/end)</a></b></li>
    <li> <b><a href="otl3_ex61.htm">Example 61 (Using OTL/OCI8:
server_attach/detach, session_begin/end, and session_reopen)</a></b></li>
    <br>
&nbsp; <li> <b><a href="otl3_ex65.htm">Example 65 (Simple
Insert/Select and otl_stream::clean() function for Oracle 7)</a></b></li>
    <li> <b><a href="otl3_ex66.htm">Example 66 (Simple Insert/Select
and otl_stream::clean() function for Oracle 8/8i)</a></b></li>
    <li> <b><a href="otl3_ex67.htm">Example 67 (Simple Insert/Select
and otl_stream::clean() function for OTL/ODBC and MS SQL Server)</a></b></li>
    <br>
&nbsp; <li> <b><a href="otl3_ex68.htm">Example 68 (Dynamically
allocated PL/SQL tables as parameters, Oracle 7)</a></b></li>
    <li> <b><a href="otl3_ex69.htm">Example 69 (Dynamically allocated
PL/SQL tables as parameters, Oracle 8)</a></b></li>
    <li> <b><a href="otl3_ex70.htm">Example 70 (Dynamically allocated
PL/SQL table of DATEs as parameter, Oracle 7)</a></b></li>
    <li> <b><a href="otl3_ex71.htm">Example 71 (Dynamically allocated
PL/SQL table of DATEs as parameter, Oracle 8)</a></b></li>
    <br>
&nbsp; <li> <b><a href="otl3_ex72.htm">Example 72 (STL std::strings,
ANSI C++ typecasts, Oracle 7)</a></b></li>
    <li> <b><a href="otl3_ex73.htm">Example 73 (STL std::strings, ANSI
C++ typecasts, Oracle 8)</a></b></li>
    <li> <b><a href="otl3_ex74.htm">Example 74 (STL std::strings, ANSI
C++ typecasts, MS SQL Server)</a></b></li>
    <br>
&nbsp; <li> <b><a href="otl3_ex75.htm">Example 75 (STL-compliant OTL
stream iterators, Oracle 7)</a></b></li>
    <li> <b><a href="otl3_ex76.htm">Example 76 (STL-compliant OTL
stream iterators, Oracle 8)</a></b></li>
    <li> <b><a href="otl3_ex77.htm">Example 77 (STL-compliant OTL/ODBC
stream iterators, MS SQL Server)</a></b></li>
    <br>
&nbsp; <li> <b><a href="otl3_ex85.htm">Example 85 (STL vector based
PL/SQL tables as parameters, Oracle 7)</a></b></li>
    <li> <b><a href="otl3_ex86.htm">Example 86 (STL vector based
PL/SQL
tables as parameters, Oracle 8)</a></b></li>
    <li> <b><a href="otl3_ex87.htm">Example 87 (STL vector based
PL/SQL
table of DATEs as parameter, Oracle 7)</a></b></li>
    <li> <b><a href="otl3_ex88.htm">Example 88 (STL vector based
PL/SQL
table of DATEs as parameter, Oracle 8)</a></b></li>
    <br>
&nbsp; <li> <b><a href="otl3_ex97.htm">Example 97
(otl_value&lt;T&gt;,
Oracle 7)</a></b></li>
    <li> <b><a href="otl3_ex98.htm">Example 98 (otl_value&lt;T&gt;,
Oracle 8/8i)</a></b></li>
    <li> <b><a href="otl3_ex99.htm">Example 99 (otl_value&lt;T&gt;,
ODBC / MS SQL Server)</a></b></li>
    <li> <b><a href="otl3_ex100.htm">Example 100 (otl_value&lt;T&gt;,
DB2-CLI)</a></b></li>
    <br>
&nbsp; <li> <b><a href="otl3_ex101.htm">Example 101 (#define
OTL_UNCAUGHT_EXCEPTION_ON, Oracle 7)</a></b></li>
    <li> <b><a href="otl3_ex102.htm">Example 102 (#define
OTL_UNCAUGHT_EXCEPTION_ON, Oracle 8/8i)</a></b></li>
    <li> <b><a href="otl3_ex103.htm">Example 103 (#define
OTL_UNCAUGHT_EXCEPTION_ON, ODBC / MS SQL Server)</a></b></li>
    <br>
&nbsp; <li> <b><a href="otl3_ex104.htm">Example 104 (#define
OTL_EXTENDED_EXCEPTION, ODBC / MS SQL Server)</a></b></li>
    <li> <b><a href="otl3_ex105.htm">Example 105 (OTL/ODBC and MS SQL
Server's GUIDs)</a></b></li>
    <br>
&nbsp; <li> <b><a href="otl3_ex106.htm">Example 106 (OTL/ODBC and
bulk
operations with Oracle's LONG)</a></b></li>
    <li> <b><a href="otl3_ex107.htm">Example 107 (OTL/ODBC and bulk
operations with Oracle's CLOB)</a></b></li>
    <li> <b><a href="otl3_ex108.htm">Example 108 (OTL/ODBC and bulk
operations with MS SQL Server's TEXT)</a></b></li>
    <li> <b><a href="otl3_ex109.htm">Example 109 (OTL/DB2-CLI and bulk
operations with DB2's CLOB)</a></b></li>
    <br>
&nbsp; <li> <b><a href="otl3_ex110.htm">Example 110 (Group data type
override in SELECT, Oracle 7)</a></b></li>
    <li> <b><a href="otl3_ex111.htm">Example 111 (Group data type
override in SELECT, Oracle 8/8i)</a></b></li>
    <li> <b><a href="otl3_ex112.htm">Example 112 (Group data type
override in SELECT, MS SQL Server)</a></b></li>
    <br>
&nbsp; <li> <b><a href="otl3_ex113.htm">Example 113 (OTL stream
pooling, Oracle 8/8i)</a></b></li>
    <li> <b><a href="otl3_ex114.htm">Example 114 (OTL stream pooling,
OTL/ODBC)</a></b></li>
    <li> <b><a href="otl3_ex115.htm">Example 115 (OTL stream pooling,
DB2-CLI)</a></b></li>
    <br>
&nbsp; <li> <b><a href="otl3_ex116.htm">Example 116
(otl_stream::set_flush(), Oracle 8/8i)</a></b></li>
    <li> <b><a href="otl3_ex117.htm">Example 117
(otl_stream::set_flush(), OTL/ODBC)</a></b></li>