ProtocolSQLBuilder.java 21 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681
  1. package com.miniframe.model.system;
  2. import java.util.ArrayList;
  3. import java.util.Date;
  4. import java.util.List;
  5. public class ProtocolSQLBuilder {
  6. protected String orderByClause;
  7. protected boolean distinct;
  8. protected List<Criteria> oredCriteria;
  9. public ProtocolSQLBuilder() {
  10. oredCriteria = new ArrayList<Criteria>();
  11. }
  12. public void setOrderByClause(String orderByClause) {
  13. this.orderByClause = orderByClause;
  14. }
  15. public String getOrderByClause() {
  16. return orderByClause;
  17. }
  18. public void setDistinct(boolean distinct) {
  19. this.distinct = distinct;
  20. }
  21. public boolean isDistinct() {
  22. return distinct;
  23. }
  24. public List<Criteria> getOredCriteria() {
  25. return oredCriteria;
  26. }
  27. public void or(Criteria criteria) {
  28. oredCriteria.add(criteria);
  29. }
  30. public Criteria or() {
  31. Criteria criteria = createCriteriaInternal();
  32. oredCriteria.add(criteria);
  33. return criteria;
  34. }
  35. public Criteria createCriteria() {
  36. Criteria criteria = createCriteriaInternal();
  37. if (oredCriteria.size() == 0) {
  38. oredCriteria.add(criteria);
  39. }
  40. return criteria;
  41. }
  42. protected Criteria createCriteriaInternal() {
  43. Criteria criteria = new Criteria();
  44. return criteria;
  45. }
  46. public void clear() {
  47. oredCriteria.clear();
  48. orderByClause = null;
  49. distinct = false;
  50. }
  51. protected abstract static class GeneratedCriteria {
  52. protected List<Criterion> criteria;
  53. protected GeneratedCriteria() {
  54. super();
  55. criteria = new ArrayList<Criterion>();
  56. }
  57. public boolean isValid() {
  58. return criteria.size() > 0;
  59. }
  60. public List<Criterion> getAllCriteria() {
  61. return criteria;
  62. }
  63. public List<Criterion> getCriteria() {
  64. return criteria;
  65. }
  66. protected void addCriterion(String condition) {
  67. if (condition == null) {
  68. throw new RuntimeException("Value for condition cannot be null");
  69. }
  70. criteria.add(new Criterion(condition));
  71. }
  72. protected void addCriterion(String condition, Object value, String property) {
  73. if (value == null) {
  74. throw new RuntimeException("Value for " + property + " cannot be null");
  75. }
  76. criteria.add(new Criterion(condition, value));
  77. }
  78. protected void addCriterion(String condition, Object value1, Object value2, String property) {
  79. if (value1 == null || value2 == null) {
  80. throw new RuntimeException("Between values for " + property + " cannot be null");
  81. }
  82. criteria.add(new Criterion(condition, value1, value2));
  83. }
  84. public Criteria andIdIsNull() {
  85. addCriterion("id is null");
  86. return (Criteria) this;
  87. }
  88. public Criteria andIdIsNotNull() {
  89. addCriterion("id is not null");
  90. return (Criteria) this;
  91. }
  92. public Criteria andIdEqualTo(String value) {
  93. addCriterion("id =", value, "id");
  94. return (Criteria) this;
  95. }
  96. public Criteria andIdNotEqualTo(String value) {
  97. addCriterion("id <>", value, "id");
  98. return (Criteria) this;
  99. }
  100. public Criteria andIdGreaterThan(String value) {
  101. addCriterion("id >", value, "id");
  102. return (Criteria) this;
  103. }
  104. public Criteria andIdGreaterThanOrEqualTo(String value) {
  105. addCriterion("id >=", value, "id");
  106. return (Criteria) this;
  107. }
  108. public Criteria andIdLessThan(String value) {
  109. addCriterion("id <", value, "id");
  110. return (Criteria) this;
  111. }
  112. public Criteria andIdLessThanOrEqualTo(String value) {
  113. addCriterion("id <=", value, "id");
  114. return (Criteria) this;
  115. }
  116. public Criteria andIdLike(String value) {
  117. addCriterion("id like", value, "id");
  118. return (Criteria) this;
  119. }
  120. public Criteria andIdNotLike(String value) {
  121. addCriterion("id not like", value, "id");
  122. return (Criteria) this;
  123. }
  124. public Criteria andIdIn(List<String> values) {
  125. addCriterion("id in", values, "id");
  126. return (Criteria) this;
  127. }
  128. public Criteria andIdNotIn(List<String> values) {
  129. addCriterion("id not in", values, "id");
  130. return (Criteria) this;
  131. }
  132. public Criteria andIdBetween(String value1, String value2) {
  133. addCriterion("id between", value1, value2, "id");
  134. return (Criteria) this;
  135. }
  136. public Criteria andIdNotBetween(String value1, String value2) {
  137. addCriterion("id not between", value1, value2, "id");
  138. return (Criteria) this;
  139. }
  140. public Criteria andProtocolIdIsNull() {
  141. addCriterion("protocol_id is null");
  142. return (Criteria) this;
  143. }
  144. public Criteria andProtocolIdIsNotNull() {
  145. addCriterion("protocol_id is not null");
  146. return (Criteria) this;
  147. }
  148. public Criteria andProtocolIdEqualTo(String value) {
  149. addCriterion("protocol_id =", value, "protocolId");
  150. return (Criteria) this;
  151. }
  152. public Criteria andProtocolIdNotEqualTo(String value) {
  153. addCriterion("protocol_id <>", value, "protocolId");
  154. return (Criteria) this;
  155. }
  156. public Criteria andProtocolIdGreaterThan(String value) {
  157. addCriterion("protocol_id >", value, "protocolId");
  158. return (Criteria) this;
  159. }
  160. public Criteria andProtocolIdGreaterThanOrEqualTo(String value) {
  161. addCriterion("protocol_id >=", value, "protocolId");
  162. return (Criteria) this;
  163. }
  164. public Criteria andProtocolIdLessThan(String value) {
  165. addCriterion("protocol_id <", value, "protocolId");
  166. return (Criteria) this;
  167. }
  168. public Criteria andProtocolIdLessThanOrEqualTo(String value) {
  169. addCriterion("protocol_id <=", value, "protocolId");
  170. return (Criteria) this;
  171. }
  172. public Criteria andProtocolIdLike(String value) {
  173. addCriterion("protocol_id like", value, "protocolId");
  174. return (Criteria) this;
  175. }
  176. public Criteria andProtocolIdNotLike(String value) {
  177. addCriterion("protocol_id not like", value, "protocolId");
  178. return (Criteria) this;
  179. }
  180. public Criteria andProtocolIdIn(List<String> values) {
  181. addCriterion("protocol_id in", values, "protocolId");
  182. return (Criteria) this;
  183. }
  184. public Criteria andProtocolIdNotIn(List<String> values) {
  185. addCriterion("protocol_id not in", values, "protocolId");
  186. return (Criteria) this;
  187. }
  188. public Criteria andProtocolIdBetween(String value1, String value2) {
  189. addCriterion("protocol_id between", value1, value2, "protocolId");
  190. return (Criteria) this;
  191. }
  192. public Criteria andProtocolIdNotBetween(String value1, String value2) {
  193. addCriterion("protocol_id not between", value1, value2, "protocolId");
  194. return (Criteria) this;
  195. }
  196. public Criteria andContentIsNull() {
  197. addCriterion("content is null");
  198. return (Criteria) this;
  199. }
  200. public Criteria andContentIsNotNull() {
  201. addCriterion("content is not null");
  202. return (Criteria) this;
  203. }
  204. public Criteria andContentEqualTo(String value) {
  205. addCriterion("content =", value, "content");
  206. return (Criteria) this;
  207. }
  208. public Criteria andContentNotEqualTo(String value) {
  209. addCriterion("content <>", value, "content");
  210. return (Criteria) this;
  211. }
  212. public Criteria andContentGreaterThan(String value) {
  213. addCriterion("content >", value, "content");
  214. return (Criteria) this;
  215. }
  216. public Criteria andContentGreaterThanOrEqualTo(String value) {
  217. addCriterion("content >=", value, "content");
  218. return (Criteria) this;
  219. }
  220. public Criteria andContentLessThan(String value) {
  221. addCriterion("content <", value, "content");
  222. return (Criteria) this;
  223. }
  224. public Criteria andContentLessThanOrEqualTo(String value) {
  225. addCriterion("content <=", value, "content");
  226. return (Criteria) this;
  227. }
  228. public Criteria andContentLike(String value) {
  229. addCriterion("content like", value, "content");
  230. return (Criteria) this;
  231. }
  232. public Criteria andContentNotLike(String value) {
  233. addCriterion("content not like", value, "content");
  234. return (Criteria) this;
  235. }
  236. public Criteria andContentIn(List<String> values) {
  237. addCriterion("content in", values, "content");
  238. return (Criteria) this;
  239. }
  240. public Criteria andContentNotIn(List<String> values) {
  241. addCriterion("content not in", values, "content");
  242. return (Criteria) this;
  243. }
  244. public Criteria andContentBetween(String value1, String value2) {
  245. addCriterion("content between", value1, value2, "content");
  246. return (Criteria) this;
  247. }
  248. public Criteria andContentNotBetween(String value1, String value2) {
  249. addCriterion("content not between", value1, value2, "content");
  250. return (Criteria) this;
  251. }
  252. public Criteria andProtNameIsNull() {
  253. addCriterion("prot_name is null");
  254. return (Criteria) this;
  255. }
  256. public Criteria andProtNameIsNotNull() {
  257. addCriterion("prot_name is not null");
  258. return (Criteria) this;
  259. }
  260. public Criteria andProtNameEqualTo(String value) {
  261. addCriterion("prot_name =", value, "protName");
  262. return (Criteria) this;
  263. }
  264. public Criteria andProtNameNotEqualTo(String value) {
  265. addCriterion("prot_name <>", value, "protName");
  266. return (Criteria) this;
  267. }
  268. public Criteria andProtNameGreaterThan(String value) {
  269. addCriterion("prot_name >", value, "protName");
  270. return (Criteria) this;
  271. }
  272. public Criteria andProtNameGreaterThanOrEqualTo(String value) {
  273. addCriterion("prot_name >=", value, "protName");
  274. return (Criteria) this;
  275. }
  276. public Criteria andProtNameLessThan(String value) {
  277. addCriterion("prot_name <", value, "protName");
  278. return (Criteria) this;
  279. }
  280. public Criteria andProtNameLessThanOrEqualTo(String value) {
  281. addCriterion("prot_name <=", value, "protName");
  282. return (Criteria) this;
  283. }
  284. public Criteria andProtNameLike(String value) {
  285. addCriterion("prot_name like", value, "protName");
  286. return (Criteria) this;
  287. }
  288. public Criteria andProtNameNotLike(String value) {
  289. addCriterion("prot_name not like", value, "protName");
  290. return (Criteria) this;
  291. }
  292. public Criteria andProtNameIn(List<String> values) {
  293. addCriterion("prot_name in", values, "protName");
  294. return (Criteria) this;
  295. }
  296. public Criteria andProtNameNotIn(List<String> values) {
  297. addCriterion("prot_name not in", values, "protName");
  298. return (Criteria) this;
  299. }
  300. public Criteria andProtNameBetween(String value1, String value2) {
  301. addCriterion("prot_name between", value1, value2, "protName");
  302. return (Criteria) this;
  303. }
  304. public Criteria andProtNameNotBetween(String value1, String value2) {
  305. addCriterion("prot_name not between", value1, value2, "protName");
  306. return (Criteria) this;
  307. }
  308. public Criteria andProtDescIsNull() {
  309. addCriterion("prot_desc is null");
  310. return (Criteria) this;
  311. }
  312. public Criteria andProtDescIsNotNull() {
  313. addCriterion("prot_desc is not null");
  314. return (Criteria) this;
  315. }
  316. public Criteria andProtDescEqualTo(String value) {
  317. addCriterion("prot_desc =", value, "protDesc");
  318. return (Criteria) this;
  319. }
  320. public Criteria andProtDescNotEqualTo(String value) {
  321. addCriterion("prot_desc <>", value, "protDesc");
  322. return (Criteria) this;
  323. }
  324. public Criteria andProtDescGreaterThan(String value) {
  325. addCriterion("prot_desc >", value, "protDesc");
  326. return (Criteria) this;
  327. }
  328. public Criteria andProtDescGreaterThanOrEqualTo(String value) {
  329. addCriterion("prot_desc >=", value, "protDesc");
  330. return (Criteria) this;
  331. }
  332. public Criteria andProtDescLessThan(String value) {
  333. addCriterion("prot_desc <", value, "protDesc");
  334. return (Criteria) this;
  335. }
  336. public Criteria andProtDescLessThanOrEqualTo(String value) {
  337. addCriterion("prot_desc <=", value, "protDesc");
  338. return (Criteria) this;
  339. }
  340. public Criteria andProtDescLike(String value) {
  341. addCriterion("prot_desc like", value, "protDesc");
  342. return (Criteria) this;
  343. }
  344. public Criteria andProtDescNotLike(String value) {
  345. addCriterion("prot_desc not like", value, "protDesc");
  346. return (Criteria) this;
  347. }
  348. public Criteria andProtDescIn(List<String> values) {
  349. addCriterion("prot_desc in", values, "protDesc");
  350. return (Criteria) this;
  351. }
  352. public Criteria andProtDescNotIn(List<String> values) {
  353. addCriterion("prot_desc not in", values, "protDesc");
  354. return (Criteria) this;
  355. }
  356. public Criteria andProtDescBetween(String value1, String value2) {
  357. addCriterion("prot_desc between", value1, value2, "protDesc");
  358. return (Criteria) this;
  359. }
  360. public Criteria andProtDescNotBetween(String value1, String value2) {
  361. addCriterion("prot_desc not between", value1, value2, "protDesc");
  362. return (Criteria) this;
  363. }
  364. public Criteria andCreateTimeIsNull() {
  365. addCriterion("create_time is null");
  366. return (Criteria) this;
  367. }
  368. public Criteria andCreateTimeIsNotNull() {
  369. addCriterion("create_time is not null");
  370. return (Criteria) this;
  371. }
  372. public Criteria andCreateTimeEqualTo(Date value) {
  373. addCriterion("create_time =", value, "createTime");
  374. return (Criteria) this;
  375. }
  376. public Criteria andCreateTimeNotEqualTo(Date value) {
  377. addCriterion("create_time <>", value, "createTime");
  378. return (Criteria) this;
  379. }
  380. public Criteria andCreateTimeGreaterThan(Date value) {
  381. addCriterion("create_time >", value, "createTime");
  382. return (Criteria) this;
  383. }
  384. public Criteria andCreateTimeGreaterThanOrEqualTo(Date value) {
  385. addCriterion("create_time >=", value, "createTime");
  386. return (Criteria) this;
  387. }
  388. public Criteria andCreateTimeLessThan(Date value) {
  389. addCriterion("create_time <", value, "createTime");
  390. return (Criteria) this;
  391. }
  392. public Criteria andCreateTimeLessThanOrEqualTo(Date value) {
  393. addCriterion("create_time <=", value, "createTime");
  394. return (Criteria) this;
  395. }
  396. public Criteria andCreateTimeIn(List<Date> values) {
  397. addCriterion("create_time in", values, "createTime");
  398. return (Criteria) this;
  399. }
  400. public Criteria andCreateTimeNotIn(List<Date> values) {
  401. addCriterion("create_time not in", values, "createTime");
  402. return (Criteria) this;
  403. }
  404. public Criteria andCreateTimeBetween(Date value1, Date value2) {
  405. addCriterion("create_time between", value1, value2, "createTime");
  406. return (Criteria) this;
  407. }
  408. public Criteria andCreateTimeNotBetween(Date value1, Date value2) {
  409. addCriterion("create_time not between", value1, value2, "createTime");
  410. return (Criteria) this;
  411. }
  412. public Criteria andRemarksIsNull() {
  413. addCriterion("remarks is null");
  414. return (Criteria) this;
  415. }
  416. public Criteria andRemarksIsNotNull() {
  417. addCriterion("remarks is not null");
  418. return (Criteria) this;
  419. }
  420. public Criteria andRemarksEqualTo(String value) {
  421. addCriterion("remarks =", value, "remarks");
  422. return (Criteria) this;
  423. }
  424. public Criteria andRemarksNotEqualTo(String value) {
  425. addCriterion("remarks <>", value, "remarks");
  426. return (Criteria) this;
  427. }
  428. public Criteria andRemarksGreaterThan(String value) {
  429. addCriterion("remarks >", value, "remarks");
  430. return (Criteria) this;
  431. }
  432. public Criteria andRemarksGreaterThanOrEqualTo(String value) {
  433. addCriterion("remarks >=", value, "remarks");
  434. return (Criteria) this;
  435. }
  436. public Criteria andRemarksLessThan(String value) {
  437. addCriterion("remarks <", value, "remarks");
  438. return (Criteria) this;
  439. }
  440. public Criteria andRemarksLessThanOrEqualTo(String value) {
  441. addCriterion("remarks <=", value, "remarks");
  442. return (Criteria) this;
  443. }
  444. public Criteria andRemarksLike(String value) {
  445. addCriterion("remarks like", value, "remarks");
  446. return (Criteria) this;
  447. }
  448. public Criteria andRemarksNotLike(String value) {
  449. addCriterion("remarks not like", value, "remarks");
  450. return (Criteria) this;
  451. }
  452. public Criteria andRemarksIn(List<String> values) {
  453. addCriterion("remarks in", values, "remarks");
  454. return (Criteria) this;
  455. }
  456. public Criteria andRemarksNotIn(List<String> values) {
  457. addCriterion("remarks not in", values, "remarks");
  458. return (Criteria) this;
  459. }
  460. public Criteria andRemarksBetween(String value1, String value2) {
  461. addCriterion("remarks between", value1, value2, "remarks");
  462. return (Criteria) this;
  463. }
  464. public Criteria andRemarksNotBetween(String value1, String value2) {
  465. addCriterion("remarks not between", value1, value2, "remarks");
  466. return (Criteria) this;
  467. }
  468. }
  469. public static class Criteria extends GeneratedCriteria {
  470. protected Criteria() {
  471. super();
  472. }
  473. }
  474. public static class Criterion {
  475. private String condition;
  476. private Object value;
  477. private Object secondValue;
  478. private boolean noValue;
  479. private boolean singleValue;
  480. private boolean betweenValue;
  481. private boolean listValue;
  482. private String typeHandler;
  483. public String getCondition() {
  484. return condition;
  485. }
  486. public Object getValue() {
  487. return value;
  488. }
  489. public Object getSecondValue() {
  490. return secondValue;
  491. }
  492. public boolean isNoValue() {
  493. return noValue;
  494. }
  495. public boolean isSingleValue() {
  496. return singleValue;
  497. }
  498. public boolean isBetweenValue() {
  499. return betweenValue;
  500. }
  501. public boolean isListValue() {
  502. return listValue;
  503. }
  504. public String getTypeHandler() {
  505. return typeHandler;
  506. }
  507. protected Criterion(String condition) {
  508. super();
  509. this.condition = condition;
  510. this.typeHandler = null;
  511. this.noValue = true;
  512. }
  513. protected Criterion(String condition, Object value, String typeHandler) {
  514. super();
  515. this.condition = condition;
  516. this.value = value;
  517. this.typeHandler = typeHandler;
  518. if (value instanceof List<?>) {
  519. this.listValue = true;
  520. } else {
  521. this.singleValue = true;
  522. }
  523. }
  524. protected Criterion(String condition, Object value) {
  525. this(condition, value, null);
  526. }
  527. protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
  528. super();
  529. this.condition = condition;
  530. this.value = value;
  531. this.secondValue = secondValue;
  532. this.typeHandler = typeHandler;
  533. this.betweenValue = true;
  534. }
  535. protected Criterion(String condition, Object value, Object secondValue) {
  536. this(condition, value, secondValue, null);
  537. }
  538. }
  539. }