cn.vonce.sql.constant.SqlHelperCons Maven / Gradle / Ivy

Go to download
Show more of this group Show more artifacts with this name
Show all versions of vonce-sqlbean-core Show documentation
This is the core project of Sqlbean.
There is a newer version: 1.7.0-beta1
package cn.vonce.sql.constant;

public class SqlHelperCons {

    // sql
    public static final String SELECT = "SELECT ";
    public static final String COUNT = "COUNT";
    public static final String SELECT_DISTINCT = "SELECT DISTINCT";
    public static final String FROM = " FROM ";
    public static final String WHERE = " WHERE ";
    public static final String GROUP_BY = " GROUP BY ";
    public static final String HAVING = " HAVING ";
    public static final String ORDER_BY = " ORDER BY ";
    public static final String LIMIT = " LIMIT ";
    public static final String BEGIN_BRACKET = "(";
    public static final String END_BRACKET = ")";
    public static final String AND_BRACKET = ") AND (";
    public static final String OR_BRACKET = ") OR (";
    public static final String AND = " AND ";
    public static final String OR = " OR ";
    public static final String UPDATE = "UPDATE ";
    public static final String SET = " SET ";
    public static final String VALUES = "VALUES";
    public static final String NULL_VALUE = "NULL";
    public static final String INSERT_INTO = "INSERT INTO ";
    public static final String DELETE_FROM = "DELETE FROM ";
    public static final String IS = " IS ";
    public static final String IS_NOT = " IS NOT ";
    public static final String IN = " IN (";
    public static final String NOT_IN = " NOT IN (";
    //    public static final String EXISTS = " EXISTS (";
//    public static final String NOT_EXISTS = " NOT EXISTS (";
    public static final String LIKE = " LIKE ";
    public static final String NOT_LIKE = " NOT LIKE ";
    public static final String PERCENT = "%";
    public static final String BETWEEN = " BETWEEN ";
    public static final String GREATER_THAN = " > ";
    public static final String GREAT_THAN_OR_EQUAL_TO = " >= ";
    public static final String LESS_THAN = " < ";
    public static final String LESS_THAN_OR_EQUAL_TO = " <= ";
    public static final String EQUAL_TO = " = ";
    public static final String NOT_EQUAL_TO = " <> ";
    public static final String SPACES = " ";
    public static final String COMMA = ", ";
    public static final String ALL = " * ";
    public static final String SINGLE_ESCAPE_CHARACTER = "`";
    public static final String POINT = ".";
    public static final String UNDERLINE = "_";
    //    public static final String WELL_NUMBER = "#";
    public static final String AS = " AS ";
    public static final String SINGLE_QUOTATION_MARK = "'";
    public static final String INNER_JOIN = " INNER JOIN ";
    public static final String LEFT_JOIN = " LEFT JOIN ";
    public static final String RIGHT_JOIN = " RIGHT JOIN ";
    public static final String FULL_JOIN = " FULL JOIN ";
    public static final String ON = " ON ";

    public static final String CREATE_TABLE = "CREATE TABLE ";
    public static final String PRIMARY_KEY = "PRIMARY KEY";
    public static final String NOT_NULL = "NOT NULL";
    public static final String DEFAULT = "DEFAULT ";

    // mssql
    public static final String TOP = " TOP ";
    public static final String ROW_NUMBER = " ROW_NUMBER() ";
    public static final String OVER = " OVER ";
    public static final String ID = "ID";
    public static final String ROWNUM = " ROWNUM ";
    public static final String T = " T";

    // oracle
    public static final String RN = "RN";
    public static final String TB = " TB ";
    public static final String DOUBLE_ESCAPE_CHARACTER = "\"";
    public static final String INSERT_ALL_INTO = "INSERT ALL INTO ";
    public static final String INTO = " INTO ";
    public static final String SELECT_DUAL = " SELECT 1 FROM DUAL ";

    public static final String OFFSET = " OFFSET ";
    public static final String ROWNUMBER = " ROWNUMBER() ";

    // sqlite
    public static final String INTEGER = "INTEGER";
    public static final String REAL = "REAL";
    public static final String TEXT = "TEXT";
    public static final String BLOB = "BLOB";

}