程序包 ohos.data.rdb

接口 Statement

public interface Statement

Provides methods for setting values for precompiled SQL statements and executing precompiled SQL statements.

从以下版本开始:

1

SystemCapability

SystemCapability.Data#DATA_APPDATAMGR

方法概要

限定符和类型	方法	说明
void	clearValues()	Clears all dynamic values of a precompiled statement.
void	close()	Closes the current precompiled SQL statement.
void	execute()	Executes a precompiled SQL statement.
int	executeAndGetChanges()	Executes a precompiled SQL statement to obtain the number of affected rows.
long	executeAndGetLastInsertRowId()	Executes a precompiled SQL statement to obtain the ID of the last inserted row.
long	executeAndGetLong()	Executes a precompiled SQL statement to obtain a return value of the long type.
String	executeAndGetString()	Executes a precompiled SQL statement to obtain a return value of the string type.
void	setBlob(int index, byte[] value)	Sets a byte array value for a precompiled statement dynamically.
void	setDouble(int index, double value)	Sets a double value for a precompiled statement dynamically.
void	setLong(int index, long value)	Sets a long value for a precompiled statement dynamically.
void	setNull(int index)	Sets null for a precompiled statement dynamically.
void	setObject(int index, Object value)	Sets an object value for a precompiled statement dynamically.
void	setString(int index, String value)	Sets a string value for a precompiled statement dynamically.
void	setStrings(String[] stringValues)	Sets all the string values for a precompiled statement dynamically.

方法详细资料

setNull

void setNull(int index)

Sets null for a precompiled statement dynamically.

参数:

index - Indicates the index of the value to be set for the precompiled statement, which starts from 1.

从以下版本开始:

1

setLong

void setLong(int index,
             long value)

Sets a long value for a precompiled statement dynamically.

参数:

index - Indicates the index of the value to be set for the precompiled statement, which starts from 1.

value - Indicates the value to be set for the precompiled statement.

从以下版本开始:

1

setDouble

void setDouble(int index,
               double value)

Sets a double value for a precompiled statement dynamically.

参数:

index - Indicates the index of the value to be set for the precompiled statement, which starts from 1.

value - Indicates the value to be set for the precompiled statement.

从以下版本开始:

1

setString

void setString(int index,
               String value)

Sets a string value for a precompiled statement dynamically.

参数:

index - Indicates the index of the value to be set for the precompiled statement, which starts from 1.

value - Indicates the value to be set for the precompiled statement.

从以下版本开始:

1

setBlob

void setBlob(int index,
             byte[] value)

Sets a byte array value for a precompiled statement dynamically.

参数:

index - Indicates the index of the value to be set for the precompiled statement, which starts from 1.

value - Indicates the value to be set for the precompiled statement.

从以下版本开始:

1

setStrings

void setStrings(String[] stringValues)

Sets all the string values for a precompiled statement dynamically.

参数:

stringValues - Indicates all the string values.

从以下版本开始:

1

setObject

void setObject(int index,
               Object value)

Sets an object value for a precompiled statement dynamically.

The method used to set the value varies depending on the value type:

• If the value is null, use Statement#setNull(int).
• If the value type is Boolean, use Statement#setLong(int, long). 1 indicates true and 0 indicates false.
• If the value type is byte array, use Statement#setBlob(int, byte[]).
• If the value type is Double or Float, use Statement#setDouble(int, double).
• If the value type is Number, use Statement#setLong(int, long).

If the value is not any of the preceding types, convert it into a string and use Statement#setString(int, String) to set it.

参数:

index - Indicates the index of the value to be set for the precompiled statement, which starts from 1.

value - Indicates the value to be set for the precompiled statement.

从以下版本开始:

1

clearValues

void clearValues()

Clears all dynamic values of a precompiled statement.

从以下版本开始:

1

execute

void execute()

Executes a precompiled SQL statement.

从以下版本开始:

1

executeAndGetLong

long executeAndGetLong()

Executes a precompiled SQL statement to obtain a return value of the long type.

返回:

Returns a value of the long type.

从以下版本开始:

1

executeAndGetString

String executeAndGetString()

Executes a precompiled SQL statement to obtain a return value of the string type.

返回:

Returns a value of the string type.

从以下版本开始:

1

executeAndGetChanges

int executeAndGetChanges()

Executes a precompiled SQL statement to obtain the number of affected rows.

返回:

Returns the number of affected rows.

从以下版本开始:

1

executeAndGetLastInsertRowId

long executeAndGetLastInsertRowId()

Executes a precompiled SQL statement to obtain the ID of the last inserted row.

返回:

Returns the ID of the last inserted row.

从以下版本开始:

1

close

void close()

Closes the current precompiled SQL statement.

A closed SQL statement can no longer be used.

从以下版本开始:

1