class Statement
extends anvil.sql.MetaData

JDBC prepared or callable statement.

Methods

Clears the current parameter values immediately.

In general, parameter values remain in force for repeated use of a Statement. Setting a parameter value automatically clears its previous value. However, in some cases it is useful to immediately release the resourcesused by the current parameter values; this can be done by calling clear.

Returns	this
Throws	`SQLError -` if an error occured

boolean close()

Closes this result set, releasing all the resources associated with it.

Returns	true if operation was successful
Throws	`SQLError -` if an error occured

ResultSet query()

Executes the SQL query in this Statement object and returns the result set generated by the query.

Returns	ResultSet
Throws	`SQLError -` if an error occured

Statement register(int column, int type)
Statement register(int column, int type, int scale)

Registers the OUT parameter in ordinal position parameterIndex to the JDBC type sqlType. All OUT parameters must be registered before a stored procedure is executed.

Parameters	`column -` Column index, `0<=column<getColumnCount()` `type -` Type code `scale -` the desired number of digits to the right of the / decimal point. It must be greater than or equal to zero.
Returns	this
Throws	`SQLError -` if an error occured

Statement reset()

Resets the column pointer back to start.

int update()

Executes the SQL update statement in this Statement object. Also statements returning nothing can be executed.

Returns	Number of rows affected.
Throws	`SQLError -` if an error occured

Attributes

object Statement.columnName
Returns the value of parameter with given name.
object Statement.columnName = value
Sets the value of parameter with given name.

Parameters columnName - Name of column
value - value to assign

References

object Statement[int columnIndex]
Returns the value of parameter at given index.
object Statement[string columnName]
Returns the value of parameter at column with given name.
Statement[int columnIndex] = value
Sets the value of parameter at given index.
Statement[string columnName] = value
Returns the value of parameter with given name.

Parameters columnIndex - Index of column, from 0 (inclusive) to getColumnCount()-1.
columnName - Name of column