Technical Blog of Android

reference : http://www.vogella.com/articles/AndroidSQLite/article.html Table of Contents 1. SQLite and Android 1.1. What is SQLite? 1.2. SQLite in Android 2. Prerequisites for this tutorial 3. SQLite Architecture 3.1. Packages 3.2. SQLiteOpenHelper 3.3. SQLiteDatabase 3.4. rawQuery() Example 3.5. query() Example 3.6. Cursor 3.7. ListViews, ListActivities and SimpleCursorAdapter 4. Tutorial: Using SQLite 4.1. Introduction to the project 4.2. Create Project 4.3. Database and Data Model 4.4. User Interface 4.5. Running the apps 5. ContentProvider and sharing data 5.1. ContentProvider Overview 5.2. Own ContentProvider 5.3. Security and ContentProvider 5.4. Thread Safety 6. Tutorial: Using ContentProvider 6.1. Overview 6.2. Create contacts on your emulator 6.3. Using the Contact Content Provider 7. Activities, Loader and ContentProvider 7.1. Activities and Databases 7.2. Loader 8. Tutorial: SQLite, own ContentProvider and Loader ...