oseinner.blogg.se - Sqlite database in android example step by step

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).