省市二级联动数据库生成代码（JAVA） - JAVA

System.out.println(sb.toString());
}

//获取当前省下所有市区，迭代方法与上面类似，请注意这里面的循环比较多，请大家注意分辨。
List> cities = proviceEntry.getValue();

Iterator> citiesIt = cities.iterator();
long cityId = provinceId;//市的ID直接从省的ID开始递增，每次递增50
while (citiesIt.hasNext()) {
Map city = citiesIt.next();
Set> cityEntries = city.entrySet();
Iterator> cityIt = cityEntries.iterator();
cityId += 50;//市的ID，先递增50，避免与省份ID相同
while(cityIt.hasNext()) {
Entry cityEntry = cityIt.next();
String cityName = cityEntry.getKey();
String cityPinYin = cityEntry.getValue();

StringBuilder sb = new StringBuilder();
sb.append("insert into city values ('");
sb.append(cityId).append("','").append("2','").append(provinceId).append("','").append(cityName).append("', '").append(cityPinYin).append("');");
System.out.println(sb.toString());
}
}
//省份ID以10000递增
provinceId += 10000;
}

}

}
生成的sql语句为：

[sql]
insert into city values ('1000000','1','','北京', 'BJ');
insert into city values ('1000050','2','1000000','东城', 'DC');
insert into city values ('1000100','2','1000000','西城', 'XC');
insert into city values ('1000150','2','1000000','朝阳', 'CY');
insert into city values ('1000200','2','1000000','丰台', 'FT');
insert into city values ('1000250','2','1000000','石景山', 'SJS');
insert into city values ('1000300','2','1000000','海淀', 'HD');
insert into city values ('1000350','2','1000000','门头沟', 'MTG');
insert into city values ('1000400','2','1000000','房山', 'FS');
insert into city values ('1000450','2','1000000','通州', 'TZ');
insert into city values ('1000500','2','1000000','顺义', 'SY');
insert into city values ('1000550','2','1000000','昌平', 'CP');
insert into city values ('1000600','2','1000000','大兴', 'DX');
insert into city values ('1000650','2','1000000','怀柔', 'HR');
insert into city values ('1000700','2','1000000','平谷', 'PG');
insert into city values ('1000750','2','1000000','密云县', 'MYX');
insert into city values ('1000800','2','1000000','延庆县', 'YQX');
insert into city values ('1010000','1','','天津', 'TJ');
insert into city values ('1010050','2','1010000','和平', 'HP');
insert into city values ('1010100','2','1010000','河东', 'HD');
insert into city values ('1010150','2','1010000','河西', 'HX');
insert into city values ('1010200','2','1010000','南开', 'NK');
insert into city values ('1010250','2','1010000','河北', 'HB');
insert into city values ('1010300','2','1010000','红桥', 'HQ');
insert into city values ('1010350','2','1010000','东丽', 'DL');
insert into city values ('1010400','2','1010000','西青', 'XQ');
insert into city values ('1010450','2','1010000','津南', 'JN');
insert into city values ('1010500','2','1010000','北辰', 'BC');
insert into city values ('1010550','2','1010000','武清', 'WQ');
insert into city values ('1010600','2','1010000','宝坻', 'BC');
insert into city values ('1010650','2','1010000','滨海', 'BH');
insert into city values ('

省市二级联动数据库生成代码（JAVA）(四)