filmov
tv
Android SQLite Tutorial | Android CRUD Tutorial with SQLite (Create, Read, Update, Delete) | #Part 1
![preview_player](https://i.ytimg.com/vi/BcpVlXo2F3U/maxresdefault.jpg)
ะะพะบะฐะทะฐัั ะพะฟะธัะฐะฝะธะต
#๐๐๐ซ๐ญ ๐ (๐๐ง๐ฌ๐๐ซ๐ญ ๐๐ง๐ ๐๐๐๐ ๐๐๐ญ๐)
Hello Guys,In this ๐๐ง๐๐ซ๐จ๐ข๐ ๐ฌ๐ญ๐ฎ๐๐ข๐จ tutorial we will learn to ๐ข๐ง๐ฌ๐๐ซ๐ญ,๐ฎ๐ฉ๐๐๐ญ๐,๐๐๐ฅ๐๐ญ๐,๐ฌ๐๐ฅ๐๐๐ญ data in ๐๐๐๐ข๐ญ๐ D๐๐ญ๐๐๐๐ฌ๐.in this example we will store ๐๐ฆ๐ฉ๐ฅ๐จ๐ฒ๐๐ name,email in to ๐๐๐๐ข๐ญ๐ D๐๐ญ๐๐๐๐ฌ๐ and then select and modify data in ๐๐๐๐ข๐ญ๐ D๐๐ญ๐๐๐๐ฌ๐ in very simple way.
๐๐ก๐๐ญ ๐ข๐ฌ ๐๐๐๐ข๐ญ๐ ?
-SQLite is a opensource SQL database that stores data to a text file on a device. Android comes in with built in SQLite database implementation.
-To use SQLiteOpenHelper, create a subclass that overrides the onCreate() and onUpgrade() callback methods.
-SQLite supports all the relational database features. In order to access this database, you don't need to establish any kind of connections for it like JDBC,ODBC ,MySql e.t.c
๐๐๐ญ๐๐๐๐ฌ๐ - ๐๐๐ฅ๐ฉ๐๐ซ ๐๐ฅ๐๐ฌ๐ฌ
For managing all the operations related to the database , an helper class has been given and is called SQLiteOpenHelper. It automatically manages the creation and update of the database. Its syntax is given below
๐๐๐ญ๐๐๐๐ฌ๐ - ๐๐ซ๐๐๐ญ๐ข๐จ๐ง
In order to create a database you just need to call this method openOrCreateDatabase with your database name and mode as a parameter. It returns an instance of SQLite database which you have to receive in your own object.
๐๐๐ญ๐๐๐๐ฌ๐ - ๐๐ง๐ฌ๐๐ซ๐ญ๐ข๐จ๐ง
we can create table or insert data into table using execSQL method defined in SQLiteDatabase class.
๐๐๐ญ๐๐๐๐ฌ๐ - ๐ ๐๐ญ๐๐ก๐ข๐ง๐
We can retrieve anything from database using an object of the Cursor class. We will call a method of this class called rawQuery and it will return a resultset with the cursor pointing to the table. We can move the cursor forward and retrieve the data.
Please ๐๐๐ข๐ค๐ ,๐ค๐ฆ๐ต๐ฒ๐ฎ๐ฟ,โ๐๐จ๐ฆ๐ฆ๐๐ง๐ญ And โ๐แดส๐สษชสแด My ๐ฌ๐ข๐จ๐ง๐จ๐๐ Channel
๐ ๐จ๐ซ ๐๐ฎ๐ฌ๐ฌ๐ข๐ง๐๐ฌ๐ฌ ๐๐ง๐ช๐ฎ๐ข๐ซ๐ข๐๐ฌ
๐แดส๐สษชสแด My ๐ฌ๐ข๐จ๐ง๐จ๐๐ Channel #๐ฐ๐ผ๐ฑ๐ถ๐ป๐ด๐๐ถ๐๐ฑ๐ฒ๐ for more latest videos..
Thank You :-)
#SQLite #AndroidStudioTutorial #CRUD #sqlitedatabase #create #update #read #delete #Android #EmployeeDirectoryApp #recyclerview #listview
#sqlite database in android example step by step
#how to connect sqlite database in android studio
#how to insert data in sqlite database in android studio
#how to store data in sqlite database in android example
#how to insert and retrieve data from sqlite database in android
#simple sqlite database example in android
#android sqlite tutorial for beginners
#Setting up an Android SQlite Database - Employee Directory App #1
Hello Guys,In this ๐๐ง๐๐ซ๐จ๐ข๐ ๐ฌ๐ญ๐ฎ๐๐ข๐จ tutorial we will learn to ๐ข๐ง๐ฌ๐๐ซ๐ญ,๐ฎ๐ฉ๐๐๐ญ๐,๐๐๐ฅ๐๐ญ๐,๐ฌ๐๐ฅ๐๐๐ญ data in ๐๐๐๐ข๐ญ๐ D๐๐ญ๐๐๐๐ฌ๐.in this example we will store ๐๐ฆ๐ฉ๐ฅ๐จ๐ฒ๐๐ name,email in to ๐๐๐๐ข๐ญ๐ D๐๐ญ๐๐๐๐ฌ๐ and then select and modify data in ๐๐๐๐ข๐ญ๐ D๐๐ญ๐๐๐๐ฌ๐ in very simple way.
๐๐ก๐๐ญ ๐ข๐ฌ ๐๐๐๐ข๐ญ๐ ?
-SQLite is a opensource SQL database that stores data to a text file on a device. Android comes in with built in SQLite database implementation.
-To use SQLiteOpenHelper, create a subclass that overrides the onCreate() and onUpgrade() callback methods.
-SQLite supports all the relational database features. In order to access this database, you don't need to establish any kind of connections for it like JDBC,ODBC ,MySql e.t.c
๐๐๐ญ๐๐๐๐ฌ๐ - ๐๐๐ฅ๐ฉ๐๐ซ ๐๐ฅ๐๐ฌ๐ฌ
For managing all the operations related to the database , an helper class has been given and is called SQLiteOpenHelper. It automatically manages the creation and update of the database. Its syntax is given below
๐๐๐ญ๐๐๐๐ฌ๐ - ๐๐ซ๐๐๐ญ๐ข๐จ๐ง
In order to create a database you just need to call this method openOrCreateDatabase with your database name and mode as a parameter. It returns an instance of SQLite database which you have to receive in your own object.
๐๐๐ญ๐๐๐๐ฌ๐ - ๐๐ง๐ฌ๐๐ซ๐ญ๐ข๐จ๐ง
we can create table or insert data into table using execSQL method defined in SQLiteDatabase class.
๐๐๐ญ๐๐๐๐ฌ๐ - ๐ ๐๐ญ๐๐ก๐ข๐ง๐
We can retrieve anything from database using an object of the Cursor class. We will call a method of this class called rawQuery and it will return a resultset with the cursor pointing to the table. We can move the cursor forward and retrieve the data.
Please ๐๐๐ข๐ค๐ ,๐ค๐ฆ๐ต๐ฒ๐ฎ๐ฟ,โ๐๐จ๐ฆ๐ฆ๐๐ง๐ญ And โ๐แดส๐สษชสแด My ๐ฌ๐ข๐จ๐ง๐จ๐๐ Channel
๐ ๐จ๐ซ ๐๐ฎ๐ฌ๐ฌ๐ข๐ง๐๐ฌ๐ฌ ๐๐ง๐ช๐ฎ๐ข๐ซ๐ข๐๐ฌ
๐แดส๐สษชสแด My ๐ฌ๐ข๐จ๐ง๐จ๐๐ Channel #๐ฐ๐ผ๐ฑ๐ถ๐ป๐ด๐๐ถ๐๐ฑ๐ฒ๐ for more latest videos..
Thank You :-)
#SQLite #AndroidStudioTutorial #CRUD #sqlitedatabase #create #update #read #delete #Android #EmployeeDirectoryApp #recyclerview #listview
#sqlite database in android example step by step
#how to connect sqlite database in android studio
#how to insert data in sqlite database in android studio
#how to store data in sqlite database in android example
#how to insert and retrieve data from sqlite database in android
#simple sqlite database example in android
#android sqlite tutorial for beginners
#Setting up an Android SQlite Database - Employee Directory App #1
ะะพะผะผะตะฝัะฐัะธะธ