JdbcSqlQuery |
JdbcSqlQuery.addField(String fieldName,
String definition) |
Centralization in order to populate the prepare statement parameters (FOR TABLE CREATION ONLY).
|
JdbcSqlQuery |
JdbcSqlQuery.addInsertParam(String paramName,
Object paramValue) |
Centralization in order to populate the prepare statement parameters for insertion.
|
JdbcSqlQuery |
JdbcSqlQuery.addSaveParam(String paramName,
Object paramValue,
boolean isInsert) |
Centralization in order to populate the prepare statement parameters.
|
JdbcSqlQuery |
JdbcSqlQuery.addSqlPart(String sqlPart,
Object... paramValue) |
Centralization in order to populate the prepare statement parameters.
|
JdbcSqlQuery |
JdbcSqlQuery.addUpdateParam(String paramName,
Object paramValue) |
Centralization in order to populate the prepare statement parameters for update.
|
JdbcSqlQuery |
JdbcSqlQuery.and(String sqlPart,
Object... paramValue) |
Centralization in order to populate the prepare statement parameters.
|
JdbcSqlQuery |
JdbcSqlQuery.and(String sqlPart,
Collection<?> paramValues) |
Centralization in order to populate the prepare statement parameters.
|
JdbcSqlQuery |
JdbcSqlQuery.andNotNull(String parameter) |
The specified parameter, in a conjunction filter, must not be null when requesting the
data source.
|
JdbcSqlQuery |
JdbcSqlQuery.andNull(String parameter) |
The specified parameter, in a conjunction filter, must be null when requesting the
data source.
|
JdbcSqlQuery |
JdbcSqlQuery.configure(Consumer<JdbcSqlQuery.Configuration> config) |
Calling this method to configure some parameters around execution, result, etc.
|
static JdbcSqlQuery |
JdbcSqlQuery.create(String sqlPart,
Object... paramValue) |
Creates a new instance of the JDBC SQL query initialized with the given sql part.
|
static JdbcSqlQuery |
JdbcSqlQuery.create(String sqlPart,
Collection<?> paramValue) |
Creates a new instance of the JDBC SQL query initialized with the given sql part.
|
static JdbcSqlQuery |
JdbcSqlQuery.createCountFor(String tableName) |
Creates a new instance of the SQL query to count the items that are in the specified table.
|
static JdbcSqlQuery |
JdbcSqlQuery.createDeleteFor(String tableName) |
Creates a new instance of the SQL query to delete some items in the specified table.
|
static JdbcSqlQuery |
JdbcSqlQuery.createDropFor(String tableName) |
Creates a new instance of the SQL query to drop the specified table.
|
static JdbcSqlQuery |
JdbcSqlQuery.createInsertFor(String tableName) |
Creates a new instance of the SQL query to insert one or more items in the specified table.
|
static JdbcSqlQuery |
JdbcSqlQuery.createSelect(String sqlPart,
Object... paramValue) |
Creates a new instance of the JDBC SQL query to select some fields of the items to find
according to the specified SQL part.
|
static JdbcSqlQuery |
JdbcSqlQuery.createSelect(String sqlPart,
Collection<?> paramValue) |
Creates a new instance of the JDBC SQL query to select some fields of the items to find
according to the specified SQL part.
|
static JdbcSqlQuery |
JdbcSqlQuery.createTable(String tableName) |
Creates a new instance of the SQL query to create the specified table.
|
static JdbcSqlQuery |
JdbcSqlQuery.createUpdateFor(String tableName) |
Creates a new instance of the SQL query to update some items in the specified table.
|
JdbcSqlQuery |
JdbcSqlQuery.from(String... tableNames) |
The query is about the concerned SQL table.
|
JdbcSqlQuery |
JdbcSqlQuery.groupBy(String sqlPart) |
Group the result of the query by the specified columns.
|
JdbcSqlQuery |
JdbcSqlQuery.in(Object... parameters) |
Centralization in order to build easily a SQL in clause.
|
JdbcSqlQuery |
JdbcSqlQuery.in(Collection<?> parameters) |
Centralization in order to build easily a SQL in clause.
|
JdbcSqlQuery |
JdbcSqlQuery.join(String sqlPart) |
Centralization in order to populate the prepare statement parameters.
|
JdbcSqlQuery |
JdbcSqlQuery.limit(int count) |
Limits the count of result returned by the query.
|
JdbcSqlQuery |
JdbcSqlQuery.notIn(Object... parameters) |
Centralization in order to build easily a SQL in clause.
|
JdbcSqlQuery |
JdbcSqlQuery.notIn(Collection<?> parameters) |
Centralization in order to build easily a SQL in clause.
|
JdbcSqlQuery |
JdbcSqlQuery.offset(int offset) |
Sets the offset from which each result should be processed by the row processor.
|
JdbcSqlQuery |
JdbcSqlQuery.on(String sqlPart,
Object... paramValue) |
Centralization in order to populate the prepare statement parameters.
|
JdbcSqlQuery |
JdbcSqlQuery.or(String sqlPart,
Object... paramValue) |
Centralization in order to populate the prepare statement parameters.
|
JdbcSqlQuery |
JdbcSqlQuery.or(String sqlPart,
Collection<?> paramValues) |
Centralization in order to populate the prepare statement parameters.
|
JdbcSqlQuery |
JdbcSqlQuery.orderBy(String sqlPart) |
Orders the result of the query by the specified statement.
|
JdbcSqlQuery |
JdbcSqlQuery.orNotNull(String parameter) |
The specified parameter, in a disjunction filter, must not be null when requesting the
data source.
|
JdbcSqlQuery |
JdbcSqlQuery.orNull(String parameter) |
The specified parameter, in a conjunction filter, must null when requesting the
data source.
|
JdbcSqlQuery |
JdbcSqlQuery.outerJoin(String sqlPart) |
Centralization in order to populate the prepare statement parameters.
|
JdbcSqlQuery |
JdbcSqlQuery.union() |
Centralization in order to populate the prepare statement parameters.
|
JdbcSqlQuery |
JdbcSqlQuery.where(String sqlPart,
Object... paramValue) |
Centralization in order to populate the prepare statement parameters.
|
JdbcSqlQuery |
JdbcSqlQuery.where(String sqlPart,
Collection<?> paramValues) |
Centralization in order to populate the prepare statement parameters.
|
JdbcSqlQuery |
JdbcSqlQuery.withPagination(PaginationCriterion pagination) |
Configures the query execution in order to retrieve only items of pagination.
Be careful to execute a SQL query containing an ORDER BY clause!!!
|