<html>
<head>
<META http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Changing Data</title>
<link rel="stylesheet" type="text/css" href="../../../style.css">
</head>
<body>
<div class="CommonContent">
<div class="CommonContentArea">
<h1>Changing Data</h1><script>
//We attach this function to a browser object as a variable so that if multiple of these blocks are
//present on the same page, then they will simply over-write eachother with the same function instead
//of generating a naming collision.
window.WikiCodeFormattingCopyToClipboard = function copyToClipboard(sID){
var sContent = document.getElementById(sID).innerText;
if( window.clipboardData && clipboardData.setData )
{
clipboardData.setData("Text", sContent);
}
else
{
alert("You must enable javascript access to your clipboard for this feature to work. Please referr to your browser documentation or Google search for instructions.");
}
}
</script><p>For this test we will select and update a car with a new
pilot, where existing pilot has 15 points:</p>
<p>SQLite:</p>
<div class="FormattedSourceCode"><div class="fscHeader"><span class="fscFileName">SqlExample.java: <span class="fscMemberName">updateCar</span></span></div><div class="fscCode"><pre ID="..DBCompareJava.Zipssrccomdb4odocandroidcompareSqlExample.Java_Srccomdb4odocandroidcompareSqlExample.Java_UpdateCar_129_92"><div><!--
Code highlighting produced by Actipro CodeHighlighter (freeware)
http://www.CodeHighlighter.com/
--><span style="color: #008080;">01</span><img id="..DBCompareJava.Zipssrccomdb4odocandroidcompareSqlExample.Java_Srccomdb4odocandroidcompareSqlExample.Java_UpdateCar_129_92_30_914_Open_Image" src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ExpandedBlockStart.gif" align="top" onClick="this.style.display='none'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareSqlExample.Java_Srccomdb4odocandroidcompareSqlExample.Java_UpdateCar_129_92_30_914_Open_Text').style.display='none'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareSqlExample.Java_Srccomdb4odocandroidcompareSqlExample.Java_UpdateCar_129_92_30_914_Closed_Image').style.display='inline'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareSqlExample.Java_Srccomdb4odocandroidcompareSqlExample.Java_UpdateCar_129_92_30_914_Closed_Text').style.display='inline';"/><img id="..DBCompareJava.Zipssrccomdb4odocandroidcompareSqlExample.Java_Srccomdb4odocandroidcompareSqlExample.Java_UpdateCar_129_92_30_914_Closed_Image" src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ContractedBlock.gif" align="top" style="display: none;" onClick="this.style.display='none'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareSqlExample.Java_Srccomdb4odocandroidcompareSqlExample.Java_UpdateCar_129_92_30_914_Closed_Text').style.display='none'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareSqlExample.Java_Srccomdb4odocandroidcompareSqlExample.Java_UpdateCar_129_92_30_914_Open_Image').style.display='inline'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareSqlExample.Java_Srccomdb4odocandroidcompareSqlExample.Java_UpdateCar_129_92_30_914_Open_Text').style.display='inline';"/><span style="color: #0000FF;">public</span><span style="color: #000000;"> </span><span style="color: #0000FF;">static</span><span style="color: #000000;"> </span><span style="color: #0000FF;">void</span><span style="color: #000000;"> updateCar()</span><span id="..DBCompareJava.Zipssrccomdb4odocandroidcompareSqlExample.Java_Srccomdb4odocandroidcompareSqlExample.Java_UpdateCar_129_92_30_914_Closed_Text" style="border: solid 1px #808080; background-color: #FFFFFF; display: none;">...</span><span id="..DBCompareJava.Zipssrccomdb4odocandroidcompareSqlExample.Java_Srccomdb4odocandroidcompareSqlExample.Java_UpdateCar_129_92_30_914_Open_Text"><span style="color: #000000;">{
</span><span style="color: #008080;">02</span><span style="color: #000000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> SQLiteDatabase db </span><span style="color: #000000;">=</span><span style="color: #000000;"> database();
</span><span style="color: #008080;">03</span><span style="color: #000000;"><img id="..DBCompareJava.Zipssrccomdb4odocandroidcompareSqlExample.Java_Srccomdb4odocandroidcompareSqlExample.Java_UpdateCar_129_92_95_908_Open_Image" src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ExpandedSubBlockStart.gif" align="top" onClick="this.style.display='none'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareSqlExample.Java_Srccomdb4odocandroidcompareSqlExample.Java_UpdateCar_129_92_95_908_Open_Text').style.display='none'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareSqlExample.Java_Srccomdb4odocandroidcompareSqlExample.Java_UpdateCar_129_92_95_908_Closed_Image').style.display='inline'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareSqlExample.Java_Srccomdb4odocandroidcompareSqlExample.Java_UpdateCar_129_92_95_908_Closed_Text').style.display='inline';"/><img id="..DBCompareJava.Zipssrccomdb4odocandroidcompareSqlExample.Java_Srccomdb4odocandroidcompareSqlExample.Java_UpdateCar_129_92_95_908_Closed_Image" src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ContractedSubBlock.gif" align="top" style="display: none;" onClick="this.style.display='none'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareSqlExample.Java_Srccomdb4odocandroidcompareSqlExample.Java_UpdateCar_129_92_95_908_Closed_Text').style.display='none'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareSqlExample.Java_Srccomdb4odocandroidcompareSqlExample.Java_UpdateCar_129_92_95_908_Open_Image').style.display='inline'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareSqlExample.Java_Srccomdb4odocandroidcompareSqlExample.Java_UpdateCar_129_92_95_908_Open_Text').style.display='inline';"/> </span><span style="color: #0000FF;">if</span><span style="color: #000000;"> (db </span><span style="color: #000000;">!=</span><span style="color: #000000;"> </span><span style="color: #0000FF;">null</span><span style="color: #000000;">)</span><span id="..DBCompareJava.Zipssrccomdb4odocandroidcompareSqlExample.Java_Srccomdb4odocandroidcompareSqlExample.Java_UpdateCar_129_92_95_908_Closed_Text" style="border: solid 1px #808080; background-color: #FFFFFF; display: none;">...</span><span id="..DBCompareJava.Zipssrccomdb4odocandroidcompareSqlExample.Java_Srccomdb4odocandroidcompareSqlExample.Java_UpdateCar_129_92_95_908_Open_Text"><span style="color: #000000;">{
</span><span style="color: #008080;">04</span><span style="color: #000000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> </span><span style="color: #0000FF;">long</span><span style="color: #000000;"> startTime </span><span style="color: #000000;">=</span><span style="color: #000000;"> System.currentTimeMillis();
</span><span style="color: #008080;">05</span><span style="color: #000000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> </span><span style="color: #008000;">//</span><span style="color: #008000;"> insert a new pilot</span><span style="color: #008000;">
</span><span style="color: #008080;">06</span><span style="color: #008000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/></span><span style="color: #000000;"> ContentValues updateValues </span><span style="color: #000000;">=</span><span style="color: #000000;"> </span><span style="color: #0000FF;">new</span><span style="color: #000000;"> ContentValues();
</span><span style="color: #008080;">07</span><span style="color: #000000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/>
</span><span style="color: #008080;">08</span><span style="color: #000000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> updateValues.put(</span><span style="color: #000000;">"</span><span style="color: #000000;">id</span><span style="color: #000000;">"</span><span style="color: #000000;">, </span><span style="color: #000000;">101</span><span style="color: #000000;">);
</span><span style="color: #008080;">09</span><span style="color: #000000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> updateValues.put(</span><span style="color: #000000;">"</span><span style="color: #000000;">name</span><span style="color: #000000;">"</span><span style="color: #000000;">, </span><span style="color: #000000;">"</span><span style="color: #000000;">Tester1</span><span style="color: #000000;">"</span><span style="color: #000000;">);
</span><span style="color: #008080;">10</span><span style="color: #000000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> updateValues.put(</span><span style="color: #000000;">"</span><span style="color: #000000;">points</span><span style="color: #000000;">"</span><span style="color: #000000;">, </span><span style="color: #000000;">25</span><span style="color: #000000;">);
</span><span style="color: #008080;">11</span><span style="color: #000000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> db.insert(DB_TABLE_PILOT, </span><span style="color: #0000FF;">null</span><span style="color: #000000;">, updateValues);
</span><span style="color: #008080;">12</span><span style="color: #000000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/>
</span><span style="color: #008080;">13</span><span style="color: #000000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> updateValues </span><span style="color: #000000;">=</span><span style="color: #000000;"> </span><span style="color: #0000FF;">new</span><span style="color: #000000;"> ContentValues();
</span><span style="color: #008080;">14</span><span style="color: #000000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/>
</span><span style="color: #008080;">15</span><span style="color: #000000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> </span><span style="color: #008000;">//</span><span style="color: #008000;"> update pilot in the car</span><span style="color: #008000;">
</span><span style="color: #008080;">16</span><span style="color: #008000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/></span><span style="color: #000000;"> updateValues.put(</span><span style="color: #000000;">"</span><span style="color: #000000;">pilot</span><span style="color: #000000;">"</span><span style="color: #000000;">, </span><span style="color: #000000;">101</span><span style="color: #000000;">);
</span><span style="color: #008080;">17</span><span style="color: #000000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> </span><span style="color: #0000FF;">int</span><span style="color: #000000;"> count </span><span style="color: #000000;">=</span><span style="color: #000000;"> db.update(DB_TABLE_CAR, updateValues, </span><span style="color: #000000;">"</span><span style="color: #000000;">pilot in (select id from pilot where points = 15)</span><span style="color: #000000;">"</span><span style="color: #000000;">, </span><span style="color: #0000FF;">null</span><span style="color: #000000;">);
</span><span style="color: #008080;">18</span><span style="color: #000000;"><img id="..DBCompareJava.Zipssrccomdb4odocandroidcompareSqlExample.Java_Srccomdb4odocandroidcompareSqlExample.Java_UpdateCar_129_92_711_808_Open_Image" src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ExpandedSubBlockStart.gif" align="top" onClick="this.style.display='none'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareSqlExample.Java_Srccomdb4odocandroidcompareSqlExample.Java_UpdateCar_129_92_711_808_Open_Text').style.display='none'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareSqlExample.Java_Srccomdb4odocandroidcompareSqlExample.Java_UpdateCar_129_92_711_808_Closed_Image').style.display='inline'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareSqlExample.Java_Srccomdb4odocandroidcompareSqlExample.Java_UpdateCar_129_92_711_808_Closed_Text').style.display='inline';"/><img id="..DBCompareJava.Zipssrccomdb4odocandroidcompareSqlExample.Java_Srccomdb4odocandroidcompareSqlExample.Java_UpdateCar_129_92_711_808_Closed_Image" src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ContractedSubBlock.gif" align="top" style="display: none;" onClick="this.style.display='none'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareSqlExample.Java_Srccomdb4odocandroidcompareSqlExample.Java_UpdateCar_129_92_711_808_Closed_Text').style.display='none'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareSqlExample.Java_Srccomdb4odocandroidcompareSqlExample.Java_UpdateCar_129_92_711_808_Open_Image').style.display='inline'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareSqlExample.Java_Srccomdb4odocandroidcompareSqlExample.Java_UpdateCar_129_92_711_808_Open_Text').style.display='inline';"/> </span><span style="color: #0000FF;">if</span><span style="color: #000000;"> (count </span><span style="color: #000000;">==</span><span style="color: #000000;"> </span><span style="color: #000000;">0</span><span style="color: #000000;">)</span><span id="..DBCompareJava.Zipssrccomdb4odocandroidcompareSqlExample.Java_Srccomdb4odocandroidcompareSqlExample.Java_UpdateCar_129_92_711_808_Closed_Text" style="border: solid 1px #808080; background-color: #FFFFFF; display: none;">...</span><span id="..DBCompareJava.Zipssrccomdb4odocandroidcompareSqlExample.Java_Srccomdb4odocandroidcompareSqlExample.Java_UpdateCar_129_92_711_808_Open_Text"><span style="color: #000000;">{
</span><span style="color: #008080;">19</span><span style="color: #000000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> logToConsole(</span><span style="color: #000000;">0</span><span style="color: #000000;">, </span><span style="color: #000000;">"</span><span style="color: #000000;">Car not found, refill the database to continue.</span><span style="color: #000000;">"</span><span style="color: #000000;">, </span><span style="color: #0000FF;">false</span><span style="color: #000000;">);
</span><span style="color: #008080;">20</span><span style="color: #000000;"><img id="..DBCompareJava.Zipssrccomdb4odocandroidcompareSqlExample.Java_Srccomdb4odocandroidcompareSqlExample.Java_UpdateCar_129_92_814_898_Open_Image" src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ExpandedSubBlockStart.gif" align="top" onClick="this.style.display='none'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareSqlExample.Java_Srccomdb4odocandroidcompareSqlExample.Java_UpdateCar_129_92_814_898_Open_Text').style.display='none'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareSqlExample.Java_Srccomdb4odocandroidcompareSqlExample.Java_UpdateCar_129_92_814_898_Closed_Image').style.display='inline'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareSqlExample.Java_Srccomdb4odocandroidcompareSqlExample.Java_UpdateCar_129_92_814_898_Closed_Text').style.display='inline';"/><img id="..DBCompareJava.Zipssrccomdb4odocandroidcompareSqlExample.Java_Srccomdb4odocandroidcompareSqlExample.Java_UpdateCar_129_92_814_898_Closed_Image" src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ContractedSubBlock.gif" align="top" style="display: none;" onClick="this.style.display='none'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareSqlExample.Java_Srccomdb4odocandroidcompareSqlExample.Java_UpdateCar_129_92_814_898_Closed_Text').style.display='none'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareSqlExample.Java_Srccomdb4odocandroidcompareSqlExample.Java_UpdateCar_129_92_814_898_Open_Image').style.display='inline'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareSqlExample.Java_Srccomdb4odocandroidcompareSqlExample.Java_UpdateCar_129_92_814_898_Open_Text').style.display='inline';"/> }</span></span><span style="color: #000000;"> </span><span style="color: #0000FF;">else</span><span style="color: #000000;"> </span><span id="..DBCompareJava.Zipssrccomdb4odocandroidcompareSqlExample.Java_Srccomdb4odocandroidcompareSqlExample.Java_UpdateCar_129_92_814_898_Closed_Text" style="border: solid 1px #808080; background-color: #FFFFFF; display: none;">...</span><span id="..DBCompareJava.Zipssrccomdb4odocandroidcompareSqlExample.Java_Srccomdb4odocandroidcompareSqlExample.Java_UpdateCar_129_92_814_898_Open_Text"><span style="color: #000000;">{
</span><span style="color: #008080;">21</span><span style="color: #000000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> logToConsole(startTime, </span><span style="color: #000000;">"</span><span style="color: #000000;">Updated selected object: </span><span style="color: #000000;">"</span><span style="color: #000000;">, </span><span style="color: #0000FF;">false</span><span style="color: #000000;">);
</span><span style="color: #008080;">22</span><span style="color: #000000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ExpandedSubBlockEnd.gif" align="top"/> }</span></span><span style="color: #000000;">
</span><span style="color: #008080;">23</span><span style="color: #000000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ExpandedSubBlockEnd.gif" align="top"/> }</span></span><span style="color: #000000;">
</span><span style="color: #008080;">24</span><span style="color: #000000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ExpandedBlockEnd.gif" align="top"/> }</span></span></div></pre></div></div><p>db4o:</p>
<p>(Select Car using Native Query)</p>
<div class="FormattedSourceCode"><div class="fscHeader"><span class="fscFileName">Db4oExample.java: <span class="fscMemberName">updateCar</span></span></div><div class="fscCode"><pre ID="..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_UpdateCar_279_93"><div><!--
Code highlighting produced by Actipro CodeHighlighter (freeware)
http://www.CodeHighlighter.com/
--><span style="color: #008080;">01</span><img id="..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_UpdateCar_279_93_30_777_Open_Image" src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ExpandedBlockStart.gif" align="top" onClick="this.style.display='none'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_UpdateCar_279_93_30_777_Open_Text').style.display='none'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_UpdateCar_279_93_30_777_Closed_Image').style.display='inline'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_UpdateCar_279_93_30_777_Closed_Text').style.display='inline';"/><img id="..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_UpdateCar_279_93_30_777_Closed_Image" src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ContractedBlock.gif" align="top" style="display: none;" onClick="this.style.display='none'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_UpdateCar_279_93_30_777_Closed_Text').style.display='none'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_UpdateCar_279_93_30_777_Open_Image').style.display='inline'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_UpdateCar_279_93_30_777_Open_Text').style.display='inline';"/><span style="color: #0000FF;">public</span><span style="color: #000000;"> </span><span style="color: #0000FF;">static</span><span style="color: #000000;"> </span><span style="color: #0000FF;">void</span><span style="color: #000000;"> updateCar()</span><span id="..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_UpdateCar_279_93_30_777_Closed_Text" style="border: solid 1px #808080; background-color: #FFFFFF; display: none;">...</span><span id="..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_UpdateCar_279_93_30_777_Open_Text"><span style="color: #000000;">{
</span><span style="color: #008080;">02</span><span style="color: #000000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> ObjectContainer container</span><span style="color: #000000;">=</span><span style="color: #000000;">database();
</span><span style="color: #008080;">03</span><span style="color: #000000;"><img id="..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_UpdateCar_279_93_108_771_Open_Image" src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ExpandedSubBlockStart.gif" align="top" onClick="this.style.display='none'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_UpdateCar_279_93_108_771_Open_Text').style.display='none'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_UpdateCar_279_93_108_771_Closed_Image').style.display='inline'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_UpdateCar_279_93_108_771_Closed_Text').style.display='inline';"/><img id="..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_UpdateCar_279_93_108_771_Closed_Image" src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ContractedSubBlock.gif" align="top" style="display: none;" onClick="this.style.display='none'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_UpdateCar_279_93_108_771_Closed_Text').style.display='none'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_UpdateCar_279_93_108_771_Open_Image').style.display='inline'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_UpdateCar_279_93_108_771_Open_Text').style.display='inline';"/> </span><span style="color: #0000FF;">if</span><span style="color: #000000;"> (container </span><span style="color: #000000;">!=</span><span style="color: #000000;"> </span><span style="color: #0000FF;">null</span><span style="color: #000000;">)</span><span id="..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_UpdateCar_279_93_108_771_Closed_Text" style="border: solid 1px #808080; background-color: #FFFFFF; display: none;">...</span><span id="..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_UpdateCar_279_93_108_771_Open_Text"><span style="color: #000000;">{
</span><span style="color: #008080;">04</span><span style="color: #000000;"><img id="..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_UpdateCar_279_93_123_656_Open_Image" src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ExpandedSubBlockStart.gif" align="top" onClick="this.style.display='none'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_UpdateCar_279_93_123_656_Open_Text').style.display='none'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_UpdateCar_279_93_123_656_Closed_Image').style.display='inline'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_UpdateCar_279_93_123_656_Closed_Text').style.display='inline';"/><img id="..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_UpdateCar_279_93_123_656_Closed_Image" src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ContractedSubBlock.gif" align="top" style="display: none;" onClick="this.style.display='none'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_UpdateCar_279_93_123_656_Closed_Text').style.display='none'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_UpdateCar_279_93_123_656_Open_Image').style.display='inline'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_UpdateCar_279_93_123_656_Open_Text').style.display='inline';"/> </span><span style="color: #0000FF;">try</span><span style="color: #000000;"> </span><span id="..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_UpdateCar_279_93_123_656_Closed_Text" style="border: solid 1px #808080; background-color: #FFFFFF; display: none;">...</span><span id="..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_UpdateCar_279_93_123_656_Open_Text"><span style="color: #000000;">{
</span><span style="color: #008080;">05</span><span style="color: #000000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> </span><span style="color: #0000FF;">long</span><span style="color: #000000;"> startTime </span><span style="color: #000000;">=</span><span style="color: #000000;"> System.currentTimeMillis();
</span><span style="color: #008080;">06</span><span style="color: #000000;"><img id="..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_UpdateCar_279_93_240_458_Open_Image" src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ExpandedSubBlockStart.gif" align="top" onClick="this.style.display='none'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_UpdateCar_279_93_240_458_Open_Text').style.display='none'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_UpdateCar_279_93_240_458_Closed_Image').style.display='inline'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_UpdateCar_279_93_240_458_Closed_Text').style.display='inline';"/><img id="..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_UpdateCar_279_93_240_458_Closed_Image" src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ContractedSubBlock.gif" align="top" style="display: none;" onClick="this.style.display='none'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_UpdateCar_279_93_240_458_Closed_Text').style.display='none'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_UpdateCar_279_93_240_458_Open_Image').style.display='inline'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_UpdateCar_279_93_240_458_Open_Text').style.display='inline';"/> ObjectSet result </span><span style="color: #000000;">=</span><span style="color: #000000;"> container.query(</span><span style="color: #0000FF;">new</span><span style="color: #000000;"> Predicate()</span><span id="..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_UpdateCar_279_93_240_458_Closed_Text" style="border: solid 1px #808080; background-color: #FFFFFF; display: none;">...</span><span id="..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_UpdateCar_279_93_240_458_Open_Text"><span style="color: #000000;">{
</span><span style="color: #008080;">07</span><span style="color: #000000;"><img id="..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_UpdateCar_279_93_288_446_Open_Image" src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ExpandedSubBlockStart.gif" align="top" onClick="this.style.display='none'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_UpdateCar_279_93_288_446_Open_Text').style.display='none'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_UpdateCar_279_93_288_446_Closed_Image').style.display='inline'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_UpdateCar_279_93_288_446_Closed_Text').style.display='inline';"/><img id="..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_UpdateCar_279_93_288_446_Closed_Image" src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ContractedSubBlock.gif" align="top" style="display: none;" onClick="this.style.display='none'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_UpdateCar_279_93_288_446_Closed_Text').style.display='none'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_UpdateCar_279_93_288_446_Open_Image').style.display='inline'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_UpdateCar_279_93_288_446_Open_Text').style.display='inline';"/> </span><span style="color: #0000FF;">public</span><span style="color: #000000;"> </span><span style="color: #0000FF;">boolean</span><span style="color: #000000;"> match(Object object)</span><span id="..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_UpdateCar_279_93_288_446_Closed_Text" style="border: solid 1px #808080; background-color: #FFFFFF; display: none;">...</span><span id="..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_UpdateCar_279_93_288_446_Open_Text"><span style="color: #000000;">{
</span><span style="color: #008080;">08</span><span style="color: #000000;"><img id="..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_UpdateCar_279_93_328_407_Open_Image" src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ExpandedSubBlockStart.gif" align="top" onClick="this.style.display='none'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_UpdateCar_279_93_328_407_Open_Text').style.display='none'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_UpdateCar_279_93_328_407_Closed_Image').style.display='inline'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_UpdateCar_279_93_328_407_Closed_Text').style.display='inline';"/><img id="..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_UpdateCar_279_93_328_407_Closed_Image" src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ContractedSubBlock.gif" align="top" style="display: none;" onClick="this.style.display='none'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_UpdateCar_279_93_328_407_Closed_Text').style.display='none'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_UpdateCar_279_93_328_407_Open_Image').style.display='inline'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_UpdateCar_279_93_328_407_Open_Text').style.display='inline';"/> </span><span style="color: #0000FF;">if</span><span style="color: #000000;"> (object </span><span style="color: #0000FF;">instanceof</span><span style="color: #000000;"> Car)</span><span id="..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_UpdateCar_279_93_328_407_Closed_Text" style="border: solid 1px #808080; background-color: #FFFFFF; display: none;">...</span><span id="..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_UpdateCar_279_93_328_407_Open_Text"><span style="color: #000000;">{
</span><span style="color: #008080;">09</span><span style="color: #000000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> </span><span style="color: #0000FF;">return</span><span style="color: #000000;"> ((Car)object).getPilot().getPoints() </span><span style="color: #000000;">==</span><span style="color: #000000;"> </span><span style="color: #000000;">15</span><span style="color: #000000;">;
</span><span style="color: #008080;">10</span><span style="color: #000000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ExpandedSubBlockEnd.gif" align="top"/> }</span></span><span style="color: #000000;">
</span><span style="color: #008080;">11</span><span style="color: #000000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> </span><span style="color: #0000FF;">return</span><span style="color: #000000;"> </span><span style="color: #0000FF;">false</span><span style="color: #000000;">;
</span><span style="color: #008080;">12</span><span style="color: #000000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ExpandedSubBlockEnd.gif" align="top"/> }</span></span><span style="color: #000000;">
</span><span style="color: #008080;">13</span><span style="color: #000000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ExpandedSubBlockEnd.gif" align="top"/> }</span></span><span style="color: #000000;">);
</span><span style="color: #008080;">14</span><span style="color: #000000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> Car car </span><span style="color: #000000;">=</span><span style="color: #000000;"> (Car)result.next();
</span><span style="color: #008080;">15</span><span style="color: #000000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> car.setPilot(</span><span style="color: #0000FF;">new</span><span style="color: #000000;"> Pilot(</span><span style="color: #000000;">"</span><span style="color: #000000;">Tester1</span><span style="color: #000000;">"</span><span style="color: #000000;">, </span><span style="color: #000000;">25</span><span style="color: #000000;">));
</span><span style="color: #008080;">16</span><span style="color: #000000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> container.set(car);
</span><span style="color: #008080;">17</span><span style="color: #000000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> logToConsole(startTime, </span><span style="color: #000000;">"</span><span style="color: #000000;">Updated selected object: </span><span style="color: #000000;">"</span><span style="color: #000000;">, </span><span style="color: #0000FF;">false</span><span style="color: #000000;">);
</span><span style="color: #008080;">18</span><span style="color: #000000;"><img id="..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_UpdateCar_279_93_676_761_Open_Image" src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ExpandedSubBlockStart.gif" align="top" onClick="this.style.display='none'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_UpdateCar_279_93_676_761_Open_Text').style.display='none'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_UpdateCar_279_93_676_761_Closed_Image').style.display='inline'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_UpdateCar_279_93_676_761_Closed_Text').style.display='inline';"/><img id="..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_UpdateCar_279_93_676_761_Closed_Image" src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ContractedSubBlock.gif" align="top" style="display: none;" onClick="this.style.display='none'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_UpdateCar_279_93_676_761_Closed_Text').style.display='none'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_UpdateCar_279_93_676_761_Open_Image').style.display='inline'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_UpdateCar_279_93_676_761_Open_Text').style.display='inline';"/> }</span></span><span style="color: #000000;"> </span><span style="color: #0000FF;">catch</span><span style="color: #000000;"> (Exception e)</span><span id="..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_UpdateCar_279_93_676_761_Closed_Text" style="border: solid 1px #808080; background-color: #FFFFFF; display: none;">...</span><span id="..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_UpdateCar_279_93_676_761_Open_Text"><span style="color: #000000;">{
</span><span style="color: #008080;">19</span><span style="color: #000000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> logToConsole(</span><span style="color: #000000;">0</span><span style="color: #000000;">, </span><span style="color: #000000;">"</span><span style="color: #000000;">Car not found, refill the database to continue.</span><span style="color: #000000;">"</span><span style="color: #000000;">, </span><span style="color: #0000FF;">false</span><span style="color: #000000;">);
</span><span style="color: #008080;">20</span><span style="color: #000000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ExpandedSubBlockEnd.gif" align="top"/> }</span></span><span style="color: #000000;">
</span><span style="color: #008080;">21</span><span style="color: #000000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ExpandedSubBlockEnd.gif" align="top"/> }</span></span><span style="color: #000000;">
</span><span style="color: #008080;">22</span><span style="color: #000000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ExpandedBlockEnd.gif" align="top"/> }</span></span></div></pre></div></div>
<p> In this example db4o and SQLite actually behave quite differently. For SQLite in order to update a pilot in an existing car in the database the following actions are needed:</p><ol><li>A new pilot should be created and saved to the database.</li><li>New pilot's primary key (101) should be retrieved (not shown in this example, but is necessary for a real database application).</li><li>An update statement should be issued to replace pilot field in the car table.</li></ol><p>For db4o database the sequence will be the following:</p><ol><li>Retrieve the car from the database</li><li>Update the car with a new pilot object</li></ol><p>As you can see the only benefit of SQLite API is that the car can be selected and updated in one statement. But in the same time there are serious disadvantages:</p><ul><li>A new pilot record should be created absolutely separately (in a real database will also include ORM)</li><li>The pilot's ID needs to be retrieved separately (we must must sure that it is a correct id) <br></li></ul>In db4o we avoid these disadvantages as creating new pilot and updating the car value are actually combined in one atomic operation.<br></div>
</div>
<div id="footer">
This revision (2) was last Modified 2007-12-09T09:33:29 by Tetyana.
</div>
</body>
</html>
