Video by Android Coding via YouTube
Source

SQLite Tutorial : In This Video, You Will Learn How to Integrate SQLite Database in Android Studio.

//Create table query
String sQuery = "create table " + TableName + "(id INTEGER primary key autoincrement,text TEXT,date TEXT)";

//Drop table query
String sQuery = "drop table if exists " + TableName;

//Update query
String sQuery = "update " + TableName + " set text=’" + text + "’ where id=’" + id + "’";

//Delete query
String sQuery = "delete from " + TableName + " where id=’" + id + "’";

//Truncate table query
String sQuery1 = "delete from " + TableName;

//Reset sequence query
String sQuery2 = "DELETE FROM sqlite_sequence WHERE name = ‘" + TableName + "’";

//Select all query
String sQuery = "select * from " + TableName;

Build.Gradle :
implementation ‘com.google.android.material:material:1.4.0’

All File :
== XML File ==
1) res/layout/activity_main.xml
2) res/layout/item_main.xml
3) res/layout/dialog_main.xml
== Java File ==
1) java/MainActivity.java
2) java/MainAdapter.java
3) java/DatabaseHelper.java

Table Of Content :
00:27 – Preview
01:08 – Project Creation
01:22 – XML Code
05:18 – Java Code
32:17 – Output

Presented By : Android Coding
Background Music By : BreakingCopyright

Join this channel to get access to perks:
https://www.youtube.com/channel/UCUIF5MImktJLDWDKe5oTdJQ/join

Download Apk Link :
https://drive.google.com/file/d/199so_W9xx5lWOms-qruC_W2x6nQ35lt-/view

All My App Links :
1) QR Scanner App : http://bit.ly/ScannerAndGenerator
2) Colors Code App : http://bit.ly/ColorsCode
3) Age Calculator App : http://bit.ly/AndroidAgeCalculator

Enjoy & Stay Connected With Us!
► Subscribe To Android Coding : http://bit.ly/Youtube-AndroidCoding
► Like Us On Facebook : http://bit.ly/Facebook-AndroidCoding
► Follow Us On Instagram : http://bit.ly/Instagram-AndroidCoding
► Follow Us On Twitter : http://bit.ly/Twitter-AndroidCoding_

#SQLiteDatabase #AndroidTutorial #12H1r

Go to Source