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 usysQueries.
\r
17 * @author DBFlute(AutoGenerator)
\r
19 public abstract class AbstractBsUsysqueriesCQ extends AbstractConditionQuery {
\r
21 // ===================================================================================
\r
24 protected final DBMetaProvider _dbmetaProvider = new DBMetaInstanceHandler();
\r
26 // ===================================================================================
\r
29 public AbstractBsUsysqueriesCQ(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 "usysQueries";
\r
48 public String getTableSqlName() {
\r
49 return "usysQueries";
\r
52 // ===================================================================================
\r
57 * Equal(=). And NullOrEmptyIgnored, OnlyOnceRegistered. {VARCHAR(50)}
\r
58 * @param queryname The value of queryname as equal.
\r
60 public void setQueryname_Equal(String queryname) {
\r
61 regQueryname(CK_EQ, fRES(queryname));
\r
65 * NotEqual(!=). And NullOrEmptyIgnored, OnlyOnceRegistered.
\r
66 * @param queryname The value of queryname as notEqual.
\r
68 public void setQueryname_NotEqual(String queryname) {
\r
69 regQueryname(CK_NE, fRES(queryname));
\r
73 * GreaterThan(>). And NullOrEmptyIgnored, OnlyOnceRegistered.
\r
74 * @param queryname The value of queryname as greaterThan.
\r
76 public void setQueryname_GreaterThan(String queryname) {
\r
77 regQueryname(CK_GT, fRES(queryname));
\r
81 * LessThan(<). And NullOrEmptyIgnored, OnlyOnceRegistered.
\r
82 * @param queryname The value of queryname as lessThan.
\r
84 public void setQueryname_LessThan(String queryname) {
\r
85 regQueryname(CK_LT, fRES(queryname));
\r
89 * GreaterEqual(>=). And NullOrEmptyIgnored, OnlyOnceRegistered.
\r
90 * @param queryname The value of queryname as greaterEqual.
\r
92 public void setQueryname_GreaterEqual(String queryname) {
\r
93 regQueryname(CK_GE, fRES(queryname));
\r
97 * LessEqual(<=). And NullOrEmptyIgnored, OnlyOnceRegistered.
\r
98 * @param queryname The value of queryname as lessEqual.
\r
100 public void setQueryname_LessEqual(String queryname) {
\r
101 regQueryname(CK_LE, fRES(queryname));
\r
105 * PrefixSearch(like 'xxx%'). And NullOrEmptyIgnored, OnlyOnceRegistered.
\r
106 * @param queryname The value of queryname as prefixSearch.
\r
108 public void setQueryname_PrefixSearch(String queryname) {
\r
109 regQueryname(CK_PS, fRES(queryname));
\r
113 * InScope(in ('a', 'b')). And NullOrEmptyIgnored, NullOrEmptyElementIgnored, SeveralRegistered.
\r
114 * @param querynameList The collection of queryname as inScope.
\r
116 public void setQueryname_InScope(Collection<String> querynameList) {
\r
117 regQueryname(CK_INS, cTL(querynameList));
\r
121 * LikeSearch(like 'xxx%' escape ...). And NullOrEmptyIgnored, SeveralRegistered.
\r
122 * @param queryname The value of queryname as likeSearch.
\r
123 * @param likeSearchOption The option of like-search. (NotNull)
\r
125 public void setQueryname_LikeSearch(String queryname, LikeSearchOption likeSearchOption) {
\r
126 regLSQ(CK_LS, fRES(queryname), getCValueQueryname(), "QueryName", likeSearchOption);
\r
130 * NotLikeSearch(not like 'xxx%' escape ...). And NullOrEmptyIgnored, SeveralRegistered.
\r
131 * @param queryname The value of queryname as notLikeSearch.
\r
132 * @param likeSearchOption The option of not-like-search. (NotNull)
\r
134 public void setQueryname_NotLikeSearch(String queryname, LikeSearchOption likeSearchOption) {
\r
135 regLSQ(CK_NLS, fRES(queryname), getCValueQueryname(), "QueryName", likeSearchOption);
\r
139 * IsNull(is null). And OnlyOnceRegistered.
\r
141 public void setQueryname_IsNull() { regQueryname(CK_ISN, DOBJ); }
\r
144 * IsNotNull(is not null). And OnlyOnceRegistered.
\r
146 public void setQueryname_IsNotNull() { regQueryname(CK_ISNN, DOBJ); }
\r
148 protected void regQueryname(ConditionKey k, Object v) { regQ(k, v, getCValueQueryname(), "QueryName"); }
\r
149 abstract protected ConditionValue getCValueQueryname();
\r
152 * Equal(=). And NullOrEmptyIgnored, OnlyOnceRegistered. {VARCHAR(50)}
\r
153 * @param newname The value of newname as equal.
\r
155 public void setNewname_Equal(String newname) {
\r
156 regNewname(CK_EQ, fRES(newname));
\r
160 * NotEqual(!=). And NullOrEmptyIgnored, OnlyOnceRegistered.
\r
161 * @param newname The value of newname as notEqual.
\r
163 public void setNewname_NotEqual(String newname) {
\r
164 regNewname(CK_NE, fRES(newname));
\r
168 * GreaterThan(>). And NullOrEmptyIgnored, OnlyOnceRegistered.
\r
169 * @param newname The value of newname as greaterThan.
\r
171 public void setNewname_GreaterThan(String newname) {
\r
172 regNewname(CK_GT, fRES(newname));
\r
176 * LessThan(<). And NullOrEmptyIgnored, OnlyOnceRegistered.
\r
177 * @param newname The value of newname as lessThan.
\r
179 public void setNewname_LessThan(String newname) {
\r
180 regNewname(CK_LT, fRES(newname));
\r
184 * GreaterEqual(>=). And NullOrEmptyIgnored, OnlyOnceRegistered.
\r
185 * @param newname The value of newname as greaterEqual.
\r
187 public void setNewname_GreaterEqual(String newname) {
\r
188 regNewname(CK_GE, fRES(newname));
\r
192 * LessEqual(<=). And NullOrEmptyIgnored, OnlyOnceRegistered.
\r
193 * @param newname The value of newname as lessEqual.
\r
195 public void setNewname_LessEqual(String newname) {
\r
196 regNewname(CK_LE, fRES(newname));
\r
200 * PrefixSearch(like 'xxx%'). And NullOrEmptyIgnored, OnlyOnceRegistered.
\r
201 * @param newname The value of newname as prefixSearch.
\r
203 public void setNewname_PrefixSearch(String newname) {
\r
204 regNewname(CK_PS, fRES(newname));
\r
208 * InScope(in ('a', 'b')). And NullOrEmptyIgnored, NullOrEmptyElementIgnored, SeveralRegistered.
\r
209 * @param newnameList The collection of newname as inScope.
\r
211 public void setNewname_InScope(Collection<String> newnameList) {
\r
212 regNewname(CK_INS, cTL(newnameList));
\r
216 * LikeSearch(like 'xxx%' escape ...). And NullOrEmptyIgnored, SeveralRegistered.
\r
217 * @param newname The value of newname as likeSearch.
\r
218 * @param likeSearchOption The option of like-search. (NotNull)
\r
220 public void setNewname_LikeSearch(String newname, LikeSearchOption likeSearchOption) {
\r
221 regLSQ(CK_LS, fRES(newname), getCValueNewname(), "NewName", likeSearchOption);
\r
225 * NotLikeSearch(not like 'xxx%' escape ...). And NullOrEmptyIgnored, SeveralRegistered.
\r
226 * @param newname The value of newname as notLikeSearch.
\r
227 * @param likeSearchOption The option of not-like-search. (NotNull)
\r
229 public void setNewname_NotLikeSearch(String newname, LikeSearchOption likeSearchOption) {
\r
230 regLSQ(CK_NLS, fRES(newname), getCValueNewname(), "NewName", likeSearchOption);
\r
234 * IsNull(is null). And OnlyOnceRegistered.
\r
236 public void setNewname_IsNull() { regNewname(CK_ISN, DOBJ); }
\r
239 * IsNotNull(is not null). And OnlyOnceRegistered.
\r
241 public void setNewname_IsNotNull() { regNewname(CK_ISNN, DOBJ); }
\r
243 protected void regNewname(ConditionKey k, Object v) { regQ(k, v, getCValueNewname(), "NewName"); }
\r
244 abstract protected ConditionValue getCValueNewname();
\r
247 * Equal(=). And NullIgnored, OnlyOnceRegistered. {NotNull : BIT}
\r
248 * @param fixcode The value of fixcode as equal.
\r
250 public void setFixcode_Equal(Boolean fixcode) {
\r
251 regFixcode(CK_EQ, fixcode);
\r
254 protected void regFixcode(ConditionKey k, Object v) { regQ(k, v, getCValueFixcode(), "FixCode"); }
\r
255 abstract protected ConditionValue getCValueFixcode();
\r
257 // ===================================================================================
\r
260 // Very Internal (for Suppressing Warn about 'Not Use Import')
\r
261 String xCB() { return UsysqueriesCB.class.getName(); }
\r
262 String xCQ() { return UsysqueriesCQ.class.getName(); }
\r
263 String xLSO() { return LikeSearchOption.class.getName(); }
\r