adi-manager-server/modelsrc/com/miniframe/system/model/SysUserSQLBuilder.java

/*
*  Copyright 2010 The YAPULAN Software Foundation
*
*  Licensed under the YAPULAN License, Version 2.0 (the "License");
*/

package com.miniframe.system.model;

import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

/**
 * 用户表 : 用户表
 * @generated
 */
public class SysUserSQLBuilder {
    /**
     * 用户表 : 用户表
     * @generated
     */
    protected String orderByClause;

    /**
     * 用户表 : 用户表
     * @generated
     */
    protected boolean distinct;

    /**
     * 用户表 : 用户表
     * @generated
     */
    protected boolean NoWait;

    /**
     * 用户表 : 用户表
     * @generated
     */
    protected boolean forUpdate;

    /**
     * 用户表 : 用户表
     * @generated
     */
    protected List<Criteria> oredCriteria;

    /**
     * 用户表 : 用户表
     * @generated
     */
    private Integer oracleStart;

    /**
     * 用户表 : 用户表
     * @generated
     */
    private Integer oracleEnd;

    /**
     * 用户表 : 用户表
     * @generated
     */
    private Integer startOffSet;

    /**
     * 用户表 : 用户表
     * @generated
     */
    private Integer pageSize;

    /**
     * @generated
     */
    public SysUserSQLBuilder() {
        oredCriteria = new ArrayList<Criteria>();
    }

    /**
     * @generated
     */
    protected SysUserSQLBuilder(SysUserSQLBuilder example) {
        this.orderByClause = example.orderByClause;
        this.oredCriteria = example.oredCriteria;
        this.distinct = example.distinct;
        this.forUpdate = example.forUpdate;
        this.NoWait = example.NoWait;
    }

    /**
     * 设置排序
     * @generated
     */
    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    /**
     * 获取排序
     * @generated
     */
    public String getOrderByClause() {
        return orderByClause;
    }

    /**
     * 设置是否过滤重复
     * @generated
     */
    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    /**
     * 获取是否过滤重复
     * @generated
     */
    public boolean isDistinct() {
        return distinct;
    }

    /**
     * 设置是否上锁是否不等待
     * @generated
     */
    public void setNoWait(boolean NoWait) {
        this.NoWait = NoWait;
    }

    /**
     * 设置是否上锁是否不等待
     * @generated
     */
    public boolean isNoWait() {
        return NoWait;
    }

    /**
     * 设置是否行锁定
     * @generated
     */
    public void setForUpdate(boolean forUpdate) {
        this.forUpdate = forUpdate;
    }

    /**
     * 获取是否行锁定
     * @generated
     */
    public boolean isForUpdate() {
        return forUpdate;
    }

    /**
     * @generated
     */
    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    /**
     * @generated
     */
    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    /**
     * 或
     * @generated
     */
    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    /**
     * @generated
     */
    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    /**
     * @generated
     */
    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    /**
     * 清除
     * @generated
     */
    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
        forUpdate = false;
        NoWait = false;
    }

    /**
     * 设置开始行，从1开始
     * @generated
     */
    public void setOracleStart(Integer oracleStart) {
        this.oracleStart = oracleStart;
        this.startOffSet = this.oracleStart - 1;
        if(this.oracleEnd!=null){
            this.pageSize = this.oracleEnd - this.oracleStart + 1;
        }
    }

    /**
     * 获取开始行，从1开始
     * @generated
     */
    public Integer getOracleStart() {
        return oracleStart;
    }

    /**
     * 设置结束行
     * @generated
     */
    public void setOracleEnd(Integer oracleEnd) {
        if(this.oracleStart==null){
            	this.oracleStart =1;
            	this.startOffSet =0;
        }
        this.oracleEnd = oracleEnd;
        this.pageSize = this.oracleEnd - this.oracleStart + 1;
    }

    /**
     * 获取结束行
     * @generated
     */
    public Integer getOracleEnd() {
        return oracleEnd;
    }

    /**
     * 设置偏移量，从0开始
     * @generated
     */
    public void setStartOffSet(Integer startOffSet) {
        this.startOffSet = startOffSet;
        this.oracleStart = this.startOffSet + 1;
        if(this.pageSize!=null){
             this.oracleEnd = this.oracleStart - 1 + this.pageSize;
        }
    }

    /**
     * 获取偏移量，从0开始
     * @generated
     */
    public Integer getStartOffSet() {
        return startOffSet;
    }

    /**
     * 设置页尺寸
     * @generated
     */
    public void setPageSize(Integer pageSize) {
        if(this.oracleStart==null){
            	this.oracleStart =1;
            	this.startOffSet =0;
        }
        this.pageSize = pageSize;
        this.oracleEnd = this.pageSize + this.oracleStart - 1;
    }

    /**
     * 获取页尺寸
     * @generated
     */
    public Integer getPageSize() {
        return pageSize;
    }

    /**
     * 用户表 : 用户表
     * @generated
     */
    protected abstract static class GeneratedCriteria {
        /**
         * 用户表 : 用户表
         * @generated
         */
        protected List<String> criteriaWithoutValue;

        /**
         * 用户表 : 用户表
         * @generated
         */
        protected List<Map<String, Object>> criteriaWithSingleValue;

        /**
         * 用户表 : 用户表
         * @generated
         */
        protected List<Map<String, Object>> criteriaWithListValue;

        /**
         * 用户表 : 用户表
         * @generated
         */
        protected List<Map<String, Object>> criteriaWithBetweenValue;

        /**
         * @generated
         */
        protected GeneratedCriteria() {
            super();
            criteriaWithoutValue = new ArrayList<String>();
            criteriaWithSingleValue = new ArrayList<Map<String, Object>>();
            criteriaWithListValue = new ArrayList<Map<String, Object>>();
            criteriaWithBetweenValue = new ArrayList<Map<String, Object>>();
        }

        /**
         * 验证
         * @generated
         */
        public boolean isValid() {
            return criteriaWithoutValue.size() > 0
                || criteriaWithSingleValue.size() > 0
                || criteriaWithListValue.size() > 0
                || criteriaWithBetweenValue.size() > 0;
        }

        /**
         * @generated
         */
        public List<String> getCriteriaWithoutValue() {
            return criteriaWithoutValue;
        }

        /**
         * @generated
         */
        public void setCriteriaWithoutValue(List<String> criteriaWithoutValue) {
            this.criteriaWithoutValue = criteriaWithoutValue;
        }

        /**
         * @generated
         */
        public List<Map<String, Object>> getCriteriaWithSingleValue() {
            return criteriaWithSingleValue;
        }

        /**
         * @generated
         */
        public void setCriteriaWithSingleValue(List<Map<String, Object>> criteriaWithSingleValue) {
            this.criteriaWithSingleValue = criteriaWithSingleValue;
        }

        /**
         * @generated
         */
        public List<Map<String, Object>> getCriteriaWithListValue() {
            return criteriaWithListValue;
        }

        /**
         * @generated
         */
        public void setCriteriaWithListValue(List<Map<String, Object>> criteriaWithListValue) {
            this.criteriaWithListValue = criteriaWithListValue;
        }

        /**
         * @generated
         */
        public List<Map<String, Object>> getCriteriaWithBetweenValue() {
            return criteriaWithBetweenValue;
        }

        /**
         * @generated
         */
        public void setCriteriaWithBetweenValue(List<Map<String, Object>> criteriaWithBetweenValue) {
            this.criteriaWithBetweenValue = criteriaWithBetweenValue;
        }

        /**
         * @generated
         */
        public void whereSQL(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteriaWithoutValue.add(condition);
        }

        /**
         * @generated
         */
        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteriaWithoutValue.add(condition);
        }

        /**
         * @generated
         */
        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            Map<String, Object> map = new HashMap<String, Object>();
            map.put("condition", condition);
            map.put("value", value);
            criteriaWithSingleValue.add(map);
        }

        /**
         * @generated
         */
        protected void addCriterion(String condition, List<? extends Object> values, String property) {
            if (values == null || values.size() == 0) {
                throw new RuntimeException("Value list for " + property + " cannot be null or empty");
            }
            Map<String, Object> map = new HashMap<String, Object>();
            map.put("condition", condition);
            map.put("values", values);
            criteriaWithListValue.add(map);
        }

        /**
         * @generated
         */
        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");
            }
            List<Object> list = new ArrayList<Object>();
            list.add(value1);
            list.add(value2);
            Map<String, Object> map = new HashMap<String, Object>();
            map.put("condition", condition);
            map.put("values", list);
            criteriaWithBetweenValue.add(map);
        }

        /**
         * @generated
         */
        public Criteria andUseridIsNull() {
            addCriterion("userid is null");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUseridIsNotNull() {
            addCriterion("userid <> ''");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUseridEqualTo(String value) {
            addCriterion("userid =", value, "userid");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUseridNotEqualTo(String value) {
            addCriterion("userid <>", value, "userid");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUseridGreaterThan(String value) {
            addCriterion("userid >", value, "userid");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUseridGreaterThanOrEqualTo(String value) {
            addCriterion("userid >=", value, "userid");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUseridLessThan(String value) {
            addCriterion("userid <", value, "userid");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUseridLessThanOrEqualTo(String value) {
            addCriterion("userid <=", value, "userid");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUseridLike(String value) {
            addCriterion("userid like", value, "userid");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUseridNotLike(String value) {
            addCriterion("userid not like", value, "userid");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUseridIn(List<String> values) {
            addCriterion("userid in", values, "userid");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUseridNotIn(List<String> values) {
            addCriterion("userid not in", values, "userid");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUseridBetween(String value1, String value2) {
            addCriterion("userid between", value1, value2, "userid");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUseridNotBetween(String value1, String value2) {
            addCriterion("userid not between", value1, value2, "userid");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUsertypeIsNull() {
            addCriterion("usertype is null");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUsertypeIsNotNull() {
            addCriterion("usertype <> ''");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUsertypeEqualTo(Integer value) {
            addCriterion("usertype =", value, "usertype");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUsertypeNotEqualTo(Integer value) {
            addCriterion("usertype <>", value, "usertype");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUsertypeGreaterThan(Integer value) {
            addCriterion("usertype >", value, "usertype");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUsertypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("usertype >=", value, "usertype");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUsertypeLessThan(Integer value) {
            addCriterion("usertype <", value, "usertype");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUsertypeLessThanOrEqualTo(Integer value) {
            addCriterion("usertype <=", value, "usertype");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUsertypeIn(List<Integer> values) {
            addCriterion("usertype in", values, "usertype");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUsertypeNotIn(List<Integer> values) {
            addCriterion("usertype not in", values, "usertype");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUsertypeBetween(Integer value1, Integer value2) {
            addCriterion("usertype between", value1, value2, "usertype");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUsertypeNotBetween(Integer value1, Integer value2) {
            addCriterion("usertype not between", value1, value2, "usertype");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andOrgnameIsNull() {
            addCriterion("orgname is null");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andOrgnameIsNotNull() {
            addCriterion("orgname <> ''");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andOrgnameEqualTo(String value) {
            addCriterion("orgname =", value, "orgname");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andOrgnameNotEqualTo(String value) {
            addCriterion("orgname <>", value, "orgname");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andOrgnameGreaterThan(String value) {
            addCriterion("orgname >", value, "orgname");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andOrgnameGreaterThanOrEqualTo(String value) {
            addCriterion("orgname >=", value, "orgname");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andOrgnameLessThan(String value) {
            addCriterion("orgname <", value, "orgname");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andOrgnameLessThanOrEqualTo(String value) {
            addCriterion("orgname <=", value, "orgname");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andOrgnameLike(String value) {
            addCriterion("orgname like", value, "orgname");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andOrgnameNotLike(String value) {
            addCriterion("orgname not like", value, "orgname");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andOrgnameIn(List<String> values) {
            addCriterion("orgname in", values, "orgname");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andOrgnameNotIn(List<String> values) {
            addCriterion("orgname not in", values, "orgname");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andOrgnameBetween(String value1, String value2) {
            addCriterion("orgname between", value1, value2, "orgname");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andOrgnameNotBetween(String value1, String value2) {
            addCriterion("orgname not between", value1, value2, "orgname");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUserstateIsNull() {
            addCriterion("userstate is null");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUserstateIsNotNull() {
            addCriterion("userstate <> ''");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUserstateEqualTo(Integer value) {
            addCriterion("userstate =", value, "userstate");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUserstateNotEqualTo(Integer value) {
            addCriterion("userstate <>", value, "userstate");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUserstateGreaterThan(Integer value) {
            addCriterion("userstate >", value, "userstate");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUserstateGreaterThanOrEqualTo(Integer value) {
            addCriterion("userstate >=", value, "userstate");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUserstateLessThan(Integer value) {
            addCriterion("userstate <", value, "userstate");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUserstateLessThanOrEqualTo(Integer value) {
            addCriterion("userstate <=", value, "userstate");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUserstateIn(List<Integer> values) {
            addCriterion("userstate in", values, "userstate");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUserstateNotIn(List<Integer> values) {
            addCriterion("userstate not in", values, "userstate");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUserstateBetween(Integer value1, Integer value2) {
            addCriterion("userstate between", value1, value2, "userstate");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUserstateNotBetween(Integer value1, Integer value2) {
            addCriterion("userstate not between", value1, value2, "userstate");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUserpwdIsNull() {
            addCriterion("userpwd is null");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUserpwdIsNotNull() {
            addCriterion("userpwd <> ''");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUserpwdEqualTo(String value) {
            addCriterion("userpwd =", value, "userpwd");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUserpwdNotEqualTo(String value) {
            addCriterion("userpwd <>", value, "userpwd");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUserpwdGreaterThan(String value) {
            addCriterion("userpwd >", value, "userpwd");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUserpwdGreaterThanOrEqualTo(String value) {
            addCriterion("userpwd >=", value, "userpwd");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUserpwdLessThan(String value) {
            addCriterion("userpwd <", value, "userpwd");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUserpwdLessThanOrEqualTo(String value) {
            addCriterion("userpwd <=", value, "userpwd");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUserpwdLike(String value) {
            addCriterion("userpwd like", value, "userpwd");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUserpwdNotLike(String value) {
            addCriterion("userpwd not like", value, "userpwd");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUserpwdIn(List<String> values) {
            addCriterion("userpwd in", values, "userpwd");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUserpwdNotIn(List<String> values) {
            addCriterion("userpwd not in", values, "userpwd");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUserpwdBetween(String value1, String value2) {
            addCriterion("userpwd between", value1, value2, "userpwd");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUserpwdNotBetween(String value1, String value2) {
            addCriterion("userpwd not between", value1, value2, "userpwd");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUsernameIsNull() {
            addCriterion("username is null");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUsernameIsNotNull() {
            addCriterion("username <> ''");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUsernameEqualTo(String value) {
            addCriterion("username =", value, "username");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUsernameNotEqualTo(String value) {
            addCriterion("username <>", value, "username");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUsernameGreaterThan(String value) {
            addCriterion("username >", value, "username");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUsernameGreaterThanOrEqualTo(String value) {
            addCriterion("username >=", value, "username");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUsernameLessThan(String value) {
            addCriterion("username <", value, "username");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUsernameLessThanOrEqualTo(String value) {
            addCriterion("username <=", value, "username");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUsernameLike(String value) {
            addCriterion("username like", value, "username");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUsernameNotLike(String value) {
            addCriterion("username not like", value, "username");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUsernameIn(List<String> values) {
            addCriterion("username in", values, "username");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUsernameNotIn(List<String> values) {
            addCriterion("username not in", values, "username");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUsernameBetween(String value1, String value2) {
            addCriterion("username between", value1, value2, "username");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUsernameNotBetween(String value1, String value2) {
            addCriterion("username not between", value1, value2, "username");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUserdnIsNull() {
            addCriterion("userdn is null");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUserdnIsNotNull() {
            addCriterion("userdn <> ''");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUserdnEqualTo(String value) {
            addCriterion("userdn =", value, "userdn");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUserdnNotEqualTo(String value) {
            addCriterion("userdn <>", value, "userdn");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUserdnGreaterThan(String value) {
            addCriterion("userdn >", value, "userdn");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUserdnGreaterThanOrEqualTo(String value) {
            addCriterion("userdn >=", value, "userdn");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUserdnLessThan(String value) {
            addCriterion("userdn <", value, "userdn");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUserdnLessThanOrEqualTo(String value) {
            addCriterion("userdn <=", value, "userdn");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUserdnLike(String value) {
            addCriterion("userdn like", value, "userdn");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUserdnNotLike(String value) {
            addCriterion("userdn not like", value, "userdn");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUserdnIn(List<String> values) {
            addCriterion("userdn in", values, "userdn");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUserdnNotIn(List<String> values) {
            addCriterion("userdn not in", values, "userdn");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUserdnBetween(String value1, String value2) {
            addCriterion("userdn between", value1, value2, "userdn");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUserdnNotBetween(String value1, String value2) {
            addCriterion("userdn not between", value1, value2, "userdn");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUserdnflagIsNull() {
            addCriterion("userdnflag is null");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUserdnflagIsNotNull() {
            addCriterion("userdnflag <> ''");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUserdnflagEqualTo(Integer value) {
            addCriterion("userdnflag =", value, "userdnflag");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUserdnflagNotEqualTo(Integer value) {
            addCriterion("userdnflag <>", value, "userdnflag");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUserdnflagGreaterThan(Integer value) {
            addCriterion("userdnflag >", value, "userdnflag");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUserdnflagGreaterThanOrEqualTo(Integer value) {
            addCriterion("userdnflag >=", value, "userdnflag");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUserdnflagLessThan(Integer value) {
            addCriterion("userdnflag <", value, "userdnflag");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUserdnflagLessThanOrEqualTo(Integer value) {
            addCriterion("userdnflag <=", value, "userdnflag");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUserdnflagIn(List<Integer> values) {
            addCriterion("userdnflag in", values, "userdnflag");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUserdnflagNotIn(List<Integer> values) {
            addCriterion("userdnflag not in", values, "userdnflag");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUserdnflagBetween(Integer value1, Integer value2) {
            addCriterion("userdnflag between", value1, value2, "userdnflag");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUserdnflagNotBetween(Integer value1, Integer value2) {
            addCriterion("userdnflag not between", value1, value2, "userdnflag");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andNicknameIsNull() {
            addCriterion("nickname is null");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andNicknameIsNotNull() {
            addCriterion("nickname <> ''");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andNicknameEqualTo(String value) {
            addCriterion("nickname =", value, "nickname");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andNicknameNotEqualTo(String value) {
            addCriterion("nickname <>", value, "nickname");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andNicknameGreaterThan(String value) {
            addCriterion("nickname >", value, "nickname");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andNicknameGreaterThanOrEqualTo(String value) {
            addCriterion("nickname >=", value, "nickname");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andNicknameLessThan(String value) {
            addCriterion("nickname <", value, "nickname");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andNicknameLessThanOrEqualTo(String value) {
            addCriterion("nickname <=", value, "nickname");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andNicknameLike(String value) {
            addCriterion("nickname like", value, "nickname");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andNicknameNotLike(String value) {
            addCriterion("nickname not like", value, "nickname");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andNicknameIn(List<String> values) {
            addCriterion("nickname in", values, "nickname");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andNicknameNotIn(List<String> values) {
            addCriterion("nickname not in", values, "nickname");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andNicknameBetween(String value1, String value2) {
            addCriterion("nickname between", value1, value2, "nickname");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andNicknameNotBetween(String value1, String value2) {
            addCriterion("nickname not between", value1, value2, "nickname");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUsersexIsNull() {
            addCriterion("usersex is null");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUsersexIsNotNull() {
            addCriterion("usersex <> ''");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUsersexEqualTo(Integer value) {
            addCriterion("usersex =", value, "usersex");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUsersexNotEqualTo(Integer value) {
            addCriterion("usersex <>", value, "usersex");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUsersexGreaterThan(Integer value) {
            addCriterion("usersex >", value, "usersex");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUsersexGreaterThanOrEqualTo(Integer value) {
            addCriterion("usersex >=", value, "usersex");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUsersexLessThan(Integer value) {
            addCriterion("usersex <", value, "usersex");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUsersexLessThanOrEqualTo(Integer value) {
            addCriterion("usersex <=", value, "usersex");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUsersexIn(List<Integer> values) {
            addCriterion("usersex in", values, "usersex");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUsersexNotIn(List<Integer> values) {
            addCriterion("usersex not in", values, "usersex");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUsersexBetween(Integer value1, Integer value2) {
            addCriterion("usersex between", value1, value2, "usersex");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUsersexNotBetween(Integer value1, Integer value2) {
            addCriterion("usersex not between", value1, value2, "usersex");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUseremailIsNull() {
            addCriterion("useremail is null");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUseremailIsNotNull() {
            addCriterion("useremail <> ''");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUseremailEqualTo(String value) {
            addCriterion("useremail =", value, "useremail");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUseremailNotEqualTo(String value) {
            addCriterion("useremail <>", value, "useremail");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUseremailGreaterThan(String value) {
            addCriterion("useremail >", value, "useremail");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUseremailGreaterThanOrEqualTo(String value) {
            addCriterion("useremail >=", value, "useremail");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUseremailLessThan(String value) {
            addCriterion("useremail <", value, "useremail");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUseremailLessThanOrEqualTo(String value) {
            addCriterion("useremail <=", value, "useremail");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUseremailLike(String value) {
            addCriterion("useremail like", value, "useremail");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUseremailNotLike(String value) {
            addCriterion("useremail not like", value, "useremail");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUseremailIn(List<String> values) {
            addCriterion("useremail in", values, "useremail");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUseremailNotIn(List<String> values) {
            addCriterion("useremail not in", values, "useremail");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUseremailBetween(String value1, String value2) {
            addCriterion("useremail between", value1, value2, "useremail");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUseremailNotBetween(String value1, String value2) {
            addCriterion("useremail not between", value1, value2, "useremail");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUsertelnumIsNull() {
            addCriterion("usertelnum is null");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUsertelnumIsNotNull() {
            addCriterion("usertelnum <> ''");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUsertelnumEqualTo(String value) {
            addCriterion("usertelnum =", value, "usertelnum");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUsertelnumNotEqualTo(String value) {
            addCriterion("usertelnum <>", value, "usertelnum");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUsertelnumGreaterThan(String value) {
            addCriterion("usertelnum >", value, "usertelnum");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUsertelnumGreaterThanOrEqualTo(String value) {
            addCriterion("usertelnum >=", value, "usertelnum");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUsertelnumLessThan(String value) {
            addCriterion("usertelnum <", value, "usertelnum");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUsertelnumLessThanOrEqualTo(String value) {
            addCriterion("usertelnum <=", value, "usertelnum");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUsertelnumLike(String value) {
            addCriterion("usertelnum like", value, "usertelnum");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUsertelnumNotLike(String value) {
            addCriterion("usertelnum not like", value, "usertelnum");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUsertelnumIn(List<String> values) {
            addCriterion("usertelnum in", values, "usertelnum");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUsertelnumNotIn(List<String> values) {
            addCriterion("usertelnum not in", values, "usertelnum");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUsertelnumBetween(String value1, String value2) {
            addCriterion("usertelnum between", value1, value2, "usertelnum");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUsertelnumNotBetween(String value1, String value2) {
            addCriterion("usertelnum not between", value1, value2, "usertelnum");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUsermobnubIsNull() {
            addCriterion("usermobnub is null");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUsermobnubIsNotNull() {
            addCriterion("usermobnub <> ''");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUsermobnubEqualTo(String value) {
            addCriterion("usermobnub =", value, "usermobnub");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUsermobnubNotEqualTo(String value) {
            addCriterion("usermobnub <>", value, "usermobnub");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUsermobnubGreaterThan(String value) {
            addCriterion("usermobnub >", value, "usermobnub");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUsermobnubGreaterThanOrEqualTo(String value) {
            addCriterion("usermobnub >=", value, "usermobnub");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUsermobnubLessThan(String value) {
            addCriterion("usermobnub <", value, "usermobnub");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUsermobnubLessThanOrEqualTo(String value) {
            addCriterion("usermobnub <=", value, "usermobnub");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUsermobnubLike(String value) {
            addCriterion("usermobnub like", value, "usermobnub");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUsermobnubNotLike(String value) {
            addCriterion("usermobnub not like", value, "usermobnub");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUsermobnubIn(List<String> values) {
            addCriterion("usermobnub in", values, "usermobnub");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUsermobnubNotIn(List<String> values) {
            addCriterion("usermobnub not in", values, "usermobnub");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUsermobnubBetween(String value1, String value2) {
            addCriterion("usermobnub between", value1, value2, "usermobnub");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUsermobnubNotBetween(String value1, String value2) {
            addCriterion("usermobnub not between", value1, value2, "usermobnub");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andRoleidsIsNull() {
            addCriterion("roleids is null");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andRoleidsIsNotNull() {
            addCriterion("roleids <> ''");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andRoleidsEqualTo(String value) {
            addCriterion("roleids =", value, "roleids");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andRoleidsNotEqualTo(String value) {
            addCriterion("roleids <>", value, "roleids");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andRoleidsGreaterThan(String value) {
            addCriterion("roleids >", value, "roleids");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andRoleidsGreaterThanOrEqualTo(String value) {
            addCriterion("roleids >=", value, "roleids");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andRoleidsLessThan(String value) {
            addCriterion("roleids <", value, "roleids");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andRoleidsLessThanOrEqualTo(String value) {
            addCriterion("roleids <=", value, "roleids");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andRoleidsLike(String value) {
            addCriterion("roleids like", value, "roleids");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andRoleidsNotLike(String value) {
            addCriterion("roleids not like", value, "roleids");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andRoleidsIn(List<String> values) {
            addCriterion("roleids in", values, "roleids");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andRoleidsNotIn(List<String> values) {
            addCriterion("roleids not in", values, "roleids");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andRoleidsBetween(String value1, String value2) {
            addCriterion("roleids between", value1, value2, "roleids");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andRoleidsNotBetween(String value1, String value2) {
            addCriterion("roleids not between", value1, value2, "roleids");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andStylenameIsNull() {
            addCriterion("stylename is null");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andStylenameIsNotNull() {
            addCriterion("stylename <> ''");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andStylenameEqualTo(String value) {
            addCriterion("stylename =", value, "stylename");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andStylenameNotEqualTo(String value) {
            addCriterion("stylename <>", value, "stylename");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andStylenameGreaterThan(String value) {
            addCriterion("stylename >", value, "stylename");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andStylenameGreaterThanOrEqualTo(String value) {
            addCriterion("stylename >=", value, "stylename");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andStylenameLessThan(String value) {
            addCriterion("stylename <", value, "stylename");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andStylenameLessThanOrEqualTo(String value) {
            addCriterion("stylename <=", value, "stylename");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andStylenameLike(String value) {
            addCriterion("stylename like", value, "stylename");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andStylenameNotLike(String value) {
            addCriterion("stylename not like", value, "stylename");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andStylenameIn(List<String> values) {
            addCriterion("stylename in", values, "stylename");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andStylenameNotIn(List<String> values) {
            addCriterion("stylename not in", values, "stylename");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andStylenameBetween(String value1, String value2) {
            addCriterion("stylename between", value1, value2, "stylename");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andStylenameNotBetween(String value1, String value2) {
            addCriterion("stylename not between", value1, value2, "stylename");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUserdescIsNull() {
            addCriterion("userdesc is null");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUserdescIsNotNull() {
            addCriterion("userdesc <> ''");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUserdescEqualTo(String value) {
            addCriterion("userdesc =", value, "userdesc");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUserdescNotEqualTo(String value) {
            addCriterion("userdesc <>", value, "userdesc");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUserdescGreaterThan(String value) {
            addCriterion("userdesc >", value, "userdesc");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUserdescGreaterThanOrEqualTo(String value) {
            addCriterion("userdesc >=", value, "userdesc");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUserdescLessThan(String value) {
            addCriterion("userdesc <", value, "userdesc");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUserdescLessThanOrEqualTo(String value) {
            addCriterion("userdesc <=", value, "userdesc");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUserdescLike(String value) {
            addCriterion("userdesc like", value, "userdesc");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUserdescNotLike(String value) {
            addCriterion("userdesc not like", value, "userdesc");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUserdescIn(List<String> values) {
            addCriterion("userdesc in", values, "userdesc");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUserdescNotIn(List<String> values) {
            addCriterion("userdesc not in", values, "userdesc");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUserdescBetween(String value1, String value2) {
            addCriterion("userdesc between", value1, value2, "userdesc");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andUserdescNotBetween(String value1, String value2) {
            addCriterion("userdesc not between", value1, value2, "userdesc");
            return (Criteria) this;
        }
    }

    /**
     * 用户表 : 用户表
     * @generated
     */
    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }
}