2个dropdownlist应用 打扰你们午休了

Question

一个dropdownlist1里面放省 
另一个dropdownlist2放市当在dropdownlist1里面选择省后
dropdownlist2里面显示该省对应的市怎么实现 大伙帮帮忙 打扰你们午休了

Answer 1

我刚刚做了的<script runat="server">
    BJCity City = new BJCity();
  protected override void Before_BindForm(WebBase info, bool isNew)
  {
    base.Before_BindForm(info, isNew);
    BJProductCategory catetory = info as BJProductCategory;
    BJProvince Province = new BJProvince();        
    if (!IsPostBack)
    {
      //加载分类树
        //catetory.ParentID = 0;
       //按ID大小显示信息
      //catetory.OrderNo =
        //DataTable dt = WebManager.List(catetory, "", "[ID],[Title]", "&version=", "[OrderNo]");
        catetory.Version = "cn";
        DataTable dt = WebManager.GetCategoryTree(catetory);
      DataView dv = new DataView(dt);
      ////dv.Sort = " Path ";
      BJProductCategory_ParentID.DataSource = dv;
      BJProductCategory_ParentID.DataValueField = "ID";
      BJProductCategory_ParentID.DataTextField = "Title";
      BJProductCategory_ParentID.DataBind();      Province.Version = "cn";
      DataTable dt1 = WebManager.List(Province,"", "[ID],[Title]", "&version=", "[OrderNo] asc");
      DataView dv1 = new DataView(dt1);
      ////dv.Sort = " Path ";
      BJProductCategory_CategoryProvince.DataSource = dv1;
      BJProductCategory_CategoryProvince.DataValueField = "ID";
      BJProductCategory_CategoryProvince.DataTextField = "Title";
      BJProductCategory_CategoryProvince.DataBind();      City.ParentID = Convert.ToInt32(BJProductCategory_CategoryProvince.SelectedValue);
      DataTable dt2 = WebManager.List(City, "", "[ID],[Title]", "&parentid=", "[OrderNo]");
      DataView dv2 = new DataView(dt2);
      ////dv.Sort = " Path ";
      BJProductCategory_CategoryFrom.DataSource = dv2;
      BJProductCategory_CategoryFrom.DataValueField = "ID";
      BJProductCategory_CategoryFrom.DataTextField = "Title";
      BJProductCategory_CategoryFrom.DataBind();
    }
  }
  protected override void Before_SaveData(WebBase info, bool isNew)
  {
    base.Before_SaveData(info, isNew);
    if (isNew)
    {
      //自动获取分类深度       
      BJProductCategory parent = new BJProductCategory();
      parent.ID = Convert.ToInt32(BJProductCategory_ParentID.SelectedValue);
      WebManager.GetInfo(parent);
      BJProductCategory child = info as BJProductCategory;
      child.Depth = parent.Depth + 1;
      //这个是二级分类的原if (child.Depth >= Config.MaxDepth_ProductCategory)
      if (child.Depth >= 10)
      {
        throw new Exception("超过了分类级数，不能再分类了");
      }
    }
  }
  protected override void After_SaveData(WebBase info, bool isNew)
  {
    base.After_SaveData(info, isNew);
    if (isNew)
    {
      //自动增加父分类的子节点数      
      BJProductCategory parent = new BJProductCategory();
      parent.ID = Convert.ToInt32(BJProductCategory_ParentID.SelectedValue);
      WebManager.Update(parent, "childnum");
    }
  }    protected void BJProductCategory_CategoryProvince_SelectedIndexChanged(object sender, EventArgs e)
    {        City.ParentID = Convert.ToInt32(BJProductCategory_CategoryProvince.SelectedValue);
        DataTable dt2 = WebManager.List(City,"","[ID],[Title]","&parentid=","[OrderNo]");
        DataView dv2 = new DataView(dt2);
        ////dv.Sort = " Path ";
        BJProductCategory_CategoryFrom.DataSource = dv2;
        BJProductCategory_CategoryFrom.DataValueField = "ID";
        BJProductCategory_CategoryFrom.DataTextField = "Title";
        BJProductCategory_CategoryFrom.DataBind();
    }
</script>

Answer 2

<%@ Page Language="C#" Inherits="BaiJie.Web.WebInfoEditPage" ValidateRequest="false" %>
<script runat="server">
    BJCity City = new BJCity();
  protected override void Before_BindForm(WebBase info, bool isNew)
  {
    base.Before_BindForm(info, isNew);
    BJProductCategory catetory = info as BJProductCategory;
    BJProvince Province = new BJProvince();        
    if (!IsPostBack)
    {
      //加载分类树
        //catetory.ParentID = 0;
       //按ID大小显示信息
      //catetory.OrderNo =
        //DataTable dt = WebManager.List(catetory, "", "[ID],[Title]", "&version=", "[OrderNo]");
        catetory.Version = "cn";
        DataTable dt = WebManager.GetCategoryTree(catetory);
      DataView dv = new DataView(dt);
      ////dv.Sort = " Path ";
      BJProductCategory_ParentID.DataSource = dv;
      BJProductCategory_ParentID.DataValueField = "ID";
      BJProductCategory_ParentID.DataTextField = "Title";
      BJProductCategory_ParentID.DataBind();
      //取出所有的省级信息
      Province.Version = "cn";
      DataTable dt1 = WebManager.List(Province,"", "[ID],[Title]", "&version=", "[OrderNo] asc");
      DataView dv1 = new DataView(dt1);
      ////dv.Sort = " Path ";
      BJProductCategory_CategoryProvince.DataSource = dv1;
      BJProductCategory_CategoryProvince.DataValueField = "ID";
      BJProductCategory_CategoryProvince.DataTextField = "Title";
      BJProductCategory_CategoryProvince.DataBind();
      //根据BJProductCategory_CategoryProvince的ID省级ID得到对应的城市
      City.ParentID = Convert.ToInt32(BJProductCategory_CategoryProvince.SelectedValue);
      DataTable dt2 = WebManager.List(City, "", "[ID],[Title]", "&parentid=", "[OrderNo]");
      DataView dv2 = new DataView(dt2);
      ////dv.Sort = " Path ";
      BJProductCategory_CategoryFrom.DataSource = dv2;
      BJProductCategory_CategoryFrom.DataValueField = "ID";
      BJProductCategory_CategoryFrom.DataTextField = "Title";
      BJProductCategory_CategoryFrom.DataBind();
    }
  }
  protected override void Before_SaveData(WebBase info, bool isNew)
  {
    base.Before_SaveData(info, isNew);
    if (isNew)
    {
      //自动获取分类深度       
      BJProductCategory parent = new BJProductCategory();
      parent.ID = Convert.ToInt32(BJProductCategory_ParentID.SelectedValue);
      WebManager.GetInfo(parent);
      BJProductCategory child = info as BJProductCategory;
      child.Depth = parent.Depth + 1;
      //这个是二级分类的原if (child.Depth >= Config.MaxDepth_ProductCategory)
      if (child.Depth >= 10)
      {
        throw new Exception("超过了分类级数，不能再分类了");
      }
    }
  }
  protected override void After_SaveData(WebBase info, bool isNew)
  {
    base.After_SaveData(info, isNew);
    if (isNew)
    {
      //自动增加父分类的子节点数      
      BJProductCategory parent = new BJProductCategory();
      parent.ID = Convert.ToInt32(BJProductCategory_ParentID.SelectedValue);
      WebManager.Update(parent, "childnum");
    }
  }    protected void BJProductCategory_CategoryProvince_SelectedIndexChanged(object sender, EventArgs e)
    {        City.ParentID = Convert.ToInt32(BJProductCategory_CategoryProvince.SelectedValue);
        DataTable dt2 = WebManager.List(City,"","[ID],[Title]","&parentid=","[OrderNo]");
        DataView dv2 = new DataView(dt2);
        ////dv.Sort = " Path ";
        BJProductCategory_CategoryFrom.DataSource = dv2;
        BJProductCategory_CategoryFrom.DataValueField = "ID";
        BJProductCategory_CategoryFrom.DataTextField = "Title";
        BJProductCategory_CategoryFrom.DataBind();
    }
</script><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>产品分类管理</title>
<script type="text/javascript" src="script/util.js"></script>
<script type="text/javascript" src="script/edit.js"></script>
<script type="text/javascript">if(top.location.href == self.location.href){top.location.href = "frame.aspx";}</script>
<script type="text/javascript">window.onerror = reportError;</script>
<link href="style/style.css" rel="stylesheet" type="text/css" />
</head><body>
<form runat="server" id="form1">
<div id="MainPageWrapper">    
  <div id="optionRow"> <!--div layout,so nice --> 
    <ul>
      <li id="newsTitle"><img src="images/a1.gif" width="16" height="16" alt="dot" />&nbsp;<a href="javascript:goList('BJProductCategory_List.aspx');">产品分类管理</a></li>
      <li class="liLineBackground"></li>
    </ul>
  </div>
  <!--page edit container start --> 
  <div id="EditContainer">
    <table style="width:99%; border-collapse: collapse;" border="1" bordercolor="#9DBBFF" cellpadding="0" cellspacing="0">
      <tr>
      <td width="70" class="TitleBarText">标 题：</td>
      <td>&nbsp;<asp:TextBox ID="BJProductCategory_Title" runat="server" CssClass="text500" MaxLength="30"></asp:TextBox>
      <asp:RequiredFieldValidator ID="Req" runat="server" ControlToValidate="BJProductCategory_Title" ErrorMessage="必填"></asp:RequiredFieldValidator>
      </td>
      </tr>
       <tr>
      <td class="TitleBarText">地区：</td>
      <td>&nbsp;<asp:DropDownList ID="BJProductCategory_CategoryProvince" runat="server" AutoPostBack="true" OnSelectedIndexChanged="BJProductCategory_CategoryProvince_SelectedIndexChanged">
      </asp:DropDownList>
          <asp:DropDownList ID="BJProductCategory_CategoryFrom" runat="server" AutoPostBack="true">
          </asp:DropDownList>
          <%--<asp:Label ID="Label1" runat="server" Text="请选择产品系列或成功系列！" Width="160px" ForeColor="Red"></asp:Label>--%></td>
      </tr>
      <tr>
      <td class="TitleBarText">父级分类：</td>
      <td>&nbsp;<asp:DropDownList ID="BJProductCategory_ParentID" runat="server">
      </asp:DropDownList>
          <%--<asp:Label ID="Label1" runat="server" Text="请选择产品系列或成功系列！" Width="160px" ForeColor="Red"></asp:Label>--%></td>
      </tr>
      <tr>
      <td class="TitleBarText">排序号：</td>
      <td>&nbsp;<asp:TextBox ID="BJProductCategory_OrderNo" runat="server" CssClass="text50" />
          <asp:RegularExpressionValidator ID="RegularExpressionValidator1" runat="server" ControlToValidate="BJProductCategory_OrderNo"
              ErrorMessage="请输入整数！" ValidationExpression="^[1-9]\d*|0$"></asp:RegularExpressionValidator><%--<asp:RegularExpressionValidator ID="revOrderNo" runat="server" ControlToValidate="BJProductCategory_OrderNo" ErrorMessage="请填写正整数" ValidationExpression="^([1-9]{1,2}|1[0-7][0-9]|180)$" />--%></td>
      </tr>
      <tr>
      <td class="TitleBarText">摘要：</td>
      <td>&nbsp;<textarea id="BJProductCategory_Description" name="BJProductCategory_Description" runat="server" rows="7" cols="50" />&nbsp;&nbsp;200字以内</td>
      </tr>
    </table>
  </div>
  <!--submit and back button --> 
  <div id="EditSubmitBackBtn">
    <input id="btnEdit" type="button" runat="server" onclick="setDisabled('BJProductCategory_Title',this);" onserverclick="Save_OnClick" value="保存" />&nbsp;&nbsp;&nbsp;
    <input id="btnBack" type="button" value="返回" onclick="goList('BJProductCategory_List.aspx')" />
    <asp:Label ID="lblMessage" runat="server"></asp:Label>
  </div>
</div>
</form>
</body>
</html>

Answer 3

数据库信息
create table BJProvince
(
  ID int primary key,
  Title nvarchar(200),
  CreateTime Datetime default convert(varchar(10),getdate(),120),
  ModifyTime Datetime,
  IsHidden bit default 0,
  IsSystem bit default 0,
  IsChecked bit default 1,
  Version nvarchar(50) default 'cn',
  OwnerName nvarchar(50) default 'Admin',
  OrderNo int default 1,
  Keyword nvarchar(50),
  Description nvarchar(500),
)insert into BJProvince(ID,Title) values(1,'北京市')
insert into BJProvince(ID,Title) values(2,'天津市')
insert into BJProvince(ID,Title) values(3,'上海市')
insert into BJProvince(ID,Title) values(4,'重庆市')
insert into BJProvince(ID,Title) values(5,'河北省')
insert into BJProvince(ID,Title) values(6,'山西省')
insert into BJProvince(ID,Title) values(7,'台湾省')
insert into BJProvince(ID,Title) values(8,'辽宁省')
insert into BJProvince(ID,Title) values(9,'吉林省')
insert into BJProvince(ID,Title) values(10,'黑龙江省')
insert into BJProvince(ID,Title) values(11,'江苏省')
insert into BJProvince(ID,Title) values(12,'浙江省')
insert into BJProvince(ID,Title) values(13,'安徽省')
insert into BJProvince(ID,Title) values(14,'福建省')
insert into BJProvince(ID,Title) values(15,'江西省')
insert into BJProvince(ID,Title) values(16,'山东省')
insert into BJProvince(ID,Title) values(17,'河南省')
insert into BJProvince(ID,Title) values(18,'湖北省')
insert into BJProvince(ID,Title) values(19,'湖南省')
insert into BJProvince(ID,Title) values(20,'广东省')
insert into BJProvince(ID,Title) values(21,'甘肃省')
insert into BJProvince(ID,Title) values(22,'四川省')
--insert into BJProvince(ID,Title) values(23,'山东省')
insert into BJProvince(ID,Title) values(24,'贵州省')
insert into BJProvince(ID,Title) values(25,'海南省')
insert into BJProvince(ID,Title) values(26,'云南省')
insert into BJProvince(ID,Title) values(27,'青海省')
insert into BJProvince(ID,Title) values(28,'陕西省')
insert into BJProvince(ID,Title) values(29,'广西壮族自治区')
insert into BJProvince(ID,Title) values(30,'西藏自治区')
insert into BJProvince(ID,Title) values(31,'宁夏回族自治区')
insert into BJProvince(ID,Title) values(32,'新疆维吾尔自治区')
insert into BJProvince(ID,Title) values(33,'内蒙古自治区')
insert into BJProvince(ID,Title) values(34,'澳门特别行政区')
insert into BJProvince(ID,Title) values(35,'香港特别行政区')create table BJCity
(
  ID int not null,
  Title nvarchar(200),
  CreateTime Datetime default convert(varchar(10),getdate(),120),
  ModifyTime Datetime,
  IsHidden bit default 0,
  IsSystem bit default 0,
  IsChecked bit default 1,
  Version nvarchar(50) default 'cn',
  OwnerName nvarchar(50) default 'Admin',
  OrderNo int default 1,
  Keyword nvarchar(50),
  Description nvarchar(500),
  ParentID int
)insert into BJCity(ID,Title,ParentID) values(1,'北京市',1)
insert into BJCity(ID,Title,ParentID) values(1,'天津市',2)
insert into BJCity(ID,Title,ParentID) values(1,'上海市',3)
insert into BJCity(ID,Title,ParentID) values(1,'重庆市',4)
--5河北省(2005年辖：11个地级市，36个市辖区、22个县级市、108个县、6个自治县)
insert into BJCity(ID,Title,ParentID) values(1,'石家庄市',5)
insert into BJCity(ID,Title,ParentID) values(2,'唐山市',5)
insert into BJCity(ID,Title,ParentID) values(3,'秦皇岛市',5)
insert into BJCity(ID,Title,ParentID) values(4,'邯郸市',5)
insert into BJCity(ID,Title,ParentID) values(5,'邢台市',5)
insert into BJCity(ID,Title,ParentID) values(6,'保定市',5)
insert into BJCity(ID,Title,ParentID) values(7,'张家口市',5)
insert into BJCity(ID,Title,ParentID) values(8,'承德市',5)
insert into BJCity(ID,Title,ParentID) values(9,'沧州市',5)
insert into BJCity(ID,Title,ParentID) values(10,'廊坊市',5)
insert into BJCity(ID,Title,ParentID) values(11,'衡水市',5)
--6山西省11个城市
insert into BJCity(ID,Title,ParentID) values(1,'太原市',6)
insert into BJCity(ID,Title,ParentID) values(2,'大同市',6)
insert into BJCity(ID,Title,ParentID) values(3,'阳泉市',6)
insert into BJCity(ID,Title,ParentID) values(4,'长治市',6)
insert into BJCity(ID,Title,ParentID) values(5,'晋城市',6)
insert into BJCity(ID,Title,ParentID) values(6,'朔州市',6)
insert into BJCity(ID,Title,ParentID) values(7,'晋中市',6)
insert into BJCity(ID,Title,ParentID) values(8,'运城市',6)
insert into BJCity(ID,Title,ParentID) values(9,'忻州市',6)
insert into BJCity(ID,Title,ParentID) values(10,'临汾市',6)
insert into BJCity(ID,Title,ParentID) values(11,'吕梁市',6)
--7台湾省(台湾本岛和澎湖共设7市、16县，其中台北市和高雄市为“院辖市”，直属“行政院”，其余属台湾省；市下设区，县下设市（县辖市）、镇、乡，合称区市镇乡。)
insert into BJCity(ID,Title,ParentID) values(1,'台北市',7)
insert into BJCity(ID,Title,ParentID) values(2,'高雄市',7)
insert into BJCity(ID,Title,ParentID) values(3,'基隆市',7)
insert into BJCity(ID,Title,ParentID) values(4,'台中市',7)
insert into BJCity(ID,Title,ParentID) values(5,'台南市',7)
insert into BJCity(ID,Title,ParentID) values(6,'新竹市',7)
insert into BJCity(ID,Title,ParentID) values(7,'嘉义市',7)
insert into BJCity(ID,Title,ParentID) values(8,'台北县',7)
insert into BJCity(ID,Title,ParentID) values(9,'宜兰县',7)
insert into BJCity(ID,Title,ParentID) values(10,'桃园县',7)
insert into BJCity(ID,Title,ParentID) values(11,'新竹县',7)
insert into BJCity(ID,Title,ParentID) values(12,'苗栗县',7)
insert into BJCity(ID,Title,ParentID) values(13,'台中县',7)
insert into BJCity(ID,Title,ParentID) values(14,'彰化县',7)
insert into BJCity(ID,Title,ParentID) values(15,'南投县',7)
insert into BJCity(ID,Title,ParentID) values(16,'云林县',7)
insert into BJCity(ID,Title,ParentID) values(17,'嘉义县',7)
insert into BJCity(ID,Title,ParentID) values(18,'台南县',7)
insert into BJCity(ID,Title,ParentID) values(19,'高雄县',7)
insert into BJCity(ID,Title,ParentID) values(20,'屏东县',7)
insert into BJCity(ID,Title,ParentID) values(21,'澎湖县',7)
insert into BJCity(ID,Title,ParentID) values(22,'台东县',7)
insert into BJCity(ID,Title,ParentID) values(23,'花莲县',7)
--8辽宁省(2006年，辖：14个地级市；56个市辖区、17个县级市、19个县、8个自治县。)
insert into BJCity(ID,Title,ParentID) values(1,'沈阳市',8)
insert into BJCity(ID,Title,ParentID) values(2,'大连市',8)
insert into BJCity(ID,Title,ParentID) values(3,'鞍山市',8)
insert into BJCity(ID,Title,ParentID) values(4,'抚顺市',8)
insert into BJCity(ID,Title,ParentID) values(5,'本溪市',8)
insert into BJCity(ID,Title,ParentID) values(6,'丹东市',8)
insert into BJCity(ID,Title,ParentID) values(7,'锦州市',8)
insert into BJCity(ID,Title,ParentID) values(8,'营口市',8)
insert into BJCity(ID,Title,ParentID) values(9,'阜新市',8)
insert into BJCity(ID,Title,ParentID) values(10,'辽阳市',8)
insert into BJCity(ID,Title,ParentID) values(11,'盘锦市',8)
insert into BJCity(ID,Title,ParentID) values(12,'铁岭市',8)
insert into BJCity(ID,Title,ParentID) values(13,'朝阳市',8)
insert into BJCity(ID,Title,ParentID) values(14,'葫芦岛市',8)
--9吉林省(2006年，辖：8个地级市、1个自治州；20个市辖区、20个县级市、17个县、3个自治县。)
insert into BJCity(ID,Title,ParentID) values(1,'长春市',9)
insert into BJCity(ID,Title,ParentID) values(2,'吉林市',9)
insert into BJCity(ID,Title,ParentID) values(3,'四平市',9)
insert into BJCity(ID,Title,ParentID) values(4,'辽源市',9)
insert into BJCity(ID,Title,ParentID) values(5,'通化市',9)
insert into BJCity(ID,Title,ParentID) values(6,'白山市',9)
insert into BJCity(ID,Title,ParentID) values(7,'松原市',9)
insert into BJCity(ID,Title,ParentID) values(8,'白城市',9)
insert into BJCity(ID,Title,ParentID) values(9,'延边朝鲜族自治州',9)

Answer 4

--到對應語言的版問問,sql語句部份很簡單
SELECT 市 FROM 表 WHERE 省='省'

Answer 5

[code=SQL]--10黑龙江省(2006年，辖：12地级市、1地区；64市辖区、18县级市、45县、1自治县)
insert into BJCity(ID,Title,ParentID) values(1,'哈尔滨市',10)
insert into BJCity(ID,Title,ParentID) values(2,'齐齐哈尔市',10)
insert into BJCity(ID,Title,ParentID) values(3,'鹤 岗 市',10)
insert into BJCity(ID,Title,ParentID) values(4,'双鸭山市',10)
insert into BJCity(ID,Title,ParentID) values(5,'鸡 西 市',10)
insert into BJCity(ID,Title,ParentID) values(6,'大 庆 市',10)
insert into BJCity(ID,Title,ParentID) values(7,'伊 春 市',10)
insert into BJCity(ID,Title,ParentID) values(8,'牡丹江市',10)
insert into BJCity(ID,Title,ParentID) values(9,'佳木斯市',10)
insert into BJCity(ID,Title,ParentID) values(10,'七台河市',10)
insert into BJCity(ID,Title,ParentID) values(11,'黑 河 市',10)
insert into BJCity(ID,Title,ParentID) values(12,'绥 化 市',10)
insert into BJCity(ID,Title,ParentID) values(13,'大兴安岭地区',10)
--11江苏省(2005年辖：13个地级市；54个市辖区、27个县级市、25个县)
insert into BJCity(ID,Title,ParentID) values(1,'南京市',11)
insert into BJCity(ID,Title,ParentID) values(2,'无锡市',11)
insert into BJCity(ID,Title,ParentID) values(3,'徐州市',11)
insert into BJCity(ID,Title,ParentID) values(4,'常州市',11)
insert into BJCity(ID,Title,ParentID) values(5,'苏州市',11)
insert into BJCity(ID,Title,ParentID) values(6,'南通市',11)
insert into BJCity(ID,Title,ParentID) values(7,'连云港市',11)
insert into BJCity(ID,Title,ParentID) values(8,'淮安市',11)
insert into BJCity(ID,Title,ParentID) values(9,'盐城市',11)
insert into BJCity(ID,Title,ParentID) values(10,'扬州市',11)
insert into BJCity(ID,Title,ParentID) values(11,'镇江市',11)
insert into BJCity(ID,Title,ParentID) values(12,'泰州市',11)
insert into BJCity(ID,Title,ParentID) values(13,'宿迁市',11)
--12浙江省(2006年，辖：11个地级市；32个市辖区、22个县级市、35个县、1个自治县。)
insert into BJCity(ID,Title,ParentID) values(1,'杭州市',12)
insert into BJCity(ID,Title,ParentID) values(2,'宁波市',12)
insert into BJCity(ID,Title,ParentID) values(3,'温州市',12)
insert into BJCity(ID,Title,ParentID) values(4,'嘉兴市',12)
insert into BJCity(ID,Title,ParentID) values(5,'湖州市',12)
insert into BJCity(ID,Title,ParentID) values(6,'绍兴市',12)
insert into BJCity(ID,Title,ParentID) values(7,'金华市',12)
insert into BJCity(ID,Title,ParentID) values(8,'衢州市',12)
insert into BJCity(ID,Title,ParentID) values(9,'舟山市',12)
insert into BJCity(ID,Title,ParentID) values(10,'台州市',12)
insert into BJCity(ID,Title,ParentID) values(11,'丽水市',12)
--13安徽省(2005年辖：17个地级市；44个市辖区、5县个级市、56个县。)
insert into BJCity(ID,Title,ParentID) values(1,'合肥市',13)
insert into BJCity(ID,Title,ParentID) values(2,'芜湖市',13)
insert into BJCity(ID,Title,ParentID) values(3,'蚌埠市',13)
insert into BJCity(ID,Title,ParentID) values(4,'淮南市',13)
insert into BJCity(ID,Title,ParentID) values(5,'马鞍山市',13)
insert into BJCity(ID,Title,ParentID) values(6,'淮北市',13)
insert into BJCity(ID,Title,ParentID) values(7,'铜陵市',13)
insert into BJCity(ID,Title,ParentID) values(8,'安庆市',13)
insert into BJCity(ID,Title,ParentID) values(9,'黄山市',13)
insert into BJCity(ID,Title,ParentID) values(10,'滁州市',13)
insert into BJCity(ID,Title,ParentID) values(11,'阜阳市',13)
insert into BJCity(ID,Title,ParentID) values(12,'宿州市',13)
insert into BJCity(ID,Title,ParentID) values(13,'巢湖市',13)
insert into BJCity(ID,Title,ParentID) values(14,'六安市',13)
insert into BJCity(ID,Title,ParentID) values(15,'亳州市',13)
insert into BJCity(ID,Title,ParentID) values(16,'池州市',13)
insert into BJCity(ID,Title,ParentID) values(17,'宣城市',13)
--14福建省(2006年辖：9个地级市；26个市辖区、14个县级市、45个县。)
insert into BJCity(ID,Title,ParentID) values(1,'福州市',14)
insert into BJCity(ID,Title,ParentID) values(2,'厦门市',14)
insert into BJCity(ID,Title,ParentID) values(3,'莆田市',14)
insert into BJCity(ID,Title,ParentID) values(4,'三明市',14)
insert into BJCity(ID,Title,ParentID) values(5,'泉州市',14)
insert into BJCity(ID,Title,ParentID) values(6,'漳州市',14)
insert into BJCity(ID,Title,ParentID) values(7,'南平市',14)
insert into BJCity(ID,Title,ParentID) values(8,'龙岩市',14)
insert into BJCity(ID,Title,ParentID) values(9,'宁德市',14)
--15江西省(2006年全省辖：11个地级市；19个市辖区、10个县级市、70个县。)
insert into BJCity(ID,Title,ParentID) values(1,'南昌市',15)
insert into BJCity(ID,Title,ParentID) values(2,'景德镇市',15)
insert into BJCity(ID,Title,ParentID) values(3,'萍乡市',15)
insert into BJCity(ID,Title,ParentID) values(4,'九江市',15)
insert into BJCity(ID,Title,ParentID) values(5,'新余市',15)
insert into BJCity(ID,Title,ParentID) values(6,'鹰潭市',15)
insert into BJCity(ID,Title,ParentID) values(7,'赣州市',15)
insert into BJCity(ID,Title,ParentID) values(8,'吉安市',15)
insert into BJCity(ID,Title,ParentID) values(9,'宜春市',15)
insert into BJCity(ID,Title,ParentID) values(10,'抚州市',15)
insert into BJCity(ID,Title,ParentID) values(11,'上饶市',15)
--16山东省(2005年，辖：17个地级市；49个市辖区、31个县级市、60个县。)
insert into BJCity(ID,Title,ParentID) values(1,'济南市',16)
insert into BJCity(ID,Title,ParentID) values(2,'青岛市',16)
insert into BJCity(ID,Title,ParentID) values(3,'淄博市',16)
insert into BJCity(ID,Title,ParentID) values(4,'枣庄市',16)
insert into BJCity(ID,Title,ParentID) values(5,'东营市',16)
insert into BJCity(ID,Title,ParentID) values(6,'烟台市',16)
insert into BJCity(ID,Title,ParentID) values(7,'潍坊市',16)
insert into BJCity(ID,Title,ParentID) values(8,'济宁市',16)
insert into BJCity(ID,Title,ParentID) values(9,'泰安市',16)
insert into BJCity(ID,Title,ParentID) values(10,'威海市',16)
insert into BJCity(ID,Title,ParentID) values(11,'日照市',16)
insert into BJCity(ID,Title,ParentID) values(12,'莱芜市',16)
insert into BJCity(ID,Title,ParentID) values(13,'临沂市',16)
insert into BJCity(ID,Title,ParentID) values(14,'德州市',16)
insert into BJCity(ID,Title,ParentID) values(15,'聊城市',16)
insert into BJCity(ID,Title,ParentID) values(16,'滨州市',16)
insert into BJCity(ID,Title,ParentID) values(17,'菏泽市',16)
--17河南省（2005年辖：17个地级市；50个市辖区、21个县级市、88个县。）
insert into BJCity(ID,Title,ParentID) values(1,'郑州市',17)
insert into BJCity(ID,Title,ParentID) values(2,'开封市',17)
insert into BJCity(ID,Title,ParentID) values(3,'洛阳市',17)
insert into BJCity(ID,Title,ParentID) values(4,'平顶山市',17)
insert into BJCity(ID,Title,ParentID) values(5,'安阳市',17)
insert into BJCity(ID,Title,ParentID) values(6,'鹤壁市',17)
insert into BJCity(ID,Title,ParentID) values(7,'新乡市',17)
insert into BJCity(ID,Title,ParentID) values(8,'焦作市',17)
insert into BJCity(ID,Title,ParentID) values(9,'濮阳市',17)
insert into BJCity(ID,Title,ParentID) values(10,'许昌市',17)
insert into BJCity(ID,Title,ParentID) values(11,'漯河市',17)
insert into BJCity(ID,Title,ParentID) values(12,'三门峡市',17)
insert into BJCity(ID,Title,ParentID) values(13,'南阳市',17)
insert into BJCity(ID,Title,ParentID) values(14,'商丘市',17)
insert into BJCity(ID,Title,ParentID) values(15,'信阳市',17)
insert into BJCity(ID,Title,ParentID) values(16,'周口市',17)
insert into BJCity(ID,Title,ParentID) values(17,'驻马店市',17)
insert into BJCity(ID,Title,ParentID) values(18,'济源市',17)
--18湖北省（截至2005年12月31日，全省辖13个地级单位（12个地级市、1个自治州）；102县级单位（38个市辖区、24个县级市、37个县、2个自治县、1个林区），共有1220个乡级单位（277个街道、733个镇、210个乡）。）
insert into BJCity(ID,Title,ParentID) values(1,'武汉市',18)
insert into BJCity(ID,Title,ParentID) values(2,'黄石市',18)
insert into BJCity(ID,Title,ParentID) values(3,'十堰市',18)
insert into BJCity(ID,Title,ParentID) values(4,'荆州市',18)
insert into BJCity(ID,Title,ParentID) values(5,'宜昌市',18)
insert into BJCity(ID,Title,ParentID) values(6,'襄樊市',18)
insert into BJCity(ID,Title,ParentID) values(7,'鄂州市',18)
insert into BJCity(ID,Title,ParentID) values(8,'荆门市',18)
insert into BJCity(ID,Title,ParentID) values(9,'孝感市',18)
insert into BJCity(ID,Title,ParentID) values(10,'黄冈市',18)
insert into BJCity(ID,Title,ParentID) values(11,'咸宁市',18)
insert into BJCity(ID,Title,ParentID) values(12,'随州市',18)
insert into BJCity(ID,Title,ParentID) values(13,'仙桃市',18)
insert into BJCity(ID,Title,ParentID) values(14,'天门市',18)
insert into BJCity(ID,Title,ParentID) values(15,'潜江市',18)
insert into BJCity(ID,Title,ParentID) values(16,'神农架林区',18)
insert into BJCity(ID,Title,ParentID) values(17,'恩施土家族苗族自治州',18)
[/code]

Answer 6

--19湖南省（2005年辖：13个地级市、1个自治州；34个市辖区、16个县级市、65个县、7个自治县。）
insert into BJCity(ID,Title,ParentID) values(1,'长沙市',19)
insert into BJCity(ID,Title,ParentID) values(2,'株洲市',19)
insert into BJCity(ID,Title,ParentID) values(3,'湘潭市',19)
insert into BJCity(ID,Title,ParentID) values(4,'衡阳市',19)
insert into BJCity(ID,Title,ParentID) values(5,'邵阳市',19)
insert into BJCity(ID,Title,ParentID) values(6,'岳阳市',19)
insert into BJCity(ID,Title,ParentID) values(7,'常德市',19)
insert into BJCity(ID,Title,ParentID) values(8,'张家界市',19)
insert into BJCity(ID,Title,ParentID) values(9,'益阳市',19)
insert into BJCity(ID,Title,ParentID) values(10,'郴州市',19)
insert into BJCity(ID,Title,ParentID) values(11,'永州市',19)
insert into BJCity(ID,Title,ParentID) values(12,'怀化市',19)
insert into BJCity(ID,Title,ParentID) values(13,'娄底市',19)
insert into BJCity(ID,Title,ParentID) values(14,'湘西土家族苗族自治州',19)
--20广东省（截至2005年12月31日，广东省辖：21个地级市，54个市辖区、23个县级市、41个县、3个自治县，429个街道办事处、1145个镇、4个乡、7个民族乡。）
insert into BJCity(ID,Title,ParentID) values(1,'广州市',20)
insert into BJCity(ID,Title,ParentID) values(2,'深圳市',20)
insert into BJCity(ID,Title,ParentID) values(3,'珠海市',20)
insert into BJCity(ID,Title,ParentID) values(4,'汕头市',20)
insert into BJCity(ID,Title,ParentID) values(5,'韶关市',20)
insert into BJCity(ID,Title,ParentID) values(6,'佛山市',20)
insert into BJCity(ID,Title,ParentID) values(7,'江门市',20)
insert into BJCity(ID,Title,ParentID) values(8,'湛江市',20)
insert into BJCity(ID,Title,ParentID) values(9,'茂名市',20)
insert into BJCity(ID,Title,ParentID) values(10,'肇庆市',20)
insert into BJCity(ID,Title,ParentID) values(11,'惠州市',20)
insert into BJCity(ID,Title,ParentID) values(12,'梅州市',20)
insert into BJCity(ID,Title,ParentID) values(13,'汕尾市',20)
insert into BJCity(ID,Title,ParentID) values(14,'河源市',20)
insert into BJCity(ID,Title,ParentID) values(15,'阳江市',20)
insert into BJCity(ID,Title,ParentID) values(16,'清远市',20)
insert into BJCity(ID,Title,ParentID) values(17,'东莞市',20)
insert into BJCity(ID,Title,ParentID) values(18,'中山市',20)
insert into BJCity(ID,Title,ParentID) values(19,'潮州市',20)
insert into BJCity(ID,Title,ParentID) values(20,'揭阳市',20)
insert into BJCity(ID,Title,ParentID) values(21,'云浮市',20)
--21甘肃省（2006年辖：12个地级市、2个自治州；17个市辖区、4个县级市、58个县、7个自治县。）
insert into BJCity(ID,Title,ParentID) values(1,'兰州市',21)
insert into BJCity(ID,Title,ParentID) values(2,'金昌市',21)
insert into BJCity(ID,Title,ParentID) values(3,'白银市',21)
insert into BJCity(ID,Title,ParentID) values(4,'天水市',21)
insert into BJCity(ID,Title,ParentID) values(5,'嘉峪关市',21)
insert into BJCity(ID,Title,ParentID) values(6,'武威市',21)
insert into BJCity(ID,Title,ParentID) values(7,'张掖市',21)
insert into BJCity(ID,Title,ParentID) values(8,'平凉市',21)
insert into BJCity(ID,Title,ParentID) values(9,'酒泉市',21)
insert into BJCity(ID,Title,ParentID) values(10,'庆阳市',21)
insert into BJCity(ID,Title,ParentID) values(11,'定西市',21)
insert into BJCity(ID,Title,ParentID) values(12,'陇南市',21)
insert into BJCity(ID,Title,ParentID) values(13,'临夏回族自治州',21)
insert into BJCity(ID,Title,ParentID) values(14,'甘南藏族自治州',21)
--22四川省（2006年辖：18个地级市、3个自治州；43个市辖区、14个县级市、120个县、4个自治县。）
insert into BJCity(ID,Title,ParentID) values(1,'成都市',22)
insert into BJCity(ID,Title,ParentID) values(2,'自贡市',22)
insert into BJCity(ID,Title,ParentID) values(3,'攀枝花市',22)
insert into BJCity(ID,Title,ParentID) values(4,'泸州市',22)
insert into BJCity(ID,Title,ParentID) values(5,'德阳市',22)
insert into BJCity(ID,Title,ParentID) values(6,'绵阳市',22)
insert into BJCity(ID,Title,ParentID) values(7,'广元市',22)
insert into BJCity(ID,Title,ParentID) values(8,'遂宁市',22)
insert into BJCity(ID,Title,ParentID) values(9,'内江市',22)
insert into BJCity(ID,Title,ParentID) values(10,'乐山市',22)
insert into BJCity(ID,Title,ParentID) values(11,'南充市',22)
insert into BJCity(ID,Title,ParentID) values(12,'眉山市',22)
insert into BJCity(ID,Title,ParentID) values(13,'宜宾市',22)
insert into BJCity(ID,Title,ParentID) values(14,'广安市',22)
insert into BJCity(ID,Title,ParentID) values(15,'达州市',22)
insert into BJCity(ID,Title,ParentID) values(16,'雅安市',22)
insert into BJCity(ID,Title,ParentID) values(17,'巴中市',22)
insert into BJCity(ID,Title,ParentID) values(18,'资阳市',22)
insert into BJCity(ID,Title,ParentID) values(19,'阿坝藏族羌族自治州',22)
insert into BJCity(ID,Title,ParentID) values(20,'甘孜藏族自治州',22)
insert into BJCity(ID,Title,ParentID) values(21,'凉山彝族自治州',22)
/**//****************************************
--23山东省(2005年，辖：17个地级市；49个市辖区、31个县级市、60个县。)
insert into BJCity(ID,Title,ParentID) values(1,'济南市',16)
insert into BJCity(ID,Title,ParentID) values(2,'青岛市',16)
insert into BJCity(ID,Title,ParentID) values(3,'淄博市',16)
insert into BJCity(ID,Title,ParentID) values(4,'枣庄市',16)
insert into BJCity(ID,Title,ParentID) values(5,'东营市',16)
insert into BJCity(ID,Title,ParentID) values(6,'烟台市',16)
insert into BJCity(ID,Title,ParentID) values(7,'潍坊市',16)
insert into BJCity(ID,Title,ParentID) values(8,'济宁市',16)
insert into BJCity(ID,Title,ParentID) values(9,'泰安市',16)
insert into BJCity(ID,Title,ParentID) values(10,'威海市',16)
insert into BJCity(ID,Title,ParentID) values(11,'日照市',16)
insert into BJCity(ID,Title,ParentID) values(12,'莱芜市',16)
insert into BJCity(ID,Title,ParentID) values(13,'临沂市',16)
insert into BJCity(ID,Title,ParentID) values(14,'德州市',16)
insert into BJCity(ID,Title,ParentID) values(15,'聊城市',16)
insert into BJCity(ID,Title,ParentID) values(16,'滨州市',16)
insert into BJCity(ID,Title,ParentID) values(17,'菏泽市',16)
*************************************/
--24贵州省(2006年辖：4个地级市、2个地区、3个自治州；10个市辖区、9个县级市、56个县、11个自治县、2个特区。)
insert into BJCity(ID,Title,ParentID) values(1,'贵阳市',24)
insert into BJCity(ID,Title,ParentID) values(2,'六盘水市',24)
insert into BJCity(ID,Title,ParentID) values(3,'遵义市',24)
insert into BJCity(ID,Title,ParentID) values(4,'安顺市',24)
insert into BJCity(ID,Title,ParentID) values(5,'铜仁地区',24)
insert into BJCity(ID,Title,ParentID) values(6,'毕节地区',24)
insert into BJCity(ID,Title,ParentID) values(7,'黔西南布依族苗族自治州',24)
insert into BJCity(ID,Title,ParentID) values(8,'黔东南苗族侗族自治州',24)
insert into BJCity(ID,Title,ParentID) values(9,'黔南布依族苗族自治州',24)
--25海南省(2003－2005年　全省有2个地级市，6个县级市，4个县，6个民族自治县，4个市辖区，1个办事处（西南中沙群岛办事处，县级）。)
insert into BJCity(ID,Title,ParentID) values(1,'海口市',25)
insert into BJCity(ID,Title,ParentID) values(2,'三亚市',25)
insert into BJCity(ID,Title,ParentID) values(3,'五指山市',25)
insert into BJCity(ID,Title,ParentID) values(4,'琼海市',25)
insert into BJCity(ID,Title,ParentID) values(5,'儋州市',25)
insert into BJCity(ID,Title,ParentID) values(6,'文昌市',25)
insert into BJCity(ID,Title,ParentID) values(7,'万宁市',25)
insert into BJCity(ID,Title,ParentID) values(8,'东方市',25)
insert into BJCity(ID,Title,ParentID) values(9,'澄迈县',25)
insert into BJCity(ID,Title,ParentID) values(10,'定安县',25)
insert into BJCity(ID,Title,ParentID) values(11,'屯昌县',25)
insert into BJCity(ID,Title,ParentID) values(12,'临高县',25)
insert into BJCity(ID,Title,ParentID) values(13,'白沙黎族自治县',25)
insert into BJCity(ID,Title,ParentID) values(14,'昌江黎族自治县',25)
insert into BJCity(ID,Title,ParentID) values(15,'乐东黎族自治县',25)
insert into BJCity(ID,Title,ParentID) values(16,'陵水黎族自治县',25)
insert into BJCity(ID,Title,ParentID) values(17,'保亭黎族苗族自治县',25)
insert into BJCity(ID,Title,ParentID) values(18,'琼中黎族苗族自治县',25)

Answer 7

--26云南省(2006年辖：8个地级市、8个自治州；12个市辖区、9个县级市、79个县、29个自治县。)
insert into BJCity(ID,Title,ParentID) values(1,'昆明市',26)
insert into BJCity(ID,Title,ParentID) values(2,'曲靖市',26)
insert into BJCity(ID,Title,ParentID) values(3,'玉溪市',26)
insert into BJCity(ID,Title,ParentID) values(4,'保山市',26)
insert into BJCity(ID,Title,ParentID) values(5,'昭通市',26)
insert into BJCity(ID,Title,ParentID) values(6,'丽江市',26)
insert into BJCity(ID,Title,ParentID) values(7,'思茅市',26)
insert into BJCity(ID,Title,ParentID) values(8,'临沧市',26)
insert into BJCity(ID,Title,ParentID) values(9,'文山壮族苗族自治州',26)
insert into BJCity(ID,Title,ParentID) values(10,'红河哈尼族彝族自治州',26)
insert into BJCity(ID,Title,ParentID) values(11,'西双版纳傣族自治州',26)
insert into BJCity(ID,Title,ParentID) values(12,'楚雄彝族自治州',26)
insert into BJCity(ID,Title,ParentID) values(13,'大理白族自治州',26)
insert into BJCity(ID,Title,ParentID) values(14,'德宏傣族景颇族自治州',26)
insert into BJCity(ID,Title,ParentID) values(15,'怒江傈傈族自治州',26)
insert into BJCity(ID,Title,ParentID) values(16,'迪庆藏族自治州',26)
--27青海省(2006年辖：1个地级市、1个地区、6个自治州；4个市辖区、2个县级市、30个县、7个自治县。)
insert into BJCity(ID,Title,ParentID) values(1,'西宁市',27)
insert into BJCity(ID,Title,ParentID) values(2,'海东地区',27)
insert into BJCity(ID,Title,ParentID) values(3,'海北藏族自治州',27)
insert into BJCity(ID,Title,ParentID) values(4,'黄南藏族自治州',27)
insert into BJCity(ID,Title,ParentID) values(5,'海南藏族自治州',27)
insert into BJCity(ID,Title,ParentID) values(6,'果洛藏族自治州',27)
insert into BJCity(ID,Title,ParentID) values(7,'玉树藏族自治州',27)
insert into BJCity(ID,Title,ParentID) values(8,'海西蒙古族藏族自治州',27)
--28陕西省(2006年辖：10个地级市；24个市辖区、3个县级市、80个县。)
insert into BJCity(ID,Title,ParentID) values(1,'西安市',28)
insert into BJCity(ID,Title,ParentID) values(2,'铜川市',28)
insert into BJCity(ID,Title,ParentID) values(3,'宝鸡市',28)
insert into BJCity(ID,Title,ParentID) values(4,'咸阳市',28)
insert into BJCity(ID,Title,ParentID) values(5,'渭南市',28)
insert into BJCity(ID,Title,ParentID) values(6,'延安市',28)
insert into BJCity(ID,Title,ParentID) values(7,'汉中市',28)
insert into BJCity(ID,Title,ParentID) values(8,'榆林市',28)
insert into BJCity(ID,Title,ParentID) values(9,'安康市',28)
insert into BJCity(ID,Title,ParentID) values(10,'商洛市',28)
--29广西壮族自治区(2005年辖：14个地级市；34个市辖区、7个县级市、56个县、12个自治县。)
insert into BJCity(ID,Title,ParentID) values(1,'南宁市',29)
insert into BJCity(ID,Title,ParentID) values(2,'柳州市',29)
insert into BJCity(ID,Title,ParentID) values(3,'桂林市',29)
insert into BJCity(ID,Title,ParentID) values(4,'梧州市',29)
insert into BJCity(ID,Title,ParentID) values(5,'北海市',29)
insert into BJCity(ID,Title,ParentID) values(6,'防城港市',29)
insert into BJCity(ID,Title,ParentID) values(7,'钦州市',29)
insert into BJCity(ID,Title,ParentID) values(8,'贵港市',29)
insert into BJCity(ID,Title,ParentID) values(9,'玉林市',29)
insert into BJCity(ID,Title,ParentID) values(10,'百色市',29)
insert into BJCity(ID,Title,ParentID) values(11,'贺州市',29)
insert into BJCity(ID,Title,ParentID) values(12,'河池市',29)
insert into BJCity(ID,Title,ParentID) values(13,'来宾市',29)
insert into BJCity(ID,Title,ParentID) values(14,'崇左市',29)
--30西藏自治区(2005年辖：1个地级市、6个地区；1个市辖区、1个县级市、71个县。)
insert into BJCity(ID,Title,ParentID) values(1,'拉萨市',30)
insert into BJCity(ID,Title,ParentID) values(2,'那曲地区',30)
insert into BJCity(ID,Title,ParentID) values(3,'昌都地区',30)
insert into BJCity(ID,Title,ParentID) values(4,'山南地区',30)
insert into BJCity(ID,Title,ParentID) values(5,'日喀则地区',30)
insert into BJCity(ID,Title,ParentID) values(6,'阿里地区',30)
insert into BJCity(ID,Title,ParentID) values(7,'林芝地区',30)
--31宁夏回族自治区
insert into BJCity(ID,Title,ParentID) values(1,'银川市',31)
insert into BJCity(ID,Title,ParentID) values(2,'石嘴山市',31)
insert into BJCity(ID,Title,ParentID) values(3,'吴忠市',31)
insert into BJCity(ID,Title,ParentID) values(4,'固原市',31)
insert into BJCity(ID,Title,ParentID) values(5,'中卫市',31)
--32新疆维吾尔自治区(2005年辖：2个地级市、7个地区、5个自治州；11个市辖区、20个县级市、62个县、6个自治县)
insert into BJCity(ID,Title,ParentID) values(1,'乌鲁木齐市',32)
insert into BJCity(ID,Title,ParentID) values(2,'克拉玛依市',32)
insert into BJCity(ID,Title,ParentID) values(3,'石河子市　',32)
insert into BJCity(ID,Title,ParentID) values(4,'阿拉尔市',32)
insert into BJCity(ID,Title,ParentID) values(5,'图木舒克市',32)
insert into BJCity(ID,Title,ParentID) values(6,'五家渠市',32)
insert into BJCity(ID,Title,ParentID) values(7,'吐鲁番市',32)
insert into BJCity(ID,Title,ParentID) values(8,'阿克苏市',32)
insert into BJCity(ID,Title,ParentID) values(9,'喀什市',32)
insert into BJCity(ID,Title,ParentID) values(10,'哈密市',32)
insert into BJCity(ID,Title,ParentID) values(11,'和田市',32)
insert into BJCity(ID,Title,ParentID) values(12,'阿图什市',32)
insert into BJCity(ID,Title,ParentID) values(13,'库尔勒市',32)
insert into BJCity(ID,Title,ParentID) values(14,'昌吉市　',32)
insert into BJCity(ID,Title,ParentID) values(15,'阜康市',32)
insert into BJCity(ID,Title,ParentID) values(16,'米泉市',32)
insert into BJCity(ID,Title,ParentID) values(17,'博乐市',32)
insert into BJCity(ID,Title,ParentID) values(18,'伊宁市',32)
insert into BJCity(ID,Title,ParentID) values(19,'奎屯市',32)
insert into BJCity(ID,Title,ParentID) values(20,'塔城市',32)
insert into BJCity(ID,Title,ParentID) values(21,'乌苏市',32)
insert into BJCity(ID,Title,ParentID) values(22,'阿勒泰市',32)
--33内蒙古自治区(2006年，辖：9个地级市、3个盟；21个市辖区、11个县级市、17个县、49个旗、3个自治旗。)
insert into BJCity(ID,Title,ParentID) values(1,'呼和浩特市',33)
insert into BJCity(ID,Title,ParentID) values(2,'包头市',33)
insert into BJCity(ID,Title,ParentID) values(3,'乌海市',33)
insert into BJCity(ID,Title,ParentID) values(4,'赤峰市',33)
insert into BJCity(ID,Title,ParentID) values(5,'通辽市',33)
insert into BJCity(ID,Title,ParentID) values(6,'鄂尔多斯市',33)
insert into BJCity(ID,Title,ParentID) values(7,'呼伦贝尔市',33)
insert into BJCity(ID,Title,ParentID) values(8,'巴彦淖尔市',33)
insert into BJCity(ID,Title,ParentID) values(9,'乌兰察布市',33)
insert into BJCity(ID,Title,ParentID) values(10,'锡林郭勒盟',33)
insert into BJCity(ID,Title,ParentID) values(11,'兴安盟',33)
insert into BJCity(ID,Title,ParentID) values(12,'阿拉善盟',33)
--34澳门特别行政区
insert into BJCity(ID,Title,ParentID) values(1,'澳门特别行政区',34)
--35香港特别行政区
insert into BJCity(ID,Title,ParentID) values(1,'香港特别行政区',35)

Answer 8

上面的是sql版本的下面是javascriptjavascript版：
<script language="JavaScript">
<!--
var g_selProvince;
var g_selCity;
var Provinces=new Array(
new Array("110000","北京市"),
new Array("120000","天津市"),
new Array("130000","河北省"),
new Array("140000","山西省"),
new Array("150000","内蒙古自治区"),
new Array("210000","辽宁省"),
new Array("220000","吉林省"),
new Array("230000","黑龙江省"),
new Array("310000","上海市"),
new Array("320000","江苏省"),
new Array("330000","浙江省"),
new Array("340000","安徽省"),
new Array("350000","福建省"),
new Array("360000","江西省"),
new Array("370000","山东省"),
new Array("410000","河南省"),
new Array("420000","湖北省"),
new Array("430000","湖南省"),
new Array("440000","广东省"),
new Array("450000","广西壮族自治区"),
new Array("460000","海南省"),
new Array("500000","重庆市"),
new Array("510000","四川省"),
new Array("520000","贵州省"),
new Array("530000","云南省"),
new Array("540000","西藏自治区"),
new Array("610000","陕西省"),
new Array("620000","甘肃省"),
new Array("630000","青海省"),
new Array("640000","宁夏回族自治区"),
new Array("650000","新疆维吾尔自治区"),
new Array("710000","台湾省"),
new Array("810000","香港特别行政区"),
new Array("820000","澳门特别行政区")
);var Citys=new Array(
new Array("110100","北京"),
new Array("120100","天津"),
new Array("130101","石家庄"),
new Array("130201","唐山"),
new Array("130301","秦皇岛"),
new Array("130701","张家口"),
new Array("130801","承德"),
new Array("131001","廊坊"),
new Array("130401","邯郸"),
new Array("130501","邢台"),
new Array("130601","保定"),
new Array("130901","沧州"),
new Array("133001","衡水"),
new Array("140101","太原"),
new Array("140201","大同"),
new Array("140301","阳泉"),
new Array("140501","晋城"),
new Array("140601","朔州"),
new Array("142201","忻州"),
new Array("142331","离石"),
new Array("142401","榆次"),
new Array("142601","临汾"),
new Array("142701","运城"),
new Array("140401","长治"),
new Array("150101","呼和浩特"),
new Array("150201","包头"),
new Array("150301","乌海"),
new Array("152601","集宁"),
new Array("152701","东胜"),
new Array("152801","临河"),
new Array("152921","阿拉善左旗"),
new Array("150401","赤峰"),
new Array("152301","通辽"),
new Array("152502","锡林浩特"),
new Array("152101","海拉尔"),
new Array("152201","乌兰浩特"),
new Array("210101","沈阳"),
new Array("210201","大连"),
new Array("210301","鞍山"),
new Array("210401","抚顺"),
new Array("210501","本溪"),
new Array("210701","锦州"),
new Array("210801","营口"),
new Array("210901","阜新"),
new Array("211101","盘锦"),
new Array("211201","铁岭"),
new Array("211301","朝阳"),
new Array("211401","锦西"),
new Array("210601","丹东"),
new Array("220101","长春"),
new Array("220201","吉林"),
new Array("220301","四平"),
new Array("220401","辽源"),
new Array("220601","浑江"),
new Array("222301","白城"),
new Array("222401","延吉"),
new Array("220501","通化"),
new Array("230101","哈尔滨"),
new Array("230301","鸡西"),
new Array("230401","鹤岗"),
new Array("230501","双鸭山"),
new Array("230701","伊春"),
new Array("230801","佳木斯"),
new Array("230901","七台河"),
new Array("231001","牡丹江"),
new Array("232301","绥化"),
new Array("230201","齐齐哈尔"),
new Array("230601","大庆"),
new Array("232601","黑河"),
new Array("232700","加格达奇"),
new Array("310100","上海"),
new Array("320101","南京"),
new Array("320201","无锡"),
new Array("320301","徐州"),
new Array("320401","常州"),
new Array("320501","苏州"),
new Array("320600","南通"),
new Array("320701","连云港"),
new Array("320801","淮阴"),
new Array("320901","盐城"),
new Array("321001","扬州"),
new Array("321101","镇江"),
new Array("330101","杭州"),
new Array("330201","宁波"),
new Array("330301","温州"),
new Array("330401","嘉兴"),
new Array("330501","湖州"),
new Array("330601","绍兴"),
new Array("330701","金华"),
new Array("330801","衢州"),
new Array("330901","舟山"),
new Array("332501","丽水"),
new Array("332602","临海"),
new Array("340101","合肥"),
new Array("340201","芜湖"),
new Array("340301","蚌埠"),
new Array("340401","淮南"),
new Array("340501","马鞍山"),
new Array("340601","淮北"),
new Array("340701","铜陵"),
new Array("340801","安庆"),
new Array("341001","黄山"),
new Array("342101","阜阳"),
new Array("342201","宿州"),
new Array("342301","滁州"),
new Array("342401","六安"),
new Array("342501","宣州"),
new Array("342601","巢湖"),
new Array("342901","贵池"),
new Array("350101","福州"),
new Array("350201","厦门"),
new Array("350301","莆田"),
new Array("350401","三明"),
new Array("350501","泉州"),
new Array("350601","漳州"),
new Array("352101","南平"),
new Array("352201","宁德"),
new Array("352601","龙岩"),
new Array("360101","南昌"),
new Array("360201","景德镇"),
new Array("362101","赣州"),
new Array("360301","萍乡"),
new Array("360401","九江"),
new Array("360501","新余"),
new Array("360601","鹰潭"),
new Array("362201","宜春"),
new Array("362301","上饶"),
new Array("362401","吉安"),
new Array("362502","临川"),
new Array("370101","济南"),
new Array("370201","青岛"),
new Array("370301","淄博"),
new Array("370401","枣庄"),
new Array("370501","东营"),
new Array("370601","烟台"),
new Array("370701","潍坊"),
new Array("370801","济宁"),
new Array("370901","泰安"),
new Array("371001","威海"),
new Array("371100","日照"),
new Array("372301","滨州"),
new Array("372401","德州"),
new Array("372501","聊城"),
new Array("372801","临沂"),
new Array("372901","菏泽"),
new Array("410101","郑州"),
new Array("410201","开封"),
new Array("410301","洛阳"),
new Array("410401","平顶山"),
new Array("410501","安阳"),
new Array("410601","鹤壁"),
new Array("410701","新乡"),
new Array("410801","焦作"),

Answer 9

new Array("410901","濮阳"),
new Array("411001","许昌"),
new Array("411101","漯河"),
new Array("411201","三门峡"),
new Array("412301","商丘"),
new Array("412701","周口"),
new Array("412801","驻马店"),
new Array("412901","南阳"),
new Array("413001","信阳"),
new Array("420101","武汉"),
new Array("420201","黄石"),
new Array("420301","十堰"),
new Array("420400","沙市"),
new Array("420501","宜昌"),
new Array("420601","襄樊"),
new Array("420701","鄂州"),
new Array("420801","荆门"),
new Array("422103","黄州"),
new Array("422201","孝感"),
new Array("422301","咸宁"),
new Array("422421","江陵"),
new Array("422801","恩施"),
new Array("430101","长沙"),
new Array("430401","衡阳"),
new Array("430501","邵阳"),
new Array("432801","郴州"),
new Array("432901","永州"),
new Array("430801","大庸"),
new Array("433001","怀化"),
new Array("433101","吉首"),
new Array("430201","株洲"),
new Array("430301","湘潭"),
new Array("430601","岳阳"),
new Array("430701","常德"),
new Array("432301","益阳"),
new Array("432501","娄底"),
new Array("440101","广州"),
new Array("440301","深圳"),
new Array("441501","汕尾"),
new Array("441301","惠州"),
new Array("441601","河源"),
new Array("440601","佛山"),
new Array("441801","清远"),
new Array("441901","东莞"),
new Array("440401","珠海"),
new Array("440701","江门"),
new Array("441201","肇庆"),
new Array("442001","中山"),
new Array("440801","湛江"),
new Array("440901","茂名"),
new Array("440201","韶关"),
new Array("440501","汕头"),
new Array("441401","梅州"),
new Array("441701","阳江"),
new Array("450101","南宁"),
new Array("450401","梧州"),
new Array("452501","玉林"),
new Array("450301","桂林"),
new Array("452601","百色"),
new Array("452701","河池"),
new Array("452802","钦州"),
new Array("450201","柳州"),
new Array("450501","北海"),
new Array("460100","海口"),
new Array("460200","三亚"),
new Array("510101","成都"),
new Array("513321","康定"),
new Array("513101","雅安"),
new Array("513229","马尔康"),
new Array("510301","自贡"),
new Array("500100","重庆"),
new Array("512901","南充"),
new Array("510501","泸州"),
new Array("510601","德阳"),
new Array("510701","绵阳"),
new Array("510901","遂宁"),
new Array("511001","内江"),
new Array("511101","乐山"),
new Array("512501","宜宾"),
new Array("510801","广元"),
new Array("513021","达县"),
new Array("513401","西昌"),
new Array("510401","攀枝花"),
new Array("500239","黔江土家族苗族自治县"),
new Array("520101","贵阳"),
new Array("520200","六盘水"),
new Array("522201","铜仁"),
new Array("522501","安顺"),
new Array("522601","凯里"),
new Array("522701","都匀"),
new Array("522301","兴义"),
new Array("522421","毕节"),
new Array("522101","遵义"),
new Array("530101","昆明"),
new Array("530201","东川"),
new Array("532201","曲靖"),
new Array("532301","楚雄"),
new Array("532401","玉溪"),
new Array("532501","个旧"),
new Array("532621","文山"),
new Array("532721","思茅"),
new Array("532101","昭通"),
new Array("532821","景洪"),
new Array("532901","大理"),
new Array("533001","保山"),
new Array("533121","潞西"),
new Array("533221","丽江纳西族自治县"),
new Array("533321","泸水"),
new Array("533421","中甸"),
new Array("533521","临沧"),
new Array("540101","拉萨"),
new Array("542121","昌都"),
new Array("542221","乃东"),
new Array("542301","日喀则"),
new Array("542421","那曲"),
new Array("542523","噶尔"),
new Array("542621","林芝"),
new Array("610101","西安"),
new Array("610201","铜川"),
new Array("610301","宝鸡"),
new Array("610401","咸阳"),
new Array("612101","渭南"),
new Array("612301","汉中"),
new Array("612401","安康"),
new Array("612501","商州"),
new Array("612601","延安"),
new Array("612701","榆林"),
new Array("620101","兰州"),
new Array("620401","白银"),
new Array("620301","金昌"),
new Array("620501","天水"),
new Array("622201","张掖"),
new Array("622301","武威"),
new Array("622421","定西"),
new Array("622624","成县"),
new Array("622701","平凉"),
new Array("622801","西峰"),
new Array("622901","临夏"),
new Array("623027","夏河"),
new Array("620201","嘉峪关"),
new Array("622102","酒泉"),
new Array("630100","西宁"),
new Array("632121","平安"),
new Array("632221","门源回族自治县"),
new Array("632321","同仁"),
new Array("632521","共和"),
new Array("632621","玛沁"),
new Array("632721","玉树"),
new Array("632802","德令哈"),
new Array("640101","银川"),
new Array("640201","石嘴山"),
new Array("642101","吴忠"),
new Array("642221","固原"),
new Array("650101","乌鲁木齐"),
new Array("650201","克拉玛依"),
new Array("652101","吐鲁番"),
new Array("652201","哈密"),
new Array("652301","昌吉"),
new Array("652701","博乐"),
new Array("652801","库尔勒"),
new Array("652901","阿克苏"),
new Array("653001","阿图什"),
new Array("653101","喀什"),
new Array("654101","伊宁"),
new Array("710001","台北"),
new Array("710002","基隆"),
new Array("710020","台南"),
new Array("710019","高雄"),
new Array("710008","台中"),
new Array("211001","辽阳"),
new Array("653201","和田"),
new Array("542200","泽当镇"),
new Array("542600","八一镇"),
new Array("820000","澳门"),
new Array("810000","香港")
);function FillProvinces(selProvince)
{
    selProvince.options[0]=new Option("请选择","000000");
    for(i=0;i<Provinces.length;i++)
    {
        selProvince.options[i+1]=new Option(Provinces[i][1],Provinces[i][0]);
    }
    selProvince.options[0].selected=true;
    selProvince.length=i+1;
}function FillCitys(selCity,ProvinceCode)
{
    //if the province is a direct-managed city, like Beijing, shanghai, tianjin, chongqin,hongkong, macro
        //need not "请选择选项"
        if(ProvinceCode=="110000"||ProvinceCode=="120000"||ProvinceCode=="310000"
                 ||ProvinceCode=="810000"||ProvinceCode=="820000"||ProvinceCode=="500000")
             count=0;
        else
                {selCity.options[0]=new Option("请选择",ProvinceCode);
                count=1;}
    for(i=0;i<Citys.length;i++)
    {
        if(Citys[i][0].toString().substring(0,2)==ProvinceCode.substring(0,2))
        {
            selCity.options[count]=new Option(Citys[i][1],Citys[i][0]);
            count=count+1;
        }
    }
    selCity.options[0].selected=true;
    selCity.length=count;
}function Province_onchange()
{
    FillCitys(g_selCity,g_selProvince.value);
}function InitCitySelect(selProvince,selCity)
{
    //alert("begin");
    g_selProvince=selProvince;
    g_selCity=selCity;
    selProvince.onchange=Function("Province_onchange();");
    FillProvinces(selProvince);
    Province_onchange();
}
function InitCitySelect2(selProvince,selCity,CityCode)
{
    InitCitySelect(selProvince,selCity)
    for(i=0;i<selProvince.length;i++)
    {
        if(selProvince.options[i].value.substring(0,2)==CityCode.substring(0,2))
        {
            selProvince.options[i].selected=true;
        }
    }
    Province_onchange();
    for(i=0;i<selCity.length;i++)
    {
        if(selCity.options[i].value==CityCode)
        {
            selCity.options[i].selected=true;
        }
    }
}
//-->
</script>
<form name="profile" method="post">
<select id="province" size="1" name="province">
    <option selected></option>
</select>
<select id="city" size="1" name="city">
    <option selected></option>
</select>
<script language="javascript">
InitCitySelect(document.profile.province,document.profile.city);
</script>
<input type="submit">
</form>

Answer 10

12以上写的是sql版本的
12-13楼是javascript版本的自己选啊