SQLite database in android

This PPT shows how to connect SQL database with your Android App

1. SQLite Database in Android

2. Topics What is SQLite? How to install SQLite for AndroidStudio ? How to implement SQLite in Android App? How to store data in SQLite database? Login and Registration App using SQLite Database.

3. What is SQLite? SQLite is a Open Source Database. SQLite supports standard relation database feature. It is a Serverless and Zero-configuration database engine.

4. How to install SQLite for AndroidStudio? NO need to install SQLite externally .Android Studio has in built SQLite database.

5. How to use SQLite in Android App? We can use SQLite database in your Android App using some Pre-Define classes. SQLiteOpenHelper is most commonly use class to connect your Application with database. We have to extends this class in our Database class. This class is help to CRUD ( Create Retrieve Update Delete ).

6. Create A Table in Database // SQL Statement to create a new database. static final String DATABASE_CREATE = "create table " + "LOGIN" + "( " + "ID" + " integer primary key autoincrement ," + "USERNAME text,PASSWORD text); " ;

7. How to store data in SQLite database? In your database class: public void insertEntry (String userName,String password) { ContentValues newValues = new ContentValues (); // Assign values for each row. newValues.put ( "USERNAME" , userName ); newValues.put ( " PASSWORD" ,password ); // Insert the row into your table db .insert ( "LOGIN" , null , newValues ); /// Toast.makeText (context, “Reminder Is Successfully Saved”, Toast.LENGTH_LONG ).show(); }

8. In DataInsert Class loginDataBaseAdapter .insertEntry ( userName , password);

9. How to check store data in SQLite? TO check store data you need to download SQL Browser .

10. THANK YOU