public class BsAccessResultDataCB
extends org.seasar.dbflute.cbean.AbstractConditionBean
修飾子とタイプ | クラスと説明 |
---|---|
static class |
BsAccessResultDataCB.HpSpecification |
修飾子とタイプ | フィールドと説明 |
---|---|
protected AccessResultDataCQ |
_conditionQuery |
protected AccessResultNss |
_nssAccessResult |
protected BsAccessResultDataCB.HpSpecification |
_specification |
_checkCountBeforeQueryUpdate, _cursorSelectOption, _dreamCruiseDeparturePort, _dreamCruiseJourneyLogBook, _dreamCruiseTicket, _isSelectCountIgnoreFetchScope, _pagingCountLater, _pagingReSelect, _purpose, _relationMappingCache, _safetyMaxResultSize, _sqlClause, _statementConfig, _unionCBeanList, _unionQuerySynchronizer
コンストラクタと説明 |
---|
BsAccessResultDataCB() |
修飾子とタイプ | メソッドと説明 |
---|---|
void |
acceptPrimaryKey(Long id) |
org.seasar.dbflute.cbean.ConditionBean |
addOrderBy_PK_Asc() |
org.seasar.dbflute.cbean.ConditionBean |
addOrderBy_PK_Desc() |
org.seasar.dbflute.cbean.chelper.HpColQyOperand<AccessResultDataCB> |
columnQuery(org.seasar.dbflute.cbean.SpecifyQuery<AccessResultDataCB> leftSpecifyQuery)
Set up column-query.
|
protected AccessResultDataCQ |
createLocalCQ() |
protected org.seasar.dbflute.cbean.sqlclause.SqlClause |
createSqlClause() |
AccessResultDataCB |
dreamCruiseCB()
Welcome to the Dream Cruise for condition-bean deep world.
|
protected String |
getConditionBeanClassNameInternally() |
protected String |
getConditionOptionClassNameInternally() |
AccessResultDataCQ |
getConditionQuery() |
protected String |
getConditionQueryClassNameInternally() |
protected org.seasar.dbflute.dbmeta.DBMetaProvider |
getDBMetaProvider() |
protected String |
getLogDateFormat() |
protected String |
getLogTimestampFormat() |
AccessResultNss |
getNssAccessResult() |
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<AccessResultDataCB> orQuery)
Set up the query for or-scope.
|
void |
orScopeQueryAndPart(org.seasar.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.dbflute.cbean.UnionQuery<AccessResultDataCB> unionQuery)
Set up 'union' for base-point table.
|
void |
unionAll(org.seasar.dbflute.cbean.UnionQuery<AccessResultDataCB> unionQuery)
Set up 'union all' for base-point table.
|
protected AccessResultDataCB |
xcreateColumnQueryCB() |
protected AccessResultDataCQ |
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 AccessResultDataCQ |
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, assertObjectNotNull, assertQueryPurpose, assertSetupSelectPurpose, assertSpecifyPurpose, assertStringNotNullAndNotTrimmedEmpty, canPagingCountLater, canPagingReSelect, canRelationMappingCache, checkInvalidQuery, checkSafetyResult, clearOrderBy, clearWhereClauseOnBaseQuery, configure, createCBExThrower, createPagingInvoker, decryptIfNeeds, disableCheckCountBeforeQueryUpdate, disablePagingCountLater, disablePagingCountLeastJoin, disablePagingReSelect, disableRelationMappingCache, doSetupSelect, embedCondition, enableCheckCountBeforeQueryUpdate, enablePagingCountLater, enablePagingCountLeastJoin, enablePagingReSelect, 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, isPaging, isSelectCountIgnoreFetchScope, ln, lockForUpdate, makeOrderByEffective, overTheWaves, paging, reflectToSubQueryEndOnLastLine, restoreIgnoredFetchNarrowing, suppressInnerJoinAutoDetect, throwPagingPageSizeNotPlusException, throwQueryIllegalPurposeException, throwSetupSelectIllegalPurposeException, throwSpecifyIllegalPurposeException, toDisplaySql, toString, xacceptScalarSelectOption, xafterCareSelectCountIgnoreFetchScope, xassertDreamCruiseShip, xbuildColQyColumn, xbuildColQyLeftColumn, xbuildColQyRightColumn, xchangePurposeSqlClause, xcolqy, xcreateCalcSpecification, xcreateColQyAliasInfo, xcreateColQyClause, xcreateDreamCruiseCB, xdoOrSQ, xdoSetupSelectDreamCruiseJourneyLogBook, xextractColQyColumnRealName, xgetDreamCruiseDeparturePort, xhasDreamCruiseTicket, xinheritInvalidQueryInfo, xinheritStructurePossibleInnerJoin, xinheritSubQueryInfo, xinheritWhereUsedInnerJoin, xisDreamCruiseShip, xkeepDreamCruiseJourneyLogBook, xorSQ, xorSQAP, xprepareSubQueryInfo, xregisterColQyClause, xregisterUnionQuerySynchronizer, xsaveUCB, xsetPaging, xsetupForColumnQuery, xsetupForDerivedReferrer, xsetupForDreamCruise, xsetupForExistsReferrer, xsetupForInScopeRelation, xsetupForMyselfExists, xsetupForMyselfInScope, xsetupForQueryInsert, xsetupForScalarCondition, xsetupForScalarConditionPartitionBy, xsetupForScalarSelect, xsetupForSpecifiedUpdate, xsetupForUnion, xsetupForVaryingUpdate, xsetupSelectCountIgnoreFetchScope, xsetupSelectDreamCruiseJourneyLogBook, xsetupSelectDreamCruiseJourneyLogBookIfUnionExists, xshowDreamCruiseTicket, xsyncUQ
protected AccessResultDataCQ _conditionQuery
protected AccessResultNss _nssAccessResult
protected BsAccessResultDataCB.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)
public org.seasar.dbflute.cbean.ConditionBean addOrderBy_PK_Asc()
public org.seasar.dbflute.cbean.ConditionBean addOrderBy_PK_Desc()
public AccessResultDataCQ 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: (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)...;
public AccessResultDataCQ getConditionQuery()
protected AccessResultDataCQ createLocalCQ()
protected AccessResultDataCQ xcreateCQ(org.seasar.dbflute.cbean.ConditionQuery childQuery, org.seasar.dbflute.cbean.sqlclause.SqlClause sqlClause, String aliasName, int nestLevel)
protected AccessResultDataCQ 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<AccessResultDataCB> unionQuery)
cb.query().union(new UnionQuery<AccessResultDataCB>() {
public void query(AccessResultDataCB unionCB) {
unionCB.query().setXxx...
}
});
unionQuery
- The query of 'union'. (NotNull)public void unionAll(org.seasar.dbflute.cbean.UnionQuery<AccessResultDataCB> unionQuery)
cb.query().unionAll(new UnionQuery<AccessResultDataCB>() {
public void query(AccessResultDataCB unionCB) {
unionCB.query().setXxx...
}
});
unionQuery
- The query of 'union all'. (NotNull)public AccessResultNss getNssAccessResult()
public AccessResultNss setupSelect_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
public BsAccessResultDataCB.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<AccessResultDataCB> columnQuery(org.seasar.dbflute.cbean.SpecifyQuery<AccessResultDataCB> leftSpecifyQuery)
// 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)protected AccessResultDataCB xcreateColumnQueryCB()
public AccessResultDataCB dreamCruiseCB()
protected org.seasar.dbflute.cbean.ConditionBean xdoCreateDreamCruiseCB()
xdoCreateDreamCruiseCB
クラス内 org.seasar.dbflute.cbean.AbstractConditionBean
public void orScopeQuery(org.seasar.dbflute.cbean.OrQuery<AccessResultDataCB> orQuery)
// 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)public void orScopeQueryAndPart(org.seasar.dbflute.cbean.AndQuery<AccessResultDataCB> andQuery)
// 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)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.