パッケージ org.nkjmlab.sorm4j.sql
クラス SelectSql
java.lang.Object
org.nkjmlab.sorm4j.sql.SelectSql
API of creates a select SQL statement.
- 作成者:
- nkjm
-
ネストされたクラスの概要
修飾子とタイプクラス説明static class
static class
Value object represents conditions of where clause or having clause.static class
Value object for order by clause. -
コンストラクタの概要
-
メソッドの概要
修飾子とタイプメソッド説明static SelectSql.Condition
Creates AND condition with concatenating arguments.static String
Creates AS alias.static String
static SelectSql.Builder
builder()
CreatesSelectSql.Builder
object.static String
static String
static String
static SelectSql.Condition
Condition with binary operatorstatic SelectSql.Condition
CreatesSelectSql.Condition
instance.static String
static String
static String
static String
static String
static String
limit
(int limit) static String
Converts the given arguments to SQL literal.static SelectSql.Condition
Creates OR condition with concatenating arguments.static String
static SelectSql.OrderBy
CreatesSelectSql.OrderBy
objects.static String
orderByAsc
(String column) static String
orderByDesc
(String column) static String
Returns single quoted expression.static String
static String
static String
selectDistinct
(String... selectClauses) static String
selectFrom
(String tableName) static String
static String
-
コンストラクタの詳細
-
SelectSql
public SelectSql()
-
-
メソッドの詳細
-
and
Creates AND condition with concatenating arguments.
For example,
and("id=?", "name=?") returns "id=? and name=?"
- パラメータ:
conds
- condition in String or Condition- 戻り値:
-
as
Creates AS alias.
For example,
as("avg(score)", "avg_score") returns "avg(score) as avg_score"
-
between
-
castAs
-
column
-
condition
Creates
SelectSql.Condition
instance.For example,
and(cond("id=?"), "name=?") returns "id=? and name=?"
-
condition
Condition with binary operator- パラメータ:
left
-op
-right
-
-
cond
-
count
-
from
-
groupBy
-
limit
-
literal
Converts the given arguments to SQL literal.- パラメータ:
element
-- 戻り値:
-
func
-
func
-
builder
CreatesSelectSql.Builder
object.- 戻り値:
-
or
Creates OR condition with concatenating arguments.
For example,
or("id=?", "name=?") returns "id=? or name=?"
-
orderBy
CreatesSelectSql.OrderBy
objects.- パラメータ:
column
-ascOrDesc
-- 戻り値:
-
orderBy
-
orderByAsc
-
orderByDesc
-
quote
Returns single quoted expression. If it includes single quotations, they will be escaped.- パラメータ:
str
-- 戻り値:
-
select
-
select
-
selectDistinct
-
selectFrom
-
sum
-
where
-