/* * Copyright 2010 The YAPULAN Software Foundation * * Licensed under the YAPULAN License, Version 2.0 (the "License"); */ package com.miniframe.system.model; import java.util.ArrayList; import java.util.HashMap; import java.util.List; import java.util.Map; /** * 标准数据类型 : 标准数据类型 * @generated */ public class SysAppcodeSQLBuilder { /** * 标准数据类型 : 标准数据类型 * @generated */ protected String orderByClause; /** * 标准数据类型 : 标准数据类型 * @generated */ protected boolean distinct; /** * 标准数据类型 : 标准数据类型 * @generated */ protected boolean NoWait; /** * 标准数据类型 : 标准数据类型 * @generated */ protected boolean forUpdate; /** * 标准数据类型 : 标准数据类型 * @generated */ protected List oredCriteria; /** * 标准数据类型 : 标准数据类型 * @generated */ private Integer oracleStart; /** * 标准数据类型 : 标准数据类型 * @generated */ private Integer oracleEnd; /** * 标准数据类型 : 标准数据类型 * @generated */ private Integer startOffSet; /** * 标准数据类型 : 标准数据类型 * @generated */ private Integer pageSize; /** * @generated */ public SysAppcodeSQLBuilder() { oredCriteria = new ArrayList(); } /** * @generated */ protected SysAppcodeSQLBuilder(SysAppcodeSQLBuilder example) { this.orderByClause = example.orderByClause; this.oredCriteria = example.oredCriteria; this.distinct = example.distinct; this.forUpdate = example.forUpdate; this.NoWait = example.NoWait; } /** * 设置排序 * @generated */ public void setOrderByClause(String orderByClause) { this.orderByClause = orderByClause; } /** * 获取排序 * @generated */ public String getOrderByClause() { return orderByClause; } /** * 设置是否过滤重复 * @generated */ public void setDistinct(boolean distinct) { this.distinct = distinct; } /** * 获取是否过滤重复 * @generated */ public boolean isDistinct() { return distinct; } /** * 设置是否上锁是否不等待 * @generated */ public void setNoWait(boolean NoWait) { this.NoWait = NoWait; } /** * 设置是否上锁是否不等待 * @generated */ public boolean isNoWait() { return NoWait; } /** * 设置是否行锁定 * @generated */ public void setForUpdate(boolean forUpdate) { this.forUpdate = forUpdate; } /** * 获取是否行锁定 * @generated */ public boolean isForUpdate() { return forUpdate; } /** * @generated */ public List getOredCriteria() { return oredCriteria; } /** * @generated */ public void or(Criteria criteria) { oredCriteria.add(criteria); } /** * 或 * @generated */ public Criteria or() { Criteria criteria = createCriteriaInternal(); oredCriteria.add(criteria); return criteria; } /** * @generated */ public Criteria createCriteria() { Criteria criteria = createCriteriaInternal(); if (oredCriteria.size() == 0) { oredCriteria.add(criteria); } return criteria; } /** * @generated */ protected Criteria createCriteriaInternal() { Criteria criteria = new Criteria(); return criteria; } /** * 清除 * @generated */ public void clear() { oredCriteria.clear(); orderByClause = null; distinct = false; forUpdate = false; NoWait = false; } /** * 设置开始行,从1开始 * @generated */ public void setOracleStart(Integer oracleStart) { this.oracleStart = oracleStart; this.startOffSet = this.oracleStart - 1; if(this.oracleEnd!=null){ this.pageSize = this.oracleEnd - this.oracleStart + 1; } } /** * 获取开始行,从1开始 * @generated */ public Integer getOracleStart() { return oracleStart; } /** * 设置结束行 * @generated */ public void setOracleEnd(Integer oracleEnd) { if(this.oracleStart==null){ this.oracleStart =1; this.startOffSet =0; } this.oracleEnd = oracleEnd; this.pageSize = this.oracleEnd - this.oracleStart + 1; } /** * 获取结束行 * @generated */ public Integer getOracleEnd() { return oracleEnd; } /** * 设置偏移量,从0开始 * @generated */ public void setStartOffSet(Integer startOffSet) { this.startOffSet = startOffSet; this.oracleStart = this.startOffSet + 1; if(this.pageSize!=null){ this.oracleEnd = this.oracleStart - 1 + this.pageSize; } } /** * 获取偏移量,从0开始 * @generated */ public Integer getStartOffSet() { return startOffSet; } /** * 设置页尺寸 * @generated */ public void setPageSize(Integer pageSize) { if(this.oracleStart==null){ this.oracleStart =1; this.startOffSet =0; } this.pageSize = pageSize; this.oracleEnd = this.pageSize + this.oracleStart - 1; } /** * 获取页尺寸 * @generated */ public Integer getPageSize() { return pageSize; } /** * 标准数据类型 : 标准数据类型 * @generated */ protected abstract static class GeneratedCriteria { /** * 标准数据类型 : 标准数据类型 * @generated */ protected List criteriaWithoutValue; /** * 标准数据类型 : 标准数据类型 * @generated */ protected List> criteriaWithSingleValue; /** * 标准数据类型 : 标准数据类型 * @generated */ protected List> criteriaWithListValue; /** * 标准数据类型 : 标准数据类型 * @generated */ protected List> criteriaWithBetweenValue; /** * @generated */ protected GeneratedCriteria() { super(); criteriaWithoutValue = new ArrayList(); criteriaWithSingleValue = new ArrayList>(); criteriaWithListValue = new ArrayList>(); criteriaWithBetweenValue = new ArrayList>(); } /** * 验证 * @generated */ public boolean isValid() { return criteriaWithoutValue.size() > 0 || criteriaWithSingleValue.size() > 0 || criteriaWithListValue.size() > 0 || criteriaWithBetweenValue.size() > 0; } /** * @generated */ public List getCriteriaWithoutValue() { return criteriaWithoutValue; } /** * @generated */ public void setCriteriaWithoutValue(List criteriaWithoutValue) { this.criteriaWithoutValue = criteriaWithoutValue; } /** * @generated */ public List> getCriteriaWithSingleValue() { return criteriaWithSingleValue; } /** * @generated */ public void setCriteriaWithSingleValue(List> criteriaWithSingleValue) { this.criteriaWithSingleValue = criteriaWithSingleValue; } /** * @generated */ public List> getCriteriaWithListValue() { return criteriaWithListValue; } /** * @generated */ public void setCriteriaWithListValue(List> criteriaWithListValue) { this.criteriaWithListValue = criteriaWithListValue; } /** * @generated */ public List> getCriteriaWithBetweenValue() { return criteriaWithBetweenValue; } /** * @generated */ public void setCriteriaWithBetweenValue(List> criteriaWithBetweenValue) { this.criteriaWithBetweenValue = criteriaWithBetweenValue; } /** * @generated */ public void whereSQL(String condition) { if (condition == null) { throw new RuntimeException("Value for condition cannot be null"); } criteriaWithoutValue.add(condition); } /** * @generated */ protected void addCriterion(String condition) { if (condition == null) { throw new RuntimeException("Value for condition cannot be null"); } criteriaWithoutValue.add(condition); } /** * @generated */ 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); } /** * @generated */ 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); } /** * @generated */ 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); } /** * @generated */ public Criteria andCodeIdIsNull() { addCriterion("code_id is null"); return (Criteria) this; } /** * @generated */ public Criteria andCodeIdIsNotNull() { addCriterion("code_id <> ''"); return (Criteria) this; } /** * @generated */ public Criteria andCodeIdEqualTo(String value) { addCriterion("code_id =", value, "codeId"); return (Criteria) this; } /** * @generated */ public Criteria andCodeIdNotEqualTo(String value) { addCriterion("code_id <>", value, "codeId"); return (Criteria) this; } /** * @generated */ public Criteria andCodeIdGreaterThan(String value) { addCriterion("code_id >", value, "codeId"); return (Criteria) this; } /** * @generated */ public Criteria andCodeIdGreaterThanOrEqualTo(String value) { addCriterion("code_id >=", value, "codeId"); return (Criteria) this; } /** * @generated */ public Criteria andCodeIdLessThan(String value) { addCriterion("code_id <", value, "codeId"); return (Criteria) this; } /** * @generated */ public Criteria andCodeIdLessThanOrEqualTo(String value) { addCriterion("code_id <=", value, "codeId"); return (Criteria) this; } /** * @generated */ public Criteria andCodeIdLike(String value) { addCriterion("code_id like", value, "codeId"); return (Criteria) this; } /** * @generated */ public Criteria andCodeIdNotLike(String value) { addCriterion("code_id not like", value, "codeId"); return (Criteria) this; } /** * @generated */ public Criteria andCodeIdIn(List values) { addCriterion("code_id in", values, "codeId"); return (Criteria) this; } /** * @generated */ public Criteria andCodeIdNotIn(List values) { addCriterion("code_id not in", values, "codeId"); return (Criteria) this; } /** * @generated */ public Criteria andCodeIdBetween(String value1, String value2) { addCriterion("code_id between", value1, value2, "codeId"); return (Criteria) this; } /** * @generated */ public Criteria andCodeIdNotBetween(String value1, String value2) { addCriterion("code_id not between", value1, value2, "codeId"); return (Criteria) this; } /** * @generated */ public Criteria andSysidIsNull() { addCriterion("sysid is null"); return (Criteria) this; } /** * @generated */ public Criteria andSysidIsNotNull() { addCriterion("sysid <> ''"); return (Criteria) this; } /** * @generated */ public Criteria andSysidEqualTo(String value) { addCriterion("sysid =", value, "sysid"); return (Criteria) this; } /** * @generated */ public Criteria andSysidNotEqualTo(String value) { addCriterion("sysid <>", value, "sysid"); return (Criteria) this; } /** * @generated */ public Criteria andSysidGreaterThan(String value) { addCriterion("sysid >", value, "sysid"); return (Criteria) this; } /** * @generated */ public Criteria andSysidGreaterThanOrEqualTo(String value) { addCriterion("sysid >=", value, "sysid"); return (Criteria) this; } /** * @generated */ public Criteria andSysidLessThan(String value) { addCriterion("sysid <", value, "sysid"); return (Criteria) this; } /** * @generated */ public Criteria andSysidLessThanOrEqualTo(String value) { addCriterion("sysid <=", value, "sysid"); return (Criteria) this; } /** * @generated */ public Criteria andSysidLike(String value) { addCriterion("sysid like", value, "sysid"); return (Criteria) this; } /** * @generated */ public Criteria andSysidNotLike(String value) { addCriterion("sysid not like", value, "sysid"); return (Criteria) this; } /** * @generated */ public Criteria andSysidIn(List values) { addCriterion("sysid in", values, "sysid"); return (Criteria) this; } /** * @generated */ public Criteria andSysidNotIn(List values) { addCriterion("sysid not in", values, "sysid"); return (Criteria) this; } /** * @generated */ public Criteria andSysidBetween(String value1, String value2) { addCriterion("sysid between", value1, value2, "sysid"); return (Criteria) this; } /** * @generated */ public Criteria andSysidNotBetween(String value1, String value2) { addCriterion("sysid not between", value1, value2, "sysid"); return (Criteria) this; } /** * @generated */ public Criteria andCodeTypeIsNull() { addCriterion("code_type is null"); return (Criteria) this; } /** * @generated */ public Criteria andCodeTypeIsNotNull() { addCriterion("code_type <> ''"); return (Criteria) this; } /** * @generated */ public Criteria andCodeTypeEqualTo(String value) { addCriterion("code_type =", value, "codeType"); return (Criteria) this; } /** * @generated */ public Criteria andCodeTypeNotEqualTo(String value) { addCriterion("code_type <>", value, "codeType"); return (Criteria) this; } /** * @generated */ public Criteria andCodeTypeGreaterThan(String value) { addCriterion("code_type >", value, "codeType"); return (Criteria) this; } /** * @generated */ public Criteria andCodeTypeGreaterThanOrEqualTo(String value) { addCriterion("code_type >=", value, "codeType"); return (Criteria) this; } /** * @generated */ public Criteria andCodeTypeLessThan(String value) { addCriterion("code_type <", value, "codeType"); return (Criteria) this; } /** * @generated */ public Criteria andCodeTypeLessThanOrEqualTo(String value) { addCriterion("code_type <=", value, "codeType"); return (Criteria) this; } /** * @generated */ public Criteria andCodeTypeLike(String value) { addCriterion("code_type like", value, "codeType"); return (Criteria) this; } /** * @generated */ public Criteria andCodeTypeNotLike(String value) { addCriterion("code_type not like", value, "codeType"); return (Criteria) this; } /** * @generated */ public Criteria andCodeTypeIn(List values) { addCriterion("code_type in", values, "codeType"); return (Criteria) this; } /** * @generated */ public Criteria andCodeTypeNotIn(List values) { addCriterion("code_type not in", values, "codeType"); return (Criteria) this; } /** * @generated */ public Criteria andCodeTypeBetween(String value1, String value2) { addCriterion("code_type between", value1, value2, "codeType"); return (Criteria) this; } /** * @generated */ public Criteria andCodeTypeNotBetween(String value1, String value2) { addCriterion("code_type not between", value1, value2, "codeType"); return (Criteria) this; } /** * @generated */ public Criteria andCodeNameIsNull() { addCriterion("code_name is null"); return (Criteria) this; } /** * @generated */ public Criteria andCodeNameIsNotNull() { addCriterion("code_name <> ''"); return (Criteria) this; } /** * @generated */ public Criteria andCodeNameEqualTo(String value) { addCriterion("code_name =", value, "codeName"); return (Criteria) this; } /** * @generated */ public Criteria andCodeNameNotEqualTo(String value) { addCriterion("code_name <>", value, "codeName"); return (Criteria) this; } /** * @generated */ public Criteria andCodeNameGreaterThan(String value) { addCriterion("code_name >", value, "codeName"); return (Criteria) this; } /** * @generated */ public Criteria andCodeNameGreaterThanOrEqualTo(String value) { addCriterion("code_name >=", value, "codeName"); return (Criteria) this; } /** * @generated */ public Criteria andCodeNameLessThan(String value) { addCriterion("code_name <", value, "codeName"); return (Criteria) this; } /** * @generated */ public Criteria andCodeNameLessThanOrEqualTo(String value) { addCriterion("code_name <=", value, "codeName"); return (Criteria) this; } /** * @generated */ public Criteria andCodeNameLike(String value) { addCriterion("code_name like", value, "codeName"); return (Criteria) this; } /** * @generated */ public Criteria andCodeNameNotLike(String value) { addCriterion("code_name not like", value, "codeName"); return (Criteria) this; } /** * @generated */ public Criteria andCodeNameIn(List values) { addCriterion("code_name in", values, "codeName"); return (Criteria) this; } /** * @generated */ public Criteria andCodeNameNotIn(List values) { addCriterion("code_name not in", values, "codeName"); return (Criteria) this; } /** * @generated */ public Criteria andCodeNameBetween(String value1, String value2) { addCriterion("code_name between", value1, value2, "codeName"); return (Criteria) this; } /** * @generated */ public Criteria andCodeNameNotBetween(String value1, String value2) { addCriterion("code_name not between", value1, value2, "codeName"); return (Criteria) this; } /** * @generated */ public Criteria andCodeValueIsNull() { addCriterion("code_value is null"); return (Criteria) this; } /** * @generated */ public Criteria andCodeValueIsNotNull() { addCriterion("code_value <> ''"); return (Criteria) this; } /** * @generated */ public Criteria andCodeValueEqualTo(String value) { addCriterion("code_value =", value, "codeValue"); return (Criteria) this; } /** * @generated */ public Criteria andCodeValueNotEqualTo(String value) { addCriterion("code_value <>", value, "codeValue"); return (Criteria) this; } /** * @generated */ public Criteria andCodeValueGreaterThan(String value) { addCriterion("code_value >", value, "codeValue"); return (Criteria) this; } /** * @generated */ public Criteria andCodeValueGreaterThanOrEqualTo(String value) { addCriterion("code_value >=", value, "codeValue"); return (Criteria) this; } /** * @generated */ public Criteria andCodeValueLessThan(String value) { addCriterion("code_value <", value, "codeValue"); return (Criteria) this; } /** * @generated */ public Criteria andCodeValueLessThanOrEqualTo(String value) { addCriterion("code_value <=", value, "codeValue"); return (Criteria) this; } /** * @generated */ public Criteria andCodeValueLike(String value) { addCriterion("code_value like", value, "codeValue"); return (Criteria) this; } /** * @generated */ public Criteria andCodeValueNotLike(String value) { addCriterion("code_value not like", value, "codeValue"); return (Criteria) this; } /** * @generated */ public Criteria andCodeValueIn(List values) { addCriterion("code_value in", values, "codeValue"); return (Criteria) this; } /** * @generated */ public Criteria andCodeValueNotIn(List values) { addCriterion("code_value not in", values, "codeValue"); return (Criteria) this; } /** * @generated */ public Criteria andCodeValueBetween(String value1, String value2) { addCriterion("code_value between", value1, value2, "codeValue"); return (Criteria) this; } /** * @generated */ public Criteria andCodeValueNotBetween(String value1, String value2) { addCriterion("code_value not between", value1, value2, "codeValue"); return (Criteria) this; } /** * @generated */ public Criteria andCodeDescIsNull() { addCriterion("code_desc is null"); return (Criteria) this; } /** * @generated */ public Criteria andCodeDescIsNotNull() { addCriterion("code_desc <> ''"); return (Criteria) this; } /** * @generated */ public Criteria andCodeDescEqualTo(String value) { addCriterion("code_desc =", value, "codeDesc"); return (Criteria) this; } /** * @generated */ public Criteria andCodeDescNotEqualTo(String value) { addCriterion("code_desc <>", value, "codeDesc"); return (Criteria) this; } /** * @generated */ public Criteria andCodeDescGreaterThan(String value) { addCriterion("code_desc >", value, "codeDesc"); return (Criteria) this; } /** * @generated */ public Criteria andCodeDescGreaterThanOrEqualTo(String value) { addCriterion("code_desc >=", value, "codeDesc"); return (Criteria) this; } /** * @generated */ public Criteria andCodeDescLessThan(String value) { addCriterion("code_desc <", value, "codeDesc"); return (Criteria) this; } /** * @generated */ public Criteria andCodeDescLessThanOrEqualTo(String value) { addCriterion("code_desc <=", value, "codeDesc"); return (Criteria) this; } /** * @generated */ public Criteria andCodeDescLike(String value) { addCriterion("code_desc like", value, "codeDesc"); return (Criteria) this; } /** * @generated */ public Criteria andCodeDescNotLike(String value) { addCriterion("code_desc not like", value, "codeDesc"); return (Criteria) this; } /** * @generated */ public Criteria andCodeDescIn(List values) { addCriterion("code_desc in", values, "codeDesc"); return (Criteria) this; } /** * @generated */ public Criteria andCodeDescNotIn(List values) { addCriterion("code_desc not in", values, "codeDesc"); return (Criteria) this; } /** * @generated */ public Criteria andCodeDescBetween(String value1, String value2) { addCriterion("code_desc between", value1, value2, "codeDesc"); return (Criteria) this; } /** * @generated */ public Criteria andCodeDescNotBetween(String value1, String value2) { addCriterion("code_desc not between", value1, value2, "codeDesc"); return (Criteria) this; } /** * @generated */ public Criteria andCodeOrderIsNull() { addCriterion("code_order is null"); return (Criteria) this; } /** * @generated */ public Criteria andCodeOrderIsNotNull() { addCriterion("code_order <> ''"); return (Criteria) this; } /** * @generated */ public Criteria andCodeOrderEqualTo(Integer value) { addCriterion("code_order =", value, "codeOrder"); return (Criteria) this; } /** * @generated */ public Criteria andCodeOrderNotEqualTo(Integer value) { addCriterion("code_order <>", value, "codeOrder"); return (Criteria) this; } /** * @generated */ public Criteria andCodeOrderGreaterThan(Integer value) { addCriterion("code_order >", value, "codeOrder"); return (Criteria) this; } /** * @generated */ public Criteria andCodeOrderGreaterThanOrEqualTo(Integer value) { addCriterion("code_order >=", value, "codeOrder"); return (Criteria) this; } /** * @generated */ public Criteria andCodeOrderLessThan(Integer value) { addCriterion("code_order <", value, "codeOrder"); return (Criteria) this; } /** * @generated */ public Criteria andCodeOrderLessThanOrEqualTo(Integer value) { addCriterion("code_order <=", value, "codeOrder"); return (Criteria) this; } /** * @generated */ public Criteria andCodeOrderIn(List values) { addCriterion("code_order in", values, "codeOrder"); return (Criteria) this; } /** * @generated */ public Criteria andCodeOrderNotIn(List values) { addCriterion("code_order not in", values, "codeOrder"); return (Criteria) this; } /** * @generated */ public Criteria andCodeOrderBetween(Integer value1, Integer value2) { addCriterion("code_order between", value1, value2, "codeOrder"); return (Criteria) this; } /** * @generated */ public Criteria andCodeOrderNotBetween(Integer value1, Integer value2) { addCriterion("code_order not between", value1, value2, "codeOrder"); return (Criteria) this; } } /** * 标准数据类型 : 标准数据类型 * @generated */ public static class Criteria extends GeneratedCriteria { protected Criteria() { super(); } } }