filmov
tv
Android SQLite Database Tutorial 📱 Complete 1-HOUR SQLite Android Tutorial | Kotlin & Android Studio
Показать описание
In this video, you will learn everything about the Android SQLite Database with a great examples.
Using this Android SQLite database tutorial I will show you how to perform all the crud operations like Create, Insert, Update, and Delete.
In-depth Android SQLite Database Tutorial
SQLite database is an opensource, lightweight, no network access, and standalone SQL database that stores data to a text file on a device. SQLite database supports all the relational database features. SQLite is a build-in database implementation that comes with Android. You don’t need to establish any connections like JDBC, ODBC, or any other external connection for it, like what you will need to do in java applications.
In Android, whenever an application needs to store a large amount of data the SQLite is the most preferred. It is better than any other repository systems like SharedPreferences or saving data in files. For many applications in Android, SQLite is the backbone of the app, whether it’s used directly or via some third-party wrapper.
SQLite Database Package
Three main components are used to handle SQLite operations in Android:
SQLiteOpenHelper Class
The SQLiteOpenHelper class is used to determine the name and version of the database used in this class. It is responsible for opening the database if it exists, creating if it does not exists and upgrading if required.
There are the onCreate() and onUpgrade() methods.
onCreate() invoked if the database doesn’t exist, meaning the very first time dealing with the SQLite database. Moreover, the onUpgrade() method is used to update the database schema to the most recent or, let’s say, the existing without losing the data:
SQLiteDatabase in Android
The base class of the SQLite database class is SQLiteDatabase.
Android has its implementation to perform CRUD (Create, Read, Update, Delete) operations.
The SQLiteDatabase have methods such as insert(), update(), delete() and also execSQL() which are used for the execution of the database.
Cursor
The query function will return the cursor object, which results from a query. One record is equal to the row of the query results.
In Android, the cursor can perform buffer query results efficiently as it does not need to load the data into the memory.
The most commonly used methods of the cursor are getCount(), moveToFirst(), moveToNext(). The getCount() used to get the number of records from the query results. The moveToFirst() used to move to the first record of the line. And the moveToNext() used to move to the next line.
If you need additional details from our SQLite android tutorial, you can have a look at the official documentation of Android SQLite Database.
For using the methods insert() and update(), you need to define the object ContentValues in terms of KEY and VALUE to the table. The key represents the identity column of the table. And the value represents the record of the table of the column.
The query can be built in the SQLite database with the methods such as rawQuery() and query() using the SQLiteQueryBuilder class. The rawQuery() method accepts an SQL statement as input.
The query() method has a structured interface in terms of parameters to specify the SQL query. The SQLiteQueryBuilder class allows you to create SQL queries.
Example of Query()
1
Example of rawQuery()
Cursor cursor = getReadableDatabase();
rawQuery("select * from EmployeeTable);
1
2
Cursor cursor = getReadableDatabase();
rawQuery("select * from EmployeeTable);
#SQLite #androidSQLite #androidSQLiteTutorial
Check out the article including the code:
tutorialsEU offers you free video tutorials about programming and development for complete beginners up to experienced programmers.
This includes C#, Unity, Python, Android, Kotlin, Machine Learning, etc.
1:28:22
SQLite Database for Android - Full Course
0:28:23
SQLite Database Tutorial Android Studio | Insert, Delete, Update and View Data in SQLite Database
1:05:04
Android SQLite Database Tutorial 📱 Complete 1-HOUR SQLite Android Tutorial | Kotlin & Android St...
0:07:09
Android Tutorial (Kotlin) - 30 - SQLite Database Creation and Insertion
0:10:54
Android SQLite Database Tutorial 1 # Introduction + Creating Database and Tables (Part 1)
1:34:28
Android SQLite Database Tutorial - Build Note Taking App
0:28:16
SQLite Database in Android Studio | 38 | Android Development Tutorial for Beginners
0:26:10
Android SQLite Database Tutorial - Reading and Writing
0:45:20
Android SQLite Database Tutorial | Android Kotlin | CRUD Operation
0:09:13
Android SQLite Database Part - 1
0:04:47
How to Create SQLite Database in Android Studio | tutorial-2
0:04:43
Android Open and Close Database | Android SQLite Database Example Tutorial
1:17:55
Android SQLite Tutorial | Android CRUD Tutorial with SQLite (Create, Read, Update, Delete)
0:18:38
SQLite Database Tutorial Android Studio | Note List View App with Persistent Data
0:16:50
Android SQLite Database Tutorial || How to create Database and Table in Android studio project || #1
0:36:09
Android SQLite Tutorial | Android CRUD Tutorial with SQLite (Create, Read, Update, Delete) | #Part 1
0:22:44
SQLite Open Helper: How to Create Database in Android? | Android SQLite Tutorial
0:06:19
How To Add Data in SQLite Database in Android | tutorial-5
0:13:48
Android SQLite Database part 1 | Android Tutorial #43
0:37:55
Android SQLite Database Tutorial
0:47:19
The FULL Beginner Guide for Room in Android | Local Database Tutorial for Android
0:14:39
Android SQLite Database Tutorial 2 # Introduction + Creating Database and Tables (Part 2)
0:14:44
SQLite + Android - Create Database Schema (Book Library App) | Part 1
0:09:07
SQLite in Android Theory
Комментарии