SysDeptExample.java 38 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233
  1. package com.platform.yijia.pojo;
  2. import java.util.ArrayList;
  3. import java.util.Date;
  4. import java.util.List;
  5. public class SysDeptExample {
  6. /**
  7. * This field was generated by MyBatis Generator.
  8. * This field corresponds to the database table sys_dept
  9. *
  10. * @mbg.generated
  11. */
  12. protected String orderByClause;
  13. /**
  14. * This field was generated by MyBatis Generator.
  15. * This field corresponds to the database table sys_dept
  16. *
  17. * @mbg.generated
  18. */
  19. protected boolean distinct;
  20. /**
  21. * This field was generated by MyBatis Generator.
  22. * This field corresponds to the database table sys_dept
  23. *
  24. * @mbg.generated
  25. */
  26. protected List<Criteria> oredCriteria;
  27. /**
  28. * This method was generated by MyBatis Generator.
  29. * This method corresponds to the database table sys_dept
  30. *
  31. * @mbg.generated
  32. */
  33. public SysDeptExample() {
  34. oredCriteria = new ArrayList<Criteria>();
  35. }
  36. /**
  37. * This method was generated by MyBatis Generator.
  38. * This method corresponds to the database table sys_dept
  39. *
  40. * @mbg.generated
  41. */
  42. public void setOrderByClause(String orderByClause) {
  43. this.orderByClause = orderByClause;
  44. }
  45. /**
  46. * This method was generated by MyBatis Generator.
  47. * This method corresponds to the database table sys_dept
  48. *
  49. * @mbg.generated
  50. */
  51. public String getOrderByClause() {
  52. return orderByClause;
  53. }
  54. /**
  55. * This method was generated by MyBatis Generator.
  56. * This method corresponds to the database table sys_dept
  57. *
  58. * @mbg.generated
  59. */
  60. public void setDistinct(boolean distinct) {
  61. this.distinct = distinct;
  62. }
  63. /**
  64. * This method was generated by MyBatis Generator.
  65. * This method corresponds to the database table sys_dept
  66. *
  67. * @mbg.generated
  68. */
  69. public boolean isDistinct() {
  70. return distinct;
  71. }
  72. /**
  73. * This method was generated by MyBatis Generator.
  74. * This method corresponds to the database table sys_dept
  75. *
  76. * @mbg.generated
  77. */
  78. public List<Criteria> getOredCriteria() {
  79. return oredCriteria;
  80. }
  81. /**
  82. * This method was generated by MyBatis Generator.
  83. * This method corresponds to the database table sys_dept
  84. *
  85. * @mbg.generated
  86. */
  87. public void or(Criteria criteria) {
  88. oredCriteria.add(criteria);
  89. }
  90. /**
  91. * This method was generated by MyBatis Generator.
  92. * This method corresponds to the database table sys_dept
  93. *
  94. * @mbg.generated
  95. */
  96. public Criteria or() {
  97. Criteria criteria = createCriteriaInternal();
  98. oredCriteria.add(criteria);
  99. return criteria;
  100. }
  101. /**
  102. * This method was generated by MyBatis Generator.
  103. * This method corresponds to the database table sys_dept
  104. *
  105. * @mbg.generated
  106. */
  107. public Criteria createCriteria() {
  108. Criteria criteria = createCriteriaInternal();
  109. if (oredCriteria.size() == 0) {
  110. oredCriteria.add(criteria);
  111. }
  112. return criteria;
  113. }
  114. /**
  115. * This method was generated by MyBatis Generator.
  116. * This method corresponds to the database table sys_dept
  117. *
  118. * @mbg.generated
  119. */
  120. protected Criteria createCriteriaInternal() {
  121. Criteria criteria = new Criteria();
  122. return criteria;
  123. }
  124. /**
  125. * This method was generated by MyBatis Generator.
  126. * This method corresponds to the database table sys_dept
  127. *
  128. * @mbg.generated
  129. */
  130. public void clear() {
  131. oredCriteria.clear();
  132. orderByClause = null;
  133. distinct = false;
  134. }
  135. /**
  136. * This class was generated by MyBatis Generator.
  137. * This class corresponds to the database table sys_dept
  138. *
  139. * @mbg.generated
  140. */
  141. protected abstract static class GeneratedCriteria {
  142. protected List<Criterion> criteria;
  143. protected GeneratedCriteria() {
  144. super();
  145. criteria = new ArrayList<Criterion>();
  146. }
  147. public boolean isValid() {
  148. return criteria.size() > 0;
  149. }
  150. public List<Criterion> getAllCriteria() {
  151. return criteria;
  152. }
  153. public List<Criterion> getCriteria() {
  154. return criteria;
  155. }
  156. protected void addCriterion(String condition) {
  157. if (condition == null) {
  158. throw new RuntimeException("Value for condition cannot be null");
  159. }
  160. criteria.add(new Criterion(condition));
  161. }
  162. protected void addCriterion(String condition, Object value, String property) {
  163. if (value == null) {
  164. throw new RuntimeException("Value for " + property + " cannot be null");
  165. }
  166. criteria.add(new Criterion(condition, value));
  167. }
  168. protected void addCriterion(String condition, Object value1, Object value2, String property) {
  169. if (value1 == null || value2 == null) {
  170. throw new RuntimeException("Between values for " + property + " cannot be null");
  171. }
  172. criteria.add(new Criterion(condition, value1, value2));
  173. }
  174. public Criteria andDeptIdIsNull() {
  175. addCriterion("dept_id is null");
  176. return (Criteria) this;
  177. }
  178. public Criteria andDeptIdIsNotNull() {
  179. addCriterion("dept_id is not null");
  180. return (Criteria) this;
  181. }
  182. public Criteria andDeptIdEqualTo(Long value) {
  183. addCriterion("dept_id =", value, "deptId");
  184. return (Criteria) this;
  185. }
  186. public Criteria andDeptIdNotEqualTo(Long value) {
  187. addCriterion("dept_id <>", value, "deptId");
  188. return (Criteria) this;
  189. }
  190. public Criteria andDeptIdGreaterThan(Long value) {
  191. addCriterion("dept_id >", value, "deptId");
  192. return (Criteria) this;
  193. }
  194. public Criteria andDeptIdGreaterThanOrEqualTo(Long value) {
  195. addCriterion("dept_id >=", value, "deptId");
  196. return (Criteria) this;
  197. }
  198. public Criteria andDeptIdLessThan(Long value) {
  199. addCriterion("dept_id <", value, "deptId");
  200. return (Criteria) this;
  201. }
  202. public Criteria andDeptIdLessThanOrEqualTo(Long value) {
  203. addCriterion("dept_id <=", value, "deptId");
  204. return (Criteria) this;
  205. }
  206. public Criteria andDeptIdIn(List<Long> values) {
  207. addCriterion("dept_id in", values, "deptId");
  208. return (Criteria) this;
  209. }
  210. public Criteria andDeptIdNotIn(List<Long> values) {
  211. addCriterion("dept_id not in", values, "deptId");
  212. return (Criteria) this;
  213. }
  214. public Criteria andDeptIdBetween(Long value1, Long value2) {
  215. addCriterion("dept_id between", value1, value2, "deptId");
  216. return (Criteria) this;
  217. }
  218. public Criteria andDeptIdNotBetween(Long value1, Long value2) {
  219. addCriterion("dept_id not between", value1, value2, "deptId");
  220. return (Criteria) this;
  221. }
  222. public Criteria andParentIdIsNull() {
  223. addCriterion("parent_id is null");
  224. return (Criteria) this;
  225. }
  226. public Criteria andParentIdIsNotNull() {
  227. addCriterion("parent_id is not null");
  228. return (Criteria) this;
  229. }
  230. public Criteria andParentIdEqualTo(Long value) {
  231. addCriterion("parent_id =", value, "parentId");
  232. return (Criteria) this;
  233. }
  234. public Criteria andParentIdNotEqualTo(Long value) {
  235. addCriterion("parent_id <>", value, "parentId");
  236. return (Criteria) this;
  237. }
  238. public Criteria andParentIdGreaterThan(Long value) {
  239. addCriterion("parent_id >", value, "parentId");
  240. return (Criteria) this;
  241. }
  242. public Criteria andParentIdGreaterThanOrEqualTo(Long value) {
  243. addCriterion("parent_id >=", value, "parentId");
  244. return (Criteria) this;
  245. }
  246. public Criteria andParentIdLessThan(Long value) {
  247. addCriterion("parent_id <", value, "parentId");
  248. return (Criteria) this;
  249. }
  250. public Criteria andParentIdLessThanOrEqualTo(Long value) {
  251. addCriterion("parent_id <=", value, "parentId");
  252. return (Criteria) this;
  253. }
  254. public Criteria andParentIdIn(List<Long> values) {
  255. addCriterion("parent_id in", values, "parentId");
  256. return (Criteria) this;
  257. }
  258. public Criteria andParentIdNotIn(List<Long> values) {
  259. addCriterion("parent_id not in", values, "parentId");
  260. return (Criteria) this;
  261. }
  262. public Criteria andParentIdBetween(Long value1, Long value2) {
  263. addCriterion("parent_id between", value1, value2, "parentId");
  264. return (Criteria) this;
  265. }
  266. public Criteria andParentIdNotBetween(Long value1, Long value2) {
  267. addCriterion("parent_id not between", value1, value2, "parentId");
  268. return (Criteria) this;
  269. }
  270. public Criteria andAncestorsIsNull() {
  271. addCriterion("ancestors is null");
  272. return (Criteria) this;
  273. }
  274. public Criteria andAncestorsIsNotNull() {
  275. addCriterion("ancestors is not null");
  276. return (Criteria) this;
  277. }
  278. public Criteria andAncestorsEqualTo(String value) {
  279. addCriterion("ancestors =", value, "ancestors");
  280. return (Criteria) this;
  281. }
  282. public Criteria andAncestorsNotEqualTo(String value) {
  283. addCriterion("ancestors <>", value, "ancestors");
  284. return (Criteria) this;
  285. }
  286. public Criteria andAncestorsGreaterThan(String value) {
  287. addCriterion("ancestors >", value, "ancestors");
  288. return (Criteria) this;
  289. }
  290. public Criteria andAncestorsGreaterThanOrEqualTo(String value) {
  291. addCriterion("ancestors >=", value, "ancestors");
  292. return (Criteria) this;
  293. }
  294. public Criteria andAncestorsLessThan(String value) {
  295. addCriterion("ancestors <", value, "ancestors");
  296. return (Criteria) this;
  297. }
  298. public Criteria andAncestorsLessThanOrEqualTo(String value) {
  299. addCriterion("ancestors <=", value, "ancestors");
  300. return (Criteria) this;
  301. }
  302. public Criteria andAncestorsLike(String value) {
  303. addCriterion("ancestors like", value, "ancestors");
  304. return (Criteria) this;
  305. }
  306. public Criteria andAncestorsNotLike(String value) {
  307. addCriterion("ancestors not like", value, "ancestors");
  308. return (Criteria) this;
  309. }
  310. public Criteria andAncestorsIn(List<String> values) {
  311. addCriterion("ancestors in", values, "ancestors");
  312. return (Criteria) this;
  313. }
  314. public Criteria andAncestorsNotIn(List<String> values) {
  315. addCriterion("ancestors not in", values, "ancestors");
  316. return (Criteria) this;
  317. }
  318. public Criteria andAncestorsBetween(String value1, String value2) {
  319. addCriterion("ancestors between", value1, value2, "ancestors");
  320. return (Criteria) this;
  321. }
  322. public Criteria andAncestorsNotBetween(String value1, String value2) {
  323. addCriterion("ancestors not between", value1, value2, "ancestors");
  324. return (Criteria) this;
  325. }
  326. public Criteria andDeptNameIsNull() {
  327. addCriterion("dept_name is null");
  328. return (Criteria) this;
  329. }
  330. public Criteria andDeptNameIsNotNull() {
  331. addCriterion("dept_name is not null");
  332. return (Criteria) this;
  333. }
  334. public Criteria andDeptNameEqualTo(String value) {
  335. addCriterion("dept_name =", value, "deptName");
  336. return (Criteria) this;
  337. }
  338. public Criteria andDeptNameNotEqualTo(String value) {
  339. addCriterion("dept_name <>", value, "deptName");
  340. return (Criteria) this;
  341. }
  342. public Criteria andDeptNameGreaterThan(String value) {
  343. addCriterion("dept_name >", value, "deptName");
  344. return (Criteria) this;
  345. }
  346. public Criteria andDeptNameGreaterThanOrEqualTo(String value) {
  347. addCriterion("dept_name >=", value, "deptName");
  348. return (Criteria) this;
  349. }
  350. public Criteria andDeptNameLessThan(String value) {
  351. addCriterion("dept_name <", value, "deptName");
  352. return (Criteria) this;
  353. }
  354. public Criteria andDeptNameLessThanOrEqualTo(String value) {
  355. addCriterion("dept_name <=", value, "deptName");
  356. return (Criteria) this;
  357. }
  358. public Criteria andDeptNameLike(String value) {
  359. addCriterion("dept_name like", value, "deptName");
  360. return (Criteria) this;
  361. }
  362. public Criteria andDeptNameNotLike(String value) {
  363. addCriterion("dept_name not like", value, "deptName");
  364. return (Criteria) this;
  365. }
  366. public Criteria andDeptNameIn(List<String> values) {
  367. addCriterion("dept_name in", values, "deptName");
  368. return (Criteria) this;
  369. }
  370. public Criteria andDeptNameNotIn(List<String> values) {
  371. addCriterion("dept_name not in", values, "deptName");
  372. return (Criteria) this;
  373. }
  374. public Criteria andDeptNameBetween(String value1, String value2) {
  375. addCriterion("dept_name between", value1, value2, "deptName");
  376. return (Criteria) this;
  377. }
  378. public Criteria andDeptNameNotBetween(String value1, String value2) {
  379. addCriterion("dept_name not between", value1, value2, "deptName");
  380. return (Criteria) this;
  381. }
  382. public Criteria andOrderNumIsNull() {
  383. addCriterion("order_num is null");
  384. return (Criteria) this;
  385. }
  386. public Criteria andOrderNumIsNotNull() {
  387. addCriterion("order_num is not null");
  388. return (Criteria) this;
  389. }
  390. public Criteria andOrderNumEqualTo(Integer value) {
  391. addCriterion("order_num =", value, "orderNum");
  392. return (Criteria) this;
  393. }
  394. public Criteria andOrderNumNotEqualTo(Integer value) {
  395. addCriterion("order_num <>", value, "orderNum");
  396. return (Criteria) this;
  397. }
  398. public Criteria andOrderNumGreaterThan(Integer value) {
  399. addCriterion("order_num >", value, "orderNum");
  400. return (Criteria) this;
  401. }
  402. public Criteria andOrderNumGreaterThanOrEqualTo(Integer value) {
  403. addCriterion("order_num >=", value, "orderNum");
  404. return (Criteria) this;
  405. }
  406. public Criteria andOrderNumLessThan(Integer value) {
  407. addCriterion("order_num <", value, "orderNum");
  408. return (Criteria) this;
  409. }
  410. public Criteria andOrderNumLessThanOrEqualTo(Integer value) {
  411. addCriterion("order_num <=", value, "orderNum");
  412. return (Criteria) this;
  413. }
  414. public Criteria andOrderNumIn(List<Integer> values) {
  415. addCriterion("order_num in", values, "orderNum");
  416. return (Criteria) this;
  417. }
  418. public Criteria andOrderNumNotIn(List<Integer> values) {
  419. addCriterion("order_num not in", values, "orderNum");
  420. return (Criteria) this;
  421. }
  422. public Criteria andOrderNumBetween(Integer value1, Integer value2) {
  423. addCriterion("order_num between", value1, value2, "orderNum");
  424. return (Criteria) this;
  425. }
  426. public Criteria andOrderNumNotBetween(Integer value1, Integer value2) {
  427. addCriterion("order_num not between", value1, value2, "orderNum");
  428. return (Criteria) this;
  429. }
  430. public Criteria andLeaderIsNull() {
  431. addCriterion("leader is null");
  432. return (Criteria) this;
  433. }
  434. public Criteria andLeaderIsNotNull() {
  435. addCriterion("leader is not null");
  436. return (Criteria) this;
  437. }
  438. public Criteria andLeaderEqualTo(String value) {
  439. addCriterion("leader =", value, "leader");
  440. return (Criteria) this;
  441. }
  442. public Criteria andLeaderNotEqualTo(String value) {
  443. addCriterion("leader <>", value, "leader");
  444. return (Criteria) this;
  445. }
  446. public Criteria andLeaderGreaterThan(String value) {
  447. addCriterion("leader >", value, "leader");
  448. return (Criteria) this;
  449. }
  450. public Criteria andLeaderGreaterThanOrEqualTo(String value) {
  451. addCriterion("leader >=", value, "leader");
  452. return (Criteria) this;
  453. }
  454. public Criteria andLeaderLessThan(String value) {
  455. addCriterion("leader <", value, "leader");
  456. return (Criteria) this;
  457. }
  458. public Criteria andLeaderLessThanOrEqualTo(String value) {
  459. addCriterion("leader <=", value, "leader");
  460. return (Criteria) this;
  461. }
  462. public Criteria andLeaderLike(String value) {
  463. addCriterion("leader like", value, "leader");
  464. return (Criteria) this;
  465. }
  466. public Criteria andLeaderNotLike(String value) {
  467. addCriterion("leader not like", value, "leader");
  468. return (Criteria) this;
  469. }
  470. public Criteria andLeaderIn(List<String> values) {
  471. addCriterion("leader in", values, "leader");
  472. return (Criteria) this;
  473. }
  474. public Criteria andLeaderNotIn(List<String> values) {
  475. addCriterion("leader not in", values, "leader");
  476. return (Criteria) this;
  477. }
  478. public Criteria andLeaderBetween(String value1, String value2) {
  479. addCriterion("leader between", value1, value2, "leader");
  480. return (Criteria) this;
  481. }
  482. public Criteria andLeaderNotBetween(String value1, String value2) {
  483. addCriterion("leader not between", value1, value2, "leader");
  484. return (Criteria) this;
  485. }
  486. public Criteria andPhoneIsNull() {
  487. addCriterion("phone is null");
  488. return (Criteria) this;
  489. }
  490. public Criteria andPhoneIsNotNull() {
  491. addCriterion("phone is not null");
  492. return (Criteria) this;
  493. }
  494. public Criteria andPhoneEqualTo(String value) {
  495. addCriterion("phone =", value, "phone");
  496. return (Criteria) this;
  497. }
  498. public Criteria andPhoneNotEqualTo(String value) {
  499. addCriterion("phone <>", value, "phone");
  500. return (Criteria) this;
  501. }
  502. public Criteria andPhoneGreaterThan(String value) {
  503. addCriterion("phone >", value, "phone");
  504. return (Criteria) this;
  505. }
  506. public Criteria andPhoneGreaterThanOrEqualTo(String value) {
  507. addCriterion("phone >=", value, "phone");
  508. return (Criteria) this;
  509. }
  510. public Criteria andPhoneLessThan(String value) {
  511. addCriterion("phone <", value, "phone");
  512. return (Criteria) this;
  513. }
  514. public Criteria andPhoneLessThanOrEqualTo(String value) {
  515. addCriterion("phone <=", value, "phone");
  516. return (Criteria) this;
  517. }
  518. public Criteria andPhoneLike(String value) {
  519. addCriterion("phone like", value, "phone");
  520. return (Criteria) this;
  521. }
  522. public Criteria andPhoneNotLike(String value) {
  523. addCriterion("phone not like", value, "phone");
  524. return (Criteria) this;
  525. }
  526. public Criteria andPhoneIn(List<String> values) {
  527. addCriterion("phone in", values, "phone");
  528. return (Criteria) this;
  529. }
  530. public Criteria andPhoneNotIn(List<String> values) {
  531. addCriterion("phone not in", values, "phone");
  532. return (Criteria) this;
  533. }
  534. public Criteria andPhoneBetween(String value1, String value2) {
  535. addCriterion("phone between", value1, value2, "phone");
  536. return (Criteria) this;
  537. }
  538. public Criteria andPhoneNotBetween(String value1, String value2) {
  539. addCriterion("phone not between", value1, value2, "phone");
  540. return (Criteria) this;
  541. }
  542. public Criteria andEmailIsNull() {
  543. addCriterion("email is null");
  544. return (Criteria) this;
  545. }
  546. public Criteria andEmailIsNotNull() {
  547. addCriterion("email is not null");
  548. return (Criteria) this;
  549. }
  550. public Criteria andEmailEqualTo(String value) {
  551. addCriterion("email =", value, "email");
  552. return (Criteria) this;
  553. }
  554. public Criteria andEmailNotEqualTo(String value) {
  555. addCriterion("email <>", value, "email");
  556. return (Criteria) this;
  557. }
  558. public Criteria andEmailGreaterThan(String value) {
  559. addCriterion("email >", value, "email");
  560. return (Criteria) this;
  561. }
  562. public Criteria andEmailGreaterThanOrEqualTo(String value) {
  563. addCriterion("email >=", value, "email");
  564. return (Criteria) this;
  565. }
  566. public Criteria andEmailLessThan(String value) {
  567. addCriterion("email <", value, "email");
  568. return (Criteria) this;
  569. }
  570. public Criteria andEmailLessThanOrEqualTo(String value) {
  571. addCriterion("email <=", value, "email");
  572. return (Criteria) this;
  573. }
  574. public Criteria andEmailLike(String value) {
  575. addCriterion("email like", value, "email");
  576. return (Criteria) this;
  577. }
  578. public Criteria andEmailNotLike(String value) {
  579. addCriterion("email not like", value, "email");
  580. return (Criteria) this;
  581. }
  582. public Criteria andEmailIn(List<String> values) {
  583. addCriterion("email in", values, "email");
  584. return (Criteria) this;
  585. }
  586. public Criteria andEmailNotIn(List<String> values) {
  587. addCriterion("email not in", values, "email");
  588. return (Criteria) this;
  589. }
  590. public Criteria andEmailBetween(String value1, String value2) {
  591. addCriterion("email between", value1, value2, "email");
  592. return (Criteria) this;
  593. }
  594. public Criteria andEmailNotBetween(String value1, String value2) {
  595. addCriterion("email not between", value1, value2, "email");
  596. return (Criteria) this;
  597. }
  598. public Criteria andStatusIsNull() {
  599. addCriterion("status is null");
  600. return (Criteria) this;
  601. }
  602. public Criteria andStatusIsNotNull() {
  603. addCriterion("status is not null");
  604. return (Criteria) this;
  605. }
  606. public Criteria andStatusEqualTo(String value) {
  607. addCriterion("status =", value, "status");
  608. return (Criteria) this;
  609. }
  610. public Criteria andStatusNotEqualTo(String value) {
  611. addCriterion("status <>", value, "status");
  612. return (Criteria) this;
  613. }
  614. public Criteria andStatusGreaterThan(String value) {
  615. addCriterion("status >", value, "status");
  616. return (Criteria) this;
  617. }
  618. public Criteria andStatusGreaterThanOrEqualTo(String value) {
  619. addCriterion("status >=", value, "status");
  620. return (Criteria) this;
  621. }
  622. public Criteria andStatusLessThan(String value) {
  623. addCriterion("status <", value, "status");
  624. return (Criteria) this;
  625. }
  626. public Criteria andStatusLessThanOrEqualTo(String value) {
  627. addCriterion("status <=", value, "status");
  628. return (Criteria) this;
  629. }
  630. public Criteria andStatusLike(String value) {
  631. addCriterion("status like", value, "status");
  632. return (Criteria) this;
  633. }
  634. public Criteria andStatusNotLike(String value) {
  635. addCriterion("status not like", value, "status");
  636. return (Criteria) this;
  637. }
  638. public Criteria andStatusIn(List<String> values) {
  639. addCriterion("status in", values, "status");
  640. return (Criteria) this;
  641. }
  642. public Criteria andStatusNotIn(List<String> values) {
  643. addCriterion("status not in", values, "status");
  644. return (Criteria) this;
  645. }
  646. public Criteria andStatusBetween(String value1, String value2) {
  647. addCriterion("status between", value1, value2, "status");
  648. return (Criteria) this;
  649. }
  650. public Criteria andStatusNotBetween(String value1, String value2) {
  651. addCriterion("status not between", value1, value2, "status");
  652. return (Criteria) this;
  653. }
  654. public Criteria andDelFlagIsNull() {
  655. addCriterion("del_flag is null");
  656. return (Criteria) this;
  657. }
  658. public Criteria andDelFlagIsNotNull() {
  659. addCriterion("del_flag is not null");
  660. return (Criteria) this;
  661. }
  662. public Criteria andDelFlagEqualTo(String value) {
  663. addCriterion("del_flag =", value, "delFlag");
  664. return (Criteria) this;
  665. }
  666. public Criteria andDelFlagNotEqualTo(String value) {
  667. addCriterion("del_flag <>", value, "delFlag");
  668. return (Criteria) this;
  669. }
  670. public Criteria andDelFlagGreaterThan(String value) {
  671. addCriterion("del_flag >", value, "delFlag");
  672. return (Criteria) this;
  673. }
  674. public Criteria andDelFlagGreaterThanOrEqualTo(String value) {
  675. addCriterion("del_flag >=", value, "delFlag");
  676. return (Criteria) this;
  677. }
  678. public Criteria andDelFlagLessThan(String value) {
  679. addCriterion("del_flag <", value, "delFlag");
  680. return (Criteria) this;
  681. }
  682. public Criteria andDelFlagLessThanOrEqualTo(String value) {
  683. addCriterion("del_flag <=", value, "delFlag");
  684. return (Criteria) this;
  685. }
  686. public Criteria andDelFlagLike(String value) {
  687. addCriterion("del_flag like", value, "delFlag");
  688. return (Criteria) this;
  689. }
  690. public Criteria andDelFlagNotLike(String value) {
  691. addCriterion("del_flag not like", value, "delFlag");
  692. return (Criteria) this;
  693. }
  694. public Criteria andDelFlagIn(List<String> values) {
  695. addCriterion("del_flag in", values, "delFlag");
  696. return (Criteria) this;
  697. }
  698. public Criteria andDelFlagNotIn(List<String> values) {
  699. addCriterion("del_flag not in", values, "delFlag");
  700. return (Criteria) this;
  701. }
  702. public Criteria andDelFlagBetween(String value1, String value2) {
  703. addCriterion("del_flag between", value1, value2, "delFlag");
  704. return (Criteria) this;
  705. }
  706. public Criteria andDelFlagNotBetween(String value1, String value2) {
  707. addCriterion("del_flag not between", value1, value2, "delFlag");
  708. return (Criteria) this;
  709. }
  710. public Criteria andCreateByIsNull() {
  711. addCriterion("create_by is null");
  712. return (Criteria) this;
  713. }
  714. public Criteria andCreateByIsNotNull() {
  715. addCriterion("create_by is not null");
  716. return (Criteria) this;
  717. }
  718. public Criteria andCreateByEqualTo(String value) {
  719. addCriterion("create_by =", value, "createBy");
  720. return (Criteria) this;
  721. }
  722. public Criteria andCreateByNotEqualTo(String value) {
  723. addCriterion("create_by <>", value, "createBy");
  724. return (Criteria) this;
  725. }
  726. public Criteria andCreateByGreaterThan(String value) {
  727. addCriterion("create_by >", value, "createBy");
  728. return (Criteria) this;
  729. }
  730. public Criteria andCreateByGreaterThanOrEqualTo(String value) {
  731. addCriterion("create_by >=", value, "createBy");
  732. return (Criteria) this;
  733. }
  734. public Criteria andCreateByLessThan(String value) {
  735. addCriterion("create_by <", value, "createBy");
  736. return (Criteria) this;
  737. }
  738. public Criteria andCreateByLessThanOrEqualTo(String value) {
  739. addCriterion("create_by <=", value, "createBy");
  740. return (Criteria) this;
  741. }
  742. public Criteria andCreateByLike(String value) {
  743. addCriterion("create_by like", value, "createBy");
  744. return (Criteria) this;
  745. }
  746. public Criteria andCreateByNotLike(String value) {
  747. addCriterion("create_by not like", value, "createBy");
  748. return (Criteria) this;
  749. }
  750. public Criteria andCreateByIn(List<String> values) {
  751. addCriterion("create_by in", values, "createBy");
  752. return (Criteria) this;
  753. }
  754. public Criteria andCreateByNotIn(List<String> values) {
  755. addCriterion("create_by not in", values, "createBy");
  756. return (Criteria) this;
  757. }
  758. public Criteria andCreateByBetween(String value1, String value2) {
  759. addCriterion("create_by between", value1, value2, "createBy");
  760. return (Criteria) this;
  761. }
  762. public Criteria andCreateByNotBetween(String value1, String value2) {
  763. addCriterion("create_by not between", value1, value2, "createBy");
  764. return (Criteria) this;
  765. }
  766. public Criteria andCreateTimeIsNull() {
  767. addCriterion("create_time is null");
  768. return (Criteria) this;
  769. }
  770. public Criteria andCreateTimeIsNotNull() {
  771. addCriterion("create_time is not null");
  772. return (Criteria) this;
  773. }
  774. public Criteria andCreateTimeEqualTo(Date value) {
  775. addCriterion("create_time =", value, "createTime");
  776. return (Criteria) this;
  777. }
  778. public Criteria andCreateTimeNotEqualTo(Date value) {
  779. addCriterion("create_time <>", value, "createTime");
  780. return (Criteria) this;
  781. }
  782. public Criteria andCreateTimeGreaterThan(Date value) {
  783. addCriterion("create_time >", value, "createTime");
  784. return (Criteria) this;
  785. }
  786. public Criteria andCreateTimeGreaterThanOrEqualTo(Date value) {
  787. addCriterion("create_time >=", value, "createTime");
  788. return (Criteria) this;
  789. }
  790. public Criteria andCreateTimeLessThan(Date value) {
  791. addCriterion("create_time <", value, "createTime");
  792. return (Criteria) this;
  793. }
  794. public Criteria andCreateTimeLessThanOrEqualTo(Date value) {
  795. addCriterion("create_time <=", value, "createTime");
  796. return (Criteria) this;
  797. }
  798. public Criteria andCreateTimeIn(List<Date> values) {
  799. addCriterion("create_time in", values, "createTime");
  800. return (Criteria) this;
  801. }
  802. public Criteria andCreateTimeNotIn(List<Date> values) {
  803. addCriterion("create_time not in", values, "createTime");
  804. return (Criteria) this;
  805. }
  806. public Criteria andCreateTimeBetween(Date value1, Date value2) {
  807. addCriterion("create_time between", value1, value2, "createTime");
  808. return (Criteria) this;
  809. }
  810. public Criteria andCreateTimeNotBetween(Date value1, Date value2) {
  811. addCriterion("create_time not between", value1, value2, "createTime");
  812. return (Criteria) this;
  813. }
  814. public Criteria andUpdateByIsNull() {
  815. addCriterion("update_by is null");
  816. return (Criteria) this;
  817. }
  818. public Criteria andUpdateByIsNotNull() {
  819. addCriterion("update_by is not null");
  820. return (Criteria) this;
  821. }
  822. public Criteria andUpdateByEqualTo(String value) {
  823. addCriterion("update_by =", value, "updateBy");
  824. return (Criteria) this;
  825. }
  826. public Criteria andUpdateByNotEqualTo(String value) {
  827. addCriterion("update_by <>", value, "updateBy");
  828. return (Criteria) this;
  829. }
  830. public Criteria andUpdateByGreaterThan(String value) {
  831. addCriterion("update_by >", value, "updateBy");
  832. return (Criteria) this;
  833. }
  834. public Criteria andUpdateByGreaterThanOrEqualTo(String value) {
  835. addCriterion("update_by >=", value, "updateBy");
  836. return (Criteria) this;
  837. }
  838. public Criteria andUpdateByLessThan(String value) {
  839. addCriterion("update_by <", value, "updateBy");
  840. return (Criteria) this;
  841. }
  842. public Criteria andUpdateByLessThanOrEqualTo(String value) {
  843. addCriterion("update_by <=", value, "updateBy");
  844. return (Criteria) this;
  845. }
  846. public Criteria andUpdateByLike(String value) {
  847. addCriterion("update_by like", value, "updateBy");
  848. return (Criteria) this;
  849. }
  850. public Criteria andUpdateByNotLike(String value) {
  851. addCriterion("update_by not like", value, "updateBy");
  852. return (Criteria) this;
  853. }
  854. public Criteria andUpdateByIn(List<String> values) {
  855. addCriterion("update_by in", values, "updateBy");
  856. return (Criteria) this;
  857. }
  858. public Criteria andUpdateByNotIn(List<String> values) {
  859. addCriterion("update_by not in", values, "updateBy");
  860. return (Criteria) this;
  861. }
  862. public Criteria andUpdateByBetween(String value1, String value2) {
  863. addCriterion("update_by between", value1, value2, "updateBy");
  864. return (Criteria) this;
  865. }
  866. public Criteria andUpdateByNotBetween(String value1, String value2) {
  867. addCriterion("update_by not between", value1, value2, "updateBy");
  868. return (Criteria) this;
  869. }
  870. public Criteria andUpdateTimeIsNull() {
  871. addCriterion("update_time is null");
  872. return (Criteria) this;
  873. }
  874. public Criteria andUpdateTimeIsNotNull() {
  875. addCriterion("update_time is not null");
  876. return (Criteria) this;
  877. }
  878. public Criteria andUpdateTimeEqualTo(Date value) {
  879. addCriterion("update_time =", value, "updateTime");
  880. return (Criteria) this;
  881. }
  882. public Criteria andUpdateTimeNotEqualTo(Date value) {
  883. addCriterion("update_time <>", value, "updateTime");
  884. return (Criteria) this;
  885. }
  886. public Criteria andUpdateTimeGreaterThan(Date value) {
  887. addCriterion("update_time >", value, "updateTime");
  888. return (Criteria) this;
  889. }
  890. public Criteria andUpdateTimeGreaterThanOrEqualTo(Date value) {
  891. addCriterion("update_time >=", value, "updateTime");
  892. return (Criteria) this;
  893. }
  894. public Criteria andUpdateTimeLessThan(Date value) {
  895. addCriterion("update_time <", value, "updateTime");
  896. return (Criteria) this;
  897. }
  898. public Criteria andUpdateTimeLessThanOrEqualTo(Date value) {
  899. addCriterion("update_time <=", value, "updateTime");
  900. return (Criteria) this;
  901. }
  902. public Criteria andUpdateTimeIn(List<Date> values) {
  903. addCriterion("update_time in", values, "updateTime");
  904. return (Criteria) this;
  905. }
  906. public Criteria andUpdateTimeNotIn(List<Date> values) {
  907. addCriterion("update_time not in", values, "updateTime");
  908. return (Criteria) this;
  909. }
  910. public Criteria andUpdateTimeBetween(Date value1, Date value2) {
  911. addCriterion("update_time between", value1, value2, "updateTime");
  912. return (Criteria) this;
  913. }
  914. public Criteria andUpdateTimeNotBetween(Date value1, Date value2) {
  915. addCriterion("update_time not between", value1, value2, "updateTime");
  916. return (Criteria) this;
  917. }
  918. }
  919. /**
  920. * This class was generated by MyBatis Generator.
  921. * This class corresponds to the database table sys_dept
  922. *
  923. * @mbg.generated do_not_delete_during_merge
  924. */
  925. public static class Criteria extends GeneratedCriteria {
  926. protected Criteria() {
  927. super();
  928. }
  929. }
  930. /**
  931. * This class was generated by MyBatis Generator.
  932. * This class corresponds to the database table sys_dept
  933. *
  934. * @mbg.generated
  935. */
  936. public static class Criterion {
  937. private String condition;
  938. private Object value;
  939. private Object secondValue;
  940. private boolean noValue;
  941. private boolean singleValue;
  942. private boolean betweenValue;
  943. private boolean listValue;
  944. private String typeHandler;
  945. public String getCondition() {
  946. return condition;
  947. }
  948. public Object getValue() {
  949. return value;
  950. }
  951. public Object getSecondValue() {
  952. return secondValue;
  953. }
  954. public boolean isNoValue() {
  955. return noValue;
  956. }
  957. public boolean isSingleValue() {
  958. return singleValue;
  959. }
  960. public boolean isBetweenValue() {
  961. return betweenValue;
  962. }
  963. public boolean isListValue() {
  964. return listValue;
  965. }
  966. public String getTypeHandler() {
  967. return typeHandler;
  968. }
  969. protected Criterion(String condition) {
  970. super();
  971. this.condition = condition;
  972. this.typeHandler = null;
  973. this.noValue = true;
  974. }
  975. protected Criterion(String condition, Object value, String typeHandler) {
  976. super();
  977. this.condition = condition;
  978. this.value = value;
  979. this.typeHandler = typeHandler;
  980. if (value instanceof List<?>) {
  981. this.listValue = true;
  982. } else {
  983. this.singleValue = true;
  984. }
  985. }
  986. protected Criterion(String condition, Object value) {
  987. this(condition, value, null);
  988. }
  989. protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
  990. super();
  991. this.condition = condition;
  992. this.value = value;
  993. this.secondValue = secondValue;
  994. this.typeHandler = typeHandler;
  995. this.betweenValue = true;
  996. }
  997. protected Criterion(String condition, Object value, Object secondValue) {
  998. this(condition, value, secondValue, null);
  999. }
  1000. }
  1001. }