Android - An Open Handset Alliance Project

android.database.sqlite
public class

android.database.sqlite.SQLiteStatement

java.lang.Object
	android.database.sqlite.SQLiteProgram		SQLiteClosable
		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.

Summary

Fields inherited from class android.database.sqlite.SQLiteProgram

mDatabase, nHandle, nStatement

Public Methods

				void	execute()
					Execute this SQL statment, if it is not a query.
				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

bindDouble, bindLong, bindNull, bindString, clearBindings, close, compile, finalize, getUniqueId, native_compile

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

	Object	clone()
		Answers a new instance of the same class as the receiver, whose slots have been filled in with the values in the slots of the receiver.
	boolean	equals(Object o)
		Compares the argument to the receiver, and answers true if they represent the same object using a class specific comparison.
	void	finalize()
		Called by the virtual machine when there are no longer any (non-weak) references to the receiver.
final	Class	getClass()
		Answers the unique instance of java.lang.Class which represents the class of the receiver.
	int	hashCode()
		Answers an integer hash code for the receiver.
final	void	notify()
		Causes one thread which is `wait` ing on the receiver to be made ready to run.
final	void	notifyAll()
		Causes all threads which are `wait` ing on the receiver to be made ready to run.
	String	toString()
		Answers a string containing a concise, human-readable description of the receiver.
final	void	wait(long time, int frac)
		Causes the thread which sent this message to be made not ready to run either pending some change in the receiver (as indicated by `notify` or `notifyAll`) or the expiration of the timeout.
final	void	wait(long time)
		Causes the thread which sent this message to be made not ready to run either pending some change in the receiver (as indicated by `notify` or `notifyAll`) or the expiration of the timeout.
final	void	wait()
		Causes the thread which sent this message to be made not ready to run pending some change in the receiver (as indicated by `notify` or `notifyAll`).

Methods inherited from interface android.database.sqlite.SQLiteClosable

Details

Public Methods

public void execute()

Execute this SQL statment, 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 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.

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.

	void	bindDouble(int index, double value)
		Bind a double value to this statement.
	void	bindLong(int index, long value)
		Bind a long value to this statement.
	void	bindNull(int index)
		Bind a NULL value to this statement.
	void	bindString(int index, String value)
		Bind a String value to this statement.
	void	clearBindings()
		Clears all existing bindings.
	void	close()
		Release this program's resources, making it invalid.
	void	compile(String sql)
	void	finalize()
		Make sure that the native resource is cleaned up.
final	int	getUniqueId()
		Returns a unique identifier for this program.
final	void	native_compile(String sql)
		Compiles SQL into a SQLite program.

Android - An Open Handset Alliance Project

Documentation

Goodies

android.database.sqlite.SQLiteStatement

Summary

Fields inherited from class android.database.sqlite.SQLiteProgram

Public Methods

Methods inherited from class android.database.sqlite.SQLiteProgram

Methods inherited from class java.lang.Object

Methods inherited from interface android.database.sqlite.SQLiteClosable

Details

Public Methods

public void execute()

Throws

public long simpleQueryForLong()

Returns

public String simpleQueryForString()

Returns

protected	SQLiteDatabase	mDatabase	The database this program is compiled against.
protected	int	nHandle	Native linkage, do not modify
protected	int	nStatement	Native linkage, do not modify


e.g. "intent" or "activity"