domembermodify.asp

机票预定系统 各个模块的设计-ticket reservation systems detailed design system modules of the design

<!--#include file="../manager/function/conn.asp"-->
<!--#include file="../function.asp"-->
<!--#include file="../safe_mem.asp"-->
<%
mem_loginname=testdb(request("mem_loginname"))
Mem_LoginPasd=testdb(request("pwd"))
Mem_biming=testdb(request("biming"))
Mem_sex=testdb(request("Gender"))
Mem_chinese=testdb(request("chinese"))
if trim(mem_chinese)="yes" then
mem_city=testdb(request("city"))

select case mem_city
case 1
mem_city="Beijing     北京"
case 2
mem_city="Shanghai    上海"
case 3
mem_city="Tianjin     天津"
case 4
mem_city="Chongqing   重庆"
case 5
mem_city="Harbin      哈尔滨"
case 867
mem_city="Yanbian     延边"
case 149
mem_city="Qiqihar     齐齐哈尔"
case 150
mem_city="Mudanjiang  牡丹江"
case 157
mem_city="Jixi        鸡西"
case 281
mem_city="Heihe       黑河"
case 317
mem_city="Jiamusi     佳木斯"
case 1121
mem_city="Jingmen     荆门"
case 1128
mem_city="Suihua      绥化"
case 517
mem_city="Yichun      伊春"
case 158
mem_city="Changchun   长春"
case 159
mem_city="Jilin       吉林"
case 1116
mem_city="Baicheng    白城"
case 456
mem_city="Tonghua     通化"
case 6
mem_city="Dalian      大连"
case 211
mem_city="Chaoyang    朝阳"
case 221
mem_city="Dandong     丹东"
case 231
mem_city="Daqing      大庆"
case 252
mem_city="Fuxun       抚顺"
case 254
mem_city="Fuxin       阜新"
case 387
mem_city="Panjing     盘锦"
case 440
mem_city="Siping      四平"
case 178
mem_city="Anshan      鞍山"
case 327
mem_city="Jinzhou     锦州"
case 351
mem_city="Liaoyang    辽阳"
case 352
mem_city="Liaoyuan    辽源"
case 1048
mem_city="Tielin      铁岭"
case 1050
mem_city="Huludao     葫芦岛"
case 1155
mem_city="Benxi       本溪"
case 451
mem_city="Shenyang    沈阳"
case 216
mem_city="Cangzhou    沧州"
case 242
mem_city="Dezhou      德州"
case 275
mem_city="Handan      邯郸"
case 428
mem_city="Shijiazhuang石家庄"
case 147
mem_city="Qinhuangdao 秦皇岛"
case 185
mem_city="Baoding     保定"
case 290
mem_city="Hengshui    衡水"
case 340
mem_city="Langfang    廊坊"
case 947
mem_city="Xingtai     邢台"
case 468
mem_city="Tangshan    唐山"
case 550
mem_city="Zhangjiakou 张家口"
case 562
mem_city="Chende      承德"
case 385
mem_city="Nanyang     南阳"
case 436
mem_city="Sanmenxia   三门峡"
case 441
mem_city="Shangqiu    商丘"
case 181
mem_city="Anyang      安阳"
case 331
mem_city="Kaifeng     开封"
case 350
mem_city="Luoyang     洛阳"
case 951
mem_city="Hebi        鹤壁"
case 1088
mem_city="Luohe       漯河"
case 1093
mem_city="Jiaozuo     焦作"
case 1094
mem_city="Xuchang     许昌"
case 507
mem_city="Xinxiang    新乡"
case 510
mem_city="Xinyang     信阳"
case 551
mem_city="Zhumadian   驻马店"
case 559
mem_city="Zhengzhou   郑州"
case 7
mem_city="Qingdao     青岛"
case 236
mem_city="Dongying    东营"
case 144
mem_city="Jinan       济南"
case 318
mem_city="Jining      济宁"
case 1071
mem_city="Liaocheng   聊城"
case 1074
mem_city="Heze        菏泽"
case 1106
mem_city="Rezhao      日照"
case 454
mem_city="Taian       泰安"
case 475
mem_city="Weifang     潍坊"
case 479
mem_city="Weihai      威海"
case 533
mem_city="Yantai      烟台"
case 542
mem_city="Zibo        淄博"
case 569
mem_city="Linyi       临沂"
case 614
mem_city="Zhaozhuang  枣庄"
case 386
mem_city="Pingdingshan平顶山"
case 105
mem_city="Taiyuan     太原"
case 136
mem_city="Datong      大同"
case 137
mem_city="Changzhi    长治"
case 139
mem_city="Linfen      临汾"
case 140
mem_city="Yuncheng    运城"
case 907
mem_city="Yangquan    阳泉"
case 1092
mem_city="Jincheng    晋城"
case 513
mem_city="Xinzhou     忻州"
case 10
mem_city="Xian        西安"
case 269
mem_city="Huaian      淮安"
case 110
mem_city="Yanan       延安"
case 111
mem_city="Xianyang    咸阳"
case 112
mem_city="Baoji       宝鸡"
case 118
mem_city="Tongchuan   铜川"
case 129
mem_city="Hanzhong    汉中"
case 171
mem_city="Ankang      安康"
case 287
mem_city="Huainan     淮南"
case 1030
mem_city="Weinan      渭南"
case 527
mem_city="Yulin       榆林"
case 388mem_city="Pingliang   平凉"
case 404
mem_city="Qingyang    庆阳"
case 662
mem_city="Jiuquan     酒泉"
case 663
mem_city="Zhangye     张掖"
case 664
mem_city="Wuwei       武威"
case 100
mem_city="Lanzhou     兰州"
case 326
mem_city="Jiayuguan   嘉峪关"
case 1021
mem_city="Dingxi      定西"
case 1158
mem_city="Jinchang    金昌"
case 464
mem_city="Tianshui    天水"
case 99
mem_city="Yinchuan    银川"
case 321
mem_city="Guyuan      固原"
case 12
mem_city="Nanjing     南京"
case 13
mem_city="Wuxi        无锡"
case 14
mem_city="Suzhou      苏州"
case 15
mem_city="Yangzhou    扬州"
case 16
mem_city="Zhengjiang  镇江"
case 82
mem_city="Nantong     南通"
case 213
mem_city="Changzhou   常州"
case 272
mem_city="Huaibei     淮北"
case 353
mem_city="Lianyungang 连云港"
case 1200
mem_city="yancheng    盐城"
case 512
mem_city="Xuzhou      徐州"
case 579
mem_city="Taizhou     泰州"
case 17
mem_city="Hangzhou    杭州"
case 22
mem_city="Shaoxing    绍兴"
case 86
mem_city="Huzhou      湖州"
case 375
mem_city="Ningbo      宁波"
case 407
mem_city="Quzhou      衢州"
case 308
mem_city="Jinhua      金华"
case 346
mem_city="Lishui      丽水"
case 491
mem_city="Wenzhou     温州"
case 571
mem_city="Jiaxing     嘉兴"
case 578
mem_city="Taizhou     台州"
case 23
mem_city="Huangshan   黄山"
case 218
mem_city="Chizhou     池州"
case 257
mem_city="Fuyang      阜阳"
case 177
mem_city="Anqing      安庆"
case 182
mem_city="Bangbu      蚌埠"
case 278
mem_city="Hefei       合肥"
case 1006
mem_city="Xuancheng   宣城"
case 1024
mem_city="Maanshan    马鞍山"
case 1078
mem_city="Bozhou      亳州"
case 459
mem_city="Tongling    铜陵"
case 478
mem_city="Wuhu        芜湖"
case 521
mem_city="Suzhou      宿州(县)"
case 589
mem_city="Chaohu      巢湖"
case 24
mem_city="Jiujiang    九江"
case 268
mem_city="Ganzhou     赣州"
case 376
mem_city="Nanchang    南昌"
case 411
mem_city="Shangrao    上饶"
case 305
mem_city="Jingdezhen  景德镇"
case 933
mem_city="Jian        吉安"
case 518
mem_city="Yichun      宜春"
case 534
mem_city="Yingtan     鹰潭"
case 603
mem_city="Xinyu       新余"
case 25
mem_city="Xiamen      厦门"
case 258
mem_city="Fuzhou      福州"
case 378
mem_city="Ningde      宁德"
case 406
mem_city="Quanzhou    泉州"
case 437
mem_city="Sanming     三明"
case 667
mem_city="Putian      莆田"
case 348
mem_city="Longyan     龙岩"
case 560
mem_city="Zhangzhou   漳州"
case 606
mem_city="Nanping     南平"
case 245
mem_city="Enshi       恩施"
case 292
mem_city="Huangshi    黄石"
case 328
mem_city="Jinzhou     荆州"
case 937
mem_city="Xianning    咸宁"
case 992
mem_city="Ezhou       鄂州"
case 1117
mem_city="Suizhou     随州"
case 452mem_city="Shiyan      十堰"
case 477
mem_city="Wuhan       武汉"
case 496
mem_city="Xiangfan    襄樊"
case 515
mem_city="Yichang     宜昌"
case 27
mem_city="Zhangjiajie 张家界"
case 201
mem_city="Changde     常德"
case 206
mem_city="Pingxiang   萍乡"
case 282
mem_city="Huaihua     怀化"
case 297
mem_city="Hengyang    衡阳"
case 918
mem_city="Loudi       娄底"
case 970
mem_city="Yongzhou    永州"
case 1110
mem_city="Jishou      吉首"
case 1111
mem_city="Shaoyang    邵阳"
case 1125
mem_city="Yiyang      益阳"
case 539
mem_city="Yueyang     岳阳"
case 598
mem_city="Xiangtan    湘潭"
case 612
mem_city="Chengzhou   郴州"
case 28
mem_city="Chengdu     成都"
case 237
mem_city="Deyang      德阳"
case 267
mem_city="Guangyuan   广元"
case 370
mem_city="Mianyang    绵阳"
case 377
mem_city="Nanchong    南充"
case 345
mem_city="Leshan      乐山"
case 355
mem_city="Luzhou      泸州"
case 1011
mem_city="Neijiang    内江"
case 1097
mem_city="Panzhihua   攀枝花"
case 1148
mem_city="Meishan     眉山"
case 514
mem_city="Yibin       宜宾"
case 544
mem_city="Zigong      自贡"
case 30
mem_city="Shenzhen    深圳"
case 31
mem_city="Zhuhai      珠海"
case 32
mem_city="Guangzhou   广州"
case 215
mem_city="chaozhou    潮州"
case 223
mem_city="Dongguan    东莞"
case 251
mem_city="Foshan      佛山"
case 422
mem_city="Shaoguan    韶关"
case 692
mem_city="Yangjiang   阳江"
case 693
mem_city="Heyuan      河源"
case 299
mem_city="Huizhou     惠州"
case 316
mem_city="Jiangmen    江门"
case 956
mem_city="Jieyang     揭阳"
case 1105
mem_city="Maoming     茂名"
case 1139
mem_city="Xingyi      兴义"
case 447
mem_city="Shantou     汕头"
case 547
mem_city="Zhanjiang   湛江"
case 552
mem_city="Zhaoqing    肇庆"
case 553
mem_city="Zhongshan   中山"
case 33
mem_city="Guilin      桂林"
case 380
mem_city="Nanning     南宁"
case 189
mem_city="Beihai      北海"
case 354
mem_city="Liuzhou     柳州"
case 1113
mem_city="Yulin       玉林"
case 1140
mem_city="Baise       百色"
case 492
mem_city="Wuzhou      梧州"
case 34
mem_city="Kunming     昆明"
case 35
mem_city="Xishuangbann西双版纳"
case 36
mem_city="Dali        大理"
case 37
mem_city="Lijiang     丽江"
case 197
mem_city="Baoshan     保山"
case 435
mem_city="Simao       思茅"
case 93
mem_city="Diqing      迪庆"
case 186
mem_city="yuxi        玉溪"
case 985
mem_city="Qujing      曲靖"
case 555
mem_city="Zhaotong    昭通"
case 38
mem_city="Guiyang     贵阳"
case 179
mem_city="Anshun      安顺"
case 333
mem_city="Kaili       凯里"
case 975
mem_city="Duyun       都匀"
case 558
mem_city="Zunyi       遵义"
case 605
mem_city="Lps         六盘水"
case 124
mem_city="Xining      西宁"
case 202
mem_city="Chifeng     赤峰"
case 103
mem_city="Hohhot      呼和浩特"
case 141
mem_city="Baotou      包头"
case 1133
mem_city="Wuhai       乌海"
case 1134
mem_city="Shizuishan  石嘴山"
case 458
mem_city="Tongliao    通辽"
case 39
mem_city="Urumqi      乌鲁木齐"
case 40
mem_city="Tulufan     吐鲁番"
case 98
mem_city="Yili        伊犁"
case 109
mem_city="Kashi       喀什"
case 166
mem_city="Kelamayi    克拉玛依"
case 173
mem_city="Aksu        阿克苏"
case 175
mem_city="Aletai      阿勒泰"
case 285
mem_city="Hami        哈密"
case 294
mem_city="Hotan       和田"
case 330
mem_city="Koria       库尔勒"
case 455
mem_city="Tacheng     塔城"
case 41
mem_city="Lhasa       拉萨"
case 439
mem_city="Shannan     山南"
case 92
mem_city="Rikazhe     日喀则"
case 97
mem_city="Ali         阿里"
case 108
mem_city="Linzhi      林芝"
case 575
mem_city="Changdu     昌都"
case 42
mem_city="Haikou      海口"
case 43
mem_city="Sanya       三亚"
case 58
mem_city="HongKong    香港"
case 59
mem_city="Macao       澳门"
case 720
mem_city="Kaohsiung   高雄"
case 617
mem_city="Taipei      台北"
end select
 else
mem_province="中国以外的地区"
mem_city="不详"
end if
mem_loginname=testdb(request("mem_loginname"))
Mem_name=testdb(request("username"))
Mem_Idcard=testdb(request("IDCardNo"))
mem_zip=testdb(request("ZIP"))
Mem_Addr=testdb(request("Address"))
Mem_Tel=testdb(request("Tel"))
mem_loginpasd=rand()
set rs=server.CreateObject("adodb.recordset")
 sql="select top 1 * from tmember order by MEM_ID desc"
 rs.open sql,conn,3,2
 dim ZXLMem_id
'ZXLMem_id=Cint(rs("mem_id"))
 if rs.eof or rs.bof then
     ZXLMem_id=1
 else
     ZXLMem_id=Cint(rs("mem_id"))+1
 end if
rs.close
sql="select * from tmember"
rs.open sql,conn,3,2
if not rs.eof then
rs.addnew
rs("mem_id")=ZXLMem_id
rs("Mem_LoginPasd")=Mem_LoginPasd
rs("Mem_biming")=Mem_biming
rs("Mem_sex")=Mem_sex
rs("Mem_Email")=Mem_Email
rs("mem_city")=mem_city
rs("Mem_name")=Mem_name
rs("Mem_Idcard")=Mem_Idcard
rs("Mem_zip")=Mem_zip
rs("Mem_addr")=Mem_addr
rs("Mem_tel")=Mem_tel
rs.update
rs.close
  msg="会员资料修改成功！"

 else
 msg="会员资料修改失败！"
end if 
%>
<%

'rs.close
set rs=nothing
call conn_close()
%>