Join David Gassner for an in-depth discussion in this video Defining the SQLite database structure, part of Building a Note-Taking App for Android.
- View Offline
Over the course of the next few videos,…I'm going to build the data layer for my application.…Defining my SQL-like database and providing…access to the database to the rest of the app.…I'll start by creating the database itself…and defining its structure.…If you're following along,…you can either continue from the last demonstration…or you can open this project database…in the 04_DataLayer folder of the Exercise files.…I'll go to my java folder in the project window…and then right click on the default package…for the application.…
Make sure you're not selecting the version…of the package for AndroidTest.…I'll right click and choose New, Java Class,…and I'll name my new java class DBOpenHelper.…I'll get rid of these comments and then…I'll have this class extend a super class…named SQLiteOpenHelper.…This class is a member of the Android SDK…and you can use it to define your database…and manage connections to it.…
Next I'll implement some required overrides.…I'll use an intention action, or quick fix,…by pressing alt + enter on Windows or opt + return on MAC…
Building a Note-Taking App for iOS 8 and Building a Note-Taking App for Windows Phone 8 and Windows Store use the same assets to develop a similar app. Compare and contrast the steps and discover the similarities and differences between the three platforms.
- Understanding Android UI and data management patterns
- Creating an Android Studio project
- Customizing material design theme colors
- Defining an SQLite database structure
- Managing data with ContentProvider and Loader classes
- Retrieving and displaying data
- Customizing data display with a CursorAdapter
- Creating, updating, and deleting notes
- Preparing the app for deployment