sqlite database in android studio tutorial pdf

SQLITE DATABASE IN ANDROID STUDIO TUTORIAL PDF UPDATE
SQLITE DATABASE IN ANDROID STUDIO TUTORIAL PDF CODE

OpenOrCreateDatabase(File file, SQLiteDatabase.CursorFactory factory)

This method is equivalent to openDatabase method. It not only opens but create the database if it not exists. OpenOrCreateDatabase(String path, SQLiteDatabase.CursorFactory factory) It is similar to the above method as it also opens the existing database but it does not define any handler to handle the errors of databases OpenDatabase(String path, SQLiteDatabase.CursorFactory factory, int flags) The common flags mode could be OPEN_READWRITE OPEN_READONLY This method only opens the existing database with the appropriate flag mode. SQLiteDatabase.OpenDatabase(String path, SQLiteDatabase.CursorFactory factory, int flags, DatabaseErrorHandler errorHandler)

SQLITE DATABASE IN ANDROID STUDIO TUTORIAL PDF CODE

The code of this constructor looks like this: public MyDBHandler(Context context, Stringname, The database can be initialized in the constructor of the MyDBHandler class. We must also use import statements, as follows: import Type Student in the Name item, maintain the default options, and click the OK button:Īdding the following lines of code for the Student class: public class Student Right-click the myfirstdatabase package and selecting New > Java Class. The Student class contains fields, constructors, and properties as follows: My application model can be shown in the following figure: A third class (Student class) will need to be implemented to hold the database entry data as it is passed between the activity and the handler. The database handler will be a subclass of SQLiteOpenHelper and will provide an abstract layer between the underlying SQLite database and the activity class. The application will consist of an activity and a database handler class (MyDBHandler class). We will create a database Android application that has a UI as follows: getReadableDatabase(): creates or opens a database for reading only.ĬontentValues allows key/value pairs to be declared consisting of table column identifiers and the values to be stored in each column.getWritableDatabase(): opens or creates a database for reading and writing.onOpen(): called when the database is opened.onUpgrade(): called in the event that the application code contains a more recent database version number reference.onCreate(): called when the database is created for the first time.

SQLITE DATABASE IN ANDROID STUDIO TUTORIAL PDF UPDATE

SQLiteOpenHelper is designed to make it easier to create and update databases. rawQuery(): executes an SQL query statement and returns matching results in the form of a Cursor object.execSQL(): executes a single SQL Statement that does not return result data.query(): performs a specified database query and returns matching results via a Cursor object.delete(): deletes rows from a database table.insert(): inserts a new row into a database table.

SQLiteDatabase provides the primary interface between the application code and underlying SQLite database. get() (such as getInt(), getDouble(), so on): returns the value of the specified contained at the specified column index of the row at the current cursor position.move(): moves by a specified offset from the current position in the result set.moveToNext(): moves to the next row in the result set.moveToLast(): moves to the last row in the result set.moveToFirst(): moves to the first row in the result set.getCount(): returns the number of rows contained within the result set.

close(): release all resources used by cursor and close it.

Android SQLite Java ClassesĬursor: a class provides access to the results of a database query. Like other RDBMSs, data is accessed in a SQLite database by using Structured Query Language (SQL). are standalone server processes, then SQLite is embedded because it is provided in the form of a library that is linked in applications. If most RDBMSs such as MySQL, Oracle, etc. SQLite is a relational database management system (RDBMS).

Sqlite database in android studio tutorial pdf