public class BsUrlQueueCB
extends org.seasar.dbflute.cbean.AbstractConditionBean
修飾子とタイプ | クラスと説明 |
---|---|
static class |
BsUrlQueueCB.HpSpecification |
修飾子とタイプ | フィールドと説明 |
---|---|
protected UrlQueueCQ |
_conditionQuery |
protected BsUrlQueueCB.HpSpecification |
_specification |
_checkCountBeforeQueryUpdate, _cursorSelectOption, _departurePortForDreamCruise, _dreamCruiseDeparturePort, _dreamCruiseJourneyLogBook, _dreamCruiseTicket, _isSelectCountIgnoreFetchScope, _locked, _pagingCountLater, _pagingReSelect, _pagingSelectAndQuerySplit, _purpose, _relationMappingCache, _safetyMaxResultSize, _sqlClause, _statementConfig, _unionCBeanList, _unionQuerySynchronizer
コンストラクタと説明 |
---|
BsUrlQueueCB() |
修飾子とタイプ | メソッドと説明 |
---|---|
void |
acceptPrimaryKey(Long id)
Accept the query condition of primary key as equal.
|
org.seasar.dbflute.cbean.ConditionBean |
addOrderBy_PK_Asc() |
org.seasar.dbflute.cbean.ConditionBean |
addOrderBy_PK_Desc() |
org.seasar.dbflute.cbean.chelper.HpColQyOperand<UrlQueueCB> |
columnQuery(org.seasar.dbflute.cbean.SpecifyQuery<UrlQueueCB> leftSpecifyQuery)
Set up column-query.
|
protected UrlQueueCQ |
createLocalCQ() |
protected org.seasar.dbflute.cbean.sqlclause.SqlClause |
createSqlClause() |
UrlQueueCB |
dreamCruiseCB()
Welcome to the Dream Cruise for condition-bean deep world.
|
protected String |
getConditionBeanClassNameInternally() |
protected String |
getConditionOptionClassNameInternally() |
UrlQueueCQ |
getConditionQuery() |
protected String |
getConditionQueryClassNameInternally() |
protected org.seasar.dbflute.dbmeta.DBMetaProvider |
getDBMetaProvider() |
protected String |
getLogDateFormat() |
protected String |
getLogTimestampFormat() |
protected org.seasar.dbflute.twowaysql.factory.SqlAnalyzerFactory |
getSqlAnalyzerFactory() |
protected String |
getSubQueryClassNameInternally() |
String |
getTableDbName() |
boolean |
hasSpecifiedColumn() |
boolean |
hasUnionQueryOrUnionAllQuery() |
org.seasar.dbflute.cbean.ConditionQuery |
localCQ() |
org.seasar.dbflute.cbean.chelper.HpColumnSpHandler |
localSp() |
void |
orScopeQuery(org.seasar.dbflute.cbean.OrQuery<UrlQueueCB> orQuery)
Set up the query for or-scope.
|
void |
orScopeQueryAndPart(org.seasar.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.dbflute.cbean.UnionQuery<UrlQueueCB> unionQuery)
Set up 'union' for base-point table.
|
void |
unionAll(org.seasar.dbflute.cbean.UnionQuery<UrlQueueCB> unionQuery)
Set up 'union all' for base-point table.
|
protected UrlQueueCB |
xcreateColumnQueryCB() |
protected UrlQueueCQ |
xcreateCQ(org.seasar.dbflute.cbean.ConditionQuery childQuery,
org.seasar.dbflute.cbean.sqlclause.SqlClause sqlClause,
String aliasName,
int nestLevel) |
protected org.seasar.dbflute.cbean.ConditionBean |
xdoCreateDreamCruiseCB() |
protected org.seasar.dbflute.cbean.chelper.HpCBPurpose |
xhandleOrSQPurposeChange() |
protected UrlQueueCQ |
xnewCQ(org.seasar.dbflute.cbean.ConditionQuery childQuery,
org.seasar.dbflute.cbean.sqlclause.SqlClause sqlClause,
String aliasName,
int nestLevel) |
protected void |
xprepareSyncQyCall(org.seasar.dbflute.cbean.ConditionBean mainCB) |
acceptInvalidQuery, acceptPrimaryKeyMap, allowEmptyStringQuery, allowInnerJoinAutoDetect, allowThatsBadTiming, assertObjectNotNull, assertQueryPurpose, assertSetupSelectPurpose, assertSpecifyPurpose, assertStringNotNullAndNotTrimmedEmpty, canPagingCountLater, canPagingReSelect, canPagingSelectAndQuerySplit, canRelationMappingCache, checkInvalidQuery, checkSafetyResult, clearOrderBy, clearWhereClauseOnBaseQuery, configure, createCBExThrower, createPagingInvoker, decryptIfNeeds, disableCheckCountBeforeQueryUpdate, disablePagingCountLater, disablePagingCountLeastJoin, disablePagingReSelect, disablePagingSelectAndQuerySplit, disableRelationMappingCache, doSetupSelect, embedCondition, enableCheckCountBeforeQueryUpdate, enablePagingCountLater, enablePagingCountLeastJoin, enablePagingReSelect, enablePagingSelectAndQuerySplit, fetchFirst, fetchPage, fetchScope, getCursorSelectOption, getDBMeta, getFetchNarrowingLoopCount, getFetchNarrowingSkipStartIndex, getFetchPageNumber, getFetchSize, getFetchStartIndex, getFromBaseTableHint, getFromHint, getOrderByClause, getOrderByComponent, getPageEndIndex, getPageStartIndex, getPurpose, getSafetyMaxResultSize, getSelectHint, getSqlClause, getSqlSuffix, getStatementConfig, hasOrderByClause, hasSelectAllPossible, hasSubQueryEndOnLastLine, hasWhereClauseOnBaseQuery, ignoreFetchNarrowing, ignoreOrderBy, initCap, inviteDerivedToDreamCruise, invokeSetupSelect, invokeSpecifyColumn, isCheckCountBeforeQueryUpdate, isFetchNarrowingEffective, isFetchNarrowingLoopCountEffective, isFetchNarrowingSkipStartIndexEffective, isFetchScopeEffective, isLocked, isPaging, isSelectCountIgnoreFetchScope, ln, lock, lockForUpdate, makeOrderByEffective, overTheWaves, paging, reflectToSubQueryEndOnLastLine, restoreIgnoredFetchNarrowing, suppressInnerJoinAutoDetect, suppressThatsBadTiming, throwPagingPageSizeNotPlusException, throwQueryIllegalPurposeException, throwSetupSelectIllegalPurposeException, throwSpecifyIllegalPurposeException, toDisplaySql, toString, unlock, xacceptScalarSelectOption, xafterCareSelectCountIgnoreFetchScope, xassertDreamCruiseShip, xbuildColQyColumn, xbuildColQyLeftColumn, xbuildColQyRightColumn, xchangePurposeSqlClause, xcolqy, xcreateCalcSpecification, xcreateColQyAliasInfo, xcreateColQyClause, xcreateDreamCruiseCB, xdoOrSQ, xdoSetupSelectDreamCruiseJourneyLogBook, xextractColQyColumnRealName, xgetDreamCruiseDeparturePort, xhandleOrSQPurposeClose, xhasDreamCruiseTicket, xinheritInvalidQueryInfo, xinheritStructurePossibleInnerJoin, xinheritSubQueryInfo, xinheritThatsBadTiming, xinheritWhereUsedInnerJoin, xisDreamCruiseDeparturePort, xisDreamCruiseShip, xkeepDreamCruiseJourneyLogBook, xmarkAsDeparturePortForDreamCruise, xorSQ, xorSQAP, xprepareSubQueryInfo, xregisterColQyClause, xregisterUnionQuerySynchronizer, xsaveUCB, xsetPaging, xsetupForColumnQuery, xsetupForDerivedReferrer, xsetupForDreamCruise, xsetupForExistsReferrer, xsetupForInScopeRelation, xsetupForMyselfExists, xsetupForMyselfInScope, xsetupForOrScopeQuery, xsetupForQueryInsert, xsetupForScalarCondition, xsetupForScalarConditionPartitionBy, xsetupForScalarSelect, xsetupForSpecifiedUpdate, xsetupForUnion, xsetupForVaryingUpdate, xsetupSelectCountIgnoreFetchScope, xsetupSelectDreamCruiseJourneyLogBook, xsetupSelectDreamCruiseJourneyLogBookIfUnionExists, xshowDreamCruiseTicket, xsyncUQ
protected UrlQueueCQ _conditionQuery
protected BsUrlQueueCB.HpSpecification _specification
protected org.seasar.dbflute.cbean.sqlclause.SqlClause createSqlClause()
createSqlClause
クラス内 org.seasar.dbflute.cbean.AbstractConditionBean
protected org.seasar.dbflute.dbmeta.DBMetaProvider getDBMetaProvider()
getDBMetaProvider
クラス内 org.seasar.dbflute.cbean.AbstractConditionBean
public String getTableDbName()
public void acceptPrimaryKey(Long id)
id
- : PK, ID, NotNull, BIGINT(19). (NotNull)public org.seasar.dbflute.cbean.ConditionBean addOrderBy_PK_Asc()
public org.seasar.dbflute.cbean.ConditionBean addOrderBy_PK_Desc()
public UrlQueueCQ query()
// 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: (correlated 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: (correlated 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)...;
public UrlQueueCQ getConditionQuery()
protected UrlQueueCQ createLocalCQ()
protected UrlQueueCQ xcreateCQ(org.seasar.dbflute.cbean.ConditionQuery childQuery, org.seasar.dbflute.cbean.sqlclause.SqlClause sqlClause, String aliasName, int nestLevel)
protected UrlQueueCQ xnewCQ(org.seasar.dbflute.cbean.ConditionQuery childQuery, org.seasar.dbflute.cbean.sqlclause.SqlClause sqlClause, String aliasName, int nestLevel)
public org.seasar.dbflute.cbean.ConditionQuery localCQ()
public void union(org.seasar.dbflute.cbean.UnionQuery<UrlQueueCB> unionQuery)
cb.query().union(new UnionQuery<UrlQueueCB>() {
public void query(UrlQueueCB unionCB) {
unionCB.query().setXxx...
}
});
unionQuery
- The query of 'union'. (NotNull)public void unionAll(org.seasar.dbflute.cbean.UnionQuery<UrlQueueCB> unionQuery)
cb.query().unionAll(new UnionQuery<UrlQueueCB>() {
public void query(UrlQueueCB unionCB) {
unionCB.query().setXxx...
}
});
unionQuery
- The query of 'union all'. (NotNull)public BsUrlQueueCB.HpSpecification specify()
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);
public org.seasar.dbflute.cbean.chelper.HpColumnSpHandler localSp()
public boolean hasSpecifiedColumn()
public org.seasar.dbflute.cbean.chelper.HpColQyOperand<UrlQueueCB> columnQuery(org.seasar.dbflute.cbean.SpecifyQuery<UrlQueueCB> leftSpecifyQuery)
// 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)protected UrlQueueCB xcreateColumnQueryCB()
public UrlQueueCB dreamCruiseCB()
protected org.seasar.dbflute.cbean.ConditionBean xdoCreateDreamCruiseCB()
xdoCreateDreamCruiseCB
クラス内 org.seasar.dbflute.cbean.AbstractConditionBean
public void orScopeQuery(org.seasar.dbflute.cbean.OrQuery<UrlQueueCB> orQuery)
// 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)protected org.seasar.dbflute.cbean.chelper.HpCBPurpose xhandleOrSQPurposeChange()
xhandleOrSQPurposeChange
クラス内 org.seasar.dbflute.cbean.AbstractConditionBean
public void orScopeQueryAndPart(org.seasar.dbflute.cbean.AndQuery<UrlQueueCB> andQuery)
// 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)protected org.seasar.dbflute.twowaysql.factory.SqlAnalyzerFactory getSqlAnalyzerFactory()
getSqlAnalyzerFactory
クラス内 org.seasar.dbflute.cbean.AbstractConditionBean
protected String getLogDateFormat()
getLogDateFormat
クラス内 org.seasar.dbflute.cbean.AbstractConditionBean
protected String getLogTimestampFormat()
getLogTimestampFormat
クラス内 org.seasar.dbflute.cbean.AbstractConditionBean
public boolean hasUnionQueryOrUnionAllQuery()
protected void xprepareSyncQyCall(org.seasar.dbflute.cbean.ConditionBean mainCB)
xprepareSyncQyCall
クラス内 org.seasar.dbflute.cbean.AbstractConditionBean
protected String getConditionBeanClassNameInternally()
protected String getConditionQueryClassNameInternally()
protected String getSubQueryClassNameInternally()
protected String getConditionOptionClassNameInternally()
Copyright © 2009–2014 The Seasar Foundation. All rights reserved.