パッケージ org.nkjmlab.sorm4j.sql
クラス SelectSql
- java.lang.Object
-
- org.nkjmlab.sorm4j.sql.SelectSql
-
public class SelectSql extends Object
API of creates a select SQL statement.- 作成者:
- nkjm
-
-
ネストされたクラスの概要
ネストされたクラス 修飾子とタイプ クラス 説明 static class
SelectSql.Builder
static class
SelectSql.Condition
Value object represents conditions of where clause or having clause.
-
コンストラクタの概要
コンストラクタ コンストラクタ 説明 SelectSql()
-
メソッドの概要
すべてのメソッド staticメソッド concreteメソッド 修飾子とタイプ メソッド 説明 static SelectSql.Condition
and(Object... conds)
Creates AND condition with concatenating arguments.static String
as(Object src, String alias)
Creates AS alias.static String
avg(String column)
static SelectSql.Condition
between(Object colName, Object startInclusive, Object endInclusive)
static SelectSql.Builder
builder()
CreatesSelectSql.Builder
object.static String
castAs(String src, String toType)
Creates cast as.static String
column(String tableName, String... colNames)
static SelectSql.Condition
cond(Object left, String operator, Object right)
Creates a condition with binary operatorstatic SelectSql.Condition
cond(String cond)
CreatesSelectSql.Condition
instance.static String
count(String column)
static String
from(String tableName)
static String
func(String functionName, Object args)
functionsstatic String
func(String functionName, Object... args)
static String
groupBy(Object... groups)
static SelectSql.Condition
in(Object colName, Object... values)
static String
joinComma(Object... elements)
static String
joinCommaAndSpace(Object... elements)
static String
joinObjects(String delimiter, Object... elements)
static String
joinSpace(Object... elements)
static String
limit(Object limit)
static String
literal(Object element)
Converts the given arguments to SQL literal.static String
op(Object left, String operator, Object right)
Creates a string of binary operator and operands which wrapped parentheses.static SelectSql.Condition
or(Object... conds)
Creates OR condition with concatenating arguments.static String
orderBy(Object column)
static String
orderBy(Object... order)
Creates orderBy clause.static String
orderByAsc(Object column)
static String
orderByDesc(Object column)
static String
quote(String str)
Returns single quoted expression.static String
select(Object... selectClauses)
static String
select(String selectClause)
static String
selectDistinct(Object... selectClauses)
static String
selectStarFrom(String tableName)
static String
sum(String column)
static String
where()
static String
where(String searchCondition)
static String
where(SelectSql.Condition searchCondition)
static String
wrapParentheses(Object str)
static String
wrapSingleQuote(Object str)
static String
wrapSpace(Object str)
-
-
-
メソッドの詳細
-
builder
public static SelectSql.Builder builder()
CreatesSelectSql.Builder
object.- 戻り値:
-
as
public static String as(Object src, String alias)
Creates AS alias.
For example,
as("avg(score)", "avg_score") returns "avg(score) as avg_score"
-
castAs
public static String castAs(String src, String toType)
Creates cast as. ExamplecastAs("A", "DOUBLE") generates "cast (A as DOUBLE)"
- パラメータ:
src
-toType
-- 戻り値:
-
where
public static String where()
-
where
public static String where(SelectSql.Condition searchCondition)
-
op
public static String op(Object left, String operator, Object right)
Creates a string of binary operator and operands which wrapped parentheses.Examples
op(op("A", "/", "B"), "+", op("C", "/", "D")) generates "((A / B) + (C / D))"
- パラメータ:
left
-operator
-right
-- 戻り値:
-
cond
public static SelectSql.Condition cond(String cond)
Creates
SelectSql.Condition
instance.For example,
and(cond("id=?"), "name=?") returns "id=? and name=?"
-
cond
public static SelectSql.Condition cond(Object left, String operator, Object right)
Creates a condition with binary operator- パラメータ:
left
-operator
-right
-
-
and
public static SelectSql.Condition and(Object... conds)
Creates AND condition with concatenating arguments.
For example,
and("id=?", "name=?") returns "id=? and name=?"
- パラメータ:
conds
- condition in String or Condition- 戻り値:
-
or
public static SelectSql.Condition or(Object... conds)
Creates OR condition with concatenating arguments.
For example,
or("id=?", "name=?") returns "id=? or name=?"
-
between
public static SelectSql.Condition between(Object colName, Object startInclusive, Object endInclusive)
-
in
public static SelectSql.Condition in(Object colName, Object... values)
-
literal
public static String literal(Object element)
Converts the given arguments to SQL literal.- パラメータ:
element
-- 戻り値:
-
quote
public static String quote(String str)
Returns single quoted expression. If it includes single quotations, they will be escaped.- パラメータ:
str
-- 戻り値:
-
-