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;@Mapperpublic interface SysProvCityDistMapper {    int deleteByPrimaryKey(Integer id);    int insert(SysProvCityDist record);    int insertSelective(SysProvCityDist record);    SysProvCityDist selectByPrimaryKey(Integer id);    List
       
         selectByBean(SysProvCityDist sysProvCityDist);    List
        
          selectByBeanVague(SysProvCityDist sysProvCityDist);    int updateByPrimaryKeySelective(SysProvCityDist record);    int updateByPrimaryKey(SysProvCityDist record);}
        
       

       
         
            
             
             
             
             
             
             
           
          
        
             id, province, type, city, province_id, district, city_id  
          
            select         from sys_prov_city_dist    where id = #{id,jdbcType=INTEGER}    
          select    from sys_prov_city_dist  where 1=1      AND province = #{province,jdbcType=VARCHAR}        AND type = #{type,jdbcType=CHAR}        AND city = #{city,jdbcType=VARCHAR}        AND province_id = #{provinceId,jdbcType=INTEGER}        AND district = #{district,jdbcType=VARCHAR}        AND city_id = #{cityId,jdbcType=INTEGER}        AND id = #{id,jdbcType=INTEGER}    
            select        from sys_prov_city_dist    where 1=1          AND province LIKE  CONCAT(#{province,jdbcType=VARCHAR},'%')              AND type = #{type,jdbcType=CHAR}              AND city LIKE  CONCAT(#{city,jdbcType=VARCHAR},'%')              AND province_id = #{provinceId,jdbcType=INTEGER}              AND district LIKE  CONCAT(#{district,jdbcType=VARCHAR},'%')              AND city_id = #{cityId,jdbcType=INTEGER}              AND id = #{id,jdbcType=INTEGER}        
        
             delete from sys_prov_city_dist    where id = #{id,jdbcType=INTEGER}  
          
        
             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 into sys_prov_city_dist    
               
          
                   id,      
                
          
                   province,      
                
          
                   type,      
                
          
                   city,      
                
          
                   province_id,      
                
          
                   district,      
                
          
                   city_id,      
              
             
               
          
                   #{id,jdbcType=INTEGER},      
                
          
                   #{province,jdbcType=VARCHAR},      
                
          
                   #{type,jdbcType=CHAR},      
                
          
                   #{city,jdbcType=VARCHAR},      
                
          
                   #{provinceId,jdbcType=INTEGER},      
                
          
                   #{district,jdbcType=VARCHAR},      
                
          
                   #{cityId,jdbcType=INTEGER},      
              
           
          
        
             update sys_prov_city_dist    
               
          
                   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 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}