GetWritableDatabase(): opens or creates a database for reading and writing. OnOpen(): called when the database is opened.
WRITE A SIMPLE ANDROID PROGRAM CODE
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.
WRITE A SIMPLE ANDROID PROGRAM 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. Query(): performs a specified database query and returns matching results via a Cursor object.ĮxecSQL(): executes a single SQL Statement that does not return result data.
Insert(): inserts a new row into a database table.ĭelete(): deletes rows from 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. Its methods include:Ĭlose(): 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).
0 kommentar(er)
