diff options
Diffstat (limited to 'site/trunk/site-publish/rdb-das-c-workingwithbasiccrud.html')
| -rw-r--r-- | site/trunk/site-publish/rdb-das-c-workingwithbasiccrud.html | 123 |
1 files changed, 123 insertions, 0 deletions
diff --git a/site/trunk/site-publish/rdb-das-c-workingwithbasiccrud.html b/site/trunk/site-publish/rdb-das-c-workingwithbasiccrud.html new file mode 100644 index 0000000000..c71c124c83 --- /dev/null +++ b/site/trunk/site-publish/rdb-das-c-workingwithbasiccrud.html @@ -0,0 +1,123 @@ + +<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> +<HTML> + <HEAD> + <LINK type="text/css" rel="stylesheet" href="http://incubator.apache.org/tuscany/stylesheets/default.css"> + <LINK rel="SHORTCUT ICON" href="http://cwiki.apache.org/confluence/pages/$images/favicon.ico"> + <TITLE>RDB DAS C++ - WorkingWithBasicCrud : Apache Tuscany</TITLE> + <META http-equiv="Content-Type" content="text/html;charset=UTF-8"></HEAD> + + <BODY onload="init()"> + + <TABLE valign="top" border="0" cellspacing="0" cellpadding="0" width="100%" background="http://incubator.apache.org/tuscany/images/TuscanyLogoNEW_Text_120px_bg.jpg"> + <TR> + <TD valing="top" align="left"> + <A href="http://cwiki.apache.org/confluence/pages/$siteroot"><IMG src="http://incubator.apache.org/tuscany/images/TuscanyLogoNEW_Text_120px_bg.jpg" height="91" width="25" border="0"></A> + </TD> + <TD> + <A href="http://incubator.apache.org/tuscany/"><IMG src="http://incubator.apache.org/tuscany/images/TuscanyLogo.jpg" border="0"></A> + </TD> + + <TD width="100%"> + + </TD> + <TD align="right"> + <IMG src="http://incubator.apache.org/tuscany/images/apache-incubator-logo.png" border="0"> + </TD> + + <!-- Adds the edit page link to the top banner--> + <TD valign="bottom"> + <DIV style="padding: 2px 10px; margin: 0px;"> + <A href="http://cwiki.apache.org/confluence/pages/editpage.action?pageId=69479"> + <IMG src="http://incubator.apache.org/tuscany/images/notep_16.gif" height="16" width="16" border="0" align="absmiddle" title="Edit Page"></A> + </DIV> + </TD> + + </TR> + </TABLE> + + <TABLE border="0" cellpadding="2" cellspacing="0" width="100%"> + <TR class="topBar"> + <TD align="left" valign="middle" class="topBarDiv" nowrap="true" width="100%"> + <A href="home.html" title="Apache Tuscany">Apache Tuscany</A> > <A href="home.html" title="Home">Home</A> > <A href="das-overview.html" title="DAS Overview">DAS Overview</A> > <A href="das-c.html" title="DAS C++">DAS C++</A> > <A href="das-c-documentation-menu.html" title="DAS C++ Documentation Menu">DAS C++ Documentation Menu</A> > <A href="rdb-das-c-user-guide.html" title="RDB DAS C++ - User Guide">RDB DAS C++ - User Guide</A> > <A href="" title="RDB DAS C++ - WorkingWithBasicCrud">RDB DAS C++ - WorkingWithBasicCrud</A> + </TD> + + <TD align="left" valign="middle" class="topBarDiv" nowrap="true"> + <A href="http://mail-archives.apache.org/mod_mbox/ws-tuscany-user">User List</A> | <A href="http://mail-archives.apache.org/mod_mbox/ws-tuscany-dev">Dev List</A> | <A href="http://issues.apache.org/jira/browse/Tuscany">Issue Tracker</A> + </TD> + </TR> + </TABLE> + + <TABLE border="0" cellpadding="0" width="100%" bgcolor="#FFFFFF"> + <TR> + <TD align="left" valign="top"> + <DIV id="PageContent"> + + <DIV class="pagecontent"> + <DIV class="wiki-content"> + <H1><A name="RDBDASC%2B%2B-WorkingWithBasicCrud-WorkingWithBasicCrud"></A>WorkingWithBasicCrud</H1> + +<P>The RDB DAS provides a simple, command-oriented approach for reading and writing to the database.</P> + +<H3><A name="RDBDASC%2B%2B-WorkingWithBasicCrud-Asimpleread"></A>A simple read</H3> + +<P>The following illustrates the simplest possible read:</P> +<DIV class="panel"><DIV class="panelContent"> +<P> DASImpl* das = (DASImpl*) DASImpl::getFactory().createDAS(getConnection());<BR> + CommandPtr readCustomers = das->createCommand("select * from CUSTOMER where ID = 22590");<BR> + DataObjectPtr root = readCustomers->executeQuery();</P> +</DIV></DIV> +<P>The first line creates an instance of the DAS that is primed with a given ODBC Connection object. The Connection can be procured in a number of different ways. This example is from the RDB DAS test suite and the implentation of getConnection() create a Connection object using a DSN string.</P> + + +<P>The second line uses the das instance as a factory to create a Command instance from the provided SQL SELECT string. The third line executes the command which returns a "root" SDO DataObject. This root DataObject is sometimes referred to as a "dummy" root and acts as a container for the graph of data returned from the query. The RDB DAS always returns a dummy root from executing a query.</P> + +<P>Once we have a handle to the root we can pull information from the returned customer object using the dynamic SDO apis like this:</P> +<DIV class="panel"><DIV class="panelContent"> +<P> DataObjectPtr cust = root->getDataObject("CUSTOMER[1]");<BR> + wstring name = cust->getCString("LASTNAME");</P> +</DIV></DIV> +<P>The first line retreives the first Customer from the root's list of returned Customers (since we queried by ID, thereis only one). The second line pulls the LASTNAME value from the customer.</P> + +<H3><A name="RDBDASC%2B%2B-WorkingWithBasicCrud-Asimplewrite"></A>A simple write</H3> + +<P>The DAS leverages the SDO Change Summary to provide a very simple mechanism to flush data changes back to the database. We can illustrate this by continuing the previous example:</P> +<DIV class="panel"><DIV class="panelContent"> +<P> customer->setCString("LASTNAME", "Pavick");<BR> + das->applyChanges(root);</P> +</DIV></DIV> +<P>The first line uses the SDO dynamic APIs to change the LASTNAME property of the Customer instance and the second line directs the das to flush graph changes back to the database. At this point, the das scans the SDO ChangeSummary and generates the required UPDATE statement necessary to synchronize this change with the database.</P> + +<P>Although this simple example demonstrates a single property change to a single object, the das will process any numbers of changes made to any number of objects in a graph. Even if we read 1000 customers from the database and made several changes to each, flushing those changes back to the database is still just one call to das->applyChanges().</P> + +<H3><A name="RDBDASC%2B%2B-WorkingWithBasicCrud-Awritecommmand"></A>A write commmand</H3> + +<P>Writes to the database can also be done without using the change summary. To do this, we simply use the das instance as a factory to create a command initialized with a CREATE/UPDATE or DELETE statement.</P> +<DIV class="panel"><DIV class="panelContent"> +<P> DASImpl* das = (DASImpl*) DASImpl::getFactory().createDAS(getConnection());<BR> + CommandPtr insert = das->createCommand("insert into CUSTOMER values (10, 'Williams', '5555 Maine Ave.')");<BR> + insert->executeQuery();</P> +</DIV></DIV> +<P>Although allowing the das to generate write statements from the change summary is recommended, this low level ability to execute aribtrary SQL is another option. </P> + </DIV> + </DIV> + </DIV> + </TD> + </TR> + </TABLE> + + <SCRIPT src="http://www.google-analytics.com/urchin.js" type="text/javascript"> + </SCRIPT> + <SCRIPT type="text/javascript"> + _uacct = "UA-1174707-5"; + urchinTracker(); + </SCRIPT> + + <A href="http://www.statcounter.com/" target="_blank"><IMG src="http://c26.statcounter.com/counter.php?sc_project=2619156&java=0&security=94bd7e7d&invisible=0" alt="website stats" border="0"></A> + + <DIV class="footer"> + Copyright © 2003-2007, The Apache Software Foundation + </DIV> + + </BODY> +</HTML>
\ No newline at end of file |