Package io.vertx.sqlclient
Interface PreparedStatement
-
public interface PreparedStatementA prepared statement, the statement is pre-compiled and it's more efficient to execute the statement for multiple times. In addition, this kind of statement provides protection against SQL injection attacks.From a prepared statement you can
- use
query()to create and execute aPreparedQuery - use
cursor()to create aCursor - use
createStream(int)to create aRowStream
- Author:
- Julien Viet
- use
-
-
Method Summary
All Methods Instance Methods Abstract Methods Default Methods Modifier and Type Method Description Future<Void>close()Close the prepared query and release its resources.default RowStream<Row>createStream(int fetch)LikecreateStream(int, Tuple)but with empty arguments.RowStream<Row>createStream(int fetch, Tuple args)Execute the prepared query with a cursor and createStream the result.default Cursorcursor()Likecursor(Tuple)but with empty arguments.Cursorcursor(Tuple args)Create a cursor with the providedarguments.PreparedQuery<RowSet<Row>>query()Create a prepared query for this statement.
-
-
-
Method Detail
-
query
PreparedQuery<RowSet<Row>> query()
Create a prepared query for this statement.- Returns:
- the prepared query
-
cursor
default Cursor cursor()
Likecursor(Tuple)but with empty arguments.
-
cursor
Cursor cursor(Tuple args)
Create a cursor with the providedarguments.- Parameters:
args- the list of arguments- Returns:
- the query
-
createStream
default RowStream<Row> createStream(int fetch)
LikecreateStream(int, Tuple)but with empty arguments.
-
createStream
RowStream<Row> createStream(int fetch, Tuple args)
Execute the prepared query with a cursor and createStream the result. The createStream opens a cursor with afetchsize to fetch the results. Note: this requires to be in a transaction, since cursors require it.- Parameters:
fetch- the cursor fetch sizeargs- the prepared query arguments- Returns:
- the createStream
-
-