package com.miniframe.model.system; import java.util.ArrayList; import java.util.List; public class DWayResultSQLBuilder { protected String orderByClause; protected boolean distinct; protected List oredCriteria; public DWayResultSQLBuilder() { oredCriteria = new ArrayList(); } public void setOrderByClause(String orderByClause) { this.orderByClause = orderByClause; } public String getOrderByClause() { return orderByClause; } public void setDistinct(boolean distinct) { this.distinct = distinct; } public boolean isDistinct() { return distinct; } public List getOredCriteria() { return oredCriteria; } public void or(Criteria criteria) { oredCriteria.add(criteria); } public Criteria or() { Criteria criteria = createCriteriaInternal(); oredCriteria.add(criteria); return criteria; } public Criteria createCriteria() { Criteria criteria = createCriteriaInternal(); if (oredCriteria.size() == 0) { oredCriteria.add(criteria); } return criteria; } protected Criteria createCriteriaInternal() { Criteria criteria = new Criteria(); return criteria; } public void clear() { oredCriteria.clear(); orderByClause = null; distinct = false; } protected abstract static class GeneratedCriteria { protected List criteria; protected GeneratedCriteria() { super(); criteria = new ArrayList(); } public boolean isValid() { return criteria.size() > 0; } public List getAllCriteria() { return criteria; } public List getCriteria() { return criteria; } protected void addCriterion(String condition) { if (condition == null) { throw new RuntimeException("Value for condition cannot be null"); } criteria.add(new Criterion(condition)); } protected void addCriterion(String condition, Object value, String property) { if (value == null) { throw new RuntimeException("Value for " + property + " cannot be null"); } criteria.add(new Criterion(condition, value)); } protected void addCriterion(String condition, Object value1, Object value2, String property) { if (value1 == null || value2 == null) { throw new RuntimeException("Between values for " + property + " cannot be null"); } criteria.add(new Criterion(condition, value1, value2)); } public Criteria andIdIsNull() { addCriterion("id is null"); return (Criteria) this; } public Criteria andIdIsNotNull() { addCriterion("id is not null"); return (Criteria) this; } public Criteria andIdEqualTo(Integer value) { addCriterion("id =", value, "id"); return (Criteria) this; } public Criteria andIdNotEqualTo(Integer value) { addCriterion("id <>", value, "id"); return (Criteria) this; } public Criteria andIdGreaterThan(Integer value) { addCriterion("id >", value, "id"); return (Criteria) this; } public Criteria andIdGreaterThanOrEqualTo(Integer value) { addCriterion("id >=", value, "id"); return (Criteria) this; } public Criteria andIdLessThan(Integer value) { addCriterion("id <", value, "id"); return (Criteria) this; } public Criteria andIdLessThanOrEqualTo(Integer value) { addCriterion("id <=", value, "id"); return (Criteria) this; } public Criteria andIdIn(List values) { addCriterion("id in", values, "id"); return (Criteria) this; } public Criteria andIdNotIn(List values) { addCriterion("id not in", values, "id"); return (Criteria) this; } public Criteria andIdBetween(Integer value1, Integer value2) { addCriterion("id between", value1, value2, "id"); return (Criteria) this; } public Criteria andIdNotBetween(Integer value1, Integer value2) { addCriterion("id not between", value1, value2, "id"); return (Criteria) this; } public Criteria andAidIsNull() { addCriterion("aid is null"); return (Criteria) this; } public Criteria andAidIsNotNull() { addCriterion("aid is not null"); return (Criteria) this; } public Criteria andAidEqualTo(Integer value) { addCriterion("aid =", value, "aid"); return (Criteria) this; } public Criteria andAidNotEqualTo(Integer value) { addCriterion("aid <>", value, "aid"); return (Criteria) this; } public Criteria andAidGreaterThan(Integer value) { addCriterion("aid >", value, "aid"); return (Criteria) this; } public Criteria andAidGreaterThanOrEqualTo(Integer value) { addCriterion("aid >=", value, "aid"); return (Criteria) this; } public Criteria andAidLessThan(Integer value) { addCriterion("aid <", value, "aid"); return (Criteria) this; } public Criteria andAidLessThanOrEqualTo(Integer value) { addCriterion("aid <=", value, "aid"); return (Criteria) this; } public Criteria andAidIn(List values) { addCriterion("aid in", values, "aid"); return (Criteria) this; } public Criteria andAidNotIn(List values) { addCriterion("aid not in", values, "aid"); return (Criteria) this; } public Criteria andAidBetween(Integer value1, Integer value2) { addCriterion("aid between", value1, value2, "aid"); return (Criteria) this; } public Criteria andAidNotBetween(Integer value1, Integer value2) { addCriterion("aid not between", value1, value2, "aid"); return (Criteria) this; } public Criteria andJidIsNull() { addCriterion("jid is null"); return (Criteria) this; } public Criteria andJidIsNotNull() { addCriterion("jid is not null"); return (Criteria) this; } public Criteria andJidEqualTo(Integer value) { addCriterion("jid =", value, "jid"); return (Criteria) this; } public Criteria andJidNotEqualTo(Integer value) { addCriterion("jid <>", value, "jid"); return (Criteria) this; } public Criteria andJidGreaterThan(Integer value) { addCriterion("jid >", value, "jid"); return (Criteria) this; } public Criteria andJidGreaterThanOrEqualTo(Integer value) { addCriterion("jid >=", value, "jid"); return (Criteria) this; } public Criteria andJidLessThan(Integer value) { addCriterion("jid <", value, "jid"); return (Criteria) this; } public Criteria andJidLessThanOrEqualTo(Integer value) { addCriterion("jid <=", value, "jid"); return (Criteria) this; } public Criteria andJidIn(List values) { addCriterion("jid in", values, "jid"); return (Criteria) this; } public Criteria andJidNotIn(List values) { addCriterion("jid not in", values, "jid"); return (Criteria) this; } public Criteria andJidBetween(Integer value1, Integer value2) { addCriterion("jid between", value1, value2, "jid"); return (Criteria) this; } public Criteria andJidNotBetween(Integer value1, Integer value2) { addCriterion("jid not between", value1, value2, "jid"); return (Criteria) this; } public Criteria andPersonIsNull() { addCriterion("person is null"); return (Criteria) this; } public Criteria andPersonIsNotNull() { addCriterion("person is not null"); return (Criteria) this; } public Criteria andPersonEqualTo(String value) { addCriterion("person =", value, "person"); return (Criteria) this; } public Criteria andPersonNotEqualTo(String value) { addCriterion("person <>", value, "person"); return (Criteria) this; } public Criteria andPersonGreaterThan(String value) { addCriterion("person >", value, "person"); return (Criteria) this; } public Criteria andPersonGreaterThanOrEqualTo(String value) { addCriterion("person >=", value, "person"); return (Criteria) this; } public Criteria andPersonLessThan(String value) { addCriterion("person <", value, "person"); return (Criteria) this; } public Criteria andPersonLessThanOrEqualTo(String value) { addCriterion("person <=", value, "person"); return (Criteria) this; } public Criteria andPersonLike(String value) { addCriterion("person like", value, "person"); return (Criteria) this; } public Criteria andPersonNotLike(String value) { addCriterion("person not like", value, "person"); return (Criteria) this; } public Criteria andPersonIn(List values) { addCriterion("person in", values, "person"); return (Criteria) this; } public Criteria andPersonNotIn(List values) { addCriterion("person not in", values, "person"); return (Criteria) this; } public Criteria andPersonBetween(String value1, String value2) { addCriterion("person between", value1, value2, "person"); return (Criteria) this; } public Criteria andPersonNotBetween(String value1, String value2) { addCriterion("person not between", value1, value2, "person"); return (Criteria) this; } public Criteria andWcodeIsNull() { addCriterion("wcode is null"); return (Criteria) this; } public Criteria andWcodeIsNotNull() { addCriterion("wcode is not null"); return (Criteria) this; } public Criteria andWcodeEqualTo(String value) { addCriterion("wcode =", value, "wcode"); return (Criteria) this; } public Criteria andWcodeNotEqualTo(String value) { addCriterion("wcode <>", value, "wcode"); return (Criteria) this; } public Criteria andWcodeGreaterThan(String value) { addCriterion("wcode >", value, "wcode"); return (Criteria) this; } public Criteria andWcodeGreaterThanOrEqualTo(String value) { addCriterion("wcode >=", value, "wcode"); return (Criteria) this; } public Criteria andWcodeLessThan(String value) { addCriterion("wcode <", value, "wcode"); return (Criteria) this; } public Criteria andWcodeLessThanOrEqualTo(String value) { addCriterion("wcode <=", value, "wcode"); return (Criteria) this; } public Criteria andWcodeLike(String value) { addCriterion("wcode like", value, "wcode"); return (Criteria) this; } public Criteria andWcodeNotLike(String value) { addCriterion("wcode not like", value, "wcode"); return (Criteria) this; } public Criteria andWcodeIn(List values) { addCriterion("wcode in", values, "wcode"); return (Criteria) this; } public Criteria andWcodeNotIn(List values) { addCriterion("wcode not in", values, "wcode"); return (Criteria) this; } public Criteria andWcodeBetween(String value1, String value2) { addCriterion("wcode between", value1, value2, "wcode"); return (Criteria) this; } public Criteria andWcodeNotBetween(String value1, String value2) { addCriterion("wcode not between", value1, value2, "wcode"); return (Criteria) this; } public Criteria andSafetyIsNull() { addCriterion("safety is null"); return (Criteria) this; } public Criteria andSafetyIsNotNull() { addCriterion("safety is not null"); return (Criteria) this; } public Criteria andSafetyEqualTo(String value) { addCriterion("safety =", value, "safety"); return (Criteria) this; } public Criteria andSafetyNotEqualTo(String value) { addCriterion("safety <>", value, "safety"); return (Criteria) this; } public Criteria andSafetyGreaterThan(String value) { addCriterion("safety >", value, "safety"); return (Criteria) this; } public Criteria andSafetyGreaterThanOrEqualTo(String value) { addCriterion("safety >=", value, "safety"); return (Criteria) this; } public Criteria andSafetyLessThan(String value) { addCriterion("safety <", value, "safety"); return (Criteria) this; } public Criteria andSafetyLessThanOrEqualTo(String value) { addCriterion("safety <=", value, "safety"); return (Criteria) this; } public Criteria andSafetyLike(String value) { addCriterion("safety like", value, "safety"); return (Criteria) this; } public Criteria andSafetyNotLike(String value) { addCriterion("safety not like", value, "safety"); return (Criteria) this; } public Criteria andSafetyIn(List values) { addCriterion("safety in", values, "safety"); return (Criteria) this; } public Criteria andSafetyNotIn(List values) { addCriterion("safety not in", values, "safety"); return (Criteria) this; } public Criteria andSafetyBetween(String value1, String value2) { addCriterion("safety between", value1, value2, "safety"); return (Criteria) this; } public Criteria andSafetyNotBetween(String value1, String value2) { addCriterion("safety not between", value1, value2, "safety"); return (Criteria) this; } public Criteria andFlagIsNull() { addCriterion("flag is null"); return (Criteria) this; } public Criteria andFlagIsNotNull() { addCriterion("flag is not null"); return (Criteria) this; } public Criteria andFlagEqualTo(String value) { addCriterion("flag =", value, "flag"); return (Criteria) this; } public Criteria andFlagNotEqualTo(String value) { addCriterion("flag <>", value, "flag"); return (Criteria) this; } public Criteria andFlagGreaterThan(String value) { addCriterion("flag >", value, "flag"); return (Criteria) this; } public Criteria andFlagGreaterThanOrEqualTo(String value) { addCriterion("flag >=", value, "flag"); return (Criteria) this; } public Criteria andFlagLessThan(String value) { addCriterion("flag <", value, "flag"); return (Criteria) this; } public Criteria andFlagLessThanOrEqualTo(String value) { addCriterion("flag <=", value, "flag"); return (Criteria) this; } public Criteria andFlagLike(String value) { addCriterion("flag like", value, "flag"); return (Criteria) this; } public Criteria andFlagNotLike(String value) { addCriterion("flag not like", value, "flag"); return (Criteria) this; } public Criteria andFlagIn(List values) { addCriterion("flag in", values, "flag"); return (Criteria) this; } public Criteria andFlagNotIn(List values) { addCriterion("flag not in", values, "flag"); return (Criteria) this; } public Criteria andFlagBetween(String value1, String value2) { addCriterion("flag between", value1, value2, "flag"); return (Criteria) this; } public Criteria andFlagNotBetween(String value1, String value2) { addCriterion("flag not between", value1, value2, "flag"); return (Criteria) this; } } public static class Criteria extends GeneratedCriteria { protected Criteria() { super(); } } public static class Criterion { private String condition; private Object value; private Object secondValue; private boolean noValue; private boolean singleValue; private boolean betweenValue; private boolean listValue; private String typeHandler; public String getCondition() { return condition; } public Object getValue() { return value; } public Object getSecondValue() { return secondValue; } public boolean isNoValue() { return noValue; } public boolean isSingleValue() { return singleValue; } public boolean isBetweenValue() { return betweenValue; } public boolean isListValue() { return listValue; } public String getTypeHandler() { return typeHandler; } protected Criterion(String condition) { super(); this.condition = condition; this.typeHandler = null; this.noValue = true; } protected Criterion(String condition, Object value, String typeHandler) { super(); this.condition = condition; this.value = value; this.typeHandler = typeHandler; if (value instanceof List) { this.listValue = true; } else { this.singleValue = true; } } protected Criterion(String condition, Object value) { this(condition, value, null); } protected Criterion(String condition, Object value, Object secondValue, String typeHandler) { super(); this.condition = condition; this.value = value; this.secondValue = secondValue; this.typeHandler = typeHandler; this.betweenValue = true; } protected Criterion(String condition, Object value, Object secondValue) { this(condition, value, secondValue, null); } } }