package com.huimv.sj.dataobject; import java.math.BigDecimal; import java.util.ArrayList; import java.util.Date; import java.util.HashMap; import java.util.List; import java.util.Map; public class SjLrbExample { /** * This field was generated by Apache iBATIS ibator. * This field corresponds to the database table sj_lrb * * @ibatorgenerated Mon Jun 30 15:15:59 CST 2014 */ protected String orderByClause; /** * This field was generated by Apache iBATIS ibator. * This field corresponds to the database table sj_lrb * * @ibatorgenerated Mon Jun 30 15:15:59 CST 2014 */ protected List oredCriteria; /** * This field was generated by Apache iBATIS ibator. * This field corresponds to the database table sj_lrb * * @ibatorgenerated Mon Jun 30 15:15:59 CST 2014 */ protected int start = -1; /** * This field was generated by Apache iBATIS ibator. * This field corresponds to the database table sj_lrb * * @ibatorgenerated Mon Jun 30 15:15:59 CST 2014 */ protected int limit = -1; /** * This method was generated by Apache iBATIS ibator. * This method corresponds to the database table sj_lrb * * @ibatorgenerated Mon Jun 30 15:15:59 CST 2014 */ public SjLrbExample() { oredCriteria = new ArrayList(); } /** * This method was generated by Apache iBATIS ibator. * This method corresponds to the database table sj_lrb * * @ibatorgenerated Mon Jun 30 15:15:59 CST 2014 */ protected SjLrbExample(SjLrbExample example) { this.orderByClause = example.orderByClause; this.oredCriteria = example.oredCriteria; } /** * This method was generated by Apache iBATIS ibator. * This method corresponds to the database table sj_lrb * * @ibatorgenerated Mon Jun 30 15:15:59 CST 2014 */ public void setOrderByClause(String orderByClause) { this.orderByClause = orderByClause; } /** * This method was generated by Apache iBATIS ibator. * This method corresponds to the database table sj_lrb * * @ibatorgenerated Mon Jun 30 15:15:59 CST 2014 */ public String getOrderByClause() { return orderByClause; } /** * This method was generated by Apache iBATIS ibator. * This method corresponds to the database table sj_lrb * * @ibatorgenerated Mon Jun 30 15:15:59 CST 2014 */ public List getOredCriteria() { return oredCriteria; } /** * This method was generated by Apache iBATIS ibator. * This method corresponds to the database table sj_lrb * * @ibatorgenerated Mon Jun 30 15:15:59 CST 2014 */ public void or(Criteria criteria) { oredCriteria.add(criteria); } /** * This method was generated by Apache iBATIS ibator. * This method corresponds to the database table sj_lrb * * @ibatorgenerated Mon Jun 30 15:15:59 CST 2014 */ public Criteria createCriteria() { Criteria criteria = createCriteriaInternal(); if (oredCriteria.size() == 0) { oredCriteria.add(criteria); } return criteria; } /** * This method was generated by Apache iBATIS ibator. * This method corresponds to the database table sj_lrb * * @ibatorgenerated Mon Jun 30 15:15:59 CST 2014 */ protected Criteria createCriteriaInternal() { Criteria criteria = new Criteria(); return criteria; } /** * This method was generated by Apache iBATIS ibator. * This method corresponds to the database table sj_lrb * * @ibatorgenerated Mon Jun 30 15:15:59 CST 2014 */ public void clear() { oredCriteria.clear(); } /** * This method was generated by Apache iBATIS ibator. * This method corresponds to the database table sj_lrb * * @ibatorgenerated Mon Jun 30 15:15:59 CST 2014 */ public void setStart(int start) { this.start=start; } /** * This method was generated by Apache iBATIS ibator. * This method corresponds to the database table sj_lrb * * @ibatorgenerated Mon Jun 30 15:15:59 CST 2014 */ public int getStart() { return start; } /** * This method was generated by Apache iBATIS ibator. * This method corresponds to the database table sj_lrb * * @ibatorgenerated Mon Jun 30 15:15:59 CST 2014 */ public void setLimit(int limit) { this.limit=limit; } /** * This method was generated by Apache iBATIS ibator. * This method corresponds to the database table sj_lrb * * @ibatorgenerated Mon Jun 30 15:15:59 CST 2014 */ public int getLimit() { return limit; } /** * This class was generated by Apache iBATIS ibator. * This class corresponds to the database table sj_lrb * * @ibatorgenerated Mon Jun 30 15:15:59 CST 2014 */ public static class Criteria { protected List criteriaWithoutValue; protected List> criteriaWithSingleValue; protected List> criteriaWithListValue; protected List> criteriaWithBetweenValue; protected Criteria() { super(); criteriaWithoutValue = new ArrayList(); criteriaWithSingleValue = new ArrayList>(); criteriaWithListValue = new ArrayList>(); criteriaWithBetweenValue = new ArrayList>(); } public boolean isValid() { return criteriaWithoutValue.size() > 0 || criteriaWithSingleValue.size() > 0 || criteriaWithListValue.size() > 0 || criteriaWithBetweenValue.size() > 0; } public List getCriteriaWithoutValue() { return criteriaWithoutValue; } public List> getCriteriaWithSingleValue() { return criteriaWithSingleValue; } public List> getCriteriaWithListValue() { return criteriaWithListValue; } public List> getCriteriaWithBetweenValue() { return criteriaWithBetweenValue; } protected void addCriterion(String condition) { if (condition == null) { throw new RuntimeException("Value for condition cannot be null"); } criteriaWithoutValue.add(condition); } protected void addCriterion(String condition, Object value, String property) { if (value == null) { throw new RuntimeException("Value for " + property + " cannot be null"); } Map map = new HashMap(); map.put("condition", condition); map.put("value", value); criteriaWithSingleValue.add(map); } protected void addCriterion(String condition, List values, String property) { if (values == null || values.size() == 0) { throw new RuntimeException("Value list for " + property + " cannot be null or empty"); } Map map = new HashMap(); map.put("condition", condition); map.put("values", values); criteriaWithListValue.add(map); } protected void addCriterion(String condition, Object value1, Object value2, String property) { if (value1 == null || value2 == null) { throw new RuntimeException("Between values for " + property + " cannot be null"); } List list = new ArrayList(); list.add(value1); list.add(value2); Map map = new HashMap(); map.put("condition", condition); map.put("values", list); criteriaWithBetweenValue.add(map); } public Criteria andIdIsNull() { addCriterion("ID is null"); return this; } public Criteria andIdIsNotNull() { addCriterion("ID is not null"); return this; } public Criteria andIdEqualTo(Integer value) { addCriterion("ID =", value, "id"); return this; } public Criteria andIdNotEqualTo(Integer value) { addCriterion("ID <>", value, "id"); return this; } public Criteria andIdGreaterThan(Integer value) { addCriterion("ID >", value, "id"); return this; } public Criteria andIdGreaterThanOrEqualTo(Integer value) { addCriterion("ID >=", value, "id"); return this; } public Criteria andIdLessThan(Integer value) { addCriterion("ID <", value, "id"); return this; } public Criteria andIdLessThanOrEqualTo(Integer value) { addCriterion("ID <=", value, "id"); return this; } public Criteria andIdIn(List values) { addCriterion("ID in", values, "id"); return this; } public Criteria andIdNotIn(List values) { addCriterion("ID not in", values, "id"); return this; } public Criteria andIdBetween(Integer value1, Integer value2) { addCriterion("ID between", value1, value2, "id"); return this; } public Criteria andIdNotBetween(Integer value1, Integer value2) { addCriterion("ID not between", value1, value2, "id"); return this; } public Criteria andLqidIsNull() { addCriterion("LQID is null"); return this; } public Criteria andLqidIsNotNull() { addCriterion("LQID is not null"); return this; } public Criteria andLqidEqualTo(Integer value) { addCriterion("LQID =", value, "lqid"); return this; } public Criteria andLqidNotEqualTo(Integer value) { addCriterion("LQID <>", value, "lqid"); return this; } public Criteria andLqidGreaterThan(Integer value) { addCriterion("LQID >", value, "lqid"); return this; } public Criteria andLqidGreaterThanOrEqualTo(Integer value) { addCriterion("LQID >=", value, "lqid"); return this; } public Criteria andLqidLessThan(Integer value) { addCriterion("LQID <", value, "lqid"); return this; } public Criteria andLqidLessThanOrEqualTo(Integer value) { addCriterion("LQID <=", value, "lqid"); return this; } public Criteria andLqidIn(List values) { addCriterion("LQID in", values, "lqid"); return this; } public Criteria andLqidNotIn(List values) { addCriterion("LQID not in", values, "lqid"); return this; } public Criteria andLqidBetween(Integer value1, Integer value2) { addCriterion("LQID between", value1, value2, "lqid"); return this; } public Criteria andLqidNotBetween(Integer value1, Integer value2) { addCriterion("LQID not between", value1, value2, "lqid"); return this; } public Criteria andJsmsIsNull() { addCriterion("JSMS is null"); return this; } public Criteria andJsmsIsNotNull() { addCriterion("JSMS is not null"); return this; } public Criteria andJsmsEqualTo(String value) { addCriterion("JSMS =", value, "jsms"); return this; } public Criteria andJsmsNotEqualTo(String value) { addCriterion("JSMS <>", value, "jsms"); return this; } public Criteria andJsmsGreaterThan(String value) { addCriterion("JSMS >", value, "jsms"); return this; } public Criteria andJsmsGreaterThanOrEqualTo(String value) { addCriterion("JSMS >=", value, "jsms"); return this; } public Criteria andJsmsLessThan(String value) { addCriterion("JSMS <", value, "jsms"); return this; } public Criteria andJsmsLessThanOrEqualTo(String value) { addCriterion("JSMS <=", value, "jsms"); return this; } public Criteria andJsmsLike(String value) { addCriterion("JSMS like", value, "jsms"); return this; } public Criteria andJsmsNotLike(String value) { addCriterion("JSMS not like", value, "jsms"); return this; } public Criteria andJsmsIn(List values) { addCriterion("JSMS in", values, "jsms"); return this; } public Criteria andJsmsNotIn(List values) { addCriterion("JSMS not in", values, "jsms"); return this; } public Criteria andJsmsBetween(String value1, String value2) { addCriterion("JSMS between", value1, value2, "jsms"); return this; } public Criteria andJsmsNotBetween(String value1, String value2) { addCriterion("JSMS not between", value1, value2, "jsms"); return this; } public Criteria andZtlrbIsNull() { addCriterion("ZTLRB is null"); return this; } public Criteria andZtlrbIsNotNull() { addCriterion("ZTLRB is not null"); return this; } public Criteria andZtlrbEqualTo(BigDecimal value) { addCriterion("ZTLRB =", value, "ztlrb"); return this; } public Criteria andZtlrbNotEqualTo(BigDecimal value) { addCriterion("ZTLRB <>", value, "ztlrb"); return this; } public Criteria andZtlrbGreaterThan(BigDecimal value) { addCriterion("ZTLRB >", value, "ztlrb"); return this; } public Criteria andZtlrbGreaterThanOrEqualTo(BigDecimal value) { addCriterion("ZTLRB >=", value, "ztlrb"); return this; } public Criteria andZtlrbLessThan(BigDecimal value) { addCriterion("ZTLRB <", value, "ztlrb"); return this; } public Criteria andZtlrbLessThanOrEqualTo(BigDecimal value) { addCriterion("ZTLRB <=", value, "ztlrb"); return this; } public Criteria andZtlrbIn(List values) { addCriterion("ZTLRB in", values, "ztlrb"); return this; } public Criteria andZtlrbNotIn(List values) { addCriterion("ZTLRB not in", values, "ztlrb"); return this; } public Criteria andZtlrbBetween(BigDecimal value1, BigDecimal value2) { addCriterion("ZTLRB between", value1, value2, "ztlrb"); return this; } public Criteria andZtlrbNotBetween(BigDecimal value1, BigDecimal value2) { addCriterion("ZTLRB not between", value1, value2, "ztlrb"); return this; } public Criteria andCsq1lrbIsNull() { addCriterion("CSQ1LRB is null"); return this; } public Criteria andCsq1lrbIsNotNull() { addCriterion("CSQ1LRB is not null"); return this; } public Criteria andCsq1lrbEqualTo(BigDecimal value) { addCriterion("CSQ1LRB =", value, "csq1lrb"); return this; } public Criteria andCsq1lrbNotEqualTo(BigDecimal value) { addCriterion("CSQ1LRB <>", value, "csq1lrb"); return this; } public Criteria andCsq1lrbGreaterThan(BigDecimal value) { addCriterion("CSQ1LRB >", value, "csq1lrb"); return this; } public Criteria andCsq1lrbGreaterThanOrEqualTo(BigDecimal value) { addCriterion("CSQ1LRB >=", value, "csq1lrb"); return this; } public Criteria andCsq1lrbLessThan(BigDecimal value) { addCriterion("CSQ1LRB <", value, "csq1lrb"); return this; } public Criteria andCsq1lrbLessThanOrEqualTo(BigDecimal value) { addCriterion("CSQ1LRB <=", value, "csq1lrb"); return this; } public Criteria andCsq1lrbIn(List values) { addCriterion("CSQ1LRB in", values, "csq1lrb"); return this; } public Criteria andCsq1lrbNotIn(List values) { addCriterion("CSQ1LRB not in", values, "csq1lrb"); return this; } public Criteria andCsq1lrbBetween(BigDecimal value1, BigDecimal value2) { addCriterion("CSQ1LRB between", value1, value2, "csq1lrb"); return this; } public Criteria andCsq1lrbNotBetween(BigDecimal value1, BigDecimal value2) { addCriterion("CSQ1LRB not between", value1, value2, "csq1lrb"); return this; } public Criteria andCsq2lrbIsNull() { addCriterion("CSQ2LRB is null"); return this; } public Criteria andCsq2lrbIsNotNull() { addCriterion("CSQ2LRB is not null"); return this; } public Criteria andCsq2lrbEqualTo(BigDecimal value) { addCriterion("CSQ2LRB =", value, "csq2lrb"); return this; } public Criteria andCsq2lrbNotEqualTo(BigDecimal value) { addCriterion("CSQ2LRB <>", value, "csq2lrb"); return this; } public Criteria andCsq2lrbGreaterThan(BigDecimal value) { addCriterion("CSQ2LRB >", value, "csq2lrb"); return this; } public Criteria andCsq2lrbGreaterThanOrEqualTo(BigDecimal value) { addCriterion("CSQ2LRB >=", value, "csq2lrb"); return this; } public Criteria andCsq2lrbLessThan(BigDecimal value) { addCriterion("CSQ2LRB <", value, "csq2lrb"); return this; } public Criteria andCsq2lrbLessThanOrEqualTo(BigDecimal value) { addCriterion("CSQ2LRB <=", value, "csq2lrb"); return this; } public Criteria andCsq2lrbIn(List values) { addCriterion("CSQ2LRB in", values, "csq2lrb"); return this; } public Criteria andCsq2lrbNotIn(List values) { addCriterion("CSQ2LRB not in", values, "csq2lrb"); return this; } public Criteria andCsq2lrbBetween(BigDecimal value1, BigDecimal value2) { addCriterion("CSQ2LRB between", value1, value2, "csq2lrb"); return this; } public Criteria andCsq2lrbNotBetween(BigDecimal value1, BigDecimal value2) { addCriterion("CSQ2LRB not between", value1, value2, "csq2lrb"); return this; } public Criteria andGlqlrbIsNull() { addCriterion("GLQLRB is null"); return this; } public Criteria andGlqlrbIsNotNull() { addCriterion("GLQLRB is not null"); return this; } public Criteria andGlqlrbEqualTo(BigDecimal value) { addCriterion("GLQLRB =", value, "glqlrb"); return this; } public Criteria andGlqlrbNotEqualTo(BigDecimal value) { addCriterion("GLQLRB <>", value, "glqlrb"); return this; } public Criteria andGlqlrbGreaterThan(BigDecimal value) { addCriterion("GLQLRB >", value, "glqlrb"); return this; } public Criteria andGlqlrbGreaterThanOrEqualTo(BigDecimal value) { addCriterion("GLQLRB >=", value, "glqlrb"); return this; } public Criteria andGlqlrbLessThan(BigDecimal value) { addCriterion("GLQLRB <", value, "glqlrb"); return this; } public Criteria andGlqlrbLessThanOrEqualTo(BigDecimal value) { addCriterion("GLQLRB <=", value, "glqlrb"); return this; } public Criteria andGlqlrbIn(List values) { addCriterion("GLQLRB in", values, "glqlrb"); return this; } public Criteria andGlqlrbNotIn(List values) { addCriterion("GLQLRB not in", values, "glqlrb"); return this; } public Criteria andGlqlrbBetween(BigDecimal value1, BigDecimal value2) { addCriterion("GLQLRB between", value1, value2, "glqlrb"); return this; } public Criteria andGlqlrbNotBetween(BigDecimal value1, BigDecimal value2) { addCriterion("GLQLRB not between", value1, value2, "glqlrb"); return this; } public Criteria andTjsjIsNull() { addCriterion("TJSJ is null"); return this; } public Criteria andTjsjIsNotNull() { addCriterion("TJSJ is not null"); return this; } public Criteria andTjsjEqualTo(Date value) { addCriterion("TJSJ =", value, "tjsj"); return this; } public Criteria andTjsjNotEqualTo(Date value) { addCriterion("TJSJ <>", value, "tjsj"); return this; } public Criteria andTjsjGreaterThan(Date value) { addCriterion("TJSJ >", value, "tjsj"); return this; } public Criteria andTjsjGreaterThanOrEqualTo(Date value) { addCriterion("TJSJ >=", value, "tjsj"); return this; } public Criteria andTjsjLessThan(Date value) { addCriterion("TJSJ <", value, "tjsj"); return this; } public Criteria andTjsjLessThanOrEqualTo(Date value) { addCriterion("TJSJ <=", value, "tjsj"); return this; } public Criteria andTjsjIn(List values) { addCriterion("TJSJ in", values, "tjsj"); return this; } public Criteria andTjsjNotIn(List values) { addCriterion("TJSJ not in", values, "tjsj"); return this; } public Criteria andTjsjBetween(Date value1, Date value2) { addCriterion("TJSJ between", value1, value2, "tjsj"); return this; } public Criteria andTjsjNotBetween(Date value1, Date value2) { addCriterion("TJSJ not between", value1, value2, "tjsj"); return this; } public Criteria andYwebIsNull() { addCriterion("yweb is null"); return this; } public Criteria andYwebIsNotNull() { addCriterion("yweb is not null"); return this; } public Criteria andYwebEqualTo(Integer value) { addCriterion("yweb =", value, "yweb"); return this; } public Criteria andYwebNotEqualTo(Integer value) { addCriterion("yweb <>", value, "yweb"); return this; } public Criteria andYwebGreaterThan(Integer value) { addCriterion("yweb >", value, "yweb"); return this; } public Criteria andYwebGreaterThanOrEqualTo(Integer value) { addCriterion("yweb >=", value, "yweb"); return this; } public Criteria andYwebLessThan(Integer value) { addCriterion("yweb <", value, "yweb"); return this; } public Criteria andYwebLessThanOrEqualTo(Integer value) { addCriterion("yweb <=", value, "yweb"); return this; } public Criteria andYwebIn(List values) { addCriterion("yweb in", values, "yweb"); return this; } public Criteria andYwebNotIn(List values) { addCriterion("yweb not in", values, "yweb"); return this; } public Criteria andYwebBetween(Integer value1, Integer value2) { addCriterion("yweb between", value1, value2, "yweb"); return this; } public Criteria andYwebNotBetween(Integer value1, Integer value2) { addCriterion("yweb not between", value1, value2, "yweb"); return this; } } }