Home Page Icon
Home Page
Table of Contents for
Table of Contents
Close
Table of Contents
by Jason Wei
Android Database Programming
Android Database Programming
Table of Contents
Android Database Programming
Credits
About the Author
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. Storing Data on Android
Using SharedPreferences
Common use cases for SharedPreferences
Checking if it's the user's first time visit to your application
Checking when the application last updated itself
Remembering what the user's login username was
Remembering an application's state
Caching a user's location
Internal storage methods
External storage methods
SQLite databases
Summary
2. Using a SQLite Database
Creating advanced SQLite schemas
Wrappers for your SQLite database
Debugging your SQLite database
Summary
3. SQLite Queries
Methods for building SQLite queries
SELECT statements
WHERE filters and SQL operators
DISTINCT and LIMIT clauses
ORDER BY and GROUP BY clauses
HAVING filters and Aggregate functions
SQL vs. Java performance comparisons
Summary
4. Using Content Providers
ContentProvider
Implementing the query method
Implementing the delete and update methods
Implementing the insert and getType methods
Interacting with a ContentProvider
Practical use cases
Summary
5. Querying the Contacts Table
Structure of the Contacts content provider
Querying for Contacts
Modifying Contacts
Setting permissions
Summary
6. Binding to the UI
SimpleCursorAdapters and ListViews
Custom CursorAdapters
BaseAdapters and Custom BaseAdapters
Handling list interactions
Comparing CursorAdapters and BaseAdapters
Summary
7. Android Databases in Practice
Local database use cases
Databases as caches
Typical application design
Summary
8. Exploring External Databases
Different external databases
Google App Engine and JDO databases
GAE: an example with video games
The PersistenceManager and Queries
Summary
9. Collecting and Storing Data
Methods for collecting data
A primer on web scraping
Extending HTTP servlets for GET/POST methods
Scheduling CRON jobs
Summary
10. Bringing it Together
Implementing HTTP GET requests
Back to Android: parsing responses
Final steps: binding to the UI (again)
Summary
Index
Search in book...
Toggle Font Controls
Playlists
Add To
Create new playlist
Name your new playlist
Playlist description (optional)
Cancel
Create playlist
Sign In
Email address
Password
Forgot Password?
Create account
Login
or
Continue with Facebook
Continue with Google
Sign Up
Full Name
Email address
Confirm Email Address
Password
Login
Create account
or
Continue with Facebook
Continue with Google
Prev
Previous Chapter
Cover
Next
Next Chapter
Android Database Programming
Table of Contents
Android Database Programming
Credits
About the Author
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. Storing Data on Android
Using SharedPreferences
Common use cases for SharedPreferences
Checking if it's the user's first time visit to your application
Checking when the application last updated itself
Remembering what the user's login username was
Remembering an application's state
Caching a user's location
Internal storage methods
External storage methods
SQLite databases
Summary
2. Using a SQLite Database
Creating advanced SQLite schemas
Wrappers for your SQLite database
Debugging your SQLite database
Summary
3. SQLite Queries
Methods for building SQLite queries
SELECT statements
WHERE filters and SQL operators
DISTINCT and LIMIT clauses
ORDER BY and GROUP BY clauses
HAVING filters and Aggregate functions
SQL vs. Java performance comparisons
Summary
4. Using Content Providers
ContentProvider
Implementing the query method
Implementing the delete and update methods
Implementing the insert and getType methods
Interacting with a ContentProvider
Practical use cases
Summary
5. Querying the Contacts Table
Structure of the Contacts content provider
Querying for Contacts
Modifying Contacts
Setting permissions
Summary
6. Binding to the UI
SimpleCursorAdapters and ListViews
Custom CursorAdapters
BaseAdapters and Custom BaseAdapters
Handling list interactions
Comparing CursorAdapters and BaseAdapters
Summary
7. Android Databases in Practice
Local database use cases
Databases as caches
Typical application design
Summary
8. Exploring External Databases
Different external databases
Google App Engine and JDO databases
GAE: an example with video games
The PersistenceManager and Queries
Summary
9. Collecting and Storing Data
Methods for collecting data
A primer on web scraping
Extending HTTP servlets for GET/POST methods
Scheduling CRON jobs
Summary
10. Bringing it Together
Implementing HTTP GET requests
Back to Android: parsing responses
Final steps: binding to the UI (again)
Summary
Index
Add Highlight
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click
here
login for view all page.
Day Mode
Cloud Mode
Night Mode
Reset