package com.miniframe.model.system; import java.util.ArrayList; import java.util.List; public class DChecknodeValcodeSQLBuilder { protected String orderByClause; protected boolean distinct; protected List oredCriteria; public DChecknodeValcodeSQLBuilder() { 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 andAidIsNull() { addCriterion("aid is null"); return (Criteria) this; } public Criteria andAidIsNotNull() { addCriterion("aid is not null"); return (Criteria) this; } public Criteria andAidEqualTo(Integer value) { addCriterion("aid =", value, "aid"); return (Criteria) this; } public Criteria andAidNotEqualTo(Integer value) { addCriterion("aid <>", value, "aid"); return (Criteria) this; } public Criteria andAidGreaterThan(Integer value) { addCriterion("aid >", value, "aid"); return (Criteria) this; } public Criteria andAidGreaterThanOrEqualTo(Integer value) { addCriterion("aid >=", value, "aid"); return (Criteria) this; } public Criteria andAidLessThan(Integer value) { addCriterion("aid <", value, "aid"); return (Criteria) this; } public Criteria andAidLessThanOrEqualTo(Integer value) { addCriterion("aid <=", value, "aid"); return (Criteria) this; } public Criteria andAidIn(List values) { addCriterion("aid in", values, "aid"); return (Criteria) this; } public Criteria andAidNotIn(List values) { addCriterion("aid not in", values, "aid"); return (Criteria) this; } public Criteria andAidBetween(Integer value1, Integer value2) { addCriterion("aid between", value1, value2, "aid"); return (Criteria) this; } public Criteria andAidNotBetween(Integer value1, Integer value2) { addCriterion("aid not between", value1, value2, "aid"); return (Criteria) this; } public Criteria andJidIsNull() { addCriterion("jid is null"); return (Criteria) this; } public Criteria andJidIsNotNull() { addCriterion("jid is not null"); return (Criteria) this; } public Criteria andJidEqualTo(Integer value) { addCriterion("jid =", value, "jid"); return (Criteria) this; } public Criteria andJidNotEqualTo(Integer value) { addCriterion("jid <>", value, "jid"); return (Criteria) this; } public Criteria andJidGreaterThan(Integer value) { addCriterion("jid >", value, "jid"); return (Criteria) this; } public Criteria andJidGreaterThanOrEqualTo(Integer value) { addCriterion("jid >=", value, "jid"); return (Criteria) this; } public Criteria andJidLessThan(Integer value) { addCriterion("jid <", value, "jid"); return (Criteria) this; } public Criteria andJidLessThanOrEqualTo(Integer value) { addCriterion("jid <=", value, "jid"); return (Criteria) this; } public Criteria andJidIn(List values) { addCriterion("jid in", values, "jid"); return (Criteria) this; } public Criteria andJidNotIn(List values) { addCriterion("jid not in", values, "jid"); return (Criteria) this; } public Criteria andJidBetween(Integer value1, Integer value2) { addCriterion("jid between", value1, value2, "jid"); return (Criteria) this; } public Criteria andJidNotBetween(Integer value1, Integer value2) { addCriterion("jid not between", value1, value2, "jid"); return (Criteria) this; } public Criteria andValCode1IsNull() { addCriterion("val_code1 is null"); return (Criteria) this; } public Criteria andValCode1IsNotNull() { addCriterion("val_code1 is not null"); return (Criteria) this; } public Criteria andValCode1EqualTo(String value) { addCriterion("val_code1 =", value, "valCode1"); return (Criteria) this; } public Criteria andValCode1NotEqualTo(String value) { addCriterion("val_code1 <>", value, "valCode1"); return (Criteria) this; } public Criteria andValCode1GreaterThan(String value) { addCriterion("val_code1 >", value, "valCode1"); return (Criteria) this; } public Criteria andValCode1GreaterThanOrEqualTo(String value) { addCriterion("val_code1 >=", value, "valCode1"); return (Criteria) this; } public Criteria andValCode1LessThan(String value) { addCriterion("val_code1 <", value, "valCode1"); return (Criteria) this; } public Criteria andValCode1LessThanOrEqualTo(String value) { addCriterion("val_code1 <=", value, "valCode1"); return (Criteria) this; } public Criteria andValCode1Like(String value) { addCriterion("val_code1 like", value, "valCode1"); return (Criteria) this; } public Criteria andValCode1NotLike(String value) { addCriterion("val_code1 not like", value, "valCode1"); return (Criteria) this; } public Criteria andValCode1In(List values) { addCriterion("val_code1 in", values, "valCode1"); return (Criteria) this; } public Criteria andValCode1NotIn(List values) { addCriterion("val_code1 not in", values, "valCode1"); return (Criteria) this; } public Criteria andValCode1Between(String value1, String value2) { addCriterion("val_code1 between", value1, value2, "valCode1"); return (Criteria) this; } public Criteria andValCode1NotBetween(String value1, String value2) { addCriterion("val_code1 not between", value1, value2, "valCode1"); return (Criteria) this; } public Criteria andValCode2IsNull() { addCriterion("val_code2 is null"); return (Criteria) this; } public Criteria andValCode2IsNotNull() { addCriterion("val_code2 is not null"); return (Criteria) this; } public Criteria andValCode2EqualTo(String value) { addCriterion("val_code2 =", value, "valCode2"); return (Criteria) this; } public Criteria andValCode2NotEqualTo(String value) { addCriterion("val_code2 <>", value, "valCode2"); return (Criteria) this; } public Criteria andValCode2GreaterThan(String value) { addCriterion("val_code2 >", value, "valCode2"); return (Criteria) this; } public Criteria andValCode2GreaterThanOrEqualTo(String value) { addCriterion("val_code2 >=", value, "valCode2"); return (Criteria) this; } public Criteria andValCode2LessThan(String value) { addCriterion("val_code2 <", value, "valCode2"); return (Criteria) this; } public Criteria andValCode2LessThanOrEqualTo(String value) { addCriterion("val_code2 <=", value, "valCode2"); return (Criteria) this; } public Criteria andValCode2Like(String value) { addCriterion("val_code2 like", value, "valCode2"); return (Criteria) this; } public Criteria andValCode2NotLike(String value) { addCriterion("val_code2 not like", value, "valCode2"); return (Criteria) this; } public Criteria andValCode2In(List values) { addCriterion("val_code2 in", values, "valCode2"); return (Criteria) this; } public Criteria andValCode2NotIn(List values) { addCriterion("val_code2 not in", values, "valCode2"); return (Criteria) this; } public Criteria andValCode2Between(String value1, String value2) { addCriterion("val_code2 between", value1, value2, "valCode2"); return (Criteria) this; } public Criteria andValCode2NotBetween(String value1, String value2) { addCriterion("val_code2 not between", value1, value2, "valCode2"); return (Criteria) this; } public Criteria andValCode3IsNull() { addCriterion("val_code3 is null"); return (Criteria) this; } public Criteria andValCode3IsNotNull() { addCriterion("val_code3 is not null"); return (Criteria) this; } public Criteria andValCode3EqualTo(String value) { addCriterion("val_code3 =", value, "valCode3"); return (Criteria) this; } public Criteria andValCode3NotEqualTo(String value) { addCriterion("val_code3 <>", value, "valCode3"); return (Criteria) this; } public Criteria andValCode3GreaterThan(String value) { addCriterion("val_code3 >", value, "valCode3"); return (Criteria) this; } public Criteria andValCode3GreaterThanOrEqualTo(String value) { addCriterion("val_code3 >=", value, "valCode3"); return (Criteria) this; } public Criteria andValCode3LessThan(String value) { addCriterion("val_code3 <", value, "valCode3"); return (Criteria) this; } public Criteria andValCode3LessThanOrEqualTo(String value) { addCriterion("val_code3 <=", value, "valCode3"); return (Criteria) this; } public Criteria andValCode3Like(String value) { addCriterion("val_code3 like", value, "valCode3"); return (Criteria) this; } public Criteria andValCode3NotLike(String value) { addCriterion("val_code3 not like", value, "valCode3"); return (Criteria) this; } public Criteria andValCode3In(List values) { addCriterion("val_code3 in", values, "valCode3"); return (Criteria) this; } public Criteria andValCode3NotIn(List values) { addCriterion("val_code3 not in", values, "valCode3"); return (Criteria) this; } public Criteria andValCode3Between(String value1, String value2) { addCriterion("val_code3 between", value1, value2, "valCode3"); return (Criteria) this; } public Criteria andValCode3NotBetween(String value1, String value2) { addCriterion("val_code3 not between", value1, value2, "valCode3"); return (Criteria) this; } public Criteria andValCode4IsNull() { addCriterion("val_code4 is null"); return (Criteria) this; } public Criteria andValCode4IsNotNull() { addCriterion("val_code4 is not null"); return (Criteria) this; } public Criteria andValCode4EqualTo(String value) { addCriterion("val_code4 =", value, "valCode4"); return (Criteria) this; } public Criteria andValCode4NotEqualTo(String value) { addCriterion("val_code4 <>", value, "valCode4"); return (Criteria) this; } public Criteria andValCode4GreaterThan(String value) { addCriterion("val_code4 >", value, "valCode4"); return (Criteria) this; } public Criteria andValCode4GreaterThanOrEqualTo(String value) { addCriterion("val_code4 >=", value, "valCode4"); return (Criteria) this; } public Criteria andValCode4LessThan(String value) { addCriterion("val_code4 <", value, "valCode4"); return (Criteria) this; } public Criteria andValCode4LessThanOrEqualTo(String value) { addCriterion("val_code4 <=", value, "valCode4"); return (Criteria) this; } public Criteria andValCode4Like(String value) { addCriterion("val_code4 like", value, "valCode4"); return (Criteria) this; } public Criteria andValCode4NotLike(String value) { addCriterion("val_code4 not like", value, "valCode4"); return (Criteria) this; } public Criteria andValCode4In(List values) { addCriterion("val_code4 in", values, "valCode4"); return (Criteria) this; } public Criteria andValCode4NotIn(List values) { addCriterion("val_code4 not in", values, "valCode4"); return (Criteria) this; } public Criteria andValCode4Between(String value1, String value2) { addCriterion("val_code4 between", value1, value2, "valCode4"); return (Criteria) this; } public Criteria andValCode4NotBetween(String value1, String value2) { addCriterion("val_code4 not between", value1, value2, "valCode4"); return (Criteria) this; } public Criteria andValCode5IsNull() { addCriterion("val_code5 is null"); return (Criteria) this; } public Criteria andValCode5IsNotNull() { addCriterion("val_code5 is not null"); return (Criteria) this; } public Criteria andValCode5EqualTo(String value) { addCriterion("val_code5 =", value, "valCode5"); return (Criteria) this; } public Criteria andValCode5NotEqualTo(String value) { addCriterion("val_code5 <>", value, "valCode5"); return (Criteria) this; } public Criteria andValCode5GreaterThan(String value) { addCriterion("val_code5 >", value, "valCode5"); return (Criteria) this; } public Criteria andValCode5GreaterThanOrEqualTo(String value) { addCriterion("val_code5 >=", value, "valCode5"); return (Criteria) this; } public Criteria andValCode5LessThan(String value) { addCriterion("val_code5 <", value, "valCode5"); return (Criteria) this; } public Criteria andValCode5LessThanOrEqualTo(String value) { addCriterion("val_code5 <=", value, "valCode5"); return (Criteria) this; } public Criteria andValCode5Like(String value) { addCriterion("val_code5 like", value, "valCode5"); return (Criteria) this; } public Criteria andValCode5NotLike(String value) { addCriterion("val_code5 not like", value, "valCode5"); return (Criteria) this; } public Criteria andValCode5In(List values) { addCriterion("val_code5 in", values, "valCode5"); return (Criteria) this; } public Criteria andValCode5NotIn(List values) { addCriterion("val_code5 not in", values, "valCode5"); return (Criteria) this; } public Criteria andValCode5Between(String value1, String value2) { addCriterion("val_code5 between", value1, value2, "valCode5"); return (Criteria) this; } public Criteria andValCode5NotBetween(String value1, String value2) { addCriterion("val_code5 not between", value1, value2, "valCode5"); return (Criteria) this; } public Criteria andValCode6IsNull() { addCriterion("val_code6 is null"); return (Criteria) this; } public Criteria andValCode6IsNotNull() { addCriterion("val_code6 is not null"); return (Criteria) this; } public Criteria andValCode6EqualTo(String value) { addCriterion("val_code6 =", value, "valCode6"); return (Criteria) this; } public Criteria andValCode6NotEqualTo(String value) { addCriterion("val_code6 <>", value, "valCode6"); return (Criteria) this; } public Criteria andValCode6GreaterThan(String value) { addCriterion("val_code6 >", value, "valCode6"); return (Criteria) this; } public Criteria andValCode6GreaterThanOrEqualTo(String value) { addCriterion("val_code6 >=", value, "valCode6"); return (Criteria) this; } public Criteria andValCode6LessThan(String value) { addCriterion("val_code6 <", value, "valCode6"); return (Criteria) this; } public Criteria andValCode6LessThanOrEqualTo(String value) { addCriterion("val_code6 <=", value, "valCode6"); return (Criteria) this; } public Criteria andValCode6Like(String value) { addCriterion("val_code6 like", value, "valCode6"); return (Criteria) this; } public Criteria andValCode6NotLike(String value) { addCriterion("val_code6 not like", value, "valCode6"); return (Criteria) this; } public Criteria andValCode6In(List values) { addCriterion("val_code6 in", values, "valCode6"); return (Criteria) this; } public Criteria andValCode6NotIn(List values) { addCriterion("val_code6 not in", values, "valCode6"); return (Criteria) this; } public Criteria andValCode6Between(String value1, String value2) { addCriterion("val_code6 between", value1, value2, "valCode6"); return (Criteria) this; } public Criteria andValCode6NotBetween(String value1, String value2) { addCriterion("val_code6 not between", value1, value2, "valCode6"); 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); } } }