Struct Statement 

pub struct Statement<'sql> { /* private fields */ }

Represents SQL statements that can be executed with various options.

Implementations

impl<'sql> Statement<'sql>

pub fn execute(&self, params: &[&dyn ToDbValue]) -> Result<ExecResult, Error>

Executes the statement with the given parameters and returns an ExecResult structure. The statement that is executed may not be a query.

pub fn execute_batch( &self, params: BindParameters<'_>, ) -> Result<ExecResult, Error>

Executes a SQL statement against the database multiple times in one round trip.

pub fn execute_named( &self, params: &[(&str, &dyn ToDbValue)], ) -> Result<ExecResult, Error>

Executes the statement with the given named parameters and returns an ExecResult structure. The statement that is executed may not be a query.

pub fn exclude_from_cache(&mut self) -> &mut Self

Specifies that this statement should not be cached.

pub fn fetch_array_size(&mut self, value: u32) -> &mut Self

Specifies the number of rows that should be fetched at a time from the database.

pub fn fetch_lobs(&mut self) -> &mut Self

Specifies that LOB values should be fetched as LOB locators.

pub fn prefetch_rows(&mut self, value: u32) -> &mut Self

Specifies the number of rows that should be fetched when the statement is executed.

pub fn query(&self, params: &[&dyn ToDbValue]) -> Result<Cursor, Error>

Executes the statement with the given parameters and returns a Cursor which can be used to iterate over the rows returned by the query. The statement that is executed must be a query.

pub fn query_named( &self, params: &[(&str, &dyn ToDbValue)], ) -> Result<Cursor, Error>

Executes the statement with the given parameters and returns a Cursor which can be used to iterate over the rows returned by the query. The statement that is executed must be a query.

pub fn query_row(&self, params: &[&dyn ToDbValue]) -> Result<Row, Error>

Executes the statement with the given parameters and returns the first row supplied by the database. If no rows are found, a NoDataFound error is returned instead.

pub fn query_row_named( &self, params: &[(&str, &dyn ToDbValue)], ) -> Result<Row, Error>

Executes the statement with the given parameters and returns the first row supplied by the database. If no rows are found, a NoDataFound error is returned instead.