Mybatis3 generator的使用附demo 及sqlserver 分页插件

package com.cy.mybatis.mbg.model; import java.util.ArrayList; import java.util.Date; import java.util.List; public class WeatherExample { protected String orderByClause; protected boolean distinct; protected List<Criteria> oredCriteria; private int pageIndex; //第几页 private int pageSize; //每页几条数据 public WeatherExample() { oredCriteria = new ArrayList<Criteria>(); } 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() { System.out.println("size :"+oredCriteria.size()); if(oredCriteria.size()>0){ for(Criteria cri:oredCriteria){ System.out.println(":::****>"+cri.getCriteria()); for(Criterion criterion :cri.getCriteria() ){ System.out.println("::::::"+criterion.value); } } } 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; } public void setPageIndex(int pageIndex) { this.pageIndex=pageIndex; } public int getPageIndex() { return this.pageIndex; } public void setPageSize(int pageSize) { this.pageSize=pageSize; } public int getPageSize() { return this.pageSize; } public int getSkipRecordCount() { return (this.pageIndex-1)*this.pageSize; } public int getEndRecordCount() { return this.pageIndex*this.pageSize; } public WeatherExample(int pageSize, int pageIndex) { this(); this.pageSize=pageSize; this.pageIndex=pageIndex; } protected abstract static class GeneratedCriteria { protected List<Criterion> criteria; protected GeneratedCriteria() { super(); criteria = new ArrayList<Criterion>(); } 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(Integer value) { addCriterion("id =", value, "id"); return (Criteria) this; } public Criteria andIdNotEqualTo(Integer value) { addCriterion("id <>", value, "id"); return (Criteria) this; } public Criteria andIdGreaterThan(Integer value) { addCriterion("id >", value, "id"); return (Criteria) this; } public Criteria andIdGreaterThanOrEqualTo(Integer value) { addCriterion("id >=", value, "id"); return (Criteria) this; } public Criteria andIdLessThan(Integer value) { addCriterion("id <", value, "id"); return (Criteria) this; } public Criteria andIdLessThanOrEqualTo(Integer value) { addCriterion("id <=", value, "id"); return (Criteria) this; } public Criteria andIdIn(List<Integer> values) { addCriterion("id in", values, "id"); return (Criteria) this; } public Criteria andIdNotIn(List<Integer> values) { addCriterion("id not in", values, "id"); return (Criteria) this; } public Criteria andIdBetween(Integer value1, Integer value2) { addCriterion("id between", value1, value2, "id"); return (Criteria) this; } public Criteria andIdNotBetween(Integer value1, Integer value2) { addCriterion("id not between", value1, value2, "id"); return (Criteria) this; } public Criteria andCityNameIsNull() { addCriterion("city_name is null"); return (Criteria) this; } public Criteria andCityNameIsNotNull() { addCriterion("city_name is not null"); return (Criteria) this; } public Criteria andCityNameEqualTo(String value) { addCriterion("city_name =", value, "cityName"); return (Criteria) this; } public Criteria andCityNameNotEqualTo(String value) { addCriterion("city_name <>", value, "cityName"); return (Criteria) this; } public Criteria andCityNameGreaterThan(String value) { addCriterion("city_name >", value, "cityName"); return (Criteria) this; } public Criteria andCityNameGreaterThanOrEqualTo(String value) { addCriterion("city_name >=", value, "cityName"); return (Criteria) this; } public Criteria andCityNameLessThan(String value) { addCriterion("city_name <", value, "cityName"); return (Criteria) this; } public Criteria andCityNameLessThanOrEqualTo(String value) { addCriterion("city_name <=", value, "cityName"); return (Criteria) this; } public Criteria andCityNameLike(String value) { addCriterion("city_name like", value, "cityName"); return (Criteria) this; } public Criteria andCityNameNotLike(String value) { addCriterion("city_name not like", value, "cityName"); return (Criteria) this; } public Criteria andCityNameIn(List<String> values) { addCriterion("city_name in", values, "cityName"); return (Criteria) this; } public Criteria andCityNameNotIn(List<String> values) { addCriterion("city_name not in", values, "cityName"); r