com.gitee.oeoe.tisimple.page.mysql

Class MysqlPageFactory

java.lang.Object

com.gitee.oeoe.tisimple.page.mysql.MysqlPageFactory

All Implemented Interfaces:

IPageFactory, IPageParam

public class MysqlPageFactory
extends Object
implements IPageFactory

mysql 数据库分页工厂

Since:

1.8+ 2022/1/12

Author:

zhu qiang

Field Summary

Fields

Modifier and Type	Field and Description
static String	pageIndexVarName
static String	pageSizeVarName

Constructor Summary

Constructors

Constructor and Description
MysqlPageFactory()

Method Summary

Modifier and Type	Method and Description
<T> IPage<T>	assemble(List<T> data, Long maxRows, int pageSize, int pageIndex) 组装成一个分页对象
ISQL	countSql(ISQL template) 获取统计此分页条件西安的总记录数量的sql
String	countSqlSelectName() countSql 中返回的记录数量列名，比如select count(*)as max_row from user;中的 max_row
int	getDefaultPageSize() 获取默认分页大小
int	getPageIndex(ISQL template) 从参数空间中获取当前分页编号参数
int	getPageSize(ISQL template) 从参数空间中获取分页大小参数
Integer	pageIndex() 获取当前分页编号，分页从1开始
void	pageIndex(Integer page) 设置当前页编号
Integer	pageSize() 获取分页大小
void	pageSize(Integer size) 设置分页大小
ISQL	pageSql(ISQL template) 获取分页sql
void	setDefaultPageSize(int size) 设置默认分页大小

Methods inherited from class java.lang.Object

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

Field Detail

pageSizeVarName

public static final String pageSizeVarName

See Also:

Constant Field Values

pageIndexVarName

public static final String pageIndexVarName

See Also:

Constant Field Values

Constructor Detail

MysqlPageFactory

public MysqlPageFactory()

Method Detail

countSql

public ISQL countSql(ISQL template)

Description copied from interface: IPageFactory

获取统计此分页条件西安的总记录数量的sql

Specified by:

countSql in interface IPageFactory

Parameters:

template - 模版sql对象

Returns:

模版sql对象

countSqlSelectName

public String countSqlSelectName()

Description copied from interface: IPageFactory

countSql 中返回的记录数量列名，比如select count(*)as max_row from user;中的 max_row

Specified by:

countSqlSelectName in interface IPageFactory

Returns:

列名

pageSql

public ISQL pageSql(ISQL template)

Description copied from interface: IPageFactory

获取分页sql

Specified by:

pageSql in interface IPageFactory

Parameters:

template - 模版sql对象

Returns:

模版sql对象

assemble

public <T> IPage<T> assemble(List<T> data,
                             Long maxRows,
                             int pageSize,
                             int pageIndex)

Description copied from interface: IPageFactory

组装成一个分页对象

Specified by:

assemble in interface IPageFactory

Type Parameters:

T - 分页对象类型

Parameters:

data - 分页结果

maxRows - 此分页条件下的总记录数量

pageSize - 页大小

pageIndex - 当前页

Returns:

一个分页对象

getPageSize

public int getPageSize(ISQL template)

Description copied from interface: IPageFactory

从参数空间中获取分页大小参数

Specified by:

getPageSize in interface IPageFactory

Parameters:

template - 模版SQL

Returns:

分页大小

getPageIndex

public int getPageIndex(ISQL template)

Description copied from interface: IPageFactory

从参数空间中获取当前分页编号参数

Specified by:

getPageIndex in interface IPageFactory

Parameters:

template - 模版SQL

Returns:

当前页索引

setDefaultPageSize

public void setDefaultPageSize(int size)

Description copied from interface: IPageFactory

设置默认分页大小

Specified by:

setDefaultPageSize in interface IPageFactory

Parameters:

size - 默认的分页大小

getDefaultPageSize

public int getDefaultPageSize()

Description copied from interface: IPageFactory

获取默认分页大小

Specified by:

getDefaultPageSize in interface IPageFactory

Returns:

默认分页大小

pageSize

public Integer pageSize()

Description copied from interface: IPageParam

获取分页大小

Specified by:

pageSize in interface IPageParam

Returns:

分页大小

pageIndex

public Integer pageIndex()

Description copied from interface: IPageParam

获取当前分页编号，分页从1开始

Specified by:

pageIndex in interface IPageParam

Returns:

分页编号

pageSize

public void pageSize(Integer size)

Description copied from interface: IPageParam

设置分页大小

Specified by:

pageSize in interface IPageParam

Parameters:

size - 分页大小

pageIndex

public void pageIndex(Integer page)

Description copied from interface: IPageParam

设置当前页编号

Specified by:

pageIndex in interface IPageParam

Parameters:

page - 当前页