數(shù)據(jù)庫(kù)課程設(shè)計(jì)實(shí)驗(yàn)報(bào)告

數(shù)據(jù)庫(kù)課程設(shè)計(jì)實(shí)驗(yàn)報(bào)——DBMS的制作（SQL編譯、前臺(tái)設(shè)計(jì)與系統(tǒng)整合 王樂一、實(shí)驗(yàn)?zāi)坑嘘P(guān)知識(shí)，來(lái)設(shè)計(jì)、實(shí)現(xiàn)一個(gè)以數(shù)據(jù)庫(kù)為的應(yīng)用軟件系統(tǒng)二、實(shí)驗(yàn)環(huán)操作系統(tǒng)：Windows開發(fā)工具：Eclipse三、SQL詞法分ALL、AND、ANY、AS、ASC、BY、CREATE、DELETE、DESC、ESCAPEINT、FLOAT、STRING、’>’、’<’、’=’、’>=’、’<=’、’<>’、’(’、’)’、’*’、’.’、變量名（正則表達(dá)式[a-zA-Z]([0-9a-zA-數(shù)據(jù)常量（正則表達(dá)式’true’、’false’、[0-9]+、{[0-9]}*"."{[0-采用jLex語(yǔ)法分析（正規(guī)表達(dá)式SQL語(yǔ)句sql::=;create::=CREATETABLENAME malist|CREATEINDEXONNAMELPARNAME|CREATEVIEWNAMEAS;malist::= malistCOMMA;create_element::=NAMEdata_typePRIMARY|NAME;data_type::=;CREATECREATETABLEtable(IdINTPRIMARYKEY,NameHeightFLOAT)CREATEINDEXONtable(Name)CREATEVIEWtableViewASSELECT*FROMselect::=SELECTMULTIfrom|SELECTselect_listfrom;select_list::=|select_listCOMMA;s_attribute::=|column_nameAS;column_name::=|NAMEDOT;FROM子句from::=FROMfrom_list::=|from_listCOMMA;f_attribute::=|NAME;WHERE子句where::=;|NOT;predicate::=;comparison_predicate::=opEQ|opDY|opXY|opNE|opXD|opDD;like_predicate::=column_nameLIKE|column_nameLIKECONTENTESCAPE;op::=|ANY|ALLorderby|ORDERBY|ORDERBYcolumn_name|ORDERBYcolumn_name;SELECTSELECT*FROMtableWHEREName=’koh’ORinsert::=INSERTINTONAMEVALUESLPARi_values|INSERTINTONAMELPARi_columnsRPARVALUESLPARi_values;i_values::=|i_valuesCOMMA;i_value::=;i_columns::=|i_columnsCOMMA;INSERTINSERTINTOtableINSERTINTOtable(Id,Name,isMale,Height)update::=UPDATENAMESETnew_valuesWHEREnew_values::=|new_valuesCOMMA;new_value::=NAMEEQ|NAMEEQ|NAMEEQ|NAMEEQ;UPDATEUPDATEtableSETHeight=1.80WHEREdelete::=DELETEFROMNAMEWHEREDELETEDELETEFROMtableWHEREDROP語(yǔ)句drop::=DROPTABLE|DROPINDEX|DROPVIEW;DROPDROPTABLEtableDROPINDEXtableIndexDROPVIEWtableViewALTER語(yǔ)句alter::=ALTERTABLENAMEADDNAME|ALTERTABLENAMEDROP;ALTERALTERTABLEtableADDAgeALTERTABLEtableDROP抽象語(yǔ)法SQLSQL語(yǔ)句轉(zhuǎn)化成一個(gè)類（Java中的Class）或基本類型，在表達(dá)式右側(cè)出現(xiàn)的非終結(jié)符會(huì)作} }}}}nditions;Order;}}}}采用javaCup四、前臺(tái)設(shè)界面外Undo:撤銷上一個(gè)Query菜單中所有項(xiàng)目的功能為生成對(duì)應(yīng)的QueryRunQuery:運(yùn)行查詢框中的查詢語(yǔ)LastQueriesQuery上的按鍵功能依次為WorkspaceHistroyQuery用于輸入用戶想要執(zhí)行的Query，Query中可以SQL語(yǔ)句的關(guān)鍵字動(dòng)態(tài)InformationInformation中顯示一些對(duì)系統(tǒng)的統(tǒng)計(jì)信Console ResultResult用來(lái)顯示Query的結(jié)Operation下方功能依次為:Operation在此種畫面下用來(lái)新建五、系統(tǒng)整工作區(qū)的系統(tǒng)的目錄結(jié)構(gòu)由TableMapIndexMapV