package com.miniframe.model.ac; import java.util.ArrayList; import java.util.Date; import java.util.List; public class AcProAttSQLBuilder { protected String orderByClause; protected boolean distinct; protected List oredCriteria; public AcProAttSQLBuilder() { 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 andPattIdIsNull() { addCriterion("patt_id is null"); return (Criteria) this; } public Criteria andPattIdIsNotNull() { addCriterion("patt_id is not null"); return (Criteria) this; } public Criteria andPattIdEqualTo(String value) { addCriterion("patt_id =", value, "pattId"); return (Criteria) this; } public Criteria andPattIdNotEqualTo(String value) { addCriterion("patt_id <>", value, "pattId"); return (Criteria) this; } public Criteria andPattIdGreaterThan(String value) { addCriterion("patt_id >", value, "pattId"); return (Criteria) this; } public Criteria andPattIdGreaterThanOrEqualTo(String value) { addCriterion("patt_id >=", value, "pattId"); return (Criteria) this; } public Criteria andPattIdLessThan(String value) { addCriterion("patt_id <", value, "pattId"); return (Criteria) this; } public Criteria andPattIdLessThanOrEqualTo(String value) { addCriterion("patt_id <=", value, "pattId"); return (Criteria) this; } public Criteria andPattIdLike(String value) { addCriterion("patt_id like", value, "pattId"); return (Criteria) this; } public Criteria andPattIdNotLike(String value) { addCriterion("patt_id not like", value, "pattId"); return (Criteria) this; } public Criteria andPattIdIn(List values) { addCriterion("patt_id in", values, "pattId"); return (Criteria) this; } public Criteria andPattIdNotIn(List values) { addCriterion("patt_id not in", values, "pattId"); return (Criteria) this; } public Criteria andPattIdBetween(String value1, String value2) { addCriterion("patt_id between", value1, value2, "pattId"); return (Criteria) this; } public Criteria andPattIdNotBetween(String value1, String value2) { addCriterion("patt_id not between", value1, value2, "pattId"); 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(String value) { addCriterion("pid =", value, "pid"); return (Criteria) this; } public Criteria andPidNotEqualTo(String value) { addCriterion("pid <>", value, "pid"); return (Criteria) this; } public Criteria andPidGreaterThan(String value) { addCriterion("pid >", value, "pid"); return (Criteria) this; } public Criteria andPidGreaterThanOrEqualTo(String value) { addCriterion("pid >=", value, "pid"); return (Criteria) this; } public Criteria andPidLessThan(String value) { addCriterion("pid <", value, "pid"); return (Criteria) this; } public Criteria andPidLessThanOrEqualTo(String value) { addCriterion("pid <=", value, "pid"); return (Criteria) this; } public Criteria andPidLike(String value) { addCriterion("pid like", value, "pid"); return (Criteria) this; } public Criteria andPidNotLike(String value) { addCriterion("pid not like", 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(String value1, String value2) { addCriterion("pid between", value1, value2, "pid"); return (Criteria) this; } public Criteria andPidNotBetween(String value1, String value2) { addCriterion("pid not between", value1, value2, "pid"); return (Criteria) this; } public Criteria andAttIdIsNull() { addCriterion("att_id is null"); return (Criteria) this; } public Criteria andAttIdIsNotNull() { addCriterion("att_id is not null"); return (Criteria) this; } public Criteria andAttIdEqualTo(String value) { addCriterion("att_id =", value, "attId"); return (Criteria) this; } public Criteria andAttIdNotEqualTo(String value) { addCriterion("att_id <>", value, "attId"); return (Criteria) this; } public Criteria andAttIdGreaterThan(String value) { addCriterion("att_id >", value, "attId"); return (Criteria) this; } public Criteria andAttIdGreaterThanOrEqualTo(String value) { addCriterion("att_id >=", value, "attId"); return (Criteria) this; } public Criteria andAttIdLessThan(String value) { addCriterion("att_id <", value, "attId"); return (Criteria) this; } public Criteria andAttIdLessThanOrEqualTo(String value) { addCriterion("att_id <=", value, "attId"); return (Criteria) this; } public Criteria andAttIdLike(String value) { addCriterion("att_id like", value, "attId"); return (Criteria) this; } public Criteria andAttIdNotLike(String value) { addCriterion("att_id not like", value, "attId"); return (Criteria) this; } public Criteria andAttIdIn(List values) { addCriterion("att_id in", values, "attId"); return (Criteria) this; } public Criteria andAttIdNotIn(List values) { addCriterion("att_id not in", values, "attId"); return (Criteria) this; } public Criteria andAttIdBetween(String value1, String value2) { addCriterion("att_id between", value1, value2, "attId"); return (Criteria) this; } public Criteria andAttIdNotBetween(String value1, String value2) { addCriterion("att_id not between", value1, value2, "attId"); return (Criteria) this; } public Criteria andValIsNull() { addCriterion("val is null"); return (Criteria) this; } public Criteria andValIsNotNull() { addCriterion("val is not null"); return (Criteria) this; } public Criteria andValEqualTo(String value) { addCriterion("val =", value, "val"); return (Criteria) this; } public Criteria andValNotEqualTo(String value) { addCriterion("val <>", value, "val"); return (Criteria) this; } public Criteria andValGreaterThan(String value) { addCriterion("val >", value, "val"); return (Criteria) this; } public Criteria andValGreaterThanOrEqualTo(String value) { addCriterion("val >=", value, "val"); return (Criteria) this; } public Criteria andValLessThan(String value) { addCriterion("val <", value, "val"); return (Criteria) this; } public Criteria andValLessThanOrEqualTo(String value) { addCriterion("val <=", value, "val"); return (Criteria) this; } public Criteria andValLike(String value) { addCriterion("val like", value, "val"); return (Criteria) this; } public Criteria andValNotLike(String value) { addCriterion("val not like", value, "val"); return (Criteria) this; } public Criteria andValIn(List values) { addCriterion("val in", values, "val"); return (Criteria) this; } public Criteria andValNotIn(List values) { addCriterion("val not in", values, "val"); return (Criteria) this; } public Criteria andValBetween(String value1, String value2) { addCriterion("val between", value1, value2, "val"); return (Criteria) this; } public Criteria andValNotBetween(String value1, String value2) { addCriterion("val not between", value1, value2, "val"); return (Criteria) this; } public Criteria andUidIsNull() { addCriterion("uid is null"); return (Criteria) this; } public Criteria andUidIsNotNull() { addCriterion("uid is not null"); return (Criteria) this; } public Criteria andUidEqualTo(String value) { addCriterion("uid =", value, "uid"); return (Criteria) this; } public Criteria andUidNotEqualTo(String value) { addCriterion("uid <>", value, "uid"); return (Criteria) this; } public Criteria andUidGreaterThan(String value) { addCriterion("uid >", value, "uid"); return (Criteria) this; } public Criteria andUidGreaterThanOrEqualTo(String value) { addCriterion("uid >=", value, "uid"); return (Criteria) this; } public Criteria andUidLessThan(String value) { addCriterion("uid <", value, "uid"); return (Criteria) this; } public Criteria andUidLessThanOrEqualTo(String value) { addCriterion("uid <=", value, "uid"); return (Criteria) this; } public Criteria andUidLike(String value) { addCriterion("uid like", value, "uid"); return (Criteria) this; } public Criteria andUidNotLike(String value) { addCriterion("uid not like", value, "uid"); return (Criteria) this; } public Criteria andUidIn(List values) { addCriterion("uid in", values, "uid"); return (Criteria) this; } public Criteria andUidNotIn(List values) { addCriterion("uid not in", values, "uid"); return (Criteria) this; } public Criteria andUidBetween(String value1, String value2) { addCriterion("uid between", value1, value2, "uid"); return (Criteria) this; } public Criteria andUidNotBetween(String value1, String value2) { addCriterion("uid not between", value1, value2, "uid"); return (Criteria) this; } public Criteria andCreateTimeIsNull() { addCriterion("create_time is null"); return (Criteria) this; } public Criteria andCreateTimeIsNotNull() { addCriterion("create_time is not null"); return (Criteria) this; } public Criteria andCreateTimeEqualTo(Date value) { addCriterion("create_time =", value, "createTime"); return (Criteria) this; } public Criteria andCreateTimeNotEqualTo(Date value) { addCriterion("create_time <>", value, "createTime"); return (Criteria) this; } public Criteria andCreateTimeGreaterThan(Date value) { addCriterion("create_time >", value, "createTime"); return (Criteria) this; } public Criteria andCreateTimeGreaterThanOrEqualTo(Date value) { addCriterion("create_time >=", value, "createTime"); return (Criteria) this; } public Criteria andCreateTimeLessThan(Date value) { addCriterion("create_time <", value, "createTime"); return (Criteria) this; } public Criteria andCreateTimeLessThanOrEqualTo(Date value) { addCriterion("create_time <=", value, "createTime"); return (Criteria) this; } public Criteria andCreateTimeIn(List values) { addCriterion("create_time in", values, "createTime"); return (Criteria) this; } public Criteria andCreateTimeNotIn(List values) { addCriterion("create_time not in", values, "createTime"); return (Criteria) this; } public Criteria andCreateTimeBetween(Date value1, Date value2) { addCriterion("create_time between", value1, value2, "createTime"); return (Criteria) this; } public Criteria andCreateTimeNotBetween(Date value1, Date value2) { addCriterion("create_time not between", value1, value2, "createTime"); return (Criteria) this; } public Criteria andUpdateTimeIsNull() { addCriterion("update_time is null"); return (Criteria) this; } public Criteria andUpdateTimeIsNotNull() { addCriterion("update_time is not null"); return (Criteria) this; } public Criteria andUpdateTimeEqualTo(Date value) { addCriterion("update_time =", value, "updateTime"); return (Criteria) this; } public Criteria andUpdateTimeNotEqualTo(Date value) { addCriterion("update_time <>", value, "updateTime"); return (Criteria) this; } public Criteria andUpdateTimeGreaterThan(Date value) { addCriterion("update_time >", value, "updateTime"); return (Criteria) this; } public Criteria andUpdateTimeGreaterThanOrEqualTo(Date value) { addCriterion("update_time >=", value, "updateTime"); return (Criteria) this; } public Criteria andUpdateTimeLessThan(Date value) { addCriterion("update_time <", value, "updateTime"); return (Criteria) this; } public Criteria andUpdateTimeLessThanOrEqualTo(Date value) { addCriterion("update_time <=", value, "updateTime"); return (Criteria) this; } public Criteria andUpdateTimeIn(List values) { addCriterion("update_time in", values, "updateTime"); return (Criteria) this; } public Criteria andUpdateTimeNotIn(List values) { addCriterion("update_time not in", values, "updateTime"); return (Criteria) this; } public Criteria andUpdateTimeBetween(Date value1, Date value2) { addCriterion("update_time between", value1, value2, "updateTime"); return (Criteria) this; } public Criteria andUpdateTimeNotBetween(Date value1, Date value2) { addCriterion("update_time not between", value1, value2, "updateTime"); return (Criteria) this; } public Criteria andRemarkIsNull() { addCriterion("remark is null"); return (Criteria) this; } public Criteria andRemarkIsNotNull() { addCriterion("remark is not null"); return (Criteria) this; } public Criteria andRemarkEqualTo(String value) { addCriterion("remark =", value, "remark"); return (Criteria) this; } public Criteria andRemarkNotEqualTo(String value) { addCriterion("remark <>", value, "remark"); return (Criteria) this; } public Criteria andRemarkGreaterThan(String value) { addCriterion("remark >", value, "remark"); return (Criteria) this; } public Criteria andRemarkGreaterThanOrEqualTo(String value) { addCriterion("remark >=", value, "remark"); return (Criteria) this; } public Criteria andRemarkLessThan(String value) { addCriterion("remark <", value, "remark"); return (Criteria) this; } public Criteria andRemarkLessThanOrEqualTo(String value) { addCriterion("remark <=", value, "remark"); return (Criteria) this; } public Criteria andRemarkLike(String value) { addCriterion("remark like", value, "remark"); return (Criteria) this; } public Criteria andRemarkNotLike(String value) { addCriterion("remark not like", value, "remark"); return (Criteria) this; } public Criteria andRemarkIn(List values) { addCriterion("remark in", values, "remark"); return (Criteria) this; } public Criteria andRemarkNotIn(List values) { addCriterion("remark not in", values, "remark"); return (Criteria) this; } public Criteria andRemarkBetween(String value1, String value2) { addCriterion("remark between", value1, value2, "remark"); return (Criteria) this; } public Criteria andRemarkNotBetween(String value1, String value2) { addCriterion("remark not between", value1, value2, "remark"); 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); } } }