Uses of Class
io.github.blyznytsiaorg.bibernate.dao.jdbc.dsl.SelectQueryBuilder
-
Uses of SelectQueryBuilder in io.github.blyznytsiaorg.bibernate.dao.jdbc.dsl
Modifier and TypeFieldDescriptionprivate final List
<SelectQueryBuilder> SelectQueryBuilder.unionQueries
The list of SELECT queries to be combined using UNION.Modifier and TypeMethodDescriptionSelectQueryBuilder.andCondition
(String condition) Adds an AND condition to the existing WHERE conditions.SelectQueryBuilder.betweenCondition
(String field, Object lowerBound, Object upperBound) Adds a BETWEEN condition to the existing WHERE conditions.static SelectQueryBuilder
Creates a new SelectQueryBuilder with the specified table name.Sets the field for GROUP BY clauses in the SELECT statement.SelectQueryBuilder.havingCondition
(String havingCondition) Sets the condition for HAVING clauses in the SELECT statement.Adds a JOIN clause to the SELECT statement.SelectQueryBuilder.join
(List<JoinClause> joinClausesList) Adds a list of join clauses to the current select query builder.SelectQueryBuilder.orCondition
(String condition) Adds an OR condition to the existing WHERE conditions.SelectQueryBuilder.selectField
(String fieldName) Adds a field to the list of fields to be selected in the SELECT statement.SelectQueryBuilder.selectFieldFromTable
(String tableName, String fieldName) Adds a specific field from a specified table to the list of fields to be selected.SelectQueryBuilder.selectFields
(List<String> fieldNames) SelectQueryBuilder.selectFieldsFromTable
(String tableName) Adds all fields from a specified table to the list of fields to be selected.SelectQueryBuilder.union
(SelectQueryBuilder otherQuery) Combines the current SELECT query with another query using the UNION operator.SelectQueryBuilder.whereCondition
(String condition) Adds a WHERE condition to the SELECT statement.Modifier and TypeMethodDescriptionSelectQueryBuilder.union
(SelectQueryBuilder otherQuery) Combines the current SELECT query with another query using the UNION operator.