/* * Copyright 2010 The YAPULAN Software Foundation * * Licensed under the YAPULAN License, Version 2.0 (the "License"); */ package com.miniframe.system.model; import java.math.BigDecimal; import java.util.ArrayList; import java.util.HashMap; import java.util.List; import java.util.Map; /** * 菜单信息表 : 菜单信息表 * @generated */ public class SysMenuSQLBuilder { /** * 菜单信息表 : 菜单信息表 * @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 SysMenuSQLBuilder() { oredCriteria = new ArrayList(); } /** * @generated */ protected SysMenuSQLBuilder(SysMenuSQLBuilder 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 andMenuidIsNull() { addCriterion("menuid is null"); return (Criteria) this; } /** * @generated */ public Criteria andMenuidIsNotNull() { addCriterion("menuid <> ''"); return (Criteria) this; } /** * @generated */ public Criteria andMenuidEqualTo(String value) { addCriterion("menuid =", value, "menuid"); return (Criteria) this; } /** * @generated */ public Criteria andMenuidNotEqualTo(String value) { addCriterion("menuid <>", value, "menuid"); return (Criteria) this; } /** * @generated */ public Criteria andMenuidGreaterThan(String value) { addCriterion("menuid >", value, "menuid"); return (Criteria) this; } /** * @generated */ public Criteria andMenuidGreaterThanOrEqualTo(String value) { addCriterion("menuid >=", value, "menuid"); return (Criteria) this; } /** * @generated */ public Criteria andMenuidLessThan(String value) { addCriterion("menuid <", value, "menuid"); return (Criteria) this; } /** * @generated */ public Criteria andMenuidLessThanOrEqualTo(String value) { addCriterion("menuid <=", value, "menuid"); return (Criteria) this; } /** * @generated */ public Criteria andMenuidLike(String value) { addCriterion("menuid like", value, "menuid"); return (Criteria) this; } /** * @generated */ public Criteria andMenuidNotLike(String value) { addCriterion("menuid not like", value, "menuid"); return (Criteria) this; } /** * @generated */ public Criteria andMenuidIn(List values) { addCriterion("menuid in", values, "menuid"); return (Criteria) this; } /** * @generated */ public Criteria andMenuidNotIn(List values) { addCriterion("menuid not in", values, "menuid"); return (Criteria) this; } /** * @generated */ public Criteria andMenuidBetween(String value1, String value2) { addCriterion("menuid between", value1, value2, "menuid"); return (Criteria) this; } /** * @generated */ public Criteria andMenuidNotBetween(String value1, String value2) { addCriterion("menuid not between", value1, value2, "menuid"); return (Criteria) this; } /** * @generated */ public Criteria andMenupidIsNull() { addCriterion("menupid is null"); return (Criteria) this; } /** * @generated */ public Criteria andMenupidIsNotNull() { addCriterion("menupid <> ''"); return (Criteria) this; } /** * @generated */ public Criteria andMenupidEqualTo(String value) { addCriterion("menupid =", value, "menupid"); return (Criteria) this; } /** * @generated */ public Criteria andMenupidNotEqualTo(String value) { addCriterion("menupid <>", value, "menupid"); return (Criteria) this; } /** * @generated */ public Criteria andMenupidGreaterThan(String value) { addCriterion("menupid >", value, "menupid"); return (Criteria) this; } /** * @generated */ public Criteria andMenupidGreaterThanOrEqualTo(String value) { addCriterion("menupid >=", value, "menupid"); return (Criteria) this; } /** * @generated */ public Criteria andMenupidLessThan(String value) { addCriterion("menupid <", value, "menupid"); return (Criteria) this; } /** * @generated */ public Criteria andMenupidLessThanOrEqualTo(String value) { addCriterion("menupid <=", value, "menupid"); return (Criteria) this; } /** * @generated */ public Criteria andMenupidLike(String value) { addCriterion("menupid like", value, "menupid"); return (Criteria) this; } /** * @generated */ public Criteria andMenupidNotLike(String value) { addCriterion("menupid not like", value, "menupid"); return (Criteria) this; } /** * @generated */ public Criteria andMenupidIn(List values) { addCriterion("menupid in", values, "menupid"); return (Criteria) this; } /** * @generated */ public Criteria andMenupidNotIn(List values) { addCriterion("menupid not in", values, "menupid"); return (Criteria) this; } /** * @generated */ public Criteria andMenupidBetween(String value1, String value2) { addCriterion("menupid between", value1, value2, "menupid"); return (Criteria) this; } /** * @generated */ public Criteria andMenupidNotBetween(String value1, String value2) { addCriterion("menupid not between", value1, value2, "menupid"); return (Criteria) this; } /** * @generated */ public Criteria andMenunameIsNull() { addCriterion("menuname is null"); return (Criteria) this; } /** * @generated */ public Criteria andMenunameIsNotNull() { addCriterion("menuname <> ''"); return (Criteria) this; } /** * @generated */ public Criteria andMenunameEqualTo(String value) { addCriterion("menuname =", value, "menuname"); return (Criteria) this; } /** * @generated */ public Criteria andMenunameNotEqualTo(String value) { addCriterion("menuname <>", value, "menuname"); return (Criteria) this; } /** * @generated */ public Criteria andMenunameGreaterThan(String value) { addCriterion("menuname >", value, "menuname"); return (Criteria) this; } /** * @generated */ public Criteria andMenunameGreaterThanOrEqualTo(String value) { addCriterion("menuname >=", value, "menuname"); return (Criteria) this; } /** * @generated */ public Criteria andMenunameLessThan(String value) { addCriterion("menuname <", value, "menuname"); return (Criteria) this; } /** * @generated */ public Criteria andMenunameLessThanOrEqualTo(String value) { addCriterion("menuname <=", value, "menuname"); return (Criteria) this; } /** * @generated */ public Criteria andMenunameLike(String value) { addCriterion("menuname like", value, "menuname"); return (Criteria) this; } /** * @generated */ public Criteria andMenunameNotLike(String value) { addCriterion("menuname not like", value, "menuname"); return (Criteria) this; } /** * @generated */ public Criteria andMenunameIn(List values) { addCriterion("menuname in", values, "menuname"); return (Criteria) this; } /** * @generated */ public Criteria andMenunameNotIn(List values) { addCriterion("menuname not in", values, "menuname"); return (Criteria) this; } /** * @generated */ public Criteria andMenunameBetween(String value1, String value2) { addCriterion("menuname between", value1, value2, "menuname"); return (Criteria) this; } /** * @generated */ public Criteria andMenunameNotBetween(String value1, String value2) { addCriterion("menuname not between", value1, value2, "menuname"); return (Criteria) this; } /** * @generated */ public Criteria andMenudescIsNull() { addCriterion("menudesc is null"); return (Criteria) this; } /** * @generated */ public Criteria andMenudescIsNotNull() { addCriterion("menudesc <> ''"); return (Criteria) this; } /** * @generated */ public Criteria andMenudescEqualTo(String value) { addCriterion("menudesc =", value, "menudesc"); return (Criteria) this; } /** * @generated */ public Criteria andMenudescNotEqualTo(String value) { addCriterion("menudesc <>", value, "menudesc"); return (Criteria) this; } /** * @generated */ public Criteria andMenudescGreaterThan(String value) { addCriterion("menudesc >", value, "menudesc"); return (Criteria) this; } /** * @generated */ public Criteria andMenudescGreaterThanOrEqualTo(String value) { addCriterion("menudesc >=", value, "menudesc"); return (Criteria) this; } /** * @generated */ public Criteria andMenudescLessThan(String value) { addCriterion("menudesc <", value, "menudesc"); return (Criteria) this; } /** * @generated */ public Criteria andMenudescLessThanOrEqualTo(String value) { addCriterion("menudesc <=", value, "menudesc"); return (Criteria) this; } /** * @generated */ public Criteria andMenudescLike(String value) { addCriterion("menudesc like", value, "menudesc"); return (Criteria) this; } /** * @generated */ public Criteria andMenudescNotLike(String value) { addCriterion("menudesc not like", value, "menudesc"); return (Criteria) this; } /** * @generated */ public Criteria andMenudescIn(List values) { addCriterion("menudesc in", values, "menudesc"); return (Criteria) this; } /** * @generated */ public Criteria andMenudescNotIn(List values) { addCriterion("menudesc not in", values, "menudesc"); return (Criteria) this; } /** * @generated */ public Criteria andMenudescBetween(String value1, String value2) { addCriterion("menudesc between", value1, value2, "menudesc"); return (Criteria) this; } /** * @generated */ public Criteria andMenudescNotBetween(String value1, String value2) { addCriterion("menudesc not between", value1, value2, "menudesc"); return (Criteria) this; } /** * @generated */ public Criteria andMenuurlIsNull() { addCriterion("menuurl is null"); return (Criteria) this; } /** * @generated */ public Criteria andMenuurlIsNotNull() { addCriterion("menuurl <> ''"); return (Criteria) this; } /** * @generated */ public Criteria andMenuurlEqualTo(String value) { addCriterion("menuurl =", value, "menuurl"); return (Criteria) this; } /** * @generated */ public Criteria andMenuurlNotEqualTo(String value) { addCriterion("menuurl <>", value, "menuurl"); return (Criteria) this; } /** * @generated */ public Criteria andMenuurlGreaterThan(String value) { addCriterion("menuurl >", value, "menuurl"); return (Criteria) this; } /** * @generated */ public Criteria andMenuurlGreaterThanOrEqualTo(String value) { addCriterion("menuurl >=", value, "menuurl"); return (Criteria) this; } /** * @generated */ public Criteria andMenuurlLessThan(String value) { addCriterion("menuurl <", value, "menuurl"); return (Criteria) this; } /** * @generated */ public Criteria andMenuurlLessThanOrEqualTo(String value) { addCriterion("menuurl <=", value, "menuurl"); return (Criteria) this; } /** * @generated */ public Criteria andMenuurlLike(String value) { addCriterion("menuurl like", value, "menuurl"); return (Criteria) this; } /** * @generated */ public Criteria andMenuurlNotLike(String value) { addCriterion("menuurl not like", value, "menuurl"); return (Criteria) this; } /** * @generated */ public Criteria andMenuurlIn(List values) { addCriterion("menuurl in", values, "menuurl"); return (Criteria) this; } /** * @generated */ public Criteria andMenuurlNotIn(List values) { addCriterion("menuurl not in", values, "menuurl"); return (Criteria) this; } /** * @generated */ public Criteria andMenuurlBetween(String value1, String value2) { addCriterion("menuurl between", value1, value2, "menuurl"); return (Criteria) this; } /** * @generated */ public Criteria andMenuurlNotBetween(String value1, String value2) { addCriterion("menuurl not between", value1, value2, "menuurl"); return (Criteria) this; } /** * @generated */ public Criteria andMenuimageIsNull() { addCriterion("menuimage is null"); return (Criteria) this; } /** * @generated */ public Criteria andMenuimageIsNotNull() { addCriterion("menuimage <> ''"); return (Criteria) this; } /** * @generated */ public Criteria andMenuimageEqualTo(String value) { addCriterion("menuimage =", value, "menuimage"); return (Criteria) this; } /** * @generated */ public Criteria andMenuimageNotEqualTo(String value) { addCriterion("menuimage <>", value, "menuimage"); return (Criteria) this; } /** * @generated */ public Criteria andMenuimageGreaterThan(String value) { addCriterion("menuimage >", value, "menuimage"); return (Criteria) this; } /** * @generated */ public Criteria andMenuimageGreaterThanOrEqualTo(String value) { addCriterion("menuimage >=", value, "menuimage"); return (Criteria) this; } /** * @generated */ public Criteria andMenuimageLessThan(String value) { addCriterion("menuimage <", value, "menuimage"); return (Criteria) this; } /** * @generated */ public Criteria andMenuimageLessThanOrEqualTo(String value) { addCriterion("menuimage <=", value, "menuimage"); return (Criteria) this; } /** * @generated */ public Criteria andMenuimageLike(String value) { addCriterion("menuimage like", value, "menuimage"); return (Criteria) this; } /** * @generated */ public Criteria andMenuimageNotLike(String value) { addCriterion("menuimage not like", value, "menuimage"); return (Criteria) this; } /** * @generated */ public Criteria andMenuimageIn(List values) { addCriterion("menuimage in", values, "menuimage"); return (Criteria) this; } /** * @generated */ public Criteria andMenuimageNotIn(List values) { addCriterion("menuimage not in", values, "menuimage"); return (Criteria) this; } /** * @generated */ public Criteria andMenuimageBetween(String value1, String value2) { addCriterion("menuimage between", value1, value2, "menuimage"); return (Criteria) this; } /** * @generated */ public Criteria andMenuimageNotBetween(String value1, String value2) { addCriterion("menuimage not between", value1, value2, "menuimage"); return (Criteria) this; } /** * @generated */ public Criteria andFlagIsNull() { addCriterion("flag is null"); return (Criteria) this; } /** * @generated */ public Criteria andFlagIsNotNull() { addCriterion("flag <> ''"); return (Criteria) this; } /** * @generated */ public Criteria andFlagEqualTo(String value) { addCriterion("flag =", value, "flag"); return (Criteria) this; } /** * @generated */ public Criteria andFlagNotEqualTo(String value) { addCriterion("flag <>", value, "flag"); return (Criteria) this; } /** * @generated */ public Criteria andFlagGreaterThan(String value) { addCriterion("flag >", value, "flag"); return (Criteria) this; } /** * @generated */ public Criteria andFlagGreaterThanOrEqualTo(String value) { addCriterion("flag >=", value, "flag"); return (Criteria) this; } /** * @generated */ public Criteria andFlagLessThan(String value) { addCriterion("flag <", value, "flag"); return (Criteria) this; } /** * @generated */ public Criteria andFlagLessThanOrEqualTo(String value) { addCriterion("flag <=", value, "flag"); return (Criteria) this; } /** * @generated */ public Criteria andFlagLike(String value) { addCriterion("flag like", value, "flag"); return (Criteria) this; } /** * @generated */ public Criteria andFlagNotLike(String value) { addCriterion("flag not like", value, "flag"); return (Criteria) this; } /** * @generated */ public Criteria andFlagIn(List values) { addCriterion("flag in", values, "flag"); return (Criteria) this; } /** * @generated */ public Criteria andFlagNotIn(List values) { addCriterion("flag not in", values, "flag"); return (Criteria) this; } /** * @generated */ public Criteria andFlagBetween(String value1, String value2) { addCriterion("flag between", value1, value2, "flag"); return (Criteria) this; } /** * @generated */ public Criteria andFlagNotBetween(String value1, String value2) { addCriterion("flag not between", value1, value2, "flag"); return (Criteria) this; } /** * @generated */ public Criteria andMenuindexIsNull() { addCriterion("menuindex is null"); return (Criteria) this; } /** * @generated */ public Criteria andMenuindexIsNotNull() { addCriterion("menuindex <> ''"); return (Criteria) this; } /** * @generated */ public Criteria andMenuindexEqualTo(BigDecimal value) { addCriterion("menuindex =", value, "menuindex"); return (Criteria) this; } /** * @generated */ public Criteria andMenuindexNotEqualTo(BigDecimal value) { addCriterion("menuindex <>", value, "menuindex"); return (Criteria) this; } /** * @generated */ public Criteria andMenuindexGreaterThan(BigDecimal value) { addCriterion("menuindex >", value, "menuindex"); return (Criteria) this; } /** * @generated */ public Criteria andMenuindexGreaterThanOrEqualTo(BigDecimal value) { addCriterion("menuindex >=", value, "menuindex"); return (Criteria) this; } /** * @generated */ public Criteria andMenuindexLessThan(BigDecimal value) { addCriterion("menuindex <", value, "menuindex"); return (Criteria) this; } /** * @generated */ public Criteria andMenuindexLessThanOrEqualTo(BigDecimal value) { addCriterion("menuindex <=", value, "menuindex"); return (Criteria) this; } /** * @generated */ public Criteria andMenuindexIn(List values) { addCriterion("menuindex in", values, "menuindex"); return (Criteria) this; } /** * @generated */ public Criteria andMenuindexNotIn(List values) { addCriterion("menuindex not in", values, "menuindex"); return (Criteria) this; } /** * @generated */ public Criteria andMenuindexBetween(BigDecimal value1, BigDecimal value2) { addCriterion("menuindex between", value1, value2, "menuindex"); return (Criteria) this; } /** * @generated */ public Criteria andMenuindexNotBetween(BigDecimal value1, BigDecimal value2) { addCriterion("menuindex not between", value1, value2, "menuindex"); return (Criteria) this; } } /** * 菜单信息表 : 菜单信息表 * @generated */ public static class Criteria extends GeneratedCriteria { protected Criteria() { super(); } } }