MyBatis中mybatis-generator代码生成的一般过程

MyBatis框架的使用，可以参考我的文章：

https://blog.csdn.net/JayInnn/article/details/81746571（基于Mybatis实现一个查库的接口）

https://blog.csdn.net/JayInnn/article/details/81773073（mapper接口文件以及selectByExample类的实例函数详解）

 

为了深入的去了解MyBatis框架如何实现接口服务与数据库的交互，我们如果能够自己配置一下数据库XML配置文件就会对这个过程有深入的理解。配置好XML配置文件，然后根据mybatis-generator自动生成相应的entity层，Mapper层，service层，这样我们就能够去查询数据库了，而不再关注具体的SQL语句查询过程了。

那么最主要的是XML配置文件，一下主要分为两个部分：实际应用过程中，mybatis-generator的使用，配置文件的详细内容。

（一）配置文件的详细内容

关于配置文件XML里面的参数以及结构最好可以参考官网资料，为了更简单的去理解，可以参考这篇文章：

https://blog.csdn.net/xp_lx1/article/details/80074738（generatorConfig.xml配置信息详细）

如果在看的过程中，感觉知识点很多很杂，可以先看第二部分，然后对照着去理解配置文件

 

（二）实际应用过程中，mybatis-generator的使用

实际工程中的文件结构如下：

现在给出generatorConfig_restaturant.xml的详细代码：

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE generatorConfiguration
        PUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN"
        "http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd">
<generatorConfiguration>
 
    <context id="Mysql" targetRuntime="MyBatis3" defaultModelType="conditional">
 
        <property name="autoDelimitKeywords" value="true"/>
        <property name="beginningDelimiter" value="`"/>
        <property name="endingDelimiter" value="`"/>
 
        <plugin type="tk.mybatis.mapper.generator.MapperPlugin">
            <property name="mappers" value="tk.mybatis.mapper.common.Mapper"/>
        </plugin>
 
        <jdbcConnection driverClass="com.mysql.jdbc.Driver"
                        connectionURL="jdbc:mysql://远程IP地址:3306/restaurant?useUnicode=true&amp;zeroDateTimeBehavior=convertToNull&amp;tinyInt1isBit=false"
                        userId="****"
                        password="*****">
        </jdbcConnection>
 
        <javaModelGenerator targetPackage="test.cn.mwee.service.entity.restaurant"
                            targetProject="../test/java/"/>
 
        <sqlMapGenerator targetPackage="mybatis"
                         targetProject="../test/resources/"/>
 
        <javaClientGenerator targetPackage="test.cn.mwee.service.shop.mapper.restaurant"
                             targetProject="../test/java/"
                             type="XMLMAPPER"/>
 
        <table tableName="shop_licence_table" domainObjectName="ShopLicenceEntity"
               enableCountByExample="true"
               enableUpdateByExample="false"
               enableDeleteByExample="false"
               enableSelectByExample="false"
               selectByExampleQueryId="false">
            <generatedKey column="shop_id" sqlStatement="MYSQL" identity="true"/>
        </table>
 
    </context>
</generatorConfiguration>

运行脚本文件，Windows下运行gen.bat，Linux环境下运行gen.sh

 运行结果：可以参考配置文件的内容理解

然后将相应的文件放置到对应的目录下，再对Mapper接口写一个实现类，那么就可以对数据库进行访问了。

相应的文件内容：

ShopLicenceEntity类：

package test.cn.mwee.service.entity.restaurant;
 
import java.util.Date;
import javax.persistence.*;
 
@Table(name = "shop_licence_table")
public class ShopLicenceEntity {
    /**
     * 商店id
     */
    @Id
    @Column(name = "shop_id")
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Integer shopId;
 
    /**
     * 总店ID
     */
    @Column(name = "manage_shop_id")
    private Integer manageShopId;
 
    /**
     * 营业执照名称
     */
    @Column(name = "business_licence_name")
    private String businessLicenceName;
 
    /**
     * 营业执照号码
     */
    @Column(name = "business_licence_number")
    private String businessLicenceNumber;
 
    /**
     * 营业执照正面图片
     */
    @Column(name = "business_licence_front")
    private String businessLicenceFront;
 
    /**
     * 法人姓名
     */
    @Column(name = "artificial_person_name")
    private String artificialPersonName;
 
    /**
     * 法人证件类型，1身份证，2护照
     */
    @Column(name = "artificial_credential_type")
    private Byte artificialCredentialType;
 
    /**
     * 法人证件id
     */
    @Column(name = "artificial_credential_id")
    private String artificialCredentialId;
 
    /**
     * 法人联系电话
     */
    @Column(name = "artificial_phone")
    private String artificialPhone;
 
    /**
     * 法人证件照正面
     */
    @Column(name = "artificial_credential_front")
    private String artificialCredentialFront;
 
    /**
     * 法人证件照反面
     */
    @Column(name = "artificial_credential_back")
    private String artificialCredentialBack;
 
    /**
     * 门店负责人
     */
    @Column(name = "responsible_people")
    private String responsiblePeople;
 
    /**
     * 负责人证件类型，1身份证，2护照
     */
    @Column(name = "responsible_credential_type")
    private Byte responsibleCredentialType;
 
    /**
     * 负责人证件id
     */
    @Column(name = "responsible_credential_id")
    private String responsibleCredentialId;
 
    /**
     * 负责人邮箱
     */
    @Column(name = "responsible_email")
    private String responsibleEmail;
 
    /**
     * 负责人联系电话
     */
    @Column(name = "responsible_phone")
    private String responsiblePhone;
 
    /**
     * 最后更新时间
     */
    @Column(name = "update_time")
    private Date updateTime;
 
    /**
     * 开户类型，1个体户，2企业
     */
    @Column(name = "accountType")
    private Byte accounttype;
 
    /**
     * 开户许可证图片正面照
     */
    @Column(name = "accountPermissionFront")
    private String accountpermissionfront;
 
    /**
     * 客服电话
     */
    @Column(name = "servicePhone")
    private String servicephone;
 
    /**
     * 结算账户类型1对公，2：对私
     */
    @Column(name = "checkAccountType")
    private Byte checkaccounttype;
 
    /**
     * 结算账户指令书,非法人结算进件
     */
    @Column(name = "checkAccountCode")
    private String checkaccountcode;
 
    /**
     * 组织结构
     */
    @Column(name = "cert_org_code")
    private String certOrgCode;
 
    /**
     * 组织结构代码证
     */
    @Column(name = "prg_photo")
    private String prgPhoto;
 
    /**
     * 类目ID
     */
    private String mcc;
 
    /**
     * 经营类型
     */
    @Column(name = "deal_type")
    private Byte dealType;
 
    /**
     * 获取商店id
     *
     * @return shop_id - 商店id
     */
    public Integer getShopId() {
        return shopId;
    }
 
    /**
     * 设置商店id
     *
     * @param shopId 商店id
     */
    public void setShopId(Integer shopId) {
        this.shopId = shopId;
    }
 
    /**
     * 获取总店ID
     *
     * @return manage_shop_id - 总店ID
     */
    public Integer getManageShopId() {
        return manageShopId;
    }
 
    /**
     * 设置总店ID
     *
     * @param manageShopId 总店ID
     */
    public void setManageShopId(Integer manageShopId) {
        this.manageShopId = manageShopId;
    }
 
    /**
     * 获取营业执照名称
     *
     * @return business_licence_name - 营业执照名称
     */
    public String getBusinessLicenceName() {
        return businessLicenceName;
    }
 
    /**
     * 设置营业执照名称
     *
     * @param businessLicenceName 营业执照名称
     */
    public void setBusinessLicenceName(String businessLicenceName) {
        this.businessLicenceName = businessLicenceName;
    }
 
    /**
     * 获取营业执照号码
     *
     * @return business_licence_number - 营业执照号码
     */
    public String getBusinessLicenceNumber() {
        return businessLicenceNumber;
    }
 
    /**
     * 设置营业执照号码
     *
     * @param businessLicenceNumber 营业执照号码
     */
    public void setBusinessLicenceNumber(String businessLicenceNumber) {
        this.businessLicenceNumber = businessLicenceNumber;
    }
 
    /**
     * 获取营业执照正面图片
     *
     * @return business_licence_front - 营业执照正面图片
     */
    public String getBusinessLicenceFront() {
        return businessLicenceFront;
    }
 
    /**
     * 设置营业执照正面图片
     *
     * @param businessLicenceFront 营业执照正面图片
     */
    public void setBusinessLicenceFront(String businessLicenceFront) {
        this.businessLicenceFront = businessLicenceFront;
    }
 
    /**
     * 获取法人姓名
     *
     * @return artificial_person_name - 法人姓名
     */
    public String getArtificialPersonName() {
        return artificialPersonName;
    }
 
    /**
     * 设置法人姓名
     *
     * @param artificialPersonName 法人姓名
     */
    public void setArtificialPersonName(String artificialPersonName) {
        this.artificialPersonName = artificialPersonName;
    }
 
    /**
     * 获取法人证件类型，1身份证，2护照
     *
     * @return artificial_credential_type - 法人证件类型，1身份证，2护照
     */
    public Byte getArtificialCredentialType() {
        return artificialCredentialType;
    }
 
    /**
     * 设置法人证件类型，1身份证，2护照
     *
     * @param artificialCredentialType 法人证件类型，1身份证，2护照
     */
    public void setArtificialCredentialType(Byte artificialCredentialType) {
        this.artificialCredentialType = artificialCredentialType;
    }
 
    /**
     * 获取法人证件id
     *
     * @return artificial_credential_id - 法人证件id
     */
    public String getArtificialCredentialId() {
        return artificialCredentialId;
    }
 
    /**
     * 设置法人证件id
     *
     * @param artificialCredentialId 法人证件id
     */
    public void setArtificialCredentialId(String artificialCredentialId) {
        this.artificialCredentialId = artificialCredentialId;
    }
 
    /**
     * 获取法人联系电话
     *
     * @return artificial_phone - 法人联系电话
     */
    public String getArtificialPhone() {
        return artificialPhone;
    }
 
    /**
     * 设置法人联系电话
     *
     * @param artificialPhone 法人联系电话
     */
    public void setArtificialPhone(String artificialPhone) {
        this.artificialPhone = artificialPhone;
    }
 
    /**
     * 获取法人证件照正面
     *
     * @return artificial_credential_front - 法人证件照正面
     */
    public String getArtificialCredentialFront() {
        return artificialCredentialFront;
    }
 
    /**
     * 设置法人证件照正面
     *
     * @param artificialCredentialFront 法人证件照正面
     */
    public void setArtificialCredentialFront(String artificialCredentialFront) {
        this.artificialCredentialFront = artificialCredentialFront;
    }
 
    /**
     * 获取法人证件照反面
     *
     * @return artificial_credential_back - 法人证件照反面
     */
    public String getArtificialCredentialBack() {
        return artificialCredentialBack;
    }
 
    /**
     * 设置法人证件照反面
     *
     * @param artificialCredentialBack 法人证件照反面
     */
    public void setArtificialCredentialBack(String artificialCredentialBack) {
        this.artificialCredentialBack = artificialCredentialBack;
    }
 
    /**
     * 获取门店负责人
     *
     * @return responsible_people - 门店负责人
     */
    public String getResponsiblePeople() {
        return responsiblePeople;
    }
 
    /**
     * 设置门店负责人
     *
     * @param responsiblePeople 门店负责人
     */
    public void setResponsiblePeople(String responsiblePeople) {
        this.responsiblePeople = responsiblePeople;
    }
 
    /**
     * 获取负责人证件类型，1身份证，2护照
     *
     * @return responsible_credential_type - 负责人证件类型，1身份证，2护照
     */
    public Byte getResponsibleCredentialType() {
        return responsibleCredentialType;
    }
 
    /**
     * 设置负责人证件类型，1身份证，2护照
     *
     * @param responsibleCredentialType 负责人证件类型，1身份证，2护照
     */
    public void setResponsibleCredentialType(Byte responsibleCredentialType) {
        this.responsibleCredentialType = responsibleCredentialType;
    }
 
    /**
     * 获取负责人证件id
     *
     * @return responsible_credential_id - 负责人证件id
     */
    public String getResponsibleCredentialId() {
        return responsibleCredentialId;
    }
 
    /**
     * 设置负责人证件id
     *
     * @param responsibleCredentialId 负责人证件id
     */
    public void setResponsibleCredentialId(String responsibleCredentialId) {
        this.responsibleCredentialId = responsibleCredentialId;
    }
 
    /**
     * 获取负责人邮箱
     *
     * @return responsible_email - 负责人邮箱
     */
    public String getResponsibleEmail() {
        return responsibleEmail;
    }
 
    /**
     * 设置负责人邮箱
     *
     * @param responsibleEmail 负责人邮箱
     */
    public void setResponsibleEmail(String responsibleEmail) {
        this.responsibleEmail = responsibleEmail;
    }
 
    /**
     * 获取负责人联系电话
     *
     * @return responsible_phone - 负责人联系电话
     */
    public String getResponsiblePhone() {
        return responsiblePhone;
    }
 
    /**
     * 设置负责人联系电话
     *
     * @param responsiblePhone 负责人联系电话
     */
    public void setResponsiblePhone(String responsiblePhone) {
        this.responsiblePhone = responsiblePhone;
    }
 
    /**
     * 获取最后更新时间
     *
     * @return update_time - 最后更新时间
     */
    public Date getUpdateTime() {
        return updateTime;
    }
 
    /**
     * 设置最后更新时间
     *
     * @param updateTime 最后更新时间
     */
    public void setUpdateTime(Date updateTime) {
        this.updateTime = updateTime;
    }
 
    /**
     * 获取开户类型，1个体户，2企业
     *
     * @return accountType - 开户类型，1个体户，2企业
     */
    public Byte getAccounttype() {
        return accounttype;
    }
 
    /**
     * 设置开户类型，1个体户，2企业
     *
     * @param accounttype 开户类型，1个体户，2企业
     */
    public void setAccounttype(Byte accounttype) {
        this.accounttype = accounttype;
    }
 
    /**
     * 获取开户许可证图片正面照
     *
     * @return accountPermissionFront - 开户许可证图片正面照
     */
    public String getAccountpermissionfront() {
        return accountpermissionfront;
    }
 
    /**
     * 设置开户许可证图片正面照
     *
     * @param accountpermissionfront 开户许可证图片正面照
     */
    public void setAccountpermissionfront(String accountpermissionfront) {
        this.accountpermissionfront = accountpermissionfront;
    }
 
    /**
     * 获取客服电话
     *
     * @return servicePhone - 客服电话
     */
    public String getServicephone() {
        return servicephone;
    }
 
    /**
     * 设置客服电话
     *
     * @param servicephone 客服电话
     */
    public void setServicephone(String servicephone) {
        this.servicephone = servicephone;
    }
 
    /**
     * 获取结算账户类型1对公，2：对私
     *
     * @return checkAccountType - 结算账户类型1对公，2：对私
     */
    public Byte getCheckaccounttype() {
        return checkaccounttype;
    }
 
    /**
     * 设置结算账户类型1对公，2：对私
     *
     * @param checkaccounttype 结算账户类型1对公，2：对私
     */
    public void setCheckaccounttype(Byte checkaccounttype) {
        this.checkaccounttype = checkaccounttype;
    }
 
    /**
     * 获取结算账户指令书,非法人结算进件
     *
     * @return checkAccountCode - 结算账户指令书,非法人结算进件
     */
    public String getCheckaccountcode() {
        return checkaccountcode;
    }
 
    /**
     * 设置结算账户指令书,非法人结算进件
     *
     * @param checkaccountcode 结算账户指令书,非法人结算进件
     */
    public void setCheckaccountcode(String checkaccountcode) {
        this.checkaccountcode = checkaccountcode;
    }
 
    /**
     * 获取组织结构
     *
     * @return cert_org_code - 组织结构
     */
    public String getCertOrgCode() {
        return certOrgCode;
    }
 
    /**
     * 设置组织结构
     *
     * @param certOrgCode 组织结构
     */
    public void setCertOrgCode(String certOrgCode) {
        this.certOrgCode = certOrgCode;
    }
 
    /**
     * 获取组织结构代码证
     *
     * @return prg_photo - 组织结构代码证
     */
    public String getPrgPhoto() {
        return prgPhoto;
    }
 
    /**
     * 设置组织结构代码证
     *
     * @param prgPhoto 组织结构代码证
     */
    public void setPrgPhoto(String prgPhoto) {
        this.prgPhoto = prgPhoto;
    }
 
    /**
     * 获取类目ID
     *
     * @return mcc - 类目ID
     */
    public String getMcc() {
        return mcc;
    }
 
    /**
     * 设置类目ID
     *
     * @param mcc 类目ID
     */
    public void setMcc(String mcc) {
        this.mcc = mcc;
    }
 
    /**
     * 获取经营类型
     *
     * @return deal_type - 经营类型
     */
    public Byte getDealType() {
        return dealType;
    }
 
    /**
     * 设置经营类型
     *
     * @param dealType 经营类型
     */
    public void setDealType(Byte dealType) {
        this.dealType = dealType;
    }
}

ShopLicenceEntityExample类：

package test.cn.mwee.service.entity.restaurant;
 
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
 
public class ShopLicenceEntityExample {
    protected String orderByClause;
 
    protected boolean distinct;
 
    protected List<Criteria> oredCriteria;
 
    public ShopLicenceEntityExample() {
        oredCriteria = new ArrayList<Criteria>();
    }
 
    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<Criteria> 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<Criterion> criteria;
 
        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }
 
        public boolean isValid() {
            return criteria.size() > 0;
        }
 
        public List<Criterion> getAllCriteria() {
            return criteria;
        }
 
        public List<Criterion> 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 andShopIdIsNull() {
            addCriterion("shop_id is null");
            return (Criteria) this;
        }
 
        public Criteria andShopIdIsNotNull() {
            addCriterion("shop_id is not null");
            return (Criteria) this;
        }
 
        public Criteria andShopIdEqualTo(Integer value) {
            addCriterion("shop_id =", value, "shopId");
            return (Criteria) this;
        }
 
        public Criteria andShopIdNotEqualTo(Integer value) {
            addCriterion("shop_id <>", value, "shopId");
            return (Criteria) this;
        }
 
        public Criteria andShopIdGreaterThan(Integer value) {
            addCriterion("shop_id >", value, "shopId");
            return (Criteria) this;
        }
 
        public Criteria andShopIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("shop_id >=", value, "shopId");
            return (Criteria) this;
        }
 
        public Criteria andShopIdLessThan(Integer value) {
            addCriterion("shop_id <", value, "shopId");
            return (Criteria) this;
        }
 
        public Criteria andShopIdLessThanOrEqualTo(Integer value) {
            addCriterion("shop_id <=", value, "shopId");
            return (Criteria) this;
        }
 
        public Criteria andShopIdIn(List<Integer> values) {
            addCriterion("shop_id in", values, "shopId");
            return (Criteria) this;
        }
 
        public Criteria andShopIdNotIn(List<Integer> values) {
            addCriterion("shop_id not in", values, "shopId");
            return (Criteria) this;
        }
 
        public Criteria andShopIdBetween(Integer value1, Integer value2) {
            addCriterion("shop_id between", value1, value2, "shopId");
            return (Criteria) this;
        }
 
        public Criteria andShopIdNotBetween(Integer value1, Integer value2) {
            addCriterion("shop_id not between", value1, value2, "shopId");
            return (Criteria) this;
        }
 
        public Criteria andManageShopIdIsNull() {
            addCriterion("manage_shop_id is null");
            return (Criteria) this;
        }
 
        public Criteria andManageShopIdIsNotNull() {
            addCriterion("manage_shop_id is not null");
            return (Criteria) this;
        }
 
        public Criteria andManageShopIdEqualTo(Integer value) {
            addCriterion("manage_shop_id =", value, "manageShopId");
            return (Criteria) this;
        }
 
        public Criteria andManageShopIdNotEqualTo(Integer value) {
            addCriterion("manage_shop_id <>", value, "manageShopId");
            return (Criteria) this;
        }
 
        public Criteria andManageShopIdGreaterThan(Integer value) {
            addCriterion("manage_shop_id >", value, "manageShopId");
            return (Criteria) this;
        }
 
        public Criteria andManageShopIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("manage_shop_id >=", value, "manageShopId");
            return (Criteria) this;
        }
 
        public Criteria andManageShopIdLessThan(Integer value) {
            addCriterion("manage_shop_id <", value, "manageShopId");
            return (Criteria) this;
        }
 
        public Criteria andManageShopIdLessThanOrEqualTo(Integer value) {
            addCriterion("manage_shop_id <=", value, "manageShopId");
            return (Criteria) this;
        }
 
        public Criteria andManageShopIdIn(List<Integer> values) {
            addCriterion("manage_shop_id in", values, "manageShopId");
            return (Criteria) this;
        }
 
        public Criteria andManageShopIdNotIn(List<Integer> values) {
            addCriterion("manage_shop_id not in", values, "manageShopId");
            return (Criteria) this;
        }
 
        public Criteria andManageShopIdBetween(Integer value1, Integer value2) {
            addCriterion("manage_shop_id between", value1, value2, "manageShopId");
            return (Criteria) this;
        }
 
        public Criteria andManageShopIdNotBetween(Integer value1, Integer value2) {
            addCriterion("manage_shop_id not between", value1, value2, "manageShopId");
            return (Criteria) this;
        }
 
        public Criteria andBusinessLicenceNameIsNull() {
            addCriterion("business_licence_name is null");
            return (Criteria) this;
        }
 
        public Criteria andBusinessLicenceNameIsNotNull() {
            addCriterion("business_licence_name is not null");
            return (Criteria) this;
        }
 
        public Criteria andBusinessLicenceNameEqualTo(String value) {
            addCriterion("business_licence_name =", value, "businessLicenceName");
            return (Criteria) this;
        }
 
        public Criteria andBusinessLicenceNameNotEqualTo(String value) {
            addCriterion("business_licence_name <>", value, "businessLicenceName");
            return (Criteria) this;
        }
 
        public Criteria andBusinessLicenceNameGreaterThan(String value) {
            addCriterion("business_licence_name >", value, "businessLicenceName");
            return (Criteria) this;
        }
 
        public Criteria andBusinessLicenceNameGreaterThanOrEqualTo(String value) {
            addCriterion("business_licence_name >=", value, "businessLicenceName");
            return (Criteria) this;
        }
 
        public Criteria andBusinessLicenceNameLessThan(String value) {
            addCriterion("business_licence_name <", value, "businessLicenceName");
            return (Criteria) this;
        }
 
        public Criteria andBusinessLicenceNameLessThanOrEqualTo(String value) {
            addCriterion("business_licence_name <=", value, "businessLicenceName");
            return (Criteria) this;
        }
 
        public Criteria andBusinessLicenceNameLike(String value) {
            addCriterion("business_licence_name like", value, "businessLicenceName");
            return (Criteria) this;
        }
 
        public Criteria andBusinessLicenceNameNotLike(String value) {
            addCriterion("business_licence_name not like", value, "businessLicenceName");
            return (Criteria) this;
        }
 
        public Criteria andBusinessLicenceNameIn(List<String> values) {
            addCriterion("business_licence_name in", values, "businessLicenceName");
            return (Criteria) this;
        }
 
        public Criteria andBusinessLicenceNameNotIn(List<String> values) {
            addCriterion("business_licence_name not in", values, "businessLicenceName");
            return (Criteria) this;
        }
 
        public Criteria andBusinessLicenceNameBetween(String value1, String value2) {
            addCriterion("business_licence_name between", value1, value2, "businessLicenceName");
            return (Criteria) this;
        }
 
        public Criteria andBusinessLicenceNameNotBetween(String value1, String value2) {
            addCriterion("business_licence_name not between", value1, value2, "businessLicenceName");
            return (Criteria) this;
        }
 
        public Criteria andBusinessLicenceNumberIsNull() {
            addCriterion("business_licence_number is null");
            return (Criteria) this;
        }
 
        public Criteria andBusinessLicenceNumberIsNotNull() {
            addCriterion("business_licence_number is not null");
            return (Criteria) this;
        }
 
        public Criteria andBusinessLicenceNumberEqualTo(String value) {
            addCriterion("business_licence_number =", value, "businessLicenceNumber");
            return (Criteria) this;
        }
 
        public Criteria andBusinessLicenceNumberNotEqualTo(String value) {
            addCriterion("business_licence_number <>", value, "businessLicenceNumber");
            return (Criteria) this;
        }
 
        public Criteria andBusinessLicenceNumberGreaterThan(String value) {
            addCriterion("business_licence_number >", value, "businessLicenceNumber");
            return (Criteria) this;
        }
 
        public Criteria andBusinessLicenceNumberGreaterThanOrEqualTo(String value) {
            addCriterion("business_licence_number >=", value, "businessLicenceNumber");
            return (Criteria) this;
        }
 
        public Criteria andBusinessLicenceNumberLessThan(String value) {
            addCriterion("business_licence_number <", value, "businessLicenceNumber");
            return (Criteria) this;
        }
 
        public Criteria andBusinessLicenceNumberLessThanOrEqualTo(String value) {
            addCriterion("business_licence_number <=", value, "businessLicenceNumber");
            return (Criteria) this;
        }
 
        public Criteria andBusinessLicenceNumberLike(String value) {
            addCriterion("business_licence_number like", value, "businessLicenceNumber");
            return (Criteria) this;
        }
 
        public Criteria andBusinessLicenceNumberNotLike(String value) {
            addCriterion("business_licence_number not like", value, "businessLicenceNumber");
            return (Criteria) this;
        }
 
        public Criteria andBusinessLicenceNumberIn(List<String> values) {
            addCriterion("business_licence_number in", values, "businessLicenceNumber");
            return (Criteria) this;
        }
 
        public Criteria andBusinessLicenceNumberNotIn(List<String> values) {
            addCriterion("business_licence_number not in", values, "businessLicenceNumber");
            return (Criteria) this;
        }
 
        public Criteria andBusinessLicenceNumberBetween(String value1, String value2) {
            addCriterion("business_licence_number between", value1, value2, "businessLicenceNumber");
            return (Criteria) this;
        }
 
        public Criteria andBusinessLicenceNumberNotBetween(String value1, String value2) {
            addCriterion("business_licence_number not between", value1, value2, "businessLicenceNumber");
            return (Criteria) this;
        }
 
        public Criteria andBusinessLicenceFrontIsNull() {
            addCriterion("business_licence_front is null");
            return (Criteria) this;
        }
 
        public Criteria andBusinessLicenceFrontIsNotNull() {
            addCriterion("business_licence_front is not null");
            return (Criteria) this;
        }
 
        public Criteria andBusinessLicenceFrontEqualTo(String value) {
            addCriterion("business_licence_front =", value, "businessLicenceFront");
            return (Criteria) this;
        }
 
        public Criteria andBusinessLicenceFrontNotEqualTo(String value) {
            addCriterion("business_licence_front <>", value, "businessLicenceFront");
            return (Criteria) this;
        }
 
        public Criteria andBusinessLicenceFrontGreaterThan(String value) {
            addCriterion("business_licence_front >", value, "businessLicenceFront");
            return (Criteria) this;
        }
 
        public Criteria andBusinessLicenceFrontGreaterThanOrEqualTo(String value) {
            addCriterion("business_licence_front >=", value, "businessLicenceFront");
            return (Criteria) this;
        }
 
        public Criteria andBusinessLicenceFrontLessThan(String value) {
            addCriterion("business_licence_front <", value, "businessLicenceFront");
            return (Criteria) this;
        }
 
        public Criteria andBusinessLicenceFrontLessThanOrEqualTo(String value) {
            addCriterion("business_licence_front <=", value, "businessLicenceFront");
            return (Criteria) this;
        }
 
        public Criteria andBusinessLicenceFrontLike(String value) {
            addCriterion("business_licence_front like", value, "businessLicenceFront");
            return (Criteria) this;
        }
 
        public Criteria andBusinessLicenceFrontNotLike(String value) {
            addCriterion("business_licence_front not like", value, "businessLicenceFront");
            return (Criteria) this;
        }
 
        public Criteria andBusinessLicenceFrontIn(List<String> values) {
            addCriterion("business_licence_front in", values, "businessLicenceFront");
            return (Criteria) this;
        }
 
        public Criteria andBusinessLicenceFrontNotIn(List<String> values) {
            addCriterion("business_licence_front not in", values, "businessLicenceFront");
            return (Criteria) this;
        }
 
        public Criteria andBusinessLicenceFrontBetween(String value1, String value2) {
            addCriterion("business_licence_front between", value1, value2, "businessLicenceFront");
            return (Criteria) this;
        }
 
        public Criteria andBusinessLicenceFrontNotBetween(String value1, String value2) {
            addCriterion("business_licence_front not between", value1, value2, "businessLicenceFront");
            return (Criteria) this;
        }
 
        public Criteria andArtificialPersonNameIsNull() {
            addCriterion("artificial_person_name is null");
            return (Criteria) this;
        }
 
        public Criteria andArtificialPersonNameIsNotNull() {
            addCriterion("artificial_person_name is not null");
            return (Criteria) this;
        }
 
        public Criteria andArtificialPersonNameEqualTo(String value) {
            addCriterion("artificial_person_name =", value, "artificialPersonName");
            return (Criteria) this;
        }
 
        public Criteria andArtificialPersonNameNotEqualTo(String value) {
            addCriterion("artificial_person_name <>", value, "artificialPersonName");
            return (Criteria) this;
        }
 
        public Criteria andArtificialPersonNameGreaterThan(String value) {
            addCriterion("artificial_person_name >", value, "artificialPersonName");
            return (Criteria) this;
        }
 
        public Criteria andArtificialPersonNameGreaterThanOrEqualTo(String value) {
            addCriterion("artificial_person_name >=", value, "artificialPersonName");
            return (Criteria) this;
        }
 
        public Criteria andArtificialPersonNameLessThan(String value) {
            addCriterion("artificial_person_name <", value, "artificialPersonName");
            return (Criteria) this;
        }
 
        public Criteria andArtificialPersonNameLessThanOrEqualTo(String value) {
            addCriterion("artificial_person_name <=", value, "artificialPersonName");
            return (Criteria) this;
        }
 
        public Criteria andArtificialPersonNameLike(String value) {
            addCriterion("artificial_person_name like", value, "artificialPersonName");
            return (Criteria) this;
        }
 
        public Criteria andArtificialPersonNameNotLike(String value) {
            addCriterion("artificial_person_name not like", value, "artificialPersonName");
            return (Criteria) this;
        }
 
        public Criteria andArtificialPersonNameIn(List<String> values) {
            addCriterion("artificial_person_name in", values, "artificialPersonName");
            return (Criteria) this;
        }
 
        public Criteria andArtificialPersonNameNotIn(List<String> values) {
            addCriterion("artificial_person_name not in", values, "artificialPersonName");
            return (Criteria) this;
        }
 
        public Criteria andArtificialPersonNameBetween(String value1, String value2) {
            addCriterion("artificial_person_name between", value1, value2, "artificialPersonName");
            return (Criteria) this;
        }
 
        public Criteria andArtificialPersonNameNotBetween(String value1, String value2) {
            addCriterion("artificial_person_name not between", value1, value2, "artificialPersonName");
            return (Criteria) this;
        }
 
        public Criteria andArtificialCredentialTypeIsNull() {
            addCriterion("artificial_credential_type is null");
            return (Criteria) this;
        }
 
        public Criteria andArtificialCredentialTypeIsNotNull() {
            addCriterion("artificial_credential_type is not null");
            return (Criteria) this;
        }
 
        public Criteria andArtificialCredentialTypeEqualTo(Byte value) {
            addCriterion("artificial_credential_type =", value, "artificialCredentialType");
            return (Criteria) this;
        }
 
        public Criteria andArtificialCredentialTypeNotEqualTo(Byte value) {
            addCriterion("artificial_credential_type <>", value, "artificialCredentialType");
            return (Criteria) this;
        }
 
        public Criteria andArtificialCredentialTypeGreaterThan(Byte value) {
            addCriterion("artificial_credential_type >", value, "artificialCredentialType");
            return (Criteria) this;
        }
 
        public Criteria andArtificialCredentialTypeGreaterThanOrEqualTo(Byte value) {
            addCriterion("artificial_credential_type >=", value, "artificialCredentialType");
            return (Criteria) this;
        }
 
        public Criteria andArtificialCredentialTypeLessThan(Byte value) {
            addCriterion("artificial_credential_type <", value, "artificialCredentialType");
            return (Criteria) this;
        }
 
        public Criteria andArtificialCredentialTypeLessThanOrEqualTo(Byte value) {
            addCriterion("artificial_credential_type <=", value, "artificialCredentialType");
            return (Criteria) this;
        }
 
        public Criteria andArtificialCredentialTypeIn(List<Byte> values) {
            addCriterion("artificial_credential_type in", values, "artificialCredentialType");
            return (Criteria) this;
        }
 
        public Criteria andArtificialCredentialTypeNotIn(List<Byte> values) {
            addCriterion("artificial_credential_type not in", values, "artificialCredentialType");
            return (Criteria) this;
        }
 
        public Criteria andArtificialCredentialTypeBetween(Byte value1, Byte value2) {
            addCriterion("artificial_credential_type between", value1, value2, "artificialCredentialType");
            return (Criteria) this;
        }
 
        public Criteria andArtificialCredentialTypeNotBetween(Byte value1, Byte value2) {
            addCriterion("artificial_credential_type not between", value1, value2, "artificialCredentialType");
            return (Criteria) this;
        }
 
        public Criteria andArtificialCredentialIdIsNull() {
            addCriterion("artificial_credential_id is null");
            return (Criteria) this;
        }
 
        public Criteria andArtificialCredentialIdIsNotNull() {
            addCriterion("artificial_credential_id is not null");
            return (Criteria) this;
        }
 
        public Criteria andArtificialCredentialIdEqualTo(String value) {
            addCriterion("artificial_credential_id =", value, "artificialCredentialId");
            return (Criteria) this;
        }
 
        public Criteria andArtificialCredentialIdNotEqualTo(String value) {
            addCriterion("artificial_credential_id <>", value, "artificialCredentialId");
            return (Criteria) this;
        }
 
        public Criteria andArtificialCredentialIdGreaterThan(String value) {
            addCriterion("artificial_credential_id >", value, "artificialCredentialId");
            return (Criteria) this;
        }
 
        public Criteria andArtificialCredentialIdGreaterThanOrEqualTo(String value) {
            addCriterion("artificial_credential_id >=", value, "artificialCredentialId");
            return (Criteria) this;
        }
 
        public Criteria andArtificialCredentialIdLessThan(String value) {
            addCriterion("artificial_credential_id <", value, "artificialCredentialId");
            return (Criteria) this;
        }
 
        public Criteria andArtificialCredentialIdLessThanOrEqualTo(String value) {
            addCriterion("artificial_credential_id <=", value, "artificialCredentialId");
            return (Criteria) this;
        }
 
        public Criteria andArtificialCredentialIdLike(String value) {
            addCriterion("artificial_credential_id like", value, "artificialCredentialId");
            return (Criteria) this;
        }
 
        public Criteria andArtificialCredentialIdNotLike(String value) {
            addCriterion("artificial_credential_id not like", value, "artificialCredentialId");
            return (Criteria) this;
        }
 
        public Criteria andArtificialCredentialIdIn(List<String> values) {
            addCriterion("artificial_credential_id in", values, "artificialCredentialId");
            return (Criteria) this;
        }
 
        public Criteria andArtificialCredentialIdNotIn(List<String> values) {
            addCriterion("artificial_credential_id not in", values, "artificialCredentialId");
            return (Criteria) this;
        }
 
        public Criteria andArtificialCredentialIdBetween(String value1, String value2) {
            addCriterion("artificial_credential_id between", value1, value2, "artificialCredentialId");
            return (Criteria) this;
        }
 
        public Criteria andArtificialCredentialIdNotBetween(String value1, String value2) {
            addCriterion("artificial_credential_id not between", value1, value2, "artificialCredentialId");
            return (Criteria) this;
        }
 
        public Criteria andArtificialPhoneIsNull() {
            addCriterion("artificial_phone is null");
            return (Criteria) this;
        }
 
        public Criteria andArtificialPhoneIsNotNull() {
            addCriterion("artificial_phone is not null");
            return (Criteria) this;
        }
 
        public Criteria andArtificialPhoneEqualTo(String value) {
            addCriterion("artificial_phone =", value, "artificialPhone");
            return (Criteria) this;
        }
 
        public Criteria andArtificialPhoneNotEqualTo(String value) {
            addCriterion("artificial_phone <>", value, "artificialPhone");
            return (Criteria) this;
        }
 
        public Criteria andArtificialPhoneGreaterThan(String value) {
            addCriterion("artificial_phone >", value, "artificialPhone");
            return (Criteria) this;
        }
 
        public Criteria andArtificialPhoneGreaterThanOrEqualTo(String value) {
            addCriterion("artificial_phone >=", value, "artificialPhone");
            return (Criteria) this;
        }
 
        public Criteria andArtificialPhoneLessThan(String value) {
            addCriterion("artificial_phone <", value, "artificialPhone");
            return (Criteria) this;
        }
 
        public Criteria andArtificialPhoneLessThanOrEqualTo(String value) {
            addCriterion("artificial_phone <=", value, "artificialPhone");
            return (Criteria) this;
        }
 
        public Criteria andArtificialPhoneLike(String value) {
            addCriterion("artificial_phone like", value, "artificialPhone");
            return (Criteria) this;
        }
 
        public Criteria andArtificialPhoneNotLike(String value) {
            addCriterion("artificial_phone not like", value, "artificialPhone");
            return (Criteria) this;
        }
 
        public Criteria andArtificialPhoneIn(List<String> values) {
            addCriterion("artificial_phone in", values, "artificialPhone");
            return (Criteria) this;
        }
 
        public Criteria andArtificialPhoneNotIn(List<String> values) {
            addCriterion("artificial_phone not in", values, "artificialPhone");
            return (Criteria) this;
        }
 
        public Criteria andArtificialPhoneBetween(String value1, String value2) {
            addCriterion("artificial_phone between", value1, value2, "artificialPhone");
            return (Criteria) this;
        }
 
        public Criteria andArtificialPhoneNotBetween(String value1, String value2) {
            addCriterion("artificial_phone not between", value1, value2, "artificialPhone");
            return (Criteria) this;
        }
 
        public Criteria andArtificialCredentialFrontIsNull() {
            addCriterion("artificial_credential_front is null");
            return (Criteria) this;
        }
 
        public Criteria andArtificialCredentialFrontIsNotNull() {
            addCriterion("artificial_credential_front is not null");
            return (Criteria) this;
        }
 
        public Criteria andArtificialCredentialFrontEqualTo(String value) {
            addCriterion("artificial_credential_front =", value, "artificialCredentialFront");
            return (Criteria) this;
        }
 
        public Criteria andArtificialCredentialFrontNotEqualTo(String value) {
            addCriterion("artificial_credential_front <>", value, "artificialCredentialFront");
            return (Criteria) this;
        }
 
        public Criteria andArtificialCredentialFrontGreaterThan(String value) {
            addCriterion("artificial_credential_front >", value, "artificialCredentialFront");
            return (Criteria) this;
        }
 
        public Criteria andArtificialCredentialFrontGreaterThanOrEqualTo(String value) {
            addCriterion("artificial_credential_front >=", value, "artificialCredentialFront");
            return (Criteria) this;
        }
 
        public Criteria andArtificialCredentialFrontLessThan(String value) {
            addCriterion("artificial_credential_front <", value, "artificialCredentialFront");
            return (Criteria) this;
        }
 
        public Criteria andArtificialCredentialFrontLessThanOrEqualTo(String value) {
            addCriterion("artificial_credential_front <=", value, "artificialCredentialFront");
            return (Criteria) this;
        }
 
        public Criteria andArtificialCredentialFrontLike(String value) {
            addCriterion("artificial_credential_front like", value, "artificialCredentialFront");
            return (Criteria) this;
        }
 
        public Criteria andArtificialCredentialFrontNotLike(String value) {
            addCriterion("artificial_credential_front not like", value, "artificialCredentialFront");
            return (Criteria) this;
        }
 
        public Criteria andArtificialCredentialFrontIn(List<String> values) {
            addCriterion("artificial_credential_front in", values, "artificialCredentialFront");
            return (Criteria) this;
        }
 
        public Criteria andArtificialCredentialFrontNotIn(List<String> values) {
            addCriterion("artificial_credential_front not in", values, "artificialCredentialFront");
            return (Criteria) this;
        }
 
        public Criteria andArtificialCredentialFrontBetween(String value1, String value2) {
            addCriterion("artificial_credential_front between", value1, value2, "artificialCredentialFront");
            return (Criteria) this;
        }
 
        public Criteria andArtificialCredentialFrontNotBetween(String value1, String value2) {
            addCriterion("artificial_credential_front not between", value1, value2, "artificialCredentialFront");
            return (Criteria) this;
        }
 
        public Criteria andArtificialCredentialBackIsNull() {
            addCriterion("artificial_credential_back is null");
            return (Criteria) this;
        }
 
        public Criteria andArtificialCredentialBackIsNotNull() {
            addCriterion("artificial_credential_back is not null");
            return (Criteria) this;
        }
 
        public Criteria andArtificialCredentialBackEqualTo(String value) {
            addCriterion("artificial_credential_back =", value, "artificialCredentialBack");
            return (Criteria) this;
        }
 
        public Criteria andArtificialCredentialBackNotEqualTo(String value) {
            addCriterion("artificial_credential_back <>", value, "artificialCredentialBack");
            return (Criteria) this;
        }
 
        public Criteria andArtificialCredentialBackGreaterThan(String value) {
            addCriterion("artificial_credential_back >", value, "artificialCredentialBack");
            return (Criteria) this;
        }
 
        public Criteria andArtificialCredentialBackGreaterThanOrEqualTo(String value) {
            addCriterion("artificial_credential_back >=", value, "artificialCredentialBack");
            return (Criteria) this;
        }
 
        public Criteria andArtificialCredentialBackLessThan(String value) {
            addCriterion("artificial_credential_back <", value, "artificialCredentialBack");
            return (Criteria) this;
        }
 
        public Criteria andArtificialCredentialBackLessThanOrEqualTo(String value) {
            addCriterion("artificial_credential_back <=", value, "artificialCredentialBack");
            return (Criteria) this;
        }
 
        public Criteria andArtificialCredentialBackLike(String value) {
            addCriterion("artificial_credential_back like", value, "artificialCredentialBack");
            return (Criteria) this;
        }
 
        public Criteria andArtificialCredentialBackNotLike(String value) {
            addCriterion("artificial_credential_back not like", value, "artificialCredentialBack");
            return (Criteria) this;
        }
 
        public Criteria andArtificialCredentialBackIn(List<String> values) {
            addCriterion("artificial_credential_back in", values, "artificialCredentialBack");
            return (Criteria) this;
        }
 
        public Criteria andArtificialCredentialBackNotIn(List<String> values) {
            addCriterion("artificial_credential_back not in", values, "artificialCredentialBack");
            return (Criteria) this;
        }
 
        public Criteria andArtificialCredentialBackBetween(String value1, String value2) {
            addCriterion("artificial_credential_back between", value1, value2, "artificialCredentialBack");
            return (Criteria) this;
        }
 
        public Criteria andArtificialCredentialBackNotBetween(String value1, String value2) {
            addCriterion("artificial_credential_back not between", value1, value2, "artificialCredentialBack");
            return (Criteria) this;
        }
 
        public Criteria andResponsiblePeopleIsNull() {
            addCriterion("responsible_people is null");
            return (Criteria) this;
        }
 
        public Criteria andResponsiblePeopleIsNotNull() {
            addCriterion("responsible_people is not null");
            return (Criteria) this;
        }
 
        public Criteria andResponsiblePeopleEqualTo(String value) {
            addCriterion("responsible_people =", value, "responsiblePeople");
            return (Criteria) this;
        }
 
        public Criteria andResponsiblePeopleNotEqualTo(String value) {
            addCriterion("responsible_people <>", value, "responsiblePeople");
            return (Criteria) this;
        }
 
        public Criteria andResponsiblePeopleGreaterThan(String value) {
            addCriterion("responsible_people >", value, "responsiblePeople");
            return (Criteria) this;
        }
 
        public Criteria andResponsiblePeopleGreaterThanOrEqualTo(String value) {
            addCriterion("responsible_people >=", value, "responsiblePeople");
            return (Criteria) this;
        }
 
        public Criteria andResponsiblePeopleLessThan(String value) {
            addCriterion("responsible_people <", value, "responsiblePeople");
            return (Criteria) this;
        }
 
        public Criteria andResponsiblePeopleLessThanOrEqualTo(String value) {
            addCriterion("responsible_people <=", value, "responsiblePeople");
            return (Criteria) this;
        }
 
        public Criteria andResponsiblePeopleLike(String value) {
            addCriterion("responsible_people like", value, "responsiblePeople");
            return (Criteria) this;
        }
 
        public Criteria andResponsiblePeopleNotLike(String value) {
            addCriterion("responsible_people not like", value, "responsiblePeople");
            return (Criteria) this;
        }
 
        public Criteria andResponsiblePeopleIn(List<String> values) {
            addCriterion("responsible_people in", values, "responsiblePeople");
            return (Criteria) this;
        }
 
        public Criteria andResponsiblePeopleNotIn(List<String> values) {
            addCriterion("responsible_people not in", values, "responsiblePeople");
            return (Criteria) this;
        }
 
        public Criteria andResponsiblePeopleBetween(String value1, String value2) {
            addCriterion("responsible_people between", value1, value2, "responsiblePeople");
            return (Criteria) this;
        }
 
        public Criteria andResponsiblePeopleNotBetween(String value1, String value2) {
            addCriterion("responsible_people not between", value1, value2, "responsiblePeople");
            return (Criteria) this;
        }
 
        public Criteria andResponsibleCredentialTypeIsNull() {
            addCriterion("responsible_credential_type is null");
            return (Criteria) this;
        }
 
        public Criteria andResponsibleCredentialTypeIsNotNull() {
            addCriterion("responsible_credential_type is not null");
            return (Criteria) this;
        }
 
        public Criteria andResponsibleCredentialTypeEqualTo(Byte value) {
            addCriterion("responsible_credential_type =", value, "responsibleCredentialType");
            return (Criteria) this;
        }
 
        public Criteria andResponsibleCredentialTypeNotEqualTo(Byte value) {
            addCriterion("responsible_credential_type <>", value, "responsibleCredentialType");
            return (Criteria) this;
        }
 
        public Criteria andResponsibleCredentialTypeGreaterThan(Byte value) {
            addCriterion("responsible_credential_type >", value, "responsibleCredentialType");
            return (Criteria) this;
        }
 
        public Criteria andResponsibleCredentialTypeGreaterThanOrEqualTo(Byte value) {
            addCriterion("responsible_credential_type >=", value, "responsibleCredentialType");
            return (Criteria) this;
        }
 
        public Criteria andResponsibleCredentialTypeLessThan(Byte value) {
            addCriterion("responsible_credential_type <", value, "responsibleCredentialType");
            return (Criteria) this;
        }
 
        public Criteria andResponsibleCredentialTypeLessThanOrEqualTo(Byte value) {
            addCriterion("responsible_credential_type <=", value, "responsibleCredentialType");
            return (Criteria) this;
        }
 
        public Criteria andResponsibleCredentialTypeIn(List<Byte> values) {
            addCriterion("responsible_credential_type in", values, "responsibleCredentialType");
            return (Criteria) this;
        }
 
        public Criteria andResponsibleCredentialTypeNotIn(List<Byte> values) {
            addCriterion("responsible_credential_type not in", values, "responsibleCredentialType");
            return (Criteria) this;
        }
 
        public Criteria andResponsibleCredentialTypeBetween(Byte value1, Byte value2) {
            addCriterion("responsible_credential_type between", value1, value2, "responsibleCredentialType");
            return (Criteria) this;
        }
 
        public Criteria andResponsibleCredentialTypeNotBetween(Byte value1, Byte value2) {
            addCriterion("responsible_credential_type not between", value1, value2, "responsibleCredentialType");
            return (Criteria) this;
        }
 
        public Criteria andResponsibleCredentialIdIsNull() {
            addCriterion("responsible_credential_id is null");
            return (Criteria) this;
        }
 
        public Criteria andResponsibleCredentialIdIsNotNull() {
            addCriterion("responsible_credential_id is not null");
            return (Criteria) this;
        }
 
        public Criteria andResponsibleCredentialIdEqualTo(String value) {
            addCriterion("responsible_credential_id =", value, "responsibleCredentialId");
            return (Criteria) this;
        }
 
        public Criteria andResponsibleCredentialIdNotEqualTo(String value) {
            addCriterion("responsible_credential_id <>", value, "responsibleCredentialId");
            return (Criteria) this;
        }
 
        public Criteria andResponsibleCredentialIdGreaterThan(String value) {
            addCriterion("responsible_credential_id >", value, "responsibleCredentialId");
            return (Criteria) this;
        }
 
        public Criteria andResponsibleCredentialIdGreaterThanOrEqualTo(String value) {
            addCriterion("responsible_credential_id >=", value, "responsibleCredentialId");
            return (Criteria) this;
        }
 
        public Criteria andResponsibleCredentialIdLessThan(String value) {
            addCriterion("responsible_credential_id <", value, "responsibleCredentialId");
            return (Criteria) this;
        }
 
        public Criteria andResponsibleCredentialIdLessThanOrEqualTo(String value) {
            addCriterion("responsible_credential_id <=", value, "responsibleCredentialId");
            return (Criteria) this;
        }
 
        public Criteria andResponsibleCredentialIdLike(String value) {
            addCriterion("responsible_credential_id like", value, "responsibleCredentialId");
            return (Criteria) this;
        }
 
        public Criteria andResponsibleCredentialIdNotLike(String value) {
            addCriterion("responsible_credential_id not like", value, "responsibleCredentialId");
            return (Criteria) this;
        }
 
        public Criteria andResponsibleCredentialIdIn(List<String> values) {
            addCriterion("responsible_credential_id in", values, "responsibleCredentialId");
            return (Criteria) this;
        }
 
        public Criteria andResponsibleCredentialIdNotIn(List<String> values) {
            addCriterion("responsible_credential_id not in", values, "responsibleCredentialId");
            return (Criteria) this;
        }
 
        public Criteria andResponsibleCredentialIdBetween(String value1, String value2) {
            addCriterion("responsible_credential_id between", value1, value2, "responsibleCredentialId");
            return (Criteria) this;
        }
 
        public Criteria andResponsibleCredentialIdNotBetween(String value1, String value2) {
            addCriterion("responsible_credential_id not between", value1, value2, "responsibleCredentialId");
            return (Criteria) this;
        }
 
        public Criteria andResponsibleEmailIsNull() {
            addCriterion("responsible_email is null");
            return (Criteria) this;
        }
 
        public Criteria andResponsibleEmailIsNotNull() {
            addCriterion("responsible_email is not null");
            return (Criteria) this;
        }
 
        public Criteria andResponsibleEmailEqualTo(String value) {
            addCriterion("responsible_email =", value, "responsibleEmail");
            return (Criteria) this;
        }
 
        public Criteria andResponsibleEmailNotEqualTo(String value) {
            addCriterion("responsible_email <>", value, "responsibleEmail");
            return (Criteria) this;
        }
 
        public Criteria andResponsibleEmailGreaterThan(String value) {
            addCriterion("responsible_email >", value, "responsibleEmail");
            return (Criteria) this;
        }
 
        public Criteria andResponsibleEmailGreaterThanOrEqualTo(String value) {
            addCriterion("responsible_email >=", value, "responsibleEmail");
            return (Criteria) this;
        }
 
        public Criteria andResponsibleEmailLessThan(String value) {
            addCriterion("responsible_email <", value, "responsibleEmail");
            return (Criteria) this;
        }
 
        public Criteria andResponsibleEmailLessThanOrEqualTo(String value) {
            addCriterion("responsible_email <=", value, "responsibleEmail");
            return (Criteria) this;
        }
 
        public Criteria andResponsibleEmailLike(String value) {
            addCriterion("responsible_email like", value, "responsibleEmail");
            return (Criteria) this;
        }
 
        public Criteria andResponsibleEmailNotLike(String value) {
            addCriterion("responsible_email not like", value, "responsibleEmail");
            return (Criteria) this;
        }
 
        public Criteria andResponsibleEmailIn(List<String> values) {
            addCriterion("responsible_email in", values, "responsibleEmail");
            return (Criteria) this;
        }
 
        public Criteria andResponsibleEmailNotIn(List<String> values) {
            addCriterion("responsible_email not in", values, "responsibleEmail");
            return (Criteria) this;
        }
 
        public Criteria andResponsibleEmailBetween(String value1, String value2) {
            addCriterion("responsible_email between", value1, value2, "responsibleEmail");
            return (Criteria) this;
        }
 
        public Criteria andResponsibleEmailNotBetween(String value1, String value2) {
            addCriterion("responsible_email not between", value1, value2, "responsibleEmail");
            return (Criteria) this;
        }
 
        public Criteria andResponsiblePhoneIsNull() {
            addCriterion("responsible_phone is null");
            return (Criteria) this;
        }
 
        public Criteria andResponsiblePhoneIsNotNull() {
            addCriterion("responsible_phone is not null");
            return (Criteria) this;
        }
 
        public Criteria andResponsiblePhoneEqualTo(String value) {
            addCriterion("responsible_phone =", value, "responsiblePhone");
            return (Criteria) this;
        }
 
        public Criteria andResponsiblePhoneNotEqualTo(String value) {
            addCriterion("responsible_phone <>", value, "responsiblePhone");
            return (Criteria) this;
        }
 
        public Criteria andResponsiblePhoneGreaterThan(String value) {
            addCriterion("responsible_phone >", value, "responsiblePhone");
            return (Criteria) this;
        }
 
        public Criteria andResponsiblePhoneGreaterThanOrEqualTo(String value) {
            addCriterion("responsible_phone >=", value, "responsiblePhone");
            return (Criteria) this;
        }
 
        public Criteria andResponsiblePhoneLessThan(String value) {
            addCriterion("responsible_phone <", value, "responsiblePhone");
            return (Criteria) this;
        }
 
        public Criteria andResponsiblePhoneLessThanOrEqualTo(String value) {
            addCriterion("responsible_phone <=", value, "responsiblePhone");
            return (Criteria) this;
        }
 
        public Criteria andResponsiblePhoneLike(String value) {
            addCriterion("responsible_phone like", value, "responsiblePhone");
            return (Criteria) this;
        }
 
        public Criteria andResponsiblePhoneNotLike(String value) {
            addCriterion("responsible_phone not like", value, "responsiblePhone");
            return (Criteria) this;
        }
 
        public Criteria andResponsiblePhoneIn(List<String> values) {
            addCriterion("responsible_phone in", values, "responsiblePhone");
            return (Criteria) this;
        }
 
        public Criteria andResponsiblePhoneNotIn(List<String> values) {
            addCriterion("responsible_phone not in", values, "responsiblePhone");
            return (Criteria) this;
        }
 
        public Criteria andResponsiblePhoneBetween(String value1, String value2) {
            addCriterion("responsible_phone between", value1, value2, "responsiblePhone");
            return (Criteria) this;
        }
 
        public Criteria andResponsiblePhoneNotBetween(String value1, String value2) {
            addCriterion("responsible_phone not between", value1, value2, "responsiblePhone");
            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<Date> values) {
            addCriterion("update_time in", values, "updateTime");
            return (Criteria) this;
        }
 
        public Criteria andUpdateTimeNotIn(List<Date> 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 andAccounttypeIsNull() {
            addCriterion("accountType is null");
            return (Criteria) this;
        }
 
        public Criteria andAccounttypeIsNotNull() {
            addCriterion("accountType is not null");
            return (Criteria) this;
        }
 
        public Criteria andAccounttypeEqualTo(Byte value) {
            addCriterion("accountType =", value, "accounttype");
            return (Criteria) this;
        }
 
        public Criteria andAccounttypeNotEqualTo(Byte value) {
            addCriterion("accountType <>", value, "accounttype");
            return (Criteria) this;
        }
 
        public Criteria andAccounttypeGreaterThan(Byte value) {
            addCriterion("accountType >", value, "accounttype");
            return (Criteria) this;
        }
 
        public Criteria andAccounttypeGreaterThanOrEqualTo(Byte value) {
            addCriterion("accountType >=", value, "accounttype");
            return (Criteria) this;
        }
 
        public Criteria andAccounttypeLessThan(Byte value) {
            addCriterion("accountType <", value, "accounttype");
            return (Criteria) this;
        }
 
        public Criteria andAccounttypeLessThanOrEqualTo(Byte value) {
            addCriterion("accountType <=", value, "accounttype");
            return (Criteria) this;
        }
 
        public Criteria andAccounttypeIn(List<Byte> values) {
            addCriterion("accountType in", values, "accounttype");
            return (Criteria) this;
        }
 
        public Criteria andAccounttypeNotIn(List<Byte> values) {
            addCriterion("accountType not in", values, "accounttype");
            return (Criteria) this;
        }
 
        public Criteria andAccounttypeBetween(Byte value1, Byte value2) {
            addCriterion("accountType between", value1, value2, "accounttype");
            return (Criteria) this;
        }
 
        public Criteria andAccounttypeNotBetween(Byte value1, Byte value2) {
            addCriterion("accountType not between", value1, value2, "accounttype");
            return (Criteria) this;
        }
 
        public Criteria andAccountpermissionfrontIsNull() {
            addCriterion("accountPermissionFront is null");
            return (Criteria) this;
        }
 
        public Criteria andAccountpermissionfrontIsNotNull() {
            addCriterion("accountPermissionFront is not null");
            return (Criteria) this;
        }
 
        public Criteria andAccountpermissionfrontEqualTo(String value) {
            addCriterion("accountPermissionFront =", value, "accountpermissionfront");
            return (Criteria) this;
        }
 
        public Criteria andAccountpermissionfrontNotEqualTo(String value) {
            addCriterion("accountPermissionFront <>", value, "accountpermissionfront");
            return (Criteria) this;
        }
 
        public Criteria andAccountpermissionfrontGreaterThan(String value) {
            addCriterion("accountPermissionFront >", value, "accountpermissionfront");
            return (Criteria) this;
        }
 
        public Criteria andAccountpermissionfrontGreaterThanOrEqualTo(String value) {
            addCriterion("accountPermissionFront >=", value, "accountpermissionfront");
            return (Criteria) this;
        }
 
        public Criteria andAccountpermissionfrontLessThan(String value) {
            addCriterion("accountPermissionFront <", value, "accountpermissionfront");
            return (Criteria) this;
        }
 
        public Criteria andAccountpermissionfrontLessThanOrEqualTo(String value) {
            addCriterion("accountPermissionFront <=", value, "accountpermissionfront");
            return (Criteria) this;
        }
 
        public Criteria andAccountpermissionfrontLike(String value) {
            addCriterion("accountPermissionFront like", value, "accountpermissionfront");
            return (Criteria) this;
        }
 
        public Criteria andAccountpermissionfrontNotLike(String value) {
            addCriterion("accountPermissionFront not like", value, "accountpermissionfront");
            return (Criteria) this;
        }
 
        public Criteria andAccountpermissionfrontIn(List<String> values) {
            addCriterion("accountPermissionFront in", values, "accountpermissionfront");
            return (Criteria) this;
        }
 
        public Criteria andAccountpermissionfrontNotIn(List<String> values) {
            addCriterion("accountPermissionFront not in", values, "accountpermissionfront");
            return (Criteria) this;
        }
 
        public Criteria andAccountpermissionfrontBetween(String value1, String value2) {
            addCriterion("accountPermissionFront between", value1, value2, "accountpermissionfront");
            return (Criteria) this;
        }
 
        public Criteria andAccountpermissionfrontNotBetween(String value1, String value2) {
            addCriterion("accountPermissionFront not between", value1, value2, "accountpermissionfront");
            return (Criteria) this;
        }
 
        public Criteria andServicephoneIsNull() {
            addCriterion("servicePhone is null");
            return (Criteria) this;
        }
 
        public Criteria andServicephoneIsNotNull() {
            addCriterion("servicePhone is not null");
            return (Criteria) this;
        }
 
        public Criteria andServicephoneEqualTo(String value) {
            addCriterion("servicePhone =", value, "servicephone");
            return (Criteria) this;
        }
 
        public Criteria andServicephoneNotEqualTo(String value) {
            addCriterion("servicePhone <>", value, "servicephone");
            return (Criteria) this;
        }
 
        public Criteria andServicephoneGreaterThan(String value) {
            addCriterion("servicePhone >", value, "servicephone");
            return (Criteria) this;
        }
 
        public Criteria andServicephoneGreaterThanOrEqualTo(String value) {
            addCriterion("servicePhone >=", value, "servicephone");
            return (Criteria) this;
        }
 
        public Criteria andServicephoneLessThan(String value) {
            addCriterion("servicePhone <", value, "servicephone");
            return (Criteria) this;
        }
 
        public Criteria andServicephoneLessThanOrEqualTo(String value) {
            addCriterion("servicePhone <=", value, "servicephone");
            return (Criteria) this;
        }
 
        public Criteria andServicephoneLike(String value) {
            addCriterion("servicePhone like", value, "servicephone");
            return (Criteria) this;
        }
 
        public Criteria andServicephoneNotLike(String value) {
            addCriterion("servicePhone not like", value, "servicephone");
            return (Criteria) this;
        }
 
        public Criteria andServicephoneIn(List<String> values) {
            addCriterion("servicePhone in", values, "servicephone");
            return (Criteria) this;
        }
 
        public Criteria andServicephoneNotIn(List<String> values) {
            addCriterion("servicePhone not in", values, "servicephone");
            return (Criteria) this;
        }
 
        public Criteria andServicephoneBetween(String value1, String value2) {
            addCriterion("servicePhone between", value1, value2, "servicephone");
            return (Criteria) this;
        }
 
        public Criteria andServicephoneNotBetween(String value1, String value2) {
            addCriterion("servicePhone not between", value1, value2, "servicephone");
            return (Criteria) this;
        }
 
        public Criteria andCheckaccounttypeIsNull() {
            addCriterion("checkAccountType is null");
            return (Criteria) this;
        }
 
        public Criteria andCheckaccounttypeIsNotNull() {
            addCriterion("checkAccountType is not null");
            return (Criteria) this;
        }
 
        public Criteria andCheckaccounttypeEqualTo(Byte value) {
            addCriterion("checkAccountType =", value, "checkaccounttype");
            return (Criteria) this;
        }
 
        public Criteria andCheckaccounttypeNotEqualTo(Byte value) {
            addCriterion("checkAccountType <>", value, "checkaccounttype");
            return (Criteria) this;
        }
 
        public Criteria andCheckaccounttypeGreaterThan(Byte value) {
            addCriterion("checkAccountType >", value, "checkaccounttype");
            return (Criteria) this;
        }
 
        public Criteria andCheckaccounttypeGreaterThanOrEqualTo(Byte value) {
            addCriterion("checkAccountType >=", value, "checkaccounttype");
            return (Criteria) this;
        }
 
        public Criteria andCheckaccounttypeLessThan(Byte value) {
            addCriterion("checkAccountType <", value, "checkaccounttype");
            return (Criteria) this;
        }
 
        public Criteria andCheckaccounttypeLessThanOrEqualTo(Byte value) {
            addCriterion("checkAccountType <=", value, "checkaccounttype");
            return (Criteria) this;
        }
 
        public Criteria andCheckaccounttypeIn(List<Byte> values) {
            addCriterion("checkAccountType in", values, "checkaccounttype");
            return (Criteria) this;
        }
 
        public Criteria andCheckaccounttypeNotIn(List<Byte> values) {
            addCriterion("checkAccountType not in", values, "checkaccounttype");
            return (Criteria) this;
        }
 
        public Criteria andCheckaccounttypeBetween(Byte value1, Byte value2) {
            addCriterion("checkAccountType between", value1, value2, "checkaccounttype");
            return (Criteria) this;
        }
 
        public Criteria andCheckaccounttypeNotBetween(Byte value1, Byte value2) {
            addCriterion("checkAccountType not between", value1, value2, "checkaccounttype");
            return (Criteria) this;
        }
 
        public Criteria andCheckaccountcodeIsNull() {
            addCriterion("checkAccountCode is null");
            return (Criteria) this;
        }
 
        public Criteria andCheckaccountcodeIsNotNull() {
            addCriterion("checkAccountCode is not null");
            return (Criteria) this;
        }
 
        public Criteria andCheckaccountcodeEqualTo(String value) {
            addCriterion("checkAccountCode =", value, "checkaccountcode");
            return (Criteria) this;
        }
 
        public Criteria andCheckaccountcodeNotEqualTo(String value) {
            addCriterion("checkAccountCode <>", value, "checkaccountcode");
            return (Criteria) this;
        }
 
        public Criteria andCheckaccountcodeGreaterThan(String value) {
            addCriterion("checkAccountCode >", value, "checkaccountcode");
            return (Criteria) this;
        }
 
        public Criteria andCheckaccountcodeGreaterThanOrEqualTo(String value) {
            addCriterion("checkAccountCode >=", value, "checkaccountcode");
            return (Criteria) this;
        }
 
        public Criteria andCheckaccountcodeLessThan(String value) {
            addCriterion("checkAccountCode <", value, "checkaccountcode");
            return (Criteria) this;
        }
 
        public Criteria andCheckaccountcodeLessThanOrEqualTo(String value) {
            addCriterion("checkAccountCode <=", value, "checkaccountcode");
            return (Criteria) this;
        }
 
        public Criteria andCheckaccountcodeLike(String value) {
            addCriterion("checkAccountCode like", value, "checkaccountcode");
            return (Criteria) this;
        }
 
        public Criteria andCheckaccountcodeNotLike(String value) {
            addCriterion("checkAccountCode not like", value, "checkaccountcode");
            return (Criteria) this;
        }
 
        public Criteria andCheckaccountcodeIn(List<String> values) {
            addCriterion("checkAccountCode in", values, "checkaccountcode");
            return (Criteria) this;
        }
 
        public Criteria andCheckaccountcodeNotIn(List<String> values) {
            addCriterion("checkAccountCode not in", values, "checkaccountcode");
            return (Criteria) this;
        }
 
        public Criteria andCheckaccountcodeBetween(String value1, String value2) {
            addCriterion("checkAccountCode between", value1, value2, "checkaccountcode");
            return (Criteria) this;
        }
 
        public Criteria andCheckaccountcodeNotBetween(String value1, String value2) {
            addCriterion("checkAccountCode not between", value1, value2, "checkaccountcode");
            return (Criteria) this;
        }
 
        public Criteria andCertOrgCodeIsNull() {
            addCriterion("cert_org_code is null");
            return (Criteria) this;
        }
 
        public Criteria andCertOrgCodeIsNotNull() {
            addCriterion("cert_org_code is not null");
            return (Criteria) this;
        }
 
        public Criteria andCertOrgCodeEqualTo(String value) {
            addCriterion("cert_org_code =", value, "certOrgCode");
            return (Criteria) this;
        }
 
        public Criteria andCertOrgCodeNotEqualTo(String value) {
            addCriterion("cert_org_code <>", value, "certOrgCode");
            return (Criteria) this;
        }
 
        public Criteria andCertOrgCodeGreaterThan(String value) {
            addCriterion("cert_org_code >", value, "certOrgCode");
            return (Criteria) this;
        }
 
        public Criteria andCertOrgCodeGreaterThanOrEqualTo(String value) {
            addCriterion("cert_org_code >=", value, "certOrgCode");
            return (Criteria) this;
        }
 
        public Criteria andCertOrgCodeLessThan(String value) {
            addCriterion("cert_org_code <", value, "certOrgCode");
            return (Criteria) this;
        }
 
        public Criteria andCertOrgCodeLessThanOrEqualTo(String value) {
            addCriterion("cert_org_code <=", value, "certOrgCode");
            return (Criteria) this;
        }
 
        public Criteria andCertOrgCodeLike(String value) {
            addCriterion("cert_org_code like", value, "certOrgCode");
            return (Criteria) this;
        }
 
        public Criteria andCertOrgCodeNotLike(String value) {
            addCriterion("cert_org_code not like", value, "certOrgCode");
            return (Criteria) this;
        }
 
        public Criteria andCertOrgCodeIn(List<String> values) {
            addCriterion("cert_org_code in", values, "certOrgCode");
            return (Criteria) this;
        }
 
        public Criteria andCertOrgCodeNotIn(List<String> values) {
            addCriterion("cert_org_code not in", values, "certOrgCode");
            return (Criteria) this;
        }
 
        public Criteria andCertOrgCodeBetween(String value1, String value2) {
            addCriterion("cert_org_code between", value1, value2, "certOrgCode");
            return (Criteria) this;
        }
 
        public Criteria andCertOrgCodeNotBetween(String value1, String value2) {
            addCriterion("cert_org_code not between", value1, value2, "certOrgCode");
            return (Criteria) this;
        }
 
        public Criteria andPrgPhotoIsNull() {
            addCriterion("prg_photo is null");
            return (Criteria) this;
        }
 
        public Criteria andPrgPhotoIsNotNull() {
            addCriterion("prg_photo is not null");
            return (Criteria) this;
        }
 
        public Criteria andPrgPhotoEqualTo(String value) {
            addCriterion("prg_photo =", value, "prgPhoto");
            return (Criteria) this;
        }
 
        public Criteria andPrgPhotoNotEqualTo(String value) {
            addCriterion("prg_photo <>", value, "prgPhoto");
            return (Criteria) this;
        }
 
        public Criteria andPrgPhotoGreaterThan(String value) {
            addCriterion("prg_photo >", value, "prgPhoto");
            return (Criteria) this;
        }
 
        public Criteria andPrgPhotoGreaterThanOrEqualTo(String value) {
            addCriterion("prg_photo >=", value, "prgPhoto");
            return (Criteria) this;
        }
 
        public Criteria andPrgPhotoLessThan(String value) {
            addCriterion("prg_photo <", value, "prgPhoto");
            return (Criteria) this;
        }
 
        public Criteria andPrgPhotoLessThanOrEqualTo(String value) {
            addCriterion("prg_photo <=", value, "prgPhoto");
            return (Criteria) this;
        }
 
        public Criteria andPrgPhotoLike(String value) {
            addCriterion("prg_photo like", value, "prgPhoto");
            return (Criteria) this;
        }
 
        public Criteria andPrgPhotoNotLike(String value) {
            addCriterion("prg_photo not like", value, "prgPhoto");
            return (Criteria) this;
        }
 
        public Criteria andPrgPhotoIn(List<String> values) {
            addCriterion("prg_photo in", values, "prgPhoto");
            return (Criteria) this;
        }
 
        public Criteria andPrgPhotoNotIn(List<String> values) {
            addCriterion("prg_photo not in", values, "prgPhoto");
            return (Criteria) this;
        }
 
        public Criteria andPrgPhotoBetween(String value1, String value2) {
            addCriterion("prg_photo between", value1, value2, "prgPhoto");
            return (Criteria) this;
        }
 
        public Criteria andPrgPhotoNotBetween(String value1, String value2) {
            addCriterion("prg_photo not between", value1, value2, "prgPhoto");
            return (Criteria) this;
        }
 
        public Criteria andMccIsNull() {
            addCriterion("mcc is null");
            return (Criteria) this;
        }
 
        public Criteria andMccIsNotNull() {
            addCriterion("mcc is not null");
            return (Criteria) this;
        }
 
        public Criteria andMccEqualTo(String value) {
            addCriterion("mcc =", value, "mcc");
            return (Criteria) this;
        }
 
        public Criteria andMccNotEqualTo(String value) {
            addCriterion("mcc <>", value, "mcc");
            return (Criteria) this;
        }
 
        public Criteria andMccGreaterThan(String value) {
            addCriterion("mcc >", value, "mcc");
            return (Criteria) this;
        }
 
        public Criteria andMccGreaterThanOrEqualTo(String value) {
            addCriterion("mcc >=", value, "mcc");
            return (Criteria) this;
        }
 
        public Criteria andMccLessThan(String value) {
            addCriterion("mcc <", value, "mcc");
            return (Criteria) this;
        }
 
        public Criteria andMccLessThanOrEqualTo(String value) {
            addCriterion("mcc <=", value, "mcc");
            return (Criteria) this;
        }
 
        public Criteria andMccLike(String value) {
            addCriterion("mcc like", value, "mcc");
            return (Criteria) this;
        }
 
        public Criteria andMccNotLike(String value) {
            addCriterion("mcc not like", value, "mcc");
            return (Criteria) this;
        }
 
        public Criteria andMccIn(List<String> values) {
            addCriterion("mcc in", values, "mcc");
            return (Criteria) this;
        }
 
        public Criteria andMccNotIn(List<String> values) {
            addCriterion("mcc not in", values, "mcc");
            return (Criteria) this;
        }
 
        public Criteria andMccBetween(String value1, String value2) {
            addCriterion("mcc between", value1, value2, "mcc");
            return (Criteria) this;
        }
 
        public Criteria andMccNotBetween(String value1, String value2) {
            addCriterion("mcc not between", value1, value2, "mcc");
            return (Criteria) this;
        }
 
        public Criteria andDealTypeIsNull() {
            addCriterion("deal_type is null");
            return (Criteria) this;
        }
 
        public Criteria andDealTypeIsNotNull() {
            addCriterion("deal_type is not null");
            return (Criteria) this;
        }
 
        public Criteria andDealTypeEqualTo(Byte value) {
            addCriterion("deal_type =", value, "dealType");
            return (Criteria) this;
        }
 
        public Criteria andDealTypeNotEqualTo(Byte value) {
            addCriterion("deal_type <>", value, "dealType");
            return (Criteria) this;
        }
 
        public Criteria andDealTypeGreaterThan(Byte value) {
            addCriterion("deal_type >", value, "dealType");
            return (Criteria) this;
        }
 
        public Criteria andDealTypeGreaterThanOrEqualTo(Byte value) {
            addCriterion("deal_type >=", value, "dealType");
            return (Criteria) this;
        }
 
        public Criteria andDealTypeLessThan(Byte value) {
            addCriterion("deal_type <", value, "dealType");
            return (Criteria) this;
        }
 
        public Criteria andDealTypeLessThanOrEqualTo(Byte value) {
            addCriterion("deal_type <=", value, "dealType");
            return (Criteria) this;
        }
 
        public Criteria andDealTypeIn(List<Byte> values) {
            addCriterion("deal_type in", values, "dealType");
            return (Criteria) this;
        }
 
        public Criteria andDealTypeNotIn(List<Byte> values) {
            addCriterion("deal_type not in", values, "dealType");
            return (Criteria) this;
        }
 
        public Criteria andDealTypeBetween(Byte value1, Byte value2) {
            addCriterion("deal_type between", value1, value2, "dealType");
            return (Criteria) this;
        }
 
        public Criteria andDealTypeNotBetween(Byte value1, Byte value2) {
            addCriterion("deal_type not between", value1, value2, "dealType");
            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);
        }
    }
}

ShopLicenceEntityMapper接口：

package test.cn.mwee.service.shop.mapper.restaurant;
 
import test.cn.mwee.service.entity.restaurant.ShopLicenceEntity;
import test.cn.mwee.service.entity.restaurant.ShopLicenceEntityExample;
import tk.mybatis.mapper.common.Mapper;
 
public interface ShopLicenceEntityMapper extends Mapper<ShopLicenceEntity> {
    int countByExample(ShopLicenceEntityExample example);
}

ShopLicenceEntityMapper.xml配置（未给出）