cn.sucang.core.util

Class SQLUtils

java.lang.Object

cn.sucang.core.util.SQLUtils

public class SQLUtils
extends java.lang.Object

Field Summary

Fields

Modifier and Type	Field and Description
static boolean	isDebug

Constructor Summary

Constructors

Constructor and Description
SQLUtils(java.lang.String sql)
SQLUtils(java.lang.String fields, java.lang.String tables, java.lang.String wheres)

Method Summary

Modifier and Type	Method and Description
java.lang.String	getCountsSql(java.lang.String keyField) 获取指定select的查询记录总数的Sql
java.lang.String	getFields()
java.lang.String	getGroupby()
java.lang.String	getLimitSql(int num, java.lang.Integer dbType) 获取指定select的查询查询行数限制sql
java.lang.String	getOrderby()
java.lang.String	getPageSql(int pageNum, int pageSize, java.lang.String keyField)
java.lang.String	getPageSql(int pageNum, int pageSize, java.lang.String keyField, java.lang.Integer dbType)
static java.lang.String	getPageSql(java.lang.String sql, int pageNum, int pageSize, java.lang.String keyField) 封装带分页查询的SQL
static java.lang.String	getPageSql(java.lang.String sql, int pageNum, int pageSize, java.lang.String keyField, java.lang.Integer dbType)
static java.lang.String	getPermissionSql(java.lang.String sql, java.lang.String keyField, java.lang.String resId) 返回根据resId封装后的带权限查询的SQL语句
java.lang.String	getTables()
java.lang.String	getWheres()
static java.lang.String	parseSubSql(java.lang.String selectSql, java.util.Map<java.lang.String,java.lang.String> subSqlMap) 解析查询页，将其中的子查询转换为占用符，方便处理或格式化
void	setFields(java.lang.String fields)
void	setGroupby(java.lang.String groupby)
void	setOrderby(java.lang.String orderby)
void	setWheres(java.lang.String wheres)
static java.lang.String[]	spitOrderBy(java.lang.String sqlWhere) 将SQL条件语句中的Orderby分离出来
java.lang.String	toString()

Methods inherited from class java.lang.Object

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

Field Detail

isDebug

public static boolean isDebug

Constructor Detail

SQLUtils

public SQLUtils(java.lang.String sql)

SQLUtils

public SQLUtils(java.lang.String fields,
                java.lang.String tables,
                java.lang.String wheres)

Method Detail

toString

public java.lang.String toString()

Overrides:

toString in class java.lang.Object

parseSubSql

public static java.lang.String parseSubSql(java.lang.String selectSql,
                                           java.util.Map<java.lang.String,java.lang.String> subSqlMap)

解析查询页，将其中的子查询转换为占用符，方便处理或格式化

Parameters:

selectSql -

subSqlMap -

Returns:

getPageSql

public static java.lang.String getPageSql(java.lang.String sql,
                                          int pageNum,
                                          int pageSize,
                                          java.lang.String keyField)

封装带分页查询的SQL

Parameters:

sql - as String

pageNum - as int

pageSize - as int

keyField - as String //分页时需要用到关字，如果有别名时用，如果为空时默认为id

Returns:

String

getPageSql

public static java.lang.String getPageSql(java.lang.String sql,
                                          int pageNum,
                                          int pageSize,
                                          java.lang.String keyField,
                                          java.lang.Integer dbType)

getLimitSql

public java.lang.String getLimitSql(int num,
                                    java.lang.Integer dbType)

获取指定select的查询查询行数限制sql

Parameters:

num - as int 限制的行号，必须大于0

dbType - as Integer 如果为null表示默认当前系统所用的数据库类型

Returns:

String

getCountsSql

public java.lang.String getCountsSql(java.lang.String keyField)

获取指定select的查询记录总数的Sql

Parameters:

keyField -

Returns:

getPageSql

public java.lang.String getPageSql(int pageNum,
                                   int pageSize,
                                   java.lang.String keyField)

getPageSql

public java.lang.String getPageSql(int pageNum,
                                   int pageSize,
                                   java.lang.String keyField,
                                   java.lang.Integer dbType)

getPermissionSql

public static java.lang.String getPermissionSql(java.lang.String sql,
                                                java.lang.String keyField,
                                                java.lang.String resId)

返回根据resId封装后的带权限查询的SQL语句

Parameters:

sql - as String

keyField - as String //关键字ID

resId - as String 资源ID

Returns:

String

getOrderby

public java.lang.String getOrderby()

setOrderby

public void setOrderby(java.lang.String orderby)

getFields

public java.lang.String getFields()

setFields

public void setFields(java.lang.String fields)

getTables

public java.lang.String getTables()

setWheres

public void setWheres(java.lang.String wheres)

getWheres

public java.lang.String getWheres()

setGroupby

public void setGroupby(java.lang.String groupby)

getGroupby

public java.lang.String getGroupby()

spitOrderBy

public static java.lang.String[] spitOrderBy(java.lang.String sqlWhere)

将SQL条件语句中的Orderby分离出来

Parameters:

sqlWhere -

Returns: