程序包 com.alibaba.druid.sql

类 PagerUtils

java.lang.Object

com.alibaba.druid.sql.PagerUtils

public class PagerUtils
extends Object

构造器概要

构造器

构造器	说明
PagerUtils()

方法概要

修饰符和类型	方法	说明
static String	count(String sql, DbType dbType)
static int	getLimit(String sql, DbType dbType)	Retrieves the limit value from the provided SQL query string based on the specified database type.
static boolean	hasUnorderedLimit(String sql, DbType dbType)
static String	limit(SQLSelect select, DbType dbType, int offset, int count)
static boolean	limit(SQLSelect select, DbType dbType, int offset, int count, boolean check)
static String	limit(String sql, DbType dbType, int offset, int count)
static String	limit(String sql, DbType dbType, int offset, int count, boolean check)

从类继承的方法 java.lang.Object

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

构造器详细资料

PagerUtils

public PagerUtils()

方法详细资料

count

public static String count(String sql,
 DbType dbType)

limit

public static String limit(String sql,
 DbType dbType,
 int offset,
 int count)

limit

public static String limit(String sql,
 DbType dbType,
 int offset,
 int count,
 boolean check)

limit

public static String limit(SQLSelect select,
 DbType dbType,
 int offset,
 int count)

limit

public static boolean limit(SQLSelect select,
 DbType dbType,
 int offset,
 int count,
 boolean check)

getLimit

public static int getLimit(String sql,
 DbType dbType)

Retrieves the limit value from the provided SQL query string based on the specified database type.

参数:

sql - the SQL query string

dbType - the database type for parsing the SQL query

返回:

the limit value extracted from the SQL query, or -1 if the query does not have a valid limit clause

hasUnorderedLimit

public static boolean hasUnorderedLimit(String sql,
 DbType dbType)