Skip to content

Most visited

Recently visited

navigation
Added in API level 1
Deprecated since API level 17

DatabaseUtils.InsertHelper

public static class DatabaseUtils.InsertHelper
extends Object

java.lang.Object
   ↳ android.database.DatabaseUtils.InsertHelper


This class was deprecated in API level 17.
Use SQLiteStatement instead.

This class allows users to do multiple inserts into a table using the same statement.

This class is not thread-safe.

Summary

Public constructors

DatabaseUtils.InsertHelper(SQLiteDatabase db, String tableName)

Public methods

void bind(int index, float value)

Bind the value to an index.

void bind(int index, int value)

Bind the value to an index.

void bind(int index, double value)

Bind the value to an index.

void bind(int index, byte[] value)

Bind the value to an index.

void bind(int index, long value)

Bind the value to an index.

void bind(int index, boolean value)

Bind the value to an index.

void bind(int index, String value)

Bind the value to an index.

void bindNull(int index)

Bind null to an index.

void close()

Close this object and release any resources associated with it.

long execute()

Execute the previously prepared insert or replace using the bound values since the last call to prepareForInsert or prepareForReplace.

int getColumnIndex(String key)

Returns the index of the specified column.

long insert(ContentValues values)

Performs an insert, adding a new row with the given values.

void prepareForInsert()

Prepare the InsertHelper for an insert.

void prepareForReplace()

Prepare the InsertHelper for a replace.

long replace(ContentValues values)

Performs an insert, adding a new row with the given values.

Inherited methods

From class java.lang.Object

Public constructors

DatabaseUtils.InsertHelper

Added in API level 1
DatabaseUtils.InsertHelper (SQLiteDatabase db, 
                String tableName)

Parameters
db SQLiteDatabase: the SQLiteDatabase to insert into
tableName String: the name of the table to insert into

Public methods

bind

Added in API level 1
void bind (int index, 
                float value)

Bind the value to an index. A prepareForInsert() or prepareForReplace() without a matching execute() must have already have been called.

Parameters
index int: the index of the slot to which to bind
value float: the value to bind

bind

Added in API level 1
void bind (int index, 
                int value)

Bind the value to an index. A prepareForInsert() or prepareForReplace() without a matching execute() must have already have been called.

Parameters
index int: the index of the slot to which to bind
value int: the value to bind

bind

Added in API level 1
void bind (int index, 
                double value)

Bind the value to an index. A prepareForInsert() or prepareForReplace() without a matching execute() must have already have been called.

Parameters
index int: the index of the slot to which to bind
value double: the value to bind

bind

Added in API level 1
void bind (int index, 
                byte[] value)

Bind the value to an index. A prepareForInsert() or prepareForReplace() without a matching execute() must have already have been called.

Parameters
index int: the index of the slot to which to bind
value byte: the value to bind

bind

Added in API level 1
void bind (int index, 
                long value)

Bind the value to an index. A prepareForInsert() or prepareForReplace() without a matching execute() must have already have been called.

Parameters
index int: the index of the slot to which to bind
value long: the value to bind

bind

Added in API level 1
void bind (int index, 
                boolean value)

Bind the value to an index. A prepareForInsert() or prepareForReplace() without a matching execute() must have already have been called.

Parameters
index int: the index of the slot to which to bind
value boolean: the value to bind

bind

Added in API level 1
void bind (int index, 
                String value)

Bind the value to an index. A prepareForInsert() or prepareForReplace() without a matching execute() must have already have been called.

Parameters
index int: the index of the slot to which to bind
value String: the value to bind

bindNull

Added in API level 1
void bindNull (int index)

Bind null to an index. A prepareForInsert() or prepareForReplace() without a matching execute() must have already have been called.

Parameters
index int: the index of the slot to which to bind

close

Added in API level 1
void close ()

Close this object and release any resources associated with it. The behavior of calling insert() after calling this method is undefined.

execute

Added in API level 1
long execute ()

Execute the previously prepared insert or replace using the bound values since the last call to prepareForInsert or prepareForReplace.

Note that calling bind() and then execute() is not thread-safe. The only thread-safe way to use this class is to call insert() or replace().

Returns
long the row ID of the newly inserted row, or -1 if an error occurred

getColumnIndex

Added in API level 1
int getColumnIndex (String key)

Returns the index of the specified column. This is index is suitagble for use in calls to bind().

Parameters
key String: the column name
Returns
int the index of the column

insert

Added in API level 1
long insert (ContentValues values)

Performs an insert, adding a new row with the given values. If the table contains conflicting rows, an error is returned.

Parameters
values ContentValues: the set of values with which to populate the new row
Returns
long the row ID of the newly inserted row, or -1 if an error occurred

prepareForInsert

Added in API level 1
void prepareForInsert ()

Prepare the InsertHelper for an insert. The pattern for this is:

  • prepareForInsert()
  • bind(index, value);
  • bind(index, value);
  • ...
  • bind(index, value);
  • execute();

prepareForReplace

Added in API level 1
void prepareForReplace ()

Prepare the InsertHelper for a replace. The pattern for this is:

  • prepareForReplace()
  • bind(index, value);
  • bind(index, value);
  • ...
  • bind(index, value);
  • execute();

replace

Added in API level 1
long replace (ContentValues values)

Performs an insert, adding a new row with the given values. If the table contains conflicting rows, they are deleted and replaced with the new row.

Parameters
values ContentValues: the set of values with which to populate the new row
Returns
long the row ID of the newly inserted row, or -1 if an error occurred
This site uses cookies to store your preferences for site-specific language and display options.

Hooray!

This class requires API level or higher

This doc is hidden because your selected API level for the documentation is . You can change the documentation API level with the selector above the left navigation.

For more information about specifying the API level your app requires, read Supporting Different Platform Versions.