Uses of Interface
io.ebean.SqlQuery
-
Uses of SqlQuery in io.ebean
Methods in io.ebean that return SqlQuery Modifier and Type Method Description SqlQueryDatabase. createSqlQuery(String sql)Deprecated.static SqlQueryDB. createSqlQuery(String sql)Deprecated.static SqlQueryEbean. createSqlQuery(String sql)Deprecated.SqlQuerySqlQuery. setBufferFetchSizeHint(int bufferFetchSizeHint)A hint which for JDBC translates to the Statement.fetchSize().SqlQuerySqlQuery. setFirstRow(int firstRow)Set the index of the first row of the results to return.SqlQuerySqlQuery. setLabel(String label)Set a label that can be put on performance metrics that are collected.SqlQuerySqlQuery. setMaxRows(int maxRows)Set the maximum number of query results to return.SqlQuerySqlQuery. setParameter(int position, Object value)Bind the parameter by its index position (1 based like JDBC).SqlQuerySqlQuery. setParameter(Object value)Set the next bind parameter by position.SqlQuerySqlQuery. setParameter(String name, Object value)Bind the named parameter value.SqlQuerySqlQuery. setParameters(Object... values)Set one of more positioned parameters.SqlQuerySqlQuery. setParams(Object... values)Deprecated.SqlQuerySqlQuery. setTimeout(int secs)Set a timeout on this query.SqlQueryDatabase. sqlQuery(String sql)Look to execute a native sql query that does not returns beans but instead returns SqlRow or direct access to ResultSet (seefindList(RowMapper).static SqlQueryDB. sqlQuery(String sql)Look to execute a native sql query that does not returns beans but instead returns SqlRow or direct access to ResultSet (seefindList(RowMapper).Methods in io.ebean with parameters of type SqlQuery Modifier and Type Method Description voidExtendedServer. findEach(SqlQuery query, Consumer<SqlRow> consumer, Transaction transaction)Execute the SqlQuery iterating a row at a time.voidExtendedServer. 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.List<SqlRow>ExtendedServer. findList(SqlQuery query, Transaction transaction)Execute the sql query returning a list of MapBean.SqlRowExtendedServer. findOne(SqlQuery query, Transaction transaction)Execute the sql query returning a single MapBean or null.