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 selectprotected JdbcUserDirectory.JdbcPredicate
_mandatoryPredicate
The mandatory predicate to use when querying users by patternprotected int
_offset
The offset to start with, first is 0protected 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
All Methods Instance Methods Concrete Methods 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 executeprotected 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
-
-
-
-
Field Detail
-
_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 classJdbcUserDirectory.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 classJdbcUserDirectory.AbstractJdbcQueryExecutor<T>
- Parameters:
connection
- The pool connectionsql
- The SQL query- Returns:
- The prepared statement, ready to be executed
- Throws:
SQLException
- If an SQL Exception occurs
-
-