EsProComAttDataSQLBuilder.java 39 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281
  1. package com.miniframe.model.es;
  2. import java.util.ArrayList;
  3. import java.util.Date;
  4. import java.util.List;
  5. public class EsProComAttDataSQLBuilder {
  6. protected String orderByClause;
  7. protected boolean distinct;
  8. protected List<Criteria> oredCriteria;
  9. public EsProComAttDataSQLBuilder() {
  10. oredCriteria = new ArrayList<Criteria>();
  11. }
  12. public void setOrderByClause(String orderByClause) {
  13. this.orderByClause = orderByClause;
  14. }
  15. public String getOrderByClause() {
  16. return orderByClause;
  17. }
  18. public void setDistinct(boolean distinct) {
  19. this.distinct = distinct;
  20. }
  21. public boolean isDistinct() {
  22. return distinct;
  23. }
  24. public List<Criteria> getOredCriteria() {
  25. return oredCriteria;
  26. }
  27. public void or(Criteria criteria) {
  28. oredCriteria.add(criteria);
  29. }
  30. public Criteria or() {
  31. Criteria criteria = createCriteriaInternal();
  32. oredCriteria.add(criteria);
  33. return criteria;
  34. }
  35. public Criteria createCriteria() {
  36. Criteria criteria = createCriteriaInternal();
  37. if (oredCriteria.size() == 0) {
  38. oredCriteria.add(criteria);
  39. }
  40. return criteria;
  41. }
  42. protected Criteria createCriteriaInternal() {
  43. Criteria criteria = new Criteria();
  44. return criteria;
  45. }
  46. public void clear() {
  47. oredCriteria.clear();
  48. orderByClause = null;
  49. distinct = false;
  50. }
  51. protected abstract static class GeneratedCriteria {
  52. protected List<Criterion> criteria;
  53. protected GeneratedCriteria() {
  54. super();
  55. criteria = new ArrayList<Criterion>();
  56. }
  57. public boolean isValid() {
  58. return criteria.size() > 0;
  59. }
  60. public List<Criterion> getAllCriteria() {
  61. return criteria;
  62. }
  63. public List<Criterion> getCriteria() {
  64. return criteria;
  65. }
  66. protected void addCriterion(String condition) {
  67. if (condition == null) {
  68. throw new RuntimeException("Value for condition cannot be null");
  69. }
  70. criteria.add(new Criterion(condition));
  71. }
  72. protected void addCriterion(String condition, Object value, String property) {
  73. if (value == null) {
  74. throw new RuntimeException("Value for " + property + " cannot be null");
  75. }
  76. criteria.add(new Criterion(condition, value));
  77. }
  78. protected void addCriterion(String condition, Object value1, Object value2, String property) {
  79. if (value1 == null || value2 == null) {
  80. throw new RuntimeException("Between values for " + property + " cannot be null");
  81. }
  82. criteria.add(new Criterion(condition, value1, value2));
  83. }
  84. public Criteria andPcadIdIsNull() {
  85. addCriterion("pcad_id is null");
  86. return (Criteria) this;
  87. }
  88. public Criteria andPcadIdIsNotNull() {
  89. addCriterion("pcad_id is not null");
  90. return (Criteria) this;
  91. }
  92. public Criteria andPcadIdEqualTo(String value) {
  93. addCriterion("pcad_id =", value, "pcadId");
  94. return (Criteria) this;
  95. }
  96. public Criteria andPcadIdNotEqualTo(String value) {
  97. addCriterion("pcad_id <>", value, "pcadId");
  98. return (Criteria) this;
  99. }
  100. public Criteria andPcadIdGreaterThan(String value) {
  101. addCriterion("pcad_id >", value, "pcadId");
  102. return (Criteria) this;
  103. }
  104. public Criteria andPcadIdGreaterThanOrEqualTo(String value) {
  105. addCriterion("pcad_id >=", value, "pcadId");
  106. return (Criteria) this;
  107. }
  108. public Criteria andPcadIdLessThan(String value) {
  109. addCriterion("pcad_id <", value, "pcadId");
  110. return (Criteria) this;
  111. }
  112. public Criteria andPcadIdLessThanOrEqualTo(String value) {
  113. addCriterion("pcad_id <=", value, "pcadId");
  114. return (Criteria) this;
  115. }
  116. public Criteria andPcadIdLike(String value) {
  117. addCriterion("pcad_id like", value, "pcadId");
  118. return (Criteria) this;
  119. }
  120. public Criteria andPcadIdNotLike(String value) {
  121. addCriterion("pcad_id not like", value, "pcadId");
  122. return (Criteria) this;
  123. }
  124. public Criteria andPcadIdIn(List<String> values) {
  125. addCriterion("pcad_id in", values, "pcadId");
  126. return (Criteria) this;
  127. }
  128. public Criteria andPcadIdNotIn(List<String> values) {
  129. addCriterion("pcad_id not in", values, "pcadId");
  130. return (Criteria) this;
  131. }
  132. public Criteria andPcadIdBetween(String value1, String value2) {
  133. addCriterion("pcad_id between", value1, value2, "pcadId");
  134. return (Criteria) this;
  135. }
  136. public Criteria andPcadIdNotBetween(String value1, String value2) {
  137. addCriterion("pcad_id not between", value1, value2, "pcadId");
  138. return (Criteria) this;
  139. }
  140. public Criteria andPcadgIdIsNull() {
  141. addCriterion("pcadg_id is null");
  142. return (Criteria) this;
  143. }
  144. public Criteria andPcadgIdIsNotNull() {
  145. addCriterion("pcadg_id is not null");
  146. return (Criteria) this;
  147. }
  148. public Criteria andPcadgIdEqualTo(Integer value) {
  149. addCriterion("pcadg_id =", value, "pcadgId");
  150. return (Criteria) this;
  151. }
  152. public Criteria andPcadgIdNotEqualTo(Integer value) {
  153. addCriterion("pcadg_id <>", value, "pcadgId");
  154. return (Criteria) this;
  155. }
  156. public Criteria andPcadgIdGreaterThan(Integer value) {
  157. addCriterion("pcadg_id >", value, "pcadgId");
  158. return (Criteria) this;
  159. }
  160. public Criteria andPcadgIdGreaterThanOrEqualTo(Integer value) {
  161. addCriterion("pcadg_id >=", value, "pcadgId");
  162. return (Criteria) this;
  163. }
  164. public Criteria andPcadgIdLessThan(Integer value) {
  165. addCriterion("pcadg_id <", value, "pcadgId");
  166. return (Criteria) this;
  167. }
  168. public Criteria andPcadgIdLessThanOrEqualTo(Integer value) {
  169. addCriterion("pcadg_id <=", value, "pcadgId");
  170. return (Criteria) this;
  171. }
  172. public Criteria andPcadgIdIn(List<Integer> values) {
  173. addCriterion("pcadg_id in", values, "pcadgId");
  174. return (Criteria) this;
  175. }
  176. public Criteria andPcadgIdNotIn(List<Integer> values) {
  177. addCriterion("pcadg_id not in", values, "pcadgId");
  178. return (Criteria) this;
  179. }
  180. public Criteria andPcadgIdBetween(Integer value1, Integer value2) {
  181. addCriterion("pcadg_id between", value1, value2, "pcadgId");
  182. return (Criteria) this;
  183. }
  184. public Criteria andPcadgIdNotBetween(Integer value1, Integer value2) {
  185. addCriterion("pcadg_id not between", value1, value2, "pcadgId");
  186. return (Criteria) this;
  187. }
  188. public Criteria andPidIsNull() {
  189. addCriterion("pid is null");
  190. return (Criteria) this;
  191. }
  192. public Criteria andPidIsNotNull() {
  193. addCriterion("pid is not null");
  194. return (Criteria) this;
  195. }
  196. public Criteria andPidEqualTo(String value) {
  197. addCriterion("pid =", value, "pid");
  198. return (Criteria) this;
  199. }
  200. public Criteria andPidNotEqualTo(String value) {
  201. addCriterion("pid <>", value, "pid");
  202. return (Criteria) this;
  203. }
  204. public Criteria andPidGreaterThan(String value) {
  205. addCriterion("pid >", value, "pid");
  206. return (Criteria) this;
  207. }
  208. public Criteria andPidGreaterThanOrEqualTo(String value) {
  209. addCriterion("pid >=", value, "pid");
  210. return (Criteria) this;
  211. }
  212. public Criteria andPidLessThan(String value) {
  213. addCriterion("pid <", value, "pid");
  214. return (Criteria) this;
  215. }
  216. public Criteria andPidLessThanOrEqualTo(String value) {
  217. addCriterion("pid <=", value, "pid");
  218. return (Criteria) this;
  219. }
  220. public Criteria andPidLike(String value) {
  221. addCriterion("pid like", value, "pid");
  222. return (Criteria) this;
  223. }
  224. public Criteria andPidNotLike(String value) {
  225. addCriterion("pid not like", value, "pid");
  226. return (Criteria) this;
  227. }
  228. public Criteria andPidIn(List<String> values) {
  229. addCriterion("pid in", values, "pid");
  230. return (Criteria) this;
  231. }
  232. public Criteria andPidNotIn(List<String> values) {
  233. addCriterion("pid not in", values, "pid");
  234. return (Criteria) this;
  235. }
  236. public Criteria andPidBetween(String value1, String value2) {
  237. addCriterion("pid between", value1, value2, "pid");
  238. return (Criteria) this;
  239. }
  240. public Criteria andPidNotBetween(String value1, String value2) {
  241. addCriterion("pid not between", value1, value2, "pid");
  242. return (Criteria) this;
  243. }
  244. public Criteria andComIdIsNull() {
  245. addCriterion("com_id is null");
  246. return (Criteria) this;
  247. }
  248. public Criteria andComIdIsNotNull() {
  249. addCriterion("com_id is not null");
  250. return (Criteria) this;
  251. }
  252. public Criteria andComIdEqualTo(String value) {
  253. addCriterion("com_id =", value, "comId");
  254. return (Criteria) this;
  255. }
  256. public Criteria andComIdNotEqualTo(String value) {
  257. addCriterion("com_id <>", value, "comId");
  258. return (Criteria) this;
  259. }
  260. public Criteria andComIdGreaterThan(String value) {
  261. addCriterion("com_id >", value, "comId");
  262. return (Criteria) this;
  263. }
  264. public Criteria andComIdGreaterThanOrEqualTo(String value) {
  265. addCriterion("com_id >=", value, "comId");
  266. return (Criteria) this;
  267. }
  268. public Criteria andComIdLessThan(String value) {
  269. addCriterion("com_id <", value, "comId");
  270. return (Criteria) this;
  271. }
  272. public Criteria andComIdLessThanOrEqualTo(String value) {
  273. addCriterion("com_id <=", value, "comId");
  274. return (Criteria) this;
  275. }
  276. public Criteria andComIdLike(String value) {
  277. addCriterion("com_id like", value, "comId");
  278. return (Criteria) this;
  279. }
  280. public Criteria andComIdNotLike(String value) {
  281. addCriterion("com_id not like", value, "comId");
  282. return (Criteria) this;
  283. }
  284. public Criteria andComIdIn(List<String> values) {
  285. addCriterion("com_id in", values, "comId");
  286. return (Criteria) this;
  287. }
  288. public Criteria andComIdNotIn(List<String> values) {
  289. addCriterion("com_id not in", values, "comId");
  290. return (Criteria) this;
  291. }
  292. public Criteria andComIdBetween(String value1, String value2) {
  293. addCriterion("com_id between", value1, value2, "comId");
  294. return (Criteria) this;
  295. }
  296. public Criteria andComIdNotBetween(String value1, String value2) {
  297. addCriterion("com_id not between", value1, value2, "comId");
  298. return (Criteria) this;
  299. }
  300. public Criteria andAttIdIsNull() {
  301. addCriterion("att_id is null");
  302. return (Criteria) this;
  303. }
  304. public Criteria andAttIdIsNotNull() {
  305. addCriterion("att_id is not null");
  306. return (Criteria) this;
  307. }
  308. public Criteria andAttIdEqualTo(String value) {
  309. addCriterion("att_id =", value, "attId");
  310. return (Criteria) this;
  311. }
  312. public Criteria andAttIdNotEqualTo(String value) {
  313. addCriterion("att_id <>", value, "attId");
  314. return (Criteria) this;
  315. }
  316. public Criteria andAttIdGreaterThan(String value) {
  317. addCriterion("att_id >", value, "attId");
  318. return (Criteria) this;
  319. }
  320. public Criteria andAttIdGreaterThanOrEqualTo(String value) {
  321. addCriterion("att_id >=", value, "attId");
  322. return (Criteria) this;
  323. }
  324. public Criteria andAttIdLessThan(String value) {
  325. addCriterion("att_id <", value, "attId");
  326. return (Criteria) this;
  327. }
  328. public Criteria andAttIdLessThanOrEqualTo(String value) {
  329. addCriterion("att_id <=", value, "attId");
  330. return (Criteria) this;
  331. }
  332. public Criteria andAttIdLike(String value) {
  333. addCriterion("att_id like", value, "attId");
  334. return (Criteria) this;
  335. }
  336. public Criteria andAttIdNotLike(String value) {
  337. addCriterion("att_id not like", value, "attId");
  338. return (Criteria) this;
  339. }
  340. public Criteria andAttIdIn(List<String> values) {
  341. addCriterion("att_id in", values, "attId");
  342. return (Criteria) this;
  343. }
  344. public Criteria andAttIdNotIn(List<String> values) {
  345. addCriterion("att_id not in", values, "attId");
  346. return (Criteria) this;
  347. }
  348. public Criteria andAttIdBetween(String value1, String value2) {
  349. addCriterion("att_id between", value1, value2, "attId");
  350. return (Criteria) this;
  351. }
  352. public Criteria andAttIdNotBetween(String value1, String value2) {
  353. addCriterion("att_id not between", value1, value2, "attId");
  354. return (Criteria) this;
  355. }
  356. public Criteria andPcIdIsNull() {
  357. addCriterion("pc_id is null");
  358. return (Criteria) this;
  359. }
  360. public Criteria andPcIdIsNotNull() {
  361. addCriterion("pc_id is not null");
  362. return (Criteria) this;
  363. }
  364. public Criteria andPcIdEqualTo(String value) {
  365. addCriterion("pc_id =", value, "pcId");
  366. return (Criteria) this;
  367. }
  368. public Criteria andPcIdNotEqualTo(String value) {
  369. addCriterion("pc_id <>", value, "pcId");
  370. return (Criteria) this;
  371. }
  372. public Criteria andPcIdGreaterThan(String value) {
  373. addCriterion("pc_id >", value, "pcId");
  374. return (Criteria) this;
  375. }
  376. public Criteria andPcIdGreaterThanOrEqualTo(String value) {
  377. addCriterion("pc_id >=", value, "pcId");
  378. return (Criteria) this;
  379. }
  380. public Criteria andPcIdLessThan(String value) {
  381. addCriterion("pc_id <", value, "pcId");
  382. return (Criteria) this;
  383. }
  384. public Criteria andPcIdLessThanOrEqualTo(String value) {
  385. addCriterion("pc_id <=", value, "pcId");
  386. return (Criteria) this;
  387. }
  388. public Criteria andPcIdLike(String value) {
  389. addCriterion("pc_id like", value, "pcId");
  390. return (Criteria) this;
  391. }
  392. public Criteria andPcIdNotLike(String value) {
  393. addCriterion("pc_id not like", value, "pcId");
  394. return (Criteria) this;
  395. }
  396. public Criteria andPcIdIn(List<String> values) {
  397. addCriterion("pc_id in", values, "pcId");
  398. return (Criteria) this;
  399. }
  400. public Criteria andPcIdNotIn(List<String> values) {
  401. addCriterion("pc_id not in", values, "pcId");
  402. return (Criteria) this;
  403. }
  404. public Criteria andPcIdBetween(String value1, String value2) {
  405. addCriterion("pc_id between", value1, value2, "pcId");
  406. return (Criteria) this;
  407. }
  408. public Criteria andPcIdNotBetween(String value1, String value2) {
  409. addCriterion("pc_id not between", value1, value2, "pcId");
  410. return (Criteria) this;
  411. }
  412. public Criteria andPcaIdIsNull() {
  413. addCriterion("pca_id is null");
  414. return (Criteria) this;
  415. }
  416. public Criteria andPcaIdIsNotNull() {
  417. addCriterion("pca_id is not null");
  418. return (Criteria) this;
  419. }
  420. public Criteria andPcaIdEqualTo(String value) {
  421. addCriterion("pca_id =", value, "pcaId");
  422. return (Criteria) this;
  423. }
  424. public Criteria andPcaIdNotEqualTo(String value) {
  425. addCriterion("pca_id <>", value, "pcaId");
  426. return (Criteria) this;
  427. }
  428. public Criteria andPcaIdGreaterThan(String value) {
  429. addCriterion("pca_id >", value, "pcaId");
  430. return (Criteria) this;
  431. }
  432. public Criteria andPcaIdGreaterThanOrEqualTo(String value) {
  433. addCriterion("pca_id >=", value, "pcaId");
  434. return (Criteria) this;
  435. }
  436. public Criteria andPcaIdLessThan(String value) {
  437. addCriterion("pca_id <", value, "pcaId");
  438. return (Criteria) this;
  439. }
  440. public Criteria andPcaIdLessThanOrEqualTo(String value) {
  441. addCriterion("pca_id <=", value, "pcaId");
  442. return (Criteria) this;
  443. }
  444. public Criteria andPcaIdLike(String value) {
  445. addCriterion("pca_id like", value, "pcaId");
  446. return (Criteria) this;
  447. }
  448. public Criteria andPcaIdNotLike(String value) {
  449. addCriterion("pca_id not like", value, "pcaId");
  450. return (Criteria) this;
  451. }
  452. public Criteria andPcaIdIn(List<String> values) {
  453. addCriterion("pca_id in", values, "pcaId");
  454. return (Criteria) this;
  455. }
  456. public Criteria andPcaIdNotIn(List<String> values) {
  457. addCriterion("pca_id not in", values, "pcaId");
  458. return (Criteria) this;
  459. }
  460. public Criteria andPcaIdBetween(String value1, String value2) {
  461. addCriterion("pca_id between", value1, value2, "pcaId");
  462. return (Criteria) this;
  463. }
  464. public Criteria andPcaIdNotBetween(String value1, String value2) {
  465. addCriterion("pca_id not between", value1, value2, "pcaId");
  466. return (Criteria) this;
  467. }
  468. public Criteria andCdIdIsNull() {
  469. addCriterion("cd_id is null");
  470. return (Criteria) this;
  471. }
  472. public Criteria andCdIdIsNotNull() {
  473. addCriterion("cd_id is not null");
  474. return (Criteria) this;
  475. }
  476. public Criteria andCdIdEqualTo(String value) {
  477. addCriterion("cd_id =", value, "cdId");
  478. return (Criteria) this;
  479. }
  480. public Criteria andCdIdNotEqualTo(String value) {
  481. addCriterion("cd_id <>", value, "cdId");
  482. return (Criteria) this;
  483. }
  484. public Criteria andCdIdGreaterThan(String value) {
  485. addCriterion("cd_id >", value, "cdId");
  486. return (Criteria) this;
  487. }
  488. public Criteria andCdIdGreaterThanOrEqualTo(String value) {
  489. addCriterion("cd_id >=", value, "cdId");
  490. return (Criteria) this;
  491. }
  492. public Criteria andCdIdLessThan(String value) {
  493. addCriterion("cd_id <", value, "cdId");
  494. return (Criteria) this;
  495. }
  496. public Criteria andCdIdLessThanOrEqualTo(String value) {
  497. addCriterion("cd_id <=", value, "cdId");
  498. return (Criteria) this;
  499. }
  500. public Criteria andCdIdLike(String value) {
  501. addCriterion("cd_id like", value, "cdId");
  502. return (Criteria) this;
  503. }
  504. public Criteria andCdIdNotLike(String value) {
  505. addCriterion("cd_id not like", value, "cdId");
  506. return (Criteria) this;
  507. }
  508. public Criteria andCdIdIn(List<String> values) {
  509. addCriterion("cd_id in", values, "cdId");
  510. return (Criteria) this;
  511. }
  512. public Criteria andCdIdNotIn(List<String> values) {
  513. addCriterion("cd_id not in", values, "cdId");
  514. return (Criteria) this;
  515. }
  516. public Criteria andCdIdBetween(String value1, String value2) {
  517. addCriterion("cd_id between", value1, value2, "cdId");
  518. return (Criteria) this;
  519. }
  520. public Criteria andCdIdNotBetween(String value1, String value2) {
  521. addCriterion("cd_id not between", value1, value2, "cdId");
  522. return (Criteria) this;
  523. }
  524. public Criteria andCdvIdIsNull() {
  525. addCriterion("cdv_id is null");
  526. return (Criteria) this;
  527. }
  528. public Criteria andCdvIdIsNotNull() {
  529. addCriterion("cdv_id is not null");
  530. return (Criteria) this;
  531. }
  532. public Criteria andCdvIdEqualTo(String value) {
  533. addCriterion("cdv_id =", value, "cdvId");
  534. return (Criteria) this;
  535. }
  536. public Criteria andCdvIdNotEqualTo(String value) {
  537. addCriterion("cdv_id <>", value, "cdvId");
  538. return (Criteria) this;
  539. }
  540. public Criteria andCdvIdGreaterThan(String value) {
  541. addCriterion("cdv_id >", value, "cdvId");
  542. return (Criteria) this;
  543. }
  544. public Criteria andCdvIdGreaterThanOrEqualTo(String value) {
  545. addCriterion("cdv_id >=", value, "cdvId");
  546. return (Criteria) this;
  547. }
  548. public Criteria andCdvIdLessThan(String value) {
  549. addCriterion("cdv_id <", value, "cdvId");
  550. return (Criteria) this;
  551. }
  552. public Criteria andCdvIdLessThanOrEqualTo(String value) {
  553. addCriterion("cdv_id <=", value, "cdvId");
  554. return (Criteria) this;
  555. }
  556. public Criteria andCdvIdLike(String value) {
  557. addCriterion("cdv_id like", value, "cdvId");
  558. return (Criteria) this;
  559. }
  560. public Criteria andCdvIdNotLike(String value) {
  561. addCriterion("cdv_id not like", value, "cdvId");
  562. return (Criteria) this;
  563. }
  564. public Criteria andCdvIdIn(List<String> values) {
  565. addCriterion("cdv_id in", values, "cdvId");
  566. return (Criteria) this;
  567. }
  568. public Criteria andCdvIdNotIn(List<String> values) {
  569. addCriterion("cdv_id not in", values, "cdvId");
  570. return (Criteria) this;
  571. }
  572. public Criteria andCdvIdBetween(String value1, String value2) {
  573. addCriterion("cdv_id between", value1, value2, "cdvId");
  574. return (Criteria) this;
  575. }
  576. public Criteria andCdvIdNotBetween(String value1, String value2) {
  577. addCriterion("cdv_id not between", value1, value2, "cdvId");
  578. return (Criteria) this;
  579. }
  580. public Criteria andValueIsNull() {
  581. addCriterion("value is null");
  582. return (Criteria) this;
  583. }
  584. public Criteria andValueIsNotNull() {
  585. addCriterion("value is not null");
  586. return (Criteria) this;
  587. }
  588. public Criteria andValueEqualTo(String value) {
  589. addCriterion("value =", value, "value");
  590. return (Criteria) this;
  591. }
  592. public Criteria andValueNotEqualTo(String value) {
  593. addCriterion("value <>", value, "value");
  594. return (Criteria) this;
  595. }
  596. public Criteria andValueGreaterThan(String value) {
  597. addCriterion("value >", value, "value");
  598. return (Criteria) this;
  599. }
  600. public Criteria andValueGreaterThanOrEqualTo(String value) {
  601. addCriterion("value >=", value, "value");
  602. return (Criteria) this;
  603. }
  604. public Criteria andValueLessThan(String value) {
  605. addCriterion("value <", value, "value");
  606. return (Criteria) this;
  607. }
  608. public Criteria andValueLessThanOrEqualTo(String value) {
  609. addCriterion("value <=", value, "value");
  610. return (Criteria) this;
  611. }
  612. public Criteria andValueLike(String value) {
  613. addCriterion("value like", value, "value");
  614. return (Criteria) this;
  615. }
  616. public Criteria andValueNotLike(String value) {
  617. addCriterion("value not like", value, "value");
  618. return (Criteria) this;
  619. }
  620. public Criteria andValueIn(List<String> values) {
  621. addCriterion("value in", values, "value");
  622. return (Criteria) this;
  623. }
  624. public Criteria andValueNotIn(List<String> values) {
  625. addCriterion("value not in", values, "value");
  626. return (Criteria) this;
  627. }
  628. public Criteria andValueBetween(String value1, String value2) {
  629. addCriterion("value between", value1, value2, "value");
  630. return (Criteria) this;
  631. }
  632. public Criteria andValueNotBetween(String value1, String value2) {
  633. addCriterion("value not between", value1, value2, "value");
  634. return (Criteria) this;
  635. }
  636. public Criteria andUnitIsNull() {
  637. addCriterion("unit is null");
  638. return (Criteria) this;
  639. }
  640. public Criteria andUnitIsNotNull() {
  641. addCriterion("unit is not null");
  642. return (Criteria) this;
  643. }
  644. public Criteria andUnitEqualTo(String value) {
  645. addCriterion("unit =", value, "unit");
  646. return (Criteria) this;
  647. }
  648. public Criteria andUnitNotEqualTo(String value) {
  649. addCriterion("unit <>", value, "unit");
  650. return (Criteria) this;
  651. }
  652. public Criteria andUnitGreaterThan(String value) {
  653. addCriterion("unit >", value, "unit");
  654. return (Criteria) this;
  655. }
  656. public Criteria andUnitGreaterThanOrEqualTo(String value) {
  657. addCriterion("unit >=", value, "unit");
  658. return (Criteria) this;
  659. }
  660. public Criteria andUnitLessThan(String value) {
  661. addCriterion("unit <", value, "unit");
  662. return (Criteria) this;
  663. }
  664. public Criteria andUnitLessThanOrEqualTo(String value) {
  665. addCriterion("unit <=", value, "unit");
  666. return (Criteria) this;
  667. }
  668. public Criteria andUnitLike(String value) {
  669. addCriterion("unit like", value, "unit");
  670. return (Criteria) this;
  671. }
  672. public Criteria andUnitNotLike(String value) {
  673. addCriterion("unit not like", value, "unit");
  674. return (Criteria) this;
  675. }
  676. public Criteria andUnitIn(List<String> values) {
  677. addCriterion("unit in", values, "unit");
  678. return (Criteria) this;
  679. }
  680. public Criteria andUnitNotIn(List<String> values) {
  681. addCriterion("unit not in", values, "unit");
  682. return (Criteria) this;
  683. }
  684. public Criteria andUnitBetween(String value1, String value2) {
  685. addCriterion("unit between", value1, value2, "unit");
  686. return (Criteria) this;
  687. }
  688. public Criteria andUnitNotBetween(String value1, String value2) {
  689. addCriterion("unit not between", value1, value2, "unit");
  690. return (Criteria) this;
  691. }
  692. public Criteria andSerIsNull() {
  693. addCriterion("ser is null");
  694. return (Criteria) this;
  695. }
  696. public Criteria andSerIsNotNull() {
  697. addCriterion("ser is not null");
  698. return (Criteria) this;
  699. }
  700. public Criteria andSerEqualTo(Integer value) {
  701. addCriterion("ser =", value, "ser");
  702. return (Criteria) this;
  703. }
  704. public Criteria andSerNotEqualTo(Integer value) {
  705. addCriterion("ser <>", value, "ser");
  706. return (Criteria) this;
  707. }
  708. public Criteria andSerGreaterThan(Integer value) {
  709. addCriterion("ser >", value, "ser");
  710. return (Criteria) this;
  711. }
  712. public Criteria andSerGreaterThanOrEqualTo(Integer value) {
  713. addCriterion("ser >=", value, "ser");
  714. return (Criteria) this;
  715. }
  716. public Criteria andSerLessThan(Integer value) {
  717. addCriterion("ser <", value, "ser");
  718. return (Criteria) this;
  719. }
  720. public Criteria andSerLessThanOrEqualTo(Integer value) {
  721. addCriterion("ser <=", value, "ser");
  722. return (Criteria) this;
  723. }
  724. public Criteria andSerIn(List<Integer> values) {
  725. addCriterion("ser in", values, "ser");
  726. return (Criteria) this;
  727. }
  728. public Criteria andSerNotIn(List<Integer> values) {
  729. addCriterion("ser not in", values, "ser");
  730. return (Criteria) this;
  731. }
  732. public Criteria andSerBetween(Integer value1, Integer value2) {
  733. addCriterion("ser between", value1, value2, "ser");
  734. return (Criteria) this;
  735. }
  736. public Criteria andSerNotBetween(Integer value1, Integer value2) {
  737. addCriterion("ser not between", value1, value2, "ser");
  738. return (Criteria) this;
  739. }
  740. public Criteria andUidIsNull() {
  741. addCriterion("uid is null");
  742. return (Criteria) this;
  743. }
  744. public Criteria andUidIsNotNull() {
  745. addCriterion("uid is not null");
  746. return (Criteria) this;
  747. }
  748. public Criteria andUidEqualTo(String value) {
  749. addCriterion("uid =", value, "uid");
  750. return (Criteria) this;
  751. }
  752. public Criteria andUidNotEqualTo(String value) {
  753. addCriterion("uid <>", value, "uid");
  754. return (Criteria) this;
  755. }
  756. public Criteria andUidGreaterThan(String value) {
  757. addCriterion("uid >", value, "uid");
  758. return (Criteria) this;
  759. }
  760. public Criteria andUidGreaterThanOrEqualTo(String value) {
  761. addCriterion("uid >=", value, "uid");
  762. return (Criteria) this;
  763. }
  764. public Criteria andUidLessThan(String value) {
  765. addCriterion("uid <", value, "uid");
  766. return (Criteria) this;
  767. }
  768. public Criteria andUidLessThanOrEqualTo(String value) {
  769. addCriterion("uid <=", value, "uid");
  770. return (Criteria) this;
  771. }
  772. public Criteria andUidLike(String value) {
  773. addCriterion("uid like", value, "uid");
  774. return (Criteria) this;
  775. }
  776. public Criteria andUidNotLike(String value) {
  777. addCriterion("uid not like", value, "uid");
  778. return (Criteria) this;
  779. }
  780. public Criteria andUidIn(List<String> values) {
  781. addCriterion("uid in", values, "uid");
  782. return (Criteria) this;
  783. }
  784. public Criteria andUidNotIn(List<String> values) {
  785. addCriterion("uid not in", values, "uid");
  786. return (Criteria) this;
  787. }
  788. public Criteria andUidBetween(String value1, String value2) {
  789. addCriterion("uid between", value1, value2, "uid");
  790. return (Criteria) this;
  791. }
  792. public Criteria andUidNotBetween(String value1, String value2) {
  793. addCriterion("uid not between", value1, value2, "uid");
  794. return (Criteria) this;
  795. }
  796. public Criteria andRemarkIsNull() {
  797. addCriterion("remark is null");
  798. return (Criteria) this;
  799. }
  800. public Criteria andRemarkIsNotNull() {
  801. addCriterion("remark is not null");
  802. return (Criteria) this;
  803. }
  804. public Criteria andRemarkEqualTo(String value) {
  805. addCriterion("remark =", value, "remark");
  806. return (Criteria) this;
  807. }
  808. public Criteria andRemarkNotEqualTo(String value) {
  809. addCriterion("remark <>", value, "remark");
  810. return (Criteria) this;
  811. }
  812. public Criteria andRemarkGreaterThan(String value) {
  813. addCriterion("remark >", value, "remark");
  814. return (Criteria) this;
  815. }
  816. public Criteria andRemarkGreaterThanOrEqualTo(String value) {
  817. addCriterion("remark >=", value, "remark");
  818. return (Criteria) this;
  819. }
  820. public Criteria andRemarkLessThan(String value) {
  821. addCriterion("remark <", value, "remark");
  822. return (Criteria) this;
  823. }
  824. public Criteria andRemarkLessThanOrEqualTo(String value) {
  825. addCriterion("remark <=", value, "remark");
  826. return (Criteria) this;
  827. }
  828. public Criteria andRemarkLike(String value) {
  829. addCriterion("remark like", value, "remark");
  830. return (Criteria) this;
  831. }
  832. public Criteria andRemarkNotLike(String value) {
  833. addCriterion("remark not like", value, "remark");
  834. return (Criteria) this;
  835. }
  836. public Criteria andRemarkIn(List<String> values) {
  837. addCriterion("remark in", values, "remark");
  838. return (Criteria) this;
  839. }
  840. public Criteria andRemarkNotIn(List<String> values) {
  841. addCriterion("remark not in", values, "remark");
  842. return (Criteria) this;
  843. }
  844. public Criteria andRemarkBetween(String value1, String value2) {
  845. addCriterion("remark between", value1, value2, "remark");
  846. return (Criteria) this;
  847. }
  848. public Criteria andRemarkNotBetween(String value1, String value2) {
  849. addCriterion("remark not between", value1, value2, "remark");
  850. return (Criteria) this;
  851. }
  852. public Criteria andCreateTimeIsNull() {
  853. addCriterion("create_time is null");
  854. return (Criteria) this;
  855. }
  856. public Criteria andCreateTimeIsNotNull() {
  857. addCriterion("create_time is not null");
  858. return (Criteria) this;
  859. }
  860. public Criteria andCreateTimeEqualTo(Date value) {
  861. addCriterion("create_time =", value, "createTime");
  862. return (Criteria) this;
  863. }
  864. public Criteria andCreateTimeNotEqualTo(Date value) {
  865. addCriterion("create_time <>", value, "createTime");
  866. return (Criteria) this;
  867. }
  868. public Criteria andCreateTimeGreaterThan(Date value) {
  869. addCriterion("create_time >", value, "createTime");
  870. return (Criteria) this;
  871. }
  872. public Criteria andCreateTimeGreaterThanOrEqualTo(Date value) {
  873. addCriterion("create_time >=", value, "createTime");
  874. return (Criteria) this;
  875. }
  876. public Criteria andCreateTimeLessThan(Date value) {
  877. addCriterion("create_time <", value, "createTime");
  878. return (Criteria) this;
  879. }
  880. public Criteria andCreateTimeLessThanOrEqualTo(Date value) {
  881. addCriterion("create_time <=", value, "createTime");
  882. return (Criteria) this;
  883. }
  884. public Criteria andCreateTimeIn(List<Date> values) {
  885. addCriterion("create_time in", values, "createTime");
  886. return (Criteria) this;
  887. }
  888. public Criteria andCreateTimeNotIn(List<Date> values) {
  889. addCriterion("create_time not in", values, "createTime");
  890. return (Criteria) this;
  891. }
  892. public Criteria andCreateTimeBetween(Date value1, Date value2) {
  893. addCriterion("create_time between", value1, value2, "createTime");
  894. return (Criteria) this;
  895. }
  896. public Criteria andCreateTimeNotBetween(Date value1, Date value2) {
  897. addCriterion("create_time not between", value1, value2, "createTime");
  898. return (Criteria) this;
  899. }
  900. public Criteria andUpdateTimeIsNull() {
  901. addCriterion("update_time is null");
  902. return (Criteria) this;
  903. }
  904. public Criteria andUpdateTimeIsNotNull() {
  905. addCriterion("update_time is not null");
  906. return (Criteria) this;
  907. }
  908. public Criteria andUpdateTimeEqualTo(Date value) {
  909. addCriterion("update_time =", value, "updateTime");
  910. return (Criteria) this;
  911. }
  912. public Criteria andUpdateTimeNotEqualTo(Date value) {
  913. addCriterion("update_time <>", value, "updateTime");
  914. return (Criteria) this;
  915. }
  916. public Criteria andUpdateTimeGreaterThan(Date value) {
  917. addCriterion("update_time >", value, "updateTime");
  918. return (Criteria) this;
  919. }
  920. public Criteria andUpdateTimeGreaterThanOrEqualTo(Date value) {
  921. addCriterion("update_time >=", value, "updateTime");
  922. return (Criteria) this;
  923. }
  924. public Criteria andUpdateTimeLessThan(Date value) {
  925. addCriterion("update_time <", value, "updateTime");
  926. return (Criteria) this;
  927. }
  928. public Criteria andUpdateTimeLessThanOrEqualTo(Date value) {
  929. addCriterion("update_time <=", value, "updateTime");
  930. return (Criteria) this;
  931. }
  932. public Criteria andUpdateTimeIn(List<Date> values) {
  933. addCriterion("update_time in", values, "updateTime");
  934. return (Criteria) this;
  935. }
  936. public Criteria andUpdateTimeNotIn(List<Date> values) {
  937. addCriterion("update_time not in", values, "updateTime");
  938. return (Criteria) this;
  939. }
  940. public Criteria andUpdateTimeBetween(Date value1, Date value2) {
  941. addCriterion("update_time between", value1, value2, "updateTime");
  942. return (Criteria) this;
  943. }
  944. public Criteria andUpdateTimeNotBetween(Date value1, Date value2) {
  945. addCriterion("update_time not between", value1, value2, "updateTime");
  946. return (Criteria) this;
  947. }
  948. }
  949. public static class Criteria extends GeneratedCriteria {
  950. protected Criteria() {
  951. super();
  952. }
  953. }
  954. public static class Criterion {
  955. private String condition;
  956. private Object value;
  957. private Object secondValue;
  958. private boolean noValue;
  959. private boolean singleValue;
  960. private boolean betweenValue;
  961. private boolean listValue;
  962. private String typeHandler;
  963. public String getCondition() {
  964. return condition;
  965. }
  966. public Object getValue() {
  967. return value;
  968. }
  969. public Object getSecondValue() {
  970. return secondValue;
  971. }
  972. public boolean isNoValue() {
  973. return noValue;
  974. }
  975. public boolean isSingleValue() {
  976. return singleValue;
  977. }
  978. public boolean isBetweenValue() {
  979. return betweenValue;
  980. }
  981. public boolean isListValue() {
  982. return listValue;
  983. }
  984. public String getTypeHandler() {
  985. return typeHandler;
  986. }
  987. protected Criterion(String condition) {
  988. super();
  989. this.condition = condition;
  990. this.typeHandler = null;
  991. this.noValue = true;
  992. }
  993. protected Criterion(String condition, Object value, String typeHandler) {
  994. super();
  995. this.condition = condition;
  996. this.value = value;
  997. this.typeHandler = typeHandler;
  998. if (value instanceof List<?>) {
  999. this.listValue = true;
  1000. } else {
  1001. this.singleValue = true;
  1002. }
  1003. }
  1004. protected Criterion(String condition, Object value) {
  1005. this(condition, value, null);
  1006. }
  1007. protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
  1008. super();
  1009. this.condition = condition;
  1010. this.value = value;
  1011. this.secondValue = secondValue;
  1012. this.typeHandler = typeHandler;
  1013. this.betweenValue = true;
  1014. }
  1015. protected Criterion(String condition, Object value, Object secondValue) {
  1016. this(condition, value, secondValue, null);
  1017. }
  1018. }
  1019. }