濱州視頻拍攝腳本
❶ 誰知道國家選省份的javascript腳本,給個例子地址也可以。謝謝大家了!
這個是我國的各省的城市選擇網頁,你可以按自己的要求進行一些改動.
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>省份選城市</title>
<style type="text/css">
<!--
form{margin:0;padding:0;}
img{border:0;}
body,select,input,td{ font-family:宋體,Arial; font-size: 12px; font-family: Arial; margin-top: 2px;}
#hd{clear:both;width:700px;margin:0 auto;margin-bottom:.5em;padding:.5em 0 0 0;}
.rlcon a{text-decoration:none;margin-left:.3em;}
.mcon,.lpanel,.panel{text-align:left;}
.lg{float:left;width:185px;padding:.5em 0;}
.rl{float:right;width:100%;margin:0 0 0 -30em;}
.rlcon{text-align:right;height:32px;margin:0 0 0 190px;color:#b8b8b8;border-bottom:1px solid #b5b5b5;overflow:hidden;line-height:45px;}
#lcon{float:left;width:180px;}
#mcon{float:right;width:100%;margin:0 0 0 -20em;}
.mcon{margin:0 0 0 190px;width:570px;}
.xb{border-top:1px solid transparent !important;border-top:0;clear:both;}
#footer {margin:0 auto;width:740px;text-align:center;font-size:12px;height:30px;line-height:30px;border-top:1px solid #666;}
table{clear:both;text-align:left;}
#tip{clear:both;margin:0 auto;width:500px;background-color:#ffffe1;border:1px solid #ACA899;padding:1em;margin:1em;text-align:left;color:#ff0000;}
#tip #cancel{float:right;}
#tip ul{display:block;margin:0;padding:0;list-style-type:none;}
#tip ul li{float:left;width:220px;line-height:1.5em;background-color:#ffffe1;}
#hidenbox{border-top:1px solid transparent !important;border-top:0;clear:both;}
.bnt14{font-size:13px;font-family:宋體,Arial;line-height:18px;height:25px;}
-->
</style>
</head>
<html>
<body>
<center>
<form name="personalorder" action="preferences" method="POST">
<div id="hd">
<TABLE height=20 cellSpacing=0 cellPadding=0 width=714 align=center
border=0>
<TBODY>
<TR>
<TD height="60" vAlign=center> <DIV class=s5 align=center>選擇省市:
<select name="prov" onchange="setInd(this)">
<option value=0>不預定</option><option value=8610>北京</option><option value=8621>上海</option><option value=8622>天津</option><option value=8623>重慶</option><option value=86311>河北</option><option value=8625>江蘇</option><option value=86571>浙江</option><option value=8620>廣東</option><option value=86351>山西</option><option value=8624>遼寧</option><option value=86431>吉林</option><option value=86451>黑龍江</option><option value=86551>安徽</option><option value=86591>福建</option><option value=86791>江西</option><option value=86531>山東</option><option value=86371>河南</option><option value=8627>湖北</option><option value=86731 selected>湖南</option><option value=8628>四川</option><option value=86851>貴州</option><option value=86871>雲南</option><option value=8629>陝西</option><option value=86931>甘肅</option><option value=86971>青海</option><option value=86471>內蒙古</option><option value=86771>廣西</option><option value=86898>海南</option><option value=86891>西藏</option><option value=86951>寧夏</option><option value=86991>新疆</option><option value=88610>台灣</option><option value=85210>香港</option><option value=85310>澳門</option></SELECT>
選擇城市:
<SELECT name=locid>
<OPTION value=86731731>長沙</OPTION><OPTION value=86731730>岳陽</OPTION><OPTION value=86731732>湘潭</OPTION><OPTION value=86731733>株洲</OPTION><OPTION value=86731734>衡陽</OPTION><OPTION value=86731735>郴州</OPTION><OPTION value=86731736>常德</OPTION><OPTION value=86731737>益陽</OPTION><OPTION value=86731738>婁底</OPTION><OPTION value=86731739>邵陽</OPTION><OPTION value=86731743 selected>吉首</OPTION><OPTION value=86731745>懷化</OPTION><OPTION value=86731746>永州</OPTION>
</SELECT>
</DIV>
<script>
function cls_inpt(){
var _inpt=document.getElementsByTagName("input");
for(var i=0;i<_inpt.length;i++){
if(_inpt[i].name.indexOf('stockid')>=0 ||_inpt[i].name.indexOf('showname')>=0 ||_inpt[i].name.indexOf('stockname')>=0){
_inpt[i].value='';
}
}
return false;
}
cityarray0 = new Array(
"0;不預定");
cityarray8610 = new Array(
"861010;北京");
cityarray8621 = new Array(
"862121;上海");
cityarray8622 = new Array(
"862222;天津");
cityarray8623 = new Array(
"862323;重慶",
"86232314;萬州",
"8623810;涪陵");
cityarray86311 = new Array(
"86311311;石家莊",
"86311310;邯鄲",
"86311312;保定",
"86311313;張家口",
"86311314;承德",
"86311315;唐山",
"86311316;廊坊",
"86311317;滄州",
"86311318;衡水",
"86311319;邢台",
"86311335;秦皇島");
cityarray8625 = new Array(
"862525;南京",
"8625510;無錫",
"8625511;鎮江",
"8625512;蘇州",
"8625513;南通",
"8625514;揚州",
"8625515;鹽城",
"8625516;徐州",
"8625517;淮安",
"862551701;淮陰",
"8625518;連雲港",
"8625519;常州",
"8625523;泰州",
"8625527;宿遷");
cityarray86571 = new Array(
"86571571;杭州",
"86571570;衢州",
"86571572;湖州",
"86571573;嘉興",
"86571574;寧波",
"86571575;紹興",
"86571576;台州",
"86571577;溫州",
"86571578;麗水",
"86571579;金華",
"86571580;舟山");
cityarray8620 = new Array(
"862020;廣州",
"8620660;汕尾",
"8620662;陽江",
"8620663;揭陽",
"8620668;茂名",
"8620750;江門",
"8620751;韶關",
"8620752;惠州",
"8620753;梅州",
"8620754;汕頭",
"8620755;深圳",
"8620756;珠海",
"8620757;佛山",
"8620758;肇慶",
"8620759;湛江",
"8620760;中山",
"8620762;河源",
"8620763;清遠",
"8620766;雲浮",
"8620768;潮州",
"8620769;東莞");
cityarray86351 = new Array(
"86351351;太原",
"86351349;朔州",
"86351350;忻州",
"86351352;大同",
"86351353;陽泉",
"86351354;榆次",
"86351355;長治",
"86351356;晉城",
"86351357;臨汾",
"86351358;呂梁",
"86351359;運城");
cityarray8624 = new Array(
"862424;沈陽",
"8624410;鐵嶺",
"8624411;大連",
"8624412;鞍山",
"8624413;撫順",
"8624414;本溪",
"8624415;丹東",
"8624416;錦州",
"8624417;營口",
"8624418;阜新",
"1378819;遼陽",
"8624421;朝陽",
"8624427;盤錦",
"8624429;葫蘆島");
cityarray86431 = new Array(
"86431431;長春",
"86431432;吉林",
"86431434;四平",
"86431435;通化",
"86431436;白城",
"86431437;遼源",
"86431438;松原",
"86431439;白山");
cityarray86451 = new Array(
"86451451;哈爾濱",
"86451452;齊齊哈爾",
"86451453;牡丹江",
"86451454;佳木斯",
"86451455;綏化",
"86451456;黑河",
"86451458;伊春",
"86451459;大慶",
"86451464;七台河",
"86451467;雞西",
"86451468;鶴崗",
"86451469;雙鴨山",
"86451470;大興安嶺");
cityarray86551 = new Array(
"86551551;合肥",
"86551550;滁州",
"86551552;蚌埠",
"86551553;蕪湖",
"86551554;淮南",
"86551555;馬鞍山",
"86551556;安慶",
"86551557;宿州",
"86551558;阜陽",
"8655155801;亳州",
"86551559;黃山",
"86551561;淮北",
"86551562;銅陵",
"86551563;宣城",
"86551564;六安",
"86551565;巢湖",
"86551566;池州");
cityarray86591 = new Array(
"86591591;福州",
"86591592;廈門",
"86591593;寧德",
"86591594;莆田",
"86591595;泉州",
"86591596;漳州",
"86591597;龍岩",
"86591598;三明",
"86591599;南平");
cityarray86791 = new Array(
"86791791;南昌",
"86791701;鷹潭",
"86791790;新余",
"86791792;九江",
"86791793;上饒",
"86791794;撫州",
"86791795;宜春",
"86791796;吉安",
"86791797;贛州",
"86791798;景德鎮",
"86791799;萍鄉");
cityarray86531 = new Array(
"86531531;濟南",
"86531530;菏澤",
"86531532;青島",
"86531533;淄博",
"86531534;德州",
"86531535;煙台",
"86531536;濰坊",
"86531537;濟寧",
"86531539;臨沂",
"86531543;濱州",
"86531546;東營",
"86531631;威海",
"86531632;棗庄",
"86531633;日照",
"86531634;萊蕪",
"86531635;聊城");
cityarray86371 = new Array(
"86371371;鄭州",
"86371370;商丘",
"86371372;安陽",
"86371373;新鄉",
"86371374;許昌",
"86371375;平頂山",
"86371376;信陽",
"86371377;南陽",
"86371378;開封",
"86371379;洛陽",
"86371391;焦作",
"86371392;鶴壁",
"86371393;濮陽",
"86371394;周口",
"86371395;漯河",
"86371396;駐馬店",
"86371398;三門峽");
cityarray8627 = new Array(
"862727;武漢",
"8627710;襄樊",
"8627711;鄂州",
"8627712;孝感",
"8627713;黃岡",
"8627714;黃石",
"8627715;咸寧",
"8627716;荊州",
"8627717;宜昌",
"8627718;恩施",
"8627719;十堰",
"8627722;隨州",
"8627724;荊門");
cityarray86731 = new Array(
"86731731;長沙",
"86731730;岳陽",
"86731732;湘潭",
"86731733;株洲",
"86731734;衡陽",
"86731735;郴州",
"86731736;常德",
"86731737;益陽",
"86731738;婁底",
"86731739;邵陽",
"86731743;吉首",
"86731745;懷化",
"86731746;永州");
cityarray8628 = new Array(
"862828;成都",
"8628812;攀枝花",
"8628813;自貢",
"8628816;綿陽",
"8628817;南充",
"8628818;達州",
"8628825;遂寧",
"8628826;廣安",
"8628827;巴中",
"8628830;瀘州",
"8628831;宜賓",
"8628832;資陽",
"862883201;內江",
"8628833;樂山",
"862883301;眉山",
"862883401;涼山",
"8628835;雅安",
"862883701;阿壩",
"8628838;德陽",
"8628839;廣元");
cityarray86851 = new Array(
"86851851;貴陽",
"86851852;遵義",
"86851853;安順",
"86851854;都勻",
"86851855;凱里",
"86851856;銅仁",
"86851857;畢節",
"86851858;六盤水",
"86851859;興義");
cityarray86871 = new Array(
"86871871;昆明",
"86871691;西雙版納",
"86871692;德宏",
"86871870;昭通",
"86871872;大理",
"8687187303;紅河",
"86871874;曲靖",
"86871875;保山",
"86871876;文山",
"86871877;玉溪",
"86871878;楚雄",
"86871879;思茅",
"86871883;臨滄",
"8687188601;怒江",
"8687188701;迪慶",
"86871888;麗江");
cityarray8629 = new Array(
"862929;西安",
"8629910;咸陽",
"8629911;延安",
"8629912;榆林",
"8629913;渭南",
"8629914;商洛",
"8629915;安康",
"8629916;漢中",
"8629917;寶雞",
"8629919;銅川");
cityarray86931 = new Array(
"86931931;蘭州",
"86931930;臨夏",
"86931932;定西",
"86931933;平涼",
"86931934;慶陽",
"86931935;金昌",
"8693193501;武威",
"86931936;張掖",
"86931937;酒泉",
"8693193701;嘉峪關",
"86931938;天水",
"86931939;隴南",
"86931941;甘南",
"86931943;白銀");
cityarray86971 = new Array(
"86971971;西寧",
"8697197001;海北",
"86971972;海東",
"8697197501;果洛",
"8697197301;黃南",
"86971976;玉樹",
"86971979;格爾木",
"8697197901;海西");
cityarray86471 = new Array(
"86471471;呼和浩特",
"86471470;海拉爾",
"86471472;包頭",
"86471473;烏海",
"86471474;集寧",
"86471475;通遼",
"86471476;赤峰",
"86471478;臨河",
"86471479;錫林浩特",
"86471482;烏蘭浩特",
"86471483;巴彥浩特",
"86471484;鄂爾多斯");
cityarray86771 = new Array(
"86771771;南寧",
"86771770;防城港",
"8677177101;崇左",
"86771772;柳州",
"8677177201;來賓",
"86771773;桂林",
"86771774;梧州",
"8677177401;賀州",
"86771775;玉林",
"8677177501;貴港",
"86771776,;百色",
"86771777,;欽州",
"86771778,;河池",
"86771779,;北海");
cityarray86898 = new Array(
"86898898;海口",
"86898899;三亞",
"8689889901;西沙群島");
cityarray86891 = new Array(
"86891891;拉薩",
"86891892;日喀則",
"86891893;山南",
"86891894;林芝",
"86891895;昌都",
"86891896;那曲",
"86891897;阿里");
cityarray86951 = new Array(
"86951951;銀川",
"86951952;石嘴山",
"86951953;吳忠",
"86951954;固原");
cityarray86991 = new Array(
"86991991;烏魯木齊",
"86991901;塔城",
"86991902;哈密",
"86991903;和田",
"86991906;阿勒泰",
"8699190801;克州",
"86991909;博樂",
"86991990;克拉瑪依",
"86991993;石河子",
"86991994;昌吉",
"86991995;吐魯番",
"86991996;庫爾勒",
"86991997;阿克蘇",
"86991998;喀什",
"86991999;伊犁");
cityarray88610 = new Array(
"8861010;台北");
cityarray85210 = new Array(
"8521010;香港");
cityarray85310 = new Array(
"8531010;澳門");
function getCitiesFromProvinceID(provinceid) {
if (provinceid == 0) return cityarray0;
if (provinceid == 8610) return cityarray8610;
if (provinceid == 8621) return cityarray8621;
if (provinceid == 8622) return cityarray8622;
if (provinceid == 8623) return cityarray8623;
if (provinceid == 86311) return cityarray86311;
if (provinceid == 8625) return cityarray8625;
if (provinceid == 86571) return cityarray86571;
if (provinceid == 8620) return cityarray8620;
if (provinceid == 86351) return cityarray86351;
if (provinceid == 8624) return cityarray8624;
if (provinceid == 86431) return cityarray86431;
if (provinceid == 86451) return cityarray86451;
if (provinceid == 86551) return cityarray86551;
if (provinceid == 86591) return cityarray86591;
if (provinceid == 86791) return cityarray86791;
if (provinceid == 86531) return cityarray86531;
if (provinceid == 86371) return cityarray86371;
if (provinceid == 8627) return cityarray8627;
if (provinceid == 86731) return cityarray86731;
if (provinceid == 8628) return cityarray8628;
if (provinceid == 86851) return cityarray86851;
if (provinceid == 86871) return cityarray86871;
if (provinceid == 8629) return cityarray8629;
if (provinceid == 86931) return cityarray86931;
if (provinceid == 86971) return cityarray86971;
if (provinceid == 86471) return cityarray86471;
if (provinceid == 86771) return cityarray86771;
if (provinceid == 86898) return cityarray86898;
if (provinceid == 86891) return cityarray86891;
if (provinceid == 86951) return cityarray86951;
if (provinceid == 86991) return cityarray86991;
if (provinceid == 88610) return cityarray88610;
if (provinceid == 85210) return cityarray85210;
if (provinceid == 85310) return cityarray85310;
return new Array();
}
function fillInCities(provinceid) {
document.forms['personalorder']['locid'].length = 0;
var arr = getCitiesFromProvinceID(provinceid);
var cnt = 0;
var isSelected = false;
for(var n=0; n<arr.length; n++){
newOpt=new Option;
i = arr[n].search(';');
newOpt.text=arr[n].slice(i+1);
newOpt.value=arr[n].slice(0,i);
if (!isSelected){
//newOpt.selected = true;
isSelected = true;
}
document.forms['personalorder']['locid'].options[cnt]=newOpt;
cnt=cnt+1;
}
}
function GetSelectedText(box){
var boxText = '';
for(var i=0; i<box.options.length; i++){
if(box.options[i].selected && box.options[i].value != ''){
boxText = box.options[i].value;
}
}
return boxText;
}
function setInd(box) {
ind = GetSelectedText(box);
if(ind != ''){
fillInCities(ind);
}
//alert(ind);
}
</script>
</TD>
</TR>
</TBODY>
</TABLE>
</body>
</html>
❷ BAT鎵瑰勭悊鑴氭湰錛氭庢牱鎵歸噺淇鏀規枃浠跺悕錛
BAT鎵瑰勭悊鑴氭湰錛氭壒閲忎慨鏀規枃浠跺悕錛屾柟娉曞備笅錛
鎵瑰勭悊鑴氭湰錛岃嫳鏂囧悕鍙獴atch錛屾墿灞曞悕.bat鍙栦簡鍓3涓瀛楁瘝銆傝娉曞ソ鍍忓叾瀹炴槸DOS鍛戒護錛岃村疄璇濇垜涓嶄細錛屽綋騫存垜姣忔℃兂鐜┿婂ぇ瀵岀縼銆嬶紝閮芥槸瑕佸枈鎴戝堢粰鎴戞墦寮鐨勩傛墍浠ヨ碬indows榪欐牱鐨勮嗙獥鎿嶄綔緋葷粺鐨勫嚭鐜扮『瀹炴湁鍒掓椂浠g殑鎰忎箟錛屽畠瑙e喅浜嗗ぇ澶氭暟鐔婂╁瓙鐢ㄧ數鑴100%鎶ュ囩殑闂棰樸
Windows濮嬬粓淇濈暀鐫涓閮ㄥ垎DOS鐨勫姛鑳斤紝鍦ㄥ紑濮嬭彍鍗曢噷鍙浠ユ壘鍒般備互鍓嶅彨MS-DOS錛岀幇鍦ㄥ彨鍛戒護鎻愮ず絎︼紝鎵撳紑瀹冪殑蹇鎹烽敭鏄銆愨淲in+R鈥濃啋杈撳叆鈥渃md鈥濃啋紜瀹氥戙
鐜板湪鍐嶅亣璁句竴涓鏂扮殑鍦烘櫙銆傛柊濯掍綋榪愯惀鍚屽﹀皬鏄庤礋璐e井淇℃帹閫侊紝浠栨彁鍓嶅噯澶囧ソ浜30澶╃殑鏂囩珷錛屽苟鎸夌収鈥5.3鍙.doc鈥濄佲5.4鍙.doc鈥濃︹﹁繖鏍峰懡鍚嶏紝鍏朵腑鐩稿綋涓閮ㄥ垎榪樻槸鏈夊厛鍚庨『搴忕殑榪炶澆鍐呭廣傚洜涓轟竴浜涘師鍥狅紝灝忔槑璐熻矗鐨勫叕浼楀彿瑕佸仠鏇5澶╋紝鎵浠ヤ粬鐨勭垮瓙鏂囦歡鍚嶅氨鍑虹幇浜嗛棶棰橈紝姣忎竴綃囬兘闇瑕侀『寤5澶┿備簬鏄錛屾庝箞鍔烇紵
榪炵畫鐨勯『寤訛紝鐔熸倝Excel鐨勪漢搴旇ヨ兘寰堝揩鎯沖埌Excel鐨勨滆嚜鍔ㄥ畬鎴愨濆姛鑳姐傛墍浠ワ紝榪欎釜闂棰樼殑瑙e喅鏂規硶涔嬩竴錛屽氨鏄鍙浠ラ厤鍚圗xcel鏉ヨВ鍐熾傝繖縐嶆劅瑙夛紝灝辨湁鐐瑰儚鍦‥xcel閲岋紝鍐沖畾鍋氫竴涓杈呭姪鍒楃殑鎰熻夈備嬌鐢ㄨ緟鍔╁垪鍏跺疄灝辨槸紼嶇◢澶氭兂涓姝ワ紝浠ラ伩鍏嶅幓姝葷曞嶆潅鐨勫叕寮忥紝榪欑嶆劅瑙夊張鏈夌偣鍍忓垪鏂圭▼銆備絾澶氭兂榪欎竴姝ユ尯閲嶈侊紝鎴戦亣鍒拌繃涓浜涚粡甯告皵鐨勪漢鑲濈柤鐨勫悓瀛︼紝灝辨槸姝繪椿涓嶆効澶氬姩鍗婃ヨ剳絳嬨
鍦–鍒楀埄鐢ㄥ叕寮忓皢A銆丅鍒楁枃鏈榪炴帴騫惰ˉ鍏ㄦ枃浠跺悕錛=鈥渞en 鈥&A1&鈥滃彂.doc 鈥&B1&鈥滃彂.doc鈥濈幇鍦ㄥ彧瑕佸嶅埗C鍒楀埌鏂囨湰鏂囨。錛屽啀淇鏀規墿灞曞悕涓.bat灝卞彲浠ヤ簡銆傚悓鐞嗭紝褰撴嬁鍒頒竴涓杈冧負娣蜂貢鐨勬敼鍚嶅瑰簲琛ㄦ椂錛屽埄鐢╥ndex錛堬級銆乵atch錛堬級鍑芥暟緇勫悎鎴栬卾lookup鍑芥暟錛岄氳繃Excel鐨勮緟鍔╋紝灝卞彲浠ュ畬鎴愭枃浠跺悕鐨勬壒閲忎慨鏀廣
浠ュ強錛屽悓鏍風殑錛屽墠闈㈡彁鍒扮殑閲嶅嶆枃浠跺垹闄や篃鑳芥壘寰楀埌ReNamer寮忕殑鎿嶄綔錛屼緥濡傝祫婧愮$悊鍣ㄧ殑鏉′歡鎼滅儲錛屾垨鑰呭崌綰т竴涓嬩嬌鐢⊿earch Everything錛屾壘鍒版枃浠跺す涓嬫寚瀹氭枃浠跺悕鎴栨枃浠剁被鍨嬬殑鎵鏈夋枃浠訛紝涓璧峰垹闄ゃ