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

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

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

The base condition-bean of URL_QUEUE.

作成者:
DBFlute(AutoGenerator)

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

_specification

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

BsUrlQueueCB

public BsUrlQueueCB()
メソッドの詳細

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

createLocalCQ

protected UrlQueueCQ createLocalCQ()

xcreateCQ

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

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

unionAll

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

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

specify

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

orScopeQuery

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