package com.miniframe.model.system; import java.util.ArrayList; import java.util.List; public class DBoundarySQLBuilder { protected String orderByClause; protected boolean distinct; protected List oredCriteria; public DBoundarySQLBuilder() { 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 andNidIsNull() { addCriterion("nid is null"); return (Criteria) this; } public Criteria andNidIsNotNull() { addCriterion("nid is not null"); return (Criteria) this; } public Criteria andNidEqualTo(Integer value) { addCriterion("nid =", value, "nid"); return (Criteria) this; } public Criteria andNidNotEqualTo(Integer value) { addCriterion("nid <>", value, "nid"); return (Criteria) this; } public Criteria andNidGreaterThan(Integer value) { addCriterion("nid >", value, "nid"); return (Criteria) this; } public Criteria andNidGreaterThanOrEqualTo(Integer value) { addCriterion("nid >=", value, "nid"); return (Criteria) this; } public Criteria andNidLessThan(Integer value) { addCriterion("nid <", value, "nid"); return (Criteria) this; } public Criteria andNidLessThanOrEqualTo(Integer value) { addCriterion("nid <=", value, "nid"); return (Criteria) this; } public Criteria andNidIn(List values) { addCriterion("nid in", values, "nid"); return (Criteria) this; } public Criteria andNidNotIn(List values) { addCriterion("nid not in", values, "nid"); return (Criteria) this; } public Criteria andNidBetween(Integer value1, Integer value2) { addCriterion("nid between", value1, value2, "nid"); return (Criteria) this; } public Criteria andNidNotBetween(Integer value1, Integer value2) { addCriterion("nid not between", value1, value2, "nid"); return (Criteria) this; } public Criteria andNnameIsNull() { addCriterion("nname is null"); return (Criteria) this; } public Criteria andNnameIsNotNull() { addCriterion("nname is not null"); return (Criteria) this; } public Criteria andNnameEqualTo(String value) { addCriterion("nname =", value, "nname"); return (Criteria) this; } public Criteria andNnameNotEqualTo(String value) { addCriterion("nname <>", value, "nname"); return (Criteria) this; } public Criteria andNnameGreaterThan(String value) { addCriterion("nname >", value, "nname"); return (Criteria) this; } public Criteria andNnameGreaterThanOrEqualTo(String value) { addCriterion("nname >=", value, "nname"); return (Criteria) this; } public Criteria andNnameLessThan(String value) { addCriterion("nname <", value, "nname"); return (Criteria) this; } public Criteria andNnameLessThanOrEqualTo(String value) { addCriterion("nname <=", value, "nname"); return (Criteria) this; } public Criteria andNnameLike(String value) { addCriterion("nname like", value, "nname"); return (Criteria) this; } public Criteria andNnameNotLike(String value) { addCriterion("nname not like", value, "nname"); return (Criteria) this; } public Criteria andNnameIn(List values) { addCriterion("nname in", values, "nname"); return (Criteria) this; } public Criteria andNnameNotIn(List values) { addCriterion("nname not in", values, "nname"); return (Criteria) this; } public Criteria andNnameBetween(String value1, String value2) { addCriterion("nname between", value1, value2, "nname"); return (Criteria) this; } public Criteria andNnameNotBetween(String value1, String value2) { addCriterion("nname not between", value1, value2, "nname"); 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 andVal1IsNull() { addCriterion("val1 is null"); return (Criteria) this; } public Criteria andVal1IsNotNull() { addCriterion("val1 is not null"); return (Criteria) this; } public Criteria andVal1EqualTo(Float value) { addCriterion("val1 =", value, "val1"); return (Criteria) this; } public Criteria andVal1NotEqualTo(Float value) { addCriterion("val1 <>", value, "val1"); return (Criteria) this; } public Criteria andVal1GreaterThan(Float value) { addCriterion("val1 >", value, "val1"); return (Criteria) this; } public Criteria andVal1GreaterThanOrEqualTo(Float value) { addCriterion("val1 >=", value, "val1"); return (Criteria) this; } public Criteria andVal1LessThan(Float value) { addCriterion("val1 <", value, "val1"); return (Criteria) this; } public Criteria andVal1LessThanOrEqualTo(Float value) { addCriterion("val1 <=", value, "val1"); return (Criteria) this; } public Criteria andVal1In(List values) { addCriterion("val1 in", values, "val1"); return (Criteria) this; } public Criteria andVal1NotIn(List values) { addCriterion("val1 not in", values, "val1"); return (Criteria) this; } public Criteria andVal1Between(Float value1, Float value2) { addCriterion("val1 between", value1, value2, "val1"); return (Criteria) this; } public Criteria andVal1NotBetween(Float value1, Float value2) { addCriterion("val1 not between", value1, value2, "val1"); return (Criteria) this; } public Criteria andVal2IsNull() { addCriterion("val2 is null"); return (Criteria) this; } public Criteria andVal2IsNotNull() { addCriterion("val2 is not null"); return (Criteria) this; } public Criteria andVal2EqualTo(Float value) { addCriterion("val2 =", value, "val2"); return (Criteria) this; } public Criteria andVal2NotEqualTo(Float value) { addCriterion("val2 <>", value, "val2"); return (Criteria) this; } public Criteria andVal2GreaterThan(Float value) { addCriterion("val2 >", value, "val2"); return (Criteria) this; } public Criteria andVal2GreaterThanOrEqualTo(Float value) { addCriterion("val2 >=", value, "val2"); return (Criteria) this; } public Criteria andVal2LessThan(Float value) { addCriterion("val2 <", value, "val2"); return (Criteria) this; } public Criteria andVal2LessThanOrEqualTo(Float value) { addCriterion("val2 <=", value, "val2"); return (Criteria) this; } public Criteria andVal2In(List values) { addCriterion("val2 in", values, "val2"); return (Criteria) this; } public Criteria andVal2NotIn(List values) { addCriterion("val2 not in", values, "val2"); return (Criteria) this; } public Criteria andVal2Between(Float value1, Float value2) { addCriterion("val2 between", value1, value2, "val2"); return (Criteria) this; } public Criteria andVal2NotBetween(Float value1, Float value2) { addCriterion("val2 not between", value1, value2, "val2"); return (Criteria) this; } public Criteria andVal3IsNull() { addCriterion("val3 is null"); return (Criteria) this; } public Criteria andVal3IsNotNull() { addCriterion("val3 is not null"); return (Criteria) this; } public Criteria andVal3EqualTo(Float value) { addCriterion("val3 =", value, "val3"); return (Criteria) this; } public Criteria andVal3NotEqualTo(Float value) { addCriterion("val3 <>", value, "val3"); return (Criteria) this; } public Criteria andVal3GreaterThan(Float value) { addCriterion("val3 >", value, "val3"); return (Criteria) this; } public Criteria andVal3GreaterThanOrEqualTo(Float value) { addCriterion("val3 >=", value, "val3"); return (Criteria) this; } public Criteria andVal3LessThan(Float value) { addCriterion("val3 <", value, "val3"); return (Criteria) this; } public Criteria andVal3LessThanOrEqualTo(Float value) { addCriterion("val3 <=", value, "val3"); return (Criteria) this; } public Criteria andVal3In(List values) { addCriterion("val3 in", values, "val3"); return (Criteria) this; } public Criteria andVal3NotIn(List values) { addCriterion("val3 not in", values, "val3"); return (Criteria) this; } public Criteria andVal3Between(Float value1, Float value2) { addCriterion("val3 between", value1, value2, "val3"); return (Criteria) this; } public Criteria andVal3NotBetween(Float value1, Float value2) { addCriterion("val3 not between", value1, value2, "val3"); return (Criteria) this; } public Criteria andVal4IsNull() { addCriterion("val4 is null"); return (Criteria) this; } public Criteria andVal4IsNotNull() { addCriterion("val4 is not null"); return (Criteria) this; } public Criteria andVal4EqualTo(Float value) { addCriterion("val4 =", value, "val4"); return (Criteria) this; } public Criteria andVal4NotEqualTo(Float value) { addCriterion("val4 <>", value, "val4"); return (Criteria) this; } public Criteria andVal4GreaterThan(Float value) { addCriterion("val4 >", value, "val4"); return (Criteria) this; } public Criteria andVal4GreaterThanOrEqualTo(Float value) { addCriterion("val4 >=", value, "val4"); return (Criteria) this; } public Criteria andVal4LessThan(Float value) { addCriterion("val4 <", value, "val4"); return (Criteria) this; } public Criteria andVal4LessThanOrEqualTo(Float value) { addCriterion("val4 <=", value, "val4"); return (Criteria) this; } public Criteria andVal4In(List values) { addCriterion("val4 in", values, "val4"); return (Criteria) this; } public Criteria andVal4NotIn(List values) { addCriterion("val4 not in", values, "val4"); return (Criteria) this; } public Criteria andVal4Between(Float value1, Float value2) { addCriterion("val4 between", value1, value2, "val4"); return (Criteria) this; } public Criteria andVal4NotBetween(Float value1, Float value2) { addCriterion("val4 not between", value1, value2, "val4"); 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); } } }