package com.miniframe.model.system; import java.util.ArrayList; import java.util.List; public class DThresholdSQLBuilder { protected String orderByClause; protected boolean distinct; protected List oredCriteria; public DThresholdSQLBuilder() { 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 andStypeIsNull() { addCriterion("stype is null"); return (Criteria) this; } public Criteria andStypeIsNotNull() { addCriterion("stype is not null"); return (Criteria) this; } public Criteria andStypeEqualTo(String value) { addCriterion("stype =", value, "stype"); return (Criteria) this; } public Criteria andStypeNotEqualTo(String value) { addCriterion("stype <>", value, "stype"); return (Criteria) this; } public Criteria andStypeGreaterThan(String value) { addCriterion("stype >", value, "stype"); return (Criteria) this; } public Criteria andStypeGreaterThanOrEqualTo(String value) { addCriterion("stype >=", value, "stype"); return (Criteria) this; } public Criteria andStypeLessThan(String value) { addCriterion("stype <", value, "stype"); return (Criteria) this; } public Criteria andStypeLessThanOrEqualTo(String value) { addCriterion("stype <=", value, "stype"); return (Criteria) this; } public Criteria andStypeLike(String value) { addCriterion("stype like", value, "stype"); return (Criteria) this; } public Criteria andStypeNotLike(String value) { addCriterion("stype not like", value, "stype"); return (Criteria) this; } public Criteria andStypeIn(List values) { addCriterion("stype in", values, "stype"); return (Criteria) this; } public Criteria andStypeNotIn(List values) { addCriterion("stype not in", values, "stype"); return (Criteria) this; } public Criteria andStypeBetween(String value1, String value2) { addCriterion("stype between", value1, value2, "stype"); return (Criteria) this; } public Criteria andStypeNotBetween(String value1, String value2) { addCriterion("stype not between", value1, value2, "stype"); return (Criteria) this; } public Criteria andHeightIsNull() { addCriterion("height is null"); return (Criteria) this; } public Criteria andHeightIsNotNull() { addCriterion("height is not null"); return (Criteria) this; } public Criteria andHeightEqualTo(String value) { addCriterion("height =", value, "height"); return (Criteria) this; } public Criteria andHeightNotEqualTo(String value) { addCriterion("height <>", value, "height"); return (Criteria) this; } public Criteria andHeightGreaterThan(String value) { addCriterion("height >", value, "height"); return (Criteria) this; } public Criteria andHeightGreaterThanOrEqualTo(String value) { addCriterion("height >=", value, "height"); return (Criteria) this; } public Criteria andHeightLessThan(String value) { addCriterion("height <", value, "height"); return (Criteria) this; } public Criteria andHeightLessThanOrEqualTo(String value) { addCriterion("height <=", value, "height"); return (Criteria) this; } public Criteria andHeightLike(String value) { addCriterion("height like", value, "height"); return (Criteria) this; } public Criteria andHeightNotLike(String value) { addCriterion("height not like", value, "height"); return (Criteria) this; } public Criteria andHeightIn(List values) { addCriterion("height in", values, "height"); return (Criteria) this; } public Criteria andHeightNotIn(List values) { addCriterion("height not in", values, "height"); return (Criteria) this; } public Criteria andHeightBetween(String value1, String value2) { addCriterion("height between", value1, value2, "height"); return (Criteria) this; } public Criteria andHeightNotBetween(String value1, String value2) { addCriterion("height not between", value1, value2, "height"); return (Criteria) this; } public Criteria andTemperatureIsNull() { addCriterion("temperature is null"); return (Criteria) this; } public Criteria andTemperatureIsNotNull() { addCriterion("temperature is not null"); return (Criteria) this; } public Criteria andTemperatureEqualTo(String value) { addCriterion("temperature =", value, "temperature"); return (Criteria) this; } public Criteria andTemperatureNotEqualTo(String value) { addCriterion("temperature <>", value, "temperature"); return (Criteria) this; } public Criteria andTemperatureGreaterThan(String value) { addCriterion("temperature >", value, "temperature"); return (Criteria) this; } public Criteria andTemperatureGreaterThanOrEqualTo(String value) { addCriterion("temperature >=", value, "temperature"); return (Criteria) this; } public Criteria andTemperatureLessThan(String value) { addCriterion("temperature <", value, "temperature"); return (Criteria) this; } public Criteria andTemperatureLessThanOrEqualTo(String value) { addCriterion("temperature <=", value, "temperature"); return (Criteria) this; } public Criteria andTemperatureLike(String value) { addCriterion("temperature like", value, "temperature"); return (Criteria) this; } public Criteria andTemperatureNotLike(String value) { addCriterion("temperature not like", value, "temperature"); return (Criteria) this; } public Criteria andTemperatureIn(List values) { addCriterion("temperature in", values, "temperature"); return (Criteria) this; } public Criteria andTemperatureNotIn(List values) { addCriterion("temperature not in", values, "temperature"); return (Criteria) this; } public Criteria andTemperatureBetween(String value1, String value2) { addCriterion("temperature between", value1, value2, "temperature"); return (Criteria) this; } public Criteria andTemperatureNotBetween(String value1, String value2) { addCriterion("temperature not between", value1, value2, "temperature"); return (Criteria) this; } public Criteria andCo2IsNull() { addCriterion("co2 is null"); return (Criteria) this; } public Criteria andCo2IsNotNull() { addCriterion("co2 is not null"); return (Criteria) this; } public Criteria andCo2EqualTo(String value) { addCriterion("co2 =", value, "co2"); return (Criteria) this; } public Criteria andCo2NotEqualTo(String value) { addCriterion("co2 <>", value, "co2"); return (Criteria) this; } public Criteria andCo2GreaterThan(String value) { addCriterion("co2 >", value, "co2"); return (Criteria) this; } public Criteria andCo2GreaterThanOrEqualTo(String value) { addCriterion("co2 >=", value, "co2"); return (Criteria) this; } public Criteria andCo2LessThan(String value) { addCriterion("co2 <", value, "co2"); return (Criteria) this; } public Criteria andCo2LessThanOrEqualTo(String value) { addCriterion("co2 <=", value, "co2"); return (Criteria) this; } public Criteria andCo2Like(String value) { addCriterion("co2 like", value, "co2"); return (Criteria) this; } public Criteria andCo2NotLike(String value) { addCriterion("co2 not like", value, "co2"); return (Criteria) this; } public Criteria andCo2In(List values) { addCriterion("co2 in", values, "co2"); return (Criteria) this; } public Criteria andCo2NotIn(List values) { addCriterion("co2 not in", values, "co2"); return (Criteria) this; } public Criteria andCo2Between(String value1, String value2) { addCriterion("co2 between", value1, value2, "co2"); return (Criteria) this; } public Criteria andCo2NotBetween(String value1, String value2) { addCriterion("co2 not between", value1, value2, "co2"); return (Criteria) this; } public Criteria andCh4IsNull() { addCriterion("ch4 is null"); return (Criteria) this; } public Criteria andCh4IsNotNull() { addCriterion("ch4 is not null"); return (Criteria) this; } public Criteria andCh4EqualTo(String value) { addCriterion("ch4 =", value, "ch4"); return (Criteria) this; } public Criteria andCh4NotEqualTo(String value) { addCriterion("ch4 <>", value, "ch4"); return (Criteria) this; } public Criteria andCh4GreaterThan(String value) { addCriterion("ch4 >", value, "ch4"); return (Criteria) this; } public Criteria andCh4GreaterThanOrEqualTo(String value) { addCriterion("ch4 >=", value, "ch4"); return (Criteria) this; } public Criteria andCh4LessThan(String value) { addCriterion("ch4 <", value, "ch4"); return (Criteria) this; } public Criteria andCh4LessThanOrEqualTo(String value) { addCriterion("ch4 <=", value, "ch4"); return (Criteria) this; } public Criteria andCh4Like(String value) { addCriterion("ch4 like", value, "ch4"); return (Criteria) this; } public Criteria andCh4NotLike(String value) { addCriterion("ch4 not like", value, "ch4"); return (Criteria) this; } public Criteria andCh4In(List values) { addCriterion("ch4 in", values, "ch4"); return (Criteria) this; } public Criteria andCh4NotIn(List values) { addCriterion("ch4 not in", values, "ch4"); return (Criteria) this; } public Criteria andCh4Between(String value1, String value2) { addCriterion("ch4 between", value1, value2, "ch4"); return (Criteria) this; } public Criteria andCh4NotBetween(String value1, String value2) { addCriterion("ch4 not between", value1, value2, "ch4"); return (Criteria) this; } public Criteria andGradeIsNull() { addCriterion("grade is null"); return (Criteria) this; } public Criteria andGradeIsNotNull() { addCriterion("grade is not null"); return (Criteria) this; } public Criteria andGradeEqualTo(Integer value) { addCriterion("grade =", value, "grade"); return (Criteria) this; } public Criteria andGradeNotEqualTo(Integer value) { addCriterion("grade <>", value, "grade"); return (Criteria) this; } public Criteria andGradeGreaterThan(Integer value) { addCriterion("grade >", value, "grade"); return (Criteria) this; } public Criteria andGradeGreaterThanOrEqualTo(Integer value) { addCriterion("grade >=", value, "grade"); return (Criteria) this; } public Criteria andGradeLessThan(Integer value) { addCriterion("grade <", value, "grade"); return (Criteria) this; } public Criteria andGradeLessThanOrEqualTo(Integer value) { addCriterion("grade <=", value, "grade"); return (Criteria) this; } public Criteria andGradeIn(List values) { addCriterion("grade in", values, "grade"); return (Criteria) this; } public Criteria andGradeNotIn(List values) { addCriterion("grade not in", values, "grade"); return (Criteria) this; } public Criteria andGradeBetween(Integer value1, Integer value2) { addCriterion("grade between", value1, value2, "grade"); return (Criteria) this; } public Criteria andGradeNotBetween(Integer value1, Integer value2) { addCriterion("grade not between", value1, value2, "grade"); return (Criteria) this; } public Criteria andSo2IsNull() { addCriterion("so2 is null"); return (Criteria) this; } public Criteria andSo2IsNotNull() { addCriterion("so2 is not null"); return (Criteria) this; } public Criteria andSo2EqualTo(String value) { addCriterion("so2 =", value, "so2"); return (Criteria) this; } public Criteria andSo2NotEqualTo(String value) { addCriterion("so2 <>", value, "so2"); return (Criteria) this; } public Criteria andSo2GreaterThan(String value) { addCriterion("so2 >", value, "so2"); return (Criteria) this; } public Criteria andSo2GreaterThanOrEqualTo(String value) { addCriterion("so2 >=", value, "so2"); return (Criteria) this; } public Criteria andSo2LessThan(String value) { addCriterion("so2 <", value, "so2"); return (Criteria) this; } public Criteria andSo2LessThanOrEqualTo(String value) { addCriterion("so2 <=", value, "so2"); return (Criteria) this; } public Criteria andSo2Like(String value) { addCriterion("so2 like", value, "so2"); return (Criteria) this; } public Criteria andSo2NotLike(String value) { addCriterion("so2 not like", value, "so2"); return (Criteria) this; } public Criteria andSo2In(List values) { addCriterion("so2 in", values, "so2"); return (Criteria) this; } public Criteria andSo2NotIn(List values) { addCriterion("so2 not in", values, "so2"); return (Criteria) this; } public Criteria andSo2Between(String value1, String value2) { addCriterion("so2 between", value1, value2, "so2"); return (Criteria) this; } public Criteria andSo2NotBetween(String value1, String value2) { addCriterion("so2 not between", value1, value2, "so2"); 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); } } }