Uses of Interface
io.ebean.SqlQuery
Packages that use SqlQuery
-
Uses of SqlQuery in io.ebean
Modifier and TypeMethodDescriptionSqlQuery.setBufferFetchSizeHint
(int bufferFetchSizeHint) A hint which for JDBC translates to the Statement.fetchSize().SqlQuery.setFirstRow
(int firstRow) Set the index of the first row of the results to return.Set a label that can be put on performance metrics that are collected.SqlQuery.setMaxRows
(int maxRows) Set the maximum number of query results to return.SqlQuery.setNullParameter
(int position, int jdbcType) Set a null parameter by position.SqlQuery.setNullParameter
(String name, int jdbcType) Set a null parameter by name.SqlQuery.setParameter
(int position, Object value) Bind the parameter by its index position (1 based like JDBC).SqlQuery.setParameter
(Object value) Set the next bind parameter by position.SqlQuery.setParameter
(String name, Object value) Bind the named parameter value.SqlQuery.setParameters
(Object... values) Set one of more positioned parameters.SqlQuery.setTimeout
(int secs) Set a timeout on this query.Look to execute a native sql query that does not return beans but instead returns SqlRow or direct access to ResultSet.static SqlQuery
Look to execute a native sql query that does not return beans but instead returns SqlRow or usesRowMapper
.Modifier and TypeMethodDescriptionvoid
ExtendedServer.findEach
(SqlQuery query, Consumer<SqlRow> consumer, Transaction transaction) Execute the SqlQuery iterating a row at a time.void
ExtendedServer.findEachWhile
(SqlQuery query, Predicate<SqlRow> consumer, Transaction transaction) Execute the SqlQuery iterating a row at a time with the ability to stop consuming part way through.ExtendedServer.findList
(SqlQuery query, Transaction transaction) Execute the sql query returning a list of MapBean.ExtendedServer.findOne
(SqlQuery query, Transaction transaction) Execute the sql query returning a single MapBean or null.