com.github.drinkjava2.jdbpro
Enum SqlOption

java.lang.Object
  java.lang.Enum<SqlOption>
      com.github.drinkjava2.jdbpro.SqlOption

All Implemented Interfaces:

Serializable, Comparable<SqlOption>

public enum SqlOption
extends Enum<SqlOption>

SqlOption system how to explain a SqlItem, SqlItem like "Message" in windows, SqlOption is the "Message" type.

Since:

1.7.0.3

Author:

Yong Zhu

Enum Constant Summary

ALIAS
Mark a SqlItem stored alias name(s) for latest TableModel in SQL

AUTO_SQL
Mark a AUTO_SQL SqlOption, tell ORM to create left join SQL automatically

BIND
Mark a Mark a BIND SqlItem, bind Key-Values pairs "key1,value1, key2,value2..." for SqlTemplateEngine

DISABLE_HANDLERS
Mark a ENABLE_HANDLERS SqlOption, disable given handlers

ENABLE_HANDLERS
Mark a ENABLE_HANDLERS SqlOption, enable given handlers

EXECUTE
Mark a EXECUTE SqlOption

GIVE
Mark a GIVE SqlItem for ORM purpose

GIVE_BOTH
Mark a GIVE_BOTH SqlItem for ORM purpose

IGNORE_NULL
Mark a IGNORE_NULL SqlOption, if true in ORM insert and update method will ignore null fields

INSERT
Mark a INSERT SqlOption

NOT_NULL
Mark a NOT_NULL SqlItem, Usage: NOT_NUL("user_name=?", name), when name is null, nothing will be appended into SQL and parameters, otherwise return a "user_name=?" String and a SQL parameter

OTHER
Mark a USE_SLAVE SqlItem, used to store some other items

PARAM
Mark a SQL parameter SqlItem

QUERY
Mark a QUERY SqlOption

QUESTION_PARAM
Mark a QUESTION_PARAM SqlItem, i.e.

SHARD_DATABASE
Mark a SHARD_DATABASE SqlOption

SHARD_TABLE
Mark a SHARD_TABLE SqlOption

SQL
Mark a SQL SqlItem, i.e.

SWITCHTO
Mark a ENABLE_HANDLERS SqlOption, switch to another DbPro or subClass (SqlBoxContext) to execute SQL

TAIL
Mark a TAIL SqlItem, tell ORM to use this model do CRUD

UPDATE
Mark a UPDATE SqlOption

USE_AUTO
Mark a USE_SLAVE SqlOption, tell system to choose master or slave database automatically (write:master, read:if in Transaction use master otherwise use one slave)

USE_BOTH
Mark a USE_BOTH SqlOption, tell system force use master and slave

USE_MASTER
Mark a USE_SLAVE SqlOption, tell system force use master database

USE_SLAVE
Mark a USE_SLAVE SqlOption, tell system force use slave database

USE_TEMPLATE
Mark a USE_TEMPLATE SqlOption, Force use template style

VALUES_QUESTIONS
Mark a VALUES_QUESTIONS SqlItem, append a " values(?,?,?....?)" String at end of SQL

Method Summary

static SqlOption	valueOf(String name) Returns the enum constant of this type with the specified name.
static SqlOption[]	values() Returns an array containing the constants of this enum type, in the order they are declared.

Methods inherited from class java.lang.Enum

clone, compareTo, equals, finalize, getDeclaringClass, hashCode, name, ordinal, toString, valueOf

Methods inherited from class java.lang.Object

getClass, notify, notifyAll, wait, wait, wait

Enum Constant Detail

SQL

public static final SqlOption SQL

Mark a SQL SqlItem, i.e. a Sql String piece

PARAM

public static final SqlOption PARAM

Mark a SQL parameter SqlItem

QUESTION_PARAM

public static final SqlOption QUESTION_PARAM

Mark a QUESTION_PARAM SqlItem, i.e. a ? String and a parameter

BIND

public static final SqlOption BIND

Mark a Mark a BIND SqlItem, bind Key-Values pairs "key1,value1, key2,value2..." for SqlTemplateEngine

NOT_NULL

public static final SqlOption NOT_NULL

Mark a NOT_NULL SqlItem, Usage: NOT_NUL("user_name=?", name), when name is null, nothing will be appended into SQL and parameters, otherwise return a "user_name=?" String and a SQL parameter

VALUES_QUESTIONS

public static final SqlOption VALUES_QUESTIONS

Mark a VALUES_QUESTIONS SqlItem, append a " values(?,?,?....?)" String at end of SQL

SWITCHTO

public static final SqlOption SWITCHTO

Mark a ENABLE_HANDLERS SqlOption, switch to another DbPro or subClass (SqlBoxContext) to execute SQL

DISABLE_HANDLERS

public static final SqlOption DISABLE_HANDLERS

Mark a ENABLE_HANDLERS SqlOption, disable given handlers

ENABLE_HANDLERS

public static final SqlOption ENABLE_HANDLERS

Mark a ENABLE_HANDLERS SqlOption, enable given handlers

USE_TEMPLATE

public static final SqlOption USE_TEMPLATE

Mark a USE_TEMPLATE SqlOption, Force use template style

EXECUTE

public static final SqlOption EXECUTE

Mark a EXECUTE SqlOption

UPDATE

public static final SqlOption UPDATE

Mark a UPDATE SqlOption

INSERT

public static final SqlOption INSERT

Mark a INSERT SqlOption

QUERY

public static final SqlOption QUERY

Mark a QUERY SqlOption

OTHER

public static final SqlOption OTHER

Mark a USE_SLAVE SqlItem, used to store some other items

USE_AUTO

public static final SqlOption USE_AUTO

Mark a USE_SLAVE SqlOption, tell system to choose master or slave database automatically (write:master, read:if in Transaction use master otherwise use one slave)

USE_MASTER

public static final SqlOption USE_MASTER

Mark a USE_SLAVE SqlOption, tell system force use master database

USE_SLAVE

public static final SqlOption USE_SLAVE

Mark a USE_SLAVE SqlOption, tell system force use slave database

USE_BOTH

public static final SqlOption USE_BOTH

Mark a USE_BOTH SqlOption, tell system force use master and slave

ALIAS

public static final SqlOption ALIAS

Mark a SqlItem stored alias name(s) for latest TableModel in SQL

SHARD_TABLE

public static final SqlOption SHARD_TABLE

Mark a SHARD_TABLE SqlOption

SHARD_DATABASE

public static final SqlOption SHARD_DATABASE

Mark a SHARD_DATABASE SqlOption

GIVE

public static final SqlOption GIVE

Mark a GIVE SqlItem for ORM purpose

GIVE_BOTH

public static final SqlOption GIVE_BOTH

Mark a GIVE_BOTH SqlItem for ORM purpose

IGNORE_NULL

public static final SqlOption IGNORE_NULL

Mark a IGNORE_NULL SqlOption, if true in ORM insert and update method will ignore null fields

AUTO_SQL

public static final SqlOption AUTO_SQL

Mark a AUTO_SQL SqlOption, tell ORM to create left join SQL automatically

TAIL

public static final SqlOption TAIL

Mark a TAIL SqlItem, tell ORM to use this model do CRUD

Method Detail

values

public static SqlOption[] values()

Returns an array containing the constants of this enum type, in the order they are declared. This method may be used to iterate over the constants as follows:

for (SqlOption c : SqlOption.values())
    System.out.println(c);

Returns:

an array containing the constants of this enum type, in the order they are declared

valueOf

public static SqlOption valueOf(String name)

Returns the enum constant of this type with the specified name. The string must match exactly an identifier used to declare an enum constant in this type. (Extraneous whitespace characters are not permitted.)

Parameters:

name - the name of the enum constant to be returned.

Returns:

the enum constant with the specified name

Throws:

IllegalArgumentException - if this enum type has no constant with the specified name

NullPointerException - if the argument is null