SQLite databases
SQLite databases are light weight file based databases. They usually have the extension .db
or .sqlite
. Android provides full support for SQLite databases. Databases we create in the application will be accessible to any class in the application. Other apps cannot access them.
The following code snippet shows a sample application storing username and password in an SQLite database user.db
:
String uName=editTextUName.getText().toString(); String passwd=editTextPasswd.getText().toString(); context=LoginActivity.this; dbhelper = DBHelper(context, "user.db",null, 1); dbhelper.insertEntry(uName, password);
Programmatically, we are extending the SQLiteOpenHelper
class to implement the insert
and read
method. We are inserting the values from the user into a table called USER
:
import android.database.sqlite.SQLiteDatabase; import android.database.sqlite.SQLiteDatabase.CursorFactory; import android.database.sqlite.SQLiteOpenHelper; public class DBHelper extends SQLiteOpenHelper ...