org.seasar.robot.db.cbean.bs
クラス BsUrlFilterCB

java.lang.Object
  上位を拡張 org.seasar.robot.dbflute.cbean.AbstractConditionBean
      上位を拡張 org.seasar.robot.db.cbean.bs.BsUrlFilterCB
すべての実装されたインタフェース:
org.seasar.robot.dbflute.cbean.ConditionBean, org.seasar.robot.dbflute.cbean.FetchNarrowingBean, org.seasar.robot.dbflute.cbean.OrderByBean, org.seasar.robot.dbflute.cbean.PagingBean, org.seasar.robot.dbflute.jdbc.FetchBean
直系の既知のサブクラス:
UrlFilterCB

public class BsUrlFilterCB
extends org.seasar.robot.dbflute.cbean.AbstractConditionBean

The base condition-bean of URL_FILTER.

作成者:
DBFlute(AutoGenerator)

入れ子のクラスの概要
static class BsUrlFilterCB.HpSpecification
           
 
クラス org.seasar.robot.dbflute.cbean.AbstractConditionBean から継承された入れ子のクラス/インタフェース
org.seasar.robot.dbflute.cbean.AbstractConditionBean.SsCall
 
フィールドの概要
protected  UrlFilterCQ _conditionQuery
           
protected  BsUrlFilterCB.HpSpecification _specification
           
 
クラス org.seasar.robot.dbflute.cbean.AbstractConditionBean から継承されたフィールド
_colQyCBMap, _isSelectCountIgnoreFetchScope, _purpose, _sqlClause
 
コンストラクタの概要
BsUrlFilterCB()
           
 
メソッドの概要
 void acceptPrimaryKey(Long id)
           
 org.seasar.robot.dbflute.cbean.ConditionBean addOrderBy_PK_Asc()
           
 org.seasar.robot.dbflute.cbean.ConditionBean addOrderBy_PK_Desc()
           
 org.seasar.robot.dbflute.cbean.chelper.HpColQyOperand<UrlFilterCB> columnQuery(org.seasar.robot.dbflute.cbean.SpecifyQuery<UrlFilterCB> leftSpecifyQuery)
          Set up column-query.
protected  UrlFilterCQ createLocalCQ()
           
protected  org.seasar.robot.dbflute.cbean.sqlclause.SqlClause createSqlClause()
           
protected  String getConditionBeanClassNameInternally()
           
protected  String getConditionOptionClassNameInternally()
           
 UrlFilterCQ getConditionQuery()
           
protected  String getConditionQueryClassNameInternally()
           
protected  org.seasar.robot.dbflute.dbmeta.DBMetaProvider getDBMetaProvider()
           
protected  String getLogDateFormat()
           
protected  String getLogTimestampFormat()
           
protected  org.seasar.robot.dbflute.twowaysql.factory.SqlAnalyzerFactory getSqlAnalyzerFactory()
           
protected  String getSubQueryClassNameInternally()
           
 String getTableDbName()
           
protected  boolean hasSpecifiedColumn()
           
 boolean hasUnionQueryOrUnionAllQuery()
           
 org.seasar.robot.dbflute.cbean.ConditionQuery localCQ()
           
protected  org.seasar.robot.dbflute.cbean.chelper.HpAbstractSpecification<? extends org.seasar.robot.dbflute.cbean.ConditionQuery> localSp()
           
 void orScopeQuery(org.seasar.robot.dbflute.cbean.OrQuery<UrlFilterCB> orQuery)
          Set up the query for or-scope.
 void orScopeQueryAndPart(org.seasar.robot.dbflute.cbean.AndQuery<UrlFilterCB> andQuery)
          Set up the and-part of or-scope.
 UrlFilterCQ query()
          Prepare for various queries.
 BsUrlFilterCB.HpSpecification specify()
          Prepare for SpecifyColumn, (Specify)DerivedReferrer.
 void union(org.seasar.robot.dbflute.cbean.UnionQuery<UrlFilterCB> unionQuery)
          Set up 'union' for base-point table.
 void unionAll(org.seasar.robot.dbflute.cbean.UnionQuery<UrlFilterCB> unionQuery)
          Set up 'union all' for base-point table.
protected  UrlFilterCB xcreateColumnQueryCB()
           
protected  UrlFilterCQ xcreateCQ(org.seasar.robot.dbflute.cbean.ConditionQuery childQuery, org.seasar.robot.dbflute.cbean.sqlclause.SqlClause sqlClause, String aliasName, int nestLevel)
           
protected  void xprepareSyncQyCall(org.seasar.robot.dbflute.cbean.ConditionBean mainCB)
           
 
クラス org.seasar.robot.dbflute.cbean.AbstractConditionBean から継承されたメソッド
acceptPrimaryKeyMap, allowEmptyStringQuery, assertObjectNotNull, assertQueryPurpose, assertSetupSelectBeforeUnion, assertSetupSelectPurpose, assertSpecifyPurpose, assertStringNotNullAndNotTrimmedEmpty, canPagingCountLater, canPagingReSelect, checkInvalidQuery, checkSafetyResult, clearOrderBy, configure, createCBExThrower, createPagingInvoker, disablePagingReSelect, doSetupSelect, embedCondition, enablePagingCountLater, fetchFirst, fetchPage, fetchScope, getColQyCBMap, getDBMeta, getFetchNarrowingLoopCount, getFetchNarrowingSkipStartIndex, getFetchPageNumber, getFetchSize, getFetchStartIndex, getFreeParameterMap, getFromBaseTableHint, getFromHint, getOrderByClause, getOrderByComponent, getPageEndIndex, getPageStartIndex, getPurpose, getSafetyMaxResultSize, getSelectHint, getSqlClause, getSqlSuffix, getStatementConfig, hasOrderByClause, hasSubQueryBeginOnFirstLine, hasSubQueryEndOnLastLine, hasWhereClause, ignoreFetchNarrowing, ignoreOrderBy, initCap, insertSubQueryEndOnLastLine, invokeSetupSelect, isFetchNarrowingEffective, isFetchNarrowingLoopCountEffective, isFetchNarrowingSkipStartIndexEffective, isFetchScopeEffective, isPaging, isSelectCountIgnoreFetchScope, ln, lockForUpdate, makeOrderByEffective, paging, restoreIgnoredFetchNarrowing, throwPagingPageSizeNotPlusException, throwQueryIllegalPurposeException, throwSetupSelectAfterUnionException, throwSetupSelectIllegalPurposeException, throwSpecifyIllegalPurposeException, toDisplaySql, toString, xafterCareSelectCountIgnoreFetchScope, xbuildColQyColumn, xbuildLeftColumn, xbuildRightColumn, xchangePurposeSqlClause, xcolqy, xcreateCalcSpecification, xcreateColQyClause, xinheritInvalidQueryInfo, xinheritSubQueryInfo, xorSQ, xorSQAP, xprepareSubQueryInfo, xregisterFreeParameter, xregisterUnionQuerySynchronizer, xsaveUCB, xsetPaging, xsetupForColumnQuery, xsetupForDerivedReferrer, xsetupForExistsReferrer, xsetupForInScopeRelation, xsetupForQueryInsert, xsetupForScalarCondition, xsetupForScalarSelect, xsetupForSpecifiedUpdate, xsetupForUnion, xsetupForVaryingUpdate, xsetupSelectCountIgnoreFetchScope, xsyncUQ
 
クラス java.lang.Object から継承されたメソッド
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait
 

フィールドの詳細

_conditionQuery

protected UrlFilterCQ _conditionQuery

_specification

protected BsUrlFilterCB.HpSpecification _specification
コンストラクタの詳細

BsUrlFilterCB

public BsUrlFilterCB()
メソッドの詳細

createSqlClause

protected org.seasar.robot.dbflute.cbean.sqlclause.SqlClause createSqlClause()
定義:
クラス org.seasar.robot.dbflute.cbean.AbstractConditionBean 内の createSqlClause

getDBMetaProvider

protected org.seasar.robot.dbflute.dbmeta.DBMetaProvider getDBMetaProvider()
定義:
クラス org.seasar.robot.dbflute.cbean.AbstractConditionBean 内の getDBMetaProvider

getTableDbName

public String getTableDbName()

acceptPrimaryKey

public void acceptPrimaryKey(Long id)

addOrderBy_PK_Asc

public org.seasar.robot.dbflute.cbean.ConditionBean addOrderBy_PK_Asc()

addOrderBy_PK_Desc

public org.seasar.robot.dbflute.cbean.ConditionBean addOrderBy_PK_Desc()

query

public UrlFilterCQ query()
Prepare for various queries.
Examples of main functions are following:
 // Basic Queries
 cb.query().setMemberId_Equal(value);        // =
 cb.query().setMemberId_NotEqual(value);     // !=
 cb.query().setMemberId_GreaterThan(value);  // >
 cb.query().setMemberId_LessThan(value);     // <
 cb.query().setMemberId_GreaterEqual(value); // >=
 cb.query().setMemberId_LessEqual(value);    // <=
 cb.query().setMemberName_InScope(valueList);    // in ('a', 'b')
 cb.query().setMemberName_NotInScope(valueList); // not in ('a', 'b')
 cb.query().setMemberName_PrefixSearch(value);   // like 'a%' escape '|'
 // LikeSearch with various options: (versatile)
 // {like ... [options]}
 cb.query().setMemberName_LikeSearch(value, option);
 cb.query().setMemberName_NotLikeSearch(value, option); // not like ...
 // FromTo with various options: (versatile)
 // {(default) fromDatetime <= BIRTHDATE <= toDatetime}
 cb.query().setBirthdate_FromTo(fromDatetime, toDatetime, option);
 // DateFromTo: (Date means yyyy/MM/dd)
 // {fromDate <= BIRTHDATE < toDate + 1 day}
 cb.query().setBirthdate_DateFromTo(fromDate, toDate);
 cb.query().setBirthdate_IsNull();    // is null
 cb.query().setBirthdate_IsNotNull(); // is not null
 
 // ExistsReferrer: (co-related sub-query)
 // {where exists (select PURCHASE_ID from PURCHASE where ...)}
 cb.query().existsPurchaseList(new SubQuery<PurchaseCB>() {
     public void query(PurchaseCB subCB) {
         subCB.query().setXxx... // referrer sub-query condition
     }
 });
 cb.query().notExistsPurchaseList...
 
 // InScopeRelation: (sub-query)
 // {where MEMBER_STATUS_CODE in (select MEMBER_STATUS_CODE from MEMBER_STATUS where ...)}
 cb.query().inScopeMemberStatus(new SubQuery<MemberStatusCB>() {
     public void query(MemberStatusCB subCB) {
         subCB.query().setXxx... // relation sub-query condition
     }
 });
 cb.query().notInScopeMemberStatus...
 
 // (Query)DerivedReferrer: (co-related sub-query)
 cb.query().derivedPurchaseList().max(new SubQuery<PurchaseCB>() {
     public void query(PurchaseCB subCB) {
         subCB.specify().columnPurchasePrice(); // derived column for function
         subCB.query().setXxx... // referrer sub-query condition
     }
 }).greaterEqual(value);
 
 // ScalarCondition: (self-table sub-query)
 cb.query().scalar_Equal().max(new SubQuery<MemberCB>() {
     public void query(MemberCB subCB) {
         subCB.specify().columnBirthdate(); // derived column for function
         subCB.query().setXxx... // scalar sub-query condition
     }
 });
 
 // OrderBy
 cb.query().addOrderBy_MemberName_Asc();
 cb.query().addOrderBy_MemberName_Desc().withManualOrder(valueList);
 cb.query().addOrderBy_MemberName_Desc().withNullsFirst();
 cb.query().addOrderBy_MemberName_Desc().withNullsLast();
 cb.query().addSpecifiedDerivedOrderBy_Desc(aliasName);
 
 // Query(Relation)
 cb.query().queryMemberStatus()...;
 cb.query().queryMemberAddressAsValid(targetDate)...;
 

戻り値:
The instance of condition-query for base-point table to set up query. (NotNull)

getConditionQuery

public UrlFilterCQ getConditionQuery()

createLocalCQ

protected UrlFilterCQ createLocalCQ()

xcreateCQ

protected UrlFilterCQ xcreateCQ(org.seasar.robot.dbflute.cbean.ConditionQuery childQuery,
                                org.seasar.robot.dbflute.cbean.sqlclause.SqlClause sqlClause,
                                String aliasName,
                                int nestLevel)

localCQ

public org.seasar.robot.dbflute.cbean.ConditionQuery localCQ()

union

public void union(org.seasar.robot.dbflute.cbean.UnionQuery<UrlFilterCB> unionQuery)
Set up 'union' for base-point table.
You don't need to call SetupSelect in union-query, because it inherits calls before. (Don't call SetupSelect after here)
 cb.query().union(new UnionQuery<UrlFilterCB>() {
     public void query(UrlFilterCB unionCB) {
         unionCB.query().setXxx...
     }
 });
 

パラメータ:
unionQuery - The query of 'union'. (NotNull)

unionAll

public void unionAll(org.seasar.robot.dbflute.cbean.UnionQuery<UrlFilterCB> unionQuery)
Set up 'union all' for base-point table.
You don't need to call SetupSelect in union-query, because it inherits calls before. (Don't call SetupSelect after here)
 cb.query().unionAll(new UnionQuery<UrlFilterCB>() {
     public void query(UrlFilterCB unionCB) {
         unionCB.query().setXxx...
     }
 });
 

パラメータ:
unionQuery - The query of 'union all'. (NotNull)

specify

public BsUrlFilterCB.HpSpecification specify()
Prepare for SpecifyColumn, (Specify)DerivedReferrer.
This method should be called after SetupSelect.
 cb.setupSelect_MemberStatus(); // should be called before specify()
 cb.specify().columnMemberName();
 cb.specify().specifyMemberStatus().columnMemberStatusName();
 cb.specify().derivedPurchaseList().max(new SubQuery<PurchaseCB>() {
     public void query(PurchaseCB subCB) {
         subCB.specify().columnPurchaseDatetime();
         subCB.query().set...
     }
 }, aliasName);
 

戻り値:
The instance of specification. (NotNull)

hasSpecifiedColumn

protected boolean hasSpecifiedColumn()
定義:
クラス org.seasar.robot.dbflute.cbean.AbstractConditionBean 内の hasSpecifiedColumn

localSp

protected org.seasar.robot.dbflute.cbean.chelper.HpAbstractSpecification<? extends org.seasar.robot.dbflute.cbean.ConditionQuery> localSp()
定義:
クラス org.seasar.robot.dbflute.cbean.AbstractConditionBean 内の localSp

columnQuery

public org.seasar.robot.dbflute.cbean.chelper.HpColQyOperand<UrlFilterCB> columnQuery(org.seasar.robot.dbflute.cbean.SpecifyQuery<UrlFilterCB> leftSpecifyQuery)
Set up column-query. {column1 = column2}
 // where FOO < BAR
 cb.columnQuery(new SpecifyQuery<UrlFilterCB>() {
     public void query(UrlFilterCB cb) {
         cb.specify().columnFoo(); // left column
     }
 }).lessThan(new SpecifyQuery<UrlFilterCB>() {
     public void query(UrlFilterCB cb) {
         cb.specify().columnBar(); // right column
     }
 }); // you can calculate for right column like '}).plus(3);'
 

パラメータ:
leftSpecifyQuery - The specify-query for left column. (NotNull)
戻り値:
The object for setting up operand and right column. (NotNull)

xcreateColumnQueryCB

protected UrlFilterCB xcreateColumnQueryCB()

orScopeQuery

public void orScopeQuery(org.seasar.robot.dbflute.cbean.OrQuery<UrlFilterCB> orQuery)
Set up the query for or-scope.
(Same-column-and-same-condition-key conditions are allowed in or-scope)
 // where (FOO = '...' or BAR = '...')
 cb.orScopeQuery(new OrQuery<UrlFilterCB>() {
     public void query(UrlFilterCB orCB) {
         orCB.query().setFOO_Equal...
         orCB.query().setBAR_Equal...
     }
 });
 

パラメータ:
orQuery - The query for or-condition. (NotNull)

orScopeQueryAndPart

public void orScopeQueryAndPart(org.seasar.robot.dbflute.cbean.AndQuery<UrlFilterCB> andQuery)
Set up the and-part of or-scope.
(However nested or-scope query and as-or-split of like-search in and-part are unsupported)
 // where (FOO = '...' or (BAR = '...' and QUX = '...'))
 cb.orScopeQuery(new OrQuery<UrlFilterCB>() {
     public void query(UrlFilterCB orCB) {
         orCB.query().setFOO_Equal...
         orCB.orScopeQueryAndPart(new AndQuery<UrlFilterCB>() {
             public void query(UrlFilterCB andCB) {
                 andCB.query().setBar_...
                 andCB.query().setQux_...
             }
         });
     }
 });
 

パラメータ:
andQuery - The query for and-condition. (NotNull)

getSqlAnalyzerFactory

protected org.seasar.robot.dbflute.twowaysql.factory.SqlAnalyzerFactory getSqlAnalyzerFactory()
定義:
クラス org.seasar.robot.dbflute.cbean.AbstractConditionBean 内の getSqlAnalyzerFactory

getLogDateFormat

protected String getLogDateFormat()
定義:
クラス org.seasar.robot.dbflute.cbean.AbstractConditionBean 内の getLogDateFormat

getLogTimestampFormat

protected String getLogTimestampFormat()
定義:
クラス org.seasar.robot.dbflute.cbean.AbstractConditionBean 内の getLogTimestampFormat

hasUnionQueryOrUnionAllQuery

public boolean hasUnionQueryOrUnionAllQuery()

xprepareSyncQyCall

protected void xprepareSyncQyCall(org.seasar.robot.dbflute.cbean.ConditionBean mainCB)
定義:
クラス org.seasar.robot.dbflute.cbean.AbstractConditionBean 内の xprepareSyncQyCall

getConditionBeanClassNameInternally

protected String getConditionBeanClassNameInternally()

getConditionQueryClassNameInternally

protected String getConditionQueryClassNameInternally()

getSubQueryClassNameInternally

protected String getSubQueryClassNameInternally()

getConditionOptionClassNameInternally

protected String getConditionOptionClassNameInternally()


Copyright © 2012. All Rights Reserved.