WsclSbztbgExample.java 18 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593
  1. package com.huimv.wscl.dataobject;
  2. import java.util.ArrayList;
  3. import java.util.HashMap;
  4. import java.util.List;
  5. import java.util.Map;
  6. public class WsclSbztbgExample {
  7. /**
  8. * This field was generated by Apache iBATIS ibator.
  9. * This field corresponds to the database table wscl_sbztbg
  10. *
  11. * @ibatorgenerated Mon Jul 29 16:24:45 CST 2019
  12. */
  13. protected String orderByClause;
  14. /**
  15. * This field was generated by Apache iBATIS ibator.
  16. * This field corresponds to the database table wscl_sbztbg
  17. *
  18. * @ibatorgenerated Mon Jul 29 16:24:45 CST 2019
  19. */
  20. protected List<Criteria> oredCriteria;
  21. /**
  22. * This field was generated by Apache iBATIS ibator.
  23. * This field corresponds to the database table wscl_sbztbg
  24. *
  25. * @ibatorgenerated Mon Jul 29 16:24:45 CST 2019
  26. */
  27. protected int start = -1;
  28. /**
  29. * This field was generated by Apache iBATIS ibator.
  30. * This field corresponds to the database table wscl_sbztbg
  31. *
  32. * @ibatorgenerated Mon Jul 29 16:24:45 CST 2019
  33. */
  34. protected int limit = -1;
  35. /**
  36. * This method was generated by Apache iBATIS ibator.
  37. * This method corresponds to the database table wscl_sbztbg
  38. *
  39. * @ibatorgenerated Mon Jul 29 16:24:45 CST 2019
  40. */
  41. public WsclSbztbgExample() {
  42. oredCriteria = new ArrayList<Criteria>();
  43. }
  44. /**
  45. * This method was generated by Apache iBATIS ibator.
  46. * This method corresponds to the database table wscl_sbztbg
  47. *
  48. * @ibatorgenerated Mon Jul 29 16:24:45 CST 2019
  49. */
  50. protected WsclSbztbgExample(WsclSbztbgExample example) {
  51. this.orderByClause = example.orderByClause;
  52. this.oredCriteria = example.oredCriteria;
  53. }
  54. /**
  55. * This method was generated by Apache iBATIS ibator.
  56. * This method corresponds to the database table wscl_sbztbg
  57. *
  58. * @ibatorgenerated Mon Jul 29 16:24:45 CST 2019
  59. */
  60. public void setOrderByClause(String orderByClause) {
  61. this.orderByClause = orderByClause;
  62. }
  63. /**
  64. * This method was generated by Apache iBATIS ibator.
  65. * This method corresponds to the database table wscl_sbztbg
  66. *
  67. * @ibatorgenerated Mon Jul 29 16:24:45 CST 2019
  68. */
  69. public String getOrderByClause() {
  70. return orderByClause;
  71. }
  72. /**
  73. * This method was generated by Apache iBATIS ibator.
  74. * This method corresponds to the database table wscl_sbztbg
  75. *
  76. * @ibatorgenerated Mon Jul 29 16:24:45 CST 2019
  77. */
  78. public List<Criteria> getOredCriteria() {
  79. return oredCriteria;
  80. }
  81. /**
  82. * This method was generated by Apache iBATIS ibator.
  83. * This method corresponds to the database table wscl_sbztbg
  84. *
  85. * @ibatorgenerated Mon Jul 29 16:24:45 CST 2019
  86. */
  87. public void or(Criteria criteria) {
  88. oredCriteria.add(criteria);
  89. }
  90. /**
  91. * This method was generated by Apache iBATIS ibator.
  92. * This method corresponds to the database table wscl_sbztbg
  93. *
  94. * @ibatorgenerated Mon Jul 29 16:24:45 CST 2019
  95. */
  96. public Criteria createCriteria() {
  97. Criteria criteria = createCriteriaInternal();
  98. if (oredCriteria.size() == 0) {
  99. oredCriteria.add(criteria);
  100. }
  101. return criteria;
  102. }
  103. /**
  104. * This method was generated by Apache iBATIS ibator.
  105. * This method corresponds to the database table wscl_sbztbg
  106. *
  107. * @ibatorgenerated Mon Jul 29 16:24:45 CST 2019
  108. */
  109. protected Criteria createCriteriaInternal() {
  110. Criteria criteria = new Criteria();
  111. return criteria;
  112. }
  113. /**
  114. * This method was generated by Apache iBATIS ibator.
  115. * This method corresponds to the database table wscl_sbztbg
  116. *
  117. * @ibatorgenerated Mon Jul 29 16:24:45 CST 2019
  118. */
  119. public void clear() {
  120. oredCriteria.clear();
  121. }
  122. /**
  123. * This method was generated by Apache iBATIS ibator.
  124. * This method corresponds to the database table wscl_sbztbg
  125. *
  126. * @ibatorgenerated Mon Jul 29 16:24:45 CST 2019
  127. */
  128. public void setStart(int start) {
  129. this.start=start;
  130. }
  131. /**
  132. * This method was generated by Apache iBATIS ibator.
  133. * This method corresponds to the database table wscl_sbztbg
  134. *
  135. * @ibatorgenerated Mon Jul 29 16:24:45 CST 2019
  136. */
  137. public int getStart() {
  138. return start;
  139. }
  140. /**
  141. * This method was generated by Apache iBATIS ibator.
  142. * This method corresponds to the database table wscl_sbztbg
  143. *
  144. * @ibatorgenerated Mon Jul 29 16:24:45 CST 2019
  145. */
  146. public void setLimit(int limit) {
  147. this.limit=limit;
  148. }
  149. /**
  150. * This method was generated by Apache iBATIS ibator.
  151. * This method corresponds to the database table wscl_sbztbg
  152. *
  153. * @ibatorgenerated Mon Jul 29 16:24:45 CST 2019
  154. */
  155. public int getLimit() {
  156. return limit;
  157. }
  158. /**
  159. * This class was generated by Apache iBATIS ibator.
  160. * This class corresponds to the database table wscl_sbztbg
  161. *
  162. * @ibatorgenerated Mon Jul 29 16:24:45 CST 2019
  163. */
  164. public static class Criteria {
  165. protected List<String> criteriaWithoutValue;
  166. protected List<Map<String, Object>> criteriaWithSingleValue;
  167. protected List<Map<String, Object>> criteriaWithListValue;
  168. protected List<Map<String, Object>> criteriaWithBetweenValue;
  169. protected Criteria() {
  170. super();
  171. criteriaWithoutValue = new ArrayList<String>();
  172. criteriaWithSingleValue = new ArrayList<Map<String, Object>>();
  173. criteriaWithListValue = new ArrayList<Map<String, Object>>();
  174. criteriaWithBetweenValue = new ArrayList<Map<String, Object>>();
  175. }
  176. public boolean isValid() {
  177. return criteriaWithoutValue.size() > 0
  178. || criteriaWithSingleValue.size() > 0
  179. || criteriaWithListValue.size() > 0
  180. || criteriaWithBetweenValue.size() > 0;
  181. }
  182. public List<String> getCriteriaWithoutValue() {
  183. return criteriaWithoutValue;
  184. }
  185. public List<Map<String, Object>> getCriteriaWithSingleValue() {
  186. return criteriaWithSingleValue;
  187. }
  188. public List<Map<String, Object>> getCriteriaWithListValue() {
  189. return criteriaWithListValue;
  190. }
  191. public List<Map<String, Object>> getCriteriaWithBetweenValue() {
  192. return criteriaWithBetweenValue;
  193. }
  194. protected void addCriterion(String condition) {
  195. if (condition == null) {
  196. throw new RuntimeException("Value for condition cannot be null");
  197. }
  198. criteriaWithoutValue.add(condition);
  199. }
  200. protected void addCriterion(String condition, Object value, String property) {
  201. if (value == null) {
  202. throw new RuntimeException("Value for " + property + " cannot be null");
  203. }
  204. Map<String, Object> map = new HashMap<String, Object>();
  205. map.put("condition", condition);
  206. map.put("value", value);
  207. criteriaWithSingleValue.add(map);
  208. }
  209. protected void addCriterion(String condition, List<? extends Object> values, String property) {
  210. if (values == null || values.size() == 0) {
  211. throw new RuntimeException("Value list for " + property + " cannot be null or empty");
  212. }
  213. Map<String, Object> map = new HashMap<String, Object>();
  214. map.put("condition", condition);
  215. map.put("values", values);
  216. criteriaWithListValue.add(map);
  217. }
  218. protected void addCriterion(String condition, Object value1, Object value2, String property) {
  219. if (value1 == null || value2 == null) {
  220. throw new RuntimeException("Between values for " + property + " cannot be null");
  221. }
  222. List<Object> list = new ArrayList<Object>();
  223. list.add(value1);
  224. list.add(value2);
  225. Map<String, Object> map = new HashMap<String, Object>();
  226. map.put("condition", condition);
  227. map.put("values", list);
  228. criteriaWithBetweenValue.add(map);
  229. }
  230. public Criteria andIdIsNull() {
  231. addCriterion("ID is null");
  232. return this;
  233. }
  234. public Criteria andIdIsNotNull() {
  235. addCriterion("ID is not null");
  236. return this;
  237. }
  238. public Criteria andIdEqualTo(Integer value) {
  239. addCriterion("ID =", value, "id");
  240. return this;
  241. }
  242. public Criteria andIdNotEqualTo(Integer value) {
  243. addCriterion("ID <>", value, "id");
  244. return this;
  245. }
  246. public Criteria andIdGreaterThan(Integer value) {
  247. addCriterion("ID >", value, "id");
  248. return this;
  249. }
  250. public Criteria andIdGreaterThanOrEqualTo(Integer value) {
  251. addCriterion("ID >=", value, "id");
  252. return this;
  253. }
  254. public Criteria andIdLessThan(Integer value) {
  255. addCriterion("ID <", value, "id");
  256. return this;
  257. }
  258. public Criteria andIdLessThanOrEqualTo(Integer value) {
  259. addCriterion("ID <=", value, "id");
  260. return this;
  261. }
  262. public Criteria andIdIn(List<Integer> values) {
  263. addCriterion("ID in", values, "id");
  264. return this;
  265. }
  266. public Criteria andIdNotIn(List<Integer> values) {
  267. addCriterion("ID not in", values, "id");
  268. return this;
  269. }
  270. public Criteria andIdBetween(Integer value1, Integer value2) {
  271. addCriterion("ID between", value1, value2, "id");
  272. return this;
  273. }
  274. public Criteria andIdNotBetween(Integer value1, Integer value2) {
  275. addCriterion("ID not between", value1, value2, "id");
  276. return this;
  277. }
  278. public Criteria andMcidIsNull() {
  279. addCriterion("MCID is null");
  280. return this;
  281. }
  282. public Criteria andMcidIsNotNull() {
  283. addCriterion("MCID is not null");
  284. return this;
  285. }
  286. public Criteria andMcidEqualTo(Integer value) {
  287. addCriterion("MCID =", value, "mcid");
  288. return this;
  289. }
  290. public Criteria andMcidNotEqualTo(Integer value) {
  291. addCriterion("MCID <>", value, "mcid");
  292. return this;
  293. }
  294. public Criteria andMcidGreaterThan(Integer value) {
  295. addCriterion("MCID >", value, "mcid");
  296. return this;
  297. }
  298. public Criteria andMcidGreaterThanOrEqualTo(Integer value) {
  299. addCriterion("MCID >=", value, "mcid");
  300. return this;
  301. }
  302. public Criteria andMcidLessThan(Integer value) {
  303. addCriterion("MCID <", value, "mcid");
  304. return this;
  305. }
  306. public Criteria andMcidLessThanOrEqualTo(Integer value) {
  307. addCriterion("MCID <=", value, "mcid");
  308. return this;
  309. }
  310. public Criteria andMcidIn(List<Integer> values) {
  311. addCriterion("MCID in", values, "mcid");
  312. return this;
  313. }
  314. public Criteria andMcidNotIn(List<Integer> values) {
  315. addCriterion("MCID not in", values, "mcid");
  316. return this;
  317. }
  318. public Criteria andMcidBetween(Integer value1, Integer value2) {
  319. addCriterion("MCID between", value1, value2, "mcid");
  320. return this;
  321. }
  322. public Criteria andMcidNotBetween(Integer value1, Integer value2) {
  323. addCriterion("MCID not between", value1, value2, "mcid");
  324. return this;
  325. }
  326. public Criteria andTablenameIsNull() {
  327. addCriterion("TABLENAME is null");
  328. return this;
  329. }
  330. public Criteria andTablenameIsNotNull() {
  331. addCriterion("TABLENAME is not null");
  332. return this;
  333. }
  334. public Criteria andTablenameEqualTo(String value) {
  335. addCriterion("TABLENAME =", value, "tablename");
  336. return this;
  337. }
  338. public Criteria andTablenameNotEqualTo(String value) {
  339. addCriterion("TABLENAME <>", value, "tablename");
  340. return this;
  341. }
  342. public Criteria andTablenameGreaterThan(String value) {
  343. addCriterion("TABLENAME >", value, "tablename");
  344. return this;
  345. }
  346. public Criteria andTablenameGreaterThanOrEqualTo(String value) {
  347. addCriterion("TABLENAME >=", value, "tablename");
  348. return this;
  349. }
  350. public Criteria andTablenameLessThan(String value) {
  351. addCriterion("TABLENAME <", value, "tablename");
  352. return this;
  353. }
  354. public Criteria andTablenameLessThanOrEqualTo(String value) {
  355. addCriterion("TABLENAME <=", value, "tablename");
  356. return this;
  357. }
  358. public Criteria andTablenameLike(String value) {
  359. addCriterion("TABLENAME like", value, "tablename");
  360. return this;
  361. }
  362. public Criteria andTablenameNotLike(String value) {
  363. addCriterion("TABLENAME not like", value, "tablename");
  364. return this;
  365. }
  366. public Criteria andTablenameIn(List<String> values) {
  367. addCriterion("TABLENAME in", values, "tablename");
  368. return this;
  369. }
  370. public Criteria andTablenameNotIn(List<String> values) {
  371. addCriterion("TABLENAME not in", values, "tablename");
  372. return this;
  373. }
  374. public Criteria andTablenameBetween(String value1, String value2) {
  375. addCriterion("TABLENAME between", value1, value2, "tablename");
  376. return this;
  377. }
  378. public Criteria andTablenameNotBetween(String value1, String value2) {
  379. addCriterion("TABLENAME not between", value1, value2, "tablename");
  380. return this;
  381. }
  382. public Criteria andSbkeyIsNull() {
  383. addCriterion("SBKEY is null");
  384. return this;
  385. }
  386. public Criteria andSbkeyIsNotNull() {
  387. addCriterion("SBKEY is not null");
  388. return this;
  389. }
  390. public Criteria andSbkeyEqualTo(String value) {
  391. addCriterion("SBKEY =", value, "sbkey");
  392. return this;
  393. }
  394. public Criteria andSbkeyNotEqualTo(String value) {
  395. addCriterion("SBKEY <>", value, "sbkey");
  396. return this;
  397. }
  398. public Criteria andSbkeyGreaterThan(String value) {
  399. addCriterion("SBKEY >", value, "sbkey");
  400. return this;
  401. }
  402. public Criteria andSbkeyGreaterThanOrEqualTo(String value) {
  403. addCriterion("SBKEY >=", value, "sbkey");
  404. return this;
  405. }
  406. public Criteria andSbkeyLessThan(String value) {
  407. addCriterion("SBKEY <", value, "sbkey");
  408. return this;
  409. }
  410. public Criteria andSbkeyLessThanOrEqualTo(String value) {
  411. addCriterion("SBKEY <=", value, "sbkey");
  412. return this;
  413. }
  414. public Criteria andSbkeyLike(String value) {
  415. addCriterion("SBKEY like", value, "sbkey");
  416. return this;
  417. }
  418. public Criteria andSbkeyNotLike(String value) {
  419. addCriterion("SBKEY not like", value, "sbkey");
  420. return this;
  421. }
  422. public Criteria andSbkeyIn(List<String> values) {
  423. addCriterion("SBKEY in", values, "sbkey");
  424. return this;
  425. }
  426. public Criteria andSbkeyNotIn(List<String> values) {
  427. addCriterion("SBKEY not in", values, "sbkey");
  428. return this;
  429. }
  430. public Criteria andSbkeyBetween(String value1, String value2) {
  431. addCriterion("SBKEY between", value1, value2, "sbkey");
  432. return this;
  433. }
  434. public Criteria andSbkeyNotBetween(String value1, String value2) {
  435. addCriterion("SBKEY not between", value1, value2, "sbkey");
  436. return this;
  437. }
  438. public Criteria andKeyvalIsNull() {
  439. addCriterion("KEYVAL is null");
  440. return this;
  441. }
  442. public Criteria andKeyvalIsNotNull() {
  443. addCriterion("KEYVAL is not null");
  444. return this;
  445. }
  446. public Criteria andKeyvalEqualTo(String value) {
  447. addCriterion("KEYVAL =", value, "keyval");
  448. return this;
  449. }
  450. public Criteria andKeyvalNotEqualTo(String value) {
  451. addCriterion("KEYVAL <>", value, "keyval");
  452. return this;
  453. }
  454. public Criteria andKeyvalGreaterThan(String value) {
  455. addCriterion("KEYVAL >", value, "keyval");
  456. return this;
  457. }
  458. public Criteria andKeyvalGreaterThanOrEqualTo(String value) {
  459. addCriterion("KEYVAL >=", value, "keyval");
  460. return this;
  461. }
  462. public Criteria andKeyvalLessThan(String value) {
  463. addCriterion("KEYVAL <", value, "keyval");
  464. return this;
  465. }
  466. public Criteria andKeyvalLessThanOrEqualTo(String value) {
  467. addCriterion("KEYVAL <=", value, "keyval");
  468. return this;
  469. }
  470. public Criteria andKeyvalLike(String value) {
  471. addCriterion("KEYVAL like", value, "keyval");
  472. return this;
  473. }
  474. public Criteria andKeyvalNotLike(String value) {
  475. addCriterion("KEYVAL not like", value, "keyval");
  476. return this;
  477. }
  478. public Criteria andKeyvalIn(List<String> values) {
  479. addCriterion("KEYVAL in", values, "keyval");
  480. return this;
  481. }
  482. public Criteria andKeyvalNotIn(List<String> values) {
  483. addCriterion("KEYVAL not in", values, "keyval");
  484. return this;
  485. }
  486. public Criteria andKeyvalBetween(String value1, String value2) {
  487. addCriterion("KEYVAL between", value1, value2, "keyval");
  488. return this;
  489. }
  490. public Criteria andKeyvalNotBetween(String value1, String value2) {
  491. addCriterion("KEYVAL not between", value1, value2, "keyval");
  492. return this;
  493. }
  494. }
  495. }