Android SQLite Essentials - Sunny Kumar Aditya.pdf

(1449 KB) Pobierz
Android SQLite Essentials
Table of Contents
Android SQLite Essentials
Credits
About the Authors
About the Reviewers
www.PacktPub.com
Support files, eBooks, discount offers and more
Why Subscribe?
Free Access for Packt account holders
Preface
What this book covers
What you need for this book
Who this book is for
Conventions
Reader feedback
Customer support
Downloading the example code
Errata
Piracy
Questions
1. Enter SQLite
Why SQLite?
The SQLite architecture
The SQLite interface
The SQL compiler
The virtual machine
The SQLite backend
A quick review of database fundamentals
What is an SQLite statement?
The SQLite syntax
Datatypes in SQLite
Storage classes
The Boolean datatype
The Date and Time datatype
SQLite in Android
SQLite version
Database packages
APIs
The SQLiteOpenHelper class
The SQLiteDatabase class
ContentValues
Cursor
Summary
2. Connecting the Dots
Building blocks
A database handler and queries
Building the Create query
Building the Insert query
Building the Delete query
Building the Update query
Connecting the UI and database
Summary
3. Sharing is Caring
What is a content provider?
Using existing content providers
What is a content resolver?
Creating a content provider
Understanding content URIs
Declaring our contract class
Creating UriMatcher definitions
Implementing the core methods
Zgłoś jeśli naruszono regulamin