databaseinit.java

基于struts+hibernate的电子商务网站。可运行。数据库mysql

							{"方山县","汾阳市","交城县","交口县","离石市","临县","柳林县","石楼县","文水县","孝义市","兴县","中阳县","岚县"},
							{"怀仁县","山阴县","朔州市","应县","右玉县"},
							{"古交市","娄烦县","清徐县","太原市","阳曲县"},
							{"保德县","代县","定襄县","繁峙县","河曲县","静乐县","宁武县","偏关县","神池县","五台县","五寨县","忻州市","原平市","岢岚县"},
							{"平定县","阳泉市","盂县"},
							{"河津市","临猗县","平陆县","万荣县","闻喜县","夏县","新绛县","永济市","垣曲县","运城市","芮城县","绛县","稷山县"}},
							
						   {{"安康市","白河县","汉阴县","宁陕县","平利县","石泉县","旬阳县","镇坪县","紫阳县","岚皋县"},
							{"宝鸡市","宝鸡县","凤县","凤翔县","扶风县","陇县","眉县","千阳县","太白县","岐山县","麟游县"},
							{"城固县","佛坪县","汉中市","留坝县","略阳县","勉县","南郑县","宁强县","西乡县","洋县","镇巴县"},
							{"丹凤县","洛南县","山阳县","商洛市","商南县","镇安县","柞水县"},
							{"铜川市","宜君县"},
							{"白水县","澄城县","大荔县","富平县","韩城市","合阳县","华县","华阴市","蒲城县","渭南市","潼关县"},
							{"高陵县","户县","蓝田县","西安市","周至县"},
							{"彬县","长武县","淳化县","礼泉县","乾县","三原县","武功县","咸阳市","兴平市","旬邑县","永寿县","泾阳县"},
							{"安塞县","富县","甘泉县","黄陵县","黄龙县","洛川县","吴旗县","延安市","延长县","延川县","宜川县","志丹县","子长县"},
							{"定边县","府谷县","横山县","佳县","靖边县","米脂县","清涧县","神木县","绥德县","吴堡县","榆林市","子洲县"}},
							
						   {{"崇明县","上海市"}},
						   
						   {{"阿坝县","黑水县","红原县","金川县","九寨沟县","理县","马尔康县","茂县","壤塘县","若尔盖县","松潘县","小金县","汶川县"},
							{"巴中市","南江县","平昌县","通江县"},
							{"成都市","崇州市","大邑县","都江堰市","金堂县","彭州市","蒲江县","双流县","新津县","邛崃市","郫县"},
							{"达县","达州市","大竹县","开江县","渠县","万源市","宣汉县"},
							{"德阳市","广汉市","罗江县","绵竹市","什邡市","中江县"},
							{"巴塘县","白玉县","丹巴县","稻城县","道孚县","德格县","得荣县","甘孜县","九龙县","康定县","理塘县","炉霍县","色达县","石渠县","乡城县","新龙县","雅江县","泸定县"},
							{"广安市","华蓥市","邻水县","武胜县","岳池县"},
							{"苍溪县","广元市","剑阁县","青川县","旺苍县"},
							{"峨边彝族自治县","峨眉山市","夹江县","井研县","乐山市","马边彝族自治县","沐川县","犍为县"},
							{"布拖县","德昌县","甘洛县","会东县","会理县","金阳县","雷波县","美姑县","冕宁县","木里藏族自治县","宁南县","普格县","西昌市","喜德县","盐源县","越西县","昭觉县"},
							{"丹棱县","洪雅县","眉山市","彭山县","青神县","仁寿县"},
							{"安县","北川县","江油市","绵阳市","平武县","三台县","盐亭县","梓潼县"},
							{"南部县","南充市","蓬安县","西充县","仪陇县","营山县","阆中市"},
							{"隆昌县","内江市","威远县","资中县"},
							{"米易县","攀枝花市","盐边县"},
							{"大英县","蓬溪县","射洪县","遂宁市"},
							{"宝兴县","汉源县","芦山县","名山县","石棉县","天全县","雅安市","荥经县"},
							{"长宁县","高县","江安县","南溪县","屏山县","兴文县","宜宾市","宜宾县","珙县","筠连县"},
							{"安岳县","简阳市","乐至县","资阳市"},
							{"富顺县","荣县","自贡市"},
							{"古蔺县","合江县","叙永县","泸县","泸州市"}},
							
						   {{"蓟县","静海县","宁河县","天津市"}},
						   
						   {{"措勤县","噶尔县","改则县","革吉县","普兰县","日土县","札达县"},
							{"八宿县","边坝县","察雅县","昌都县","丁青县","贡觉县","江达县","类乌齐县","洛隆县","芒康县","左贡县"},
							{"达孜县","当雄县","堆龙德庆县","拉萨市","林周县","墨竹工卡县","尼木县","曲水县"},
							{"波密县","察隅县","工布江达县","朗县","林芝县","米林县","墨脱县"},
							{"安多县","巴青县","班戈县","比如县","嘉黎县","那曲县","尼玛县","聂荣县","申扎县","索县"},
							{"昂仁县","白朗县","定结县","定日县","岗巴县","吉隆县","江孜县","康马县","拉孜县","南木林县","聂拉木县","仁布县","日喀则市","萨嘎县","萨迦县","谢通门县","亚东县","仲巴县"},
							{"措美县","错那县","贡嘎县","加查县","浪卡子县","隆子县","洛扎县","乃东县","琼结县","曲松县","桑日县","扎囊县"}},
							
						   {{"阿克苏市","阿瓦提县","拜城县","柯坪县","库车县","沙雅县","温宿县","乌什县","新和县"},
							{"阿拉尔市"},
							{"博湖县","和静县","和硕县","库尔勒市","轮台县","且末县","若羌县","尉犁县","焉耆回族自治县"},
							{"博乐市","精河县","温泉县"},
							{"昌吉市","阜康市","呼图壁县","吉木萨尔县","玛纳斯县","米泉市","木垒哈萨克自治县","奇台县"},
							{"巴里坤哈萨克自治县","哈密市","伊吾县"},
							{"策勒县","和田市","和田县","洛浦县","民丰县","墨玉县","皮山县","于田县"},
							{"巴楚县","喀什市","麦盖提县","莎车县","疏附县","疏勒县","塔什库尔干塔吉克自治县","叶城县","英吉沙县","岳普湖县","泽普县","伽师县"},
							{"克拉玛依市"},
							{"阿合奇县","阿克陶县","阿图什市","乌恰县"},
							{"石河子市"},
							{"图木舒克市"},
							{"吐鲁番市","托克逊县","鄯善县"},
							{"乌鲁木齐市","乌鲁木齐县"},
							{"五家渠市"},
							{"阿勒泰市","布尔津县","察布查尔锡伯自治县","额敏县","福海县","富蕴县","巩留县","哈巴河县","和布克赛尔蒙古自治县","霍城县","吉木乃县","奎屯市","尼勒克县","青河县","沙湾县","塔城市","特克斯县","托里县","乌苏市","新源县","伊宁市","伊宁县","裕民县","昭苏县"}},
							
						   {{"保山市","昌宁县","龙陵县","施甸县","腾冲县"},
							{"楚雄市","大姚县","禄丰县","牟定县","南华县","双柏县","武定县","姚安县","永仁县","元谋县"},
							{"宾川县","大理市","洱源县","鹤庆县","剑川县","弥渡县","南涧彝族自治县","巍山彝族回族自治县","祥云县","漾濞彝族自治县","永平县","云龙县"},
							{"梁河县","陇川县","潞西市","瑞丽市","盈江县"},
							{"德钦县","维西傈僳族自治县","香格里拉县"},
							{"个旧市","河口瑶族自治县","红河县","建水县","金平苗族瑶族傣族自治县","开远市","绿春县","蒙自县","弥勒县","屏边苗族自治县","石屏县","元阳县","泸西县"},
							{"安宁市","呈贡县","富民县","晋宁县","昆明市","禄劝彝族苗族自治县","石林彝族自治县","寻甸回族自治县","宜良县","嵩明县"},
							{"华坪县","丽江市","宁蒗彝族自治县","永胜县","玉龙纳西族自治县"},
							{"沧源佤族自治县","凤庆县","耿马傣族佤族治县","临沧县","双江拉祜族佤族布朗族傣族自治县","永德县","云县","镇康县"},
							{"福贡县","贡山独龙族怒族自治县","兰坪白族普米族自治县","泸水县"},
							{"富源县","会泽县","陆良县","罗平县","马龙县","曲靖市","师宗县","宣威市","沾益县"},
							{"江城哈尼族彝族自治县","景东彝族自治县","景谷彝族傣族自治县","澜沧拉祜族自治县","孟连傣族拉祜族佤族自治县","墨江哈尼族自治县","普洱哈尼族彝族自治县","思茅市","西盟佤族自治县","镇沅彝族哈尼族拉祜族自治县"},
							{"富宁县","广南县","麻栗坡县","马关县","丘北县","文山县","西畴县","砚山县"},
							{"景洪市","勐海县","勐腊县"},
							{"澄江县","峨山彝族自治县","华宁县","江川县","通海县","新平彝族傣族自治县","易门县","玉溪市","元江哈尼族彝族傣族自治县"},
							{"大关县","鲁甸县","巧家县","水富县","绥江县","威信县","盐津县","彝良县","永善县","昭通市","镇雄县"}},
							
						   {{"淳安县","富阳市","杭州市","建德市","临安市","桐庐县"},
							{"安吉县","长兴县","德清县","湖州市"},
							{"海宁市","海盐县","嘉善县","嘉兴市","平湖市","桐乡市"},
							{"东阳市","金华市","兰溪市","磐安县","浦江县","武义县","义乌市","永康市"},
							{"景宁畲族自治县","丽水市","龙泉市","青田县","庆元县","松阳县","遂昌县","云和县","缙云县"},
							{"慈溪市","奉化市","宁波市","宁海县","象山县","余姚市"},
							{"上虞市","绍兴市","绍兴县","新昌县","诸暨市","嵊州市"},
							{"临海市","三门县","台州市","天台县","温岭市","仙居县","玉环县"},
							{"苍南县","洞头县","乐清市","平阳县","瑞安市","泰顺县","温州市","文成县","永嘉县"},
							{"舟山市","岱山县","嵊泗县"},
							{"常山县","江山市","开化县","龙游县","衢州市"}},
						   
						   {{"城口县","大足县","垫江县","丰都县","奉节县","合川市","江津市","开县","梁平县","南川市","彭水苗族土家族自治县","荣昌县","石柱土家族自治县","铜梁县","巫山县","巫溪县","武隆县","秀山土家族苗族自治县","永川市","酉阳土家族苗族自治县","云阳县","忠县","重庆市","潼南县","璧山县","綦江县"}}};
		
		int [][] parentid={ {33},
							{34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50},
							{51,52,53,54,55,56,57,58,59},
							{60,61,62,63,64,65,66,67,68,69,70,71,72,73},
							{74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94},
							{95,96,97,98,99,100,101,102,103,104,105,106,107,108},
							{109,110,111,112,113,114,115,116,117},
							{118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,135},
							{136,137,138,139,140,141,142,143,144,145,146},
							{147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,163,164},
							{165,166,167,168,169,170,171,172,173,174,175,176,177},
							{178,179,180,181,182,183,184,185,186,187,188,189,190,191,192,193,194},
							{195,196,197,198,199,200,201,202,203,204,205,206,207,208},
							{209,210,211,212,213,214,215,216,217},
							{218,219,220,221,222,223,224,225,226,227,228,229,230},
							{231,232,233,234,235,236,237,238,239,240,241},
							{242,243,244,245,246,247,248,249,250,251,252,253,254,255},
							{256,257,258,259,260,261,262,263,264,265,266,267},
							{268,269,270,271},
							{272,273,274,275,276,277,278,279},
							{280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296},
							{297,298,299,300,301,302,303,304,305,306,307},
							{308,309,310,311,312,313,314,315,316,317},
							{318},
							{319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339},
							{340},
							{341,342,343,344,345,346,347},
							{348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363},
							{364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379},
							{380,381,382,383,384,385,386,387,388,389,390},
							{391}};
		
		
		StringBuffer sql=new StringBuffer();
		sql.append("insert into countryarea (areaname,parentid,level) values (?,?,?)");
		try {
			PreparedStatement ps=DBCon.getCon().prepareStatement(sql.toString());
			
			System.out.println("正在插入国家地区信息，请稍等...");									

			ps.setString(1, contry);
			ps.setInt(2, 0);
			ps.setInt(3, 1);
			ps.execute();
			
			for(int i=0;i<province.length;i++){				
				ps.setString(1, province[i]);
				ps.setInt(2, 1);
				ps.setInt(3, 2);
				ps.addBatch();	
				//System.out.println("["+(id++)+"]"+province[i]+":"+(1));				
			}
			ps.executeBatch();
			
			
			for(int i=0;i<area.length;i++){				
				for(int j=0;j<area[i].length;j++){
					ps.setString(1, area[i][j]);
					ps.setInt(2, i+2);
					ps.setInt(3, 3);
					ps.addBatch();	
					//System.out.println("["+(id++)+"]"+area[i][j]+":"+(i+2));					
				}				
				ps.executeBatch();
			}
			
			for(int i=0;i<city.length;i++){
				for(int j=0;j<city[i].length;j++){
					for(int k=0;k<city[i][j].length;k++){						
						ps.setString(1, city[i][j][k]);
						ps.setInt(2, parentid[i][j]);
						ps.setInt(3, 4);
						ps.addBatch();							
						//System.out.println("["+(id++)+"]"+city[i][j][k]+":"+(parentid[i][j]));
					}
					ps.executeBatch();
				}										
			}
						
			System.out.println("国家地区信息插入完毕。");
		} catch (SQLException sqlexception) {
			sqlexception.printStackTrace();
			throw sqlexception;
		} 
		
	}
}