--初始化cityinfo表
insert into cityinfo(cityid,cityname) values('100001','北京');
insert into cityinfo(cityid,cityname) values('100002','天津');
insert into cityinfo(cityid,cityname) values('100003','太原');
insert into cityinfo(cityid,cityname) values('100004','石家莊');
insert into cityinfo(cityid,cityname) values('100005','濟(jì)南');
insert into cityinfo(cityid,cityname) values('100006','青島');
insert into cityinfo(cityid,cityname) values('100007','呼和浩特');
insert into cityinfo(cityid,cityname) values('100008','福州');
insert into cityinfo(cityid,cityname) values('100009','廣州');
insert into cityinfo(cityid,cityname) values('100010','廈門');
insert into cityinfo(cityid,cityname) values('100011','南寧');
insert into cityinfo(cityid,cityname) values('100013','海口');
insert into cityinfo(cityid,cityname) values('100015','鄭州');
insert into cityinfo(cityid,cityname) values('100016','武漢');
insert into cityinfo(cityid,cityname) values('100017','長沙');
insert into cityinfo(cityid,cityname) values('100018','南昌');
insert into cityinfo(cityid,cityname) values('100019','合肥');
insert into cityinfo(cityid,cityname) values('100020','上海');
insert into cityinfo(cityid,cityname) values('100021','南京');
insert into cityinfo(cityid,cityname) values('100024','杭州');
insert into cityinfo(cityid,cityname) values('100025','哈爾濱');
insert into cityinfo(cityid,cityname) values('100026','沈陽');
insert into cityinfo(cityid,cityname) values('100027','長春');
insert into cityinfo(cityid,cityname) values('100028','大連');
insert into cityinfo(cityid,cityname) values('100029','烏魯木齊');
insert into cityinfo(cityid,cityname) values('100030','銀川');
insert into cityinfo(cityid,cityname) values('100031','西安');
insert into cityinfo(cityid,cityname) values('100032','西寧');
insert into cityinfo(cityid,cityname) values('100033','蘭州');
insert into cityinfo(cityid,cityname) values('100034','拉薩');
insert into cityinfo(cityid,cityname) values('100035','重慶');
insert into cityinfo(cityid,cityname) values('100036','昆明');
insert into cityinfo(cityid,cityname) values('100037','成都');
insert into cityinfo(cityid,cityname) values('100038','貴陽');
insert into cityinfo(cityid,cityname) values('100039','香港');
insert into cityinfo(cityid,cityname) values('100040','澳門');
insert into cityinfo(cityid,cityname) values('100041','臺北');
insert into cityinfo(cityid,cityname) values('100042','東京');
insert into cityinfo(cityid,cityname) values('100044','新加坡');
insert into cityinfo(cityid,cityname) values('100046','曼谷');
insert into cityinfo(cityid,cityname) values('100047','漢城');
/
--初始化業(yè)務(wù)信息表
insert into serviceinfo
(serviceid,name,priceinfo,ServiceDesc,freqdesc,example)
values(
99,
'天氣預(yù)報',
'包月計費，每城市3元 ',
'提供全國37個主要城市和10個國際城市的24小時天氣預(yù)報。(每天晚上6-7時發(fā)布。)',
'1 條/日',
'北京天氣預(yù)報：1月17日周四<br>
今晚：晴<br>
風(fēng)力：<3<br>
最低溫度：-8<br>
明天：晴<br>
風(fēng)力：<3<br>
最高溫度：5<br>
污染指數(shù)：3');