Techalert

Android Application’s Basic Core Components

<div dir="ltr" style="text-align: left;" trbidi="on">
App components are the essential building blocks of an Android app. Each component is a different point through which the system can enter your app.<br />
<div>
<br /></div>
<div>
Not all components are actual entry points for the user and some depend on each other, but each one exists as its own entity and plays a specific role each one is a unique building block that helps define your app's overall behavior.<br />
<div>
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhUHQvEU8yqk9vtDvw7thBsbqDJ1NuAgCYX4sZBTryY1_U8g0Dz1kCDUwJ2X4A0VPueorEfw4coG7bZjUWB70_ulthCwbVtkZdVHTwcYa8AC2PUjJHAPr8kPwP1TrYAU-F9AeyLt4HGqQ/s1600/android-core.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="Android Apps Core Components" border="0" height="260" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhUHQvEU8yqk9vtDvw7thBsbqDJ1NuAgCYX4sZBTryY1_U8g0Dz1kCDUwJ2X4A0VPueorEfw4coG7bZjUWB70_ulthCwbVtkZdVHTwcYa8AC2PUjJHAPr8kPwP1TrYAU-F9AeyLt4HGqQ/s1600/android-core.jpg" title="Android Apps Core Components" width="550" /></a></div>
<div>
<br />
There are four different types of app components. Each type serves a distinct purpose and has a distinct lifecycle that defines how the component is created and destroyed.<br />
<div>
<br /></div>
An Android application consists four types of app core components.<br />
<br />
Like musicians in an orchestra, the independent core components cooperate with each other contributing somehow to the success of the application.<br />
<br />
A core component can be:<br />
1. An Activity<br />
2. A Service<br />
3. A broadcast receiver<br />
4. A content provider<br />
<br />
<b>Here is details of four core component of android...</b><br />
<br />
<b>1. Activity</b><br />
<ul style="text-align: left;">
<li>A typical Android application consists of one or more activities.</li>
<li>An activity is roughly equivalent to a Windows-Form .</li>
<li>An activity usually shows a single visual user interface (UI).</li>
<li>Only one activity is chosen to be executed first when the application is launched.</li>
<li>An activity may transfer control and data to another activity through an interprocess communication protocol called intents.</li>
</ul>
<br />
<b>2. Service</b><br />
<ul style="text-align: left;">
<li>Services are a special type of activity that do not have a visual user interface.</li>
<li>Services usually run in the background for an indefinite period of time.</li>
<li>Applications start their own services or connect to services already active.</li>
<li><b>For example,</b> your background GPS service could be set to inconspicuosly run in the backgroud detecting satellite, phone tower or wi-fi router location information. The service periodically broadcast location coordinates to any application listening for that kind of data. An application may bind to the running GPS service or be the first to execute it.</li>
</ul>
<br />
<b>3. Broadcast receiver</b><br />
<ul style="text-align: left;">
<li>A BroadcastReceiver is a dedicated listener that waits for system-wide or locally transmitted messages.</li>
<li>Broadcast receivers do not display a user interface.</li>
<li>They tipically register with the system by means of a filter acting as a key.</li>
<li>When the broadcasted message matches the key the receiver is activated.</li>
<li>A broadcast receiver could respond by either executing a specific activity or use the notification mechanism to request the user‘s attention.</li>
</ul>
<br />
<b>4. Content provider</b><br />
<ul style="text-align: left;">
<li>A content provider is a data-centric service that makes persistent datasets available to any number of applications.</li>
<li>Common global datasets include: contacts, pictures, messages, audio files, emails.</li>
<li>The global datasets are usually stored in a SQLite database.</li>
<li>The content provider class offers a standard set of “database-like“ methods to enable other applications to retrieve, delete, update, and insert data items.</li>
</ul>
<div>
<b>Read More:</b></div>
</div>
</div>
<ol style="text-align: left;">
<li><a href="http://www.itechaleart.com/2015/01/what-is-android.html">What is Android? Introduction, Features and Applications.</a></li>
<li><a href="http://www.itechaleart.com/2015/01/android-resource-for-beginner.html">Android Resources for Beginner to Learn Apps Development</a></li>
<li><a href="http://www.itechaleart.com/2013/12/unlock-android-after-too-many-pattern-attempts.html">Unlock Android After Too Many Pattern Attempts</a></li>
<li><a href="http://www.itechaleart.com/2013/10/how-to-speed-up-android-phone.html">How to Speed-up Android Phone</a></li>
<li><a href="http://www.itechaleart.com/2014/06/android-secret-codes.html">Android Secret Codes for All Mobile</a></li>
</ol>
</div>

Android Application’s Basic Core Components

App components are the essential building blocks of an Android app. Each component is a different point through which the system can enter ...

Blogspot SEO Tips For bloggers

<div dir="ltr" style="text-align: left;" trbidi="on">
<div style="background-color: white; color: #666666; font-family: 'Lucida Sans Unicode', Verdana, Arial, sans-serif; font-size: 14px; line-height: 28px; margin-bottom: 12px; margin-top: 12px; padding: 0px; text-align: justify;">
Everyone knows that Blogger is a product of Google and how popular the CMS is among the Bloggers. There is a myth among Bloggers that <a href="http://www.itechaleart.com/search/label/blogger" style="border: none; color: black; margin: 0px; padding: 0px;">Blogger blog</a> is SEO friendly as it is owned by Google itself. Surprisingly, the fact is that no CMS is SEO friendly by default. We as a user should optimize it for search engines. Until a year back, Blogger used to lack many <a href="http://www.itechaleart.com/search/label/seo" style="border: none; color: black; margin: 0px; padding: 0px;">popular SEO features</a> that most other popular CMS like WordPress and Joomla. But, Google has added several useful SEO features to the Blogger platform and those include – Custom Robots.txt, Search Description for all Blogger Posts, an option to 301 redirect blogger posts, custom permalinks, custom 404 page and much more.</div>
<div style="background-color: white; color: #666666; font-family: 'Lucida Sans Unicode', Verdana, Arial, sans-serif; font-size: 14px; line-height: 28px; margin-bottom: 12px; margin-top: 12px; padding: 0px; text-align: justify;">
I’ve talked about those features in detail earlier separately but today I just wanted to list the <em style="margin: 0px; padding: 0px;"><strong style="margin: 0px; padding: 0px;">SEO benefits of Blogger</strong></em> as a whole along with a process on how to optimize them (with settings).</div>
<h2 style="background-color: white; border-bottom-color: rgb(229, 229, 229); border-bottom-style: solid; border-bottom-width: 1px; color: #333333; font-family: 'Lucida Sans Unicode', Verdana, Arial, sans-serif; font-size: 16.5px; letter-spacing: -1px; line-height: 13px; margin: 0px 0px 5px; padding: 0px 0px 7px;">
<b style="margin: 0px; padding: 0px;">How to Make Your Blogger Blog SEO Friendly?</b></h2>
<h3 style="background-color: white; border-bottom-color: rgb(229, 229, 229); border-bottom-style: solid; border-bottom-width: 1px; color: #111111; font-family: 'Lucida Sans Unicode', Verdana, Arial, sans-serif; font-size: 15px; font-weight: normal; letter-spacing: -1px; line-height: 18px; margin: 12px 0px 10px; padding: 10px 0px; text-align: justify;">
Title Tag Optimization</h3>
<div style="background-color: white; color: #666666; font-family: 'Lucida Sans Unicode', Verdana, Arial, sans-serif; font-size: 14px; line-height: 28px; margin-bottom: 12px; margin-top: 12px; padding: 0px; text-align: justify;">
If you’re using any <a href="http://www.itechaleart.com/search/label/blogger" style="border: none; color: black; margin: 0px; padding: 0px;">default blogger templates</a>, you might’ve noticed that your homepage title appears after every post title in search results. Since Google displays only the first 66 characters of your title, your actual title that come after your home page title will get ignored most of the time. If you’ve targeted any important keywords in your post title, then they’ll be chopped off because of the home page title being appended before it.</div>
<div style="background-color: white; color: #666666; font-family: 'Lucida Sans Unicode', Verdana, Arial, sans-serif; font-size: 14px; line-height: 28px; margin-bottom: 12px; margin-top: 12px; padding: 0px; text-align: justify;">
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgaKMkz3e8OArQsA9HxoGXYvDpPNRfd-GA1l8QB88TXde1bV2i9FrQJnICSJRFD3hJgxdXLGls8mH0KwHu4yNaG46ggAyBba5ZaL9p3VjTtuscMp9QxP3LzJAKBUMMm0lLDm19gd0heRw/s1600/SEO.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="Blogspot SEO Tips For bloggers" border="0" height="300" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgaKMkz3e8OArQsA9HxoGXYvDpPNRfd-GA1l8QB88TXde1bV2i9FrQJnICSJRFD3hJgxdXLGls8mH0KwHu4yNaG46ggAyBba5ZaL9p3VjTtuscMp9QxP3LzJAKBUMMm0lLDm19gd0heRw/s1600/SEO.jpg" width="450" /></a></div>
</div>
<div style="background-color: white; color: #666666; font-family: 'Lucida Sans Unicode', Verdana, Arial, sans-serif; font-size: 14px; line-height: 28px; margin-bottom: 12px; margin-top: 12px; padding: 0px; text-align: justify;">
In order to optimize your Title tags, follow the below steps.</div>
<ol style="background-color: white; color: #666666; font-family: 'Lucida Sans Unicode', Verdana, Arial, sans-serif; font-size: 14px; line-height: 28px; margin: 12px 0px; padding: 0px 0px 0px 30px; text-align: justify;">
<li style="line-height: 21px; margin: 0px 0px 5px 35px; padding: 0px; position: relative;">Blogger > Template > Edit HTML</li>
<li style="line-height: 21px; margin: 0px 0px 5px 35px; padding: 0px; position: relative;">Search for the below code in the <head> section of your template<br style="margin: 0px; padding: 0px;" /><blockquote style="background-color: #eeeeee; background-position: 0% 0%; background-repeat: no-repeat no-repeat; color: #333333; margin: 1em; padding: 1px 10px;">
<div style="margin-bottom: 12px; margin-top: 12px; padding: 0px;">
<title><data:blog.pageTitle/></title></div>
</blockquote>
</li>
<li style="line-height: 21px; margin: 0px 0px 5px 35px; padding: 0px; position: relative;">Replace it with the below code<br style="margin: 0px; padding: 0px;" /><blockquote style="background-color: #eeeeee; background-position: 0% 0%; background-repeat: no-repeat no-repeat; color: #333333; margin: 1em; padding: 1px 10px;">
<div style="margin-bottom: 12px; margin-top: 12px; padding: 0px;">
<b:if cond=’data:blog.pageType == &quot;item&quot;’><br />
<title><data:blog.pageName/> | <data:blog.title/></title><br />
<b:else/><br />
<title><data:blog.pageTitle/></title><br />
</b:if></div>
</blockquote>
</li>
<li style="line-height: 21px; margin: 0px 0px 5px 35px; padding: 0px; position: relative;">Now, save your template.</li>
</ol>
<h3 style="background-color: white; border-bottom-color: rgb(229, 229, 229); border-bottom-style: solid; border-bottom-width: 1px; color: #111111; font-family: 'Lucida Sans Unicode', Verdana, Arial, sans-serif; font-size: 15px; font-weight: normal; letter-spacing: -1px; line-height: 18px; margin: 12px 0px 10px; padding: 10px 0px; text-align: justify;">
Change your Post title Heading Tag</h3>
<div style="background-color: white; color: #666666; font-family: 'Lucida Sans Unicode', Verdana, Arial, sans-serif; font-size: 14px; line-height: 28px; margin-bottom: 12px; margin-top: 12px; padding: 0px; text-align: justify;">
By default, all <a href="http://www.itechaleart.com/search/label/blogger" style="border: none; color: black; margin: 0px; padding: 0px;">blogger templates</a> use H1 for homepage title, H2 for blog description and H3 to post titles. Due to the fact that the post titles are the second most important part of your blog after the main title, you should assign them an H2 instead of H3.</div>
<ol style="background-color: white; color: #666666; font-family: 'Lucida Sans Unicode', Verdana, Arial, sans-serif; font-size: 14px; line-height: 28px; margin: 12px 0px; padding: 0px 0px 0px 30px; text-align: justify;">
<li style="line-height: 21px; margin: 0px 0px 5px 35px; padding: 0px; position: relative;">Go to Template | Edit HTML</li>
<li style="line-height: 21px; margin: 0px 0px 5px 35px; padding: 0px; position: relative;">Search for .post h3 and replace all the occurrences of it with .post h2.</li>
<li style="line-height: 21px; margin: 0px 0px 5px 35px; padding: 0px; position: relative;">Next search for,<br style="margin: 0px; padding: 0px;" /><blockquote style="background-color: #eeeeee; background-position: 0% 0%; background-repeat: no-repeat no-repeat; color: #333333; margin: 1em; padding: 1px 10px;">
<div style="margin-bottom: 12px; margin-top: 12px; padding: 0px;">
<h3><data:title/></h3></div>
</blockquote>
</li>
<li style="line-height: 21px; margin: 0px 0px 5px 35px; padding: 0px; position: relative;">Replace it with the below code<br style="margin: 0px; padding: 0px;" /><blockquote style="background-color: #eeeeee; background-position: 0% 0%; background-repeat: no-repeat no-repeat; color: #333333; margin: 1em; padding: 1px 10px;">
<div style="margin-bottom: 12px; margin-top: 12px; padding: 0px;">
<h2><data:title/></h2></div>
</blockquote>
</li>
<li style="line-height: 21px; margin: 0px 0px 5px 35px; padding: 0px; position: relative;">Save template.</li>
</ol>
<h3 style="background-color: white; border-bottom-color: rgb(229, 229, 229); border-bottom-style: solid; border-bottom-width: 1px; color: #111111; font-family: 'Lucida Sans Unicode', Verdana, Arial, sans-serif; font-size: 15px; font-weight: normal; letter-spacing: -1px; line-height: 18px; margin: 12px 0px 10px; padding: 10px 0px; text-align: justify;">
Meta Description</h3>
<div style="background-color: white; color: #666666; font-family: 'Lucida Sans Unicode', Verdana, Arial, sans-serif; font-size: 14px; line-height: 28px; margin-bottom: 12px; margin-top: 12px; padding: 0px; text-align: justify;">
Blogger has implemented another much-awaited feature called ‘Search Description’. This allows us to provide a meta description to every post individually. If you’re using the default template provided by Blogger, you can simply activate this feature by going to Settings > Search Preferences and provide the description for your homepage under ‘Meta Tags’ section. Doing so will enable ‘Search Description’ option for all individual posts & you can see it on the right sidebar while you are on the post editor.</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjhX1SNe34f-Ss47XOFl-Xm0ImkOqWWeLb6Bunq7SF_IDJyMk22_NoScxO7SMJgIO53_mzqY2I9DdQE74sv4yvqglOfQl-fkguuce7I1-XBBAPPWHzlkj1gRD3BbjocgjaSII6XcEDgiA/s1600/Add-search-description-for-blogspot.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="Add search description for blogspot" border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjhX1SNe34f-Ss47XOFl-Xm0ImkOqWWeLb6Bunq7SF_IDJyMk22_NoScxO7SMJgIO53_mzqY2I9DdQE74sv4yvqglOfQl-fkguuce7I1-XBBAPPWHzlkj1gRD3BbjocgjaSII6XcEDgiA/s1600/Add-search-description-for-blogspot.png" /></a></div>
<div style="background-color: white; color: #666666; font-family: 'Lucida Sans Unicode', Verdana, Arial, sans-serif; font-size: 14px; line-height: 28px; margin-bottom: 12px; margin-top: 12px; padding: 0px; text-align: justify;">
In case you’re using a custom or third-party templates, along with the above settings, you’ll also need to add a small piece of code in your template.</div>
<div style="background-color: white; color: #666666; font-family: 'Lucida Sans Unicode', Verdana, Arial, sans-serif; font-size: 14px; line-height: 28px; margin-bottom: 12px; margin-top: 12px; padding: 0px; text-align: justify;">
Add the below code under the <head> tag in your template.</div>
<blockquote style="background-color: #eeeeee; background-position: 0% 0%; background-repeat: no-repeat no-repeat; color: #333333; font-family: 'Lucida Sans Unicode', Verdana, Arial, sans-serif; font-size: 14px; line-height: 28px; margin: 1em; padding: 1px 10px; text-align: justify;">
<div style="margin-bottom: 12px; margin-top: 12px; padding: 0px;">
<b:if cond=’data:blog.metaDescription != &quot;&quot;’><br />
<meta expr:content=’data:blog.metaDescription’ name=’description’/><br />
</b:if></div>
</blockquote>
<h3 style="background-color: white; border-bottom-color: rgb(229, 229, 229); border-bottom-style: solid; border-bottom-width: 1px; color: #111111; font-family: 'Lucida Sans Unicode', Verdana, Arial, sans-serif; font-size: 15px; font-weight: normal; letter-spacing: -1px; line-height: 18px; margin: 12px 0px 10px; padding: 10px 0px; text-align: justify;">
Robots.txt Settings for Blogger</h3>
<div style="background-color: white; color: #666666; font-family: 'Lucida Sans Unicode', Verdana, Arial, sans-serif; font-size: 14px; line-height: 28px; margin-bottom: 12px; margin-top: 12px; padding: 0px; text-align: justify;">
The robots.txt file in Blogger will have the default settings which are not sufficient enough to control the search engines actions. By default, all your posts and labels will get indexed by the search engines like Google & Bing, thus creating a lot of <a href="http://www.itechaleart.com/2014/01/online-duplicate-content-checkers.html" style="border: none; color: black; margin: 0px; padding: 0px;">duplicate content issues</a> inside your own blog. In order to avoid such technical issues, it’s wise to make a better use of the robots.txt file.</div>
<div style="background-color: white; color: #666666; font-family: 'Lucida Sans Unicode', Verdana, Arial, sans-serif; font-size: 14px; line-height: 28px; margin-bottom: 12px; margin-top: 12px; padding: 0px; text-align: justify;">
Settings > Search Preference > Enable ‘Custom robots.txt’ under ‘Crawlers and indexing’ section and use the below text.</div>
<blockquote style="background-color: #eeeeee; background-position: 0% 0%; background-repeat: no-repeat no-repeat; color: #333333; font-family: 'Lucida Sans Unicode', Verdana, Arial, sans-serif; font-size: 14px; line-height: 28px; margin: 1em; padding: 1px 10px; text-align: justify;">
<div style="margin-bottom: 12px; margin-top: 12px; padding: 0px;">
User-agent: Mediapartners-Google<br />
Disallow:<br />
User-agent: *<br />
Disallow: /search/<br />
Disallow: /search?<br />
Disallow: /search?q=*<br />
Disallow: /*?updated-max=*<br />
Disallow: /p/about.html<br />
Disallow: /p/privacy.html<br />
Allow: /</div>
<div style="margin-bottom: 12px; margin-top: 12px; padding: 0px;">
Sitemap: http://www.itechaleart.com/atom.xml?redirect=false&start-index=1&max-results=500</div>
</blockquote>
<h4 style="background-color: white; color: #666666; font-family: 'Lucida Sans Unicode', Verdana, Arial, sans-serif; font-size: 14px; line-height: 28px; margin: 12px 0px; padding: 0px; text-align: justify;">
Points to Remember</h4>
<ul style="background-color: white; color: #666666; font-family: 'Lucida Sans Unicode', Verdana, Arial, sans-serif; font-size: 14px; line-height: 28px; list-style: none; margin: 12px 0px; padding: 0px; text-align: justify;">
<li style="background-image: url(https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgJQRzZLXMPrEb64SK4BthGm9G9D0qm-8lWVe93CCd32A0KofmxCideg1FlLIx76vgTdtWFiLSpDsF-ePci-0jLN6TrH2e1EW01gVRC8NWkAO-MERKwjeEfkZ8pBsgCxeAfB2dzGEMxjoo/s1600/li.gif); background-position: 15px 7px; background-repeat: no-repeat no-repeat; margin: 0px 0px 5px; padding: 0px 0px 0px 33px; position: relative;">Replace my domain name with yours in the sitemap section.</li>
<li style="background-image: url(https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgJQRzZLXMPrEb64SK4BthGm9G9D0qm-8lWVe93CCd32A0KofmxCideg1FlLIx76vgTdtWFiLSpDsF-ePci-0jLN6TrH2e1EW01gVRC8NWkAO-MERKwjeEfkZ8pBsgCxeAfB2dzGEMxjoo/s1600/li.gif); background-position: 15px 7px; background-repeat: no-repeat no-repeat; margin: 0px 0px 5px; padding: 0px 0px 0px 33px; position: relative;">If you’ve more than 500 posts, then simply use this <a href="http://ctrlq.org/blogger/" style="border: none; color: #333333; margin: 0px; padding: 0px;" target="_blank">tool</a> to generate the Sitemaps based on your post count.</li>
<li style="background-image: url(https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgJQRzZLXMPrEb64SK4BthGm9G9D0qm-8lWVe93CCd32A0KofmxCideg1FlLIx76vgTdtWFiLSpDsF-ePci-0jLN6TrH2e1EW01gVRC8NWkAO-MERKwjeEfkZ8pBsgCxeAfB2dzGEMxjoo/s1600/li.gif); background-position: 15px 7px; background-repeat: no-repeat no-repeat; margin: 0px 0px 5px; padding: 0px 0px 0px 33px; position: relative;">You can also chose to disallow your privacy and about pages from being indexed. Make sure you change the my URLs with your own permalinks before saving.</li>
</ul>
<h3 style="background-color: white; border-bottom-color: rgb(229, 229, 229); border-bottom-style: solid; border-bottom-width: 1px; color: #111111; font-family: 'Lucida Sans Unicode', Verdana, Arial, sans-serif; font-size: 15px; font-weight: normal; letter-spacing: -1px; line-height: 18px; margin: 12px 0px 10px; padding: 10px 0px; text-align: justify;">
Add NoFollow Tag to All Labels</h3>
<div style="background-color: white; color: #666666; font-family: 'Lucida Sans Unicode', Verdana, Arial, sans-serif; font-size: 14px; line-height: 28px; margin-bottom: 12px; margin-top: 12px; padding: 0px; text-align: justify;">
Although you’ve disallowed indexing of Labels using the robots.txt file, it is better to add a nofollow tag to them so that there will be no chance for them to get indexed. Go to Template > Edit HTML and search for the below code.</div>
<blockquote style="background-color: #eeeeee; background-position: 0% 0%; background-repeat: no-repeat no-repeat; color: #333333; font-family: 'Lucida Sans Unicode', Verdana, Arial, sans-serif; font-size: 14px; line-height: 28px; margin: 1em; padding: 1px 10px; text-align: justify;">
<div style="margin-bottom: 12px; margin-top: 12px; padding: 0px;">
<a expr:href=’data:label.url’ rel=’tag’></div>
</blockquote>
<div style="background-color: white; color: #666666; font-family: 'Lucida Sans Unicode', Verdana, Arial, sans-serif; font-size: 14px; line-height: 28px; margin-bottom: 12px; margin-top: 12px; padding: 0px; text-align: justify;">
Either add the nofollow tag to the end of the above syntax or simply replace it with the below one.</div>
<blockquote style="background-color: #eeeeee; background-position: 0% 0%; background-repeat: no-repeat no-repeat; color: #333333; font-family: 'Lucida Sans Unicode', Verdana, Arial, sans-serif; font-size: 14px; line-height: 28px; margin: 1em; padding: 1px 10px; text-align: justify;">
<div style="margin-bottom: 12px; margin-top: 12px; padding: 0px;">
<a expr:href=’data:label.url’ rel=’tag,nofollow’></div>
</blockquote>
<div style="background-color: white; color: #666666; font-family: 'Lucida Sans Unicode', Verdana, Arial, sans-serif; font-size: 14px; line-height: 28px; margin-bottom: 12px; margin-top: 12px; padding: 0px; text-align: justify;">
Save your template.</div>
<h3 style="background-color: white; border-bottom-color: rgb(229, 229, 229); border-bottom-style: solid; border-bottom-width: 1px; color: #111111; font-family: 'Lucida Sans Unicode', Verdana, Arial, sans-serif; font-size: 15px; font-weight: normal; letter-spacing: -1px; line-height: 18px; margin: 12px 0px 10px; padding: 10px 0px; text-align: justify;">
Custom Robots Header Tags</h3>
<div style="background-color: white; color: #666666; font-family: 'Lucida Sans Unicode', Verdana, Arial, sans-serif; font-size: 14px; line-height: 28px; margin-bottom: 12px; margin-top: 12px; padding: 0px; text-align: justify;">
These robots tags will go in the header section of your blog. You can use these settings to disable indexing of archive and search pages in search results. Go to Settings > Search Preferences > ‘Enable custom robots header tags?’ under the ‘Crawlers and indexing’ section. Next, use the below settings.</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg2Smfh-LS69XxCkR0KGc71ONGOreB4iOForxmhlrHt0p_DzgOhPKEg__RT5t1sYuo3Gw7Uc8MqXX33Z3Hey7Y6vGcyFFYkgHk6Q_Due2H2DqgutoGQMGbfGee9iJ2CohT3iNr4Rkj4Ag/s1600/Custom-robots-header-tags-blogger.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="Custom robots header tags blogger" border="0" height="300" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg2Smfh-LS69XxCkR0KGc71ONGOreB4iOForxmhlrHt0p_DzgOhPKEg__RT5t1sYuo3Gw7Uc8MqXX33Z3Hey7Y6vGcyFFYkgHk6Q_Due2H2DqgutoGQMGbfGee9iJ2CohT3iNr4Rkj4Ag/s1600/Custom-robots-header-tags-blogger.png" width="550" /></a></div>
<div style="background-color: white; color: #666666; font-family: 'Lucida Sans Unicode', Verdana, Arial, sans-serif; font-size: 14px; line-height: 28px; margin-bottom: 12px; margin-top: 12px; padding: 0px; text-align: justify;">
In case you don’t understand the meaning and use of these commands, then know about them <a href="https://developers.google.com/webmasters/control-crawl-index/docs/robots_meta_tag" style="border: none; color: black; margin: 0px; padding: 0px;" target="_blank">here</a>.</div>
<h3 style="background-color: white; border-bottom-color: rgb(229, 229, 229); border-bottom-style: solid; border-bottom-width: 1px; color: #111111; font-family: 'Lucida Sans Unicode', Verdana, Arial, sans-serif; font-size: 15px; font-weight: normal; letter-spacing: -1px; line-height: 18px; margin: 12px 0px 10px; padding: 10px 0px; text-align: justify;">
Submit Blogger Sitemap to Google & Bing</h3>
<div style="background-color: white; color: #666666; font-family: 'Lucida Sans Unicode', Verdana, Arial, sans-serif; font-size: 14px; line-height: 28px; margin-bottom: 12px; margin-top: 12px; padding: 0px; text-align: justify;">
Although Google & Bing can find your blog, they cannot index your entire site as they won’t have a clue what pages are listed on your blog. This is why the Sitemaps existed. Generate sitemap for your blogger blog (use this <a href="http://ctrlq.org/blogger/" style="border: none; color: black; margin: 0px; padding: 0px;" target="_blank">tool</a>) and then submit them to both <a href="http://www.google.com/webmasters/tools/" style="border: none; color: black; margin: 0px; padding: 0px;" target="_blank">Google Webmaster Tools</a> & <a href="http://www.bing.com/toolbox/webmaster" style="border: none; color: black; margin: 0px; padding: 0px;" target="_blank">Bing Webmasters</a>. Doing so will not only helps the search engines to crawl your blog efficiently but also let you to monitor your SEO score using their dashboard.</div>
<div style="background-color: white; color: #666666; font-family: 'Lucida Sans Unicode', Verdana, Arial, sans-serif; font-size: 14px; line-height: 28px; margin-bottom: 12px; margin-top: 12px; padding: 0px; text-align: justify;">
Note: You’ll need to place their tag on your site under <head> tag in order to verify your ownership.</div>
<h3 style="background-color: white; border-bottom-color: rgb(229, 229, 229); border-bottom-style: solid; border-bottom-width: 1px; color: #111111; font-family: 'Lucida Sans Unicode', Verdana, Arial, sans-serif; font-size: 15px; font-weight: normal; letter-spacing: -1px; line-height: 18px; margin: 12px 0px 10px; padding: 10px 0px; text-align: justify;">
Optimize URL Parameters in Webmaster Tools</h3>
<div style="background-color: white; color: #666666; font-family: 'Lucida Sans Unicode', Verdana, Arial, sans-serif; font-size: 14px; line-height: 28px; margin-bottom: 12px; margin-top: 12px; padding: 0px; text-align: justify;">
URL parameters help the search engines to crawl your site even more efficiently. Prioritize your  most useful content by controlling the URL parameters that effect your site content. Simply, go to WMT > Configuration > URL parameters and the add the below parameters one by one. Watch the screenshot in case of any doubts.</div>
<blockquote style="background-color: #eeeeee; background-position: 0% 0%; background-repeat: no-repeat no-repeat; color: #333333; font-family: 'Lucida Sans Unicode', Verdana, Arial, sans-serif; font-size: 14px; line-height: 28px; margin: 1em; padding: 1px 10px; text-align: justify;">
<ul style="list-style: none; margin: 12px 0px; padding: 0px;">
<li style="background-image: url(https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgJQRzZLXMPrEb64SK4BthGm9G9D0qm-8lWVe93CCd32A0KofmxCideg1FlLIx76vgTdtWFiLSpDsF-ePci-0jLN6TrH2e1EW01gVRC8NWkAO-MERKwjeEfkZ8pBsgCxeAfB2dzGEMxjoo/s1600/li.gif); background-position: 15px 7px; background-repeat: no-repeat no-repeat; margin: 0px 0px 5px; padding: 0px 0px 0px 33px; position: relative;">utm_source > No > Let Googlebot decide</li>
<li style="background-image: url(https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgJQRzZLXMPrEb64SK4BthGm9G9D0qm-8lWVe93CCd32A0KofmxCideg1FlLIx76vgTdtWFiLSpDsF-ePci-0jLN6TrH2e1EW01gVRC8NWkAO-MERKwjeEfkZ8pBsgCxeAfB2dzGEMxjoo/s1600/li.gif); background-position: 15px 7px; background-repeat: no-repeat no-repeat; margin: 0px 0px 5px; padding: 0px 0px 0px 33px; position: relative;">utm_medium > No > Let Googlebot decide</li>
<li style="background-image: url(https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgJQRzZLXMPrEb64SK4BthGm9G9D0qm-8lWVe93CCd32A0KofmxCideg1FlLIx76vgTdtWFiLSpDsF-ePci-0jLN6TrH2e1EW01gVRC8NWkAO-MERKwjeEfkZ8pBsgCxeAfB2dzGEMxjoo/s1600/li.gif); background-position: 15px 7px; background-repeat: no-repeat no-repeat; margin: 0px 0px 5px; padding: 0px 0px 0px 33px; position: relative;">utm_campaign > No > Let Googlebot decide</li>
<li style="background-image: url(https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgJQRzZLXMPrEb64SK4BthGm9G9D0qm-8lWVe93CCd32A0KofmxCideg1FlLIx76vgTdtWFiLSpDsF-ePci-0jLN6TrH2e1EW01gVRC8NWkAO-MERKwjeEfkZ8pBsgCxeAfB2dzGEMxjoo/s1600/li.gif); background-position: 15px 7px; background-repeat: no-repeat no-repeat; margin: 0px 0px 5px; padding: 0px 0px 0px 33px; position: relative;">updated-max > Yes > Sorts > Let Googlebot decide</li>
<li style="background-image: url(https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgJQRzZLXMPrEb64SK4BthGm9G9D0qm-8lWVe93CCd32A0KofmxCideg1FlLIx76vgTdtWFiLSpDsF-ePci-0jLN6TrH2e1EW01gVRC8NWkAO-MERKwjeEfkZ8pBsgCxeAfB2dzGEMxjoo/s1600/li.gif); background-position: 15px 7px; background-repeat: no-repeat no-repeat; margin: 0px 0px 5px; padding: 0px 0px 0px 33px; position: relative;">showComment > No > Let Google bot decide</li>
<li style="background-image: url(https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgJQRzZLXMPrEb64SK4BthGm9G9D0qm-8lWVe93CCd32A0KofmxCideg1FlLIx76vgTdtWFiLSpDsF-ePci-0jLN6TrH2e1EW01gVRC8NWkAO-MERKwjeEfkZ8pBsgCxeAfB2dzGEMxjoo/s1600/li.gif); background-position: 15px 7px; background-repeat: no-repeat no-repeat; margin: 0px 0px 5px; padding: 0px 0px 0px 33px; position: relative;">max-results > Yes > Sorts > Let Google bot decide</li>
<li style="background-image: url(https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgJQRzZLXMPrEb64SK4BthGm9G9D0qm-8lWVe93CCd32A0KofmxCideg1FlLIx76vgTdtWFiLSpDsF-ePci-0jLN6TrH2e1EW01gVRC8NWkAO-MERKwjeEfkZ8pBsgCxeAfB2dzGEMxjoo/s1600/li.gif); background-position: 15px 7px; background-repeat: no-repeat no-repeat; margin: 0px 0px 5px; padding: 0px 0px 0px 33px; position: relative;">m > Yes > Paginates > Let Google bot decide</li>
<li style="background-image: url(https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgJQRzZLXMPrEb64SK4BthGm9G9D0qm-8lWVe93CCd32A0KofmxCideg1FlLIx76vgTdtWFiLSpDsF-ePci-0jLN6TrH2e1EW01gVRC8NWkAO-MERKwjeEfkZ8pBsgCxeAfB2dzGEMxjoo/s1600/li.gif); background-position: 15px 7px; background-repeat: no-repeat no-repeat; margin: 0px 0px 5px; padding: 0px 0px 0px 33px; position: relative;">commentPage > Yes > Paginates > Every URL</li>
</ul>
</blockquote>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhB_pk8ffahM5DkfvMJ9lQkBXUFOALPTSz6uM9C7VSzf-05yEnBaip9Uo1rmMrfuIYo0lvwszOA-L7objDso1gTkpY6HsZDl_c4x-TkvXkmSKyzOF1tPkihw3_N4C-exLp3D_9f3fv4vg/s1600/webmaster-tools-url-parameters-blogger.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="webmaster tools url parameters blogger" border="0" height="250" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhB_pk8ffahM5DkfvMJ9lQkBXUFOALPTSz6uM9C7VSzf-05yEnBaip9Uo1rmMrfuIYo0lvwszOA-L7objDso1gTkpY6HsZDl_c4x-TkvXkmSKyzOF1tPkihw3_N4C-exLp3D_9f3fv4vg/s1600/webmaster-tools-url-parameters-blogger.png" width="550" /></a></div>
<div style="background-color: white; color: #666666; font-family: 'Lucida Sans Unicode', Verdana, Arial, sans-serif; font-size: 14px; line-height: 28px; margin-bottom: 12px; margin-top: 12px; padding: 0px; text-align: justify;">
<br /></div>
<h3 style="background-color: white; border-bottom-color: rgb(229, 229, 229); border-bottom-style: solid; border-bottom-width: 1px; color: #111111; font-family: 'Lucida Sans Unicode', Verdana, Arial, sans-serif; font-size: 15px; font-weight: normal; letter-spacing: -1px; line-height: 18px; margin: 12px 0px 10px; padding: 10px 0px; text-align: justify;">
Redirect Broken Links</h3>
<div style="background-color: white; color: #666666; font-family: 'Lucida Sans Unicode', Verdana, Arial, sans-serif; font-size: 14px; line-height: 28px; margin-bottom: 12px; margin-top: 12px; padding: 0px; text-align: justify;">
Just go to your webmaster tools account and from Health > Crawl Errors, find out if there are any 404 errors on your blog. If there are any such errors, simply use a 301 to redirect them to the correct locations on your blog.</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj06gF0R5jMAs2C7gDqYK-aFAdlOI4TLBKRewYcEaX__7p2hYy0sa-5HsJbHNWNKg9dRWkIz3A2bEICjtMqDDIqFksbcHyPbdSReOneL996f8yhCveBRYAsEQyBrTVk_d8IcAHT7vEJDQ/s1600/301-Redirect-Blogger-Posts.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="301 Redirect Blogger Posts" border="0" height="300" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj06gF0R5jMAs2C7gDqYK-aFAdlOI4TLBKRewYcEaX__7p2hYy0sa-5HsJbHNWNKg9dRWkIz3A2bEICjtMqDDIqFksbcHyPbdSReOneL996f8yhCveBRYAsEQyBrTVk_d8IcAHT7vEJDQ/s1600/301-Redirect-Blogger-Posts.png" width="550" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div style="background-color: white; color: #666666; font-family: 'Lucida Sans Unicode', Verdana, Arial, sans-serif; font-size: 14px; line-height: 28px; margin-bottom: 12px; margin-top: 12px; padding: 0px; text-align: justify;">
Go to Settings > Errors and redirections > Custom Redirects.</div>
<div style="background-color: white; color: #666666; font-family: 'Lucida Sans Unicode', Verdana, Arial, sans-serif; font-size: 14px; line-height: 28px; margin-bottom: 12px; margin-top: 12px; padding: 0px; text-align: justify;">
Apart from these basic settings, make sure you’re optimizing your blog post too. Here are some tips from my end.</div>
<h2 style="background-color: white; border-bottom-color: rgb(229, 229, 229); border-bottom-style: solid; border-bottom-width: 1px; color: #333333; font-family: 'Lucida Sans Unicode', Verdana, Arial, sans-serif; font-size: 16.5px; letter-spacing: -1px; line-height: 13px; margin: 0px 0px 5px; padding: 0px 0px 7px;">
<a href="http://www.9to5blogger.com/write-an-seo-friendly-article/56/" style="border: none; color: #333333; font-weight: normal; margin: 0px; padding: 0px; text-decoration: none;">How to Write a Keyword Efficient Blog Post?</a></h2>
<ol style="background-color: white; color: #666666; font-family: 'Lucida Sans Unicode', Verdana, Arial, sans-serif; font-size: 14px; line-height: 28px; margin: 12px 0px; padding: 0px 0px 0px 30px; text-align: justify;">
<li style="line-height: 21px; margin: 0px 0px 5px 35px; padding: 0px; position: relative;">Analyze & choose a target keyword before writing any article.</li>
<li style="line-height: 21px; margin: 0px 0px 5px 35px; padding: 0px; position: relative;">Use the exact keyword at least twice in the article & use the synonyms (3 times) across the entire article.</li>
<li style="line-height: 21px; margin: 0px 0px 5px 35px; padding: 0px; position: relative;">Ensure that the <a href="http://www.itechaleart.com/2013/07/how-to-create-custom-post-url-in-blogger.html" style="border: none; color: #333333; margin: 0px; padding: 0px;">permalink of your post</a> contains the exact keyword.</li>
<li style="line-height: 21px; margin: 0px 0px 5px 35px; padding: 0px; position: relative;">The title should contain your exact match keyword.</li>
<li style="line-height: 21px; margin: 0px 0px 5px 35px; padding: 0px; position: relative;">Make sure your ‘Search Description’ contains at least 1 exact keyword & 1 synonym.</li>
<li style="line-height: 21px; margin: 0px 0px 5px 35px; padding: 0px; position: relative;">Lastly, give some useful insights in the article and then publish it.</li>
</ol>
<div style="background-color: white; color: #666666; font-family: 'Lucida Sans Unicode', Verdana, Arial, sans-serif; font-size: 14px; line-height: 28px; margin-bottom: 12px; margin-top: 12px; padding: 0px; text-align: justify;">
Note: Never stuff more than the described keyword count as it looks like stuffing keywords in your article. Just use them at appropriate places (wherever suitable).</div>
<div style="background-color: white; color: #666666; font-family: 'Lucida Sans Unicode', Verdana, Arial, sans-serif; font-size: 14px; line-height: 28px; margin-bottom: 12px; margin-top: 12px; padding: 0px; text-align: justify;">
That’s it! Do follow these tips to make your blogspot blog SEO friendly. Happy Blogging. <img alt=":)" class="wp-smiley" src="http://www.9to5blogger.com/wp-includes/images/smilies/icon_smile.gif" style="border: 0px; margin: 0px; padding: 0px;" /></div>
</div>

Blogspot SEO Tips For bloggers

Everyone knows that Blogger is a product of Google and how popular the CMS is among the Bloggers. There is a myth among Bloggers that Blo...

How To Backup and Restore Blogger Blog

<div dir="ltr" style="text-align: left;" trbidi="on">
<div style="background-color: white; border: 0px; box-sizing: border-box; color: #4a4a4a; font-family: 'Pontano Sans', sans-serif; font-size: 16px; line-height: 22.399999618530273px; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline;">
Data is not permanent and there is chance to lose your data any time. So having backup is a must. As last year (2013) statistics they reported that over 20000 blogs or websites are been hacked per day. When we mention about this number anyone can simply understand that all webmasters are in a grate risk of been hacked.</div>
<ul style="background-color: white; border: 0px; box-sizing: border-box; color: #4a4a4a; font-family: 'Pontano Sans', sans-serif; font-size: 16px; line-height: 22.399999618530273px; list-style-image: initial; list-style-position: initial; margin: 0px 0px 1.5em 3em; outline: 0px; padding: 0px; vertical-align: baseline;">
<li style="border: 0px; box-sizing: border-box; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">What if your blog was hacked?</li>
<li style="border: 0px; box-sizing: border-box; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">Do you have backups of your blog?</li>
<li style="border: 0px; box-sizing: border-box; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">Do you even knew you can backup your blog so easily?</li>
</ul>
<div style="background-color: white; border: 0px; box-sizing: border-box; color: #4a4a4a; font-family: 'Pontano Sans', sans-serif; font-size: 16px; line-height: 22.399999618530273px; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline;">
Most of webmasters are not doing this backups. So if they losses there data they have to start again with beginning. but what if you have backups? You can simply restore and start it again easily. Today in this post we are going to talk about how to Backup and Restore your blogger blog. Please note that this steps are only for blogs which are hosted on Blogger.</div>
<h3 style="background-color: white; border: 0px; box-sizing: border-box; clear: both; color: #4a4a4a; font-family: 'Roboto Slab', sans-serif; font-size: 24px; font-weight: 500; line-height: 1.1; margin: 20px 0px 10px; outline: 0px; padding: 0px; vertical-align: baseline;">
<strong style="border: 0px; box-sizing: border-box; font-family: inherit; font-style: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">How to Make a Backup of Blogger Blog</strong></h3>
<div style="background-color: white; border: 0px; box-sizing: border-box; color: #4a4a4a; font-family: 'Pontano Sans', sans-serif; font-size: 16px; line-height: 22.399999618530273px; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline;">
Step 01 : Log in to your blogger blog dashboard.</div>
<div style="background-color: white; border: 0px; box-sizing: border-box; color: #4a4a4a; font-family: 'Pontano Sans', sans-serif; font-size: 16px; line-height: 22.399999618530273px; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline;">
Step 02 : Go to settings tab.</div>
<div style="background-color: white; border: 0px; box-sizing: border-box; color: #4a4a4a; font-family: 'Pontano Sans', sans-serif; font-size: 16px; line-height: 22.399999618530273px; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline;">
Step 03 : Click on Other tab under Settings.</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjGXoNgKRvMMYRmNF94r1UelG_9L71KgGzwutMoVVVuSoHLoCvPwPcf0dcilyg33GXRyBDpETddlojTsypesTTLX7B92jf_-w7UYOteQwBMClpH5zj1-DgVR8wkhkCx1AFg9pEOXtfZOw/s1600/settings.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjGXoNgKRvMMYRmNF94r1UelG_9L71KgGzwutMoVVVuSoHLoCvPwPcf0dcilyg33GXRyBDpETddlojTsypesTTLX7B92jf_-w7UYOteQwBMClpH5zj1-DgVR8wkhkCx1AFg9pEOXtfZOw/s1600/settings.png" /></a></div>
<div style="background-color: white; border: 0px; box-sizing: border-box; color: #4a4a4a; font-family: 'Pontano Sans', sans-serif; font-size: 16px; line-height: 22.399999618530273px; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline;">
<br /></div>
<div style="background-color: white; border: 0px; box-sizing: border-box; color: #4a4a4a; font-family: 'Pontano Sans', sans-serif; font-size: 16px; line-height: 22.399999618530273px; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline;">
Step 04 : Now Click on Export Blog. Once you click on Export Blog a popup will be open, Then just click on Download Blog.</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEihkirjiDXlXZmwikIRIwRUSWShRuHoxfoqQNEhX6Mfxc26MDa4ZC8qgjgBWu5XlrccRI2TzkZtqoCN-j5crZusCxorrTkAzWGAzRuClVPw8UyZv62cLRLAZont5Arj8tmufW9qklvgiw/s1600/Export-backup.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEihkirjiDXlXZmwikIRIwRUSWShRuHoxfoqQNEhX6Mfxc26MDa4ZC8qgjgBWu5XlrccRI2TzkZtqoCN-j5crZusCxorrTkAzWGAzRuClVPw8UyZv62cLRLAZont5Arj8tmufW9qklvgiw/s1600/Export-backup.png" /></a></div>
<div style="background-color: white; border: 0px; box-sizing: border-box; color: #4a4a4a; font-family: 'Pontano Sans', sans-serif; font-size: 16px; line-height: 22.399999618530273px; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline;">
<br /></div>
<div style="border: 0px; box-sizing: border-box; color: #4a4a4a; font-family: 'Pontano Sans', sans-serif; font-size: 16px; line-height: 22.399999618530273px; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline;">
<em style="background-color: white; border: 0px; box-sizing: border-box; color: #5f9025; font-family: inherit; font-weight: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">Now you have successfully backup your blog into your computer. Save backup file with a date and keep it in a safe folder.</em></div>
<h3 style="background-color: white; border: 0px; box-sizing: border-box; clear: both; color: #4a4a4a; font-family: 'Roboto Slab', sans-serif; font-size: 24px; font-weight: 500; line-height: 1.1; margin: 20px 0px 10px; outline: 0px; padding: 0px; vertical-align: baseline;">
<strong style="border: 0px; box-sizing: border-box; font-family: inherit; font-style: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">How to Restore a Backup to Blogger Blog</strong></h3>
<div style="background-color: white; border: 0px; box-sizing: border-box; color: #4a4a4a; font-family: 'Pontano Sans', sans-serif; font-size: 16px; line-height: 22.399999618530273px; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline;">
Step 01 : Log in to your blogger blog dashboard.</div>
<div style="background-color: white; border: 0px; box-sizing: border-box; color: #4a4a4a; font-family: 'Pontano Sans', sans-serif; font-size: 16px; line-height: 22.399999618530273px; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline;">
Step 02 : Go to settings tab.</div>
<div style="background-color: white; border: 0px; box-sizing: border-box; color: #4a4a4a; font-family: 'Pontano Sans', sans-serif; font-size: 16px; line-height: 22.399999618530273px; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline;">
Step 03 : Go to other tab under settings.</div>
<div style="background-color: white; border: 0px; box-sizing: border-box; color: #4a4a4a; font-family: 'Pontano Sans', sans-serif; font-size: 16px; line-height: 22.399999618530273px; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline;">
Step 04 : Click on Import Blog.</div>
<div style="background-color: white; border: 0px; box-sizing: border-box; color: #4a4a4a; font-family: 'Pontano Sans', sans-serif; font-size: 16px; line-height: 22.399999618530273px; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline;">
Step 05 : Once you click on import blog a popup fill be open. Chose the backup which you want to restore and fill the captcha then click on Import Blog Button.</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgC3cd57chRj3_sHlVMJCjvSao8Kunc8jIqU6iDnzAgruyftiIii2dmlWVBCE4grlxCOYO-dAUbJomv7e2BThvvBljWWP1ZcNYfob8pRIZXvOPR9L8Q_g45eCgXZG0mMGfKsWfVntze_g/s1600/restore-Blog.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgC3cd57chRj3_sHlVMJCjvSao8Kunc8jIqU6iDnzAgruyftiIii2dmlWVBCE4grlxCOYO-dAUbJomv7e2BThvvBljWWP1ZcNYfob8pRIZXvOPR9L8Q_g45eCgXZG0mMGfKsWfVntze_g/s1600/restore-Blog.png" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both;">
<span style="background-color: white; color: #5f9025; font-family: 'Pontano Sans', sans-serif; font-size: 16px; line-height: 22.399999618530273px;"><i>If you complete this steps correctly you should have restore your back up data to your blog.</i></span></div>
</div>

How To Backup and Restore Blogger Blog

Data is not permanent and there is chance to lose your data any time. So having backup is a must. As last year (2013) statistics they repo...

Best Android & iPhone App Builders To Create Your Own App

<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="background-color: white; color: #333333; font-family: Verdana, Geneva, sans-serif; font-size: 13px; line-height: 20.796875px;">Are you looking for free and </span><span style="background-color: white; box-sizing: border-box; font-family: Verdana, Geneva, sans-serif; font-size: 13px; line-height: 20.796875px;"><span style="box-sizing: border-box;"><span style="box-sizing: border-box;"><b><span style="color: #6aa84f;">best android & iPhone app building services</span></b></span></span></span><span style="background-color: white; color: #333333; font-family: Verdana, Geneva, sans-serif; font-size: 13px; line-height: 20.796875px;"> ? If you want to launch your own mobile app free of cost, these app builders can help you to make launch your own app without coding.</span><br />
<div style="background-color: white; box-sizing: border-box; color: #333333; font-family: Verdana, Geneva, sans-serif; font-size: 13px; line-height: 20.796875px;">
<br style="box-sizing: border-box;" /></div>
<div style="background-color: white; box-sizing: border-box; color: #333333; font-family: Verdana, Geneva, sans-serif; font-size: 13px; line-height: 20.796875px;">
Some of these app making services also allow users to monetize their apps for making money. If you also want to make money by promoting your own Android app or iPhone app, check out these useful services. Although all of these services cannot be used totally free but most of these sites offer free services for internet users.</div>
<div style="background-color: white; box-sizing: border-box; color: #333333; font-family: Verdana, Geneva, sans-serif; font-size: 13px; line-height: 20.796875px;">
<br style="box-sizing: border-box;" /></div>
<div style="background-color: white; box-sizing: border-box; color: #333333; font-family: Verdana, Geneva, sans-serif; font-size: 13px; line-height: 20.796875px;">
<b style="box-sizing: border-box;">1. <a href="http://www.appsgeyser.com/" rel="nofollow" style="-webkit-transition: all 0.4s ease-in-out; box-sizing: border-box; color: #2266bb; text-decoration: none; transition: all 0.4s ease-in-out;" target="_blank">AppGeyser</a> ( Android App Builder )</b> - AppGeyser is one of the best android app builders that helps you create your own android app without coding. The site also allows users to make money by promoting their app. AppGeyser monetizes your android app with high paying ads so that you can make money by promoting your app on the web. The method is very simple, just visit the site and create your own app and start promoting your android app to make money with ads.<br style="box-sizing: border-box;" /><br style="box-sizing: border-box;" />Very useful service that helps users make their own mobile app without any technical skill. You can also add many features to your app such as social sharing option, messaging, tabs and many other useful functions. AppGeyser also helps you to distribute your android app through AppGeyser android app marketplace. </div>
<div style="background-color: white; box-sizing: border-box; color: #333333; font-family: Verdana, Geneva, sans-serif; font-size: 13px; line-height: 20.796875px;">
<br style="box-sizing: border-box;" /></div>
<div style="background-color: white; box-sizing: border-box; color: #333333; font-family: Verdana, Geneva, sans-serif; font-size: 13px; line-height: 20.796875px;">
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEizUWuIg2s1-WfrUcQ8ucgob1zFVmJB7v3r6LDsuR15u9UX8BoDz0dGiEzakBqD0wDzEWTsZROrv-385vQ9Um7pBGAJ2DAXligbij_HOy73rd2PHDmiFnNhHD7w4BEqB8KW4_CFukpSIQ/s1600/Appsgeyser.jpeg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEizUWuIg2s1-WfrUcQ8ucgob1zFVmJB7v3r6LDsuR15u9UX8BoDz0dGiEzakBqD0wDzEWTsZROrv-385vQ9Um7pBGAJ2DAXligbij_HOy73rd2PHDmiFnNhHD7w4BEqB8KW4_CFukpSIQ/s1600/Appsgeyser.jpeg" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
</div>
<div style="background-color: white; box-sizing: border-box; color: #333333; font-family: Verdana, Geneva, sans-serif; font-size: 13px; line-height: 20.796875px;">
<br style="box-sizing: border-box;" /></div>
<div style="background-color: white; box-sizing: border-box; color: #333333; font-family: Verdana, Geneva, sans-serif; font-size: 13px; line-height: 20.796875px;">
<b style="box-sizing: border-box;">2. <a href="http://www.theappbuilder.com/" rel="nofollow" style="-webkit-transition: all 0.4s ease-in-out; box-sizing: border-box; color: #2266bb; text-decoration: none; transition: all 0.4s ease-in-out;" target="_blank">TheAppBuilder</a> ( iPhone, Android, Windows )</b> -  One of the most popular mobile app building services on the web that allows you create free web based mobile apps.You can also create native apps by upgrading your membership. Very useful site that offers easy app creation tools which can help you build your own iPhone or Android app for professional or personal purpose.<br style="box-sizing: border-box;" /><br style="box-sizing: border-box;" /> If you wish to make money by selling your own mobile app,you can upgrade your membership to create native Android or iPhone app. Free membership has many restrictions so it cannot be used for money making purpose. Theappbuilder offers many features including user friendly app toolkit, multiple mobile platforms and public distribution option.</div>
<div style="background-color: white; box-sizing: border-box; color: #333333; font-family: Verdana, Geneva, sans-serif; font-size: 13px; line-height: 20.796875px;">
<br style="box-sizing: border-box;" /></div>
<div style="background-color: white; box-sizing: border-box; color: #333333; font-family: Verdana, Geneva, sans-serif; font-size: 13px; line-height: 20.796875px;">
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEixFKalsrsGivqxXS68FwSZT5xNi3NRyZWylBZqNv2W0YXkftskeHTJmA2FSgIX2GfeLoATPcdYxOOjJgHZDYjzwBinEKslYwdgeUWMnV_A4qQPOrwJ00k2vNMlPqScmbgzYGIayfyCQQ/s1600/Theappbuilder.jpeg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEixFKalsrsGivqxXS68FwSZT5xNi3NRyZWylBZqNv2W0YXkftskeHTJmA2FSgIX2GfeLoATPcdYxOOjJgHZDYjzwBinEKslYwdgeUWMnV_A4qQPOrwJ00k2vNMlPqScmbgzYGIayfyCQQ/s1600/Theappbuilder.jpeg" /></a></div>
</div>
<div style="background-color: white; box-sizing: border-box; color: #333333; font-family: Verdana, Geneva, sans-serif; font-size: 13px; line-height: 20.796875px;">
<br style="box-sizing: border-box;" /></div>
<div style="background-color: white; box-sizing: border-box; color: #333333; font-family: Verdana, Geneva, sans-serif; font-size: 13px; line-height: 20.796875px;">
<b style="box-sizing: border-box;">3. <a href="http://www.infinitemonkeys.mobi/" rel="nofollow" style="-webkit-transition: all 0.4s ease-in-out; box-sizing: border-box; color: #2266bb; text-decoration: none; transition: all 0.4s ease-in-out;" target="_blank">Infinitemonkeys</a> ( iPhone & Android )</b> - Fully functional app builder that helps you make awesome android and iPhone apps without few minutes. The site also helps you to publish your apps to   app stores free of cost, but if you want to make money from your app, you have to pay small fees. The site offers easy tools to create web and native apps for android and iPhone devices. </div>
<div style="background-color: white; box-sizing: border-box; color: #333333; font-family: Verdana, Geneva, sans-serif; font-size: 13px; line-height: 20.796875px;">
<br style="box-sizing: border-box;" /></div>
<div style="background-color: white; box-sizing: border-box; color: #333333; font-family: Verdana, Geneva, sans-serif; font-size: 13px; line-height: 20.796875px;">
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhf8YUG9KFlnKTbtNwm5D7PE8gy-LHDGSw1RfEC9nc3l4LJtt76TRYgMdC6RZ-YCVRv5BMSoU-2ZKXCllcZRdH6EOq3yR4N_PSDxwAOPdE-YWpez4TWkm8DSleIZMFaFYNNF9j7ISJ6DA/s1600/Infinitemonkeys.jpeg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhf8YUG9KFlnKTbtNwm5D7PE8gy-LHDGSw1RfEC9nc3l4LJtt76TRYgMdC6RZ-YCVRv5BMSoU-2ZKXCllcZRdH6EOq3yR4N_PSDxwAOPdE-YWpez4TWkm8DSleIZMFaFYNNF9j7ISJ6DA/s1600/Infinitemonkeys.jpeg" /></a></div>
</div>
<div style="background-color: white; box-sizing: border-box; color: #333333; font-family: Verdana, Geneva, sans-serif; font-size: 13px; line-height: 20.796875px;">
<br style="box-sizing: border-box;" /></div>
<div style="background-color: white; box-sizing: border-box; color: #333333; font-family: Verdana, Geneva, sans-serif; font-size: 13px; line-height: 20.796875px;">
<b style="box-sizing: border-box;">4. <a href="http://gamesalad.com/" rel="nofollow" style="-webkit-transition: all 0.4s ease-in-out; box-sizing: border-box; color: #2266bb; text-decoration: none; transition: all 0.4s ease-in-out;" target="_blank">Gamesalad</a> ( iPhone, Android, Windows & Mac )</b> - Gamesalad is one of the best and popular online services that helps you make your own mobile or desktop games. Although you cannot access all of useful features free of cost. Although you can create fully functional addictive games for all platforms free of cost but if you wish to make money by selling your games, you have to pay money to Gamesalad. Very useful app builder for game developers.</div>
<div style="background-color: white; box-sizing: border-box; color: #333333; font-family: Verdana, Geneva, sans-serif; font-size: 13px; line-height: 20.796875px;">
<br style="box-sizing: border-box;" /></div>
<div style="background-color: white; box-sizing: border-box; color: #333333; font-family: Verdana, Geneva, sans-serif; font-size: 13px; line-height: 20.796875px;">
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjgMOrRnZBEEWn_NQSqac1yEgeFklfUVdC5LqeGvALx97o3UGOlRqqzAiwb3hfiFEyyHMwEpcihf76lujJw3ulT59l-3xqSsfjisesR_3BjQZMVTxa88AGQPbsoU-ZlcTPkAcGmnWP5Sg/s1600/GameSalad.jpeg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjgMOrRnZBEEWn_NQSqac1yEgeFklfUVdC5LqeGvALx97o3UGOlRqqzAiwb3hfiFEyyHMwEpcihf76lujJw3ulT59l-3xqSsfjisesR_3BjQZMVTxa88AGQPbsoU-ZlcTPkAcGmnWP5Sg/s1600/GameSalad.jpeg" /></a></div>
</div>
<div style="background-color: white; box-sizing: border-box; color: #333333; font-family: Verdana, Geneva, sans-serif; font-size: 13px; line-height: 20.796875px;">
<br style="box-sizing: border-box;" /></div>
<div style="background-color: white; box-sizing: border-box; color: #333333; font-family: Verdana, Geneva, sans-serif; font-size: 13px; line-height: 20.796875px;">
<b style="box-sizing: border-box;">5. <a href="http://www.buzztouch.com/" rel="nofollow" style="-webkit-transition: all 0.4s ease-in-out; box-sizing: border-box; color: #2266bb; text-decoration: none; transition: all 0.4s ease-in-out;" target="_blank">BuzzTouch</a> ( Android & iPhone )</b> - Full featured free iPhone & Android app maker that allows you to create easily mobile apps, download the app source code and launch them to Android or iOS app stores. BuzzTouch also offers many tools and plugins that can help you make your own app with ease.</div>
<div style="background-color: white; box-sizing: border-box; color: #333333; font-family: Verdana, Geneva, sans-serif; font-size: 13px; line-height: 20.796875px;">
<br style="box-sizing: border-box;" /></div>
<div style="background-color: white; box-sizing: border-box; color: #333333; font-family: Verdana, Geneva, sans-serif; font-size: 13px; line-height: 20.796875px;">
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjQK3vt6s1i4v4Bd-majEu-918P5k-8Sn2Xr-ytDUh86UafKws_lkfEY4kYIg3NWK6Be1zdPKdPT3xzo6PqrMteXXh-qpofpfgMY3XS0dARKEZ1UgbtQWQdRcrg-mepZWPWwKzwumvroQ/s1600/BuzzTouch.jpeg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjQK3vt6s1i4v4Bd-majEu-918P5k-8Sn2Xr-ytDUh86UafKws_lkfEY4kYIg3NWK6Be1zdPKdPT3xzo6PqrMteXXh-qpofpfgMY3XS0dARKEZ1UgbtQWQdRcrg-mepZWPWwKzwumvroQ/s1600/BuzzTouch.jpeg" /></a></div>
</div>
<div style="background-color: white; box-sizing: border-box; color: #333333; font-family: Verdana, Geneva, sans-serif; font-size: 13px; line-height: 20.796875px;">
<br style="box-sizing: border-box;" /></div>
<div style="background-color: white; box-sizing: border-box; color: #333333; font-family: Verdana, Geneva, sans-serif; font-size: 13px; line-height: 20.796875px;">
<b style="box-sizing: border-box;">6. <a href="http://www.appsbar.com/" rel="nofollow" style="-webkit-transition: all 0.4s ease-in-out; box-sizing: border-box; color: #2266bb; text-decoration: none; transition: all 0.4s ease-in-out;" target="_blank">Appsbar</a> ( Android , iPhone & Facebook )</b> - Very easy to use app builder that allows you to create android, iPhone, Facebook and web apps. You can use this useful service free of cost. Very useful service to create beautiful , featured rich and user friendly mobile and social apps.</div>
<div style="background-color: white; box-sizing: border-box; color: #333333; font-family: Verdana, Geneva, sans-serif; font-size: 13px; line-height: 20.796875px;">
<br style="box-sizing: border-box;" /><div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgV0LGZ3Zut1RRrOXkikuWiBB8aoSyQLDtIVxLhXJOmVZ-p-TuZrMIT-WRrd_3XI1af9ss6AnFLJRXsDSTFNsZABgkQGB4DfxTBThSN79gSRsMaLsJ0fTMnuXqzXMY4-YOUqHYtkQbxHg/s1600/Appsbar.jpeg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgV0LGZ3Zut1RRrOXkikuWiBB8aoSyQLDtIVxLhXJOmVZ-p-TuZrMIT-WRrd_3XI1af9ss6AnFLJRXsDSTFNsZABgkQGB4DfxTBThSN79gSRsMaLsJ0fTMnuXqzXMY4-YOUqHYtkQbxHg/s1600/Appsbar.jpeg" /></a></div>
</div>
<div style="background-color: white; box-sizing: border-box; color: #333333; font-family: Verdana, Geneva, sans-serif; font-size: 13px; line-height: 20.796875px;">
<br style="box-sizing: border-box;" /></div>
<div style="background-color: white; box-sizing: border-box; color: #333333; font-family: Verdana, Geneva, sans-serif; font-size: 13px; line-height: 20.796875px;">
<b style="box-sizing: border-box;">7. <a href="http://www.appypie.com/" rel="nofollow" style="-webkit-transition: all 0.4s ease-in-out; box-sizing: border-box; color: #2266bb; text-decoration: none; transition: all 0.4s ease-in-out;" target="_blank">Appypie</a> ( iPhone, Android, Blackberry & Windows )</b> - Appypie is one of the fastest growing DIY mobile app builder that lets you create featured rich app for almost all popular platforms such as Android , iPhone, iPad, Windows & Blackberry. The site offers easy drag and drop tools app creation tools that can also be used by non technical internet users. </div>
<div style="background-color: white; box-sizing: border-box; color: #333333; font-family: Verdana, Geneva, sans-serif; font-size: 13px; line-height: 20.796875px;">
<br style="box-sizing: border-box;" /></div>
<div style="background-color: white; box-sizing: border-box; color: #333333; font-family: Verdana, Geneva, sans-serif; font-size: 13px; line-height: 20.796875px;">
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgNFRs0BHDTAdkpqv7aowkIAp-PA65SPJoDJ8ltJjjAn_qtLdLJoORasvw-UqKl7I0b4KFFn8dlHvrJB6d3Az77AslLSdfcRl3NrsUTGXI-FVgPDjzZF-Wmcru3_9SFJVZsmXbMPFdytw/s1600/Appypie.jpeg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgNFRs0BHDTAdkpqv7aowkIAp-PA65SPJoDJ8ltJjjAn_qtLdLJoORasvw-UqKl7I0b4KFFn8dlHvrJB6d3Az77AslLSdfcRl3NrsUTGXI-FVgPDjzZF-Wmcru3_9SFJVZsmXbMPFdytw/s1600/Appypie.jpeg" /></a></div>
<br style="box-sizing: border-box;" /></div>
<div style="background-color: white; box-sizing: border-box; color: #333333; font-family: Verdana, Geneva, sans-serif; font-size: 13px; line-height: 20.796875px;">
<b style="box-sizing: border-box;">8. <a href="http://www.andromo.com/" rel="nofollow" style="-webkit-transition: all 0.4s ease-in-out; box-sizing: border-box; color: #2266bb; text-decoration: none; transition: all 0.4s ease-in-out;" target="_blank">Andromo</a> ( Android )</b> - Andromo is one of the best places to build fully functional native Android apps free of cost. The service helps you make your android app without coding and you can also publish your app on Android app store to make money with your app. Although you cannot access full features with the free plan but free plan also helps you create free app. For more pricing details, you can view their pricing page.</div>
<div style="background-color: white; box-sizing: border-box; color: #333333; font-family: Verdana, Geneva, sans-serif; font-size: 13px; line-height: 20.796875px;">
<br style="box-sizing: border-box;" /><div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgKdA5UNWMQJEMYKEUy2BRHPfkFZhMvlVL66Fsv3tMSQQC_ixekAyrXNlVXPsQTzV1lDlQmSqriP_qFy-ZG8vSXVj-9XhZm6DGsFQjB8QOQpZ7MFvOSF2HesxbfO_L7plSWSfmxgT-t_w/s1600/Andromo.jpeg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgKdA5UNWMQJEMYKEUy2BRHPfkFZhMvlVL66Fsv3tMSQQC_ixekAyrXNlVXPsQTzV1lDlQmSqriP_qFy-ZG8vSXVj-9XhZm6DGsFQjB8QOQpZ7MFvOSF2HesxbfO_L7plSWSfmxgT-t_w/s1600/Andromo.jpeg" /></a></div>
</div>
<div style="background-color: white; box-sizing: border-box; color: #333333; font-family: Verdana, Geneva, sans-serif; font-size: 13px; line-height: 20.796875px;">
<br style="box-sizing: border-box;" /></div>
<div style="background-color: white; box-sizing: border-box; color: #333333; font-family: Verdana, Geneva, sans-serif; font-size: 13px; line-height: 20.796875px;">
<b style="box-sizing: border-box;">9. <a href="http://www.appmakr.com/" rel="nofollow" style="-webkit-transition: all 0.4s ease-in-out; box-sizing: border-box; color: #2266bb; text-decoration: none; transition: all 0.4s ease-in-out;" target="_blank">AppMakr</a> ( iPhone, Android )</b> - Great free mobile app maker that helps you build your own Android or iPhone app without coding. You can create easily your mobile apps using this service.The service also allows you to make money by monetizing your own apps. </div>
<div style="background-color: white; box-sizing: border-box; color: #333333; font-family: Verdana, Geneva, sans-serif; font-size: 13px; line-height: 20.796875px;">
<br style="box-sizing: border-box;" /><div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi-tg5x3xEAYesULTlrL4Pk4Q5C1A7FRS3Ocly-2iciTB3wqM_P9jOBkECM6IvcYh95S77BD4hyJHs770NVxbAPPiqis4pJJCu_b2E6YskQ5u1qd3IITWxfbEOtruAZWS7P4Qbi-sjoag/s1600/AppMakr.jpeg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="123" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi-tg5x3xEAYesULTlrL4Pk4Q5C1A7FRS3Ocly-2iciTB3wqM_P9jOBkECM6IvcYh95S77BD4hyJHs770NVxbAPPiqis4pJJCu_b2E6YskQ5u1qd3IITWxfbEOtruAZWS7P4Qbi-sjoag/s1600/AppMakr.jpeg" width="400" /></a></div>
</div>
<div style="background-color: white; box-sizing: border-box; color: #333333; font-family: Verdana, Geneva, sans-serif; font-size: 13px; line-height: 20.796875px;">
<br style="box-sizing: border-box;" /></div>
<div style="background-color: white; box-sizing: border-box; color: #333333; font-family: Verdana, Geneva, sans-serif; font-size: 13px; line-height: 20.796875px;">
<b style="box-sizing: border-box;">10. <a href="http://ibuildapp.com/" rel="nofollow" style="-webkit-transition: all 0.4s ease-in-out; box-sizing: border-box; color: #2266bb; text-decoration: none; transition: all 0.4s ease-in-out;" target="_blank">iBuildApp</a> ( iPhone , Android )</b> - Popular free web service that allows internet users to create Android and iOS apps free of cost without coding. Very useful service for non technical internet users who want to make their own mobile apps. The site offers easy app creation tool with many features such as tools, social features, analytics, notifications, ad revenue option and lots of other features.</div>
<div style="background-color: white; box-sizing: border-box; color: #333333; font-family: Verdana, Geneva, sans-serif; font-size: 13px; line-height: 20.796875px;">
<br style="box-sizing: border-box;" /></div>
<div style="background-color: white; box-sizing: border-box; color: #333333; font-family: Verdana, Geneva, sans-serif; font-size: 13px; line-height: 20.796875px;">
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhg3FNhU1oY_4Oi3EeC_GoARDciyOUJICHbmugEZAU54prX0tyVbwwctRh4lKI-lg3HUne4-hGx_kl5z_9xOfbxhLAzwqjST7A9-zPghgwQUk4f3gwvJSdYEmBnzckB1i1c-1QMOPpzJQ/s1600/ibuildapp.jpeg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhg3FNhU1oY_4Oi3EeC_GoARDciyOUJICHbmugEZAU54prX0tyVbwwctRh4lKI-lg3HUne4-hGx_kl5z_9xOfbxhLAzwqjST7A9-zPghgwQUk4f3gwvJSdYEmBnzckB1i1c-1QMOPpzJQ/s1600/ibuildapp.jpeg" /></a></div>
<div class="separator" style="box-sizing: border-box; clear: both; text-align: center;">
<br /></div>
<div class="separator" style="box-sizing: border-box; clear: both; text-align: left;">
<span style="background-color: transparent; box-sizing: border-box; color: #555555; font-family: Verdana, sans-serif; font-size: 15px; line-height: 20px;">Hope this article useful for you. </span><span style="background-color: transparent; box-sizing: border-box; color: #555555; font-family: Verdana, sans-serif; font-size: 15px; line-height: 20px;">Are you favorite Website not in the list? Feel free to mention it in comments below.</span></div>
</div>
</div>

Best Android & iPhone App Builders To Create Your Own App

Are you looking for free and best android & iPhone app building services ? If you want to launch your own mobile app free of cost, th...

Redirect 404 Error Page to Homepage in Blogger

<div dir="ltr" style="text-align: left;" trbidi="on">
<div class=" PIN_1373116230291_hazClick" style="background-color: white; font-family: Arial, sans-serif; font-size: 14px; line-height: 22.875px; text-align: justify;">
<b>404 error page (Page Not Found)</b> is part of every website and blog. According to Wikipedia, "The 404 or Not Found error message is a HTTP standard response code indicating that the client was able to communicate with the server, but the server could not find what was requested."<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjk0wQCmTiTyUxSFSGNRfO3PkZf4pOYQxhh6nFU7Q9VSjECwTeb07RcDsVpel4NZJ2BS4zuZGlAnbm1Xbzo7f7hH-E2xv9Ep6UJYePTMWcnkZjOpT1dH2Trg6l9ujyFc6zSl0vwAyArEao/s1600/URL-transfar.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjk0wQCmTiTyUxSFSGNRfO3PkZf4pOYQxhh6nFU7Q9VSjECwTeb07RcDsVpel4NZJ2BS4zuZGlAnbm1Xbzo7f7hH-E2xv9Ep6UJYePTMWcnkZjOpT1dH2Trg6l9ujyFc6zSl0vwAyArEao/s1600/URL-transfar.jpg" /></a></div>
</div>
<br style="background-color: white; font-family: Arial, sans-serif; font-size: 14px; line-height: 22.875px; text-align: justify;" />
<span style="background-color: white; font-family: Arial, sans-serif; font-size: 14px; line-height: 22.875px; text-align: justify;">A non existing page on a website/blog will result to a 404 error page and this might give first timer a wrong impression about your blog. So the best solution to this type of situation is to redirect your blog 404 error page to your blog home page or a certain page on your blog. This can be done by adding a simple piece of JavaScript code to your blog. Follow the procedure outlined below to redirect your blogger error 404 page to homepage.</span><br />
<br style="background-color: white; font-family: Arial, sans-serif; font-size: 14px; line-height: 22.875px; text-align: justify;" />
<span style="background-color: white; font-family: Arial, sans-serif; font-size: 14px; line-height: 22.875px; text-align: justify;">==> Log in to your Blogger Dashboard, then go to </span><b style="background-color: white; font-family: Arial, sans-serif; font-size: 14px; line-height: 22.875px; text-align: justify;">Settings </b><span style="background-color: white; font-family: Arial, sans-serif; font-size: 14px; line-height: 22.875px; text-align: justify;">>> </span><b style="background-color: white; font-family: Arial, sans-serif; font-size: 14px; line-height: 22.875px; text-align: justify;">Search Preferences </b><span style="background-color: white; font-family: Arial, sans-serif; font-size: 14px; line-height: 22.875px; text-align: justify;">>></span><b style="background-color: white; font-family: Arial, sans-serif; font-size: 14px; line-height: 22.875px; text-align: justify;">Custom Page Not Found</b><span style="background-color: white; font-family: Arial, sans-serif; font-size: 14px; line-height: 22.875px; text-align: justify;"> (</span><i style="background-color: white; font-family: Arial, sans-serif; font-size: 14px; line-height: 22.875px; text-align: justify;">Under Errors and redirections</i><span style="background-color: white; font-family: Arial, sans-serif; font-size: 14px; line-height: 22.875px; text-align: justify;">).</span><br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjxr2axy8TxqvoTDdU74S7U56LhyizG7oXVsmBBkyYy2XyXZlJakJpLb6eFd_7YsYawrixupF9B8db-n0NfyQAZsNV3wk7j4IqLvaHhB86owHQNBWKtIn8bUoIoGCpHYZuXKDc5N6mMZKM/s1600/URL-transfar-show.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjxr2axy8TxqvoTDdU74S7U56LhyizG7oXVsmBBkyYy2XyXZlJakJpLb6eFd_7YsYawrixupF9B8db-n0NfyQAZsNV3wk7j4IqLvaHhB86owHQNBWKtIn8bUoIoGCpHYZuXKDc5N6mMZKM/s1600/URL-transfar-show.jpg" width="550" /></a></div>
<div class="separator" style="background-color: white; clear: both; font-family: Arial, sans-serif; font-size: 14px; line-height: 22.875px; text-align: center;">
<br /></div>
<span style="background-color: white; font-family: Arial, sans-serif; font-size: 14px; line-height: 22.875px; text-align: justify;">==> Click on edit, paste the code below into the box and then </span><b style="background-color: white; font-family: Arial, sans-serif; font-size: 14px; line-height: 22.875px; text-align: justify;">Save changes</b><br />
<blockquote class="tr_bq" style="background-color: #666666; border-bottom-left-radius: 5px; border-bottom-right-radius: 5px; border-top-left-radius: 5px; border-top-right-radius: 5px; border: 1px dotted rgb(0, 0, 51); color: white; font-family: Arial, sans-serif; font-size: 14px; font-weight: bold; line-height: 22.875px; margin: 1em 20px; padding: 10px; text-align: justify;">
Sorry, the page you were looking for in this blog does not exist. You will be redirected to homepage shortly.<br />
<script type = "text/javascript"><br />
//Blogger 404 Redirect v1.0 by Olusegun(Justnaira.com)<br />
JN_redirect = setTimeout(function() {<br />
location.<i style="color: red;">pathname</i>= "<i style="color: lime;">/</i>"<br />
}, <span style="color: #ffd966;">5000</span>);<br />
</script></blockquote>
<br style="background-color: white; font-family: Arial, sans-serif; font-size: 14px; line-height: 22.875px; text-align: justify;" />
<h4 style="background-color: white; border-bottom-color: rgb(6, 75, 140); border-bottom-style: dotted; border-bottom-width: 1px; border-top-color: rgb(6, 75, 140); border-top-style: dotted; border-top-width: 1px; font-family: Arial, sans-serif; font-size: 12pt; line-height: 22.875px; padding: 3px; text-align: justify;">
Customizing the Redirection Code</h4>
<ul style="background-color: white; font-family: Arial, sans-serif; font-size: 14px; line-height: 22.875px; list-style: none; text-align: justify;">
<li style="background-attachment: scroll; background-color: transparent; background-image: url(https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjiKnd0Nd4txE_dyCesG7DaV1mrk0ZmXoKdrsAQgJ62W0SgB7q7p-DJJmp1O50GpFitQPhTPOYXpJ91YxmmAUKFapRkLP-KRMJ2Z49vlCyEjIOta8s5Ts7WzNsDVi3Wyl7NkqWRcWWQAtM/s400/251.gif); background-position: 0px 4px; background-repeat: no-repeat no-repeat; line-height: 1.4em; margin: 0.3em 0px; padding: 0px 0px 0.8em 20px;">• You can change the message on the top (i.e. Sorry, the page you were looking for in this blog does not exist. You will be redirected to homepage shortly) to anything you like</li>
<li style="background-attachment: scroll; background-color: transparent; background-image: url(https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjkRoII10XCGaE2rcBWwxgW0VrScck4qqhyphenhyphenrHcZv6QdDVdTUyPbmRrLPH63ygXQD5JV1-93r7vlwHyCYQNpollWFwLlxFiI1bS8CMSWYxyromSZd-lIDzMKXFsZQHxD8N8oylyZrL0rLMo/s400/255.gif); background-position: 0px 4px; background-repeat: no-repeat no-repeat; line-height: 1.4em; margin: 0.3em 0px; padding: 0px 0px 0.8em 20px;">• The <span style="color: #ffd966;">5000</span> in the code represents delay in milliseconds. You can change the <span style="color: #ffd966;">5000</span> to any value. Changing the value to zero simply means your 404 error page will be redirected to your homepage or any desired page without any delay.</li>
<li style="background-attachment: scroll; background-color: transparent; background-image: url(https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjiKnd0Nd4txE_dyCesG7DaV1mrk0ZmXoKdrsAQgJ62W0SgB7q7p-DJJmp1O50GpFitQPhTPOYXpJ91YxmmAUKFapRkLP-KRMJ2Z49vlCyEjIOta8s5Ts7WzNsDVi3Wyl7NkqWRcWWQAtM/s400/251.gif); background-position: 0px 4px; background-repeat: no-repeat no-repeat; line-height: 1.4em; margin: 0.3em 0px; padding: 0px 0px 0.8em 20px;">• If you are willing to redirect your blog 404 error page to another page other than your home page, just replace <i style="color: red;">pathname </i>to <b style="color: red;">href</b> and <span style="color: lime;">/</span> to the <b style="color: lime;">url</b> of the page.</li>
</ul>
</div>

Redirect 404 Error Page to Homepage in Blogger

404 error page (Page Not Found) is part of every website and blog. According to Wikipedia, "The 404 or Not Found error message is a ...

Java Database Connectivity – MySQL, Oracle and SQLite

<div dir="ltr" style="text-align: left;" trbidi="on">
<div style="background-color: white; border: 0px; color: #444444; font-family: 'Open Sans', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 24px; margin-bottom: 1.714285714rem; padding: 0px; vertical-align: baseline;">
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiQdqG_6rcBc0hvK-NlGc9Y8PS88L1jV6hw9BleEx7eV-0ph875P5QS8D65bHNraU1uPnUlMBp3Mwz0wzrwDDdmTsc-7vzBMaqMG7XIGRwcW1krLHDHmXh5wF2eiYdH1tttwUKtZslEH_s/s1600/java.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiQdqG_6rcBc0hvK-NlGc9Y8PS88L1jV6hw9BleEx7eV-0ph875P5QS8D65bHNraU1uPnUlMBp3Mwz0wzrwDDdmTsc-7vzBMaqMG7XIGRwcW1krLHDHmXh5wF2eiYdH1tttwUKtZslEH_s/s1600/java.jpg" width="319" /></a></div>
I have played around with database connectivity with Java for MySQL, Oracle and SQLite. I thought I would share some simple connection setup code with the world.</div>
<div style="background-color: white; border: 0px; color: #444444; font-family: 'Open Sans', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 24px; margin-bottom: 1.714285714rem; padding: 0px; vertical-align: baseline;">
You will need to download and add the appropriate JARs to your project and or your class path, as well as having a database to connect to, unless you are using SQLite in which case the database is local.</div>
<h3 style="background-color: white; border: 0px; clear: both; color: #444444; font-family: 'Open Sans', Helvetica, Arial, sans-serif; font-size: 1.142857143rem; line-height: 1.846153846; margin: 1.714285714rem 0px; padding: 0px; text-align: center; vertical-align: baseline;">
MySQL</h3>
<div style="background-color: white; border: 0px; color: #444444; font-family: 'Open Sans', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 24px; margin-bottom: 1.714285714rem; padding: 0px; vertical-align: baseline;">
First up is MySQL connectivity. This first snippet will check you have loaded the JDBC driver correctly.</div>
<pre class="wp-code-highlight prettyprint prettyprinted" style="background-color: white; border: 1px solid rgb(204, 204, 204); color: #666666; font-family: Consolas, Monaco, 'Lucida Console', monospace; font-size: 12px; line-height: 16px; margin-bottom: 6px; margin-top: 6px; overflow: auto; padding: 2px 7px; vertical-align: baseline; width: 591.421875px; word-wrap: normal;"><span class="kwd" style="border: 0px; color: #000088; margin: 0px; padding: 0px; vertical-align: baseline;">import</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;"> java</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">.</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">sql</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">.*;</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="kwd" style="border: 0px; color: #000088; margin: 0px; padding: 0px; vertical-align: baseline;">public</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="kwd" style="border: 0px; color: #000088; margin: 0px; padding: 0px; vertical-align: baseline;">class</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="typ" style="border: 0px; color: #660066; margin: 0px; padding: 0px; vertical-align: baseline;">MySqlLoadDriver</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">{</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">
  </span><span class="kwd" style="border: 0px; color: #000088; margin: 0px; padding: 0px; vertical-align: baseline;">public</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="kwd" style="border: 0px; color: #000088; margin: 0px; padding: 0px; vertical-align: baseline;">static</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="kwd" style="border: 0px; color: #000088; margin: 0px; padding: 0px; vertical-align: baseline;">void</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;"> main</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">(</span><span class="typ" style="border: 0px; color: #660066; margin: 0px; padding: 0px; vertical-align: baseline;">String</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">[]</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;"> args</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">)</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">{</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">
    </span><span class="typ" style="border: 0px; color: #660066; margin: 0px; padding: 0px; vertical-align: baseline;">Connection</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;"> con </span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">=</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="kwd" style="border: 0px; color: #000088; margin: 0px; padding: 0px; vertical-align: baseline;">null</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">;</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">
    </span><span class="kwd" style="border: 0px; color: #000088; margin: 0px; padding: 0px; vertical-align: baseline;">try</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">{</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">

</span><span class="com" style="border: 0px; color: #880000; margin: 0px; padding: 0px; vertical-align: baseline;">// Load the MySQL JDBC driver</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">
      </span><span class="typ" style="border: 0px; color: #660066; margin: 0px; padding: 0px; vertical-align: baseline;">Class</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">.</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">forName</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">(</span><span class="str" style="border: 0px; color: #008800; margin: 0px; padding: 0px; vertical-align: baseline;">"com.mysql.jdbc.Driver"</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">)</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">;</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">
      </span><span class="typ" style="border: 0px; color: #660066; margin: 0px; padding: 0px; vertical-align: baseline;">System</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">.</span><span class="kwd" style="border: 0px; color: #000088; margin: 0px; padding: 0px; vertical-align: baseline;">out</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">.</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">println</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">(</span><span class="str" style="border: 0px; color: #008800; margin: 0px; padding: 0px; vertical-align: baseline;">"MySQL JDBC driver loaded ok."</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">);</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">

</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">}</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="kwd" style="border: 0px; color: #000088; margin: 0px; padding: 0px; vertical-align: baseline;">catch</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">(</span><span class="typ" style="border: 0px; color: #660066; margin: 0px; padding: 0px; vertical-align: baseline;">Exception</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;"> e</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">)</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">{</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">
      </span><span class="typ" style="border: 0px; color: #660066; margin: 0px; padding: 0px; vertical-align: baseline;">System</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">.</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">err</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">.</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">println</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">(</span><span class="str" style="border: 0px; color: #008800; margin: 0px; padding: 0px; vertical-align: baseline;">"Exception: "</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">+</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">e</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">.</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">getMessage</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">());</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">
    </span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">}</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">
  </span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">}</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">}</span></pre>
<div style="background-color: white; border: 0px; color: #444444; font-family: 'Open Sans', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 24px; margin-bottom: 1.714285714rem; padding: 0px; vertical-align: baseline;">
The following snippet will set up a connection to the database. Where the host in the example is set to localhost so you may change this to point to your database address or tunnel in to your database using a client like Putty. Also change username and password to your database username and password.</div>
<pre class="wp-code-highlight prettyprint prettyprinted" style="background-color: white; border: 1px solid rgb(204, 204, 204); color: #666666; font-family: Consolas, Monaco, 'Lucida Console', monospace; font-size: 12px; line-height: 16px; margin-bottom: 6px; margin-top: 6px; overflow: auto; padding: 2px 7px; vertical-align: baseline; width: 591.421875px; word-wrap: normal;"><span class="kwd" style="border: 0px; color: #000088; margin: 0px; padding: 0px; vertical-align: baseline;">import</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;"> java</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">.</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">sql</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">.</span><span class="typ" style="border: 0px; color: #660066; margin: 0px; padding: 0px; vertical-align: baseline;">Connection</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">;</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="kwd" style="border: 0px; color: #000088; margin: 0px; padding: 0px; vertical-align: baseline;">import</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;"> java</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">.</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">sql</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">.</span><span class="typ" style="border: 0px; color: #660066; margin: 0px; padding: 0px; vertical-align: baseline;">DriverManager</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">;</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="kwd" style="border: 0px; color: #000088; margin: 0px; padding: 0px; vertical-align: baseline;">import</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;"> java</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">.</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">sql</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">.</span><span class="typ" style="border: 0px; color: #660066; margin: 0px; padding: 0px; vertical-align: baseline;">SQLException</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">;</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="kwd" style="border: 0px; color: #000088; margin: 0px; padding: 0px; vertical-align: baseline;">public</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="kwd" style="border: 0px; color: #000088; margin: 0px; padding: 0px; vertical-align: baseline;">class</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="typ" style="border: 0px; color: #660066; margin: 0px; padding: 0px; vertical-align: baseline;">SimpleConnection</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">;</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">{</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">

</span><span class="kwd" style="border: 0px; color: #000088; margin: 0px; padding: 0px; vertical-align: baseline;">static</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="kwd" style="border: 0px; color: #000088; margin: 0px; padding: 0px; vertical-align: baseline;">public</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="kwd" style="border: 0px; color: #000088; margin: 0px; padding: 0px; vertical-align: baseline;">void</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;"> main</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">(</span><span class="typ" style="border: 0px; color: #660066; margin: 0px; padding: 0px; vertical-align: baseline;">String</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;"> args</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">[])</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">
     </span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">{</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">

</span><span class="typ" style="border: 0px; color: #660066; margin: 0px; padding: 0px; vertical-align: baseline;">Class</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">.</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">forName</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">(</span><span class="str" style="border: 0px; color: #008800; margin: 0px; padding: 0px; vertical-align: baseline;">"com.mysql.jdbc.Driver"</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">)</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">;</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">
         </span><span class="typ" style="border: 0px; color: #660066; margin: 0px; padding: 0px; vertical-align: baseline;">System</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">.</span><span class="kwd" style="border: 0px; color: #000088; margin: 0px; padding: 0px; vertical-align: baseline;">out</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">.</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">println</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">(</span><span class="str" style="border: 0px; color: #008800; margin: 0px; padding: 0px; vertical-align: baseline;">"MySQL JDBC driver loaded ok."</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">);</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">
         con </span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">=</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="typ" style="border: 0px; color: #660066; margin: 0px; padding: 0px; vertical-align: baseline;">DriverManager</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">.</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">getConnection</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">(</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">
         </span><span class="str" style="border: 0px; color: #008800; margin: 0px; padding: 0px; vertical-align: baseline;">"jdbc:mysql://127.0.0.1:3306/"</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">,</span><span class="str" style="border: 0px; color: #008800; margin: 0px; padding: 0px; vertical-align: baseline;">"username"</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">,</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="str" style="border: 0px; color: #008800; margin: 0px; padding: 0px; vertical-align: baseline;">"password"</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">);</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">
         </span><span class="typ" style="border: 0px; color: #660066; margin: 0px; padding: 0px; vertical-align: baseline;">System</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">.</span><span class="kwd" style="border: 0px; color: #000088; margin: 0px; padding: 0px; vertical-align: baseline;">out</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">.</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">println</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">(</span><span class="str" style="border: 0px; color: #008800; margin: 0px; padding: 0px; vertical-align: baseline;">"Connected with host:port/database."</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">);</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">
         con</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">.</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">close</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">();</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">

</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">}</span></pre>
<div style="background-color: white; border: 0px; color: #444444; font-family: 'Open Sans', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 24px; margin-bottom: 1.714285714rem; padding: 0px; vertical-align: baseline;">
<br /></div>
<h3 style="background-color: white; border: 0px; clear: both; color: #444444; font-family: 'Open Sans', Helvetica, Arial, sans-serif; font-size: 1.142857143rem; line-height: 1.846153846; margin: 1.714285714rem 0px; padding: 0px; text-align: center; vertical-align: baseline;">
Oracle</h3>
<div style="background-color: white; border: 0px; color: #444444; font-family: 'Open Sans', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 24px; margin-bottom: 1.714285714rem; padding: 0px; vertical-align: baseline;">
Oracle has a two types of connection I have played with Oracle Call Interface and Oracle’s JDBC Thin driver uses Java sockets to connect directly to Oracle. It provides its own TCP/IP version of Oracle’s SQL*Net protocol. Because it is 100% Java, this driver is platform independent and can also run from a Web Browser. Depending on which one you want to use comment out or delete the other line. In the example I am using the OJDBC Thin Driver not the Oracle Call Interface.</div>
<pre class="wp-code-highlight prettyprint prettyprinted" style="background-color: white; border: 1px solid rgb(204, 204, 204); color: #666666; font-family: Consolas, Monaco, 'Lucida Console', monospace; font-size: 12px; line-height: 16px; margin-bottom: 6px; margin-top: 6px; overflow: auto; padding: 2px 7px; vertical-align: baseline; width: 591.421875px; word-wrap: normal;"><span class="kwd" style="border: 0px; color: #000088; margin: 0px; padding: 0px; vertical-align: baseline;">import</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;"> java</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">.</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">sql</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">.</span><span class="typ" style="border: 0px; color: #660066; margin: 0px; padding: 0px; vertical-align: baseline;">Connection</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">;</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="kwd" style="border: 0px; color: #000088; margin: 0px; padding: 0px; vertical-align: baseline;">import</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;"> java</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">.</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">sql</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">.</span><span class="typ" style="border: 0px; color: #660066; margin: 0px; padding: 0px; vertical-align: baseline;">DriverManager</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">;</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="kwd" style="border: 0px; color: #000088; margin: 0px; padding: 0px; vertical-align: baseline;">import</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;"> java</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">.</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">sql</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">.</span><span class="typ" style="border: 0px; color: #660066; margin: 0px; padding: 0px; vertical-align: baseline;">SQLException</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">;</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">

</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">{</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">
         </span><span class="typ" style="border: 0px; color: #660066; margin: 0px; padding: 0px; vertical-align: baseline;">Connection</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;"> con </span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">=</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="kwd" style="border: 0px; color: #000088; margin: 0px; padding: 0px; vertical-align: baseline;">null</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">;</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">

</span><span class="kwd" style="border: 0px; color: #000088; margin: 0px; padding: 0px; vertical-align: baseline;">try</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">
         </span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">{</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">
               </span><span class="typ" style="border: 0px; color: #660066; margin: 0px; padding: 0px; vertical-align: baseline;">Class</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">.</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">forName </span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">(</span><span class="str" style="border: 0px; color: #008800; margin: 0px; padding: 0px; vertical-align: baseline;">"oracle.jdbc.OracleDriver"</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">);</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">
               </span><span class="typ" style="border: 0px; color: #660066; margin: 0px; padding: 0px; vertical-align: baseline;">System</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">.</span><span class="kwd" style="border: 0px; color: #000088; margin: 0px; padding: 0px; vertical-align: baseline;">out</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">.</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">println</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">(</span><span class="str" style="border: 0px; color: #008800; margin: 0px; padding: 0px; vertical-align: baseline;">"Oracle JDBC driver loaded ok."</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">);</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">
               con </span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">=</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="typ" style="border: 0px; color: #660066; margin: 0px; padding: 0px; vertical-align: baseline;">DriverManager</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">.</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">getConnection</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">(</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">

</span><span class="com" style="border: 0px; color: #880000; margin: 0px; padding: 0px; vertical-align: baseline;">//"jdbc:oracle:oci7:@//localhost:1521/ORCL","username", "password");</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">
                   </span><span class="str" style="border: 0px; color: #008800; margin: 0px; padding: 0px; vertical-align: baseline;">"jdbc:oracle:thin:@//192.168.104.11:1521/ORCL"</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">,</span><span class="str" style="border: 0px; color: #008800; margin: 0px; padding: 0px; vertical-align: baseline;">"username"</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">,</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="str" style="border: 0px; color: #008800; margin: 0px; padding: 0px; vertical-align: baseline;">"password"</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">);</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">
               </span><span class="typ" style="border: 0px; color: #660066; margin: 0px; padding: 0px; vertical-align: baseline;">System</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">.</span><span class="kwd" style="border: 0px; color: #000088; margin: 0px; padding: 0px; vertical-align: baseline;">out</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">.</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">println</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">(</span><span class="str" style="border: 0px; color: #008800; margin: 0px; padding: 0px; vertical-align: baseline;">"Success!!"</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">);</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">
               </span><span class="typ" style="border: 0px; color: #660066; margin: 0px; padding: 0px; vertical-align: baseline;">System</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">.</span><span class="kwd" style="border: 0px; color: #000088; margin: 0px; padding: 0px; vertical-align: baseline;">out</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">.</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">println</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">(</span><span class="str" style="border: 0px; color: #008800; margin: 0px; padding: 0px; vertical-align: baseline;">"Connected with host:port/database."</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">);</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">
               con</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">.</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">close</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">();</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">
          </span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">}</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">
          </span><span class="kwd" style="border: 0px; color: #000088; margin: 0px; padding: 0px; vertical-align: baseline;">catch</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">(</span><span class="typ" style="border: 0px; color: #660066; margin: 0px; padding: 0px; vertical-align: baseline;">Exception</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;"> e</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">)</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">
          </span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">{</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">
               </span><span class="typ" style="border: 0px; color: #660066; margin: 0px; padding: 0px; vertical-align: baseline;">System</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">.</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">err</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">.</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">println</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">(</span><span class="str" style="border: 0px; color: #008800; margin: 0px; padding: 0px; vertical-align: baseline;">"Exception: "</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">+</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">e</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">.</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">getMessage</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">());</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">
          </span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">}</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">
       </span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">}</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">}</span></pre>
<div style="background-color: white; border: 0px; color: #444444; font-family: 'Open Sans', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 24px; margin-bottom: 1.714285714rem; padding: 0px; vertical-align: baseline;">
<br /></div>
<h3 style="background-color: white; border: 0px; clear: both; color: #444444; font-family: 'Open Sans', Helvetica, Arial, sans-serif; font-size: 1.142857143rem; line-height: 1.846153846; margin: 1.714285714rem 0px; padding: 0px; text-align: center; vertical-align: baseline;">
SQLite</h3>
<div style="background-color: white; border: 0px; color: #444444; font-family: 'Open Sans', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 24px; margin-bottom: 1.714285714rem; padding: 0px; vertical-align: baseline;">
Finally the creation and testing of an SQLite Database, adding in a few things with a simple query.</div>
<pre class="wp-code-highlight prettyprint prettyprinted" style="background-color: white; border: 1px solid rgb(204, 204, 204); color: #666666; font-family: Consolas, Monaco, 'Lucida Console', monospace; font-size: 12px; line-height: 16px; margin-bottom: 6px; margin-top: 6px; overflow: auto; padding: 2px 7px; vertical-align: baseline; width: 591.421875px; word-wrap: normal;"><span class="kwd" style="border: 0px; color: #000088; margin: 0px; padding: 0px; vertical-align: baseline;">import</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;"> java</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">.</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">sql</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">.*;</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">

</span><span class="kwd" style="border: 0px; color: #000088; margin: 0px; padding: 0px; vertical-align: baseline;">public</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="kwd" style="border: 0px; color: #000088; margin: 0px; padding: 0px; vertical-align: baseline;">static</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="kwd" style="border: 0px; color: #000088; margin: 0px; padding: 0px; vertical-align: baseline;">void</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;"> main</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">(</span><span class="typ" style="border: 0px; color: #660066; margin: 0px; padding: 0px; vertical-align: baseline;">String</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">[]</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;"> args</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">)</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="kwd" style="border: 0px; color: #000088; margin: 0px; padding: 0px; vertical-align: baseline;">throws</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="typ" style="border: 0px; color: #660066; margin: 0px; padding: 0px; vertical-align: baseline;">Exception</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">{</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">

</span><span class="typ" style="border: 0px; color: #660066; margin: 0px; padding: 0px; vertical-align: baseline;">Connection</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;"> conn </span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">=</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="typ" style="border: 0px; color: #660066; margin: 0px; padding: 0px; vertical-align: baseline;">DriverManager</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">.</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">getConnection</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">(</span><span class="str" style="border: 0px; color: #008800; margin: 0px; padding: 0px; vertical-align: baseline;">"jdbc:sqlite:test.db"</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">);</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">
    </span><span class="typ" style="border: 0px; color: #660066; margin: 0px; padding: 0px; vertical-align: baseline;">Statement</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;"> stat </span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">=</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;"> conn</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">.</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">createStatement</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">();</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">
    stat</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">.</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">executeUpdate</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">(</span><span class="str" style="border: 0px; color: #008800; margin: 0px; padding: 0px; vertical-align: baseline;">"drop table if exists people;"</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">);</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">
    stat</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">.</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">executeUpdate</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">(</span><span class="str" style="border: 0px; color: #008800; margin: 0px; padding: 0px; vertical-align: baseline;">"create table people (name, occupation);"</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">);</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">
    </span><span class="typ" style="border: 0px; color: #660066; margin: 0px; padding: 0px; vertical-align: baseline;">PreparedStatement</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;"> prep </span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">=</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;"> conn</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">.</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">prepareStatement</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">(</span><span class="str" style="border: 0px; color: #008800; margin: 0px; padding: 0px; vertical-align: baseline;">"insert into people values (?, ?);"</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">);</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">
    prep</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">.</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">setString</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">(</span><span class="lit" style="border: 0px; color: #006666; margin: 0px; padding: 0px; vertical-align: baseline;">1</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">,</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="str" style="border: 0px; color: #008800; margin: 0px; padding: 0px; vertical-align: baseline;">"Gandhi"</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">);</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">
    prep</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">.</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">setString</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">(</span><span class="lit" style="border: 0px; color: #006666; margin: 0px; padding: 0px; vertical-align: baseline;">2</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">,</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="str" style="border: 0px; color: #008800; margin: 0px; padding: 0px; vertical-align: baseline;">"politics"</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">);</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">
    prep</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">.</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">addBatch</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">();</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">
    prep</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">.</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">setString</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">(</span><span class="lit" style="border: 0px; color: #006666; margin: 0px; padding: 0px; vertical-align: baseline;">1</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">,</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="str" style="border: 0px; color: #008800; margin: 0px; padding: 0px; vertical-align: baseline;">"Turing"</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">);</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">
    prep</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">.</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">setString</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">(</span><span class="lit" style="border: 0px; color: #006666; margin: 0px; padding: 0px; vertical-align: baseline;">2</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">,</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="str" style="border: 0px; color: #008800; margin: 0px; padding: 0px; vertical-align: baseline;">"computers"</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">);</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">
    prep</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">.</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">addBatch</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">();</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">
    prep</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">.</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">setString</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">(</span><span class="lit" style="border: 0px; color: #006666; margin: 0px; padding: 0px; vertical-align: baseline;">1</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">,</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="str" style="border: 0px; color: #008800; margin: 0px; padding: 0px; vertical-align: baseline;">"Wittgenstein"</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">);</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">
    prep</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">.</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">setString</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">(</span><span class="lit" style="border: 0px; color: #006666; margin: 0px; padding: 0px; vertical-align: baseline;">2</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">,</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="str" style="border: 0px; color: #008800; margin: 0px; padding: 0px; vertical-align: baseline;">"smartypants"</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">);</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">
    prep</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">.</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">addBatch</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">();</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">
    conn</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">.</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">setAutoCommit</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">(</span><span class="kwd" style="border: 0px; color: #000088; margin: 0px; padding: 0px; vertical-align: baseline;">false</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">);</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">
    prep</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">.</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">executeBatch</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">();</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">
    conn</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">.</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">setAutoCommit</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">(</span><span class="kwd" style="border: 0px; color: #000088; margin: 0px; padding: 0px; vertical-align: baseline;">true</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">);</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">
    </span><span class="typ" style="border: 0px; color: #660066; margin: 0px; padding: 0px; vertical-align: baseline;">ResultSet</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;"> rs </span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">=</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;"> stat</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">.</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">executeQuery</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">(</span><span class="str" style="border: 0px; color: #008800; margin: 0px; padding: 0px; vertical-align: baseline;">"select * from people;"</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">);</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">

</span><span class="kwd" style="border: 0px; color: #000088; margin: 0px; padding: 0px; vertical-align: baseline;">while</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">(</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">rs</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">.</span><span class="kwd" style="border: 0px; color: #000088; margin: 0px; padding: 0px; vertical-align: baseline;">next</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">())</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">{</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">
          </span><span class="typ" style="border: 0px; color: #660066; margin: 0px; padding: 0px; vertical-align: baseline;">System</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">.</span><span class="kwd" style="border: 0px; color: #000088; margin: 0px; padding: 0px; vertical-align: baseline;">out</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">.</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">println</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">(</span><span class="str" style="border: 0px; color: #008800; margin: 0px; padding: 0px; vertical-align: baseline;">"name = "</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">+</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;"> rs</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">.</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">getString</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">(</span><span class="str" style="border: 0px; color: #008800; margin: 0px; padding: 0px; vertical-align: baseline;">"name"</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">));</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">
          </span><span class="typ" style="border: 0px; color: #660066; margin: 0px; padding: 0px; vertical-align: baseline;">System</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">.</span><span class="kwd" style="border: 0px; color: #000088; margin: 0px; padding: 0px; vertical-align: baseline;">out</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">.</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">println</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">(</span><span class="str" style="border: 0px; color: #008800; margin: 0px; padding: 0px; vertical-align: baseline;">"job = "</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">+</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;"> rs</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">.</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">getString</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">(</span><span class="str" style="border: 0px; color: #008800; margin: 0px; padding: 0px; vertical-align: baseline;">"occupation"</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">));</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">
    </span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">}</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">

rs</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">.</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">close</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">();</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">
    conn</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">.</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">close</span><span class="pun" style="border: 0px; color: #666600; margin: 0px; padding: 0px; vertical-align: baseline;">();</span><span class="pln" style="border: 0px; color: black; margin: 0px; padding: 0px; vertical-align: baseline;">

Java Database Connectivity – MySQL, Oracle and SQLite

I have played around with database connectivity with Java for MySQL, Oracle and SQLite. I thought I would share some simple connection s...