Package lu.kbra.pclib.db.query

Class QueryBuilder<V extends DatabaseEntry,S extends QueryBuilder<V,S>>

java.lang.Object

lu.kbra.pclib.db.query.QueryBuilder<V,S>

Direct Known Subclasses:

SelectQueryBuilder

public abstract class QueryBuilder<V extends DatabaseEntry,S extends QueryBuilder<V,S>>
extends Object

Field Summary

Fields

Modifier and Type	Field	Description
protected ConditionBuilder.Node	conditionRoot
static int	DEFAULT_ENTRY_LIMIT
static final String	DEFAULT_ENTRY_LIMIT_PROPERTY
protected int	limit
protected final List<String>	paramColumns
protected final List<Object>	params

Constructor Summary

Constructors

Constructor	Description
QueryBuilder()

Method Summary

Modifier and Type	Method	Description
protected abstract <B extends SQLQueryable<T>, T extends DatabaseEntry> String	getPreparedQuerySQL(B table)
S	limit(int limit)
static <V extends DatabaseEntry> SelectQueryBuilder<V>	select()
protected void	updateQuerySQL(PreparedStatement stmt, SQLQueryable<V> table)
S	where(Consumer<ConditionBuilder> builderFn)

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Details

DEFAULT_ENTRY_LIMIT_PROPERTY

public static final String DEFAULT_ENTRY_LIMIT_PROPERTY

DEFAULT_ENTRY_LIMIT

public static int DEFAULT_ENTRY_LIMIT

conditionRoot

protected ConditionBuilder.Node conditionRoot

params

protected final List<Object> params

paramColumns

protected final List<String> paramColumns

limit

protected int limit

Constructor Details

QueryBuilder

public QueryBuilder()

Method Details

select

public static <V extends DatabaseEntry>
SelectQueryBuilder<V> select()

limit

public S limit(int limit)

where

public S where(Consumer<ConditionBuilder> builderFn)

getPreparedQuerySQL

protected abstract <B extends SQLQueryable<T>,
T extends DatabaseEntry>
String getPreparedQuerySQL(B table)

updateQuerySQL

protected void updateQuerySQL(PreparedStatement stmt,
 SQLQueryable<V> table)
                       throws SQLException

Throws:

SQLException