<html>
<head>
<META http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Storing Data</title>
<link rel="stylesheet" type="text/css" href="../../../style.css">
</head>
<body>
<div class="CommonContent">
<div class="CommonContentArea">
<h1>Storing 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>"Store" button creates and stores 100 of car objects (each
including a reference to Pilot object) to each database.</p>
<p>SQLite:</p>
<div class="FormattedSourceCode"><div class="fscHeader"><span class="fscFileName">SqlExample.java: <span class="fscMemberName">fillUpDB</span></span></div><div class="fscCode"><pre ID="..DBCompareJava.Zipssrccomdb4odocandroidcompareSqlExample.Java_Srccomdb4odocandroidcompareSqlExample.Java_FillUpDB_145_91"><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_FillUpDB_145_91_47_414_Open_Image" src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ExpandedBlockStart.gif" align="top" onClick="this.style.display='none'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareSqlExample.Java_Srccomdb4odocandroidcompareSqlExample.Java_FillUpDB_145_91_47_414_Open_Text').style.display='none'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareSqlExample.Java_Srccomdb4odocandroidcompareSqlExample.Java_FillUpDB_145_91_47_414_Closed_Image').style.display='inline'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareSqlExample.Java_Srccomdb4odocandroidcompareSqlExample.Java_FillUpDB_145_91_47_414_Closed_Text').style.display='inline';"/><img id="..DBCompareJava.Zipssrccomdb4odocandroidcompareSqlExample.Java_Srccomdb4odocandroidcompareSqlExample.Java_FillUpDB_145_91_47_414_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_FillUpDB_145_91_47_414_Closed_Text').style.display='none'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareSqlExample.Java_Srccomdb4odocandroidcompareSqlExample.Java_FillUpDB_145_91_47_414_Open_Image').style.display='inline'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareSqlExample.Java_Srccomdb4odocandroidcompareSqlExample.Java_FillUpDB_145_91_47_414_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;"> fillUpDB() </span><span style="color: #0000FF;">throws</span><span style="color: #000000;"> Exception </span><span id="..DBCompareJava.Zipssrccomdb4odocandroidcompareSqlExample.Java_Srccomdb4odocandroidcompareSqlExample.Java_FillUpDB_145_91_47_414_Closed_Text" style="border: solid 1px #808080; background-color: #FFFFFF; display: none;">...</span><span id="..DBCompareJava.Zipssrccomdb4odocandroidcompareSqlExample.Java_Srccomdb4odocandroidcompareSqlExample.Java_FillUpDB_145_91_47_414_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"/> close();
</span><span style="color: #008080;">03</span><span style="color: #000000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> _context.deleteDatabase(DATABASE_NAME);
</span><span style="color: #008080;">04</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;">05</span><span style="color: #000000;"><img id="..DBCompareJava.Zipssrccomdb4odocandroidcompareSqlExample.Java_Srccomdb4odocandroidcompareSqlExample.Java_FillUpDB_145_91_171_408_Open_Image" src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ExpandedSubBlockStart.gif" align="top" onClick="this.style.display='none'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareSqlExample.Java_Srccomdb4odocandroidcompareSqlExample.Java_FillUpDB_145_91_171_408_Open_Text').style.display='none'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareSqlExample.Java_Srccomdb4odocandroidcompareSqlExample.Java_FillUpDB_145_91_171_408_Closed_Image').style.display='inline'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareSqlExample.Java_Srccomdb4odocandroidcompareSqlExample.Java_FillUpDB_145_91_171_408_Closed_Text').style.display='inline';"/><img id="..DBCompareJava.Zipssrccomdb4odocandroidcompareSqlExample.Java_Srccomdb4odocandroidcompareSqlExample.Java_FillUpDB_145_91_171_408_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_FillUpDB_145_91_171_408_Closed_Text').style.display='none'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareSqlExample.Java_Srccomdb4odocandroidcompareSqlExample.Java_FillUpDB_145_91_171_408_Open_Image').style.display='inline'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareSqlExample.Java_Srccomdb4odocandroidcompareSqlExample.Java_FillUpDB_145_91_171_408_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_FillUpDB_145_91_171_408_Closed_Text" style="border: solid 1px #808080; background-color: #FFFFFF; display: none;">...</span><span id="..DBCompareJava.Zipssrccomdb4odocandroidcompareSqlExample.Java_Srccomdb4odocandroidcompareSqlExample.Java_FillUpDB_145_91_171_408_Open_Text"><span style="color: #000000;">{
</span><span style="color: #008080;">06</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;">07</span><span style="color: #000000;"><img id="..DBCompareJava.Zipssrccomdb4odocandroidcompareSqlExample.Java_Srccomdb4odocandroidcompareSqlExample.Java_FillUpDB_145_91_260_290_Open_Image" src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ExpandedSubBlockStart.gif" align="top" onClick="this.style.display='none'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareSqlExample.Java_Srccomdb4odocandroidcompareSqlExample.Java_FillUpDB_145_91_260_290_Open_Text').style.display='none'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareSqlExample.Java_Srccomdb4odocandroidcompareSqlExample.Java_FillUpDB_145_91_260_290_Closed_Image').style.display='inline'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareSqlExample.Java_Srccomdb4odocandroidcompareSqlExample.Java_FillUpDB_145_91_260_290_Closed_Text').style.display='inline';"/><img id="..DBCompareJava.Zipssrccomdb4odocandroidcompareSqlExample.Java_Srccomdb4odocandroidcompareSqlExample.Java_FillUpDB_145_91_260_290_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_FillUpDB_145_91_260_290_Closed_Text').style.display='none'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareSqlExample.Java_Srccomdb4odocandroidcompareSqlExample.Java_FillUpDB_145_91_260_290_Open_Image').style.display='inline'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareSqlExample.Java_Srccomdb4odocandroidcompareSqlExample.Java_FillUpDB_145_91_260_290_Open_Text').style.display='inline';"/> </span><span style="color: #0000FF;">for</span><span style="color: #000000;"> (</span><span style="color: #0000FF;">int</span><span style="color: #000000;"> i</span><span style="color: #000000;">=</span><span style="color: #000000;">0</span><span style="color: #000000;">; i</span><span style="color: #000000;"><</span><span style="color: #000000;">100</span><span style="color: #000000;">;i</span><span style="color: #000000;">++</span><span style="color: #000000;">)</span><span id="..DBCompareJava.Zipssrccomdb4odocandroidcompareSqlExample.Java_Srccomdb4odocandroidcompareSqlExample.Java_FillUpDB_145_91_260_290_Closed_Text" style="border: solid 1px #808080; background-color: #FFFFFF; display: none;">...</span><span id="..DBCompareJava.Zipssrccomdb4odocandroidcompareSqlExample.Java_Srccomdb4odocandroidcompareSqlExample.Java_FillUpDB_145_91_260_290_Open_Text"><span style="color: #000000;">{
</span><span style="color: #008080;">08</span><span style="color: #000000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> addCar(db,i);
</span><span style="color: #008080;">09</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;">10</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;">Stored 100 objects: </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;">11</span><span style="color: #000000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> startTime </span><span style="color: #000000;">=</span><span style="color: #000000;"> System.currentTimeMillis();
</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/ExpandedBlockEnd.gif" align="top"/> }</span></span></div></pre></div></div>
<div class="FormattedSourceCode"><div class="fscHeader"><span class="fscFileName">SqlExample.java: <span class="fscMemberName">addCar</span></span></div><div class="fscCode"><pre ID="..DBCompareJava.Zipssrccomdb4odocandroidcompareSqlExample.Java_Srccomdb4odocandroidcompareSqlExample.Java_AddCar_240_89"><div><!--
Code highlighting produced by Actipro CodeHighlighter (freeware)
http://www.CodeHighlighter.com/
--><span style="color: #008080;">01</span><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/None.gif" align="top"/><span style="color: #0000FF;">private</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;"> addCar(SQLiteDatabase db, </span><span style="color: #0000FF;">int</span><span style="color: #000000;"> number)
</span><span style="color: #008080;">02</span><span style="color: #000000;"><img id="..DBCompareJava.Zipssrccomdb4odocandroidcompareSqlExample.Java_Srccomdb4odocandroidcompareSqlExample.Java_AddCar_240_89_59_510_Open_Image" src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ExpandedBlockStart.gif" align="top" onClick="this.style.display='none'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareSqlExample.Java_Srccomdb4odocandroidcompareSqlExample.Java_AddCar_240_89_59_510_Open_Text').style.display='none'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareSqlExample.Java_Srccomdb4odocandroidcompareSqlExample.Java_AddCar_240_89_59_510_Closed_Image').style.display='inline'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareSqlExample.Java_Srccomdb4odocandroidcompareSqlExample.Java_AddCar_240_89_59_510_Closed_Text').style.display='inline';"/><img id="..DBCompareJava.Zipssrccomdb4odocandroidcompareSqlExample.Java_Srccomdb4odocandroidcompareSqlExample.Java_AddCar_240_89_59_510_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_AddCar_240_89_59_510_Closed_Text').style.display='none'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareSqlExample.Java_Srccomdb4odocandroidcompareSqlExample.Java_AddCar_240_89_59_510_Open_Image').style.display='inline'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareSqlExample.Java_Srccomdb4odocandroidcompareSqlExample.Java_AddCar_240_89_59_510_Open_Text').style.display='inline';"/> </span><span id="..DBCompareJava.Zipssrccomdb4odocandroidcompareSqlExample.Java_Srccomdb4odocandroidcompareSqlExample.Java_AddCar_240_89_59_510_Closed_Text" style="border: solid 1px #808080; background-color: #FFFFFF; display: none;">...</span><span id="..DBCompareJava.Zipssrccomdb4odocandroidcompareSqlExample.Java_Srccomdb4odocandroidcompareSqlExample.Java_AddCar_240_89_59_510_Open_Text"><span style="color: #000000;">{
</span><span style="color: #008080;">03</span><span style="color: #000000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> ContentValues initialValues </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;">04</span><span style="color: #000000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/>
</span><span style="color: #008080;">05</span><span style="color: #000000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> initialValues.put(</span><span style="color: #000000;">"</span><span style="color: #000000;">id</span><span style="color: #000000;">"</span><span style="color: #000000;">, number);
</span><span style="color: #008080;">06</span><span style="color: #000000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> initialValues.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;">Tester</span><span style="color: #000000;">"</span><span style="color: #000000;">);
</span><span style="color: #008080;">07</span><span style="color: #000000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> initialValues.put(</span><span style="color: #000000;">"</span><span style="color: #000000;">points</span><span style="color: #000000;">"</span><span style="color: #000000;">, number);
</span><span style="color: #008080;">08</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;">, initialValues);
</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: #008080;">10</span><span style="color: #000000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> initialValues </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;">11</span><span style="color: #000000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/>
</span><span style="color: #008080;">12</span><span style="color: #000000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> initialValues.put(</span><span style="color: #000000;">"</span><span style="color: #000000;">model</span><span style="color: #000000;">"</span><span style="color: #000000;">, </span><span style="color: #000000;">"</span><span style="color: #000000;">BMW</span><span style="color: #000000;">"</span><span style="color: #000000;">);
</span><span style="color: #008080;">13</span><span style="color: #000000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> initialValues.put(</span><span style="color: #000000;">"</span><span style="color: #000000;">pilot</span><span style="color: #000000;">"</span><span style="color: #000000;">, number);
</span><span style="color: #008080;">14</span><span style="color: #000000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> db.insert(DB_TABLE_CAR, </span><span style="color: #0000FF;">null</span><span style="color: #000000;">, initialValues);
</span><span style="color: #008080;">15</span><span style="color: #000000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ExpandedBlockEnd.gif" align="top"/> }</span></span></div></pre></div></div><p>db4o:</p>
<div class="FormattedSourceCode"><div class="fscHeader"><span class="fscFileName">Db4oExample.java: <span class="fscMemberName">fillUpDB</span></span></div><div class="fscCode"><pre ID="..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_FillUpDB_345_92"><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_FillUpDB_345_92_47_518_Open_Image" src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ExpandedBlockStart.gif" align="top" onClick="this.style.display='none'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_FillUpDB_345_92_47_518_Open_Text').style.display='none'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_FillUpDB_345_92_47_518_Closed_Image').style.display='inline'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_FillUpDB_345_92_47_518_Closed_Text').style.display='inline';"/><img id="..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_FillUpDB_345_92_47_518_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_FillUpDB_345_92_47_518_Closed_Text').style.display='none'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_FillUpDB_345_92_47_518_Open_Image').style.display='inline'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_FillUpDB_345_92_47_518_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;"> fillUpDB() </span><span style="color: #0000FF;">throws</span><span style="color: #000000;"> Exception </span><span id="..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_FillUpDB_345_92_47_518_Closed_Text" style="border: solid 1px #808080; background-color: #FFFFFF; display: none;">...</span><span id="..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_FillUpDB_345_92_47_518_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"/> close();
</span><span style="color: #008080;">03</span><span style="color: #000000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> </span><span style="color: #0000FF;">new</span><span style="color: #000000;"> File(db4oDBFullPath()).delete();
</span><span style="color: #008080;">04</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;">05</span><span style="color: #000000;"><img id="..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_FillUpDB_345_92_184_512_Open_Image" src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ExpandedSubBlockStart.gif" align="top" onClick="this.style.display='none'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_FillUpDB_345_92_184_512_Open_Text').style.display='none'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_FillUpDB_345_92_184_512_Closed_Image').style.display='inline'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_FillUpDB_345_92_184_512_Closed_Text').style.display='inline';"/><img id="..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_FillUpDB_345_92_184_512_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_FillUpDB_345_92_184_512_Closed_Text').style.display='none'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_FillUpDB_345_92_184_512_Open_Image').style.display='inline'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_FillUpDB_345_92_184_512_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_FillUpDB_345_92_184_512_Closed_Text" style="border: solid 1px #808080; background-color: #FFFFFF; display: none;">...</span><span id="..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_FillUpDB_345_92_184_512_Open_Text"><span style="color: #000000;">{
</span><span style="color: #008080;">06</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;">07</span><span style="color: #000000;"><img id="..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_FillUpDB_345_92_273_310_Open_Image" src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ExpandedSubBlockStart.gif" align="top" onClick="this.style.display='none'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_FillUpDB_345_92_273_310_Open_Text').style.display='none'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_FillUpDB_345_92_273_310_Closed_Image').style.display='inline'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_FillUpDB_345_92_273_310_Closed_Text').style.display='inline';"/><img id="..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_FillUpDB_345_92_273_310_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_FillUpDB_345_92_273_310_Closed_Text').style.display='none'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_FillUpDB_345_92_273_310_Open_Image').style.display='inline'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_FillUpDB_345_92_273_310_Open_Text').style.display='inline';"/> </span><span style="color: #0000FF;">for</span><span style="color: #000000;"> (</span><span style="color: #0000FF;">int</span><span style="color: #000000;"> i</span><span style="color: #000000;">=</span><span style="color: #000000;">0</span><span style="color: #000000;">; i</span><span style="color: #000000;"><</span><span style="color: #000000;">100</span><span style="color: #000000;">;i</span><span style="color: #000000;">++</span><span style="color: #000000;">)</span><span id="..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_FillUpDB_345_92_273_310_Closed_Text" style="border: solid 1px #808080; background-color: #FFFFFF; display: none;">...</span><span id="..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_FillUpDB_345_92_273_310_Open_Text"><span style="color: #000000;">{
</span><span style="color: #008080;">08</span><span style="color: #000000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> addCar(container,i);
</span><span style="color: #008080;">09</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;">10</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;">Stored 100 objects: </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;">11</span><span style="color: #000000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> startTime </span><span style="color: #000000;">=</span><span style="color: #000000;"> System.currentTimeMillis();
</span><span style="color: #008080;">12</span><span style="color: #000000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> container.commit();
</span><span style="color: #008080;">13</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;">Committed: </span><span style="color: #000000;">"</span><span style="color: #000000;">, </span><span style="color: #0000FF;">true</span><span style="color: #000000;">);
</span><span style="color: #008080;">14</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;">15</span><span style="color: #000000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ExpandedBlockEnd.gif" align="top"/> }</span></span></div></pre></div></div>
<div class="FormattedSourceCode"><div class="fscHeader"><span class="fscFileName">Db4oExample.java: <span class="fscMemberName">addCar</span></span></div><div class="fscCode"><pre ID="..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_AddCar_441_90"><div><!--
Code highlighting produced by Actipro CodeHighlighter (freeware)
http://www.CodeHighlighter.com/
--><span style="color: #008080;">1</span><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/None.gif" align="top"/><span style="color: #0000FF;">private</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;"> addCar(ObjectContainer container, </span><span style="color: #0000FF;">int</span><span style="color: #000000;"> points)
</span><span style="color: #008080;">2</span><span style="color: #000000;"><img id="..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_AddCar_441_90_67_166_Open_Image" src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ExpandedBlockStart.gif" align="top" onClick="this.style.display='none'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_AddCar_441_90_67_166_Open_Text').style.display='none'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_AddCar_441_90_67_166_Closed_Image').style.display='inline'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_AddCar_441_90_67_166_Closed_Text').style.display='inline';"/><img id="..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_AddCar_441_90_67_166_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_AddCar_441_90_67_166_Closed_Text').style.display='none'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_AddCar_441_90_67_166_Open_Image').style.display='inline'; document.getElementById('..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_AddCar_441_90_67_166_Open_Text').style.display='inline';"/> </span><span id="..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_AddCar_441_90_67_166_Closed_Text" style="border: solid 1px #808080; background-color: #FFFFFF; display: none;">...</span><span id="..DBCompareJava.Zipssrccomdb4odocandroidcompareDb4oExample.Java_Srccomdb4odocandroidcompareDb4oExample.Java_AddCar_441_90_67_166_Open_Text"><span style="color: #000000;">{
</span><span style="color: #008080;">3</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;"> </span><span style="color: #0000FF;">new</span><span style="color: #000000;"> Car(</span><span style="color: #000000;">"</span><span style="color: #000000;">BMW</span><span style="color: #000000;">"</span><span style="color: #000000;">);
</span><span style="color: #008080;">4</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;">Tester</span><span style="color: #000000;">"</span><span style="color: #000000;">, points));
</span><span style="color: #008080;">5</span><span style="color: #000000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> container.set(car);
</span><span style="color: #008080;">6</span><span style="color: #000000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ExpandedBlockEnd.gif" align="top"/> }</span></span></div></pre></div></div>
<p>You can see that db4o handles adding objects to the database in a much more elegant way - #set(object) method is enough. In SQLite case it is much more difficult as you mush store different objects into different tables. Some of the additional work that SQLite developer will have to do is not visible in this example, i.e:</p><ul><li>the developer will have to ensure that the sequence of insert commands starts from children objects and goes up to the parent (this can be a really difficult task for relational models including lots of foreign key dependencies);</li><li>in most cases the data for insertion will come from business objects, which will mean that the object model will have to be transferred to relational model.<br></li></ul></div>
</div>
<div id="footer">
This revision (3) was last Modified 2007-12-09T08:46:52 by Tetyana.
</div>
</body>
</html>
