com.github.pagehelper.parser.defaults

Class DefaultCountSqlParser

java.lang.Object

com.github.pagehelper.parser.defaults.DefaultCountSqlParser

All Implemented Interfaces:

CountSqlParser

public class DefaultCountSqlParser
extends Object
implements CountSqlParser

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

Author:

liuzh

Field Summary

Fields

Modifier and Type	Field and Description
protected Set<String>	falseFunctions
static String	KEEP_ORDERBY
protected Set<String>	skipFunctions
protected static net.sf.jsqlparser.expression.Alias	TABLE_ALIAS

Fields inherited from interface com.github.pagehelper.parser.CountSqlParser

AGGREGATE_FUNCTIONS

Constructor Summary

Constructors

Constructor and Description
DefaultCountSqlParser()

Method Summary

Modifier and Type	Method and Description
String	getSimpleCountSql(String sql) 获取普通的Count-sql
String	getSimpleCountSql(String sql, String name) 获取普通的Count-sql
String	getSmartCountSql(String sql, String countColumn) 获取智能的countSql
boolean	isSimpleCount(net.sf.jsqlparser.statement.select.PlainSelect select) 是否可以用简单的count查询方式
protected boolean	keepOrderBy() 保留 order by
protected boolean	keepSubSelectOrderBy() 保留子查询 order by
boolean	orderByHashParameters(List<net.sf.jsqlparser.statement.select.OrderByElement> orderByElements) 判断Orderby是否包含参数，有参数的不能去
void	processFromItem(net.sf.jsqlparser.statement.select.FromItem fromItem) 处理子查询
void	processPlainSelect(net.sf.jsqlparser.statement.select.PlainSelect plainSelect) 处理PlainSelect类型的selectBody
void	processSelect(net.sf.jsqlparser.statement.select.Select select) 处理selectBody去除Order by
void	processWithItemsList(List<net.sf.jsqlparser.statement.select.WithItem> withItemsList) 处理WithItem
net.sf.jsqlparser.statement.select.Select	sqlToCount(net.sf.jsqlparser.statement.select.Select select, String name) 将sql转换为count查询

Methods inherited from class java.lang.Object

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

Methods inherited from interface com.github.pagehelper.parser.CountSqlParser

addAggregateFunctions, getSmartCountSql

Field Detail

KEEP_ORDERBY

public static final String KEEP_ORDERBY

See Also:

Constant Field Values

TABLE_ALIAS

protected static final net.sf.jsqlparser.expression.Alias TABLE_ALIAS

skipFunctions

protected final Set<String> skipFunctions

falseFunctions

protected final Set<String> falseFunctions

Constructor Detail

DefaultCountSqlParser

public DefaultCountSqlParser()

Method Detail

getSmartCountSql

public String getSmartCountSql(String sql,
                               String countColumn)

获取智能的countSql

Specified by:

getSmartCountSql in interface CountSqlParser

Parameters:

sql -

countColumn - 列名，默认 0

Returns:

getSimpleCountSql

public String getSimpleCountSql(String sql)

获取普通的Count-sql

Parameters:

sql - 原查询sql

Returns:

返回count查询sql

getSimpleCountSql

public String getSimpleCountSql(String sql,
                                String name)

获取普通的Count-sql

Parameters:

sql - 原查询sql

Returns:

返回count查询sql

sqlToCount

public net.sf.jsqlparser.statement.select.Select sqlToCount(net.sf.jsqlparser.statement.select.Select select,
                                                            String name)

将sql转换为count查询

Parameters:

select -

isSimpleCount

public boolean isSimpleCount(net.sf.jsqlparser.statement.select.PlainSelect select)

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

Parameters:

select -

Returns:

processSelect

public void processSelect(net.sf.jsqlparser.statement.select.Select select)

处理selectBody去除Order by

Parameters:

select -

processPlainSelect

public void processPlainSelect(net.sf.jsqlparser.statement.select.PlainSelect plainSelect)

处理PlainSelect类型的selectBody

Parameters:

plainSelect -

processWithItemsList

public void processWithItemsList(List<net.sf.jsqlparser.statement.select.WithItem> withItemsList)

处理WithItem

Parameters:

withItemsList -

processFromItem

public void processFromItem(net.sf.jsqlparser.statement.select.FromItem fromItem)

处理子查询

Parameters:

fromItem -

keepOrderBy

protected boolean keepOrderBy()

保留 order by

keepSubSelectOrderBy

protected boolean keepSubSelectOrderBy()

保留子查询 order by

orderByHashParameters

public boolean orderByHashParameters(List<net.sf.jsqlparser.statement.select.OrderByElement> orderByElements)

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

Parameters:

orderByElements -

Returns: