MyBatis中mybatis-generator代码生成的一般过程
2024-10-13 19:51:27
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配置（未给出）
最新文章
- sql SYS对象集合
- java基础算法之冒泡排序
- swift 动手写网络请求封装（仿照了一个大神的）不用导入第三方
- Java设置环境变量的含义（JAVA_HOME，PATH，CLASSPATH）
- spl_autoload_register更改框架文件引用模式
- Quantum & r2q
- jQuery 添加元素和删除元素
- 【BZOJ 1045】 1045: [HAOI2008] 糖果传递
- 设计模式之（三）Proxy模式
- jquery 插件JTable使用
- Codeforces Round #312 (Div. 2) C.Amr and Chemistry
- MD5 .net与PHP加密值一样的加密代码
- RedLock.Net - 基于Redis分布式锁的开源实现
- Runnable和Callable接口辨析
- html 表格边线设置
- Git使用四：查看工作状态和历史提交
- No mapping found for HTTP request with URI [/webapp/] in DispatcherServlet with name 'SpringMVC'
- 347. Top K Frequent Elements 最常用的k个元素
- 【03月04日】A股滚动市盈率PE历史新低排名
- val和var和Java