package com.miniframe.model.system; import java.util.ArrayList; import java.util.List; public class DNodeSQLBuilder { protected String orderByClause; protected boolean distinct; protected List oredCriteria; public DNodeSQLBuilder() { 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 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 andXIsNull() { addCriterion("x is null"); return (Criteria) this; } public Criteria andXIsNotNull() { addCriterion("x is not null"); return (Criteria) this; } public Criteria andXEqualTo(Float value) { addCriterion("x =", value, "x"); return (Criteria) this; } public Criteria andXNotEqualTo(Float value) { addCriterion("x <>", value, "x"); return (Criteria) this; } public Criteria andXGreaterThan(Float value) { addCriterion("x >", value, "x"); return (Criteria) this; } public Criteria andXGreaterThanOrEqualTo(Float value) { addCriterion("x >=", value, "x"); return (Criteria) this; } public Criteria andXLessThan(Float value) { addCriterion("x <", value, "x"); return (Criteria) this; } public Criteria andXLessThanOrEqualTo(Float value) { addCriterion("x <=", value, "x"); return (Criteria) this; } public Criteria andXIn(List values) { addCriterion("x in", values, "x"); return (Criteria) this; } public Criteria andXNotIn(List values) { addCriterion("x not in", values, "x"); return (Criteria) this; } public Criteria andXBetween(Float value1, Float value2) { addCriterion("x between", value1, value2, "x"); return (Criteria) this; } public Criteria andXNotBetween(Float value1, Float value2) { addCriterion("x not between", value1, value2, "x"); return (Criteria) this; } public Criteria andYIsNull() { addCriterion("y is null"); return (Criteria) this; } public Criteria andYIsNotNull() { addCriterion("y is not null"); return (Criteria) this; } public Criteria andYEqualTo(Float value) { addCriterion("y =", value, "y"); return (Criteria) this; } public Criteria andYNotEqualTo(Float value) { addCriterion("y <>", value, "y"); return (Criteria) this; } public Criteria andYGreaterThan(Float value) { addCriterion("y >", value, "y"); return (Criteria) this; } public Criteria andYGreaterThanOrEqualTo(Float value) { addCriterion("y >=", value, "y"); return (Criteria) this; } public Criteria andYLessThan(Float value) { addCriterion("y <", value, "y"); return (Criteria) this; } public Criteria andYLessThanOrEqualTo(Float value) { addCriterion("y <=", value, "y"); return (Criteria) this; } public Criteria andYIn(List values) { addCriterion("y in", values, "y"); return (Criteria) this; } public Criteria andYNotIn(List values) { addCriterion("y not in", values, "y"); return (Criteria) this; } public Criteria andYBetween(Float value1, Float value2) { addCriterion("y between", value1, value2, "y"); return (Criteria) this; } public Criteria andYNotBetween(Float value1, Float value2) { addCriterion("y not between", value1, value2, "y"); return (Criteria) this; } public Criteria andZIsNull() { addCriterion("z is null"); return (Criteria) this; } public Criteria andZIsNotNull() { addCriterion("z is not null"); return (Criteria) this; } public Criteria andZEqualTo(Float value) { addCriterion("z =", value, "z"); return (Criteria) this; } public Criteria andZNotEqualTo(Float value) { addCriterion("z <>", value, "z"); return (Criteria) this; } public Criteria andZGreaterThan(Float value) { addCriterion("z >", value, "z"); return (Criteria) this; } public Criteria andZGreaterThanOrEqualTo(Float value) { addCriterion("z >=", value, "z"); return (Criteria) this; } public Criteria andZLessThan(Float value) { addCriterion("z <", value, "z"); return (Criteria) this; } public Criteria andZLessThanOrEqualTo(Float value) { addCriterion("z <=", value, "z"); return (Criteria) this; } public Criteria andZIn(List values) { addCriterion("z in", values, "z"); return (Criteria) this; } public Criteria andZNotIn(List values) { addCriterion("z not in", values, "z"); return (Criteria) this; } public Criteria andZBetween(Float value1, Float value2) { addCriterion("z between", value1, value2, "z"); return (Criteria) this; } public Criteria andZNotBetween(Float value1, Float value2) { addCriterion("z not between", value1, value2, "z"); return (Criteria) this; } public Criteria andNDescIsNull() { addCriterion("n_desc is null"); return (Criteria) this; } public Criteria andNDescIsNotNull() { addCriterion("n_desc is not null"); return (Criteria) this; } public Criteria andNDescEqualTo(String value) { addCriterion("n_desc =", value, "nDesc"); return (Criteria) this; } public Criteria andNDescNotEqualTo(String value) { addCriterion("n_desc <>", value, "nDesc"); return (Criteria) this; } public Criteria andNDescGreaterThan(String value) { addCriterion("n_desc >", value, "nDesc"); return (Criteria) this; } public Criteria andNDescGreaterThanOrEqualTo(String value) { addCriterion("n_desc >=", value, "nDesc"); return (Criteria) this; } public Criteria andNDescLessThan(String value) { addCriterion("n_desc <", value, "nDesc"); return (Criteria) this; } public Criteria andNDescLessThanOrEqualTo(String value) { addCriterion("n_desc <=", value, "nDesc"); return (Criteria) this; } public Criteria andNDescLike(String value) { addCriterion("n_desc like", value, "nDesc"); return (Criteria) this; } public Criteria andNDescNotLike(String value) { addCriterion("n_desc not like", value, "nDesc"); return (Criteria) this; } public Criteria andNDescIn(List values) { addCriterion("n_desc in", values, "nDesc"); return (Criteria) this; } public Criteria andNDescNotIn(List values) { addCriterion("n_desc not in", values, "nDesc"); return (Criteria) this; } public Criteria andNDescBetween(String value1, String value2) { addCriterion("n_desc between", value1, value2, "nDesc"); return (Criteria) this; } public Criteria andNDescNotBetween(String value1, String value2) { addCriterion("n_desc not between", value1, value2, "nDesc"); return (Criteria) this; } public Criteria andWaterlevelIsNull() { addCriterion("waterlevel is null"); return (Criteria) this; } public Criteria andWaterlevelIsNotNull() { addCriterion("waterlevel is not null"); return (Criteria) this; } public Criteria andWaterlevelEqualTo(Float value) { addCriterion("waterlevel =", value, "waterlevel"); return (Criteria) this; } public Criteria andWaterlevelNotEqualTo(Float value) { addCriterion("waterlevel <>", value, "waterlevel"); return (Criteria) this; } public Criteria andWaterlevelGreaterThan(Float value) { addCriterion("waterlevel >", value, "waterlevel"); return (Criteria) this; } public Criteria andWaterlevelGreaterThanOrEqualTo(Float value) { addCriterion("waterlevel >=", value, "waterlevel"); return (Criteria) this; } public Criteria andWaterlevelLessThan(Float value) { addCriterion("waterlevel <", value, "waterlevel"); return (Criteria) this; } public Criteria andWaterlevelLessThanOrEqualTo(Float value) { addCriterion("waterlevel <=", value, "waterlevel"); return (Criteria) this; } public Criteria andWaterlevelIn(List values) { addCriterion("waterlevel in", values, "waterlevel"); return (Criteria) this; } public Criteria andWaterlevelNotIn(List values) { addCriterion("waterlevel not in", values, "waterlevel"); return (Criteria) this; } public Criteria andWaterlevelBetween(Float value1, Float value2) { addCriterion("waterlevel between", value1, value2, "waterlevel"); return (Criteria) this; } public Criteria andWaterlevelNotBetween(Float value1, Float value2) { addCriterion("waterlevel not between", value1, value2, "waterlevel"); 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(Float value) { addCriterion("so2 =", value, "so2"); return (Criteria) this; } public Criteria andSo2NotEqualTo(Float value) { addCriterion("so2 <>", value, "so2"); return (Criteria) this; } public Criteria andSo2GreaterThan(Float value) { addCriterion("so2 >", value, "so2"); return (Criteria) this; } public Criteria andSo2GreaterThanOrEqualTo(Float value) { addCriterion("so2 >=", value, "so2"); return (Criteria) this; } public Criteria andSo2LessThan(Float value) { addCriterion("so2 <", value, "so2"); return (Criteria) this; } public Criteria andSo2LessThanOrEqualTo(Float value) { addCriterion("so2 <=", 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(Float value1, Float value2) { addCriterion("so2 between", value1, value2, "so2"); return (Criteria) this; } public Criteria andSo2NotBetween(Float value1, Float value2) { addCriterion("so2 not between", value1, value2, "so2"); 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(Float value) { addCriterion("co2 =", value, "co2"); return (Criteria) this; } public Criteria andCo2NotEqualTo(Float value) { addCriterion("co2 <>", value, "co2"); return (Criteria) this; } public Criteria andCo2GreaterThan(Float value) { addCriterion("co2 >", value, "co2"); return (Criteria) this; } public Criteria andCo2GreaterThanOrEqualTo(Float value) { addCriterion("co2 >=", value, "co2"); return (Criteria) this; } public Criteria andCo2LessThan(Float value) { addCriterion("co2 <", value, "co2"); return (Criteria) this; } public Criteria andCo2LessThanOrEqualTo(Float value) { addCriterion("co2 <=", 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(Float value1, Float value2) { addCriterion("co2 between", value1, value2, "co2"); return (Criteria) this; } public Criteria andCo2NotBetween(Float value1, Float value2) { addCriterion("co2 not between", value1, value2, "co2"); 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(Float value) { addCriterion("temperature =", value, "temperature"); return (Criteria) this; } public Criteria andTemperatureNotEqualTo(Float value) { addCriterion("temperature <>", value, "temperature"); return (Criteria) this; } public Criteria andTemperatureGreaterThan(Float value) { addCriterion("temperature >", value, "temperature"); return (Criteria) this; } public Criteria andTemperatureGreaterThanOrEqualTo(Float value) { addCriterion("temperature >=", value, "temperature"); return (Criteria) this; } public Criteria andTemperatureLessThan(Float value) { addCriterion("temperature <", value, "temperature"); return (Criteria) this; } public Criteria andTemperatureLessThanOrEqualTo(Float value) { addCriterion("temperature <=", 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(Float value1, Float value2) { addCriterion("temperature between", value1, value2, "temperature"); return (Criteria) this; } public Criteria andTemperatureNotBetween(Float value1, Float value2) { addCriterion("temperature not between", value1, value2, "temperature"); return (Criteria) this; } public Criteria andScalar1IsNull() { addCriterion("scalar1 is null"); return (Criteria) this; } public Criteria andScalar1IsNotNull() { addCriterion("scalar1 is not null"); return (Criteria) this; } public Criteria andScalar1EqualTo(Float value) { addCriterion("scalar1 =", value, "scalar1"); return (Criteria) this; } public Criteria andScalar1NotEqualTo(Float value) { addCriterion("scalar1 <>", value, "scalar1"); return (Criteria) this; } public Criteria andScalar1GreaterThan(Float value) { addCriterion("scalar1 >", value, "scalar1"); return (Criteria) this; } public Criteria andScalar1GreaterThanOrEqualTo(Float value) { addCriterion("scalar1 >=", value, "scalar1"); return (Criteria) this; } public Criteria andScalar1LessThan(Float value) { addCriterion("scalar1 <", value, "scalar1"); return (Criteria) this; } public Criteria andScalar1LessThanOrEqualTo(Float value) { addCriterion("scalar1 <=", value, "scalar1"); return (Criteria) this; } public Criteria andScalar1In(List values) { addCriterion("scalar1 in", values, "scalar1"); return (Criteria) this; } public Criteria andScalar1NotIn(List values) { addCriterion("scalar1 not in", values, "scalar1"); return (Criteria) this; } public Criteria andScalar1Between(Float value1, Float value2) { addCriterion("scalar1 between", value1, value2, "scalar1"); return (Criteria) this; } public Criteria andScalar1NotBetween(Float value1, Float value2) { addCriterion("scalar1 not between", value1, value2, "scalar1"); return (Criteria) this; } public Criteria andScalar2IsNull() { addCriterion("scalar2 is null"); return (Criteria) this; } public Criteria andScalar2IsNotNull() { addCriterion("scalar2 is not null"); return (Criteria) this; } public Criteria andScalar2EqualTo(Float value) { addCriterion("scalar2 =", value, "scalar2"); return (Criteria) this; } public Criteria andScalar2NotEqualTo(Float value) { addCriterion("scalar2 <>", value, "scalar2"); return (Criteria) this; } public Criteria andScalar2GreaterThan(Float value) { addCriterion("scalar2 >", value, "scalar2"); return (Criteria) this; } public Criteria andScalar2GreaterThanOrEqualTo(Float value) { addCriterion("scalar2 >=", value, "scalar2"); return (Criteria) this; } public Criteria andScalar2LessThan(Float value) { addCriterion("scalar2 <", value, "scalar2"); return (Criteria) this; } public Criteria andScalar2LessThanOrEqualTo(Float value) { addCriterion("scalar2 <=", value, "scalar2"); return (Criteria) this; } public Criteria andScalar2In(List values) { addCriterion("scalar2 in", values, "scalar2"); return (Criteria) this; } public Criteria andScalar2NotIn(List values) { addCriterion("scalar2 not in", values, "scalar2"); return (Criteria) this; } public Criteria andScalar2Between(Float value1, Float value2) { addCriterion("scalar2 between", value1, value2, "scalar2"); return (Criteria) this; } public Criteria andScalar2NotBetween(Float value1, Float value2) { addCriterion("scalar2 not between", value1, value2, "scalar2"); return (Criteria) this; } public Criteria andScalar3IsNull() { addCriterion("scalar3 is null"); return (Criteria) this; } public Criteria andScalar3IsNotNull() { addCriterion("scalar3 is not null"); return (Criteria) this; } public Criteria andScalar3EqualTo(Float value) { addCriterion("scalar3 =", value, "scalar3"); return (Criteria) this; } public Criteria andScalar3NotEqualTo(Float value) { addCriterion("scalar3 <>", value, "scalar3"); return (Criteria) this; } public Criteria andScalar3GreaterThan(Float value) { addCriterion("scalar3 >", value, "scalar3"); return (Criteria) this; } public Criteria andScalar3GreaterThanOrEqualTo(Float value) { addCriterion("scalar3 >=", value, "scalar3"); return (Criteria) this; } public Criteria andScalar3LessThan(Float value) { addCriterion("scalar3 <", value, "scalar3"); return (Criteria) this; } public Criteria andScalar3LessThanOrEqualTo(Float value) { addCriterion("scalar3 <=", value, "scalar3"); return (Criteria) this; } public Criteria andScalar3In(List values) { addCriterion("scalar3 in", values, "scalar3"); return (Criteria) this; } public Criteria andScalar3NotIn(List values) { addCriterion("scalar3 not in", values, "scalar3"); return (Criteria) this; } public Criteria andScalar3Between(Float value1, Float value2) { addCriterion("scalar3 between", value1, value2, "scalar3"); return (Criteria) this; } public Criteria andScalar3NotBetween(Float value1, Float value2) { addCriterion("scalar3 not between", value1, value2, "scalar3"); return (Criteria) this; } public Criteria andNtypeIsNull() { addCriterion("ntype is null"); return (Criteria) this; } public Criteria andNtypeIsNotNull() { addCriterion("ntype is not null"); return (Criteria) this; } public Criteria andNtypeEqualTo(String value) { addCriterion("ntype =", value, "ntype"); return (Criteria) this; } public Criteria andNtypeNotEqualTo(String value) { addCriterion("ntype <>", value, "ntype"); return (Criteria) this; } public Criteria andNtypeGreaterThan(String value) { addCriterion("ntype >", value, "ntype"); return (Criteria) this; } public Criteria andNtypeGreaterThanOrEqualTo(String value) { addCriterion("ntype >=", value, "ntype"); return (Criteria) this; } public Criteria andNtypeLessThan(String value) { addCriterion("ntype <", value, "ntype"); return (Criteria) this; } public Criteria andNtypeLessThanOrEqualTo(String value) { addCriterion("ntype <=", value, "ntype"); return (Criteria) this; } public Criteria andNtypeLike(String value) { addCriterion("ntype like", value, "ntype"); return (Criteria) this; } public Criteria andNtypeNotLike(String value) { addCriterion("ntype not like", value, "ntype"); return (Criteria) this; } public Criteria andNtypeIn(List values) { addCriterion("ntype in", values, "ntype"); return (Criteria) this; } public Criteria andNtypeNotIn(List values) { addCriterion("ntype not in", values, "ntype"); return (Criteria) this; } public Criteria andNtypeBetween(String value1, String value2) { addCriterion("ntype between", value1, value2, "ntype"); return (Criteria) this; } public Criteria andNtypeNotBetween(String value1, String value2) { addCriterion("ntype not between", value1, value2, "ntype"); 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); } } }