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 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); } } }