省市区 java_省市区三级-javabean和mybatis

id, province, type, city, province_id, district, city_id

selectfrom sys_prov_city_dist

where id = #{id,jdbcType=INTEGER}

selectfrom sys_prov_city_dist

where 1=1AND 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}

selectfrom sys_prov_city_dist

where 1=1AND 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}