使用mybatis plus快速生成sql

package org.example.mythymeleaf.bean; import java.util.ArrayList; import java.util.Date; import java.util.List; public class AdvertiseExample { protected String orderByClause; protected boolean distinct; protected List<Criteria> oredCriteria; public AdvertiseExample() { oredCriteria = new ArrayList<>(); } 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<>(); } 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 andIdIsNull() { addCriterion("id is null"); return (Criteria) this; } public Criteria andIdIsNotNull() { addCriterion("id is not null"); return (Criteria) this; } public Criteria andIdEqualTo(Long value) { addCriterion("id =", value, "id"); return (Criteria) this; } public Criteria andIdNotEqualTo(Long value) { addCriterion("id <>", value, "id"); return (Criteria) this; } public Criteria andIdGreaterThan(Long value) { addCriterion("id >", value, "id"); return (Criteria) this; } public Criteria andIdGreaterThanOrEqualTo(Long value) { addCriterion("id >=", value, "id"); return (Criteria) this; } public Criteria andIdLessThan(Long value) { addCriterion("id <", value, "id"); return (Criteria) this; } public Criteria andIdLessThanOrEqualTo(Long value) { addCriterion("id <=", value, "id"); return (Criteria) this; } public Criteria andIdIn(List<Long> values) { addCriterion("id in", values, "id"); return (Criteria) this; } public Criteria andIdNotIn(List<Long> values) { addCriterion("id not in", values, "id"); return (Criteria) this; } public Criteria andIdBetween(Long value1, Long value2) { addCriterion("id between", value1, value2, "id"); return (Criteria) this; } public Criteria andIdNotBetween(Long value1, Long value2) { addCriterion("id not between", value1, value2, "id"); return (Criteria) this; } public Criteria andAdnameIsNull() { addCriterion("adName is null"); return (Criteria) this; } public Criteria andAdnameIsNotNull() { addCriterion("adName is not null"); return (Criteria) this; } public Criteria andAdnameEqualTo(String value) { addCriterion("adName =", value, "adname"); return (Criteria) this; } public Criteria andAdnameNotEqualTo(String value) { addCriterion("adName <>", value, "adname"); return (Criteria) this; } public Criteria andAdnameGreaterThan(String value) { addCriterion("adName >", value, "adname"); return (Criteria) this; } public Criteria andAdnameGreaterThanOrEqualTo(String value) { addCriterion("adName >=", value, "adname"); return (Criteria) this; } public Criteria andAdnameLessThan(String value) { addCriterion("adName <", value, "adname"); return (Criteria) this; } public Criteria andAdnameLessThanOrEqualTo(String value) { addCriterion("adName <=", value, "adname"); return (Criteria) this; } public Criteria andAdnameLike(String value) { addCriterion("adName like", value, "adname"); return (Criteria) this; } public Criteria andAdnameNotLike(String value) { addCriterion("adName not like", value, "adname"); return (Criteria) this; } public Criteria andAdnameIn(List<String> values) { addCriterion("adName in", values, "adname"); return (Criteria) this; } public Criteria andAdnameNotIn(List<String> values) { addCriterion("adName not in", values, "adname"); return (Criteria) this; } public Criteria andAdnameBetween(String value1, String value2) { addCriterion("adName between", value1, value2, "adname"); return (Criteria) this; } public Criteria andAdnameNotBetween(String value1, String value2) { addCriterion("adName not between", value1, value2, "adname"); return (Criteria) this; } public Criteria andMerCodeIsNull() { addCriterion("mer_code is null"); return (Criteria) this; } public Criteria andMerCodeIsNotNull() { addCriterion("mer_code is not null"); return (Criteria) this; } public Criteria andMerCodeEqualTo(String value) { addCriterion("mer_code =", value, "merCode"); return (Criteria) this; } public Criteria andMerCodeNotEqualTo(String value) { addCriterion("mer_code <>", value, "merCode"); return (Criteria) this; } public Criteria andMerCodeGreaterThan(String value) { addCriterion("mer_code >", value, "merCode"); return (Criteria) this; }