📄 query_exampl.html
字号:
<html>
<head>
<meta name="KEYWORDS" content="
library, C++,
Oracle, SQLServer, DB2, Sybase, Informix, InterBase, SQLBase, ODBC,
SQL, server, client, database, programming, development, software,
Win32, Windows, Linux, Unix, Solaris,
Microsoft, Borland, Centura, Gupta, IBM">
<meta name="DESCRIPTION" content="SQLAPI++ is C++ library for accessing SQL databases (Oracle, SQLServer, Sybase, DB2, InterBase, SQLBase, Informix, ODBC).
It uses native APIs, provides low-level access to database-specific features.">
<title>SQLAPI++ Library - How To - Query examples</title>
</head>
<body bgcolor="#ffffff" BACKGROUND="../images/bg.gif" text="#000000"><!--class="GlbHdr"-->
<table WIDTH="600" height="40" frame="hsides" BORDER="2" BORDERCOLOR="#004fcd" align="right" cellpadding="0" cellspacing="2" id="TABLE1">
<tr><!--class="GlbDefault"-->
<td width="70" bgcolor="#000094" bordercolor="black" align="middle"><a href="../index.html" style="TEXT-DECORATION: none">
<font color="white" size="3" face="sans-serif">
<b>Home</b></font></a></td></td>
<!--class="GlbActive"-->
<td width="70" bgcolor="#00bb00" bordercolor="black" align="middle"><a href="../HowTo/index.html" style="TEXT-DECORATION: none">
<font color="white" size="3" face="sans-serif">
<b>How To</b></font></a></td>
<!--class="GlbDefault"-->
<td width="70" bgcolor="#000094" bordercolor="black" align="middle"><a href="../OnLineDoc/index.html" style="TEXT-DECORATION: none">
<font color="white" size="3" face="sans-serif">
<b>Online Documentation</b></font></a></td><!--class="GlbDefault"-->
<td width="70" bgcolor="#000094" bordercolor="black" align="middle"><a href="../Support/index.html" style="TEXT-DECORATION: none">
<font color="white" size="3" face="sans-serif">
<b>Support</b></font></a></td>
<td width="70" bgcolor="#000094" bordercolor="black" align="middle"><a href="../Download/index.html" style="TEXT-DECORATION: none">
<font color="white" size="3" face="sans-serif">
<b>Download</b></font></a></td>
<td width="70" bgcolor="#000094" bordercolor="black" align="middle"><a href="../Order/index.html" style="TEXT-DECORATION: none">
<font color="white" size="3" face="sans-serif">
<b>Order</b></font></a></td>
</tr>
</table>
<p> </p>
<p> </p>
<table width="100%" cellpadding="1" cellspacing="1">
<tr>
<td valign="top" align="left"><!--class="LeftMenu"-->
<table frame="void" CELLSPACING="2" cellpadding="2" width="165">
<tr>
<td><img align="middle" src="../images/green.gif" WIDTH="12" HEIGHT="12">
<a href="connect.html" style="TEXT-DECORATION: none">
<font color="white" size="2" face="sans-serif">
Connecting to databases</font></a> </td>
</tr>
<tr>
<td><img align="middle" src="../images/green.gif" WIDTH="12" HEIGHT="12">
<a href="transactions.html" style="TEXT-DECORATION: none">
<font color="white" face="sans-serif" size="2">
Transactions</font></a> </td>
</tr>
<tr>
<td><img align="middle" src="../images/green.gif" WIDTH="12" HEIGHT="12">
<a href="commands.html" style="TEXT-DECORATION: none">
<font color="white" size="2" face="sans-serif">
Executing an SQL command</a> </font> </td>
</tr>
<tr>
<td><img align="middle" src="../images/green.gif" WIDTH="12" HEIGHT="12">
<a href="procedures.html" style="TEXT-DECORATION: none">
<font color="white" size="2" face="sans-serif">
Executing stored procedures</a>
</font> </td>
</tr>
<tr>
<td><img align="middle" src="../images/green.gif" WIDTH="12" HEIGHT="12">
<a href="bind.html" style="TEXT-DECORATION: none">
<font color="white" size="2" face="sans-serif">
Binding input parameters</a> </font> </td>
</tr>
<tr>
<td><img align="middle" src="../images/green.gif" WIDTH="12" HEIGHT="12" alt border="0" hspace="0" style="HEIGHT: 12px; WIDTH: 12px" useMap>
<a href="fetch.html" style="TEXT-DECORATION: none">
<font color="white" size="2" face="sans-serif">
Fetching result set</a> </font> </td>
</tr>
<tr>
<td><img align="middle" src="../images/green.gif" WIDTH="12" HEIGHT="12">
<a href="fetch_multiple.html" style="TEXT-DECORATION: none">
<font color="white" size="2" face="sans-serif">
Fetching multiple result sets</a> </font> </td>
</tr>
<tr>
<td><img align="middle" src="../images/green.gif" WIDTH="12" HEIGHT="12">
<a href="performance.html" style="TEXT-DECORATION: none">
<font color="white" size="2" face="sans-serif">
Optimizing Database Performance</a> </font> </td>
</tr>
<tr>
<td><img align="middle" src="../images/green.gif" WIDTH="12" HEIGHT="12" alt border="0" hspace="0" style="HEIGHT: 12px; WIDTH: 12px" useMap>
<a href="return_param.html" style="TEXT-DECORATION: none">
<font color="white" size="2" face="sans-serif">
Returning output parameters</a> </font> </td>
</tr>
<tr>
<td><img align="middle" src="../images/green.gif" WIDTH="12" HEIGHT="12" alt border="0" hspace="0" style="HEIGHT: 12px; WIDTH: 12px" useMap>
<a href="blobs.html" style="TEXT-DECORATION: none">
<font color="white" size="2" face="sans-serif">
Working with
Long or Lob(CLob, BLob) Data</a> </font> </td>
</tr>
<tr>
<td><img align="middle" src="../images/green.gif" WIDTH="12" HEIGHT="12"><a href="datetime.html" style="TEXT-DECORATION: none">
<font color="white" size="2" face="sans-serif">
Working with date/time values</a> </font> </td>
</tr>
<tr>
<td><img align="middle" src="../images/green.gif" WIDTH="12" HEIGHT="12" alt border="0" hspace="0" style="HEIGHT: 12px; WIDTH: 12px" useMap>
<a href="errors.html" style="TEXT-DECORATION: none">
<font color="white" size="2" face="sans-serif">
Error handling</a> </font> </td>
</tr>
<tr>
<td><img align="middle" src="../images/red.gif" WIDTH="12" HEIGHT="12">
<a href="query_exampl.html" style="TEXT-DECORATION: none">
<font color="white" size="2" face="sans-serif">
Query examples</a> </font> </td>
</tr>
</table>
</td>
<td width="30">
<p> </p>
</td>
<td valign="top">
<center>
<h1>Query Examples</h1>
<h3 align="left">Steps</h3>
</center>
<p>
<a href="../Examples/step1.cpp">Step 1</a>.
<strong>Connecting to
database (and error handling)</strong><br>
This step shows how to connect
to/disconnect from databases using the Library. It also shows how to
handle errors.<br>
<a href="../Examples/step2.cpp">Step 2</a>.
<strong>Executing a simple
SQL command</strong><br>
This step show the example of executing a simple
query without any parameters and result set.<br>
<a href="../Examples/step3.cpp">Step 3</a>.
<strong>Binding input parameters</strong><br>
This step shows 2 methods for providing input
parameters in SQLAPI++: direct assignment
and stream-based.<br>
<a href="../Examples/step4.cpp">Step 4.</a>
<strong>Executing a select
query (and fetching result set)</strong><br>
This step shows how
to process result set using SQLAPI++.<br>
<a href="../Examples/step5.cpp">Step 5.</a>
<strong>Binding LongBinary, LongChar, BLob and CLob data</strong><br>
This step shows 2 methods for binding Long or Lob data: traditional
(bind all the data in one piece) and piecewise (using user defined
callbacks for providing data).<br>
<a href="../Examples/step6.cpp">Step 6.</a>
<strong>Fetching LongBinary, LongChar, BLob and CLob data</strong><br>
This step shows 2 methods for
fetching Long or Lob data: traditional (read all the data in one
piece) and piecewise (using user defined callbacks for reading
data).<br>
<a href="../Examples/step7.cpp">Step 7.</a>
<strong> Multithreading support and cancelling queries</strong><br>
This step shows how to create a thread with long
running query.
</p>
<h3>Advanced examples</h3>
<p><a href="../Examples/refcursors.cpp">Using Oracle REF CURSORs</a>.
This example demonstrates how to get Oracle
REF CURSORs from a stored procedure and than fetch it using SQLAPI++
Library. <br>
<a href="../Examples/nestedcursors.cpp">Using Oracle nested cursors</a>.
This example shows how SQLAPI++ handles queries with
nested cursors.
</p>
<h3>Problems and Questions</h3>
<p>If you haven't found the answer to your questions or have some problems on
using the Library, please, send e-mail to <a href="mailto:howto@sqlapi.com">howto@sqlapi.com</a>. </p>
<p> </p>
</td>
<tr></tr>
</table></font>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -