/* * 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 SysExportRecordSQLBuilder { /** * 导出记录表 : 导出记录表 * @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 SysExportRecordSQLBuilder() { oredCriteria = new ArrayList(); } /** * @generated */ protected SysExportRecordSQLBuilder(SysExportRecordSQLBuilder 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 andIdIsNull() { addCriterion("id is null"); return (Criteria) this; } /** * @generated */ public Criteria andIdIsNotNull() { addCriterion("id <> ''"); return (Criteria) this; } /** * @generated */ public Criteria andIdEqualTo(String value) { addCriterion("id =", value, "id"); return (Criteria) this; } /** * @generated */ public Criteria andIdNotEqualTo(String value) { addCriterion("id <>", value, "id"); return (Criteria) this; } /** * @generated */ public Criteria andIdGreaterThan(String value) { addCriterion("id >", value, "id"); return (Criteria) this; } /** * @generated */ public Criteria andIdGreaterThanOrEqualTo(String value) { addCriterion("id >=", value, "id"); return (Criteria) this; } /** * @generated */ public Criteria andIdLessThan(String value) { addCriterion("id <", value, "id"); return (Criteria) this; } /** * @generated */ public Criteria andIdLessThanOrEqualTo(String value) { addCriterion("id <=", value, "id"); return (Criteria) this; } /** * @generated */ public Criteria andIdLike(String value) { addCriterion("id like", value, "id"); return (Criteria) this; } /** * @generated */ public Criteria andIdNotLike(String value) { addCriterion("id not like", value, "id"); return (Criteria) this; } /** * @generated */ public Criteria andIdIn(List values) { addCriterion("id in", values, "id"); return (Criteria) this; } /** * @generated */ public Criteria andIdNotIn(List values) { addCriterion("id not in", values, "id"); return (Criteria) this; } /** * @generated */ public Criteria andIdBetween(String value1, String value2) { addCriterion("id between", value1, value2, "id"); return (Criteria) this; } /** * @generated */ public Criteria andIdNotBetween(String value1, String value2) { addCriterion("id not between", value1, value2, "id"); return (Criteria) this; } /** * @generated */ public Criteria andStarttimeIsNull() { addCriterion("starttime is null"); return (Criteria) this; } /** * @generated */ public Criteria andStarttimeIsNotNull() { addCriterion("starttime <> ''"); return (Criteria) this; } /** * @generated */ public Criteria andStarttimeEqualTo(String value) { addCriterion("starttime =", value, "starttime"); return (Criteria) this; } /** * @generated */ public Criteria andStarttimeNotEqualTo(String value) { addCriterion("starttime <>", value, "starttime"); return (Criteria) this; } /** * @generated */ public Criteria andStarttimeGreaterThan(String value) { addCriterion("starttime >", value, "starttime"); return (Criteria) this; } /** * @generated */ public Criteria andStarttimeGreaterThanOrEqualTo(String value) { addCriterion("starttime >=", value, "starttime"); return (Criteria) this; } /** * @generated */ public Criteria andStarttimeLessThan(String value) { addCriterion("starttime <", value, "starttime"); return (Criteria) this; } /** * @generated */ public Criteria andStarttimeLessThanOrEqualTo(String value) { addCriterion("starttime <=", value, "starttime"); return (Criteria) this; } /** * @generated */ public Criteria andStarttimeLike(String value) { addCriterion("starttime like", value, "starttime"); return (Criteria) this; } /** * @generated */ public Criteria andStarttimeNotLike(String value) { addCriterion("starttime not like", value, "starttime"); return (Criteria) this; } /** * @generated */ public Criteria andStarttimeIn(List values) { addCriterion("starttime in", values, "starttime"); return (Criteria) this; } /** * @generated */ public Criteria andStarttimeNotIn(List values) { addCriterion("starttime not in", values, "starttime"); return (Criteria) this; } /** * @generated */ public Criteria andStarttimeBetween(String value1, String value2) { addCriterion("starttime between", value1, value2, "starttime"); return (Criteria) this; } /** * @generated */ public Criteria andStarttimeNotBetween(String value1, String value2) { addCriterion("starttime not between", value1, value2, "starttime"); return (Criteria) this; } /** * @generated */ public Criteria andOptimeIsNull() { addCriterion("optime is null"); return (Criteria) this; } /** * @generated */ public Criteria andOptimeIsNotNull() { addCriterion("optime <> ''"); return (Criteria) this; } /** * @generated */ public Criteria andOptimeEqualTo(String value) { addCriterion("optime =", value, "optime"); return (Criteria) this; } /** * @generated */ public Criteria andOptimeNotEqualTo(String value) { addCriterion("optime <>", value, "optime"); return (Criteria) this; } /** * @generated */ public Criteria andOptimeGreaterThan(String value) { addCriterion("optime >", value, "optime"); return (Criteria) this; } /** * @generated */ public Criteria andOptimeGreaterThanOrEqualTo(String value) { addCriterion("optime >=", value, "optime"); return (Criteria) this; } /** * @generated */ public Criteria andOptimeLessThan(String value) { addCriterion("optime <", value, "optime"); return (Criteria) this; } /** * @generated */ public Criteria andOptimeLessThanOrEqualTo(String value) { addCriterion("optime <=", value, "optime"); return (Criteria) this; } /** * @generated */ public Criteria andOptimeLike(String value) { addCriterion("optime like", value, "optime"); return (Criteria) this; } /** * @generated */ public Criteria andOptimeNotLike(String value) { addCriterion("optime not like", value, "optime"); return (Criteria) this; } /** * @generated */ public Criteria andOptimeIn(List values) { addCriterion("optime in", values, "optime"); return (Criteria) this; } /** * @generated */ public Criteria andOptimeNotIn(List values) { addCriterion("optime not in", values, "optime"); return (Criteria) this; } /** * @generated */ public Criteria andOptimeBetween(String value1, String value2) { addCriterion("optime between", value1, value2, "optime"); return (Criteria) this; } /** * @generated */ public Criteria andOptimeNotBetween(String value1, String value2) { addCriterion("optime not between", value1, value2, "optime"); return (Criteria) this; } /** * @generated */ public Criteria andPlatformidIsNull() { addCriterion("platformid is null"); return (Criteria) this; } /** * @generated */ public Criteria andPlatformidIsNotNull() { addCriterion("platformid <> ''"); return (Criteria) this; } /** * @generated */ public Criteria andPlatformidEqualTo(String value) { addCriterion("platformid =", value, "platformid"); return (Criteria) this; } /** * @generated */ public Criteria andPlatformidNotEqualTo(String value) { addCriterion("platformid <>", value, "platformid"); return (Criteria) this; } /** * @generated */ public Criteria andPlatformidGreaterThan(String value) { addCriterion("platformid >", value, "platformid"); return (Criteria) this; } /** * @generated */ public Criteria andPlatformidGreaterThanOrEqualTo(String value) { addCriterion("platformid >=", value, "platformid"); return (Criteria) this; } /** * @generated */ public Criteria andPlatformidLessThan(String value) { addCriterion("platformid <", value, "platformid"); return (Criteria) this; } /** * @generated */ public Criteria andPlatformidLessThanOrEqualTo(String value) { addCriterion("platformid <=", value, "platformid"); return (Criteria) this; } /** * @generated */ public Criteria andPlatformidLike(String value) { addCriterion("platformid like", value, "platformid"); return (Criteria) this; } /** * @generated */ public Criteria andPlatformidNotLike(String value) { addCriterion("platformid not like", value, "platformid"); return (Criteria) this; } /** * @generated */ public Criteria andPlatformidIn(List values) { addCriterion("platformid in", values, "platformid"); return (Criteria) this; } /** * @generated */ public Criteria andPlatformidNotIn(List values) { addCriterion("platformid not in", values, "platformid"); return (Criteria) this; } /** * @generated */ public Criteria andPlatformidBetween(String value1, String value2) { addCriterion("platformid between", value1, value2, "platformid"); return (Criteria) this; } /** * @generated */ public Criteria andPlatformidNotBetween(String value1, String value2) { addCriterion("platformid not between", value1, value2, "platformid"); return (Criteria) this; } /** * @generated */ public Criteria andNumsIsNull() { addCriterion("nums is null"); return (Criteria) this; } /** * @generated */ public Criteria andNumsIsNotNull() { addCriterion("nums <> ''"); return (Criteria) this; } /** * @generated */ public Criteria andNumsEqualTo(Integer value) { addCriterion("nums =", value, "nums"); return (Criteria) this; } /** * @generated */ public Criteria andNumsNotEqualTo(Integer value) { addCriterion("nums <>", value, "nums"); return (Criteria) this; } /** * @generated */ public Criteria andNumsGreaterThan(Integer value) { addCriterion("nums >", value, "nums"); return (Criteria) this; } /** * @generated */ public Criteria andNumsGreaterThanOrEqualTo(Integer value) { addCriterion("nums >=", value, "nums"); return (Criteria) this; } /** * @generated */ public Criteria andNumsLessThan(Integer value) { addCriterion("nums <", value, "nums"); return (Criteria) this; } /** * @generated */ public Criteria andNumsLessThanOrEqualTo(Integer value) { addCriterion("nums <=", value, "nums"); return (Criteria) this; } /** * @generated */ public Criteria andNumsIn(List values) { addCriterion("nums in", values, "nums"); return (Criteria) this; } /** * @generated */ public Criteria andNumsNotIn(List values) { addCriterion("nums not in", values, "nums"); return (Criteria) this; } /** * @generated */ public Criteria andNumsBetween(Integer value1, Integer value2) { addCriterion("nums between", value1, value2, "nums"); return (Criteria) this; } /** * @generated */ public Criteria andNumsNotBetween(Integer value1, Integer value2) { addCriterion("nums not between", value1, value2, "nums"); return (Criteria) this; } /** * @generated */ public Criteria andEndtimeIsNull() { addCriterion("endtime is null"); return (Criteria) this; } /** * @generated */ public Criteria andEndtimeIsNotNull() { addCriterion("endtime <> ''"); return (Criteria) this; } /** * @generated */ public Criteria andEndtimeEqualTo(String value) { addCriterion("endtime =", value, "endtime"); return (Criteria) this; } /** * @generated */ public Criteria andEndtimeNotEqualTo(String value) { addCriterion("endtime <>", value, "endtime"); return (Criteria) this; } /** * @generated */ public Criteria andEndtimeGreaterThan(String value) { addCriterion("endtime >", value, "endtime"); return (Criteria) this; } /** * @generated */ public Criteria andEndtimeGreaterThanOrEqualTo(String value) { addCriterion("endtime >=", value, "endtime"); return (Criteria) this; } /** * @generated */ public Criteria andEndtimeLessThan(String value) { addCriterion("endtime <", value, "endtime"); return (Criteria) this; } /** * @generated */ public Criteria andEndtimeLessThanOrEqualTo(String value) { addCriterion("endtime <=", value, "endtime"); return (Criteria) this; } /** * @generated */ public Criteria andEndtimeLike(String value) { addCriterion("endtime like", value, "endtime"); return (Criteria) this; } /** * @generated */ public Criteria andEndtimeNotLike(String value) { addCriterion("endtime not like", value, "endtime"); return (Criteria) this; } /** * @generated */ public Criteria andEndtimeIn(List values) { addCriterion("endtime in", values, "endtime"); return (Criteria) this; } /** * @generated */ public Criteria andEndtimeNotIn(List values) { addCriterion("endtime not in", values, "endtime"); return (Criteria) this; } /** * @generated */ public Criteria andEndtimeBetween(String value1, String value2) { addCriterion("endtime between", value1, value2, "endtime"); return (Criteria) this; } /** * @generated */ public Criteria andEndtimeNotBetween(String value1, String value2) { addCriterion("endtime not between", value1, value2, "endtime"); return (Criteria) this; } /** * @generated */ public Criteria andRemarksIsNull() { addCriterion("remarks is null"); return (Criteria) this; } /** * @generated */ public Criteria andRemarksIsNotNull() { addCriterion("remarks <> ''"); return (Criteria) this; } /** * @generated */ public Criteria andRemarksEqualTo(String value) { addCriterion("remarks =", value, "remarks"); return (Criteria) this; } /** * @generated */ public Criteria andRemarksNotEqualTo(String value) { addCriterion("remarks <>", value, "remarks"); return (Criteria) this; } /** * @generated */ public Criteria andRemarksGreaterThan(String value) { addCriterion("remarks >", value, "remarks"); return (Criteria) this; } /** * @generated */ public Criteria andRemarksGreaterThanOrEqualTo(String value) { addCriterion("remarks >=", value, "remarks"); return (Criteria) this; } /** * @generated */ public Criteria andRemarksLessThan(String value) { addCriterion("remarks <", value, "remarks"); return (Criteria) this; } /** * @generated */ public Criteria andRemarksLessThanOrEqualTo(String value) { addCriterion("remarks <=", value, "remarks"); return (Criteria) this; } /** * @generated */ public Criteria andRemarksLike(String value) { addCriterion("remarks like", value, "remarks"); return (Criteria) this; } /** * @generated */ public Criteria andRemarksNotLike(String value) { addCriterion("remarks not like", value, "remarks"); return (Criteria) this; } /** * @generated */ public Criteria andRemarksIn(List values) { addCriterion("remarks in", values, "remarks"); return (Criteria) this; } /** * @generated */ public Criteria andRemarksNotIn(List values) { addCriterion("remarks not in", values, "remarks"); return (Criteria) this; } /** * @generated */ public Criteria andRemarksBetween(String value1, String value2) { addCriterion("remarks between", value1, value2, "remarks"); return (Criteria) this; } /** * @generated */ public Criteria andRemarksNotBetween(String value1, String value2) { addCriterion("remarks not between", value1, value2, "remarks"); return (Criteria) this; } } /** * 导出记录表 : 导出记录表 * @generated */ public static class Criteria extends GeneratedCriteria { protected Criteria() { super(); } } }