package com.miniframe.model.mdo; import java.util.ArrayList; import java.util.List; public class MdoProjectVariateSQLBuilder { protected String orderByClause; protected boolean distinct; protected List oredCriteria; public MdoProjectVariateSQLBuilder() { 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(String value) { addCriterion("id =", value, "id"); return (Criteria) this; } public Criteria andIdNotEqualTo(String value) { addCriterion("id <>", value, "id"); return (Criteria) this; } public Criteria andIdGreaterThan(String value) { addCriterion("id >", value, "id"); return (Criteria) this; } public Criteria andIdGreaterThanOrEqualTo(String value) { addCriterion("id >=", value, "id"); return (Criteria) this; } public Criteria andIdLessThan(String value) { addCriterion("id <", value, "id"); return (Criteria) this; } public Criteria andIdLessThanOrEqualTo(String value) { addCriterion("id <=", value, "id"); return (Criteria) this; } public Criteria andIdLike(String value) { addCriterion("id like", value, "id"); return (Criteria) this; } public Criteria andIdNotLike(String value) { addCriterion("id not like", 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(String value1, String value2) { addCriterion("id between", value1, value2, "id"); return (Criteria) this; } public Criteria andIdNotBetween(String value1, String value2) { addCriterion("id not between", value1, value2, "id"); return (Criteria) this; } public Criteria andPidIsNull() { addCriterion("pid is null"); return (Criteria) this; } public Criteria andPidIsNotNull() { addCriterion("pid is not null"); return (Criteria) this; } public Criteria andPidEqualTo(String value) { addCriterion("pid =", value, "pid"); return (Criteria) this; } public Criteria andPidNotEqualTo(String value) { addCriterion("pid <>", value, "pid"); return (Criteria) this; } public Criteria andPidGreaterThan(String value) { addCriterion("pid >", value, "pid"); return (Criteria) this; } public Criteria andPidGreaterThanOrEqualTo(String value) { addCriterion("pid >=", value, "pid"); return (Criteria) this; } public Criteria andPidLessThan(String value) { addCriterion("pid <", value, "pid"); return (Criteria) this; } public Criteria andPidLessThanOrEqualTo(String value) { addCriterion("pid <=", value, "pid"); return (Criteria) this; } public Criteria andPidLike(String value) { addCriterion("pid like", value, "pid"); return (Criteria) this; } public Criteria andPidNotLike(String value) { addCriterion("pid not like", value, "pid"); return (Criteria) this; } public Criteria andPidIn(List values) { addCriterion("pid in", values, "pid"); return (Criteria) this; } public Criteria andPidNotIn(List values) { addCriterion("pid not in", values, "pid"); return (Criteria) this; } public Criteria andPidBetween(String value1, String value2) { addCriterion("pid between", value1, value2, "pid"); return (Criteria) this; } public Criteria andPidNotBetween(String value1, String value2) { addCriterion("pid not between", value1, value2, "pid"); return (Criteria) this; } public Criteria andNameIsNull() { addCriterion("name is null"); return (Criteria) this; } public Criteria andNameIsNotNull() { addCriterion("name is not null"); return (Criteria) this; } public Criteria andNameEqualTo(String value) { addCriterion("name =", value, "name"); return (Criteria) this; } public Criteria andNameNotEqualTo(String value) { addCriterion("name <>", value, "name"); return (Criteria) this; } public Criteria andNameGreaterThan(String value) { addCriterion("name >", value, "name"); return (Criteria) this; } public Criteria andNameGreaterThanOrEqualTo(String value) { addCriterion("name >=", value, "name"); return (Criteria) this; } public Criteria andNameLessThan(String value) { addCriterion("name <", value, "name"); return (Criteria) this; } public Criteria andNameLessThanOrEqualTo(String value) { addCriterion("name <=", value, "name"); return (Criteria) this; } public Criteria andNameLike(String value) { addCriterion("name like", value, "name"); return (Criteria) this; } public Criteria andNameNotLike(String value) { addCriterion("name not like", value, "name"); return (Criteria) this; } public Criteria andNameIn(List values) { addCriterion("name in", values, "name"); return (Criteria) this; } public Criteria andNameNotIn(List values) { addCriterion("name not in", values, "name"); return (Criteria) this; } public Criteria andNameBetween(String value1, String value2) { addCriterion("name between", value1, value2, "name"); return (Criteria) this; } public Criteria andNameNotBetween(String value1, String value2) { addCriterion("name not between", value1, value2, "name"); return (Criteria) this; } public Criteria andUpperIsNull() { addCriterion("upper is null"); return (Criteria) this; } public Criteria andUpperIsNotNull() { addCriterion("upper is not null"); return (Criteria) this; } public Criteria andUpperEqualTo(String value) { addCriterion("upper =", value, "upper"); return (Criteria) this; } public Criteria andUpperNotEqualTo(String value) { addCriterion("upper <>", value, "upper"); return (Criteria) this; } public Criteria andUpperGreaterThan(String value) { addCriterion("upper >", value, "upper"); return (Criteria) this; } public Criteria andUpperGreaterThanOrEqualTo(String value) { addCriterion("upper >=", value, "upper"); return (Criteria) this; } public Criteria andUpperLessThan(String value) { addCriterion("upper <", value, "upper"); return (Criteria) this; } public Criteria andUpperLessThanOrEqualTo(String value) { addCriterion("upper <=", value, "upper"); return (Criteria) this; } public Criteria andUpperLike(String value) { addCriterion("upper like", value, "upper"); return (Criteria) this; } public Criteria andUpperNotLike(String value) { addCriterion("upper not like", value, "upper"); return (Criteria) this; } public Criteria andUpperIn(List values) { addCriterion("upper in", values, "upper"); return (Criteria) this; } public Criteria andUpperNotIn(List values) { addCriterion("upper not in", values, "upper"); return (Criteria) this; } public Criteria andUpperBetween(String value1, String value2) { addCriterion("upper between", value1, value2, "upper"); return (Criteria) this; } public Criteria andUpperNotBetween(String value1, String value2) { addCriterion("upper not between", value1, value2, "upper"); return (Criteria) this; } public Criteria andLowerIsNull() { addCriterion("lower is null"); return (Criteria) this; } public Criteria andLowerIsNotNull() { addCriterion("lower is not null"); return (Criteria) this; } public Criteria andLowerEqualTo(String value) { addCriterion("lower =", value, "lower"); return (Criteria) this; } public Criteria andLowerNotEqualTo(String value) { addCriterion("lower <>", value, "lower"); return (Criteria) this; } public Criteria andLowerGreaterThan(String value) { addCriterion("lower >", value, "lower"); return (Criteria) this; } public Criteria andLowerGreaterThanOrEqualTo(String value) { addCriterion("lower >=", value, "lower"); return (Criteria) this; } public Criteria andLowerLessThan(String value) { addCriterion("lower <", value, "lower"); return (Criteria) this; } public Criteria andLowerLessThanOrEqualTo(String value) { addCriterion("lower <=", value, "lower"); return (Criteria) this; } public Criteria andLowerLike(String value) { addCriterion("lower like", value, "lower"); return (Criteria) this; } public Criteria andLowerNotLike(String value) { addCriterion("lower not like", value, "lower"); return (Criteria) this; } public Criteria andLowerIn(List values) { addCriterion("lower in", values, "lower"); return (Criteria) this; } public Criteria andLowerNotIn(List values) { addCriterion("lower not in", values, "lower"); return (Criteria) this; } public Criteria andLowerBetween(String value1, String value2) { addCriterion("lower between", value1, value2, "lower"); return (Criteria) this; } public Criteria andLowerNotBetween(String value1, String value2) { addCriterion("lower not between", value1, value2, "lower"); return (Criteria) this; } public Criteria andReferenceIsNull() { addCriterion("reference is null"); return (Criteria) this; } public Criteria andReferenceIsNotNull() { addCriterion("reference is not null"); return (Criteria) this; } public Criteria andReferenceEqualTo(String value) { addCriterion("reference =", value, "reference"); return (Criteria) this; } public Criteria andReferenceNotEqualTo(String value) { addCriterion("reference <>", value, "reference"); return (Criteria) this; } public Criteria andReferenceGreaterThan(String value) { addCriterion("reference >", value, "reference"); return (Criteria) this; } public Criteria andReferenceGreaterThanOrEqualTo(String value) { addCriterion("reference >=", value, "reference"); return (Criteria) this; } public Criteria andReferenceLessThan(String value) { addCriterion("reference <", value, "reference"); return (Criteria) this; } public Criteria andReferenceLessThanOrEqualTo(String value) { addCriterion("reference <=", value, "reference"); return (Criteria) this; } public Criteria andReferenceLike(String value) { addCriterion("reference like", value, "reference"); return (Criteria) this; } public Criteria andReferenceNotLike(String value) { addCriterion("reference not like", value, "reference"); return (Criteria) this; } public Criteria andReferenceIn(List values) { addCriterion("reference in", values, "reference"); return (Criteria) this; } public Criteria andReferenceNotIn(List values) { addCriterion("reference not in", values, "reference"); return (Criteria) this; } public Criteria andReferenceBetween(String value1, String value2) { addCriterion("reference between", value1, value2, "reference"); return (Criteria) this; } public Criteria andReferenceNotBetween(String value1, String value2) { addCriterion("reference not between", value1, value2, "reference"); return (Criteria) this; } public Criteria andRemarkIsNull() { addCriterion("remark is null"); return (Criteria) this; } public Criteria andRemarkIsNotNull() { addCriterion("remark is not null"); return (Criteria) this; } public Criteria andRemarkEqualTo(String value) { addCriterion("remark =", value, "remark"); return (Criteria) this; } public Criteria andRemarkNotEqualTo(String value) { addCriterion("remark <>", value, "remark"); return (Criteria) this; } public Criteria andRemarkGreaterThan(String value) { addCriterion("remark >", value, "remark"); return (Criteria) this; } public Criteria andRemarkGreaterThanOrEqualTo(String value) { addCriterion("remark >=", value, "remark"); return (Criteria) this; } public Criteria andRemarkLessThan(String value) { addCriterion("remark <", value, "remark"); return (Criteria) this; } public Criteria andRemarkLessThanOrEqualTo(String value) { addCriterion("remark <=", value, "remark"); return (Criteria) this; } public Criteria andRemarkLike(String value) { addCriterion("remark like", value, "remark"); return (Criteria) this; } public Criteria andRemarkNotLike(String value) { addCriterion("remark not like", value, "remark"); return (Criteria) this; } public Criteria andRemarkIn(List values) { addCriterion("remark in", values, "remark"); return (Criteria) this; } public Criteria andRemarkNotIn(List values) { addCriterion("remark not in", values, "remark"); return (Criteria) this; } public Criteria andRemarkBetween(String value1, String value2) { addCriterion("remark between", value1, value2, "remark"); return (Criteria) this; } public Criteria andRemarkNotBetween(String value1, String value2) { addCriterion("remark not between", value1, value2, "remark"); return (Criteria) this; } public Criteria andUidIsNull() { addCriterion("uid is null"); return (Criteria) this; } public Criteria andUidIsNotNull() { addCriterion("uid is not null"); return (Criteria) this; } public Criteria andUidEqualTo(String value) { addCriterion("uid =", value, "uid"); return (Criteria) this; } public Criteria andUidNotEqualTo(String value) { addCriterion("uid <>", value, "uid"); return (Criteria) this; } public Criteria andUidGreaterThan(String value) { addCriterion("uid >", value, "uid"); return (Criteria) this; } public Criteria andUidGreaterThanOrEqualTo(String value) { addCriterion("uid >=", value, "uid"); return (Criteria) this; } public Criteria andUidLessThan(String value) { addCriterion("uid <", value, "uid"); return (Criteria) this; } public Criteria andUidLessThanOrEqualTo(String value) { addCriterion("uid <=", value, "uid"); return (Criteria) this; } public Criteria andUidLike(String value) { addCriterion("uid like", value, "uid"); return (Criteria) this; } public Criteria andUidNotLike(String value) { addCriterion("uid not like", value, "uid"); return (Criteria) this; } public Criteria andUidIn(List values) { addCriterion("uid in", values, "uid"); return (Criteria) this; } public Criteria andUidNotIn(List values) { addCriterion("uid not in", values, "uid"); return (Criteria) this; } public Criteria andUidBetween(String value1, String value2) { addCriterion("uid between", value1, value2, "uid"); return (Criteria) this; } public Criteria andUidNotBetween(String value1, String value2) { addCriterion("uid not between", value1, value2, "uid"); return (Criteria) this; } public Criteria andComidIsNull() { addCriterion("comid is null"); return (Criteria) this; } public Criteria andComidIsNotNull() { addCriterion("comid is not null"); return (Criteria) this; } public Criteria andComidEqualTo(String value) { addCriterion("comid =", value, "comid"); return (Criteria) this; } public Criteria andComidNotEqualTo(String value) { addCriterion("comid <>", value, "comid"); return (Criteria) this; } public Criteria andComidGreaterThan(String value) { addCriterion("comid >", value, "comid"); return (Criteria) this; } public Criteria andComidGreaterThanOrEqualTo(String value) { addCriterion("comid >=", value, "comid"); return (Criteria) this; } public Criteria andComidLessThan(String value) { addCriterion("comid <", value, "comid"); return (Criteria) this; } public Criteria andComidLessThanOrEqualTo(String value) { addCriterion("comid <=", value, "comid"); return (Criteria) this; } public Criteria andComidLike(String value) { addCriterion("comid like", value, "comid"); return (Criteria) this; } public Criteria andComidNotLike(String value) { addCriterion("comid not like", value, "comid"); return (Criteria) this; } public Criteria andComidIn(List values) { addCriterion("comid in", values, "comid"); return (Criteria) this; } public Criteria andComidNotIn(List values) { addCriterion("comid not in", values, "comid"); return (Criteria) this; } public Criteria andComidBetween(String value1, String value2) { addCriterion("comid between", value1, value2, "comid"); return (Criteria) this; } public Criteria andComidNotBetween(String value1, String value2) { addCriterion("comid not between", value1, value2, "comid"); return (Criteria) this; } public Criteria andComtypeIsNull() { addCriterion("comtype is null"); return (Criteria) this; } public Criteria andComtypeIsNotNull() { addCriterion("comtype is not null"); return (Criteria) this; } public Criteria andComtypeEqualTo(Integer value) { addCriterion("comtype =", value, "comtype"); return (Criteria) this; } public Criteria andComtypeNotEqualTo(Integer value) { addCriterion("comtype <>", value, "comtype"); return (Criteria) this; } public Criteria andComtypeGreaterThan(Integer value) { addCriterion("comtype >", value, "comtype"); return (Criteria) this; } public Criteria andComtypeGreaterThanOrEqualTo(Integer value) { addCriterion("comtype >=", value, "comtype"); return (Criteria) this; } public Criteria andComtypeLessThan(Integer value) { addCriterion("comtype <", value, "comtype"); return (Criteria) this; } public Criteria andComtypeLessThanOrEqualTo(Integer value) { addCriterion("comtype <=", value, "comtype"); return (Criteria) this; } public Criteria andComtypeIn(List values) { addCriterion("comtype in", values, "comtype"); return (Criteria) this; } public Criteria andComtypeNotIn(List values) { addCriterion("comtype not in", values, "comtype"); return (Criteria) this; } public Criteria andComtypeBetween(Integer value1, Integer value2) { addCriterion("comtype between", value1, value2, "comtype"); return (Criteria) this; } public Criteria andComtypeNotBetween(Integer value1, Integer value2) { addCriterion("comtype not between", value1, value2, "comtype"); 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); } } }