cn.hutool.db.sql

Enum SqlBuilder.Join

java.lang.Object

java.lang.Enum<SqlBuilder.Join>

cn.hutool.db.sql.SqlBuilder.Join

All Implemented Interfaces:

Serializable, Comparable<SqlBuilder.Join>

Enclosing class:

SqlBuilder

public static enum SqlBuilder.Join
extends Enum<SqlBuilder.Join>

SQL中多表关联用的关键字

Author:

Looly

Enum Constant Summary

Enum Constants

Enum Constant and Description
FULL 只要其中一个表中存在匹配，就返回行
INNER 如果表中有至少一个匹配，则返回行
LEFT 即使右表中没有匹配，也从左表返回所有的行
RIGHT 即使左表中没有匹配，也从右表返回所有的行

Method Summary

Modifier and Type	Method and Description
static SqlBuilder.Join	valueOf(String name) Returns the enum constant of this type with the specified name.
static SqlBuilder.Join[]	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

INNER

public static final SqlBuilder.Join INNER

如果表中有至少一个匹配，则返回行

LEFT

public static final SqlBuilder.Join LEFT

即使右表中没有匹配，也从左表返回所有的行

RIGHT

public static final SqlBuilder.Join RIGHT

即使左表中没有匹配，也从右表返回所有的行

FULL

public static final SqlBuilder.Join FULL

只要其中一个表中存在匹配，就返回行

Method Detail

values

public static SqlBuilder.Join[] 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 (SqlBuilder.Join c : SqlBuilder.Join.values())
    System.out.println(c);

Returns:

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

valueOf

public static SqlBuilder.Join 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