Book Image

Android 3.0 Application Development Cookbook

By : Kyle Merrifield Mew
Book Image

Android 3.0 Application Development Cookbook

By: Kyle Merrifield Mew

Overview of this book

<p>Android is a mobile operating system that runs on a staggering number of smartphones and tablets. Android offers developers the ability to build extremely rich and innovative applications written using the Java programming language. Among the number of books that have been published on the topic, what&rsquo;s missing is a thoroughly practical, hands-on book that takes you straight to getting your job done without boring you with too much theory.<br /><br />Android 3.0 Application Development Cookbook will take you straight to the information you need to get your applications up and running. This book is written to provide you with the shortest possible route between an idea and a working application. <br /><br />Work through the book from start to finish to become an Android expert, or use it as a reference book by applying recipes directly to your project.<br /><br />This book covers every aspect of mobile app development, starting with major application components and screen layout and design, before moving on to how to manage sensors such as internal gyroscopes and near field communications. Towards the end, it delves into smartphone multimedia capabilities as well as graphics and animation, web access, and GPS. <br /><br />Whether you are writing your first app or your hundredth, this is a book that you will come back to time and time again, with its many tips and tricks on the rich features of Android 3.</p>
Table of Contents (18 chapters)
Android 3.0 Application Development Cookbook
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Index

Creating a SQLite database


The methods outlined here provide some powerful techniques for storing and manipulating data, but providing a structured database this way would be a tiresome task. Fortunately Android incorporates SQLite (version 3 to be precise), a server-less, transactional database engine for this purpose. Instruction in SQL is beyond the scope of this book and it is assumed that the reader has some familiarity with self-contained databases, cursors, and queries.

In this recipe we will demonstrate how to set up a simple SQLiteDatabase, add a table and include some entries.

Getting ready

SQLite databases can be created and accessed through Java code, so to begin this task start up a new Android project with Eclipse and open the main Java activity file.

How to do it...

  1. Inside the onCreate() method declare and assign an SQLiteDatabase as follows:

    SQLiteDatabase db;
    db = openOrCreateDatabase("my_database.db", SQLiteDatabase.CREATE_IF_NECESSARY, null);
  2. Underneath this, define a table for...