Django 省、市、区三级联动及数据库的地址添加 !!!

最新推荐文章于 2022-11-03 15:09:11 发布

Only You~~~

最新推荐文章于 2022-11-03 15:09:11 发布

阅读量1.4k

点赞数 2

分类专栏： django 文章标签： python

本文链接：https://blog.csdn.net/weixin_56052356/article/details/119417344

版权

应用场景

`淘宝`、`京东`等需要地址的地方

在这里插入图片描述

`Models.py`模型

from django.db import models

# Create your models here.
class Area(models.Model):

    name = models.CharField(max_length=128)
    # related_name反向查询
    parent = models.ForeignKey('self',on_delete=models.SET_NULL,related_name='son',null=True)

    def __str__(self):
        return self.name
    class Meta:
        # 必须是tb_areas表
        db_table='tb_areas'
        verbose_name = '区域表'
        verbose_name_plural=verbose_name

`Views.py`接口

from rest_framework.views import APIView
from rest_framework.response import Response

from .models import *
from .ser import *

class AreaAPIView(APIView):

    def get(self,request):
        area_id = request.GET.get('area_id')
        if area_id:
            area = Area.objects.filter(pk=area_id).first()
            one = area.son
        else:
            one = Area.objects.filter(parent__isnull=True).all()
        ser = AreaSer(one,many=True)
        return Response({
   'area_list':ser.data})

`Url.py`路由

from django.urls import path
from . import views
urlpatterns = [
    path('area/',views.AreaAPIView.as_view())
]

`main.js`配置全局`axios`

// The Vue build version to load with the `import` command
// (runtime-only or standalone) has been set in webpack.base.conf with an alias.
import Vue from 'vue'
import App from './App'
import router from './router'

// 配置全局axios
import axios from 'axios'
Vue.prototype.axios=axios
axios.defaults.baseURL = 'http://127.0.0.1:8000'

Vue.config.productionTip = false

/* eslint-disable no-new */
new Vue({
  el: '#app',
  router,
  components: { App },
  template: '<App/>'
})

`index.js` , 页面网址默认为`Area`

import Vue from 'vue'
import Router from 'vue-router'
import Area from '@/components/Area'

Vue.use(Router)

export default new Router({
  // 去除#号
  mode:'history',
  routes: [
    {
      path: '/',
      name: 'Area',
      component: Area
    }
  ]
})

`Vue`页面

<template>
    <div>
        <label>所在地区：</label>
        <select v-model="area" @change="addCity">
            <option :value="i.id" v-for = "i in area_list" :key="i.id">{
  {i.name}}</option>
        </select>
        <select v-model="city" @change="addSection">
            <option :value="i.id" v-for="i in city_list" :key="i.id">{
  {i.name}}</option>
        </select>
        <select v-model="section">
            <option :value="i.id" v-for="i in section_list" :key="i.id">{
  {i.name}}</option>
        </select>
    </div>
</template>

<script>

export default {
    data() {
        return {
            area:'',
            city:'',
            section:'',
            area_list:[],
            city_list:[],
            section_list:[]
        }
    },
    methods: {
        addSection(){
            this.axios.get('/app01/area/?area_id='+this.city).then(res=>{
                console.log(res.data)
                this.section_list = res.data.area_list
            })
        },
        addCity(){
            this.axios.get('/app01/area/?area_id='+this.area).then(res=>{
                console.log(res.data)
                this.city_list = res.data.area_list
            })
        },
        getAreas(){
            this.axios.get('/app01/area/').then(res=>{
                console.log(res.data)
                this.area_list = res.data.area_list
            })
        }
    },
    created() {
        this.getAreas()
    }
}
</script>

<style scoped>

</style>

效果展示

在这里插入图片描述

数据库`地址添加`

INSERT INTO `tb_areas` VALUES ('110000', '北京市', NULL);
INSERT INTO `tb_areas` VALUES ('110100', '北京市', '110000');
INSERT INTO `tb_areas` VALUES ('110101', '东城区', '110100');
INSERT INTO `tb_areas` VALUES ('110102', '西城区', '110100');
INSERT INTO `tb_areas` VALUES ('110105', '朝阳区', '110100');
INSERT INTO `tb_areas` VALUES ('110106', '丰台区', '110100');
INSERT INTO `tb_areas` VALUES ('110107', '石景山区', '110100');
INSERT INTO `tb_areas` VALUES ('110108', '海淀区', '110100');
INSERT INTO `tb_areas` VALUES ('110109', '门头沟区', '110100');
INSERT INTO `tb_areas` VALUES ('110111', '房山区', '110100');
INSERT INTO `tb_areas` VALUES ('110112', '通州区', '110100');
INSERT INTO `tb_areas` VALUES ('110113', '顺义区', '110100');
INSERT INTO `tb_areas` VALUES ('110114', '昌平区', '110100');
INSERT INTO `tb_areas` VALUES ('110115', '大兴区', '110100');
INSERT INTO `tb_areas` VALUES ('110116', '怀柔区', '110100');
INSERT INTO `tb_areas` VALUES ('110117', '平谷区', '110100');
INSERT INTO `tb_areas` VALUES ('110118', '密云区', '110100');
INSERT INTO `tb_areas` VALUES ('110119', '延庆区', '110100');
INSERT INTO `tb_areas` VALUES ('120000', '天津市', NULL);
INSERT INTO `tb_areas` VALUES ('120100', '天津市', '120000');
INSERT INTO `tb_areas` VALUES ('120101', '和平区', '120100');
INSERT INTO `tb_areas` VALUES ('120102', '河东区', '120100');
INSERT INTO `tb_areas` VALUES ('120103', '河西区', '120100');
INSERT INTO `tb_areas` VALUES ('120104', '南开区', '120100');
INSERT INTO `tb_areas` VALUES ('120105', '河北区', '120100');
INSERT INTO `tb_areas` VALUES ('120106', '红桥区', '120100');
INSERT INTO `tb_areas` VALUES ('120110', '东丽区', '120100');
INSERT INTO `tb_areas` VALUES ('120111', '西青区', '120100');
INSERT INTO `tb_areas` VALUES ('120112', '津南区', '120100');
INSERT INTO `tb_areas` VALUES ('120113', '北辰区', '120100');
INSERT INTO `tb_areas` VALUES ('120114', '武清区', '120100');
INSERT INTO `tb_areas` VALUES ('120115', '宝坻区', '120100');
INSERT INTO `tb_areas` VALUES ('120116', '滨海新区', '120100');
INSERT INTO `tb_areas` VALUES ('120117', '宁河区', '120100');
INSERT INTO `tb_areas` VALUES ('120118', '静海区', '120100');
INSERT INTO `tb_areas` VALUES ('120119', '蓟州区', '120100');
INSERT INTO `tb_areas` VALUES ('130000', '河北省', NULL);
INSERT INTO `tb_areas` VALUES ('130100', '石家庄市', '130000');
INSERT INTO `tb_areas` VALUES ('130102', '长安区', '130100');
INSERT INTO `tb_areas` VALUES ('130104', '桥西区', '130100');
INSERT INTO `tb_areas` VALUES ('130105', '新华区', '130100');
INSERT INTO `tb_areas` VALUES ('130107', '井陉矿区', '130100');
INSERT INTO `tb_areas` VALUES ('130108', '裕华区', '130100');
INSERT INTO `tb_areas` VALUES ('130109', '藁城区', '130100');
INSERT INTO `tb_areas` VALUES ('130110', '鹿泉区', '130100');
INSERT INTO `tb_areas` VALUES ('130111', '栾城区', '130100');
INSERT INTO `tb_areas` VALUES ('130121', '井陉县', '130100');
INSERT INTO `tb_areas` VALUES ('130123', '正定县', '130100');
INSERT INTO `tb_areas` VALUES ('130125', '行唐县', '130100');
INSERT INTO `tb_areas` VALUES ('130126', '灵寿县', '130100');
INSERT INTO `tb_areas` VALUES ('130127', '高邑县', '130100');
INSERT INTO `tb_areas` VALUES ('130128', '深泽县', '130100');
INSERT INTO `tb_areas` VALUES ('130129', '赞皇县', '130100');
INSERT INTO `tb_areas` VALUES ('130130', '无极县', '130100');
INSERT INTO `tb_areas` VALUES ('130131', '平山县', '130100');
INSERT INTO `tb_areas` VALUES ('130132', '元氏县', '130100');
INSERT INTO `tb_areas` VALUES ('130133', '赵县', '130100');
INSERT INTO `tb_areas` VALUES ('130183', '晋州市', '130100');
INSERT INTO `tb_areas` VALUES ('130184', '新乐市', '130100');
INSERT INTO `tb_areas` VALUES ('130200', '唐山市', '130000');
INSERT INTO `tb_areas` VALUES ('130202', '路南区', '130200');
INSERT INTO `tb_areas` VALUES ('130203', '路北区', '130200');
INSERT INTO `tb_areas` VALUES ('130204', '古冶区', '130200');
INSERT INTO `tb_areas` VALUES ('130205', '开平区', '130200');
INSERT INTO `tb_areas` VALUES ('130207', '丰南区', '130200');
INSERT INTO `tb_areas` VALUES ('130208', '丰润区', '130200');
INSERT INTO `tb_areas` VALUES ('130209', '曹妃甸区', '130200');
INSERT INTO `tb_areas` VALUES ('130223', '滦县', '130200');
INSERT INTO `tb_areas` VALUES ('130224', '滦南县', '130200');
INSERT INTO `tb_areas` VALUES ('130225', '乐亭县', '130200');
INSERT INTO `tb_areas` VALUES ('130227', '迁西县', '130200');
INSERT INTO `tb_areas` VALUES ('130229', '玉田县', '130200');
INSERT INTO `tb_areas` VALUES ('130281', '遵化市', '130200');
INSERT INTO `tb_areas` VALUES ('130283', '迁安市', '130200');
INSERT INTO `tb_areas` VALUES ('130300', '秦皇岛市', '130000');
INSERT INTO `tb_areas` VALUES ('130302', '海港区', '130300');
INSERT INTO `tb_areas` VALUES ('130303', '山海关区', '130300');
INSERT INTO `tb_areas` VALUES ('130304', '北戴河区', '130300');
INSERT INTO `tb_areas` VALUES ('130306', '抚宁区', '130300');
INSERT INTO `tb_areas` VALUES ('130321', '青龙满族自治县', '130300');
INSERT INTO `tb_areas` VALUES ('130322', '昌黎县', '130300');
INSERT INTO `tb_areas` VALUES ('130324', '卢龙县', '130300');
INSERT INTO `tb_areas` VALUES ('130400', '邯郸市', '130000');
INSERT INTO `tb_areas` VALUES ('130402', '邯山区', '130400');
INSERT INTO `tb_areas` VALUES ('130403', '丛台区', '130400');
INSERT INTO `tb_areas` VALUES ('130404', '复兴区', '130400');
INSERT INTO `tb_areas` VALUES ('130406', '峰峰矿区', '130400');
INSERT INTO `tb_areas` VALUES ('130421', '邯郸县', '130400');
INSERT INTO `tb_areas` VALUES ('130423', '临漳县', '130400');
INSERT INTO `tb_areas` VALUES ('130424', '成安县', '130400');
INSERT INTO `tb_areas` VALUES ('130425', '大名县', '130400');
INSERT INTO `tb_areas` VALUES ('130426', '涉县', '130400');
INSERT INTO `tb_areas` VALUES ('130427', '磁县', '130400');
INSERT INTO `tb_areas` VALUES ('130428', '肥乡县', '130400');
INSERT INTO `tb_areas` VALUES ('130429', '永年县', '130400');
INSERT INTO `tb_areas` VALUES ('130430', '邱县', '130400');
INSERT INTO `tb_areas` VALUES ('130431', '鸡泽县', '130400');
INSERT INTO `tb_areas` VALUES ('130432', '广平县', '130400');
INSERT INTO `tb_areas` VALUES ('130433', '馆陶县', '130400');
INSERT INTO `tb_areas` VALUES ('130434', '魏县', '130400');
INSERT INTO `tb_areas` VALUES ('130435', '曲周县', '130400');
INSERT INTO `tb_areas` VALUES ('130481', '武安市', '130400');
INSERT INTO `tb_areas` VALUES ('130500', '邢台市', '130000');
INSERT INTO `tb_areas` VALUES ('130502', '桥东区', '130500');
INSERT INTO `tb_areas` VALUES ('130503', '桥西区', '130500');
INSERT INTO `tb_areas` VALUES ('130521', '邢台县', '130500');
INSERT INTO `tb_areas` VALUES ('130522', '临城县', '130500');
INSERT INTO `tb_areas` VALUES ('130523', '内丘县', '130500');
INSERT INTO `tb_areas` VALUES ('130524', '柏乡县', '130500');
INSERT INTO `tb_areas` VALUES ('130525', '隆尧县', '130500');
INSERT INTO `tb_areas` VALUES ('130526', '任县', '130500');
INSERT INTO `tb_areas` VALUES ('130527', '南和县', '130500');
INSERT INTO `tb_areas` VALUES ('130528', '宁晋县', '130500');
INSERT INTO `tb_areas` VALUES ('130529', '巨鹿县', '130500');
INSERT INTO `tb_areas` VALUES ('130530', '新河县', '130500');
INSERT INTO `tb_areas` VALUES ('130531', '广宗县', '130500');
INSERT INTO `tb_areas` VALUES ('130532', '平乡县', '130500');
INSERT INTO `tb_areas` VALUES ('130533', '威县', '130500');
INSERT INTO `tb_areas` VALUES ('130534', '清河县', '130500');
INSERT INTO `tb_areas` VALUES ('130535', '临西县', '130500');
INSERT INTO `tb_areas` VALUES ('130581', '南宫市', '130500');
INSERT INTO `tb_areas` VALUES ('130582', '沙河市', '130500');
INSERT INTO `tb_areas` VALUES ('130600', '保定市', '130000');
INSERT INTO `tb_areas` VALUES ('130602', '竞秀区', '130600');
INSERT INTO `tb_areas` VALUES ('130606', '莲池区', '130600');
INSERT INTO `tb_areas` VALUES ('130607', '满城区', '130600');
INSERT INTO `tb_areas` VALUES ('130608', '清苑区', '130600');
INSERT INTO `tb_areas` VALUES ('130609', '徐水区', '130600');
INSERT INTO `tb_areas` VALUES ('130623', '涞水县', '130600');
INSERT INTO `tb_areas` VALUES ('130624', '阜平县', '130600');
INSERT INTO `tb_areas` VALUES ('130626', '定兴县', '130600');
INSERT INTO `tb_areas` VALUES ('130627', '唐县', '130600');
INSERT INTO `tb_areas` VALUES ('130628', '高阳县', '130600');
INSERT INTO `tb_areas` VALUES ('130629', '容城县', '130600');
INSERT INTO `tb_areas` VALUES ('130630', '涞源县', '130600');
INSERT INTO `tb_areas` VALUES ('130631', '望都县', '130600');
INSERT INTO `tb_areas` VALUES ('130632', '安新县', '130600');
INSERT INTO `tb_areas` VALUES ('130633', '易县', '130600');
INSERT INTO `tb_areas` VALUES ('130634', '曲阳县', '130600');
INSERT INTO `tb_areas` VALUES ('130635', '蠡县', '130600');
INSERT INTO `tb_areas` VALUES ('130636', '顺平县', '130600');
INSERT INTO `tb_areas` VALUES ('130637', '博野县', '130600');
INSERT INTO `tb_areas` VALUES ('130638', '雄县', '130600');
INSERT INTO `tb_areas` VALUES ('130681', '涿州市', '130600');
INSERT INTO `tb_areas` VALUES ('130683', '安国市', '130600');
INSERT INTO `tb_areas` VALUES ('130684', '高碑店市', '130600');
INSERT INTO `tb_areas` VALUES ('130700', '张家口市', '130000');
INSERT INTO `tb_areas` VALUES ('130702', '桥东区', '130700');
INSERT INTO `tb_areas` VALUES ('130703', '桥西区', '130700');
INSERT INTO `tb_areas` VALUES ('130705', '宣化区', '130700');
INSERT INTO `tb_areas` VALUES ('130706', '下花园区', '130700');
INSERT INTO `tb_areas` VALUES ('130708', '万全区', '130700');
INSERT INTO `tb_areas` VALUES ('130709', '崇礼区', '130700');
INSERT INTO `tb_areas` VALUES ('130722', '张北县', '130700');
INSERT INTO `tb_areas` VALUES ('130723', '康保县', '130700');
INSERT INTO `tb_areas` VALUES ('130724', '沽源县', '130700');
INSERT INTO `tb_areas` VALUES ('130725', '尚义县', '130700');
INSERT INTO `tb_areas` VALUES ('130726', '蔚县', '130700');
INSERT INTO `tb_areas` VALUES ('130727', '阳原县', '130700');
INSERT INTO `tb_areas` VALUES ('130728', '怀安县', '130700');
INSERT INTO `tb_areas` VALUES ('130730', '怀来县', '130700');
INSERT INTO `tb_areas` VALUES ('130731', '涿鹿县', '130700');
INSERT INTO `tb_areas` VALUES ('130732', '赤城县', '130700');
INSERT INTO `tb_areas` VALUES ('130800', '承德市', '130000');
INSERT INTO `tb_areas` VALUES ('130802', '双桥区', '130800');
INSERT INTO `tb_areas` VALUES ('130803', '双滦区', '130800');
INSERT INTO `tb_areas` VALUES ('130804', '鹰手营子矿区', '130800');
INSERT INTO `tb_areas` VALUES ('130821', '承德县', '130800');
INSERT INTO `tb_areas` VALUES ('130822', '兴隆县', '130800');
INSERT INTO `tb_areas` VALUES ('130823', '平泉县', '130800');
INSERT INTO `tb_areas` VALUES ('130824', '滦平县', '130800');
INSERT INTO `tb_areas` VALUES ('130825', '隆化县', '130800');
INSERT INTO `tb_areas` VALUES ('130826', '丰宁满族自治县', '130800');
INSERT INTO `tb_areas` VALUES ('130827', '宽城满族自治县', '130800');
INSERT INTO `tb_areas` VALUES ('130828', '围场满族蒙古族自治县', '130800');
INSERT INTO `tb_areas` VALUES ('130900', '沧州市', '130000');
INSERT INTO `tb_areas` VALUES ('130902', '新华区', '130900');
INSERT INTO `tb_areas` VALUES ('130903', '运河区', '130900');
INSERT INTO `tb_areas` VALUES ('130921', '沧县', '130900');
INSERT INTO `tb_areas` VALUES ('130922', '青县', '130900');
INSERT INTO `tb_areas` VALUES ('130923', '东光县', '130900');
INSERT INTO `tb_areas` VALUES ('130924', '海兴县', '130900');
INSERT INTO `tb_areas` VALUES ('130925', '盐山县', '130900');
INSERT INTO `tb_areas` VALUES ('130926', '肃宁县', '130900');
INSERT INTO `tb_areas` VALUES ('130927', '南皮县', '130900');
INSERT INTO `tb_areas` VALUES ('130928', '吴桥县', '130900');
INSERT INTO `tb_areas` VALUES ('130929', '献县', '130900');
INSERT INTO `tb_areas` VALUES ('130930', '孟村回族自治县', '130900');
INSERT INTO `tb_areas` VALUES ('130981', '泊头市', '130900');
INSERT INTO `tb_areas` VALUES ('130982', '任丘市', '130900');
INSERT INTO `tb_areas` VALUES ('130983', '黄骅市', '130900');
INSERT INTO `tb_areas` VALUES ('130984', '河间市', '130900');
INSERT INTO `tb_areas` VALUES ('131000', '廊坊市', '130000');
INSERT INTO `tb_areas` VALUES ('131002', '安次区', '131000');
INSERT INTO `tb_areas` VALUES ('131003', '广阳区', '131000');
INSERT INTO `tb_areas` VALUES ('131022', '固安县', '131000');
INSERT INTO `tb_areas` VALUES ('131023', '永清县', '131000');
INSERT INTO `tb_areas` VALUES ('131024', '香河县', '131000');
INSERT INTO `tb_areas` VALUES ('131025', '大城县', '131000');
INSERT INTO `tb_areas` VALUES ('131026', '文安县', '131000');
INSERT INTO `tb_areas` VALUES ('131028', '大厂回族自治县', '131000');
INSERT INTO `tb_areas` VALUES ('131081', '霸州市', '131000');
INSERT INTO `tb_areas` VALUES ('131082', '三河市', '131000');
INSERT INTO `tb_areas` VALUES ('131100', '衡水市', '130000');
INSERT INTO `tb_areas` VALUES ('131102', '桃城区', '131100');
INSERT INTO `tb_areas` VALUES ('131103', '冀州区', '131100');
INSERT INTO `tb_areas` VALUES ('131121', '枣强县', '131100');
INSERT INTO `tb_areas` VALUES ('131122', '武邑县', '131100');
INSERT INTO `tb_areas` VALUES ('131123', '武强县', '131100');
INSERT INTO `tb_areas` VALUES ('131124', '饶阳县', '131100');
INSERT INTO `tb_areas` VALUES ('131125', '安平县', '131100');
INSERT INTO `tb_areas` VALUES ('131126', '故城县', '131100');
INSERT INTO `tb_areas` VALUES ('131127', '景县', '131100');
INSERT INTO `tb_areas` VALUES ('131128', '阜城县', '131100');
INSERT INTO `tb_areas` VALUES ('131182', '深州市', '131100');
INSERT INTO `tb_areas` VALUES ('139000', '省直辖县级行政区划', '130000');
INSERT INTO `tb_areas` VALUES ('139001', '定州市', '139000');
INSERT INTO `tb_areas` VALUES ('139002', '辛集市', '139000');
INSERT INTO `tb_areas` VALUES ('140000', '山西省', NULL);
INSERT INTO `tb_areas` VALUES ('140100', '太原市', '140000');
INSERT INTO `tb_areas` VALUES ('140105', '小店区', '140100');
INSERT INTO `tb_areas` VALUES ('140106', '迎泽区', '140100');
INSERT INTO `tb_areas` VALUES ('140107', '杏花岭区', '140100');
INSERT INTO `tb_areas` VALUES ('140108', '尖草坪区', '140100');
INSERT INTO `tb_areas` VALUES ('140109', '万柏林区', '140100');
INSERT INTO `tb_areas` VALUES ('140110', '晋源区', '140100');
INSERT INTO `tb_areas` VALUES ('140121', '清徐县', '140100');
INSERT INTO `tb_areas` VALUES ('140122', '阳曲县', '140100');
INSERT INTO `tb_areas` VALUES ('140123', '娄烦县', '140100');
INSERT INTO `tb_areas` VALUES ('140181', '古交市', '140100');
INSERT INTO `tb_areas` VALUES ('140200', '大同市', '140000');
INSERT INTO `tb_areas` VALUES ('140202', '城区', '140200');
INSERT INTO `tb_areas` VALUES ('140203', '矿区', '140200');
INSERT INTO `tb_areas` VALUES ('140211', '南郊区', '140200');
INSERT INTO `tb_areas` VALUES ('140212', '新荣区', '140200');
INSERT INTO `tb_areas` VALUES ('140221', '阳高县', '140200');
INSERT INTO `tb_areas` VALUES ('140222', '天镇县', '140200');
INSERT INTO `tb_areas` VALUES ('140223', '广灵县', '140200');
INSERT INTO `tb_areas` VALUES ('140224', '灵丘县', '140200');
INSERT INTO `tb_areas` VALUES ('140225', '浑源县', '140200');
INSERT INTO `tb_areas` VALUES ('140226', '左云县', '140200');
INSERT INTO `tb_areas` VALUES ('140227', '大同县', '140200');
INSERT INTO `tb_areas` VALUES ('140300', '阳泉市', '140000');
INSERT INTO `tb_areas` VALUES ('140302', '城区', '140300');
INSERT INTO `tb_areas` VALUES ('140303', '矿区', '140300');
INSERT INTO `tb_areas` VALUES ('140311', '郊区', '140300');
INSERT INTO `tb_areas` VALUES ('140321', '平定县', '140300');
INSERT INTO `tb_areas` VALUES ('140322', '盂县', '140300');
INSERT INTO `tb_areas` VALUES ('140400', '长治市', '140000');
INSERT INTO `tb_areas` VALUES ('140402', '城区', '140400');
INSERT INTO `tb_areas` VALUES ('140411', '郊区', '140400');
INSERT INTO `tb_areas` VALUES ('140421', '长治县', '140400');
INSERT INTO `tb_areas` VALUES ('140423', '襄垣县', '140400');
INSERT INTO `tb_areas` VALUES ('140424', '屯留县', '140400');
INSERT INTO `tb_areas` VALUES ('140425', '平顺县', '140400');
INSERT INTO `tb_areas` VALUES ('140426', '黎城县', '140400');
INSERT INTO `tb_areas` VALUES ('140427', '壶关县', '140400');
INSERT INTO `tb_areas` VALUES ('140428', '长子县', '140400');
INSERT INTO `tb_areas` VALUES ('140429', '武乡县', '140400');
INSERT INTO `tb_areas` VALUES ('140430', '沁县', '140400');
INSERT INTO `tb_areas` VALUES ('140431', '沁源县', '140400');
INSERT INTO `tb_areas` VALUES ('140481', '潞城市', '140400');
INSERT INTO `tb_areas` VALUES ('140500', '晋城市', '140000');
INSERT INTO `tb_areas` VALUES ('140502', '城区', '140500');
INSERT INTO `tb_areas` VALUES ('140521', '沁水县', '140500');
INSERT INTO `tb_areas` VALUES ('140522', '阳城县', '140500');
INSERT INTO `tb_areas` VALUES ('140524', '陵川县', '140500');
INSERT INTO `tb_areas` VALUES ('140525', '泽州县', '140500');
INSERT INTO `tb_areas` VALUES ('140581', '高平市', '140500');
INSERT INTO `tb_areas` VALUES ('140600', '朔州市', '140000');
INSERT INTO `tb_areas` VALUES ('140602', '朔城区', '140600');
INSERT INTO `tb_areas` VALUES ('140603', '平鲁区', '140600');
INSERT INTO `tb_areas` VALUES ('140621', '山阴县', '140600');
INSERT INTO `tb_areas` VALUES ('140622', '应县', '140600');
INSERT INTO `tb_areas` VALUES ('140623', '右玉县', '140600');
INSERT INTO `tb_areas` VALUES ('140624', '怀仁县', '140600');
INSERT INTO `tb_areas` VALUES ('140700', '晋中市', '140000');
INSERT INTO `tb_areas` VALUES ('140702', '榆次区', '140700');
INSERT INTO `tb_areas` VALUES ('140721', '榆社县', '140700');
INSERT INTO `tb_areas` VALUES ('140722', '左权县', '140700');
INSERT INTO `tb_areas` VALUES ('140723', '和顺县', '140700');
INSERT INTO `tb_areas` VALUES ('140724', '昔阳县', '140700');
INSERT INTO `tb_areas` VALUES ('140725', '寿阳县', '140700');
INSERT INTO `tb_areas` VALUES ('140726', '太谷县', '140700');
INSERT INTO `tb_areas` VALUES ('140727', '祁县', '140700');
INSERT INTO `tb_areas` VALUES ('140728', '平遥县', '140700');
INSERT INTO `tb_areas` VALUES ('140729', '灵石县', '140700');
INSERT INTO `tb_areas` VALUES ('140781', '介休市', '140700');
INSERT INTO `tb_areas` VALUES ('140800', '运城市', '140000');
INSERT INTO `tb_areas` VALUES ('140802', '盐湖区', '140800');
INSERT INTO `tb_areas` VALUES ('140821', '临猗县', '140800');
INSERT INTO `tb_areas` VALUES ('140822', '万荣县', '140800');
INSERT INTO `tb_areas` VALUES ('140823', '闻喜县', '140800');
INSERT INTO `tb_areas` VALUES ('140824', '稷山县', '140800');
INSERT INTO `tb_areas` VALUES ('140825', '新绛县', '140800');
INSERT INTO `tb_areas` VALUES ('140826', '绛县', '140800');
INSERT INTO `tb_areas` VALUES ('140827', '垣曲县', '140800');
INSERT INTO `tb_areas` VALUES ('140828', '夏县', '140800');
INSERT INTO `tb_areas` VALUES ('140829', '平陆县', '140800');
INSERT INTO `tb_areas` VALUES ('140830', '芮城县', '140800');
INSERT INTO `tb_areas` VALUES ('140881', '永济市', '140800');
INSERT INTO `tb_areas` VALUES ('140882', '河津市', '140800');
INSERT INTO `tb_areas` VALUES ('140900', '忻州市', '140000');
INSERT INTO `tb_areas` VALUES ('140902', '忻府区', '140900');
INSERT INTO `tb_areas` VALUES ('140921', '定襄县', '140900');
INSERT INTO `tb_areas` VALUES ('140922', '五台县', '140900');
INSERT INTO `tb_areas` VALUES ('140923', '代县', '140900');
INSERT INTO `tb_areas` VALUES ('140924', '繁峙县', '140900');
INSERT INTO `tb_areas` VALUES ('140925', '宁武县', '140900');
INSERT INTO `tb_areas` VALUES ('140926', '静乐县', '140900');
INSERT INTO `tb_areas` VALUES ('140927', '神池县', '140900');
INSERT INTO `tb_areas` VALUES ('140928', '五寨县', '140900');
INSERT INTO `tb_areas` VALUES ('140929', '岢岚县', '140900');
INSERT INTO `tb_areas` VALUES ('140930', '河曲县', '140900');
INSERT INTO `tb_areas` VALUES ('140931', '保德县', '140900');
INSERT INTO `tb_areas` VALUES ('140932', '偏关县', '140900');
INSERT INTO `tb_areas` VALUES ('140981', '原平市', '140900');
INSERT INTO `tb_areas` VALUES ('141000', '临汾市', '140000');
INSERT INTO `tb_areas` VALUES ('141002', '尧都区', '141000');
INSERT INTO `tb_areas` VALUES ('141021', '曲沃县', '141000');
INSERT INTO `tb_areas` VALUES ('141022', '翼城县', '141000');
INSERT INTO `tb_areas` VALUES ('141023', '襄汾县', '141000');
INSERT INTO `tb_areas` VALUES ('141024', '洪洞县', '141000');
INSERT INTO `tb_areas` VALUES ('141025', '古县', '141000');
INSERT INTO `tb_areas` VALUES ('141026', '安泽县', '141000');
INSERT INTO `tb_areas` VALUES ('141027', '浮山县', '141000');
INSERT INTO `tb_areas` VALUES ('141028', '吉县', '141000');
INSERT INTO `tb_areas` VALUES ('141029', '乡宁县', '141000');
INSERT INTO `tb_areas` VALUES ('141030', '大宁县', '141000');
INSERT INTO `tb_areas` VALUES ('141031', '隰县', '141000');
INSERT INTO `tb_areas` VALUES ('141032', '永和县', '141000');
INSERT INTO `tb_areas` VALUES ('141033', '蒲县', '141000');
INSERT INTO `tb_areas` VALUES ('141034', '汾西县', '141000');
INSERT INTO `tb_areas` VALUES ('141081', '侯马市', '141000');
INSERT INTO `tb_areas` VALUES ('141082', '霍州市', '141000');
INSERT INTO `tb_areas` VALUES ('141100', '吕梁市', '140000');
INSERT INTO `tb_areas` VALUES ('141102', '离石区', '141100');
INSERT INTO `tb_areas` VALUES ('141121', '文水县', '141100');
INSERT INTO `tb_areas` VALUES ('141122', '交城县', '141100');
INSERT INTO `tb_areas` VALUES ('141123', '兴县', '141100');
INSERT INTO `tb_areas` VALUES ('141124', '临县', '141100');
INSERT INTO `tb_areas` VALUES ('141125', '柳林县', '141100');
INSERT INTO `tb_areas` VALUES ('141126', '石楼县', '141100');
INSERT INTO `tb_areas` VALUES ('141127', '岚县', '141100');
INSERT INTO `tb_areas` VALUES ('141128', '方山县', '141100');
INSERT INTO `tb_areas` VALUES ('141129', '中阳县', '141100');
INSERT INTO `tb_areas` VALUES ('141130', '交口县', '141100');
INSERT INTO `tb_areas` VALUES ('141181', '孝义市', '141100');
INSERT INTO `tb_areas` VALUES ('141182', '汾阳市', '141100');
INSERT INTO `tb_areas` VALUES ('150000', '内蒙古自治区', NULL);
INSERT INTO `tb_areas` VALUES ('150100', '呼和浩特市', '150000');
INSERT INTO `tb_areas` VALUES ('150102', '新城区', '150100');
INSERT INTO `tb_areas` VALUES ('150103', '回民区', '150100');
INSERT INTO `tb_areas` VALUES ('150104', '玉泉区', '150100');
INSERT INTO `tb_areas` VALUES ('150105', '赛罕区', '150100');
INSERT INTO `tb_areas` VALUES ('150121', '土默特左旗', '150100');
INSERT INTO `tb_areas` VALUES ('150122', '托克托县', '150100');
INSERT INTO `tb_areas` VALUES ('150123', '和林格尔县', '150100');
INSERT INTO `tb_areas` VALUES ('150124', '清水河县', '150100');
INSERT INTO `tb_areas` VALUES ('150125', '武川县', '150100');
INSERT INTO `tb_areas` VALUES ('150200', '包头市', '150000');
INSERT INTO `tb_areas` VALUES ('150202', '东河区', '150200');
INSERT INTO `tb_areas` VALUES ('150203', '昆都仑区', '150200');
INSERT INTO `tb_areas` VALUES ('150204', '青山区', '150200');
INSERT INTO `tb_areas` VALUES ('150205', '石拐区', '150200');
INSERT INTO `tb_areas` VALUES ('150206', '白云鄂博矿区', '150200');
INSERT INTO `tb_areas` VALUES ('150207', '九原区', '150200');
INSERT INTO `tb_areas` VALUES ('150221', '土默特右旗', '150200');
INSERT INTO `tb_areas` VALUES ('150222', '固阳县', '150200');
INSERT INTO `tb_areas` VALUES ('150223', '达尔罕茂明安联合旗', '150200');
INSERT INTO `tb_areas` VALUES ('150300', '乌海市', '150000');
INSERT INTO `tb_areas` VALUES ('150302', '海勃湾区', '150300');
INSERT INTO `tb_areas` VALUES ('150303', '海南区', '150300');
INSERT INTO `tb_areas` VALUES ('150304', '乌达区', '150300');
INSERT INTO `tb_areas` VALUES ('150400', '赤峰市', '150000');
INSERT INTO `tb_areas` VALUES ('150402', '红山区', '150400');
INSERT INTO `tb_areas` VALUES ('150403', '元宝山区', '150400');
INSERT INTO `tb_areas` VALUES ('150404', '松山区', '150400');
INSERT INTO `tb_areas` VALUES ('150421', '阿鲁科尔沁旗', '150400');
INSERT INTO `tb_areas` VALUES ('150422', '巴林左旗', '150400');
INSERT INTO `tb_areas` VALUES ('150423', '巴林右旗', '150400');
INSERT INTO `tb_areas` VALUES ('150424', '林西县', '150400');
INSERT INTO `tb_areas` VALUES ('150425', '克什克腾旗', '150400');
INSERT INTO `tb_areas` VALUES ('150426', '翁牛特旗', '150400');
INSERT INTO `tb_areas` VALUES ('150428', '喀喇沁旗', '150400');
INSERT INTO `tb_areas` VALUES ('150429', '宁城县', '150400');
INSERT INTO `tb_areas` VALUES ('150430', '敖汉旗', '150400');
INSERT INTO `tb_areas` VALUES ('150500', '通辽市', '150000');
INSERT INTO `tb_areas` VALUES ('150502', '科尔沁区', '150500');
INSERT INTO `tb_areas` VALUES ('150521', '科尔沁左翼中旗', '150500');
INSERT INTO `tb_areas` VALUES ('150522', '科尔沁左翼后旗', '150500');
INSERT INTO `tb_areas` VALUES ('150523', '开鲁县', '150500');
INSERT INTO `tb_areas` VALUES ('150524', '库伦旗', '150500');
INSERT INTO `tb_areas` VALUES ('150525', '奈曼旗', '150500');
INSERT INTO `tb_areas` VALUES ('150526', '扎鲁特旗', '150500');
INSERT INTO `tb_areas` VALUES ('150581', '霍林郭勒市', '150500');
INSERT INTO `tb_areas` VALUES ('150600', '鄂尔多斯市', '150000');
INSERT INTO `tb_areas` VALUES ('150602', '东胜区', '150600');
INSERT INTO `tb_areas` VALUES ('150603', '康巴什区', '150600');
INSERT INTO `tb_areas` VALUES ('150621', '达拉特旗', '150600');
INSERT INTO `tb_areas` VALUES ('150622', '准格尔旗', '150600');
INSERT INTO `tb_areas` VALUES ('150623', '鄂托克前旗', '150600');
INSERT INTO `tb_areas` VALUES ('150624', '鄂托克旗', '150600');
INSERT INTO `tb_areas` VALUES ('150625', '杭锦旗', '150600');
INSERT INTO `tb_areas` VALUES ('150626', '乌审旗', '150600');
INSERT INTO `tb_areas` VALUES ('150627', '伊金霍洛旗', '150600');
INSERT INTO `tb_areas` VALUES ('150700', '呼伦贝尔市', '150000');
INSERT INTO `tb_areas` VALUES ('150702', '海拉尔区', '150700');
INSERT INTO `tb_areas` VALUES ('150703', '扎赉诺尔区', '150700');
INSERT INTO `tb_areas` VALUES ('150721', '阿荣旗', '150700');
INSERT INTO `tb_areas` VALUES ('150722', '莫力达瓦达斡尔族自治旗', '150700');
INSERT INTO `tb_areas` VALUES ('150723', '鄂伦春自治旗', '150700');
INSERT INTO `tb_areas` VALUES ('150724', '鄂温克族自治旗', '150700');
INSERT INTO `tb_areas` VALUES ('150725', '陈巴尔虎旗', '150700');
INSERT INTO `tb_areas` VALUES ('150726', '新巴尔虎左旗', '150700');
INSERT INTO `tb_areas` VALUES ('150727', '新巴尔虎右旗', '150700');
INSERT INTO `tb_areas` VALUES ('150781', '满洲里市', '150700');
INSERT INTO `tb_areas` VALUES ('150782', '牙克石市', '150700');
INSERT INTO `tb_areas` VALUES ('150783', '扎兰屯市', '150700');
INSERT INTO `tb_areas` VALUES ('150784', '额尔古纳市', '150700');
INSERT INTO `tb_areas` VALUES ('150785', '根河市', '150700');
INSERT INTO `tb_areas` VALUES ('150800', '巴彦淖尔市', '150000');
INSERT INTO `tb_areas` VALUES ('150802', '临河区', '150800');
INSERT INTO `tb_areas` VALUES ('150821', '五原县', '150800');
INSERT INTO `tb_areas` VALUES ('150822', '磴口县', '150800');
INSERT INTO `tb_areas` VALUES ('150823', '乌拉特前旗', '150800');
INSERT INTO `tb_areas` VALUES ('150824', '乌拉特中旗', '150800');
INSERT INTO `tb_areas` VALUES ('150825', '乌拉特后旗', '150800');
INSERT INTO `tb_areas` VALUES ('150826', '杭锦后旗', '150800');
INSERT INTO `tb_areas` VALUES ('150900', '乌兰察布市', '150000');
INSERT INTO `tb_areas` VALUES ('150902', '集宁区', '150900');
INSERT INTO `tb_areas` VALUES ('150921', '卓资县', '150900');
INSERT INTO `tb_areas` VALUES ('150922', '化德县', '150900');
INSERT INTO `tb_areas` VALUES ('150923', '商都县', '150900');
INSERT INTO `tb_areas` VALUES ('150924', '兴和县', '150900');
INSERT INTO `tb_areas` VALUES ('150925', '凉城县', '150900');
INSERT INTO `tb_areas` VALUES ('150926', '察哈尔右翼前旗', '150900');
INSERT INTO `tb_areas` VALUES ('150927', '察哈尔右翼中旗', '150900');
INSERT INTO `tb_areas` VALUES ('150928', '察哈尔右翼后旗', '150900');
INSERT INTO `tb_areas` VALUES ('150929', '四子王旗', '150900');
INSERT INTO `tb_areas` VALUES ('150981', '丰镇市', '150900');
INSERT INTO `tb_areas` VALUES ('152200', '兴安盟', '150000');
INSERT INTO `tb_areas` VALUES ('152201', '乌兰浩特市', '152200');
INSERT INTO `tb_areas` VALUES ('152202', '阿尔山市', '152200');
INSERT INTO `tb_areas` VALUES ('152221', '科尔沁右翼前旗', '152200');
INSERT INTO `tb_areas` VALUES ('152222', '科尔沁右翼中旗', '152200');
INSERT INTO `tb_areas` VALUES ('152223', '扎赉特旗', '152200');
INSERT INTO `tb_areas` VALUES ('152224', '突泉县', '152200');
INSERT INTO `tb_areas` VALUES ('152500', '锡林郭勒盟', '150000');
INSERT INTO `tb_areas` VALUES ('152501', '二连浩特市', '152500');
INSERT INTO `tb_areas` VALUES ('152502', '锡林浩特市', '152500');
INSERT INTO `tb_areas` VALUES ('152522', '阿巴嘎旗', '152500');
INSERT INTO `tb_areas` VALUES ('152523', '苏尼特左旗', '152500');
INSERT INTO `tb_areas` VALUES ('152524', '苏尼特右旗', '152500');
INSERT INTO `tb_areas` VALUES ('152525', '东乌珠穆沁旗', '152500');
INSERT INTO `tb_areas` VALUES ('152526', '西乌珠穆沁旗', '152500');
INSERT INTO `tb_areas` VALUES ('152527', '太仆寺旗', '152500');
INSERT INTO `tb_areas` VALUES ('152528', '镶黄旗', '152500');
INSERT INTO `tb_areas` VALUES ('152529', '正镶白旗', '152500');
INSERT INTO `tb_areas` VALUES ('152530', '正蓝旗', '152500');
INSERT INTO `tb_areas` VALUES ('152531', '多伦县', '152500');
INSERT INTO `tb_areas` VALUES ('152900', '阿拉善盟', '150000');
INSERT INTO `tb_areas` VALUES ('152921', '阿拉善左旗', '152900');
INSERT INTO `tb_areas` VALUES ('152922', '阿拉善右旗', '152900');
INSERT INTO `tb_areas` VALUES ('152923', '额济纳旗', '152900');
INSERT INTO `tb_areas` VALUES ('210000', '辽宁省', NULL);
INSERT INTO `tb_areas` VALUES ('210100', '沈阳市', '210000');
INSERT INTO `tb_areas` VALUES ('210102', '和平区', '210100');
INSERT INTO `tb_areas` VALUES ('210103', '沈河区', '210100');
INSERT INTO `tb_areas` VALUES ('210104', '大东区', '210100');
INSERT INTO `tb_areas` VALUES ('210105', '皇姑区', '210100');
INSERT INTO `tb_areas` VALUES ('210106', '铁西区', '210100');
INSERT INTO `tb_areas` VALUES ('210111', '苏家屯区', '210100');
INSERT INTO `tb_areas` VALUES ('210112', '浑南区', '210100');
INSERT INTO `tb_areas` VALUES ('210113', '沈北新区', '210100');
INSERT INTO `tb_areas` VALUES ('210114', '于洪区', '210100');
INSERT INTO `tb_areas` VALUES ('210115', '辽中区', '210100');
INSERT INTO `tb_areas` VALUES ('210123', '康平县', '210100');
INSERT INTO `tb_areas` VALUES ('210124', '法库县', '210100');
INSERT INTO `tb_areas` VALUES ('210181', '新民市', '210100');
INSERT INTO `tb_areas` VALUES ('210200', '大连市', '210000');
INSERT INTO `tb_areas` VALUES ('210202', '中山区', '210200');
INSERT INTO `tb_areas` VALUES ('210203', '西岗区', '210200');
INSERT INTO `tb_areas` VALUES ('210204', '沙河口区', '210200');
INSERT INTO `tb_areas` VALUES ('210211', '甘井子区', '210200');
INSERT INTO `tb_areas` VALUES ('210212', '旅顺口区', '210200');
INSERT INTO `tb_areas` VALUES ('210213', '金州区', '210200');
INSERT INTO `tb_areas` VALUES ('210214', '普兰店区', '210200');
INSERT INTO `tb_areas` VALUES ('210224', '长海县', '210200');
INSERT INTO `tb_areas` VALUES ('210281', '瓦房店市', '210200');
INSERT INTO `tb_areas` VALUES ('210283', '庄河市', '210200');
INSERT INTO `tb_areas` VALUES ('210300', '鞍山市', '210000');
INSERT INTO `tb_areas` VALUES ('210302', '铁东区', '210300');
INSERT INTO `tb_areas` VALUES ('210303', '铁西区', '210300');
INSERT INTO `tb_areas` VALUES ('210304', '立山区', '210300');
INSERT INTO `tb_areas` VALUES ('210311', '千山区', '210300');
INSERT INTO `tb_areas` VALUES ('210321', '台安县', '210300');
INSERT INTO `tb_areas` VALUES ('210323', '岫岩满族自治县', '210300');
INSERT INTO `tb_areas` VALUES ('210381', '海城市', '210300');
INSERT INTO `tb_areas` VALUES ('210400', '抚顺市', '210000');
INSERT INTO `tb_areas` VALUES ('210402', '新抚区', '210400');
INSERT INTO `tb_areas` VALUES ('210403', '东洲区', '210400');
INSERT INTO `tb_areas` VALUES ('210404', '望花区', '210400');
INSERT INTO `tb_areas` VALUES ('210411', '顺城区', '210400');
INSERT INTO `tb_areas` VALUES ('210421', '抚顺县', '210400');
INSERT INTO `tb_areas` VALUES ('210422', '新宾满族自治县', '210400');
INSERT INTO `tb_areas` VALUES ('210423', '清原满族自治县', '210400');
INSERT INTO `tb_areas` VALUES ('210500', '本溪市', '210000');
INSERT INTO `tb_areas` VALUES ('210502', '平山区', '210500');
INSERT INTO `tb_areas` VALUES ('210503', '溪湖区', '210500');
INSERT INTO `tb_areas` VALUES ('210504', '明山区', '210500');
INSERT INTO `tb_areas` VALUES ('210505', '南芬区', '210500');
INSERT INTO `tb_areas` VALUES ('210521', '本溪满族自治县', '210500');
INSERT INTO `tb_areas` VALUES ('210522', '桓仁满族自治县', '210500');
INSERT INTO `tb_areas` VALUES ('210600', '丹东市', '210000');
INSERT INTO `tb_areas` VALUES ('210602', '元宝区', '210600');
INSERT INTO `tb_areas` VALUES ('210603', '振兴区', '210600');
INSERT INTO `tb_areas` VALUES ('210604', '振安区', '210600');
INSERT INTO `tb_areas` VALUES ('210624', '宽甸满族自治县', '210600');
INSERT INTO `tb_areas` VALUES ('210681', '东港市', '210600');
INSERT INTO `tb_areas` VALUES ('210682', '凤城市', '210600');
INSERT INTO `tb_areas` VALUES ('210700', '锦州市', '210000');
INSERT INTO `tb_areas` VALUES ('210702', '古塔区', '210700');
INSERT INTO `tb_areas` VALUES ('210703', '凌河区', '210700');
INSERT INTO `tb_areas` VALUES ('210711', '太和区', '210700');
INSERT INTO `tb_areas` VALUES ('210726', '黑山县', '210700');
INSERT INTO `tb_areas` VALUES ('210727', '义县', '210700');
INSERT INTO `tb_areas` VALUES ('210781', '凌海市', '210700');
INSERT INTO `tb_areas` VALUES ('210782', '北镇市', '210700');
INSERT INTO `tb_areas` VALUES ('210800', '营口市', '210000');
INSERT INTO `tb_areas` VALUES ('210802', '站前区', '210800');
INSERT INTO `tb_areas` VALUES ('210803', '西市区', '210800');
INSERT INTO `tb_areas` VALUES ('210804', '鲅鱼圈区', '210800');
INSERT INTO `tb_areas` VALUES ('210811', '老边区', '210800');
INSERT INTO `tb_areas` VALUES ('210881', '盖州市', '210800');
INSERT INTO `tb_areas` VALUES ('210882', '大石桥市', '210800');
INSERT INTO `tb_areas` VALUES ('210900', '阜新市', '210000');
INSERT INTO `tb_areas` VALUES ('210902', '海州区', '210900');
INSERT INTO `tb_areas` VALUES ('210903', '新邱区', '210900');
INSERT INTO `tb_areas` VALUES ('210904', '太平区', '210900');
INSERT INTO `tb_areas` VALUES ('210905', '清河门区', '210900');
INSERT INTO `tb_areas` VALUES ('210911', '细河区', '210900');
INSERT INTO `tb_areas` VALUES ('210921', '阜新蒙古族自治县', '210900');
INSERT INTO `tb_areas` VALUES ('210922', '彰武县', '210900');
INSERT INTO `tb_areas` VALUES ('211000', '辽阳市', '210000');
INSERT INTO `tb_areas` VALUES ('211002', '白塔区', '211000');
INSERT INTO `tb_areas` VALUES ('211003', '文圣区', '211000');
INSERT INTO `tb_areas` VALUES ('211004', '宏伟区', '211000');
INSERT INTO `tb_areas` VALUES ('211005', '弓长岭区', '211000');
INSERT INTO `tb_areas` VALUES ('211011', '太子河区', '211000');
INSERT INTO `tb_areas` VALUES ('211021', '辽阳县', '211000');
INSERT INTO `tb_areas` VALUES ('211081', '灯塔市', '211000');
INSERT INTO `tb_areas` VALUES ('211100'

最低0.47元/天解锁文章

Only You~~~

关注

2
点赞
踩
12

收藏

觉得还不错? 一键收藏
1
评论
Django 省、市、区三级联动及数据库的地址添加 !!!

应用场景`淘宝`、`京东`等需要地址的地方Models.py模型from django.db import models# Create your models here.class Area(models.Model): name = models.CharField(max_length=128) # related_name反向查询 parent = models.ForeignKey('self',on_delete=models.SET_NULL,rela
复制链接

扫一扫