Package org.ametys.plugins.core.impl.user.directory

Class JdbcUserDirectory.SelectUsersJdbcQueryExecutor<T>

java.lang.Object

org.ametys.plugins.core.impl.user.directory.JdbcUserDirectory.AbstractJdbcQueryExecutor<T>

org.ametys.plugins.core.impl.user.directory.JdbcUserDirectory.SelectUsersJdbcQueryExecutor<T>

Type Parameters:

T - The type of the queried object

Enclosing class:

JdbcUserDirectory

protected class JdbcUserDirectory.SelectUsersJdbcQueryExecutor<T>
extends JdbcUserDirectory.AbstractJdbcQueryExecutor<T>

Query executor in order to select users

Field Summary

Fields

Modifier and Type	Field	Description
protected int	_length	The maximum number of users to select
protected JdbcUserDirectory.JdbcPredicate	_mandatoryPredicate	The mandatory predicate to use when querying users by pattern
protected int	_offset	The offset to start with, first is 0
protected String	_pattern	The pattern to match (none if null)
protected String	_patternToMatch	The pattern to match, extracted from the pattern

Constructor Summary

Constructors

Modifier	Constructor	Description
protected	SelectUsersJdbcQueryExecutor(String pattern, int length, int offset)	The constructor

Method Summary

Modifier and Type	Method	Description
private StringBuilder	_addQuerySize(int length, int offset, Connection con, StringBuilder selectClause, StringBuilder sql)
protected String	getSqlQuery(Connection connection)	Must return the SQL query to execute
protected PreparedStatement	prepareStatement(Connection connection, String sql)	Prepare the statement to execute

Methods inherited from class org.ametys.plugins.core.impl.user.directory.JdbcUserDirectory.AbstractJdbcQueryExecutor

executeQuery, processResultSet, run, runWithException

Methods inherited from class java.lang.Object

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

Field Detail

_pattern

protected String _pattern

The pattern to match (none if null)

_length

protected int _length

The maximum number of users to select

_offset

protected int _offset

The offset to start with, first is 0

_mandatoryPredicate

protected JdbcUserDirectory.JdbcPredicate _mandatoryPredicate

The mandatory predicate to use when querying users by pattern

_patternToMatch

protected String _patternToMatch

The pattern to match, extracted from the pattern

Constructor Detail

SelectUsersJdbcQueryExecutor

protected SelectUsersJdbcQueryExecutor(String pattern,
                                       int length,
                                       int offset)

The constructor

Parameters:

pattern - The pattern to match (none if null).

length - The maximum number of users to select.

offset - The offset to start with, first is 0.

Method Detail

getSqlQuery

protected String getSqlQuery(Connection connection)

Description copied from class: JdbcUserDirectory.AbstractJdbcQueryExecutor

Must return the SQL query to execute

Specified by:

getSqlQuery in class JdbcUserDirectory.AbstractJdbcQueryExecutor<T>

Parameters:

connection - The pool connection

Returns:

The SQL query

_addQuerySize

private StringBuilder _addQuerySize(int length,
                                    int offset,
                                    Connection con,
                                    StringBuilder selectClause,
                                    StringBuilder sql)

prepareStatement

protected PreparedStatement prepareStatement(Connection connection,
                                             String sql)
                                      throws SQLException

Description copied from class: JdbcUserDirectory.AbstractJdbcQueryExecutor

Prepare the statement to execute

Overrides:

prepareStatement in class JdbcUserDirectory.AbstractJdbcQueryExecutor<T>

Parameters:

connection - The pool connection

sql - The SQL query

Returns:

The prepared statement, ready to be executed

Throws:

SQLException - If an SQL Exception occurs