com.jn.sqlhelper.dialect.pagination

接口 PagedPreparedParameterSetter<P extends QueryParameters>

类型参数:

P - original parameters

所有已知实现类:

ArrayBasedParameterSetter

public interface PagedPreparedParameterSetter<P extends QueryParameters>

the prepared statement setter, just for the original parameters all parameters will slice 3 segments: |-----------------original parameters-----------------| |------before-----|-----subquery-----|------after-----|

另请参阅:

SQLStatementInstrumentor.bindParameters(Dialect, PreparedStatement, PagedPreparedParameterSetter, QueryParameters, boolean)

方法概要

限定符和类型	方法和说明
int	setAfterSubqueryParameters(PreparedStatement statement, P queryParameters, int startIndex) set original parameters, what is after subquery partition
int	setBeforeSubqueryParameters(PreparedStatement statement, P queryParameters, int startIndex) set original parameters, what is before subquery partition
int	setOriginalParameters(PreparedStatement statement, P queryParameters, int startIndex) set original parameters, it is not contains limit, offset parameters
int	setSubqueryParameters(PreparedStatement statement, P queryParameters, int startIndex) set subquery parameters, it is not contains limit, offset parameters

方法详细资料

setBeforeSubqueryParameters

int setBeforeSubqueryParameters(PreparedStatement statement,
                                P queryParameters,
                                int startIndex)
                         throws SQLException

set original parameters, what is before subquery partition

参数:

statement - the sql statement

queryParameters - all the original parameters

startIndex - the start index

返回:

the count of set in the invocation

抛出:

SQLException - throw it if error

setSubqueryParameters

int setSubqueryParameters(PreparedStatement statement,
                          P queryParameters,
                          int startIndex)
                   throws SQLException

set subquery parameters, it is not contains limit, offset parameters

参数:

statement - the sql statement

queryParameters - all the original parameters

startIndex - the start index

返回:

the count of set in the invocation

抛出:

SQLException - throw it if error

setAfterSubqueryParameters

int setAfterSubqueryParameters(PreparedStatement statement,
                               P queryParameters,
                               int startIndex)
                        throws SQLException

set original parameters, what is after subquery partition

参数:

statement - the sql statement

queryParameters - all the original parameters

startIndex - the start index

返回:

the count of set in the invocation

抛出:

SQLException - throw it if error+

setOriginalParameters

int setOriginalParameters(PreparedStatement statement,
                          P queryParameters,
                          int startIndex)
                   throws SQLException

set original parameters, it is not contains limit, offset parameters

参数:

statement - the sql statement

queryParameters - all the original parameters

startIndex - the start index

返回:

the count of set in the invocation

抛出:

SQLException - throw it if error