以树目录的方式展示数据在我们程序开发中用得算是比较多的,asp.net中的TreeView控件就是一个功能非常强大的树控件,但是TreeView控件还是有很多不足,例如要想实现动态加载,就会导致页面的刷新,这样的用户体验明显是很不够的。下面就来实现一个具有Ajax功能的树目录。
首先看数据库表的设计,表的设计很简单用一个parent_id字段标示该节点的父节点id,第一级的parent_id=0,截图如下:
界面实现设计,每一级数据以<ul><li>……</li></ul>展示,子级ul追加到父级li元素的后面,这样比将子级ul插到父级li标签中更加容易控制,实例如下:
<ul> <li>湖北省</li> <ul> <li>武汉市</li> <ul> <li>武昌区</li> <li>洪山区</li> <ul> <li>街道口</li> <li>卓刀泉</li> <li>虎泉</li> </ul> <li>硚口区</li> <li>江岸区</li> </ul> <li>黄冈市</li> <li>黄石市</li> </ul> <li>湖南省</li> <li>广东省</li> </ul>
给每一个li元素都添加click事件getAreaByPid(parent_id,obj),第一个参数为当前节点的id,obj为当前dom元素对象,这样就可以实现将获取的子级追加到obj元素的后面,当再次点击obj元素时,就只需要将obj元素后面的ul隐藏掉,之后对于obj的展开和折叠就只需要设置ul的可见性即可,大大提高程序的性能。
下面看具体代码实现,前台aspx页面代码如下:
<%@ Page Language="C#" AutoEventWireup="true" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" > <head runat="server"> <title>Ajax树目录</title> <script type="text/javascript" src="/Resources/Js/jquery-1.4.2.min.js"></script> <style type="text/css"> #treeViewDiv { width:250px; height:500px; margin-top:10px; margin-bottom:10px; padding-top:5px; padding-bottom:5px; overflow:auto; border:solid 1px #ddd;} #treeViewDiv a{ color:Black; text-decoration:none;} #treeViewDiv ul{list-style:none; padding:0; margin:0; margin-left:15px;} #treeViewDiv ul li{background:url(../Resources/Images/col.gif) no-repeat left center; font-size:13px; height:18px; *height:16px; text-indent:16px; line-height:18px; *padding-top:2px; cursor:pointer;} #treeViewDiv .expand{background:url(../Resources/Images/exp.gif) no-repeat left center; font-weight:bolder;} #treeViewDiv .collapse{background:url(../Resources/Images/col.gif) no-repeat left center;} </style> </head> <body> <div id="treeViewDiv"></div> <script type="text/javascript"> function getAreaByPid(pid, obj) { if ($(obj).attr("class") == "collapse") { if ($(obj).next().is("ul")) { //已被加载过,直接设置其可见性 $(obj).next().show(); } else { if (typeof parseInt(pid) == "number") { $.get("AjaxHandler.ashx", { pid: pid }, function(data) { if (data == null) { alert("选择了" + $(obj).html()); } else { var html = ''; $.each(data.AreaList, function(i, item) { html += '<li class="collapse" οnclick=\"getAreaByPid(' + item.Id + ',this);\">' + item.Name + '</li>'; }); $(obj).after("<ul>" + html + "</ul>"); } }, "json"); } } $(obj).removeClass("collapse").addClass("expand"); } else if ($(obj).attr("class") == "expand") { //已经是展开状态,则无需发送请求 $(obj).next().hide(); $(obj).removeClass("expand").addClass("collapse"); } } $(document).ready(function() { $.get("AjaxHandler.ashx", function(data) { if (data == null) { return; } var html = ''; $.each(data.AreaList, function(i, item) { html += '<li class="collapse" οnclick=\"getAreaByPid(' + item.Id + ',this);\">' + item.Name + '</li>'; }); $("#treeViewDiv").html("<ul>" + html + "</ul>"); }, "json"); }); </script> </body> </html>
AjaxHandler.ashx页面核心代码如下:
public void ProcessRequest(HttpContext context) { int pid = string.IsNullOrEmpty(context.Request.QueryString["pid"]) ? 0 : int.Parse(context.Request.QueryString["pid"]); DataTable dtArea = DataProvider.ChinaArea.GetChinaArea(pid); if (dtArea != null && dtArea.Rows.Count > 0) { StringBuilder sbOutput = new StringBuilder(300); sbOutput.Append("{\"AreaList\":["); foreach (DataRow row in dtArea.Rows) { sbOutput.Append("{\"Id\":\"" + row["id"].ToString() + "\",\"Name\":\"" + row["name"].ToString() + "\"},"); } string strJson = (sbOutput.ToString().IndexOf(',') > 0 ? sbOutput.ToString().TrimEnd(',') : sbOutput.ToString()) + "]}"; context.Response.ContentType = "text/plain"; context.Response.Write(strJson); } }
using System; using System.Data; using System.Data.SqlClient; namespace AjaxTreeView.DataProvider { public class ChinaArea { private static readonly string strSqlConn = System.Configuration.ConfigurationManager.ConnectionStrings["SqlConString"].ConnectionString; public static DataTable GetChinaArea(int parentId) { using (SqlConnection conn = new SqlConnection(strSqlConn)) { SqlCommand comd = new SqlCommand("select id,[name] from china_area where parent_id=@parent_id",conn); comd.Parameters.Add(new SqlParameter("parent_id", parentId)); SqlDataAdapter sqlDa = new SqlDataAdapter(comd); DataTable dtTable = new DataTable(); if (conn.State == ConnectionState.Closed) conn.Open(); try { sqlDa.Fill(dtTable); } finally { sqlDa.Dispose(); } return dtTable; } } } }
一个简单的具有ajax功能的树目录功能就完成了,当然这只是实现了一个很基本的功能,下回将进一步改进该程序。
下面附上导入全国省市的sql语句。
View Code
INSERT INTO china_area(id,[name],sort,parent_id) VALUES (1,'北京市',0,0); INSERT INTO china_area(id,[name],sort,parent_id) VALUES (2,'天津市',0,0); INSERT INTO china_area(id,[name],sort,parent_id) VALUES (3,'上海市',0,0); INSERT INTO china_area(id,[name],sort,parent_id) VALUES (4,'重庆市',0,0); INSERT INTO china_area(id,[name],sort,parent_id) VALUES (5,'河北省',0,0); INSERT INTO china_area(id,[name],sort,parent_id) VALUES (6,'山西省',0,0); INSERT INTO china_area(id,[name],sort,parent_id) VALUES (7,'台湾省',0,0); INSERT INTO china_area(id,[name],sort,parent_id) VALUES (8,'辽宁省',0,0); INSERT INTO china_area(id,[name],sort,parent_id) VALUES (9,'吉林省',0,0); INSERT INTO china_area(id,[name],sort,parent_id) VALUES (10,'黑龙江省',0,0); INSERT INTO china_area(id,[name],sort,parent_id) VALUES (11,'江苏省',0,0); INSERT INTO china_area(id,[name],sort,parent_id) VALUES (12,'浙江省',0,0); INSERT INTO china_area(id,[name],sort,parent_id) VALUES (13,'安徽省',0,0); INSERT INTO china_area(id,[name],sort,parent_id) VALUES (14,'福建省',0,0); INSERT INTO china_area(id,[name],sort,parent_id) VALUES (15,'江西省',0,0); INSERT INTO china_area(id,[name],sort,parent_id) VALUES (16,'山东省',0,0); INSERT INTO china_area(id,[name],sort,parent_id) VALUES (17,'河南省',0,0); INSERT INTO china_area(id,[name],sort,parent_id) VALUES (18,'湖北省',0,0); INSERT INTO china_area(id,[name],sort,parent_id) VALUES (19,'湖南省',0,0); INSERT INTO china_area(id,[name],sort,parent_id) VALUES (20,'广东省',0,0); INSERT INTO china_area(id,[name],sort,parent_id) VALUES (21,'甘肃省',0,0); INSERT INTO china_area(id,[name],sort,parent_id) VALUES (22,'四川省',0,0); INSERT INTO china_area(id,[name],sort,parent_id) VALUES (23,'贵州省',0,0); INSERT INTO china_area(id,[name],sort,parent_id) VALUES (24,'海南省',0,0); INSERT INTO china_area(id,[name],sort,parent_id) VALUES (25,'云南省',0,0); INSERT INTO china_area(id,[name],sort,parent_id) VALUES (26,'青海省',0,0); INSERT INTO china_area(id,[name],sort,parent_id) VALUES (27,'陕西省',0,0); INSERT INTO china_area(id,[name],sort,parent_id) VALUES (28,'广西壮族自治区',0,0); INSERT INTO china_area(id,[name],sort,parent_id) VALUES (29,'西藏自治区',0,0); INSERT INTO china_area(id,[name],sort,parent_id) VALUES (30,'宁夏回族自治区',0,0); INSERT INTO china_area(id,[name],sort,parent_id) VALUES (31,'新疆维吾尔自治区',0,0); INSERT INTO china_area(id,[name],sort,parent_id) VALUES (32,'内蒙古自治区',0,0); INSERT INTO china_area(id,[name],sort,parent_id) VALUES (33,'澳门特别行政区',0,0); INSERT INTO china_area(id,[name],sort,parent_id) VALUES (34,'香港特别行政区',0,0); INSERT INTO china_area([name],parent_id) VALUES ('七台河市',10); INSERT INTO china_area([name],parent_id) VALUES ('万宁市',24); INSERT INTO china_area([name],parent_id) VALUES ('三亚市',24); INSERT INTO china_area([name],parent_id) VALUES ('三明市',14); INSERT INTO china_area([name],parent_id) VALUES ('三门峡市',17); INSERT INTO china_area([name],parent_id) VALUES ('上海市',3); INSERT INTO china_area([name],parent_id) VALUES ('上饶市',15); INSERT INTO china_area([name],parent_id) VALUES ('东方市',24); INSERT INTO china_area([name],parent_id) VALUES ('东莞市',20); INSERT INTO china_area([name],parent_id) VALUES ('东营市',16); INSERT INTO china_area([name],parent_id) VALUES ('中卫市',30); INSERT INTO china_area([name],parent_id) VALUES ('中山市',20); INSERT INTO china_area([name],parent_id) VALUES ('临夏回族自治州',21); INSERT INTO china_area([name],parent_id) VALUES ('临汾市',6); INSERT INTO china_area([name],parent_id) VALUES ('临沂市',16); INSERT INTO china_area([name],parent_id) VALUES ('临沧市',25); INSERT INTO china_area([name],parent_id) VALUES ('临高县',24); INSERT INTO china_area([name],parent_id) VALUES ('丹东市',8); INSERT INTO china_area([name],parent_id) VALUES ('丽水市',12); INSERT INTO china_area([name],parent_id) VALUES ('丽江市',25); INSERT INTO china_area([name],parent_id) VALUES ('乌兰察布市',32); INSERT INTO china_area([name],parent_id) VALUES ('乌海市',32); INSERT INTO china_area([name],parent_id) VALUES ('乌苏市',31); INSERT INTO china_area([name],parent_id) VALUES ('乌鲁木齐市',31); INSERT INTO china_area([name],parent_id) VALUES ('乐东黎族自治县',24); INSERT INTO china_area([name],parent_id) VALUES ('乐山市',22); INSERT INTO china_area([name],parent_id) VALUES ('九江市',15); INSERT INTO china_area([name],parent_id) VALUES ('云林县',7); INSERT INTO china_area([name],parent_id) VALUES ('云浮市',20); INSERT INTO china_area([name],parent_id) VALUES ('五家渠市',31); INSERT INTO china_area([name],parent_id) VALUES ('五指山市',24); INSERT INTO china_area([name],parent_id) VALUES ('亳州市',13); INSERT INTO china_area([name],parent_id) VALUES ('仙桃市',18); INSERT INTO china_area([name],parent_id) VALUES ('伊 春 市',10); INSERT INTO china_area([name],parent_id) VALUES ('伊宁市',31); INSERT INTO china_area([name],parent_id) VALUES ('佛山市',20); INSERT INTO china_area([name],parent_id) VALUES ('佳木斯市',10); INSERT INTO china_area([name],parent_id) VALUES ('保亭黎族苗族自治县',24); INSERT INTO china_area([name],parent_id) VALUES ('保定市',5); INSERT INTO china_area([name],parent_id) VALUES ('保山市',25); INSERT INTO china_area([name],parent_id) VALUES ('信阳市',17); INSERT INTO china_area([name],parent_id) VALUES ('儋州市',24); INSERT INTO china_area([name],parent_id) VALUES ('克拉玛依市',31); INSERT INTO china_area([name],parent_id) VALUES ('六安市',13); INSERT INTO china_area([name],parent_id) VALUES ('六盘水市',23); INSERT INTO china_area([name],parent_id) VALUES ('兰州市',21); INSERT INTO china_area([name],parent_id) VALUES ('兴安盟',32); INSERT INTO china_area([name],parent_id) VALUES ('内江市',22); INSERT INTO china_area([name],parent_id) VALUES ('凉山彝族自治州',22); INSERT INTO china_area([name],parent_id) VALUES ('包头市',32); INSERT INTO china_area([name],parent_id) VALUES ('北京市',1); INSERT INTO china_area([name],parent_id) VALUES ('北海市',28); INSERT INTO china_area([name],parent_id) VALUES ('十堰市',18); INSERT INTO china_area([name],parent_id) VALUES ('南京市',11); INSERT INTO china_area([name],parent_id) VALUES ('南充市',22); INSERT INTO china_area([name],parent_id) VALUES ('南宁市',28); INSERT INTO china_area([name],parent_id) VALUES ('南平市',14); INSERT INTO china_area([name],parent_id) VALUES ('南投县',7); INSERT INTO china_area([name],parent_id) VALUES ('南昌市',15); INSERT INTO china_area([name],parent_id) VALUES ('南通市',11); INSERT INTO china_area([name],parent_id) VALUES ('南阳市',17); INSERT INTO china_area([name],parent_id) VALUES ('博乐市',31); INSERT INTO china_area([name],parent_id) VALUES ('厦门市',14); INSERT INTO china_area([name],parent_id) VALUES ('双鸭山市',10); INSERT INTO china_area([name],parent_id) VALUES ('台东县',7); INSERT INTO china_area([name],parent_id) VALUES ('台中县',7); INSERT INTO china_area([name],parent_id) VALUES ('台中市',7); INSERT INTO china_area([name],parent_id) VALUES ('台北县',7); INSERT INTO china_area([name],parent_id) VALUES ('台北市',7); INSERT INTO china_area([name],parent_id) VALUES ('台南县',7); INSERT INTO china_area([name],parent_id) VALUES ('台南市',7); INSERT INTO china_area([name],parent_id) VALUES ('台州市',12); INSERT INTO china_area([name],parent_id) VALUES ('合肥市',13); INSERT INTO china_area([name],parent_id) VALUES ('吉安市',15); INSERT INTO china_area([name],parent_id) VALUES ('吉林市',9); INSERT INTO china_area([name],parent_id) VALUES ('吐鲁番市',31); INSERT INTO china_area([name],parent_id) VALUES ('吕梁市',6); INSERT INTO china_area([name],parent_id) VALUES ('吴忠市',30); INSERT INTO china_area([name],parent_id) VALUES ('周口市',17); INSERT INTO china_area([name],parent_id) VALUES ('呼伦贝尔市',32); INSERT INTO china_area([name],parent_id) VALUES ('呼和浩特市',32); INSERT INTO china_area([name],parent_id) VALUES ('和田市',31); INSERT INTO china_area([name],parent_id) VALUES ('咸宁市',18); INSERT INTO china_area([name],parent_id) VALUES ('咸阳市',27); INSERT INTO china_area([name],parent_id) VALUES ('哈密市',31); INSERT INTO china_area([name],parent_id) VALUES ('哈尔滨市',10); INSERT INTO china_area([name],parent_id) VALUES ('唐山市',5); INSERT INTO china_area([name],parent_id) VALUES ('商丘市',17); INSERT INTO china_area([name],parent_id) VALUES ('商洛市',27); INSERT INTO china_area([name],parent_id) VALUES ('喀什市',31); INSERT INTO china_area([name],parent_id) VALUES ('嘉义县',7); INSERT INTO china_area([name],parent_id) VALUES ('嘉义市',7); INSERT INTO china_area([name],parent_id) VALUES ('嘉兴市',12); INSERT INTO china_area([name],parent_id) VALUES ('嘉峪关市',21); INSERT INTO china_area([name],parent_id) VALUES ('四平市',9); INSERT INTO china_area([name],parent_id) VALUES ('固原市',30); INSERT INTO china_area([name],parent_id) VALUES ('图木舒克市',31); INSERT INTO china_area([name],parent_id) VALUES ('基隆市',7); INSERT INTO china_area([name],parent_id) VALUES ('塔城市',31); INSERT INTO china_area([name],parent_id) VALUES ('大 庆 市',10); INSERT INTO china_area([name],parent_id) VALUES ('大兴安岭地区',10); INSERT INTO china_area([name],parent_id) VALUES ('大同市',6); INSERT INTO china_area([name],parent_id) VALUES ('大理白族自治州',25); INSERT INTO china_area([name],parent_id) VALUES ('大连市',8); INSERT INTO china_area([name],parent_id) VALUES ('天水市',21); INSERT INTO china_area([name],parent_id) VALUES ('天津市',2); INSERT INTO china_area([name],parent_id) VALUES ('天门市',18); INSERT INTO china_area([name],parent_id) VALUES ('太原市',6); INSERT INTO china_area([name],parent_id) VALUES ('奎屯市',31); INSERT INTO china_area([name],parent_id) VALUES ('威海市',16); INSERT INTO china_area([name],parent_id) VALUES ('娄底市',19); INSERT INTO china_area([name],parent_id) VALUES ('孝感市',18); INSERT INTO china_area([name],parent_id) VALUES ('宁德市',14); INSERT INTO china_area([name],parent_id) VALUES ('宁波市',12); INSERT INTO china_area([name],parent_id) VALUES ('安庆市',13); INSERT INTO china_area([name],parent_id) VALUES ('安康市',27); INSERT INTO china_area([name],parent_id) VALUES ('安阳市',17); INSERT INTO china_area([name],parent_id) VALUES ('安顺市',23); INSERT INTO china_area([name],parent_id) VALUES ('定安县',24); INSERT INTO china_area([name],parent_id) VALUES ('定西市',21); INSERT INTO china_area([name],parent_id) VALUES ('宜兰县',7); INSERT INTO china_area([name],parent_id) VALUES ('宜宾市',22); INSERT INTO china_area([name],parent_id) VALUES ('宜昌市',18); INSERT INTO china_area([name],parent_id) VALUES ('宜春市',15); INSERT INTO china_area([name],parent_id) VALUES ('宝鸡市',27); INSERT INTO china_area([name],parent_id) VALUES ('宣城市',13); INSERT INTO china_area([name],parent_id) VALUES ('宿州市',13); INSERT INTO china_area([name],parent_id) VALUES ('宿迁市',11); INSERT INTO china_area([name],parent_id) VALUES ('屏东县',7); INSERT INTO china_area([name],parent_id) VALUES ('屯昌县',24); INSERT INTO china_area([name],parent_id) VALUES ('山南地区',29); INSERT INTO china_area([name],parent_id) VALUES ('岳阳市',19); INSERT INTO china_area([name],parent_id) VALUES ('崇左市',28); INSERT INTO china_area([name],parent_id) VALUES ('巢湖市',13); INSERT INTO china_area([name],parent_id) VALUES ('巴中市',22); INSERT INTO china_area([name],parent_id) VALUES ('巴彦淖尔市',32); INSERT INTO china_area([name],parent_id) VALUES ('常州市',11); INSERT INTO china_area([name],parent_id) VALUES ('常德市',19); INSERT INTO china_area([name],parent_id) VALUES ('平凉市',21); INSERT INTO china_area([name],parent_id) VALUES ('平顶山市',17); INSERT INTO china_area([name],parent_id) VALUES ('广元市',22); INSERT INTO china_area([name],parent_id) VALUES ('广安市',22); INSERT INTO china_area([name],parent_id) VALUES ('广州市',20); INSERT INTO china_area([name],parent_id) VALUES ('庆阳市',21); INSERT INTO china_area([name],parent_id) VALUES ('库尔勒市',31); INSERT INTO china_area([name],parent_id) VALUES ('廊坊市',5); INSERT INTO china_area([name],parent_id) VALUES ('延安市',27); INSERT INTO china_area([name],parent_id) VALUES ('延边朝鲜族自治州',9); INSERT INTO china_area([name],parent_id) VALUES ('开封市',17); INSERT INTO china_area([name],parent_id) VALUES ('张家口市',5); INSERT INTO china_area([name],parent_id) VALUES ('张家界市',19); INSERT INTO china_area([name],parent_id) VALUES ('张掖市',21); INSERT INTO china_area([name],parent_id) VALUES ('彰化县',7); INSERT INTO china_area([name],parent_id) VALUES ('徐州市',11); INSERT INTO china_area([name],parent_id) VALUES ('德宏傣族景颇族自治州',25); INSERT INTO china_area([name],parent_id) VALUES ('德州市',16); INSERT INTO china_area([name],parent_id) VALUES ('德阳市',22); INSERT INTO china_area([name],parent_id) VALUES ('忻州市',6); INSERT INTO china_area([name],parent_id) VALUES ('怀化市',19); INSERT INTO china_area([name],parent_id) VALUES ('怒江傈傈族自治州',25); INSERT INTO china_area([name],parent_id) VALUES ('思茅市',25); INSERT INTO china_area([name],parent_id) VALUES ('恩施土家族苗族自治州',18); INSERT INTO china_area([name],parent_id) VALUES ('惠州市',20); INSERT INTO china_area([name],parent_id) VALUES ('成都市',22); INSERT INTO china_area([name],parent_id) VALUES ('扬州市',11); INSERT INTO china_area([name],parent_id) VALUES ('承德市',5); INSERT INTO china_area([name],parent_id) VALUES ('抚州市',15); INSERT INTO china_area([name],parent_id) VALUES ('抚顺市',8); INSERT INTO china_area([name],parent_id) VALUES ('拉萨市',29); INSERT INTO china_area([name],parent_id) VALUES ('揭阳市',20); INSERT INTO china_area([name],parent_id) VALUES ('攀枝花市',22); INSERT INTO china_area([name],parent_id) VALUES ('文山壮族苗族自治州',25); INSERT INTO china_area([name],parent_id) VALUES ('文昌市',24); INSERT INTO china_area([name],parent_id) VALUES ('新乡市',17); INSERT INTO china_area([name],parent_id) VALUES ('新余市',15); INSERT INTO china_area([name],parent_id) VALUES ('新竹县',7); INSERT INTO china_area([name],parent_id) VALUES ('新竹市',7); INSERT INTO china_area([name],parent_id) VALUES ('无锡市',11); INSERT INTO china_area([name],parent_id) VALUES ('日喀则地区',29); INSERT INTO china_area([name],parent_id) VALUES ('日照市',16); INSERT INTO china_area([name],parent_id) VALUES ('昆明市',25); INSERT INTO china_area([name],parent_id) VALUES ('昌吉市 ',31); INSERT INTO china_area([name],parent_id) VALUES ('昌江黎族自治县',24); INSERT INTO china_area([name],parent_id) VALUES ('昌都地区',29); INSERT INTO china_area([name],parent_id) VALUES ('昭通市',25); INSERT INTO china_area([name],parent_id) VALUES ('晋中市',6); INSERT INTO china_area([name],parent_id) VALUES ('晋城市',6); INSERT INTO china_area([name],parent_id) VALUES ('景德镇市',15); INSERT INTO china_area([name],parent_id) VALUES ('曲靖市',25); INSERT INTO china_area([name],parent_id) VALUES ('朔州市',6); INSERT INTO china_area([name],parent_id) VALUES ('朝阳市',8); INSERT INTO china_area([name],parent_id) VALUES ('本溪市',8); INSERT INTO china_area([name],parent_id) VALUES ('来宾市',28); INSERT INTO china_area([name],parent_id) VALUES ('杭州市',12); INSERT INTO china_area([name],parent_id) VALUES ('松原市',9); INSERT INTO china_area([name],parent_id) VALUES ('林芝地区',29); INSERT INTO china_area([name],parent_id) VALUES ('果洛藏族自治州',26); INSERT INTO china_area([name],parent_id) VALUES ('枣庄市',16); INSERT INTO china_area([name],parent_id) VALUES ('柳州市',28); INSERT INTO china_area([name],parent_id) VALUES ('株洲市',19); INSERT INTO china_area([name],parent_id) VALUES ('桂林市',28); INSERT INTO china_area([name],parent_id) VALUES ('桃园县',7); INSERT INTO china_area([name],parent_id) VALUES ('梅州市',20); INSERT INTO china_area([name],parent_id) VALUES ('梧州市',28); INSERT INTO china_area([name],parent_id) VALUES ('楚雄彝族自治州',25); INSERT INTO china_area([name],parent_id) VALUES ('榆林市',27); INSERT INTO china_area([name],parent_id) VALUES ('武威市',21); INSERT INTO china_area([name],parent_id) VALUES ('武汉市',18); INSERT INTO china_area([name],parent_id) VALUES ('毕节地区',23); INSERT INTO china_area([name],parent_id) VALUES ('永州市',19); INSERT INTO china_area([name],parent_id) VALUES ('汉中市',27); INSERT INTO china_area([name],parent_id) VALUES ('汕头市',20); INSERT INTO china_area([name],parent_id) VALUES ('汕尾市',20); INSERT INTO china_area([name],parent_id) VALUES ('江门市',20); INSERT INTO china_area([name],parent_id) VALUES ('池州市',13); INSERT INTO china_area([name],parent_id) VALUES ('沈阳市',8); INSERT INTO china_area([name],parent_id) VALUES ('沧州市',5); INSERT INTO china_area([name],parent_id) VALUES ('河池市',28); INSERT INTO china_area([name],parent_id) VALUES ('河源市',20); INSERT INTO china_area([name],parent_id) VALUES ('泉州市',14); INSERT INTO china_area([name],parent_id) VALUES ('泰安市',16); INSERT INTO china_area([name],parent_id) VALUES ('泰州市',11); INSERT INTO china_area([name],parent_id) VALUES ('泸州市',22); INSERT INTO china_area([name],parent_id) VALUES ('洛阳市',17); INSERT INTO china_area([name],parent_id) VALUES ('济南市',16); INSERT INTO china_area([name],parent_id) VALUES ('济宁市',16); INSERT INTO china_area([name],parent_id) VALUES ('济源市',17); INSERT INTO china_area([name],parent_id) VALUES ('海东地区',26); INSERT INTO china_area([name],parent_id) VALUES ('海北藏族自治州',26); INSERT INTO china_area([name],parent_id) VALUES ('海南藏族自治州',26); INSERT INTO china_area([name],parent_id) VALUES ('海口市',24); INSERT INTO china_area([name],parent_id) VALUES ('海西蒙古族藏族自治州',26); INSERT INTO china_area([name],parent_id) VALUES ('淄博市',16); INSERT INTO china_area([name],parent_id) VALUES ('淮北市',13); INSERT INTO china_area([name],parent_id) VALUES ('淮南市',13); INSERT INTO china_area([name],parent_id) VALUES ('淮安市',11); INSERT INTO china_area([name],parent_id) VALUES ('深圳市',20); INSERT INTO china_area([name],parent_id) VALUES ('清远市',20); INSERT INTO china_area([name],parent_id) VALUES ('温州市',12); INSERT INTO china_area([name],parent_id) VALUES ('渭南市',27); INSERT INTO china_area([name],parent_id) VALUES ('湖州市',12); INSERT INTO china_area([name],parent_id) VALUES ('湘潭市',19); INSERT INTO china_area([name],parent_id) VALUES ('湘西土家族苗族自治州',19); INSERT INTO china_area([name],parent_id) VALUES ('湛江市',20); INSERT INTO china_area([name],parent_id) VALUES ('滁州市',13); INSERT INTO china_area([name],parent_id) VALUES ('滨州市',16); INSERT INTO china_area([name],parent_id) VALUES ('漯河市',17); INSERT INTO china_area([name],parent_id) VALUES ('漳州市',14); INSERT INTO china_area([name],parent_id) VALUES ('潍坊市',16); INSERT INTO china_area([name],parent_id) VALUES ('潜江市',18); INSERT INTO china_area([name],parent_id) VALUES ('潮州市',20); INSERT INTO china_area([name],parent_id) VALUES ('澄迈县',24); INSERT INTO china_area([name],parent_id) VALUES ('澎湖县',7); INSERT INTO china_area([name],parent_id) VALUES ('澳门特别行政区',33); INSERT INTO china_area([name],parent_id) VALUES ('濮阳市',17); INSERT INTO china_area([name],parent_id) VALUES ('烟台市',16); INSERT INTO china_area([name],parent_id) VALUES ('焦作市',17); INSERT INTO china_area([name],parent_id) VALUES ('牡丹江市',10); INSERT INTO china_area([name],parent_id) VALUES ('玉林市',28); INSERT INTO china_area([name],parent_id) VALUES ('玉树藏族自治州',26); INSERT INTO china_area([name],parent_id) VALUES ('玉溪市',25); INSERT INTO china_area([name],parent_id) VALUES ('珠海市',20); INSERT INTO china_area([name],parent_id) VALUES ('琼中黎族苗族自治县',24); INSERT INTO china_area([name],parent_id) VALUES ('琼海市',24); INSERT INTO china_area([name],parent_id) VALUES ('甘南藏族自治州',21); INSERT INTO china_area([name],parent_id) VALUES ('甘孜藏族自治州',22); INSERT INTO china_area([name],parent_id) VALUES ('白城市',9); INSERT INTO china_area([name],parent_id) VALUES ('白山市',9); INSERT INTO china_area([name],parent_id) VALUES ('白沙黎族自治县',24); INSERT INTO china_area([name],parent_id) VALUES ('白银市',21); INSERT INTO china_area([name],parent_id) VALUES ('百色市',28); INSERT INTO china_area([name],parent_id) VALUES ('益阳市',19); INSERT INTO china_area([name],parent_id) VALUES ('盐城市',11); INSERT INTO china_area([name],parent_id) VALUES ('盘锦市',8); INSERT INTO china_area([name],parent_id) VALUES ('眉山市',22); INSERT INTO china_area([name],parent_id) VALUES ('石嘴山市',30); INSERT INTO china_area([name],parent_id) VALUES ('石家庄市',5); INSERT INTO china_area([name],parent_id) VALUES ('石河子市 ',31); INSERT INTO china_area([name],parent_id) VALUES ('神农架林区',18); INSERT INTO china_area([name],parent_id) VALUES ('福州市',14); INSERT INTO china_area([name],parent_id) VALUES ('秦皇岛市',5); INSERT INTO china_area([name],parent_id) VALUES ('米泉市',31); INSERT INTO china_area([name],parent_id) VALUES ('红河哈尼族彝族自治州',25); INSERT INTO china_area([name],parent_id) VALUES ('绍兴市',12); INSERT INTO china_area([name],parent_id) VALUES ('绥 化 市',10); INSERT INTO china_area([name],parent_id) VALUES ('绵阳市',22); INSERT INTO china_area([name],parent_id) VALUES ('聊城市',16); INSERT INTO china_area([name],parent_id) VALUES ('肇庆市',20); INSERT INTO china_area([name],parent_id) VALUES ('自贡市',22); INSERT INTO china_area([name],parent_id) VALUES ('舟山市',12); INSERT INTO china_area([name],parent_id) VALUES ('芜湖市',13); INSERT INTO china_area([name],parent_id) VALUES ('花莲县',7); INSERT INTO china_area([name],parent_id) VALUES ('苏州市',11); INSERT INTO china_area([name],parent_id) VALUES ('苗栗县',7); INSERT INTO china_area([name],parent_id) VALUES ('茂名市',20); INSERT INTO china_area([name],parent_id) VALUES ('荆州市',18); INSERT INTO china_area([name],parent_id) VALUES ('荆门市',18); INSERT INTO china_area([name],parent_id) VALUES ('莆田市',14); INSERT INTO china_area([name],parent_id) VALUES ('莱芜市',16); INSERT INTO china_area([name],parent_id) VALUES ('菏泽市',16); INSERT INTO china_area([name],parent_id) VALUES ('萍乡市',15); INSERT INTO china_area([name],parent_id) VALUES ('营口市',8); INSERT INTO china_area([name],parent_id) VALUES ('葫芦岛市',8); INSERT INTO china_area([name],parent_id) VALUES ('蚌埠市',13); INSERT INTO china_area([name],parent_id) VALUES ('衡水市',5); INSERT INTO china_area([name],parent_id) VALUES ('衡阳市',19); INSERT INTO china_area([name],parent_id) VALUES ('衢州市',12); INSERT INTO china_area([name],parent_id) VALUES ('襄樊市',18); INSERT INTO china_area([name],parent_id) VALUES ('西双版纳傣族自治州',25); INSERT INTO china_area([name],parent_id) VALUES ('西宁市',26); INSERT INTO china_area([name],parent_id) VALUES ('西安市',27); INSERT INTO china_area([name],parent_id) VALUES ('许昌市',17); INSERT INTO china_area([name],parent_id) VALUES ('贵港市',28); INSERT INTO china_area([name],parent_id) VALUES ('贵阳市',23); INSERT INTO china_area([name],parent_id) VALUES ('贺州市',28); INSERT INTO china_area([name],parent_id) VALUES ('资阳市',22); INSERT INTO china_area([name],parent_id) VALUES ('赣州市',15); INSERT INTO china_area([name],parent_id) VALUES ('赤峰市',32); INSERT INTO china_area([name],parent_id) VALUES ('辽源市',9); INSERT INTO china_area([name],parent_id) VALUES ('辽阳市',8); INSERT INTO china_area([name],parent_id) VALUES ('达州市',22); INSERT INTO china_area([name],parent_id) VALUES ('运城市',6); INSERT INTO china_area([name],parent_id) VALUES ('连云港市',11); INSERT INTO china_area([name],parent_id) VALUES ('迪庆藏族自治州',25); INSERT INTO china_area([name],parent_id) VALUES ('通化市',9); INSERT INTO china_area([name],parent_id) VALUES ('通辽市',32); INSERT INTO china_area([name],parent_id) VALUES ('遂宁市',22); INSERT INTO china_area([name],parent_id) VALUES ('遵义市',23); INSERT INTO china_area([name],parent_id) VALUES ('邢台市',5); INSERT INTO china_area([name],parent_id) VALUES ('那曲地区',29); INSERT INTO china_area([name],parent_id) VALUES ('邯郸市',5); INSERT INTO china_area([name],parent_id) VALUES ('邵阳市',19); INSERT INTO china_area([name],parent_id) VALUES ('郑州市',17); INSERT INTO china_area([name],parent_id) VALUES ('郴州市',19); INSERT INTO china_area([name],parent_id) VALUES ('鄂尔多斯市',32); INSERT INTO china_area([name],parent_id) VALUES ('鄂州市',18); INSERT INTO china_area([name],parent_id) VALUES ('酒泉市',21); INSERT INTO china_area([name],parent_id) VALUES ('重庆市',4); INSERT INTO china_area([name],parent_id) VALUES ('金华市',12); INSERT INTO china_area([name],parent_id) VALUES ('金昌市',21); INSERT INTO china_area([name],parent_id) VALUES ('钦州市',28); INSERT INTO china_area([name],parent_id) VALUES ('铁岭市',8); INSERT INTO china_area([name],parent_id) VALUES ('铜仁地区',23); INSERT INTO china_area([name],parent_id) VALUES ('铜川市',27); INSERT INTO china_area([name],parent_id) VALUES ('铜陵市',13); INSERT INTO china_area([name],parent_id) VALUES ('银川市',30); INSERT INTO china_area([name],parent_id) VALUES ('锡林郭勒盟',32); INSERT INTO china_area([name],parent_id) VALUES ('锦州市',8); INSERT INTO china_area([name],parent_id) VALUES ('镇江市',11); INSERT INTO china_area([name],parent_id) VALUES ('长春市',9); INSERT INTO china_area([name],parent_id) VALUES ('长沙市',19); INSERT INTO china_area([name],parent_id) VALUES ('长治市',6); INSERT INTO china_area([name],parent_id) VALUES ('阜康市',31); INSERT INTO china_area([name],parent_id) VALUES ('阜新市',8); INSERT INTO china_area([name],parent_id) VALUES ('阜阳市',13); INSERT INTO china_area([name],parent_id) VALUES ('防城港市',28); INSERT INTO china_area([name],parent_id) VALUES ('阳江市',20); INSERT INTO china_area([name],parent_id) VALUES ('阳泉市',6); INSERT INTO china_area([name],parent_id) VALUES ('阿克苏市',31); INSERT INTO china_area([name],parent_id) VALUES ('阿勒泰市',31); INSERT INTO china_area([name],parent_id) VALUES ('阿图什市',31); INSERT INTO china_area([name],parent_id) VALUES ('阿坝藏族羌族自治州',22); INSERT INTO china_area([name],parent_id) VALUES ('阿拉善盟',32); INSERT INTO china_area([name],parent_id) VALUES ('阿拉尔市',31); INSERT INTO china_area([name],parent_id) VALUES ('阿里地区',29); INSERT INTO china_area([name],parent_id) VALUES ('陇南市',21); INSERT INTO china_area([name],parent_id) VALUES ('陵水黎族自治县',24); INSERT INTO china_area([name],parent_id) VALUES ('随州市',18); INSERT INTO china_area([name],parent_id) VALUES ('雅安市',22); INSERT INTO china_area([name],parent_id) VALUES ('青岛市',16); INSERT INTO china_area([name],parent_id) VALUES ('鞍山市',8); INSERT INTO china_area([name],parent_id) VALUES ('韶关市',20); INSERT INTO china_area([name],parent_id) VALUES ('香港特别行政区',34); INSERT INTO china_area([name],parent_id) VALUES ('马鞍山市',13); INSERT INTO china_area([name],parent_id) VALUES ('驻马店市',17); INSERT INTO china_area([name],parent_id) VALUES ('高雄县',7); INSERT INTO china_area([name],parent_id) VALUES ('高雄市',7); INSERT INTO china_area([name],parent_id) VALUES ('鸡 西 市',10); INSERT INTO china_area([name],parent_id) VALUES ('鹤 岗 市',10); INSERT INTO china_area([name],parent_id) VALUES ('鹤壁市',17); INSERT INTO china_area([name],parent_id) VALUES ('鹰潭市',15); INSERT INTO china_area([name],parent_id) VALUES ('黄冈市',18); INSERT INTO china_area([name],parent_id) VALUES ('黄南藏族自治州',26); INSERT INTO china_area([name],parent_id) VALUES ('黄山市',13); INSERT INTO china_area([name],parent_id) VALUES ('黄石市',18); INSERT INTO china_area([name],parent_id) VALUES ('黑 河 市',10); INSERT INTO china_area([name],parent_id) VALUES ('黔东南苗族侗族自治州',23); INSERT INTO china_area([name],parent_id) VALUES ('黔南布依族苗族自治州',23); INSERT INTO china_area([name],parent_id) VALUES ('黔西南布依族苗族自治州',23); INSERT INTO china_area([name],parent_id) VALUES ('齐齐哈尔市',10); INSERT INTO china_area([name],parent_id) VALUES ('龙岩市',14);