省市表格设计(下拉框联动+递归加载TreeView)

--递归使用在ADO.Net中会有详细说明

--此处只是对省的地级市进行记录(县级市和区并未添加进去)


--省市联动之省
insert into Tab_Area(AreaName,AreaPID)values('北京市','0')
insert into Tab_Area(AreaName,AreaPID)values('天津市','0')
insert into Tab_Area(AreaName,AreaPID)values('上海市','0')
insert into Tab_Area(AreaName,AreaPID)values('重庆市','0')
insert into Tab_Area(AreaName,AreaPID)values('河北省','0')
insert into Tab_Area(AreaName,AreaPID)values('湖南省','0')
insert into Tab_Area(AreaName,AreaPID)values('河北省','0')
insert into Tab_Area(AreaName,AreaPID)values('山西省','0')
insert into Tab_Area(AreaName,AreaPID)values('辽宁省','0')
insert into Tab_Area(AreaName,AreaPID)values('吉林省','0')
insert into Tab_Area(AreaName,AreaPID)values('黑龙江省','0')
insert into Tab_Area(AreaName,AreaPID)values('江苏省','0')
insert into Tab_Area(AreaName,AreaPID)values('浙江省','0')
insert into Tab_Area(AreaName,AreaPID)values('安徽省','0')
insert into Tab_Area(AreaName,AreaPID)values('福建省','0')
insert into Tab_Area(AreaName,AreaPID)values('江西省','0')
insert into Tab_Area(AreaName,AreaPID)values('山东省','0')
insert into Tab_Area(AreaName,AreaPID)values('河南省','0')
insert into Tab_Area(AreaName,AreaPID)values('湖北省','0')
insert into Tab_Area(AreaName,AreaPID)values('广东省','0')
insert into Tab_Area(AreaName,AreaPID)values('海南省','0')
insert into Tab_Area(AreaName,AreaPID)values('四川省','0')
insert into Tab_Area(AreaName,AreaPID)values('贵州省','0')
insert into Tab_Area(AreaName,AreaPID)values('云南省','0')
insert into Tab_Area(AreaName,AreaPID)values('陕西省','0')
insert into Tab_Area(AreaName,AreaPID)values('甘肃省','0')
insert into Tab_Area(AreaName,AreaPID)values('青海省','0')
insert into Tab_Area(AreaName,AreaPID)values('台湾省','0')
insert into Tab_Area(AreaName,AreaPID)values('内蒙古自治区','0')
insert into Tab_Area(AreaName,AreaPID)values('广西壮族自治区','0')
insert into Tab_Area(AreaName,AreaPID)values('西藏自治区','0')
insert into Tab_Area(AreaName,AreaPID)values('宁夏回族自治区','0')
insert into Tab_Area(AreaName,AreaPID)values('新疆维吾尔自治区','0')
insert into Tab_Area(AreaName,AreaPID)values('香港特别行政区','0')
insert into Tab_Area(AreaName,AreaPID)values('澳门特别行政区','0')


--省市联动之市(递归设计)

--北京、天津、上海、重庆市、河北省底下均为区
insert into Tab_Area(AreaName,AreaPID)values('北京市','1')
insert into Tab_Area(AreaName,AreaPID)values('天津市','2')
insert into Tab_Area(AreaName,AreaPID)values('上海市','3')
insert into Tab_Area(AreaName,AreaPID)values('重庆市','4')
insert into Tab_Area(AreaName,AreaPID)values('石家庄市','5')
insert into Tab_Area(AreaName,AreaPID)values('唐山市','5')
insert into Tab_Area(AreaName,AreaPID)values('秦皇岛市','5')
insert into Tab_Area(AreaName,AreaPID)values('邯郸市','5')
insert into Tab_Area(AreaName,AreaPID)values('邢台市','5')
insert into Tab_Area(AreaName,AreaPID)values('保定市','5')
insert into Tab_Area(AreaName,AreaPID)values('张家口市','5')
insert into Tab_Area(AreaName,AreaPID)values('承德市','5')
insert into Tab_Area(AreaName,AreaPID)values('沧州市','5')
insert into Tab_Area(AreaName,AreaPID)values('廊坊市','5')
insert into Tab_Area(AreaName,AreaPID)values('衡水市','5')


--湖南省
insert into Tab_Area(AreaName,AreaPID)values('长沙市','6')
insert into Tab_Area(AreaName,AreaPID)values('株洲市','6')
insert into Tab_Area(AreaName,AreaPID)values('湘潭市','6')
insert into Tab_Area(AreaName,AreaPID)values('衡阳市','6')
insert into Tab_Area(AreaName,AreaPID)values('昭阳市','6')
insert into Tab_Area(AreaName,AreaPID)values('岳阳市','6')
insert into Tab_Area(AreaName,AreaPID)values('常德市','6')
insert into Tab_Area(AreaName,AreaPID)values('张家界市','6')
insert into Tab_Area(AreaName,AreaPID)values('益阳市','6')
insert into Tab_Area(AreaName,AreaPID)values('郴州市','6')
insert into Tab_Area(AreaName,AreaPID)values('永州市','6')
insert into Tab_Area(AreaName,AreaPID)values('怀化市','6')
insert into Tab_Area(AreaName,AreaPID)values('娄底市','6')


--山西省

insert into Tab_Area(AreaName,AreaPID)values('太原市','8')
insert into Tab_Area(AreaName,AreaPID)values('大同市','8')
insert into Tab_Area(AreaName,AreaPID)values('朔州市','8')
insert into Tab_Area(AreaName,AreaPID)values('忻州市','8')
insert into Tab_Area(AreaName,AreaPID)values('阳泉市','8')
insert into Tab_Area(AreaName,AreaPID)values('吕梁市','8')
insert into Tab_Area(AreaName,AreaPID)values('晋中市','8')
insert into Tab_Area(AreaName,AreaPID)values('长治市','8')
insert into Tab_Area(AreaName,AreaPID)values('晋城市','8')
insert into Tab_Area(AreaName,AreaPID)values('临汾市','8')
insert into Tab_Area(AreaName,AreaPID)values('运城市','8')

--辽宁省

insert into Tab_Area(AreaName,AreaPID)values('沈阳市','9')
insert into Tab_Area(AreaName,AreaPID)values('大连市','9')
insert into Tab_Area(AreaName,AreaPID)values('鞍山市','9')
insert into Tab_Area(AreaName,AreaPID)values('抚顺市','9')
insert into Tab_Area(AreaName,AreaPID)values('本溪市','9')
insert into Tab_Area(AreaName,AreaPID)values('丹东市','9')
insert into Tab_Area(AreaName,AreaPID)values('锦州市','9')
insert into Tab_Area(AreaName,AreaPID)values('营口市','9')
insert into Tab_Area(AreaName,AreaPID)values('阜新市','9')
insert into Tab_Area(AreaName,AreaPID)values('辽阳市','9')
insert into Tab_Area(AreaName,AreaPID)values('盘锦市','9')
insert into Tab_Area(AreaName,AreaPID)values('铁岭市','9')
insert into Tab_Area(AreaName,AreaPID)values('朝阳市','9')
insert into Tab_Area(AreaName,AreaPID)values('葫芦岛市','9')

--吉林省

insert into Tab_Area(AreaName,AreaPID)values('长春市','10')
insert into Tab_Area(AreaName,AreaPID)values('吉林市','10')
insert into Tab_Area(AreaName,AreaPID)values('四平市','10')
insert into Tab_Area(AreaName,AreaPID)values('辽源市','10')
insert into Tab_Area(AreaName,AreaPID)values('通化市','10')
insert into Tab_Area(AreaName,AreaPID)values('白山市','10')
insert into Tab_Area(AreaName,AreaPID)values('松原市','10')
insert into Tab_Area(AreaName,AreaPID)values('白城市','10')
insert into Tab_Area(AreaName,AreaPID)values('延边朝鲜族自治州','10')

--黑龙江省

insert into Tab_Area(AreaName,AreaPID)values('哈尔滨市','11')
insert into Tab_Area(AreaName,AreaPID)values('齐齐哈尔市','11')
insert into Tab_Area(AreaName,AreaPID)values('牡丹江市','11')
insert into Tab_Area(AreaName,AreaPID)values('佳木斯市','11')
insert into Tab_Area(AreaName,AreaPID)values('七台河市','11')
insert into Tab_Area(AreaName,AreaPID)values('大庆市','11')
insert into Tab_Area(AreaName,AreaPID)values('黑河市','11')
insert into Tab_Area(AreaName,AreaPID)values('绥化市','11')
insert into Tab_Area(AreaName,AreaPID)values('伊春市','11')
insert into Tab_Area(AreaName,AreaPID)values('鹤岗市','11')
insert into Tab_Area(AreaName,AreaPID)values('双鸭山市','11')
insert into Tab_Area(AreaName,AreaPID)values('鸡西市','11')


--江苏省
insert into Tab_Area(AreaName,AreaPID)values('南京市','12')
insert into Tab_Area(AreaName,AreaPID)values('无锡市','12')
insert into Tab_Area(AreaName,AreaPID)values('徐州市','12')
insert into Tab_Area(AreaName,AreaPID)values('常州市','12')
insert into Tab_Area(AreaName,AreaPID)values('苏州市','12')
insert into Tab_Area(AreaName,AreaPID)values('南通市','12')
insert into Tab_Area(AreaName,AreaPID)values('连云港市','12')
insert into Tab_Area(AreaName,AreaPID)values('淮安市','12')
insert into Tab_Area(AreaName,AreaPID)values('盐城市','12')
insert into Tab_Area(AreaName,AreaPID)values('扬州市','12')
insert into Tab_Area(AreaName,AreaPID)values('镇江市','12')
insert into Tab_Area(AreaName,AreaPID)values('泰州市','12')
insert into Tab_Area(AreaName,AreaPID)values('宿迁市','12')

--浙江省
insert into Tab_Area(AreaName,AreaPID)values('杭州市','13')
insert into Tab_Area(AreaName,AreaPID)values('宁波市','13')
insert into Tab_Area(AreaName,AreaPID)values('温州市','13')
insert into Tab_Area(AreaName,AreaPID)values('嘉兴市','13')
insert into Tab_Area(AreaName,AreaPID)values('湖州市','13')
insert into Tab_Area(AreaName,AreaPID)values('绍兴市','13')
insert into Tab_Area(AreaName,AreaPID)values('金华市','13')
insert into Tab_Area(AreaName,AreaPID)values('衢州市','13')
insert into Tab_Area(AreaName,AreaPID)values('舟山市','13')
insert into Tab_Area(AreaName,AreaPID)values('台州市','13')
insert into Tab_Area(AreaName,AreaPID)values('丽水市','13')

--安徽省
insert into Tab_Area(AreaName,AreaPID)values('合肥市','14')
insert into Tab_Area(AreaName,AreaPID)values('芜湖市','14')
insert into Tab_Area(AreaName,AreaPID)values('蚌埠市','14')
insert into Tab_Area(AreaName,AreaPID)values('淮南市','14')
insert into Tab_Area(AreaName,AreaPID)values('马鞍山市','14')
insert into Tab_Area(AreaName,AreaPID)values('淮北市','14')
insert into Tab_Area(AreaName,AreaPID)values('铜陵市','14')
insert into Tab_Area(AreaName,AreaPID)values('安庆市','14')
insert into Tab_Area(AreaName,AreaPID)values('黄山市','14')
insert into Tab_Area(AreaName,AreaPID)values('滁州市','14')
insert into Tab_Area(AreaName,AreaPID)values('阜阳市','14')
insert into Tab_Area(AreaName,AreaPID)values('宿州市','14')
insert into Tab_Area(AreaName,AreaPID)values('六安市','14')
insert into Tab_Area(AreaName,AreaPID)values('毫州市','14')
insert into Tab_Area(AreaName,AreaPID)values('宣城市','14')

--福建省
insert into Tab_Area(AreaName,AreaPID)values('福州市','15')
insert into Tab_Area(AreaName,AreaPID)values('厦门市','15')
insert into Tab_Area(AreaName,AreaPID)values('莆田市','15')
insert into Tab_Area(AreaName,AreaPID)values('泉州市','15')
insert into Tab_Area(AreaName,AreaPID)values('三明市','15')
insert into Tab_Area(AreaName,AreaPID)values('漳州市','15')
insert into Tab_Area(AreaName,AreaPID)values('宁德市','15')
insert into Tab_Area(AreaName,AreaPID)values('龙岩市','15')
insert into Tab_Area(AreaName,AreaPID)values('南平市','15')


--江西省
insert into Tab_Area(AreaName,AreaPID)values('南昌市','16')
insert into Tab_Area(AreaName,AreaPID)values('景德镇市','16')
insert into Tab_Area(AreaName,AreaPID)values('萍乡市','16')
insert into Tab_Area(AreaName,AreaPID)values('九江市','16')
insert into Tab_Area(AreaName,AreaPID)values('新余市','16')
insert into Tab_Area(AreaName,AreaPID)values('鹰潭市','16')
insert into Tab_Area(AreaName,AreaPID)values('赣州市','16')
insert into Tab_Area(AreaName,AreaPID)values('吉安市','16')
insert into Tab_Area(AreaName,AreaPID)values('宜春市','16')
insert into Tab_Area(AreaName,AreaPID)values('抚州市','16')
insert into Tab_Area(AreaName,AreaPID)values('上饶市','16')


--山东省
insert into Tab_Area(AreaName,AreaPID)values('济南市','17')
insert into Tab_Area(AreaName,AreaPID)values('青岛市','17')
insert into Tab_Area(AreaName,AreaPID)values('淄博市','17')
insert into Tab_Area(AreaName,AreaPID)values('枣庄市','17')
insert into Tab_Area(AreaName,AreaPID)values('东营市','17')
insert into Tab_Area(AreaName,AreaPID)values('烟台市','17')
insert into Tab_Area(AreaName,AreaPID)values('潍坊市','17')
insert into Tab_Area(AreaName,AreaPID)values('济宁市','17')
insert into Tab_Area(AreaName,AreaPID)values('泰安市','17')
insert into Tab_Area(AreaName,AreaPID)values('威海市','17')
insert into Tab_Area(AreaName,AreaPID)values('日照市','17')
insert into Tab_Area(AreaName,AreaPID)values('临沂市','17')
insert into Tab_Area(AreaName,AreaPID)values('德州市','17')
insert into Tab_Area(AreaName,AreaPID)values('聊城市','17')
insert into Tab_Area(AreaName,AreaPID)values('菏泽市','17')

--河南省
insert into Tab_Area(AreaName,AreaPID)values('郑州市','18')
insert into Tab_Area(AreaName,AreaPID)values('开封市','18')
insert into Tab_Area(AreaName,AreaPID)values('洛阳市','18')
insert into Tab_Area(AreaName,AreaPID)values('平顶山市','18')
insert into Tab_Area(AreaName,AreaPID)values('安阳市','18')
insert into Tab_Area(AreaName,AreaPID)values('鹤壁市','18')
insert into Tab_Area(AreaName,AreaPID)values('新乡市','18')
insert into Tab_Area(AreaName,AreaPID)values('焦作市','18')
insert into Tab_Area(AreaName,AreaPID)values('濮阳市','18')
insert into Tab_Area(AreaName,AreaPID)values('许昌市','18')
insert into Tab_Area(AreaName,AreaPID)values('漯河市','18')
insert into Tab_Area(AreaName,AreaPID)values('三峡门市','18')
insert into Tab_Area(AreaName,AreaPID)values('南阳市','18')
insert into Tab_Area(AreaName,AreaPID)values('商丘市','18')
insert into Tab_Area(AreaName,AreaPID)values('信阳市','18')
insert into Tab_Area(AreaName,AreaPID)values('周口市','18')
insert into Tab_Area(AreaName,AreaPID)values('驻马店市','18')

--湖北省
insert into Tab_Area(AreaName,AreaPID)values('武汉市','19')
insert into Tab_Area(AreaName,AreaPID)values('黄石市','19')
insert into Tab_Area(AreaName,AreaPID)values('十堰市','19')
insert into Tab_Area(AreaName,AreaPID)values('宜昌市','19')
insert into Tab_Area(AreaName,AreaPID)values('襄阳市','19')
insert into Tab_Area(AreaName,AreaPID)values('鄂州市','19')
insert into Tab_Area(AreaName,AreaPID)values('荆门市','19')
insert into Tab_Area(AreaName,AreaPID)values('孝感市','19')
insert into Tab_Area(AreaName,AreaPID)values('荆州市','19')
insert into Tab_Area(AreaName,AreaPID)values('黄冈市','19')
insert into Tab_Area(AreaName,AreaPID)values('咸宁市','19')
insert into Tab_Area(AreaName,AreaPID)values('随州市','19')

--广东省
insert into Tab_Area(AreaName,AreaPID)values('广州市','20')
insert into Tab_Area(AreaName,AreaPID)values('深圳市','20')
insert into Tab_Area(AreaName,AreaPID)values('珠海市','20')
insert into Tab_Area(AreaName,AreaPID)values('东莞市','20')
insert into Tab_Area(AreaName,AreaPID)values('汕头市','20')
insert into Tab_Area(AreaName,AreaPID)values('汕尾市','20')
insert into Tab_Area(AreaName,AreaPID)values('河源市','20')
insert into Tab_Area(AreaName,AreaPID)values('清远市','20')
insert into Tab_Area(AreaName,AreaPID)values('佛山市','20')
insert into Tab_Area(AreaName,AreaPID)values('韶关市','20')
insert into Tab_Area(AreaName,AreaPID)values('湛江市','20')
insert into Tab_Area(AreaName,AreaPID)values('肇庆市','20')
insert into Tab_Area(AreaName,AreaPID)values('惠州市','20')
insert into Tab_Area(AreaName,AreaPID)values('梅州市','20')
insert into Tab_Area(AreaName,AreaPID)values('江门市','20')
insert into Tab_Area(AreaName,AreaPID)values('阳江市','20')
insert into Tab_Area(AreaName,AreaPID)values('云浮市','20')
insert into Tab_Area(AreaName,AreaPID)values('茂名市','20')
insert into Tab_Area(AreaName,AreaPID)values('中山市','20')
insert into Tab_Area(AreaName,AreaPID)values('潮州市','20')
insert into Tab_Area(AreaName,AreaPID)values('揭阳市','20')

--海南省
insert into Tab_Area(AreaName,AreaPID)values('海口市','21')
insert into Tab_Area(AreaName,AreaPID)values('三亚市','21')
insert into Tab_Area(AreaName,AreaPID)values('三沙市','21')
insert into Tab_Area(AreaName,AreaPID)values('儋州市','21')

 

--四川省
insert into Tab_Area(AreaName,AreaPID)values('成都市','22')
insert into Tab_Area(AreaName,AreaPID)values('自贡市','22')
insert into Tab_Area(AreaName,AreaPID)values('攀枝花市','22')
insert into Tab_Area(AreaName,AreaPID)values('泸州市','22')
insert into Tab_Area(AreaName,AreaPID)values('德阳市','22')
insert into Tab_Area(AreaName,AreaPID)values('绵阳市','22')
insert into Tab_Area(AreaName,AreaPID)values('广元市','22')
insert into Tab_Area(AreaName,AreaPID)values('遂宁市','22')
insert into Tab_Area(AreaName,AreaPID)values('内江市','22')
insert into Tab_Area(AreaName,AreaPID)values('乐山市','22')
insert into Tab_Area(AreaName,AreaPID)values('南充市','22')
insert into Tab_Area(AreaName,AreaPID)values('眉山市','22')
insert into Tab_Area(AreaName,AreaPID)values('宜宾市','22')
insert into Tab_Area(AreaName,AreaPID)values('广安市','22')
insert into Tab_Area(AreaName,AreaPID)values('达州市','22')
insert into Tab_Area(AreaName,AreaPID)values('雅安市','22')
insert into Tab_Area(AreaName,AreaPID)values('巴中市','22')
insert into Tab_Area(AreaName,AreaPID)values('资阳市','22')


--贵州省
insert into Tab_Area(AreaName,AreaPID)values('贵阳市','23')
insert into Tab_Area(AreaName,AreaPID)values('六盘水市','23')
insert into Tab_Area(AreaName,AreaPID)values('遵义市','23')
insert into Tab_Area(AreaName,AreaPID)values('安顺市','23')
insert into Tab_Area(AreaName,AreaPID)values('毕节市','23')
insert into Tab_Area(AreaName,AreaPID)values('铜仁市','23')


--云南省
insert into Tab_Area(AreaName,AreaPID)values('昆明市','24')
insert into Tab_Area(AreaName,AreaPID)values('曲靖市','24')
insert into Tab_Area(AreaName,AreaPID)values('玉溪市','24')
insert into Tab_Area(AreaName,AreaPID)values('保山市','24')
insert into Tab_Area(AreaName,AreaPID)values('昭通市','24')
insert into Tab_Area(AreaName,AreaPID)values('丽江市','24')
insert into Tab_Area(AreaName,AreaPID)values('普洱市','24')
insert into Tab_Area(AreaName,AreaPID)values('临沧市','24')


--陕西省
insert into Tab_Area(AreaName,AreaPID)values('西安市','25')
insert into Tab_Area(AreaName,AreaPID)values('铜川市','25')
insert into Tab_Area(AreaName,AreaPID)values('宝鸡市','25')
insert into Tab_Area(AreaName,AreaPID)values('咸阳市','25')
insert into Tab_Area(AreaName,AreaPID)values('渭南市','25')
insert into Tab_Area(AreaName,AreaPID)values('延安市','25')
insert into Tab_Area(AreaName,AreaPID)values('汉中市','25')
insert into Tab_Area(AreaName,AreaPID)values('榆林市','25')
insert into Tab_Area(AreaName,AreaPID)values('安康市','25')
insert into Tab_Area(AreaName,AreaPID)values('商洛市','25')

 

--甘肃省
insert into Tab_Area(AreaName,AreaPID)values('兰州市','26')
insert into Tab_Area(AreaName,AreaPID)values('嘉峪关市','26')
insert into Tab_Area(AreaName,AreaPID)values('金昌市','26')
insert into Tab_Area(AreaName,AreaPID)values('白银市','26')
insert into Tab_Area(AreaName,AreaPID)values('天水市','26')
insert into Tab_Area(AreaName,AreaPID)values('武威市','26')
insert into Tab_Area(AreaName,AreaPID)values('张掖市','26')
insert into Tab_Area(AreaName,AreaPID)values('平凉市','26')
insert into Tab_Area(AreaName,AreaPID)values('酒泉市','26')
insert into Tab_Area(AreaName,AreaPID)values('庆阳市','26')
insert into Tab_Area(AreaName,AreaPID)values('定西市','26')
insert into Tab_Area(AreaName,AreaPID)values('陇南市','26')


--青海省
insert into Tab_Area(AreaName,AreaPID)values('西宁市','27')
insert into Tab_Area(AreaName,AreaPID)values('海东市','27')

 


--台湾省
insert into Tab_Area(AreaName,AreaPID)values('台北市','28')
insert into Tab_Area(AreaName,AreaPID)values('基隆市','28')
insert into Tab_Area(AreaName,AreaPID)values('嘉义市','28')
insert into Tab_Area(AreaName,AreaPID)values('新竹市','28')
insert into Tab_Area(AreaName,AreaPID)values('台中市','28')
insert into Tab_Area(AreaName,AreaPID)values('台南市','28')
insert into Tab_Area(AreaName,AreaPID)values('新北市','28')
insert into Tab_Area(AreaName,AreaPID)values('高雄市','28')
insert into Tab_Area(AreaName,AreaPID)values('桃园市','28')


--内蒙古自治区
insert into Tab_Area(AreaName,AreaPID)values('呼和浩特市','29')
insert into Tab_Area(AreaName,AreaPID)values('包头市','29')
insert into Tab_Area(AreaName,AreaPID)values('乌海市','29')
insert into Tab_Area(AreaName,AreaPID)values('赤峰市','29')
insert into Tab_Area(AreaName,AreaPID)values('通辽市','29')
insert into Tab_Area(AreaName,AreaPID)values('鄂尔多斯市','29')
insert into Tab_Area(AreaName,AreaPID)values('呼伦贝尔市','29')
insert into Tab_Area(AreaName,AreaPID)values('巴彦淖尔市','29')
insert into Tab_Area(AreaName,AreaPID)values('乌兰察布市','29')

--广西壮族自治区
insert into Tab_Area(AreaName,AreaPID)values('南宁市','30')
insert into Tab_Area(AreaName,AreaPID)values('柳州市','30')
insert into Tab_Area(AreaName,AreaPID)values('桂林市','30')
insert into Tab_Area(AreaName,AreaPID)values('梧州市','30')
insert into Tab_Area(AreaName,AreaPID)values('北海市','30')
insert into Tab_Area(AreaName,AreaPID)values('防城港市','30')
insert into Tab_Area(AreaName,AreaPID)values('钦州市','30')
insert into Tab_Area(AreaName,AreaPID)values('贵港市','30')
insert into Tab_Area(AreaName,AreaPID)values('玉林市','30')
insert into Tab_Area(AreaName,AreaPID)values('百色市','30')
insert into Tab_Area(AreaName,AreaPID)values('贺州市市','30')
insert into Tab_Area(AreaName,AreaPID)values('河池市','30')
insert into Tab_Area(AreaName,AreaPID)values('来宾市市','30')
insert into Tab_Area(AreaName,AreaPID)values('崇左市','30')

 

--西藏自治区
insert into Tab_Area(AreaName,AreaPID)values('拉萨市','31')
insert into Tab_Area(AreaName,AreaPID)values('日喀则市','31')
insert into Tab_Area(AreaName,AreaPID)values('昌都市','31')
insert into Tab_Area(AreaName,AreaPID)values('林芝市','31')
insert into Tab_Area(AreaName,AreaPID)values('山南市','31')

 

 

--宁夏回族自治区
insert into Tab_Area(AreaName,AreaPID)values('银川市','32')
insert into Tab_Area(AreaName,AreaPID)values('石嘴山市','32')
insert into Tab_Area(AreaName,AreaPID)values('吴忠市','32')
insert into Tab_Area(AreaName,AreaPID)values('固原市','32')
insert into Tab_Area(AreaName,AreaPID)values('中卫市','32')


--新疆维吾尔自治区
insert into Tab_Area(AreaName,AreaPID)values('乌鲁木齐市','33')
insert into Tab_Area(AreaName,AreaPID)values('克拉玛依市','33')
insert into Tab_Area(AreaName,AreaPID)values('吐鲁番市','33')
insert into Tab_Area(AreaName,AreaPID)values('昌吉市','33')
insert into Tab_Area(AreaName,AreaPID)values('哈密市','33')


--香港特别行政区
insert into Tab_Area(AreaName,AreaPID)values('','34')

 

--澳门特别行政区
insert into Tab_Area(AreaName,AreaPID)values('','35')

 

posted @ 2020-03-12 22:10  Kai_YoungMaster  阅读(402)  评论(0编辑  收藏  举报