Android

android.database.sqlite.SQLiteStatement

java.lang.Object
android.database.sqlite.SQLiteClosable
android.database.sqlite.SQLiteProgram
android.database.sqlite.SQLiteStatement

A pre-compiled statement against a SQLiteDatabase that can be reused. The statement cannot return multiple rows, but 1x1 result sets are allowed. Don't use SQLiteStatement constructor directly, please use compileStatement(String)

Summary

Fields inherited from class android.database.sqlite.SQLiteProgram

Public Methods

          void  execute()
Execute this SQL statement, if it is not a query.
          long  executeInsert()
Execute this SQL statement and return the ID of the most recently inserted row.
          long  simpleQueryForLong()
Execute a statement that returns a 1 by 1 table with a numeric value.
          String  simpleQueryForString()
Execute a statement that returns a 1 by 1 table with a text value.
Methods inherited from class android.database.sqlite.SQLiteProgram
Methods inherited from class android.database.sqlite.SQLiteClosable
Methods inherited from class java.lang.Object

Details

Public Methods

public void execute()

Execute this SQL statement, if it is not a query. For example, CREATE TABLE, DELTE, INSERT, etc.

Throws

SQLException If the SQL string is invalid for some reason

public long executeInsert()

Execute this SQL statement and return the ID of the most recently inserted row. The SQL statement should probably be an INSERT for this to be a useful call.

Returns

  • the row ID of the last row inserted.

Throws

SQLException If the SQL string is invalid for some reason

public long simpleQueryForLong()

Execute a statement that returns a 1 by 1 table with a numeric value. For example, SELECT COUNT(*) FROM table;

Returns

  • The result of the query.

Throws

SQLiteDoneException if the query returns zero rows

public String simpleQueryForString()

Execute a statement that returns a 1 by 1 table with a text value. For example, SELECT COUNT(*) FROM table;

Returns

  • The result of the query.

Throws

SQLiteDoneException if the query returns zero rows
Copyright 2007 Google Inc. Build 0.9_r1-98467 - 14 Aug 2008 18:56