public class SQLUtils extends Object
构造器和说明 |
---|
SQLUtils() |
public static SQLSelectOrderByItem toOrderByItem(String sql, String dbType)
public static SQLUpdateSetItem toUpdateSetItem(String sql, String dbType)
public static SQLSelectItem toSelectItem(String sql, String dbType)
public static List<SQLStatement> toStatementList(String sql, String dbType)
public static String toSQLString(List<SQLStatement> statementList, String dbType)
public static String toSQLString(List<SQLStatement> statementList, String dbType, List<Object> parameters)
public static SQLASTOutputVisitor createFormatOutputVisitor(Appendable out, List<SQLStatement> statementList, String dbType)
public static SchemaStatVisitor createSchemaStatVisitor(List<SQLStatement> statementList, String dbType)
public static List<SQLStatement> parseStatements(String sql, String dbType)
public static String buildToDate(String columnName, String tableAlias, String pattern, String dbType)
columnName
- tableAlias
- pattern
- if pattern is null,it will be set {%Y-%m-%d %H:%i:%s} as mysql default value and set {yyyy-mm-dd
hh24:mi:ss} as oracle default valuedbType
- JdbcConstants
if dbType is null ,it will be set the mysql as a default valuepublic static List<SQLExpr> split(SQLBinaryOpExpr x)
public static String addCondition(String sql, String condition, SQLBinaryOperator op, boolean left, String dbType)
public static void addCondition(SQLStatement stmt, SQLBinaryOperator op, SQLExpr condition, boolean left)
public static SQLExpr buildCondition(SQLBinaryOperator op, SQLExpr condition, boolean left, SQLExpr where)
public static String addSelectItem(String selectSql, String expr, String alias, String dbType)
public static String addSelectItem(String selectSql, String expr, String alias, boolean first, String dbType)
public static void addSelectItem(SQLStatement stmt, SQLExpr expr, String alias, boolean first)
public static void addSelectItem(SQLSelectQueryBlock queryBlock, SQLExpr expr, String alias, boolean first)
Copyright © 2013-2015 Alibaba Group. All Rights Reserved.