省市区三级-javabean和mybatis

bean：

package com.baiwang.moirai.model.sys;

import com.fasterxml.jackson.annotation.JsonInclude;

/**
 * 省市区三级
 * ClassName: AreaInfo
 * @author chengluchao
 */
@JsonInclude(JsonInclude.Include.NON_NULL)
public class SysProvCityDist {
    private Integer id;

    private String province;

    private String type;

    private String city;

    private Integer provinceId;

    private String district;

    private Integer cityId;

    private String function;

    public String getFunction() {
        return function;
    }

    public void setFunction(String function) {
        this.function = function;
    }

    public Integer getId() {
        return id;
    }

    public void setId(Integer id) {
        this.id = id;
    }

    public String getProvince() {
        return province;
    }

    public void setProvince(String province) {
        this.province = province == null ? null : province.trim();
    }

    public String getType() {
        return type;
    }

    public void setType(String type) {
        this.type = type == null ? null : type.trim();
    }

    public String getCity() {
        return city;
    }

    public void setCity(String city) {
        this.city = city == null ? null : city.trim();
    }

    public Integer getProvinceId() {
        return provinceId;
    }

    public void setProvinceId(Integer provinceId) {
        this.provinceId = provinceId;
    }

    public String getDistrict() {
        return district;
    }

    public void setDistrict(String district) {
        this.district = district == null ? null : district.trim();
    }

    public Integer getCityId() {
        return cityId;
    }

    public void setCityId(Integer cityId) {
        this.cityId = cityId;
    }
}

mybatis文件：

package com.baiwang.moirai.mapper;

import com.baiwang.moirai.model.sys.SysProvCityDist;
import org.apache.ibatis.annotations.Mapper;

import java.util.List;
@Mapper
public interface SysProvCityDistMapper {

    int deleteByPrimaryKey(Integer id);

    int insert(SysProvCityDist record);

    int insertSelective(SysProvCityDist record);

    SysProvCityDist selectByPrimaryKey(Integer id);

    List<SysProvCityDist> selectByBean(SysProvCityDist sysProvCityDist);

    List<SysProvCityDist> selectByBeanVague(SysProvCityDist sysProvCityDist);

    int updateByPrimaryKeySelective(SysProvCityDist record);

    int updateByPrimaryKey(SysProvCityDist record);
}

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.baiwang.moirai.mapper.SysProvCityDistMapper">
  <resultMap id="BaseResultMap" type="com.baiwang.moirai.model.sys.SysProvCityDist">
    <id column="id" jdbcType="INTEGER" property="id" />
    <result column="province" jdbcType="VARCHAR" property="province" />
    <result column="type" jdbcType="CHAR" property="type" />
    <result column="city" jdbcType="VARCHAR" property="city" />
    <result column="province_id" jdbcType="INTEGER" property="provinceId" />
    <result column="district" jdbcType="VARCHAR" property="district" />
    <result column="city_id" jdbcType="INTEGER" property="cityId" />
  </resultMap>
  <sql id="Base_Column_List">
    id, province, type, city, province_id, district, city_id
  </sql>

  <select id="selectByPrimaryKey" parameterType="java.lang.Integer" resultMap="BaseResultMap">
    select 
    <include refid="Base_Column_List" />
    from sys_prov_city_dist
    where id = #{id,jdbcType=INTEGER}
  </select>

  <select id="selectByBean" parameterType="com.baiwang.moirai.model.sys.SysProvCityDist" resultMap="BaseResultMap">
  select
  <include refid="Base_Column_List" />
  from sys_prov_city_dist
  where 1=1
  <if test="province != null">
    AND province = #{province,jdbcType=VARCHAR}
  </if>
  <if test="type != null">
    AND type = #{type,jdbcType=CHAR}
  </if>
  <if test="city != null">
    AND city = #{city,jdbcType=VARCHAR}
  </if>
  <if test="provinceId != null">
    AND province_id = #{provinceId,jdbcType=INTEGER}
  </if>
  <if test="district != null">
    AND district = #{district,jdbcType=VARCHAR}
  </if>
  <if test="cityId != null">
    AND city_id = #{cityId,jdbcType=INTEGER}
  </if>
  <if test="id != null">
    AND id = #{id,jdbcType=INTEGER}
  </if>
</select>

  <select id="selectByBeanVague" parameterType="com.baiwang.moirai.model.sys.SysProvCityDist" resultMap="BaseResultMap">
    select
    <include refid="Base_Column_List" />
    from sys_prov_city_dist
    where 1=1
    <if test="province != null">
      AND province LIKE  CONCAT(#{province,jdbcType=VARCHAR},'%')
    </if>
    <if test="type != null">
      AND type = #{type,jdbcType=CHAR}
    </if>
    <if test="city != null">
      AND city LIKE  CONCAT(#{city,jdbcType=VARCHAR},'%')
    </if>
    <if test="provinceId != null">
      AND province_id = #{provinceId,jdbcType=INTEGER}
    </if>
    <if test="district != null">
      AND district LIKE  CONCAT(#{district,jdbcType=VARCHAR},'%')
    </if>
    <if test="cityId != null">
      AND city_id = #{cityId,jdbcType=INTEGER}
    </if>
    <if test="id != null">
      AND id = #{id,jdbcType=INTEGER}
    </if>
  </select>

  <delete id="deleteByPrimaryKey" parameterType="java.lang.Integer">
    delete from sys_prov_city_dist
    where id = #{id,jdbcType=INTEGER}
  </delete>

  <insert id="insert" parameterType="com.baiwang.moirai.model.sys.SysProvCityDist">
    insert into sys_prov_city_dist (id, province, type, 
      city, province_id, district, 
      city_id)
    values (#{id,jdbcType=INTEGER}, #{province,jdbcType=VARCHAR}, #{type,jdbcType=CHAR}, 
      #{city,jdbcType=VARCHAR}, #{provinceId,jdbcType=INTEGER}, #{district,jdbcType=VARCHAR}, 
      #{cityId,jdbcType=INTEGER})
  </insert>

  <insert id="insertSelective" parameterType="com.baiwang.moirai.model.sys.SysProvCityDist">
    insert into sys_prov_city_dist
    <trim prefix="(" suffix=")" suffixOverrides=",">
      <if test="id != null">
        id,
      </if>
      <if test="province != null">
        province,
      </if>
      <if test="type != null">
        type,
      </if>
      <if test="city != null">
        city,
      </if>
      <if test="provinceId != null">
        province_id,
      </if>
      <if test="district != null">
        district,
      </if>
      <if test="cityId != null">
        city_id,
      </if>
    </trim>
    <trim prefix="values (" suffix=")" suffixOverrides=",">
      <if test="id != null">
        #{id,jdbcType=INTEGER},
      </if>
      <if test="province != null">
        #{province,jdbcType=VARCHAR},
      </if>
      <if test="type != null">
        #{type,jdbcType=CHAR},
      </if>
      <if test="city != null">
        #{city,jdbcType=VARCHAR},
      </if>
      <if test="provinceId != null">
        #{provinceId,jdbcType=INTEGER},
      </if>
      <if test="district != null">
        #{district,jdbcType=VARCHAR},
      </if>
      <if test="cityId != null">
        #{cityId,jdbcType=INTEGER},
      </if>
    </trim>
  </insert>

  <update id="updateByPrimaryKeySelective" parameterType="com.baiwang.moirai.model.sys.SysProvCityDist">
    update sys_prov_city_dist
    <set>
      <if test="province != null">
        province = #{province,jdbcType=VARCHAR},
      </if>
      <if test="type != null">
        type = #{type,jdbcType=CHAR},
      </if>
      <if test="city != null">
        city = #{city,jdbcType=VARCHAR},
      </if>
      <if test="provinceId != null">
        province_id = #{provinceId,jdbcType=INTEGER},
      </if>
      <if test="district != null">
        district = #{district,jdbcType=VARCHAR},
      </if>
      <if test="cityId != null">
        city_id = #{cityId,jdbcType=INTEGER},
      </if>
    </set>
    where id = #{id,jdbcType=INTEGER}
  </update>

  <update id="updateByPrimaryKey" parameterType="com.baiwang.moirai.model.sys.SysProvCityDist">
    update sys_prov_city_dist
    set province = #{province,jdbcType=VARCHAR},
      type = #{type,jdbcType=CHAR},
      city = #{city,jdbcType=VARCHAR},
      province_id = #{provinceId,jdbcType=INTEGER},
      district = #{district,jdbcType=VARCHAR},
      city_id = #{cityId,jdbcType=INTEGER}
    where id = #{id,jdbcType=INTEGER}
  </update>
</mapper>