1 package jp.sourceforge.ea2ddl.dao.cbean.cq.bs;
\r
3 import java.util.Collection;
\r
5 import org.seasar.dbflute.cbean.*;
\r
6 import org.seasar.dbflute.cbean.ckey.*;
\r
7 import org.seasar.dbflute.cbean.coption.*;
\r
8 import org.seasar.dbflute.cbean.cvalue.ConditionValue;
\r
9 import org.seasar.dbflute.cbean.sqlclause.SqlClause;
\r
10 import org.seasar.dbflute.dbmeta.DBMetaProvider;
\r
11 import jp.sourceforge.ea2ddl.dao.allcommon.*;
\r
12 import jp.sourceforge.ea2ddl.dao.cbean.*;
\r
13 import jp.sourceforge.ea2ddl.dao.cbean.cq.*;
\r
16 * The abstract condition-query of t_objectrisks.
\r
17 * @author DBFlute(AutoGenerator)
\r
19 public abstract class AbstractBsTObjectrisksCQ extends AbstractConditionQuery {
\r
21 // ===================================================================================
\r
24 protected final DBMetaProvider _dbmetaProvider = new DBMetaInstanceHandler();
\r
26 // ===================================================================================
\r
29 public AbstractBsTObjectrisksCQ(ConditionQuery childQuery, SqlClause sqlClause, String aliasName, int nestLevel) {
\r
30 super(childQuery, sqlClause, aliasName, nestLevel);
\r
33 // ===================================================================================
\r
37 protected DBMetaProvider getDBMetaProvider() {
\r
38 return _dbmetaProvider;
\r
41 // ===================================================================================
\r
44 public String getTableDbName() {
\r
45 return "t_objectrisks";
\r
48 public String getTableSqlName() {
\r
49 return "t_objectrisks";
\r
52 // ===================================================================================
\r
57 * Equal(=). And NullIgnored, OnlyOnceRegistered. {UQ : INTEGER}
\r
58 * @param objectId The value of objectId as equal.
\r
60 public void setObjectId_Equal(java.lang.Integer objectId) {
\r
61 regObjectId(CK_EQ, objectId);
\r
65 * NotEqual(!=). And NullIgnored, OnlyOnceRegistered.
\r
66 * @param objectId The value of objectId as notEqual.
\r
68 public void setObjectId_NotEqual(java.lang.Integer objectId) {
\r
69 regObjectId(CK_NE, objectId);
\r
73 * GreaterThan(>). And NullIgnored, OnlyOnceRegistered.
\r
74 * @param objectId The value of objectId as greaterThan.
\r
76 public void setObjectId_GreaterThan(java.lang.Integer objectId) {
\r
77 regObjectId(CK_GT, objectId);
\r
81 * LessThan(<). And NullIgnored, OnlyOnceRegistered.
\r
82 * @param objectId The value of objectId as lessThan.
\r
84 public void setObjectId_LessThan(java.lang.Integer objectId) {
\r
85 regObjectId(CK_LT, objectId);
\r
89 * GreaterEqual(>=). And NullIgnored, OnlyOnceRegistered.
\r
90 * @param objectId The value of objectId as greaterEqual.
\r
92 public void setObjectId_GreaterEqual(java.lang.Integer objectId) {
\r
93 regObjectId(CK_GE, objectId);
\r
97 * LessEqual(<=). And NullIgnored, OnlyOnceRegistered.
\r
98 * @param objectId The value of objectId as lessEqual.
\r
100 public void setObjectId_LessEqual(java.lang.Integer objectId) {
\r
101 regObjectId(CK_LE, objectId);
\r
105 * InScope(in (1, 2)). And NullIgnored, NullElementIgnored, SeveralRegistered.
\r
106 * @param objectIdList The collection of objectId as inScope.
\r
108 public void setObjectId_InScope(Collection<java.lang.Integer> objectIdList) {
\r
109 regObjectId(CK_INS, cTL(objectIdList));
\r
113 * IsNull(is null). And OnlyOnceRegistered.
\r
115 public void setObjectId_IsNull() { regObjectId(CK_ISN, DOBJ); }
\r
118 * IsNotNull(is not null). And OnlyOnceRegistered.
\r
120 public void setObjectId_IsNotNull() { regObjectId(CK_ISNN, DOBJ); }
\r
122 protected void regObjectId(ConditionKey k, Object v) { regQ(k, v, getCValueObjectId(), "Object_ID"); }
\r
123 abstract protected ConditionValue getCValueObjectId();
\r
126 * Equal(=). And NullOrEmptyIgnored, OnlyOnceRegistered. {UQ : VARCHAR(255)}
\r
127 * @param risk The value of risk as equal.
\r
129 public void setRisk_Equal(String risk) {
\r
130 regRisk(CK_EQ, fRES(risk));
\r
134 * NotEqual(!=). And NullOrEmptyIgnored, OnlyOnceRegistered.
\r
135 * @param risk The value of risk as notEqual.
\r
137 public void setRisk_NotEqual(String risk) {
\r
138 regRisk(CK_NE, fRES(risk));
\r
142 * GreaterThan(>). And NullOrEmptyIgnored, OnlyOnceRegistered.
\r
143 * @param risk The value of risk as greaterThan.
\r
145 public void setRisk_GreaterThan(String risk) {
\r
146 regRisk(CK_GT, fRES(risk));
\r
150 * LessThan(<). And NullOrEmptyIgnored, OnlyOnceRegistered.
\r
151 * @param risk The value of risk as lessThan.
\r
153 public void setRisk_LessThan(String risk) {
\r
154 regRisk(CK_LT, fRES(risk));
\r
158 * GreaterEqual(>=). And NullOrEmptyIgnored, OnlyOnceRegistered.
\r
159 * @param risk The value of risk as greaterEqual.
\r
161 public void setRisk_GreaterEqual(String risk) {
\r
162 regRisk(CK_GE, fRES(risk));
\r
166 * LessEqual(<=). And NullOrEmptyIgnored, OnlyOnceRegistered.
\r
167 * @param risk The value of risk as lessEqual.
\r
169 public void setRisk_LessEqual(String risk) {
\r
170 regRisk(CK_LE, fRES(risk));
\r
174 * PrefixSearch(like 'xxx%'). And NullOrEmptyIgnored, OnlyOnceRegistered.
\r
175 * @param risk The value of risk as prefixSearch.
\r
177 public void setRisk_PrefixSearch(String risk) {
\r
178 regRisk(CK_PS, fRES(risk));
\r
182 * InScope(in ('a', 'b')). And NullOrEmptyIgnored, NullOrEmptyElementIgnored, SeveralRegistered.
\r
183 * @param riskList The collection of risk as inScope.
\r
185 public void setRisk_InScope(Collection<String> riskList) {
\r
186 regRisk(CK_INS, cTL(riskList));
\r
190 * LikeSearch(like 'xxx%' escape ...). And NullOrEmptyIgnored, SeveralRegistered.
\r
191 * @param risk The value of risk as likeSearch.
\r
192 * @param likeSearchOption The option of like-search. (NotNull)
\r
194 public void setRisk_LikeSearch(String risk, LikeSearchOption likeSearchOption) {
\r
195 regLSQ(CK_LS, fRES(risk), getCValueRisk(), "Risk", likeSearchOption);
\r
199 * NotLikeSearch(not like 'xxx%' escape ...). And NullOrEmptyIgnored, SeveralRegistered.
\r
200 * @param risk The value of risk as notLikeSearch.
\r
201 * @param likeSearchOption The option of not-like-search. (NotNull)
\r
203 public void setRisk_NotLikeSearch(String risk, LikeSearchOption likeSearchOption) {
\r
204 regLSQ(CK_NLS, fRES(risk), getCValueRisk(), "Risk", likeSearchOption);
\r
208 * IsNull(is null). And OnlyOnceRegistered.
\r
210 public void setRisk_IsNull() { regRisk(CK_ISN, DOBJ); }
\r
213 * IsNotNull(is not null). And OnlyOnceRegistered.
\r
215 public void setRisk_IsNotNull() { regRisk(CK_ISNN, DOBJ); }
\r
217 protected void regRisk(ConditionKey k, Object v) { regQ(k, v, getCValueRisk(), "Risk"); }
\r
218 abstract protected ConditionValue getCValueRisk();
\r
221 * Equal(=). And NullOrEmptyIgnored, OnlyOnceRegistered. {VARCHAR(12)}
\r
222 * @param risktype The value of risktype as equal.
\r
224 public void setRisktype_Equal(String risktype) {
\r
225 regRisktype(CK_EQ, fRES(risktype));
\r
229 * NotEqual(!=). And NullOrEmptyIgnored, OnlyOnceRegistered.
\r
230 * @param risktype The value of risktype as notEqual.
\r
232 public void setRisktype_NotEqual(String risktype) {
\r
233 regRisktype(CK_NE, fRES(risktype));
\r
237 * GreaterThan(>). And NullOrEmptyIgnored, OnlyOnceRegistered.
\r
238 * @param risktype The value of risktype as greaterThan.
\r
240 public void setRisktype_GreaterThan(String risktype) {
\r
241 regRisktype(CK_GT, fRES(risktype));
\r
245 * LessThan(<). And NullOrEmptyIgnored, OnlyOnceRegistered.
\r
246 * @param risktype The value of risktype as lessThan.
\r
248 public void setRisktype_LessThan(String risktype) {
\r
249 regRisktype(CK_LT, fRES(risktype));
\r
253 * GreaterEqual(>=). And NullOrEmptyIgnored, OnlyOnceRegistered.
\r
254 * @param risktype The value of risktype as greaterEqual.
\r
256 public void setRisktype_GreaterEqual(String risktype) {
\r
257 regRisktype(CK_GE, fRES(risktype));
\r
261 * LessEqual(<=). And NullOrEmptyIgnored, OnlyOnceRegistered.
\r
262 * @param risktype The value of risktype as lessEqual.
\r
264 public void setRisktype_LessEqual(String risktype) {
\r
265 regRisktype(CK_LE, fRES(risktype));
\r
269 * PrefixSearch(like 'xxx%'). And NullOrEmptyIgnored, OnlyOnceRegistered.
\r
270 * @param risktype The value of risktype as prefixSearch.
\r
272 public void setRisktype_PrefixSearch(String risktype) {
\r
273 regRisktype(CK_PS, fRES(risktype));
\r
277 * InScope(in ('a', 'b')). And NullOrEmptyIgnored, NullOrEmptyElementIgnored, SeveralRegistered.
\r
278 * @param risktypeList The collection of risktype as inScope.
\r
280 public void setRisktype_InScope(Collection<String> risktypeList) {
\r
281 regRisktype(CK_INS, cTL(risktypeList));
\r
285 * LikeSearch(like 'xxx%' escape ...). And NullOrEmptyIgnored, SeveralRegistered.
\r
286 * @param risktype The value of risktype as likeSearch.
\r
287 * @param likeSearchOption The option of like-search. (NotNull)
\r
289 public void setRisktype_LikeSearch(String risktype, LikeSearchOption likeSearchOption) {
\r
290 regLSQ(CK_LS, fRES(risktype), getCValueRisktype(), "RiskType", likeSearchOption);
\r
294 * NotLikeSearch(not like 'xxx%' escape ...). And NullOrEmptyIgnored, SeveralRegistered.
\r
295 * @param risktype The value of risktype as notLikeSearch.
\r
296 * @param likeSearchOption The option of not-like-search. (NotNull)
\r
298 public void setRisktype_NotLikeSearch(String risktype, LikeSearchOption likeSearchOption) {
\r
299 regLSQ(CK_NLS, fRES(risktype), getCValueRisktype(), "RiskType", likeSearchOption);
\r
303 * IsNull(is null). And OnlyOnceRegistered.
\r
305 public void setRisktype_IsNull() { regRisktype(CK_ISN, DOBJ); }
\r
308 * IsNotNull(is not null). And OnlyOnceRegistered.
\r
310 public void setRisktype_IsNotNull() { regRisktype(CK_ISNN, DOBJ); }
\r
312 protected void regRisktype(ConditionKey k, Object v) { regQ(k, v, getCValueRisktype(), "RiskType"); }
\r
313 abstract protected ConditionValue getCValueRisktype();
\r
316 * Equal(=). And NullIgnored, OnlyOnceRegistered. {DOUBLE}
\r
317 * @param evalue The value of evalue as equal.
\r
319 public void setEvalue_Equal(java.math.BigDecimal evalue) {
\r
320 regEvalue(CK_EQ, evalue);
\r
324 * NotEqual(!=). And NullIgnored, OnlyOnceRegistered.
\r
325 * @param evalue The value of evalue as notEqual.
\r
327 public void setEvalue_NotEqual(java.math.BigDecimal evalue) {
\r
328 regEvalue(CK_NE, evalue);
\r
332 * GreaterThan(>). And NullIgnored, OnlyOnceRegistered.
\r
333 * @param evalue The value of evalue as greaterThan.
\r
335 public void setEvalue_GreaterThan(java.math.BigDecimal evalue) {
\r
336 regEvalue(CK_GT, evalue);
\r
340 * LessThan(<). And NullIgnored, OnlyOnceRegistered.
\r
341 * @param evalue The value of evalue as lessThan.
\r
343 public void setEvalue_LessThan(java.math.BigDecimal evalue) {
\r
344 regEvalue(CK_LT, evalue);
\r
348 * GreaterEqual(>=). And NullIgnored, OnlyOnceRegistered.
\r
349 * @param evalue The value of evalue as greaterEqual.
\r
351 public void setEvalue_GreaterEqual(java.math.BigDecimal evalue) {
\r
352 regEvalue(CK_GE, evalue);
\r
356 * LessEqual(<=). And NullIgnored, OnlyOnceRegistered.
\r
357 * @param evalue The value of evalue as lessEqual.
\r
359 public void setEvalue_LessEqual(java.math.BigDecimal evalue) {
\r
360 regEvalue(CK_LE, evalue);
\r
364 * InScope(in (1, 2)). And NullIgnored, NullElementIgnored, SeveralRegistered.
\r
365 * @param evalueList The collection of evalue as inScope.
\r
367 public void setEvalue_InScope(Collection<java.math.BigDecimal> evalueList) {
\r
368 regEvalue(CK_INS, cTL(evalueList));
\r
372 * IsNull(is null). And OnlyOnceRegistered.
\r
374 public void setEvalue_IsNull() { regEvalue(CK_ISN, DOBJ); }
\r
377 * IsNotNull(is not null). And OnlyOnceRegistered.
\r
379 public void setEvalue_IsNotNull() { regEvalue(CK_ISNN, DOBJ); }
\r
381 protected void regEvalue(ConditionKey k, Object v) { regQ(k, v, getCValueEvalue(), "EValue"); }
\r
382 abstract protected ConditionValue getCValueEvalue();
\r
385 * Equal(=). And NullOrEmptyIgnored, OnlyOnceRegistered. {LONGCHAR(2147483647)}
\r
386 * @param notes The value of notes as equal.
\r
388 public void setNotes_Equal(String notes) {
\r
389 regNotes(CK_EQ, fRES(notes));
\r
393 * NotEqual(!=). And NullOrEmptyIgnored, OnlyOnceRegistered.
\r
394 * @param notes The value of notes as notEqual.
\r
396 public void setNotes_NotEqual(String notes) {
\r
397 regNotes(CK_NE, fRES(notes));
\r
401 * GreaterThan(>). And NullOrEmptyIgnored, OnlyOnceRegistered.
\r
402 * @param notes The value of notes as greaterThan.
\r
404 public void setNotes_GreaterThan(String notes) {
\r
405 regNotes(CK_GT, fRES(notes));
\r
409 * LessThan(<). And NullOrEmptyIgnored, OnlyOnceRegistered.
\r
410 * @param notes The value of notes as lessThan.
\r
412 public void setNotes_LessThan(String notes) {
\r
413 regNotes(CK_LT, fRES(notes));
\r
417 * GreaterEqual(>=). And NullOrEmptyIgnored, OnlyOnceRegistered.
\r
418 * @param notes The value of notes as greaterEqual.
\r
420 public void setNotes_GreaterEqual(String notes) {
\r
421 regNotes(CK_GE, fRES(notes));
\r
425 * LessEqual(<=). And NullOrEmptyIgnored, OnlyOnceRegistered.
\r
426 * @param notes The value of notes as lessEqual.
\r
428 public void setNotes_LessEqual(String notes) {
\r
429 regNotes(CK_LE, fRES(notes));
\r
433 * PrefixSearch(like 'xxx%'). And NullOrEmptyIgnored, OnlyOnceRegistered.
\r
434 * @param notes The value of notes as prefixSearch.
\r
436 public void setNotes_PrefixSearch(String notes) {
\r
437 regNotes(CK_PS, fRES(notes));
\r
441 * InScope(in ('a', 'b')). And NullOrEmptyIgnored, NullOrEmptyElementIgnored, SeveralRegistered.
\r
442 * @param notesList The collection of notes as inScope.
\r
444 public void setNotes_InScope(Collection<String> notesList) {
\r
445 regNotes(CK_INS, cTL(notesList));
\r
449 * LikeSearch(like 'xxx%' escape ...). And NullOrEmptyIgnored, SeveralRegistered.
\r
450 * @param notes The value of notes as likeSearch.
\r
451 * @param likeSearchOption The option of like-search. (NotNull)
\r
453 public void setNotes_LikeSearch(String notes, LikeSearchOption likeSearchOption) {
\r
454 regLSQ(CK_LS, fRES(notes), getCValueNotes(), "Notes", likeSearchOption);
\r
458 * NotLikeSearch(not like 'xxx%' escape ...). And NullOrEmptyIgnored, SeveralRegistered.
\r
459 * @param notes The value of notes as notLikeSearch.
\r
460 * @param likeSearchOption The option of not-like-search. (NotNull)
\r
462 public void setNotes_NotLikeSearch(String notes, LikeSearchOption likeSearchOption) {
\r
463 regLSQ(CK_NLS, fRES(notes), getCValueNotes(), "Notes", likeSearchOption);
\r
467 * IsNull(is null). And OnlyOnceRegistered.
\r
469 public void setNotes_IsNull() { regNotes(CK_ISN, DOBJ); }
\r
472 * IsNotNull(is not null). And OnlyOnceRegistered.
\r
474 public void setNotes_IsNotNull() { regNotes(CK_ISNN, DOBJ); }
\r
476 protected void regNotes(ConditionKey k, Object v) { regQ(k, v, getCValueNotes(), "Notes"); }
\r
477 abstract protected ConditionValue getCValueNotes();
\r
479 // ===================================================================================
\r
482 // Very Internal (for Suppressing Warn about 'Not Use Import')
\r
483 String xCB() { return TObjectrisksCB.class.getName(); }
\r
484 String xCQ() { return TObjectrisksCQ.class.getName(); }
\r
485 String xLSO() { return LikeSearchOption.class.getName(); }
\r