io.jboot.db.model

类 SqlBuilder

java.lang.Object

io.jboot.db.model.SqlBuilder

public class SqlBuilder
extends Object

版本:

V1.0

作者:

Michael Yang 杨福海 （fuhai999@gmail.com）

字段概要

字段

限定符和类型	字段和说明
private static String	AND
private static String	OR
private static Pattern	ORDER_BY_PATTERN
private static String	SQL_ORDER_BY_PATTERN 仅支持字母、数字、下划线、空格、逗号、小数点（支持多个字段排序）

构造器概要

构造器

构造器和说明
SqlBuilder()

方法概要

限定符和类型	方法和说明
static void	appendBetweenLogic(StringBuilder sqlBuilder, Column column, char separator)
private static void	appendColumnName(StringBuilder sqlBuilder, Column column, char separator)
static void	appendGroupLogic(StringBuilder sqlBuilder, Column before, Group group, char separator)
static void	appendInLogic(StringBuilder sqlBuilder, Column column, char separator)
private static void	appendLinkString(StringBuilder sqlBuilder, Column before)
private static void	appendSqlPartLogic(StringBuilder sqlBuilder, Column before, SqlPart sqlPart, char separator)
static void	appendTextWithSeparator(StringBuilder sqlBuilder, String text, char separator)
static void	buildAlias(StringBuilder sqlBuilder, String alias)
private static void	buildByColumns(StringBuilder sqlBuilder, List<Column> columns, char separator)
static void	buildJoinSql(StringBuilder sqlBuilder, List<Join> joins, char separator)
static void	buildMysqlWhereSql(StringBuilder sqlBuilder, List<Column> columns)
static void	buildWhereSql(StringBuilder sqlBuilder, List<Column> columns, char separator)
static void	buildWhereSql(StringBuilder sqlBuilder, List<Column> columns, char separator, boolean appendWhereKeyword)
static String	escapeOrderBySql(String orignalOrderBy)
static String	forDeleteByColumns(String alias, List<Join> joins, String table, List<Column> columns, char separator)
static StringBuilder	forFindByColumns(String alias, List<Join> joins, String table, String loadColumns, List<Column> columns, String orderBy, char separator)
static String	forFindCountByColumns(String alias, List<Join> joins, String table, String loadColumns, List<Column> columns, char separator)
static String	forPaginateDistinctTotalRow(String select, String sqlExceptSelect, Object ext)
static String	forPaginateFrom(String alias, List<Join> joins, String table, List<Column> columns, String orderBy, char separator)
private static boolean	isAllGroupByColumns(List<Column> columns)
private static boolean	isValidOrderBySql(String value)
private static String	replaceOrderBy(String sql)

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

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

字段详细资料

OR

private static final String OR

另请参阅:

常量字段值

AND

private static final String AND

另请参阅:

常量字段值

ORDER_BY_PATTERN

private static final Pattern ORDER_BY_PATTERN

SQL_ORDER_BY_PATTERN

private static String SQL_ORDER_BY_PATTERN

仅支持字母、数字、下划线、空格、逗号、小数点（支持多个字段排序）

构造器详细资料

SqlBuilder

public SqlBuilder()

方法详细资料

buildMysqlWhereSql

public static void buildMysqlWhereSql(StringBuilder sqlBuilder,
                                      List<Column> columns)

forDeleteByColumns

public static String forDeleteByColumns(String alias,
                                        List<Join> joins,
                                        String table,
                                        List<Column> columns,
                                        char separator)

buildWhereSql

public static void buildWhereSql(StringBuilder sqlBuilder,
                                 List<Column> columns,
                                 char separator)

buildWhereSql

public static void buildWhereSql(StringBuilder sqlBuilder,
                                 List<Column> columns,
                                 char separator,
                                 boolean appendWhereKeyword)

isAllGroupByColumns

private static boolean isAllGroupByColumns(List<Column> columns)

buildByColumns

private static void buildByColumns(StringBuilder sqlBuilder,
                                   List<Column> columns,
                                   char separator)

appendSqlPartLogic

private static void appendSqlPartLogic(StringBuilder sqlBuilder,
                                       Column before,
                                       SqlPart sqlPart,
                                       char separator)

appendColumnName

private static void appendColumnName(StringBuilder sqlBuilder,
                                     Column column,
                                     char separator)

appendLinkString

private static void appendLinkString(StringBuilder sqlBuilder,
                                     Column before)

appendGroupLogic

public static void appendGroupLogic(StringBuilder sqlBuilder,
                                    Column before,
                                    Group group,
                                    char separator)

appendInLogic

public static void appendInLogic(StringBuilder sqlBuilder,
                                 Column column,
                                 char separator)

appendBetweenLogic

public static void appendBetweenLogic(StringBuilder sqlBuilder,
                                      Column column,
                                      char separator)

appendTextWithSeparator

public static void appendTextWithSeparator(StringBuilder sqlBuilder,
                                           String text,
                                           char separator)

forFindByColumns

public static StringBuilder forFindByColumns(String alias,
                                             List<Join> joins,
                                             String table,
                                             String loadColumns,
                                             List<Column> columns,
                                             String orderBy,
                                             char separator)

replaceOrderBy

private static String replaceOrderBy(String sql)

forPaginateDistinctTotalRow

public static String forPaginateDistinctTotalRow(String select,
                                                 String sqlExceptSelect,
                                                 Object ext)

forPaginateFrom

public static String forPaginateFrom(String alias,
                                     List<Join> joins,
                                     String table,
                                     List<Column> columns,
                                     String orderBy,
                                     char separator)

buildJoinSql

public static void buildJoinSql(StringBuilder sqlBuilder,
                                List<Join> joins,
                                char separator)

buildAlias

public static void buildAlias(StringBuilder sqlBuilder,
                              String alias)

forFindCountByColumns

public static String forFindCountByColumns(String alias,
                                           List<Join> joins,
                                           String table,
                                           String loadColumns,
                                           List<Column> columns,
                                           char separator)

escapeOrderBySql

public static String escapeOrderBySql(String orignalOrderBy)

isValidOrderBySql

private static boolean isValidOrderBySql(String value)