A C E F G I K O P S T W

A

addRowNumber(PlainSelect, List<SelectItem>) - Method in class com.github.pagehelper.parser.SqlServerJSqlParser45

获取 ROW_NUMBER() 列

C

cloneOrderByElement(OrderByElement, String) - Method in class com.github.pagehelper.parser.SqlServerJSqlParser45

复制 OrderByElement

cloneOrderByElement(OrderByElement, Expression) - Method in class com.github.pagehelper.parser.SqlServerJSqlParser45

复制 OrderByElement

com.github.pagehelper.parser - package com.github.pagehelper.parser

converToOrderBySql(String, String) - Method in class com.github.pagehelper.parser.OrderByJSqlParser45

convert to order by sql

convertToPageSql(String, Integer, Integer) - Method in class com.github.pagehelper.parser.SqlServerJSqlParser45

转换为分页语句

CountJSqlParser45 - Class in com.github.pagehelper.parser

sql解析类，提供更智能的count查询sql

CountJSqlParser45() - Constructor for class com.github.pagehelper.parser.CountJSqlParser45

E

extraOrderBy(SelectBody) - Method in class com.github.pagehelper.parser.OrderByJSqlParser45

extra order by and set default orderby to null

F

falseFunctions - Variable in class com.github.pagehelper.parser.CountJSqlParser45

G

getOrderByElements(PlainSelect, List<SelectItem>) - Method in class com.github.pagehelper.parser.SqlServerJSqlParser45

获取新的排序列表

getPageSelect(Select) - Method in class com.github.pagehelper.parser.SqlServerJSqlParser45

获取一个外层包装的TOP查询

getSelectItems(PlainSelect) - Method in class com.github.pagehelper.parser.SqlServerJSqlParser45

获取查询列

getSimpleCountSql(String) - Method in class com.github.pagehelper.parser.CountJSqlParser45

获取普通的Count-sql

getSimpleCountSql(String, String) - Method in class com.github.pagehelper.parser.CountJSqlParser45

获取普通的Count-sql

getSmartCountSql(String, String) - Method in class com.github.pagehelper.parser.CountJSqlParser45

获取智能的countSql

I

isNotEmptyList(List<?>) - Method in class com.github.pagehelper.parser.SqlServerJSqlParser45

List不空

isSimpleCount(PlainSelect) - Method in class com.github.pagehelper.parser.CountJSqlParser45

是否可以用简单的count查询方式

K

KEEP_ORDERBY - Static variable in class com.github.pagehelper.parser.CountJSqlParser45

keepOrderBy() - Method in class com.github.pagehelper.parser.CountJSqlParser45

保留 order by

keepSubSelectOrderBy() - Method in class com.github.pagehelper.parser.CountJSqlParser45

保留子查询 order by

O

orderByHashParameters(List<OrderByElement>) - Method in class com.github.pagehelper.parser.CountJSqlParser45

判断Orderby是否包含参数，有参数的不能去

OrderByJSqlParser45 - Class in com.github.pagehelper.parser

处理 Order by

OrderByJSqlParser45() - Constructor for class com.github.pagehelper.parser.OrderByJSqlParser45

P

PAGE_COLUMN_ALIAS_PREFIX - Static variable in class com.github.pagehelper.parser.SqlServerJSqlParser45

PAGE_ROW_NUMBER - Static variable in class com.github.pagehelper.parser.SqlServerJSqlParser45

PAGE_ROW_NUMBER_COLUMN - Static variable in class com.github.pagehelper.parser.SqlServerJSqlParser45

PAGE_SIZE - Static variable in class com.github.pagehelper.parser.SqlServerJSqlParser45

PAGE_TABLE_ALIAS - Static variable in class com.github.pagehelper.parser.SqlServerJSqlParser45

PAGE_TABLE_NAME - Static variable in class com.github.pagehelper.parser.SqlServerJSqlParser45

processFromItem(FromItem) - Method in class com.github.pagehelper.parser.CountJSqlParser45

处理子查询

processFromItem(FromItem, int) - Method in class com.github.pagehelper.parser.SqlServerJSqlParser45

处理子查询

processPlainSelect(PlainSelect) - Method in class com.github.pagehelper.parser.CountJSqlParser45

处理PlainSelect类型的selectBody

processPlainSelect(PlainSelect, int) - Method in class com.github.pagehelper.parser.SqlServerJSqlParser45

处理PlainSelect类型的selectBody

processSelectBody(SelectBody) - Method in class com.github.pagehelper.parser.CountJSqlParser45

处理selectBody去除Order by

processSelectBody(SelectBody, int) - Method in class com.github.pagehelper.parser.SqlServerJSqlParser45

处理selectBody去除Order by

processWithItemsList(List<WithItem>) - Method in class com.github.pagehelper.parser.CountJSqlParser45

处理WithItem

S

skipFunctions - Variable in class com.github.pagehelper.parser.CountJSqlParser45

SqlServerJSqlParser45 - Class in com.github.pagehelper.parser

将sqlserver查询语句转换为分页语句
注意事项：
请先保证你的SQL可以执行 sql中最好直接包含order by，可以自动从sql提取 如果没有order by，可以通过入参提供，但是需要自己保证正确 如果sql有order by，可以通过orderby参数覆盖sql中的order by order by的列名不能使用别名 表和列使用别名的时候不要使用单引号(') 该类设计为一个独立的工具类，依赖jsqlparser,可以独立使用

SqlServerJSqlParser45() - Constructor for class com.github.pagehelper.parser.SqlServerJSqlParser45

sqlToCount(Select, String) - Method in class com.github.pagehelper.parser.CountJSqlParser45

将sql转换为count查询

START_ROW - Static variable in class com.github.pagehelper.parser.SqlServerJSqlParser45

T

TABLE_ALIAS - Static variable in class com.github.pagehelper.parser.CountJSqlParser45

TOP100_PERCENT - Static variable in class com.github.pagehelper.parser.SqlServerJSqlParser45

W

WRAP_TABLE - Static variable in class com.github.pagehelper.parser.SqlServerJSqlParser45

wrapSetOperationList(SetOperationList) - Method in class com.github.pagehelper.parser.SqlServerJSqlParser45

包装SetOperationList

A C E F G I K O P S T W