|
||||||||||
前のクラス 次のクラス | フレームあり フレームなし | |||||||||
概要: 入れ子 | フィールド | コンストラクタ | メソッド | 詳細: フィールド | コンストラクタ | メソッド |
java.lang.Objectorg.seasar.robot.dbflute.cbean.AbstractConditionBean
org.seasar.robot.db.cbean.bs.BsUrlFilterCB
public class BsUrlFilterCB
The base condition-bean of URL_FILTER.
入れ子のクラスの概要 | |
---|---|
static class |
BsUrlFilterCB.HpSpecification
|
クラス org.seasar.robot.dbflute.cbean.AbstractConditionBean から継承された入れ子のクラス/インタフェース |
---|
org.seasar.robot.dbflute.cbean.AbstractConditionBean.SsCall |
フィールドの概要 | |
---|---|
protected UrlFilterCQ |
_conditionQuery
|
protected BsUrlFilterCB.HpSpecification |
_specification
|
クラス org.seasar.robot.dbflute.cbean.AbstractConditionBean から継承されたフィールド |
---|
_colQyCBMap, _isSelectCountIgnoreFetchScope, _purpose, _sqlClause |
コンストラクタの概要 | |
---|---|
BsUrlFilterCB()
|
メソッドの概要 | |
---|---|
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<UrlFilterCB> |
columnQuery(org.seasar.robot.dbflute.cbean.SpecifyQuery<UrlFilterCB> leftSpecifyQuery)
Set up column-query. |
protected UrlFilterCQ |
createLocalCQ()
|
protected org.seasar.robot.dbflute.cbean.sqlclause.SqlClause |
createSqlClause()
|
protected String |
getConditionBeanClassNameInternally()
|
protected String |
getConditionOptionClassNameInternally()
|
UrlFilterCQ |
getConditionQuery()
|
protected String |
getConditionQueryClassNameInternally()
|
protected org.seasar.robot.dbflute.dbmeta.DBMetaProvider |
getDBMetaProvider()
|
protected String |
getLogDateFormat()
|
protected String |
getLogTimestampFormat()
|
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<UrlFilterCB> orQuery)
Set up the query for or-scope. |
void |
orScopeQueryAndPart(org.seasar.robot.dbflute.cbean.AndQuery<UrlFilterCB> andQuery)
Set up the and-part of or-scope. |
UrlFilterCQ |
query()
Prepare for various queries. |
BsUrlFilterCB.HpSpecification |
specify()
Prepare for SpecifyColumn, (Specify)DerivedReferrer. |
void |
union(org.seasar.robot.dbflute.cbean.UnionQuery<UrlFilterCB> unionQuery)
Set up 'union' for base-point table. |
void |
unionAll(org.seasar.robot.dbflute.cbean.UnionQuery<UrlFilterCB> unionQuery)
Set up 'union all' for base-point table. |
protected UrlFilterCB |
xcreateColumnQueryCB()
|
protected UrlFilterCQ |
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 |
フィールドの詳細 |
---|
protected UrlFilterCQ _conditionQuery
protected BsUrlFilterCB.HpSpecification _specification
コンストラクタの詳細 |
---|
public BsUrlFilterCB()
メソッドの詳細 |
---|
protected org.seasar.robot.dbflute.cbean.sqlclause.SqlClause createSqlClause()
org.seasar.robot.dbflute.cbean.AbstractConditionBean
内の createSqlClause
protected org.seasar.robot.dbflute.dbmeta.DBMetaProvider getDBMetaProvider()
org.seasar.robot.dbflute.cbean.AbstractConditionBean
内の getDBMetaProvider
public String getTableDbName()
public void acceptPrimaryKey(Long id)
public org.seasar.robot.dbflute.cbean.ConditionBean addOrderBy_PK_Asc()
public org.seasar.robot.dbflute.cbean.ConditionBean addOrderBy_PK_Desc()
public UrlFilterCQ 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 UrlFilterCQ getConditionQuery()
protected UrlFilterCQ createLocalCQ()
protected UrlFilterCQ xcreateCQ(org.seasar.robot.dbflute.cbean.ConditionQuery childQuery, org.seasar.robot.dbflute.cbean.sqlclause.SqlClause sqlClause, String aliasName, int nestLevel)
public org.seasar.robot.dbflute.cbean.ConditionQuery localCQ()
public void union(org.seasar.robot.dbflute.cbean.UnionQuery<UrlFilterCB> unionQuery)
cb.query().union(new UnionQuery<UrlFilterCB>() {
public void query(UrlFilterCB unionCB) {
unionCB.query().setXxx...
}
});
unionQuery
- The query of 'union'. (NotNull)public void unionAll(org.seasar.robot.dbflute.cbean.UnionQuery<UrlFilterCB> unionQuery)
cb.query().unionAll(new UnionQuery<UrlFilterCB>() {
public void query(UrlFilterCB unionCB) {
unionCB.query().setXxx...
}
});
unionQuery
- The query of 'union all'. (NotNull)public BsUrlFilterCB.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);
protected boolean hasSpecifiedColumn()
org.seasar.robot.dbflute.cbean.AbstractConditionBean
内の hasSpecifiedColumn
protected org.seasar.robot.dbflute.cbean.chelper.HpAbstractSpecification<? extends org.seasar.robot.dbflute.cbean.ConditionQuery> localSp()
org.seasar.robot.dbflute.cbean.AbstractConditionBean
内の localSp
public org.seasar.robot.dbflute.cbean.chelper.HpColQyOperand<UrlFilterCB> columnQuery(org.seasar.robot.dbflute.cbean.SpecifyQuery<UrlFilterCB> leftSpecifyQuery)
// where FOO < BAR cb.columnQuery(new SpecifyQuery<UrlFilterCB>() { public void query(UrlFilterCB cb) { cb.specify().columnFoo(); // left column } }).lessThan(new SpecifyQuery<UrlFilterCB>() { public void query(UrlFilterCB cb) { cb.specify().columnBar(); // right column } }); // you can calculate for right column like '}).plus(3);'
leftSpecifyQuery
- The specify-query for left column. (NotNull)
protected UrlFilterCB xcreateColumnQueryCB()
public void orScopeQuery(org.seasar.robot.dbflute.cbean.OrQuery<UrlFilterCB> orQuery)
// where (FOO = '...' or BAR = '...') cb.orScopeQuery(new OrQuery<UrlFilterCB>() { public void query(UrlFilterCB orCB) { orCB.query().setFOO_Equal... orCB.query().setBAR_Equal... } });
orQuery
- The query for or-condition. (NotNull)public void orScopeQueryAndPart(org.seasar.robot.dbflute.cbean.AndQuery<UrlFilterCB> andQuery)
// where (FOO = '...' or (BAR = '...' and QUX = '...')) cb.orScopeQuery(new OrQuery<UrlFilterCB>() { public void query(UrlFilterCB orCB) { orCB.query().setFOO_Equal... orCB.orScopeQueryAndPart(new AndQuery<UrlFilterCB>() { public void query(UrlFilterCB andCB) { andCB.query().setBar_... andCB.query().setQux_... } }); } });
andQuery
- The query for and-condition. (NotNull)protected org.seasar.robot.dbflute.twowaysql.factory.SqlAnalyzerFactory getSqlAnalyzerFactory()
org.seasar.robot.dbflute.cbean.AbstractConditionBean
内の getSqlAnalyzerFactory
protected String getLogDateFormat()
org.seasar.robot.dbflute.cbean.AbstractConditionBean
内の getLogDateFormat
protected String getLogTimestampFormat()
org.seasar.robot.dbflute.cbean.AbstractConditionBean
内の getLogTimestampFormat
public boolean hasUnionQueryOrUnionAllQuery()
protected void xprepareSyncQyCall(org.seasar.robot.dbflute.cbean.ConditionBean mainCB)
org.seasar.robot.dbflute.cbean.AbstractConditionBean
内の xprepareSyncQyCall
protected String getConditionBeanClassNameInternally()
protected String getConditionQueryClassNameInternally()
protected String getSubQueryClassNameInternally()
protected String getConditionOptionClassNameInternally()
|
||||||||||
前のクラス 次のクラス | フレームあり フレームなし | |||||||||
概要: 入れ子 | フィールド | コンストラクタ | メソッド | 詳細: フィールド | コンストラクタ | メソッド |