JgUserInfExample.java 35 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139
  1. package com.minpay.db.table.model;
  2. import java.util.ArrayList;
  3. import java.util.List;
  4. public class JgUserInfExample {
  5. /**
  6. * This field was generated by MyBatis Generator.
  7. * This field corresponds to the database table jg_user_inf
  8. *
  9. * @mbggenerated
  10. */
  11. protected String orderByClause;
  12. /**
  13. * This field was generated by MyBatis Generator.
  14. * This field corresponds to the database table jg_user_inf
  15. *
  16. * @mbggenerated
  17. */
  18. protected boolean distinct;
  19. /**
  20. * This field was generated by MyBatis Generator.
  21. * This field corresponds to the database table jg_user_inf
  22. *
  23. * @mbggenerated
  24. */
  25. protected List<Criteria> oredCriteria;
  26. /**
  27. * This method was generated by MyBatis Generator.
  28. * This method corresponds to the database table jg_user_inf
  29. *
  30. * @mbggenerated
  31. */
  32. public JgUserInfExample() {
  33. oredCriteria = new ArrayList<Criteria>();
  34. }
  35. /**
  36. * This method was generated by MyBatis Generator.
  37. * This method corresponds to the database table jg_user_inf
  38. *
  39. * @mbggenerated
  40. */
  41. public void setOrderByClause(String orderByClause) {
  42. this.orderByClause = orderByClause;
  43. }
  44. /**
  45. * This method was generated by MyBatis Generator.
  46. * This method corresponds to the database table jg_user_inf
  47. *
  48. * @mbggenerated
  49. */
  50. public String getOrderByClause() {
  51. return orderByClause;
  52. }
  53. /**
  54. * This method was generated by MyBatis Generator.
  55. * This method corresponds to the database table jg_user_inf
  56. *
  57. * @mbggenerated
  58. */
  59. public void setDistinct(boolean distinct) {
  60. this.distinct = distinct;
  61. }
  62. /**
  63. * This method was generated by MyBatis Generator.
  64. * This method corresponds to the database table jg_user_inf
  65. *
  66. * @mbggenerated
  67. */
  68. public boolean isDistinct() {
  69. return distinct;
  70. }
  71. /**
  72. * This method was generated by MyBatis Generator.
  73. * This method corresponds to the database table jg_user_inf
  74. *
  75. * @mbggenerated
  76. */
  77. public List<Criteria> getOredCriteria() {
  78. return oredCriteria;
  79. }
  80. /**
  81. * This method was generated by MyBatis Generator.
  82. * This method corresponds to the database table jg_user_inf
  83. *
  84. * @mbggenerated
  85. */
  86. public void or(Criteria criteria) {
  87. oredCriteria.add(criteria);
  88. }
  89. /**
  90. * This method was generated by MyBatis Generator.
  91. * This method corresponds to the database table jg_user_inf
  92. *
  93. * @mbggenerated
  94. */
  95. public Criteria or() {
  96. Criteria criteria = createCriteriaInternal();
  97. oredCriteria.add(criteria);
  98. return criteria;
  99. }
  100. /**
  101. * This method was generated by MyBatis Generator.
  102. * This method corresponds to the database table jg_user_inf
  103. *
  104. * @mbggenerated
  105. */
  106. public Criteria createCriteria() {
  107. Criteria criteria = createCriteriaInternal();
  108. if (oredCriteria.size() == 0) {
  109. oredCriteria.add(criteria);
  110. }
  111. return criteria;
  112. }
  113. /**
  114. * This method was generated by MyBatis Generator.
  115. * This method corresponds to the database table jg_user_inf
  116. *
  117. * @mbggenerated
  118. */
  119. protected Criteria createCriteriaInternal() {
  120. Criteria criteria = new Criteria();
  121. return criteria;
  122. }
  123. /**
  124. * This method was generated by MyBatis Generator.
  125. * This method corresponds to the database table jg_user_inf
  126. *
  127. * @mbggenerated
  128. */
  129. public void clear() {
  130. oredCriteria.clear();
  131. orderByClause = null;
  132. distinct = false;
  133. }
  134. /**
  135. * This class was generated by MyBatis Generator.
  136. * This class corresponds to the database table jg_user_inf
  137. *
  138. * @mbggenerated
  139. */
  140. protected abstract static class GeneratedCriteria {
  141. protected List<Criterion> criteria;
  142. protected GeneratedCriteria() {
  143. super();
  144. criteria = new ArrayList<Criterion>();
  145. }
  146. public boolean isValid() {
  147. return criteria.size() > 0;
  148. }
  149. public List<Criterion> getCriteria() {
  150. return criteria;
  151. }
  152. protected void addCriterion(String condition) {
  153. if (condition == null) {
  154. throw new RuntimeException("Value for condition cannot be null");
  155. }
  156. criteria.add(new Criterion(condition));
  157. }
  158. protected void addCriterion(String condition, Object value, String property) {
  159. if (value == null) {
  160. throw new RuntimeException("Value for " + property + " cannot be null");
  161. }
  162. criteria.add(new Criterion(condition, value));
  163. }
  164. protected void addCriterion(String condition, Object value1, Object value2, String property) {
  165. if (value1 == null || value2 == null) {
  166. throw new RuntimeException("Between values for " + property + " cannot be null");
  167. }
  168. criteria.add(new Criterion(condition, value1, value2));
  169. }
  170. public Criteria andIdIsNull() {
  171. addCriterion("USR_ID is null");
  172. return (Criteria) this;
  173. }
  174. public Criteria andIdIsNotNull() {
  175. addCriterion("USR_ID is not null");
  176. return (Criteria) this;
  177. }
  178. public Criteria andIdEqualTo(String value) {
  179. if(value == null ){
  180. andIdIsNull();
  181. } else {
  182. addCriterion("USR_ID =", value, "id");
  183. }
  184. return (Criteria) this;
  185. }
  186. public Criteria andIdNotEqualTo(String value) {
  187. if(value == null ){
  188. andIdIsNotNull();
  189. } else {
  190. addCriterion("USR_ID <>", value, "id");
  191. }
  192. return (Criteria) this;
  193. }
  194. public Criteria andIdGreaterThan(String value) {
  195. addCriterion("USR_ID >", value, "id");
  196. return (Criteria) this;
  197. }
  198. public Criteria andIdGreaterThanOrEqualTo(String value) {
  199. addCriterion("USR_ID >=", value, "id");
  200. return (Criteria) this;
  201. }
  202. public Criteria andIdLessThan(String value) {
  203. addCriterion("USR_ID <", value, "id");
  204. return (Criteria) this;
  205. }
  206. public Criteria andIdLessThanOrEqualTo(String value) {
  207. addCriterion("USR_ID <=", value, "id");
  208. return (Criteria) this;
  209. }
  210. public Criteria andIdLike(String value) {
  211. addCriterion("USR_ID like", value, "id");
  212. return (Criteria) this;
  213. }
  214. public Criteria andIdNotLike(String value) {
  215. addCriterion("USR_ID not like", value, "id");
  216. return (Criteria) this;
  217. }
  218. public Criteria andIdIn(List<String> values) {
  219. addCriterion("USR_ID in", values, "id");
  220. return (Criteria) this;
  221. }
  222. public Criteria andIdNotIn(List<String> values) {
  223. addCriterion("USR_ID not in", values, "id");
  224. return (Criteria) this;
  225. }
  226. public Criteria andIdBetween(String value1, String value2) {
  227. addCriterion("USR_ID between", value1, value2, "id");
  228. return (Criteria) this;
  229. }
  230. public Criteria andIdNotBetween(String value1, String value2) {
  231. addCriterion("USR_ID not between", value1, value2, "id");
  232. return (Criteria) this;
  233. }
  234. public Criteria andNameIsNull() {
  235. addCriterion("USR_NAME is null");
  236. return (Criteria) this;
  237. }
  238. public Criteria andNameIsNotNull() {
  239. addCriterion("USR_NAME is not null");
  240. return (Criteria) this;
  241. }
  242. public Criteria andNameEqualTo(String value) {
  243. if(value == null ){
  244. andNameIsNull();
  245. } else {
  246. addCriterion("USR_NAME =", value, "name");
  247. }
  248. return (Criteria) this;
  249. }
  250. public Criteria andNameNotEqualTo(String value) {
  251. if(value == null ){
  252. andNameIsNotNull();
  253. } else {
  254. addCriterion("USR_NAME <>", value, "name");
  255. }
  256. return (Criteria) this;
  257. }
  258. public Criteria andNameGreaterThan(String value) {
  259. addCriterion("USR_NAME >", value, "name");
  260. return (Criteria) this;
  261. }
  262. public Criteria andNameGreaterThanOrEqualTo(String value) {
  263. addCriterion("USR_NAME >=", value, "name");
  264. return (Criteria) this;
  265. }
  266. public Criteria andNameLessThan(String value) {
  267. addCriterion("USR_NAME <", value, "name");
  268. return (Criteria) this;
  269. }
  270. public Criteria andNameLessThanOrEqualTo(String value) {
  271. addCriterion("USR_NAME <=", value, "name");
  272. return (Criteria) this;
  273. }
  274. public Criteria andNameLike(String value) {
  275. addCriterion("USR_NAME like", value, "name");
  276. return (Criteria) this;
  277. }
  278. public Criteria andNameNotLike(String value) {
  279. addCriterion("USR_NAME not like", value, "name");
  280. return (Criteria) this;
  281. }
  282. public Criteria andNameIn(List<String> values) {
  283. addCriterion("USR_NAME in", values, "name");
  284. return (Criteria) this;
  285. }
  286. public Criteria andNameNotIn(List<String> values) {
  287. addCriterion("USR_NAME not in", values, "name");
  288. return (Criteria) this;
  289. }
  290. public Criteria andNameBetween(String value1, String value2) {
  291. addCriterion("USR_NAME between", value1, value2, "name");
  292. return (Criteria) this;
  293. }
  294. public Criteria andNameNotBetween(String value1, String value2) {
  295. addCriterion("USR_NAME not between", value1, value2, "name");
  296. return (Criteria) this;
  297. }
  298. public Criteria andTeamidIsNull() {
  299. addCriterion("USR_TEAMID is null");
  300. return (Criteria) this;
  301. }
  302. public Criteria andTeamidIsNotNull() {
  303. addCriterion("USR_TEAMID is not null");
  304. return (Criteria) this;
  305. }
  306. public Criteria andTeamidEqualTo(String value) {
  307. if(value == null ){
  308. andTeamidIsNull();
  309. } else {
  310. addCriterion("USR_TEAMID =", value, "teamid");
  311. }
  312. return (Criteria) this;
  313. }
  314. public Criteria andTeamidNotEqualTo(String value) {
  315. if(value == null ){
  316. andTeamidIsNotNull();
  317. } else {
  318. addCriterion("USR_TEAMID <>", value, "teamid");
  319. }
  320. return (Criteria) this;
  321. }
  322. public Criteria andTeamidGreaterThan(String value) {
  323. addCriterion("USR_TEAMID >", value, "teamid");
  324. return (Criteria) this;
  325. }
  326. public Criteria andTeamidGreaterThanOrEqualTo(String value) {
  327. addCriterion("USR_TEAMID >=", value, "teamid");
  328. return (Criteria) this;
  329. }
  330. public Criteria andTeamidLessThan(String value) {
  331. addCriterion("USR_TEAMID <", value, "teamid");
  332. return (Criteria) this;
  333. }
  334. public Criteria andTeamidLessThanOrEqualTo(String value) {
  335. addCriterion("USR_TEAMID <=", value, "teamid");
  336. return (Criteria) this;
  337. }
  338. public Criteria andTeamidLike(String value) {
  339. addCriterion("USR_TEAMID like", value, "teamid");
  340. return (Criteria) this;
  341. }
  342. public Criteria andTeamidNotLike(String value) {
  343. addCriterion("USR_TEAMID not like", value, "teamid");
  344. return (Criteria) this;
  345. }
  346. public Criteria andTeamidIn(List<String> values) {
  347. addCriterion("USR_TEAMID in", values, "teamid");
  348. return (Criteria) this;
  349. }
  350. public Criteria andTeamidNotIn(List<String> values) {
  351. addCriterion("USR_TEAMID not in", values, "teamid");
  352. return (Criteria) this;
  353. }
  354. public Criteria andTeamidBetween(String value1, String value2) {
  355. addCriterion("USR_TEAMID between", value1, value2, "teamid");
  356. return (Criteria) this;
  357. }
  358. public Criteria andTeamidNotBetween(String value1, String value2) {
  359. addCriterion("USR_TEAMID not between", value1, value2, "teamid");
  360. return (Criteria) this;
  361. }
  362. public Criteria andDescIsNull() {
  363. addCriterion("USR_DESC is null");
  364. return (Criteria) this;
  365. }
  366. public Criteria andDescIsNotNull() {
  367. addCriterion("USR_DESC is not null");
  368. return (Criteria) this;
  369. }
  370. public Criteria andDescEqualTo(String value) {
  371. if(value == null ){
  372. andDescIsNull();
  373. } else {
  374. addCriterion("USR_DESC =", value, "desc");
  375. }
  376. return (Criteria) this;
  377. }
  378. public Criteria andDescNotEqualTo(String value) {
  379. if(value == null ){
  380. andDescIsNotNull();
  381. } else {
  382. addCriterion("USR_DESC <>", value, "desc");
  383. }
  384. return (Criteria) this;
  385. }
  386. public Criteria andDescGreaterThan(String value) {
  387. addCriterion("USR_DESC >", value, "desc");
  388. return (Criteria) this;
  389. }
  390. public Criteria andDescGreaterThanOrEqualTo(String value) {
  391. addCriterion("USR_DESC >=", value, "desc");
  392. return (Criteria) this;
  393. }
  394. public Criteria andDescLessThan(String value) {
  395. addCriterion("USR_DESC <", value, "desc");
  396. return (Criteria) this;
  397. }
  398. public Criteria andDescLessThanOrEqualTo(String value) {
  399. addCriterion("USR_DESC <=", value, "desc");
  400. return (Criteria) this;
  401. }
  402. public Criteria andDescLike(String value) {
  403. addCriterion("USR_DESC like", value, "desc");
  404. return (Criteria) this;
  405. }
  406. public Criteria andDescNotLike(String value) {
  407. addCriterion("USR_DESC not like", value, "desc");
  408. return (Criteria) this;
  409. }
  410. public Criteria andDescIn(List<String> values) {
  411. addCriterion("USR_DESC in", values, "desc");
  412. return (Criteria) this;
  413. }
  414. public Criteria andDescNotIn(List<String> values) {
  415. addCriterion("USR_DESC not in", values, "desc");
  416. return (Criteria) this;
  417. }
  418. public Criteria andDescBetween(String value1, String value2) {
  419. addCriterion("USR_DESC between", value1, value2, "desc");
  420. return (Criteria) this;
  421. }
  422. public Criteria andDescNotBetween(String value1, String value2) {
  423. addCriterion("USR_DESC not between", value1, value2, "desc");
  424. return (Criteria) this;
  425. }
  426. public Criteria andCreatedateIsNull() {
  427. addCriterion("USR_CREATEDATE is null");
  428. return (Criteria) this;
  429. }
  430. public Criteria andCreatedateIsNotNull() {
  431. addCriterion("USR_CREATEDATE is not null");
  432. return (Criteria) this;
  433. }
  434. public Criteria andCreatedateEqualTo(String value) {
  435. if(value == null ){
  436. andCreatedateIsNull();
  437. } else {
  438. addCriterion("USR_CREATEDATE =", value, "createdate");
  439. }
  440. return (Criteria) this;
  441. }
  442. public Criteria andCreatedateNotEqualTo(String value) {
  443. if(value == null ){
  444. andCreatedateIsNotNull();
  445. } else {
  446. addCriterion("USR_CREATEDATE <>", value, "createdate");
  447. }
  448. return (Criteria) this;
  449. }
  450. public Criteria andCreatedateGreaterThan(String value) {
  451. addCriterion("USR_CREATEDATE >", value, "createdate");
  452. return (Criteria) this;
  453. }
  454. public Criteria andCreatedateGreaterThanOrEqualTo(String value) {
  455. addCriterion("USR_CREATEDATE >=", value, "createdate");
  456. return (Criteria) this;
  457. }
  458. public Criteria andCreatedateLessThan(String value) {
  459. addCriterion("USR_CREATEDATE <", value, "createdate");
  460. return (Criteria) this;
  461. }
  462. public Criteria andCreatedateLessThanOrEqualTo(String value) {
  463. addCriterion("USR_CREATEDATE <=", value, "createdate");
  464. return (Criteria) this;
  465. }
  466. public Criteria andCreatedateLike(String value) {
  467. addCriterion("USR_CREATEDATE like", value, "createdate");
  468. return (Criteria) this;
  469. }
  470. public Criteria andCreatedateNotLike(String value) {
  471. addCriterion("USR_CREATEDATE not like", value, "createdate");
  472. return (Criteria) this;
  473. }
  474. public Criteria andCreatedateIn(List<String> values) {
  475. addCriterion("USR_CREATEDATE in", values, "createdate");
  476. return (Criteria) this;
  477. }
  478. public Criteria andCreatedateNotIn(List<String> values) {
  479. addCriterion("USR_CREATEDATE not in", values, "createdate");
  480. return (Criteria) this;
  481. }
  482. public Criteria andCreatedateBetween(String value1, String value2) {
  483. addCriterion("USR_CREATEDATE between", value1, value2, "createdate");
  484. return (Criteria) this;
  485. }
  486. public Criteria andCreatedateNotBetween(String value1, String value2) {
  487. addCriterion("USR_CREATEDATE not between", value1, value2, "createdate");
  488. return (Criteria) this;
  489. }
  490. public Criteria andSttIsNull() {
  491. addCriterion("USR_STT is null");
  492. return (Criteria) this;
  493. }
  494. public Criteria andSttIsNotNull() {
  495. addCriterion("USR_STT is not null");
  496. return (Criteria) this;
  497. }
  498. public Criteria andSttEqualTo(String value) {
  499. if(value == null ){
  500. andSttIsNull();
  501. } else {
  502. addCriterion("USR_STT =", value, "stt");
  503. }
  504. return (Criteria) this;
  505. }
  506. public Criteria andSttNotEqualTo(String value) {
  507. if(value == null ){
  508. andSttIsNotNull();
  509. } else {
  510. addCriterion("USR_STT <>", value, "stt");
  511. }
  512. return (Criteria) this;
  513. }
  514. public Criteria andSttGreaterThan(String value) {
  515. addCriterion("USR_STT >", value, "stt");
  516. return (Criteria) this;
  517. }
  518. public Criteria andSttGreaterThanOrEqualTo(String value) {
  519. addCriterion("USR_STT >=", value, "stt");
  520. return (Criteria) this;
  521. }
  522. public Criteria andSttLessThan(String value) {
  523. addCriterion("USR_STT <", value, "stt");
  524. return (Criteria) this;
  525. }
  526. public Criteria andSttLessThanOrEqualTo(String value) {
  527. addCriterion("USR_STT <=", value, "stt");
  528. return (Criteria) this;
  529. }
  530. public Criteria andSttLike(String value) {
  531. addCriterion("USR_STT like", value, "stt");
  532. return (Criteria) this;
  533. }
  534. public Criteria andSttNotLike(String value) {
  535. addCriterion("USR_STT not like", value, "stt");
  536. return (Criteria) this;
  537. }
  538. public Criteria andSttIn(List<String> values) {
  539. addCriterion("USR_STT in", values, "stt");
  540. return (Criteria) this;
  541. }
  542. public Criteria andSttNotIn(List<String> values) {
  543. addCriterion("USR_STT not in", values, "stt");
  544. return (Criteria) this;
  545. }
  546. public Criteria andSttBetween(String value1, String value2) {
  547. addCriterion("USR_STT between", value1, value2, "stt");
  548. return (Criteria) this;
  549. }
  550. public Criteria andSttNotBetween(String value1, String value2) {
  551. addCriterion("USR_STT not between", value1, value2, "stt");
  552. return (Criteria) this;
  553. }
  554. public Criteria andStartdateIsNull() {
  555. addCriterion("USR_STARTDATE is null");
  556. return (Criteria) this;
  557. }
  558. public Criteria andStartdateIsNotNull() {
  559. addCriterion("USR_STARTDATE is not null");
  560. return (Criteria) this;
  561. }
  562. public Criteria andStartdateEqualTo(String value) {
  563. if(value == null ){
  564. andStartdateIsNull();
  565. } else {
  566. addCriterion("USR_STARTDATE =", value, "startdate");
  567. }
  568. return (Criteria) this;
  569. }
  570. public Criteria andStartdateNotEqualTo(String value) {
  571. if(value == null ){
  572. andStartdateIsNotNull();
  573. } else {
  574. addCriterion("USR_STARTDATE <>", value, "startdate");
  575. }
  576. return (Criteria) this;
  577. }
  578. public Criteria andStartdateGreaterThan(String value) {
  579. addCriterion("USR_STARTDATE >", value, "startdate");
  580. return (Criteria) this;
  581. }
  582. public Criteria andStartdateGreaterThanOrEqualTo(String value) {
  583. addCriterion("USR_STARTDATE >=", value, "startdate");
  584. return (Criteria) this;
  585. }
  586. public Criteria andStartdateLessThan(String value) {
  587. addCriterion("USR_STARTDATE <", value, "startdate");
  588. return (Criteria) this;
  589. }
  590. public Criteria andStartdateLessThanOrEqualTo(String value) {
  591. addCriterion("USR_STARTDATE <=", value, "startdate");
  592. return (Criteria) this;
  593. }
  594. public Criteria andStartdateLike(String value) {
  595. addCriterion("USR_STARTDATE like", value, "startdate");
  596. return (Criteria) this;
  597. }
  598. public Criteria andStartdateNotLike(String value) {
  599. addCriterion("USR_STARTDATE not like", value, "startdate");
  600. return (Criteria) this;
  601. }
  602. public Criteria andStartdateIn(List<String> values) {
  603. addCriterion("USR_STARTDATE in", values, "startdate");
  604. return (Criteria) this;
  605. }
  606. public Criteria andStartdateNotIn(List<String> values) {
  607. addCriterion("USR_STARTDATE not in", values, "startdate");
  608. return (Criteria) this;
  609. }
  610. public Criteria andStartdateBetween(String value1, String value2) {
  611. addCriterion("USR_STARTDATE between", value1, value2, "startdate");
  612. return (Criteria) this;
  613. }
  614. public Criteria andStartdateNotBetween(String value1, String value2) {
  615. addCriterion("USR_STARTDATE not between", value1, value2, "startdate");
  616. return (Criteria) this;
  617. }
  618. public Criteria andEnddateIsNull() {
  619. addCriterion("USR_ENDDATE is null");
  620. return (Criteria) this;
  621. }
  622. public Criteria andEnddateIsNotNull() {
  623. addCriterion("USR_ENDDATE is not null");
  624. return (Criteria) this;
  625. }
  626. public Criteria andEnddateEqualTo(String value) {
  627. if(value == null ){
  628. andEnddateIsNull();
  629. } else {
  630. addCriterion("USR_ENDDATE =", value, "enddate");
  631. }
  632. return (Criteria) this;
  633. }
  634. public Criteria andEnddateNotEqualTo(String value) {
  635. if(value == null ){
  636. andEnddateIsNotNull();
  637. } else {
  638. addCriterion("USR_ENDDATE <>", value, "enddate");
  639. }
  640. return (Criteria) this;
  641. }
  642. public Criteria andEnddateGreaterThan(String value) {
  643. addCriterion("USR_ENDDATE >", value, "enddate");
  644. return (Criteria) this;
  645. }
  646. public Criteria andEnddateGreaterThanOrEqualTo(String value) {
  647. addCriterion("USR_ENDDATE >=", value, "enddate");
  648. return (Criteria) this;
  649. }
  650. public Criteria andEnddateLessThan(String value) {
  651. addCriterion("USR_ENDDATE <", value, "enddate");
  652. return (Criteria) this;
  653. }
  654. public Criteria andEnddateLessThanOrEqualTo(String value) {
  655. addCriterion("USR_ENDDATE <=", value, "enddate");
  656. return (Criteria) this;
  657. }
  658. public Criteria andEnddateLike(String value) {
  659. addCriterion("USR_ENDDATE like", value, "enddate");
  660. return (Criteria) this;
  661. }
  662. public Criteria andEnddateNotLike(String value) {
  663. addCriterion("USR_ENDDATE not like", value, "enddate");
  664. return (Criteria) this;
  665. }
  666. public Criteria andEnddateIn(List<String> values) {
  667. addCriterion("USR_ENDDATE in", values, "enddate");
  668. return (Criteria) this;
  669. }
  670. public Criteria andEnddateNotIn(List<String> values) {
  671. addCriterion("USR_ENDDATE not in", values, "enddate");
  672. return (Criteria) this;
  673. }
  674. public Criteria andEnddateBetween(String value1, String value2) {
  675. addCriterion("USR_ENDDATE between", value1, value2, "enddate");
  676. return (Criteria) this;
  677. }
  678. public Criteria andEnddateNotBetween(String value1, String value2) {
  679. addCriterion("USR_ENDDATE not between", value1, value2, "enddate");
  680. return (Criteria) this;
  681. }
  682. public Criteria andLastmodpwdcgdateIsNull() {
  683. addCriterion("USR_LASTMODPWDCGDATE is null");
  684. return (Criteria) this;
  685. }
  686. public Criteria andLastmodpwdcgdateIsNotNull() {
  687. addCriterion("USR_LASTMODPWDCGDATE is not null");
  688. return (Criteria) this;
  689. }
  690. public Criteria andLastmodpwdcgdateEqualTo(String value) {
  691. if(value == null ){
  692. andLastmodpwdcgdateIsNull();
  693. } else {
  694. addCriterion("USR_LASTMODPWDCGDATE =", value, "lastmodpwdcgdate");
  695. }
  696. return (Criteria) this;
  697. }
  698. public Criteria andLastmodpwdcgdateNotEqualTo(String value) {
  699. if(value == null ){
  700. andLastmodpwdcgdateIsNotNull();
  701. } else {
  702. addCriterion("USR_LASTMODPWDCGDATE <>", value, "lastmodpwdcgdate");
  703. }
  704. return (Criteria) this;
  705. }
  706. public Criteria andLastmodpwdcgdateGreaterThan(String value) {
  707. addCriterion("USR_LASTMODPWDCGDATE >", value, "lastmodpwdcgdate");
  708. return (Criteria) this;
  709. }
  710. public Criteria andLastmodpwdcgdateGreaterThanOrEqualTo(String value) {
  711. addCriterion("USR_LASTMODPWDCGDATE >=", value, "lastmodpwdcgdate");
  712. return (Criteria) this;
  713. }
  714. public Criteria andLastmodpwdcgdateLessThan(String value) {
  715. addCriterion("USR_LASTMODPWDCGDATE <", value, "lastmodpwdcgdate");
  716. return (Criteria) this;
  717. }
  718. public Criteria andLastmodpwdcgdateLessThanOrEqualTo(String value) {
  719. addCriterion("USR_LASTMODPWDCGDATE <=", value, "lastmodpwdcgdate");
  720. return (Criteria) this;
  721. }
  722. public Criteria andLastmodpwdcgdateLike(String value) {
  723. addCriterion("USR_LASTMODPWDCGDATE like", value, "lastmodpwdcgdate");
  724. return (Criteria) this;
  725. }
  726. public Criteria andLastmodpwdcgdateNotLike(String value) {
  727. addCriterion("USR_LASTMODPWDCGDATE not like", value, "lastmodpwdcgdate");
  728. return (Criteria) this;
  729. }
  730. public Criteria andLastmodpwdcgdateIn(List<String> values) {
  731. addCriterion("USR_LASTMODPWDCGDATE in", values, "lastmodpwdcgdate");
  732. return (Criteria) this;
  733. }
  734. public Criteria andLastmodpwdcgdateNotIn(List<String> values) {
  735. addCriterion("USR_LASTMODPWDCGDATE not in", values, "lastmodpwdcgdate");
  736. return (Criteria) this;
  737. }
  738. public Criteria andLastmodpwdcgdateBetween(String value1, String value2) {
  739. addCriterion("USR_LASTMODPWDCGDATE between", value1, value2, "lastmodpwdcgdate");
  740. return (Criteria) this;
  741. }
  742. public Criteria andLastmodpwdcgdateNotBetween(String value1, String value2) {
  743. addCriterion("USR_LASTMODPWDCGDATE not between", value1, value2, "lastmodpwdcgdate");
  744. return (Criteria) this;
  745. }
  746. public Criteria andImgIsNull() {
  747. addCriterion("USR_IMG is null");
  748. return (Criteria) this;
  749. }
  750. public Criteria andImgIsNotNull() {
  751. addCriterion("USR_IMG is not null");
  752. return (Criteria) this;
  753. }
  754. public Criteria andImgEqualTo(String value) {
  755. if(value == null ){
  756. andImgIsNull();
  757. } else {
  758. addCriterion("USR_IMG =", value, "img");
  759. }
  760. return (Criteria) this;
  761. }
  762. public Criteria andImgNotEqualTo(String value) {
  763. if(value == null ){
  764. andImgIsNotNull();
  765. } else {
  766. addCriterion("USR_IMG <>", value, "img");
  767. }
  768. return (Criteria) this;
  769. }
  770. public Criteria andImgGreaterThan(String value) {
  771. addCriterion("USR_IMG >", value, "img");
  772. return (Criteria) this;
  773. }
  774. public Criteria andImgGreaterThanOrEqualTo(String value) {
  775. addCriterion("USR_IMG >=", value, "img");
  776. return (Criteria) this;
  777. }
  778. public Criteria andImgLessThan(String value) {
  779. addCriterion("USR_IMG <", value, "img");
  780. return (Criteria) this;
  781. }
  782. public Criteria andImgLessThanOrEqualTo(String value) {
  783. addCriterion("USR_IMG <=", value, "img");
  784. return (Criteria) this;
  785. }
  786. public Criteria andImgLike(String value) {
  787. addCriterion("USR_IMG like", value, "img");
  788. return (Criteria) this;
  789. }
  790. public Criteria andImgNotLike(String value) {
  791. addCriterion("USR_IMG not like", value, "img");
  792. return (Criteria) this;
  793. }
  794. public Criteria andImgIn(List<String> values) {
  795. addCriterion("USR_IMG in", values, "img");
  796. return (Criteria) this;
  797. }
  798. public Criteria andImgNotIn(List<String> values) {
  799. addCriterion("USR_IMG not in", values, "img");
  800. return (Criteria) this;
  801. }
  802. public Criteria andImgBetween(String value1, String value2) {
  803. addCriterion("USR_IMG between", value1, value2, "img");
  804. return (Criteria) this;
  805. }
  806. public Criteria andImgNotBetween(String value1, String value2) {
  807. addCriterion("USR_IMG not between", value1, value2, "img");
  808. return (Criteria) this;
  809. }
  810. public Criteria andOutdateIsNull() {
  811. addCriterion("USR_OUTDATE is null");
  812. return (Criteria) this;
  813. }
  814. public Criteria andOutdateIsNotNull() {
  815. addCriterion("USR_OUTDATE is not null");
  816. return (Criteria) this;
  817. }
  818. public Criteria andOutdateEqualTo(String value) {
  819. if(value == null ){
  820. andOutdateIsNull();
  821. } else {
  822. addCriterion("USR_OUTDATE =", value, "outdate");
  823. }
  824. return (Criteria) this;
  825. }
  826. public Criteria andOutdateNotEqualTo(String value) {
  827. if(value == null ){
  828. andOutdateIsNotNull();
  829. } else {
  830. addCriterion("USR_OUTDATE <>", value, "outdate");
  831. }
  832. return (Criteria) this;
  833. }
  834. public Criteria andOutdateGreaterThan(String value) {
  835. addCriterion("USR_OUTDATE >", value, "outdate");
  836. return (Criteria) this;
  837. }
  838. public Criteria andOutdateGreaterThanOrEqualTo(String value) {
  839. addCriterion("USR_OUTDATE >=", value, "outdate");
  840. return (Criteria) this;
  841. }
  842. public Criteria andOutdateLessThan(String value) {
  843. addCriterion("USR_OUTDATE <", value, "outdate");
  844. return (Criteria) this;
  845. }
  846. public Criteria andOutdateLessThanOrEqualTo(String value) {
  847. addCriterion("USR_OUTDATE <=", value, "outdate");
  848. return (Criteria) this;
  849. }
  850. public Criteria andOutdateLike(String value) {
  851. addCriterion("USR_OUTDATE like", value, "outdate");
  852. return (Criteria) this;
  853. }
  854. public Criteria andOutdateNotLike(String value) {
  855. addCriterion("USR_OUTDATE not like", value, "outdate");
  856. return (Criteria) this;
  857. }
  858. public Criteria andOutdateIn(List<String> values) {
  859. addCriterion("USR_OUTDATE in", values, "outdate");
  860. return (Criteria) this;
  861. }
  862. public Criteria andOutdateNotIn(List<String> values) {
  863. addCriterion("USR_OUTDATE not in", values, "outdate");
  864. return (Criteria) this;
  865. }
  866. public Criteria andOutdateBetween(String value1, String value2) {
  867. addCriterion("USR_OUTDATE between", value1, value2, "outdate");
  868. return (Criteria) this;
  869. }
  870. public Criteria andOutdateNotBetween(String value1, String value2) {
  871. addCriterion("USR_OUTDATE not between", value1, value2, "outdate");
  872. return (Criteria) this;
  873. }
  874. }
  875. /**
  876. * This class was generated by MyBatis Generator.
  877. * This class corresponds to the database table jg_user_inf
  878. *
  879. * @mbggenerated do_not_delete_during_merge
  880. */
  881. public static class Criteria extends GeneratedCriteria {
  882. protected Criteria() {
  883. super();
  884. }
  885. }
  886. /**
  887. * This class was generated by MyBatis Generator.
  888. * This class corresponds to the database table jg_user_inf
  889. *
  890. * @mbggenerated
  891. */
  892. public static class Criterion {
  893. private String condition;
  894. private Object value;
  895. private Object secondValue;
  896. private boolean noValue;
  897. private boolean singleValue;
  898. private boolean betweenValue;
  899. private boolean listValue;
  900. public String getCondition() {
  901. return condition;
  902. }
  903. public Object getValue() {
  904. return value;
  905. }
  906. public Object getSecondValue() {
  907. return secondValue;
  908. }
  909. public boolean isNoValue() {
  910. return noValue;
  911. }
  912. public boolean isSingleValue() {
  913. return singleValue;
  914. }
  915. public boolean isBetweenValue() {
  916. return betweenValue;
  917. }
  918. public boolean isListValue() {
  919. return listValue;
  920. }
  921. protected Criterion(String condition) {
  922. super();
  923. this.condition = condition;
  924. this.noValue = true;
  925. }
  926. protected Criterion(String condition, Object value) {
  927. super();
  928. this.condition = condition;
  929. this.value = value;
  930. if (value instanceof List<?>) {
  931. this.listValue = true;
  932. } else {
  933. this.singleValue = true;
  934. }
  935. }
  936. protected Criterion(String condition, Object value, Object secondValue) {
  937. super();
  938. this.condition = condition;
  939. this.value = value;
  940. this.secondValue = secondValue;
  941. this.betweenValue = true;
  942. }
  943. }
  944. }