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&zeroDateTimeBehavior=convertToNull&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配置: