有助于大家健康的，不错哦，欢迎大家进来行赏指教。

中国各省市区代码名称(三级)excel文档，共有3441条数据。已有上下级父子关系，可以直接导入数据库使用。 部分代码如下： CREATE TABLE [dbo].[tb_City]( [RecNo] [int] NOT NULL, [Code] [varchar](50) NULL, [Name] [nvarchar](50) NULL, [ParentNo] [int] NULL, CONSTRAINT [PK_tb_City] PRIMARY KEY CLUSTERED ( [RecNo

CREATE TABLE sys_city ( id int NOT NULL , areaname varchar(24) NULL , parentid int DEFAULT NULL, ) INSERT INTO sys_city VALUES (110000, 北京市, 0); INSERT INTO sys_city VALUES (110101, 东城区, 110100); INSERT INTO sys_city VALUES (110102, 西

//初始数据 var dsy = new Dsy(); dsy.add("0",["北京市","天津市","上海市","重庆市","河北省","山西省","内蒙古","辽宁省","吉林省","黑龙江省","江苏省","浙江省","安徽省","福建省","江西省","山东省","河南省","湖北省","湖南省","广东省","广西","海南省","四川省","贵州省","云南省","西藏","陕西省","甘肃省","青海省","宁夏","新疆","香港","澳门","台湾省"]); dsy.ad