【正文】 smanager是否為管理員VARCHAR2(12)航班表（flight）：字段名中文說明字段類型主外鍵備注Flightid航班idNUMBER(10)主鍵非空唯一Flightno航班編號VARCHAR2(20)Flighttype航班類型VARCHAR2(20)Leaverime起飛時間VARCHAR2(20)Arrivetime到達時間VARCHAR2(20)Qdzhan起點站VARCHAR2(20)Zhdzhan終點站VARCHAR2(20)預訂表（reserveflight）：字段名中文說明字段類型主外鍵備注Reservid預訂idNUMBER(10)主鍵非空唯一Userid用戶idNUMBER(10)外鍵參照用戶表Flightid航班idNUMBER(10)外鍵參照航班表Reservtime預訂時間Date非空Softnumber經(jīng)濟艙數(shù)量NUMBER(10)Hardnumber商務艙數(shù)量NUMBER(10)Totalprices票價總金額NUMBER(10)附件二：附件三：?xml version= encoding=UTF8?!DOCTYPE strutsconfig PUBLIC //Apache Software Foundation//DTD Struts Configuration strutsconfig datasources / formbeans formbean name=loginForm type= formproperty name=username type=/formproperty formproperty name=password type=/formproperty formproperty name=ismanager type=/formproperty /formbean formbean name=userInfo type= formproperty name=username type=/formproperty formproperty name=password type=/formproperty formproperty name=ismanager type=/formproperty formproperty name=realname type=/formproperty formproperty name=sex type=/formproperty formproperty name=age type=/formproperty formproperty name= type=/formproperty /formbean formbean name=flight type= formproperty name=flightid type=/formproperty formproperty name=flightno type=/formproperty formproperty name=flighttype type=/formproperty formproperty name=qdzhan type=/formproperty formproperty name=zhdzhan type=/formproperty formproperty name=leavetime type=/formproperty formproperty name=arrivetime type=/formproperty formproperty name=softtotal type=/formproperty formproperty name=hardtotal type=/formproperty formproperty name=softprice type=/formproperty formproperty name=hardprice type=/formproperty /formbean /formbeans globalexceptions / globalforwards forward name=destine path=/user//forward forward name=header path=/user//forward forward name=ubody path=/user//forward forward name=utiles path=/user//forward forward name=ushowallTiles path=/user//forward forward name=bouncetine path=/user//forward forward name=flightManager1 path=?method=listFlight redirect=true/forward forward name=index path=//forward forward name=regist path=//forward forward name=leftMana path=/manager//forward forward name=ushowallTiles1 path=/manager/ /forward forward name=flightManager path=/manager/ /forward forward name=addflight path=/manager//forward forward name=updateflight path=/manager/ /forward forward name=reserflight path=/user//forward forward name=resersucc path=/user//forward forward name=checkflight path=/manager//forward forward name=usercheckflight path=/user/ /forward forward name=selectLMess path=/user//forward forward name=reserselect path=/user//forward forward name=treserselect path=/user//forward forward name=managerLMess path=/manager/ /forward forward name=listall path=/?method=listall redirect=true/forward forward name=listuser path=/manager//forward forward name=adduser path=/manager//forward /globalforwards actionmappings action path=/login type= name=loginForm parameter=method /action action path=/regist type= name=userInfo parameter=method /action action path=/flightManager type= parameter=method /action action path=/add type= parameter=method /action action path=/addflight type= parameter=method name=fli