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

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

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

The base condition-bean of ACCESS_RESULT.

作成者:
DBFlute(AutoGenerator)

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

_nssAccessResultDataAsOne

protected AccessResultDataNss _nssAccessResultDataAsOne

_specification

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

BsAccessResultCB

public BsAccessResultCB()
メソッドの詳細

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 java.lang.String getTableDbName()

acceptPrimaryKey

public void acceptPrimaryKey(java.lang.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 AccessResultCQ 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 AccessResultCQ getConditionQuery()

createLocalCQ

protected AccessResultCQ createLocalCQ()

xcreateCQ

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

localCQ

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

union

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

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

unionAll

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

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

getNssAccessResultDataAsOne

public AccessResultDataNss getNssAccessResultDataAsOne()

setupSelect_AccessResultDataAsOne

public AccessResultDataNss setupSelect_AccessResultDataAsOne()
Set up relation columns to select clause.
ACCESS_RESULT_DATA as 'accessResultDataAsOne'.
 AccessResultCB cb = new AccessResultCB();
 cb.setupSelect_AccessResultDataAsOne(); // ...().with[nested-relation]()
 cb.query().setFoo...(value);
 AccessResult accessResult = accessResultBhv.selectEntityWithDeletedCheck(cb);
 ... = accessResult.getAccessResultDataAsOne(); // you can get by using SetupSelect
 

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

specify

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

orScopeQuery

public void orScopeQuery(org.seasar.robot.dbflute.cbean.OrQuery<AccessResultCB> 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<AccessResultCB>() {
     public void query(AccessResultCB 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<AccessResultCB> 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<AccessResultCB>() {
     public void query(AccessResultCB orCB) {
         orCB.query().setFOO_Equal...
         orCB.orScopeQueryAndPart(new AndQuery<AccessResultCB>() {
             public void query(AccessResultCB 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 java.lang.String getLogDateFormat()
定義:
クラス org.seasar.robot.dbflute.cbean.AbstractConditionBean 内の getLogDateFormat

getLogTimestampFormat

protected java.lang.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 java.lang.String getConditionBeanClassNameInternally()

getConditionQueryClassNameInternally

protected java.lang.String getConditionQueryClassNameInternally()

getSubQueryClassNameInternally

protected java.lang.String getSubQueryClassNameInternally()

getConditionOptionClassNameInternally

protected java.lang.String getConditionOptionClassNameInternally()


Copyright © 2012. All Rights Reserved.