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

java.lang.Object
  上位を拡張 org.seasar.robot.dbflute.cbean.AbstractConditionBean
      上位を拡張 org.seasar.robot.db.cbean.bs.BsAccessResultDataCB
すべての実装されたインタフェース:
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
直系の既知のサブクラス:
AccessResultDataCB

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

The base condition-bean of ACCESS_RESULT_DATA.

作成者:
DBFlute(AutoGenerator)

入れ子のクラスの概要
static class BsAccessResultDataCB.HpSpecification
           
 
クラス org.seasar.robot.dbflute.cbean.AbstractConditionBean から継承された入れ子のクラス/インタフェース
org.seasar.robot.dbflute.cbean.AbstractConditionBean.SsCall
 
フィールドの概要
protected  AccessResultDataCQ _conditionQuery
           
protected  AccessResultNss _nssAccessResult
           
protected  BsAccessResultDataCB.HpSpecification _specification
           
 
クラス org.seasar.robot.dbflute.cbean.AbstractConditionBean から継承されたフィールド
_colQyCBMap, _isSelectCountIgnoreFetchScope, _purpose, _sqlClause
 
コンストラクタの概要
BsAccessResultDataCB()
           
 
メソッドの概要
 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<AccessResultDataCB> columnQuery(org.seasar.robot.dbflute.cbean.SpecifyQuery<AccessResultDataCB> leftSpecifyQuery)
          Set up column-query.
protected  AccessResultDataCQ createLocalCQ()
           
protected  org.seasar.robot.dbflute.cbean.sqlclause.SqlClause createSqlClause()
           
protected  String getConditionBeanClassNameInternally()
           
protected  String getConditionOptionClassNameInternally()
           
 AccessResultDataCQ getConditionQuery()
           
protected  String getConditionQueryClassNameInternally()
           
protected  org.seasar.robot.dbflute.dbmeta.DBMetaProvider getDBMetaProvider()
           
protected  String getLogDateFormat()
           
protected  String getLogTimestampFormat()
           
 AccessResultNss getNssAccessResult()
           
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<AccessResultDataCB> orQuery)
          Set up the query for or-scope.
 void orScopeQueryAndPart(org.seasar.robot.dbflute.cbean.AndQuery<AccessResultDataCB> andQuery)
          Set up the and-part of or-scope.
 AccessResultDataCQ query()
          Prepare for various queries.
 AccessResultNss setupSelect_AccessResult()
          Set up relation columns to select clause.
 BsAccessResultDataCB.HpSpecification specify()
          Prepare for SpecifyColumn, (Specify)DerivedReferrer.
 void union(org.seasar.robot.dbflute.cbean.UnionQuery<AccessResultDataCB> unionQuery)
          Set up 'union' for base-point table.
 void unionAll(org.seasar.robot.dbflute.cbean.UnionQuery<AccessResultDataCB> unionQuery)
          Set up 'union all' for base-point table.
protected  AccessResultDataCB xcreateColumnQueryCB()
           
protected  AccessResultDataCQ 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 AccessResultDataCQ _conditionQuery

_nssAccessResult

protected AccessResultNss _nssAccessResult

_specification

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

BsAccessResultDataCB

public BsAccessResultDataCB()
メソッドの詳細

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 AccessResultDataCQ 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 AccessResultDataCQ getConditionQuery()

createLocalCQ

protected AccessResultDataCQ createLocalCQ()

xcreateCQ

protected AccessResultDataCQ 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<AccessResultDataCB> 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<AccessResultDataCB>() {
     public void query(AccessResultDataCB unionCB) {
         unionCB.query().setXxx...
     }
 });
 

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

unionAll

public void unionAll(org.seasar.robot.dbflute.cbean.UnionQuery<AccessResultDataCB> 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<AccessResultDataCB>() {
     public void query(AccessResultDataCB unionCB) {
         unionCB.query().setXxx...
     }
 });
 

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

getNssAccessResult

public AccessResultNss getNssAccessResult()

setupSelect_AccessResult

public AccessResultNss setupSelect_AccessResult()
Set up relation columns to select clause.
ACCESS_RESULT as 'accessResult'.
 AccessResultDataCB cb = new AccessResultDataCB();
 cb.setupSelect_AccessResult(); // ...().with[nested-relation]()
 cb.query().setFoo...(value);
 AccessResultData accessResultData = accessResultDataBhv.selectEntityWithDeletedCheck(cb);
 ... = accessResultData.getAccessResult(); // you can get by using SetupSelect
 

戻り値:
The set-upper of nested relation. {setupSelect...().with[nested-relation]} (NotNull)

specify

public BsAccessResultDataCB.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<AccessResultDataCB> columnQuery(org.seasar.robot.dbflute.cbean.SpecifyQuery<AccessResultDataCB> leftSpecifyQuery)
Set up column-query. {column1 = column2}
 // where FOO < BAR
 cb.columnQuery(new SpecifyQuery<AccessResultDataCB>() {
     public void query(AccessResultDataCB cb) {
         cb.specify().columnFoo(); // left column
     }
 }).lessThan(new SpecifyQuery<AccessResultDataCB>() {
     public void query(AccessResultDataCB 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 AccessResultDataCB xcreateColumnQueryCB()

orScopeQuery

public void orScopeQuery(org.seasar.robot.dbflute.cbean.OrQuery<AccessResultDataCB> 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<AccessResultDataCB>() {
     public void query(AccessResultDataCB 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<AccessResultDataCB> 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<AccessResultDataCB>() {
     public void query(AccessResultDataCB orCB) {
         orCB.query().setFOO_Equal...
         orCB.orScopeQueryAndPart(new AndQuery<AccessResultDataCB>() {
             public void query(AccessResultDataCB 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.