package com.miniframe.model.system; import java.math.BigDecimal; import java.util.ArrayList; import java.util.List; public class DSensorSQLBuilder { protected String orderByClause; protected boolean distinct; protected List oredCriteria; public DSensorSQLBuilder() { 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 andPidIsNull() { addCriterion("pid is null"); return (Criteria) this; } public Criteria andPidIsNotNull() { addCriterion("pid is not null"); return (Criteria) this; } public Criteria andPidEqualTo(Integer value) { addCriterion("pid =", value, "pid"); return (Criteria) this; } public Criteria andPidNotEqualTo(Integer value) { addCriterion("pid <>", value, "pid"); return (Criteria) this; } public Criteria andPidGreaterThan(Integer value) { addCriterion("pid >", value, "pid"); return (Criteria) this; } public Criteria andPidGreaterThanOrEqualTo(Integer value) { addCriterion("pid >=", value, "pid"); return (Criteria) this; } public Criteria andPidLessThan(Integer value) { addCriterion("pid <", value, "pid"); return (Criteria) this; } public Criteria andPidLessThanOrEqualTo(Integer value) { addCriterion("pid <=", 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(Integer value1, Integer value2) { addCriterion("pid between", value1, value2, "pid"); return (Criteria) this; } public Criteria andPidNotBetween(Integer value1, Integer value2) { addCriterion("pid not between", value1, value2, "pid"); return (Criteria) this; } public Criteria andSiteIsNull() { addCriterion("site is null"); return (Criteria) this; } public Criteria andSiteIsNotNull() { addCriterion("site is not null"); return (Criteria) this; } public Criteria andSiteEqualTo(Float value) { addCriterion("site =", value, "site"); return (Criteria) this; } public Criteria andSiteNotEqualTo(Float value) { addCriterion("site <>", value, "site"); return (Criteria) this; } public Criteria andSiteGreaterThan(Float value) { addCriterion("site >", value, "site"); return (Criteria) this; } public Criteria andSiteGreaterThanOrEqualTo(Float value) { addCriterion("site >=", value, "site"); return (Criteria) this; } public Criteria andSiteLessThan(Float value) { addCriterion("site <", value, "site"); return (Criteria) this; } public Criteria andSiteLessThanOrEqualTo(Float value) { addCriterion("site <=", value, "site"); return (Criteria) this; } public Criteria andSiteIn(List values) { addCriterion("site in", values, "site"); return (Criteria) this; } public Criteria andSiteNotIn(List values) { addCriterion("site not in", values, "site"); return (Criteria) this; } public Criteria andSiteBetween(Float value1, Float value2) { addCriterion("site between", value1, value2, "site"); return (Criteria) this; } public Criteria andSiteNotBetween(Float value1, Float value2) { addCriterion("site not between", value1, value2, "site"); return (Criteria) this; } public Criteria andTypeIsNull() { addCriterion("type is null"); return (Criteria) this; } public Criteria andTypeIsNotNull() { addCriterion("type is not null"); return (Criteria) this; } public Criteria andTypeEqualTo(String value) { addCriterion("type =", value, "type"); return (Criteria) this; } public Criteria andTypeNotEqualTo(String value) { addCriterion("type <>", value, "type"); return (Criteria) this; } public Criteria andTypeGreaterThan(String value) { addCriterion("type >", value, "type"); return (Criteria) this; } public Criteria andTypeGreaterThanOrEqualTo(String value) { addCriterion("type >=", value, "type"); return (Criteria) this; } public Criteria andTypeLessThan(String value) { addCriterion("type <", value, "type"); return (Criteria) this; } public Criteria andTypeLessThanOrEqualTo(String value) { addCriterion("type <=", value, "type"); return (Criteria) this; } public Criteria andTypeLike(String value) { addCriterion("type like", value, "type"); return (Criteria) this; } public Criteria andTypeNotLike(String value) { addCriterion("type not like", value, "type"); return (Criteria) this; } public Criteria andTypeIn(List values) { addCriterion("type in", values, "type"); return (Criteria) this; } public Criteria andTypeNotIn(List values) { addCriterion("type not in", values, "type"); return (Criteria) this; } public Criteria andTypeBetween(String value1, String value2) { addCriterion("type between", value1, value2, "type"); return (Criteria) this; } public Criteria andTypeNotBetween(String value1, String value2) { addCriterion("type not between", value1, value2, "type"); return (Criteria) this; } public Criteria andPnameIsNull() { addCriterion("pname is null"); return (Criteria) this; } public Criteria andPnameIsNotNull() { addCriterion("pname is not null"); return (Criteria) this; } public Criteria andPnameEqualTo(String value) { addCriterion("pname =", value, "pname"); return (Criteria) this; } public Criteria andPnameNotEqualTo(String value) { addCriterion("pname <>", value, "pname"); return (Criteria) this; } public Criteria andPnameGreaterThan(String value) { addCriterion("pname >", value, "pname"); return (Criteria) this; } public Criteria andPnameGreaterThanOrEqualTo(String value) { addCriterion("pname >=", value, "pname"); return (Criteria) this; } public Criteria andPnameLessThan(String value) { addCriterion("pname <", value, "pname"); return (Criteria) this; } public Criteria andPnameLessThanOrEqualTo(String value) { addCriterion("pname <=", value, "pname"); return (Criteria) this; } public Criteria andPnameLike(String value) { addCriterion("pname like", value, "pname"); return (Criteria) this; } public Criteria andPnameNotLike(String value) { addCriterion("pname not like", value, "pname"); return (Criteria) this; } public Criteria andPnameIn(List values) { addCriterion("pname in", values, "pname"); return (Criteria) this; } public Criteria andPnameNotIn(List values) { addCriterion("pname not in", values, "pname"); return (Criteria) this; } public Criteria andPnameBetween(String value1, String value2) { addCriterion("pname between", value1, value2, "pname"); return (Criteria) this; } public Criteria andPnameNotBetween(String value1, String value2) { addCriterion("pname not between", value1, value2, "pname"); return (Criteria) this; } public Criteria andXCoordinateIsNull() { addCriterion("x_coordinate is null"); return (Criteria) this; } public Criteria andXCoordinateIsNotNull() { addCriterion("x_coordinate is not null"); return (Criteria) this; } public Criteria andXCoordinateEqualTo(BigDecimal value) { addCriterion("x_coordinate =", value, "xCoordinate"); return (Criteria) this; } public Criteria andXCoordinateNotEqualTo(BigDecimal value) { addCriterion("x_coordinate <>", value, "xCoordinate"); return (Criteria) this; } public Criteria andXCoordinateGreaterThan(BigDecimal value) { addCriterion("x_coordinate >", value, "xCoordinate"); return (Criteria) this; } public Criteria andXCoordinateGreaterThanOrEqualTo(BigDecimal value) { addCriterion("x_coordinate >=", value, "xCoordinate"); return (Criteria) this; } public Criteria andXCoordinateLessThan(BigDecimal value) { addCriterion("x_coordinate <", value, "xCoordinate"); return (Criteria) this; } public Criteria andXCoordinateLessThanOrEqualTo(BigDecimal value) { addCriterion("x_coordinate <=", value, "xCoordinate"); return (Criteria) this; } public Criteria andXCoordinateIn(List values) { addCriterion("x_coordinate in", values, "xCoordinate"); return (Criteria) this; } public Criteria andXCoordinateNotIn(List values) { addCriterion("x_coordinate not in", values, "xCoordinate"); return (Criteria) this; } public Criteria andXCoordinateBetween(BigDecimal value1, BigDecimal value2) { addCriterion("x_coordinate between", value1, value2, "xCoordinate"); return (Criteria) this; } public Criteria andXCoordinateNotBetween(BigDecimal value1, BigDecimal value2) { addCriterion("x_coordinate not between", value1, value2, "xCoordinate"); return (Criteria) this; } public Criteria andYCoordinateIsNull() { addCriterion("y_coordinate is null"); return (Criteria) this; } public Criteria andYCoordinateIsNotNull() { addCriterion("y_coordinate is not null"); return (Criteria) this; } public Criteria andYCoordinateEqualTo(BigDecimal value) { addCriterion("y_coordinate =", value, "yCoordinate"); return (Criteria) this; } public Criteria andYCoordinateNotEqualTo(BigDecimal value) { addCriterion("y_coordinate <>", value, "yCoordinate"); return (Criteria) this; } public Criteria andYCoordinateGreaterThan(BigDecimal value) { addCriterion("y_coordinate >", value, "yCoordinate"); return (Criteria) this; } public Criteria andYCoordinateGreaterThanOrEqualTo(BigDecimal value) { addCriterion("y_coordinate >=", value, "yCoordinate"); return (Criteria) this; } public Criteria andYCoordinateLessThan(BigDecimal value) { addCriterion("y_coordinate <", value, "yCoordinate"); return (Criteria) this; } public Criteria andYCoordinateLessThanOrEqualTo(BigDecimal value) { addCriterion("y_coordinate <=", value, "yCoordinate"); return (Criteria) this; } public Criteria andYCoordinateIn(List values) { addCriterion("y_coordinate in", values, "yCoordinate"); return (Criteria) this; } public Criteria andYCoordinateNotIn(List values) { addCriterion("y_coordinate not in", values, "yCoordinate"); return (Criteria) this; } public Criteria andYCoordinateBetween(BigDecimal value1, BigDecimal value2) { addCriterion("y_coordinate between", value1, value2, "yCoordinate"); return (Criteria) this; } public Criteria andYCoordinateNotBetween(BigDecimal value1, BigDecimal value2) { addCriterion("y_coordinate not between", value1, value2, "yCoordinate"); return (Criteria) this; } public Criteria andZCoordinateIsNull() { addCriterion("z_coordinate is null"); return (Criteria) this; } public Criteria andZCoordinateIsNotNull() { addCriterion("z_coordinate is not null"); return (Criteria) this; } public Criteria andZCoordinateEqualTo(BigDecimal value) { addCriterion("z_coordinate =", value, "zCoordinate"); return (Criteria) this; } public Criteria andZCoordinateNotEqualTo(BigDecimal value) { addCriterion("z_coordinate <>", value, "zCoordinate"); return (Criteria) this; } public Criteria andZCoordinateGreaterThan(BigDecimal value) { addCriterion("z_coordinate >", value, "zCoordinate"); return (Criteria) this; } public Criteria andZCoordinateGreaterThanOrEqualTo(BigDecimal value) { addCriterion("z_coordinate >=", value, "zCoordinate"); return (Criteria) this; } public Criteria andZCoordinateLessThan(BigDecimal value) { addCriterion("z_coordinate <", value, "zCoordinate"); return (Criteria) this; } public Criteria andZCoordinateLessThanOrEqualTo(BigDecimal value) { addCriterion("z_coordinate <=", value, "zCoordinate"); return (Criteria) this; } public Criteria andZCoordinateIn(List values) { addCriterion("z_coordinate in", values, "zCoordinate"); return (Criteria) this; } public Criteria andZCoordinateNotIn(List values) { addCriterion("z_coordinate not in", values, "zCoordinate"); return (Criteria) this; } public Criteria andZCoordinateBetween(BigDecimal value1, BigDecimal value2) { addCriterion("z_coordinate between", value1, value2, "zCoordinate"); return (Criteria) this; } public Criteria andZCoordinateNotBetween(BigDecimal value1, BigDecimal value2) { addCriterion("z_coordinate not between", value1, value2, "zCoordinate"); return (Criteria) this; } public Criteria andPointCodeIsNull() { addCriterion("point_code is null"); return (Criteria) this; } public Criteria andPointCodeIsNotNull() { addCriterion("point_code is not null"); return (Criteria) this; } public Criteria andPointCodeEqualTo(String value) { addCriterion("point_code =", value, "pointCode"); return (Criteria) this; } public Criteria andPointCodeNotEqualTo(String value) { addCriterion("point_code <>", value, "pointCode"); return (Criteria) this; } public Criteria andPointCodeGreaterThan(String value) { addCriterion("point_code >", value, "pointCode"); return (Criteria) this; } public Criteria andPointCodeGreaterThanOrEqualTo(String value) { addCriterion("point_code >=", value, "pointCode"); return (Criteria) this; } public Criteria andPointCodeLessThan(String value) { addCriterion("point_code <", value, "pointCode"); return (Criteria) this; } public Criteria andPointCodeLessThanOrEqualTo(String value) { addCriterion("point_code <=", value, "pointCode"); return (Criteria) this; } public Criteria andPointCodeLike(String value) { addCriterion("point_code like", value, "pointCode"); return (Criteria) this; } public Criteria andPointCodeNotLike(String value) { addCriterion("point_code not like", value, "pointCode"); return (Criteria) this; } public Criteria andPointCodeIn(List values) { addCriterion("point_code in", values, "pointCode"); return (Criteria) this; } public Criteria andPointCodeNotIn(List values) { addCriterion("point_code not in", values, "pointCode"); return (Criteria) this; } public Criteria andPointCodeBetween(String value1, String value2) { addCriterion("point_code between", value1, value2, "pointCode"); return (Criteria) this; } public Criteria andPointCodeNotBetween(String value1, String value2) { addCriterion("point_code not between", value1, value2, "pointCode"); return (Criteria) this; } public Criteria andPointNameIsNull() { addCriterion("point_name is null"); return (Criteria) this; } public Criteria andPointNameIsNotNull() { addCriterion("point_name is not null"); return (Criteria) this; } public Criteria andPointNameEqualTo(String value) { addCriterion("point_name =", value, "pointName"); return (Criteria) this; } public Criteria andPointNameNotEqualTo(String value) { addCriterion("point_name <>", value, "pointName"); return (Criteria) this; } public Criteria andPointNameGreaterThan(String value) { addCriterion("point_name >", value, "pointName"); return (Criteria) this; } public Criteria andPointNameGreaterThanOrEqualTo(String value) { addCriterion("point_name >=", value, "pointName"); return (Criteria) this; } public Criteria andPointNameLessThan(String value) { addCriterion("point_name <", value, "pointName"); return (Criteria) this; } public Criteria andPointNameLessThanOrEqualTo(String value) { addCriterion("point_name <=", value, "pointName"); return (Criteria) this; } public Criteria andPointNameLike(String value) { addCriterion("point_name like", value, "pointName"); return (Criteria) this; } public Criteria andPointNameNotLike(String value) { addCriterion("point_name not like", value, "pointName"); return (Criteria) this; } public Criteria andPointNameIn(List values) { addCriterion("point_name in", values, "pointName"); return (Criteria) this; } public Criteria andPointNameNotIn(List values) { addCriterion("point_name not in", values, "pointName"); return (Criteria) this; } public Criteria andPointNameBetween(String value1, String value2) { addCriterion("point_name between", value1, value2, "pointName"); return (Criteria) this; } public Criteria andPointNameNotBetween(String value1, String value2) { addCriterion("point_name not between", value1, value2, "pointName"); return (Criteria) this; } public Criteria andDeletedIsNull() { addCriterion("deleted is null"); return (Criteria) this; } public Criteria andDeletedIsNotNull() { addCriterion("deleted is not null"); return (Criteria) this; } public Criteria andDeletedEqualTo(Short value) { addCriterion("deleted =", value, "deleted"); return (Criteria) this; } public Criteria andDeletedNotEqualTo(Short value) { addCriterion("deleted <>", value, "deleted"); return (Criteria) this; } public Criteria andDeletedGreaterThan(Short value) { addCriterion("deleted >", value, "deleted"); return (Criteria) this; } public Criteria andDeletedGreaterThanOrEqualTo(Short value) { addCriterion("deleted >=", value, "deleted"); return (Criteria) this; } public Criteria andDeletedLessThan(Short value) { addCriterion("deleted <", value, "deleted"); return (Criteria) this; } public Criteria andDeletedLessThanOrEqualTo(Short value) { addCriterion("deleted <=", value, "deleted"); return (Criteria) this; } public Criteria andDeletedIn(List values) { addCriterion("deleted in", values, "deleted"); return (Criteria) this; } public Criteria andDeletedNotIn(List values) { addCriterion("deleted not in", values, "deleted"); return (Criteria) this; } public Criteria andDeletedBetween(Short value1, Short value2) { addCriterion("deleted between", value1, value2, "deleted"); return (Criteria) this; } public Criteria andDeletedNotBetween(Short value1, Short value2) { addCriterion("deleted not between", value1, value2, "deleted"); return (Criteria) this; } public Criteria andTypeCodeIsNull() { addCriterion("type_code is null"); return (Criteria) this; } public Criteria andTypeCodeIsNotNull() { addCriterion("type_code is not null"); return (Criteria) this; } public Criteria andTypeCodeEqualTo(String value) { addCriterion("type_code =", value, "typeCode"); return (Criteria) this; } public Criteria andTypeCodeNotEqualTo(String value) { addCriterion("type_code <>", value, "typeCode"); return (Criteria) this; } public Criteria andTypeCodeGreaterThan(String value) { addCriterion("type_code >", value, "typeCode"); return (Criteria) this; } public Criteria andTypeCodeGreaterThanOrEqualTo(String value) { addCriterion("type_code >=", value, "typeCode"); return (Criteria) this; } public Criteria andTypeCodeLessThan(String value) { addCriterion("type_code <", value, "typeCode"); return (Criteria) this; } public Criteria andTypeCodeLessThanOrEqualTo(String value) { addCriterion("type_code <=", value, "typeCode"); return (Criteria) this; } public Criteria andTypeCodeLike(String value) { addCriterion("type_code like", value, "typeCode"); return (Criteria) this; } public Criteria andTypeCodeNotLike(String value) { addCriterion("type_code not like", value, "typeCode"); return (Criteria) this; } public Criteria andTypeCodeIn(List values) { addCriterion("type_code in", values, "typeCode"); return (Criteria) this; } public Criteria andTypeCodeNotIn(List values) { addCriterion("type_code not in", values, "typeCode"); return (Criteria) this; } public Criteria andTypeCodeBetween(String value1, String value2) { addCriterion("type_code between", value1, value2, "typeCode"); return (Criteria) this; } public Criteria andTypeCodeNotBetween(String value1, String value2) { addCriterion("type_code not between", value1, value2, "typeCode"); 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); } } }