TrafficFaceExample.java

package com.viontech.fanxing.commons.model;

import com.viontech.fanxing.commons.base.BaseExample;
import java.util.ArrayList;
import java.util.Date;
import java.util.HashSet;
import java.util.List;
import java.util.Set;

public class TrafficFaceExample extends BaseExample {

    public TrafficFaceExample() {
        super();
        tableName = "d_traffic_face";
        tableAlias = "trafficFace";
        ignoreCase = false;
    }

    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(this.tableName,this.ignoreCase);
        return criteria;
    }

    public ColumnContainer createColumns() {
        ColumnContainer columnContainer = (ColumnContainer) columnContainerMap.get(this.tableName);
        if(columnContainer == null){
            columnContainer = new ColumnContainer(this.tableName);
            columnContainerMap.put(this.tableName,columnContainer);
        }
        return (ColumnContainer)columnContainer;
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria(String tableName) {
            super(tableName);
            tableName = "d_traffic_face";
        }

        protected Criteria(String tableName, boolean ignoreCase) {
            this(tableName);
            this.ignoreCase = ignoreCase;
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public void setAllCriteria(List<Criterion> criteria) {
            this.criteria = 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,ignoreCase));
        }

        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("`trafficFace`.id is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("`trafficFace`.id is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(Long value) {
            addCriterion("`trafficFace`.id =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(Long value) {
            addCriterion("`trafficFace`.id <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(Long value) {
            addCriterion("`trafficFace`.id >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(Long value) {
            addCriterion("`trafficFace`.id >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(Long value) {
            addCriterion("`trafficFace`.id <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(Long value) {
            addCriterion("`trafficFace`.id <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<Long> values) {
            addCriterion("`trafficFace`.id in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<Long> values) {
            addCriterion("`trafficFace`.id not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(Long value1, Long value2) {
            addCriterion("`trafficFace`.id between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(Long value1, Long value2) {
            addCriterion("`trafficFace`.id not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andEventTimeIsNull() {
            addCriterion("`trafficFace`.event_time is null");
            return (Criteria) this;
        }

        public Criteria andEventTimeIsNotNull() {
            addCriterion("`trafficFace`.event_time is not null");
            return (Criteria) this;
        }

        public Criteria andEventTimeEqualTo(Date value) {
            addCriterion("`trafficFace`.event_time =", value, "eventTime");
            return (Criteria) this;
        }

        public Criteria andEventTimeNotEqualTo(Date value) {
            addCriterion("`trafficFace`.event_time <>", value, "eventTime");
            return (Criteria) this;
        }

        public Criteria andEventTimeGreaterThan(Date value) {
            addCriterion("`trafficFace`.event_time >", value, "eventTime");
            return (Criteria) this;
        }

        public Criteria andEventTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("`trafficFace`.event_time >=", value, "eventTime");
            return (Criteria) this;
        }

        public Criteria andEventTimeLessThan(Date value) {
            addCriterion("`trafficFace`.event_time <", value, "eventTime");
            return (Criteria) this;
        }

        public Criteria andEventTimeLessThanOrEqualTo(Date value) {
            addCriterion("`trafficFace`.event_time <=", value, "eventTime");
            return (Criteria) this;
        }

        public Criteria andEventTimeIn(List<Date> values) {
            addCriterion("`trafficFace`.event_time in", values, "eventTime");
            return (Criteria) this;
        }

        public Criteria andEventTimeNotIn(List<Date> values) {
            addCriterion("`trafficFace`.event_time not in", values, "eventTime");
            return (Criteria) this;
        }

        public Criteria andEventTimeBetween(Date value1, Date value2) {
            addCriterion("`trafficFace`.event_time between", value1, value2, "eventTime");
            return (Criteria) this;
        }

        public Criteria andEventTimeNotBetween(Date value1, Date value2) {
            addCriterion("`trafficFace`.event_time not between", value1, value2, "eventTime");
            return (Criteria) this;
        }

        public Criteria andUnidIsNull() {
            addCriterion("`trafficFace`.unid is null");
            return (Criteria) this;
        }

        public Criteria andUnidIsNotNull() {
            addCriterion("`trafficFace`.unid is not null");
            return (Criteria) this;
        }

        public Criteria andUnidEqualTo(String value) {
            addCriterion("`trafficFace`.unid =", value, "unid");
            return (Criteria) this;
        }

        public Criteria andUnidNotEqualTo(String value) {
            addCriterion("`trafficFace`.unid <>", value, "unid");
            return (Criteria) this;
        }

        public Criteria andUnidGreaterThan(String value) {
            addCriterion("`trafficFace`.unid >", value, "unid");
            return (Criteria) this;
        }

        public Criteria andUnidGreaterThanOrEqualTo(String value) {
            addCriterion("`trafficFace`.unid >=", value, "unid");
            return (Criteria) this;
        }

        public Criteria andUnidLessThan(String value) {
            addCriterion("`trafficFace`.unid <", value, "unid");
            return (Criteria) this;
        }

        public Criteria andUnidLessThanOrEqualTo(String value) {
            addCriterion("`trafficFace`.unid <=", value, "unid");
            return (Criteria) this;
        }

        public Criteria andUnidLike(String value) {
            addCriterion("`trafficFace`.unid like", value, "unid");
            return (Criteria) this;
        }

        public Criteria andUnidNotLike(String value) {
            addCriterion("`trafficFace`.unid not like", value, "unid");
            return (Criteria) this;
        }

        public Criteria andUnidIn(List<String> values) {
            addCriterion("`trafficFace`.unid in", values, "unid");
            return (Criteria) this;
        }

        public Criteria andUnidNotIn(List<String> values) {
            addCriterion("`trafficFace`.unid not in", values, "unid");
            return (Criteria) this;
        }

        public Criteria andUnidBetween(String value1, String value2) {
            addCriterion("`trafficFace`.unid between", value1, value2, "unid");
            return (Criteria) this;
        }

        public Criteria andUnidNotBetween(String value1, String value2) {
            addCriterion("`trafficFace`.unid not between", value1, value2, "unid");
            return (Criteria) this;
        }

        public Criteria andTrafficIdIsNull() {
            addCriterion("`trafficFace`.traffic_id is null");
            return (Criteria) this;
        }

        public Criteria andTrafficIdIsNotNull() {
            addCriterion("`trafficFace`.traffic_id is not null");
            return (Criteria) this;
        }

        public Criteria andTrafficIdEqualTo(Long value) {
            addCriterion("`trafficFace`.traffic_id =", value, "trafficId");
            return (Criteria) this;
        }

        public Criteria andTrafficIdNotEqualTo(Long value) {
            addCriterion("`trafficFace`.traffic_id <>", value, "trafficId");
            return (Criteria) this;
        }

        public Criteria andTrafficIdGreaterThan(Long value) {
            addCriterion("`trafficFace`.traffic_id >", value, "trafficId");
            return (Criteria) this;
        }

        public Criteria andTrafficIdGreaterThanOrEqualTo(Long value) {
            addCriterion("`trafficFace`.traffic_id >=", value, "trafficId");
            return (Criteria) this;
        }

        public Criteria andTrafficIdLessThan(Long value) {
            addCriterion("`trafficFace`.traffic_id <", value, "trafficId");
            return (Criteria) this;
        }

        public Criteria andTrafficIdLessThanOrEqualTo(Long value) {
            addCriterion("`trafficFace`.traffic_id <=", value, "trafficId");
            return (Criteria) this;
        }

        public Criteria andTrafficIdIn(List<Long> values) {
            addCriterion("`trafficFace`.traffic_id in", values, "trafficId");
            return (Criteria) this;
        }

        public Criteria andTrafficIdNotIn(List<Long> values) {
            addCriterion("`trafficFace`.traffic_id not in", values, "trafficId");
            return (Criteria) this;
        }

        public Criteria andTrafficIdBetween(Long value1, Long value2) {
            addCriterion("`trafficFace`.traffic_id between", value1, value2, "trafficId");
            return (Criteria) this;
        }

        public Criteria andTrafficIdNotBetween(Long value1, Long value2) {
            addCriterion("`trafficFace`.traffic_id not between", value1, value2, "trafficId");
            return (Criteria) this;
        }

        public Criteria andStateIsNull() {
            addCriterion("`trafficFace`.`state` is null");
            return (Criteria) this;
        }

        public Criteria andStateIsNotNull() {
            addCriterion("`trafficFace`.`state` is not null");
            return (Criteria) this;
        }

        public Criteria andStateEqualTo(Short value) {
            addCriterion("`trafficFace`.`state` =", value, "state");
            return (Criteria) this;
        }

        public Criteria andStateNotEqualTo(Short value) {
            addCriterion("`trafficFace`.`state` <>", value, "state");
            return (Criteria) this;
        }

        public Criteria andStateGreaterThan(Short value) {
            addCriterion("`trafficFace`.`state` >", value, "state");
            return (Criteria) this;
        }

        public Criteria andStateGreaterThanOrEqualTo(Short value) {
            addCriterion("`trafficFace`.`state` >=", value, "state");
            return (Criteria) this;
        }

        public Criteria andStateLessThan(Short value) {
            addCriterion("`trafficFace`.`state` <", value, "state");
            return (Criteria) this;
        }

        public Criteria andStateLessThanOrEqualTo(Short value) {
            addCriterion("`trafficFace`.`state` <=", value, "state");
            return (Criteria) this;
        }

        public Criteria andStateIn(List<Short> values) {
            addCriterion("`trafficFace`.`state` in", values, "state");
            return (Criteria) this;
        }

        public Criteria andStateNotIn(List<Short> values) {
            addCriterion("`trafficFace`.`state` not in", values, "state");
            return (Criteria) this;
        }

        public Criteria andStateBetween(Short value1, Short value2) {
            addCriterion("`trafficFace`.`state` between", value1, value2, "state");
            return (Criteria) this;
        }

        public Criteria andStateNotBetween(Short value1, Short value2) {
            addCriterion("`trafficFace`.`state` not between", value1, value2, "state");
            return (Criteria) this;
        }

        public Criteria andSexIsNull() {
            addCriterion("`trafficFace`.sex is null");
            return (Criteria) this;
        }

        public Criteria andSexIsNotNull() {
            addCriterion("`trafficFace`.sex is not null");
            return (Criteria) this;
        }

        public Criteria andSexEqualTo(Short value) {
            addCriterion("`trafficFace`.sex =", value, "sex");
            return (Criteria) this;
        }

        public Criteria andSexNotEqualTo(Short value) {
            addCriterion("`trafficFace`.sex <>", value, "sex");
            return (Criteria) this;
        }

        public Criteria andSexGreaterThan(Short value) {
            addCriterion("`trafficFace`.sex >", value, "sex");
            return (Criteria) this;
        }

        public Criteria andSexGreaterThanOrEqualTo(Short value) {
            addCriterion("`trafficFace`.sex >=", value, "sex");
            return (Criteria) this;
        }

        public Criteria andSexLessThan(Short value) {
            addCriterion("`trafficFace`.sex <", value, "sex");
            return (Criteria) this;
        }

        public Criteria andSexLessThanOrEqualTo(Short value) {
            addCriterion("`trafficFace`.sex <=", value, "sex");
            return (Criteria) this;
        }

        public Criteria andSexIn(List<Short> values) {
            addCriterion("`trafficFace`.sex in", values, "sex");
            return (Criteria) this;
        }

        public Criteria andSexNotIn(List<Short> values) {
            addCriterion("`trafficFace`.sex not in", values, "sex");
            return (Criteria) this;
        }

        public Criteria andSexBetween(Short value1, Short value2) {
            addCriterion("`trafficFace`.sex between", value1, value2, "sex");
            return (Criteria) this;
        }

        public Criteria andSexNotBetween(Short value1, Short value2) {
            addCriterion("`trafficFace`.sex not between", value1, value2, "sex");
            return (Criteria) this;
        }

        public Criteria andUpperColorIsNull() {
            addCriterion("`trafficFace`.upper_color is null");
            return (Criteria) this;
        }

        public Criteria andUpperColorIsNotNull() {
            addCriterion("`trafficFace`.upper_color is not null");
            return (Criteria) this;
        }

        public Criteria andUpperColorEqualTo(String value) {
            addCriterion("`trafficFace`.upper_color =", value, "upperColor");
            return (Criteria) this;
        }

        public Criteria andUpperColorNotEqualTo(String value) {
            addCriterion("`trafficFace`.upper_color <>", value, "upperColor");
            return (Criteria) this;
        }

        public Criteria andUpperColorGreaterThan(String value) {
            addCriterion("`trafficFace`.upper_color >", value, "upperColor");
            return (Criteria) this;
        }

        public Criteria andUpperColorGreaterThanOrEqualTo(String value) {
            addCriterion("`trafficFace`.upper_color >=", value, "upperColor");
            return (Criteria) this;
        }

        public Criteria andUpperColorLessThan(String value) {
            addCriterion("`trafficFace`.upper_color <", value, "upperColor");
            return (Criteria) this;
        }

        public Criteria andUpperColorLessThanOrEqualTo(String value) {
            addCriterion("`trafficFace`.upper_color <=", value, "upperColor");
            return (Criteria) this;
        }

        public Criteria andUpperColorLike(String value) {
            addCriterion("`trafficFace`.upper_color like", value, "upperColor");
            return (Criteria) this;
        }

        public Criteria andUpperColorNotLike(String value) {
            addCriterion("`trafficFace`.upper_color not like", value, "upperColor");
            return (Criteria) this;
        }

        public Criteria andUpperColorIn(List<String> values) {
            addCriterion("`trafficFace`.upper_color in", values, "upperColor");
            return (Criteria) this;
        }

        public Criteria andUpperColorNotIn(List<String> values) {
            addCriterion("`trafficFace`.upper_color not in", values, "upperColor");
            return (Criteria) this;
        }

        public Criteria andUpperColorBetween(String value1, String value2) {
            addCriterion("`trafficFace`.upper_color between", value1, value2, "upperColor");
            return (Criteria) this;
        }

        public Criteria andUpperColorNotBetween(String value1, String value2) {
            addCriterion("`trafficFace`.upper_color not between", value1, value2, "upperColor");
            return (Criteria) this;
        }

        public Criteria andLowerColorIsNull() {
            addCriterion("`trafficFace`.lower_color is null");
            return (Criteria) this;
        }

        public Criteria andLowerColorIsNotNull() {
            addCriterion("`trafficFace`.lower_color is not null");
            return (Criteria) this;
        }

        public Criteria andLowerColorEqualTo(String value) {
            addCriterion("`trafficFace`.lower_color =", value, "lowerColor");
            return (Criteria) this;
        }

        public Criteria andLowerColorNotEqualTo(String value) {
            addCriterion("`trafficFace`.lower_color <>", value, "lowerColor");
            return (Criteria) this;
        }

        public Criteria andLowerColorGreaterThan(String value) {
            addCriterion("`trafficFace`.lower_color >", value, "lowerColor");
            return (Criteria) this;
        }

        public Criteria andLowerColorGreaterThanOrEqualTo(String value) {
            addCriterion("`trafficFace`.lower_color >=", value, "lowerColor");
            return (Criteria) this;
        }

        public Criteria andLowerColorLessThan(String value) {
            addCriterion("`trafficFace`.lower_color <", value, "lowerColor");
            return (Criteria) this;
        }

        public Criteria andLowerColorLessThanOrEqualTo(String value) {
            addCriterion("`trafficFace`.lower_color <=", value, "lowerColor");
            return (Criteria) this;
        }

        public Criteria andLowerColorLike(String value) {
            addCriterion("`trafficFace`.lower_color like", value, "lowerColor");
            return (Criteria) this;
        }

        public Criteria andLowerColorNotLike(String value) {
            addCriterion("`trafficFace`.lower_color not like", value, "lowerColor");
            return (Criteria) this;
        }

        public Criteria andLowerColorIn(List<String> values) {
            addCriterion("`trafficFace`.lower_color in", values, "lowerColor");
            return (Criteria) this;
        }

        public Criteria andLowerColorNotIn(List<String> values) {
            addCriterion("`trafficFace`.lower_color not in", values, "lowerColor");
            return (Criteria) this;
        }

        public Criteria andLowerColorBetween(String value1, String value2) {
            addCriterion("`trafficFace`.lower_color between", value1, value2, "lowerColor");
            return (Criteria) this;
        }

        public Criteria andLowerColorNotBetween(String value1, String value2) {
            addCriterion("`trafficFace`.lower_color not between", value1, value2, "lowerColor");
            return (Criteria) this;
        }
    }

    public static class ColumnContainer extends ColumnContainerBase {

        protected ColumnContainer(String tableName) {
            super(tableName);
        }

        public ColumnContainer hasIdColumn() {
            addColumnStr("`trafficFace`.id as trafficFace_id ");
            return (ColumnContainer) this;
        }

        public ColumnContainer hasEventTimeColumn() {
            addColumnStr("`trafficFace`.event_time as trafficFace_event_time ");
            return (ColumnContainer) this;
        }

        public ColumnContainer hasUnidColumn() {
            addColumnStr("`trafficFace`.unid as trafficFace_unid ");
            return (ColumnContainer) this;
        }

        public ColumnContainer hasTrafficIdColumn() {
            addColumnStr("`trafficFace`.traffic_id as trafficFace_traffic_id ");
            return (ColumnContainer) this;
        }

        public ColumnContainer hasStateColumn() {
            addColumnStr("`trafficFace`.`state` as `trafficFace_state` ");
            return (ColumnContainer) this;
        }

        public ColumnContainer hasSexColumn() {
            addColumnStr("`trafficFace`.sex as trafficFace_sex ");
            return (ColumnContainer) this;
        }

        public ColumnContainer hasUpperColorColumn() {
            addColumnStr("`trafficFace`.upper_color as trafficFace_upper_color ");
            return (ColumnContainer) this;
        }

        public ColumnContainer hasLowerColorColumn() {
            addColumnStr("`trafficFace`.lower_color as trafficFace_lower_color ");
            return (ColumnContainer) this;
        }
    }
}