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

A

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

获取 ROW_NUMBER() 列

C

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

复制 OrderByElement

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

复制 OrderByElement

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

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

convert to order by sql

convertToPageSql(String) - Method in class com.github.pagehelper.parser.SqlServerJSqlParser47

转换为分页语句

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

转换为分页语句

CountJSqlParser47 - Class in com.github.pagehelper.parser

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

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

E

extraOrderBy(Select) - Static method in class com.github.pagehelper.parser.OrderByJSqlParser47

extra order by and set default orderby to null

F

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

G

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

获取新的排序列表

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

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

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

获取查询列

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

获取普通的Count-sql

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

获取普通的Count-sql

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

获取智能的countSql

I

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

List不空

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

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

K

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

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

保留 order by

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

保留子查询 order by

O

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

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

OrderByJSqlParser47 - Class in com.github.pagehelper.parser

处理 Order by

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

P

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

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

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

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

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

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

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

处理子查询

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

处理子查询

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

处理PlainSelect类型的selectBody

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

处理PlainSelect类型的selectBody

processSelect(Select) - Method in class com.github.pagehelper.parser.CountJSqlParser47

处理selectBody去除Order by

processSelectBody(Select, int) - Method in class com.github.pagehelper.parser.SqlServerJSqlParser47

处理selectBody去除Order by

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

处理WithItem

S

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

SqlServerJSqlParser47 - Class in com.github.pagehelper.parser

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

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

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

将sql转换为count查询

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

T

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

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

W

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

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

包装SetOperationList

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