數(shù)據(jù)結(jié)構(gòu)課程設(shè)計報告(簡易英漢詞典系統(tǒng))

1、廣西大學(xué)課程設(shè)計報告課程： 數(shù)據(jù)結(jié)構(gòu)題目：簡易英漢詞典系統(tǒng)學(xué) 院：_計算機與電子信息學(xué)院_ 專 業(yè)：_計網(wǎng)類_ 班 級：_計網(wǎng)071_ _ _ 學(xué) 號： 0707100103 學(xué)生姓名： 藍冠恒 指導(dǎo)教師：_ _ 二九 年 四 月一、實驗?zāi)康暮鸵蟆緦嶒災(zāi)康摹吭O(shè)計一個簡易英漢詞典系統(tǒng)，實現(xiàn)基本的單詞檢索功能，即輸入英文單詞則系統(tǒng)輸出其漢語，反之亦然；并能夠進行基本的詞典維護操作，包括插入和刪除，要求按英語的詞典順序排列單詞?！驹O(shè)計要求】（1）使用圖形化界面。（2）建立英語詞匯表，輸入為小寫字母時為合法輸入。（3）每個詞條應(yīng)包含單詞的英語形式、漢語釋義、發(fā)音等基本信息。二、設(shè)計概要：1、根據(jù)實驗

2、要求，與及所了解的數(shù)據(jù)類型相關(guān)知識，定義了如下數(shù)據(jù)類型：鏈接數(shù)據(jù)庫聲明的變量：connection connection = null;statement statement = null;resultset result = null;聲明全局變量：string newword, pronunciations， indexword=, deleteword, searchenglish, searchchinese,issound;它們分別是：新增單詞、新單詞音標(biāo)、引擎詞、刪除詞、查找的英文、查找的漢語、判斷音頻是否存在。2、實驗功能所定義的各種按鈕、文本框、選擇框和列表框：取消刪除功能按鈕

3、：jbutton deletecancelbutton = new jbutton();英漢互譯面板上的發(fā)音按鈕：jbutton sound = new jbutton();瀏覽詞庫面板上的發(fā)音按鈕：jbutton scansoundbutton = new jbutton();添加單詞的按鈕：jbutton addokjbutton = new jbutton();取消添加功能的按鈕：jbutton addcancelbutton = new jbutton();刪除詞庫單詞信息按鈕：jbutton deleteokbutton = new jbutton();瀏覽詞庫按鈕：jbutton

4、scanbutton = new jbutton();要查找的英文或漢語的文本框輸入框：jtextfield inputsearchword = new jtextfield();新增單詞文本輸入框：jtextfield inputnewword = new jtextfield();新增單詞音標(biāo)輸入框：jtextfield pronunciation = new jtextfield();新增單詞釋義輸入框：jtextfield newwordchinese = new jtextfield();新增單詞過去式輸入框：jtextfield newwordpreterite = new jte

5、xtfield();新增單詞現(xiàn)在進行時態(tài)輸入框：jtextfield newwordmodernism = new jtextfield();要刪除的單詞輸入框：jtextfield inputdeleteword = new jtextfield();新增單詞詞性復(fù)選框：jcombobox newwordclass = new jcombobox();列出要查找的詞的記錄信息的多行文本框：textarea outputsearchenglish = new textarea();列出要刪除的單詞的記錄信息的多行文本框：textarea deletewordchinese = new text

6、area();列出瀏覽時需瀏覽單詞信息的多行文本框： textarea scanoutput = new textarea();defaultlistmodel model = new defaultlistmodel(); 列出所查找的英文或漢語對應(yīng)的單詞的列表框：jlist listsearchenglish = new jlist(model);列出備選英標(biāo)的列表框：jlist pronunciationjlist = new jlist(listitem);列出可能且可以被刪除的單詞的列表框：jlist deletejlist = new jlist(model);列出詞庫所有單詞的列

7、表框： jlist scanwordjlist = new jlist(model);3、實現(xiàn)功能所定義的各種函數(shù)：1）public static string return(string str) 將數(shù)據(jù)庫里的單詞的音標(biāo)進行還原。因為有些音標(biāo)不能正確存入數(shù)據(jù)庫，只能以其它字符代替，讀取時再還原。2）public void play(string word) 播放單詞word的音頻。3）public void inputsearch_caretupdate(caretevent e) 當(dāng)inputsearch(注：要查找的詞)輸入框值改變時，listsearchenglish（注：列出查找結(jié)果

8、）列表框和outputsearchenglish（注：寫出單詞信息）文本輸出框被清空，取inputsearch輸入框值賦給indexword，如果indexword不為空，連接數(shù)據(jù)庫；再判斷要查找的是英語，還是漢語，根據(jù)判斷結(jié)果進行查找，并將結(jié)果集按升序排列，輸出到listsearchenglish列表框4）public void listsearchenglish_mouseclicked(mouseevent me) 當(dāng)鼠標(biāo)單擊listsearchenglish列表框時，取所選選項的值賦給變量searchenglish，去掉其兩端空格，outputsearchenglish文本輸出框被清空

9、，發(fā)音按鈕變成灰白色，從數(shù)據(jù)庫讀取要查找的單詞，將其音標(biāo)進行還原，將單詞信息輸出到outputsearchenglish文本框，如果可以發(fā)音，發(fā)音按鈕變紅色，否則indexword被賦給空值5）public void sound_actionperformed(actionevent e) 如果查找單詞有音頻且查找詞不為空，則可發(fā)音，否則按鈕變?yōu)榛野咨?）public void inputnewword_caretupdate(caretevent e) 一旦輸入的新單詞字母不是小寫字母或空格時，彈出提示框7）public void pronunciation_caretupdate(care

10、tevent e) 對輸入的音標(biāo)進行處理，因為字符u0254、u01dd、u00e6 存入數(shù)據(jù)庫時會變成？或出錯，所以用0、1、2、4分別代替他們，讀取時通過調(diào)用return函數(shù)還原,且將音標(biāo)兩端和中間空格去掉8）public void pronunciationjlist_mouseclicked(mouseevent me) 當(dāng)在音標(biāo)選項列表單擊鼠標(biāo)選擇音標(biāo)時，將所選音標(biāo)輸入音標(biāo)輸入框9）public void addokjbutton_actionperformed(actionevent e) 讀取未讀取的輸入框的字符，去掉單詞、注釋各自兩端空格，并將去掉它們各自中間兩個或兩個以上的空

11、格留一個空格，接著在數(shù)據(jù)庫查找添加的單詞是否已存在，若已存在，彈出提示框，不能再添加，否則向數(shù)據(jù)庫添加新單詞信息，最后清空所有輸入框10）public void addcancelbutton_actionperformed(actionevent e)點擊添加取消按鈕，新增面板所有輸入框被清空11）public void inputdeleteword_caretupdate(caretevent e)當(dāng)inputdeleteword輸入框值改變時，清空deletejlist列表框，讀取inputdeleteword輸入框值賦給變量deleteword，按模糊查找法查找以deleteword

12、的值開頭的所有單詞，按升序排列，并將他們輸出到deletejlist列表框12）public void deletejlist_mouseclicked(mouseevent me) 當(dāng)在deletejlist列表框單擊選項時，讀取選項值賦給deleteword變量，并去掉其兩端空格，向inputdeleteword輸入框輸入deleteword變量值，接著從數(shù)據(jù)庫讀取要刪除的單詞的信息，如某屬性不為空，將其輸入到eletewordchinese多行文本框13）public void deleteokbutton_actionperformed(actionevent e) 單擊刪除按鈕，如果

13、輸入框為空，則彈出提示框，否則從數(shù)據(jù)庫中刪除要刪除的單詞的所有記錄14）public void deletecancelbutton_actionperformed(actionevent e) 單擊取消按鈕，inputdeleteword、deletewordchinese都被清空15）public void scanbutton_actionperformed(actionevent e) 單擊瀏覽按鈕，scanwordjlist列表框被清空，然后從數(shù)據(jù)庫讀取所有單詞，按升序排列；然后將所得結(jié)果集輸入到scanwordjlist列表框16）public void scanwordjlist

14、_mouseclicked(mouseevent me) 當(dāng)鼠標(biāo)單擊scanwordjlist列表框時，取所選選項的值賦給變量ndexword，去掉其兩端空格，scanoutput文本框被清空，發(fā)音按鈕變成灰白色，從數(shù)據(jù)庫讀取要查找的單詞（indexword的值），將其音標(biāo)進行還原，將單詞信息輸出到scanoutput文本框，如果可以發(fā)音，發(fā)音按鈕變紅色，否則indexword被賦給空值17）public void soundbutton_actionperformed(actionevent e) 如果查找單詞有音頻且查找詞不為空，則可發(fā)音，否則按鈕變?yōu)榛野咨?、程序模塊流程圖開始英漢互譯是

15、否輸入？是否是英文查找英文查找漢譯列出找到的單詞單擊？列出單詞信息清空列表框和多行文本框是否找到顯錯錯誤添加詞匯輸入單詞？是否合法彈出提示信息是否選擇備選音標(biāo)寫入音標(biāo)輸入框單擊添加按鈕輸入單詞？彈出警告成功？顯示錯誤提示成功單擊取消按鈕清空所有輸入框是否已存在保存所有信息不能添加可否發(fā)音結(jié)束發(fā)音按鈕變紅結(jié)束ynyynyynnynyyyny單擊發(fā)音刪除詞匯輸入？模糊查找是否匹配列出找到的單詞單擊選擇？列出單詞信息并把單詞寫入輸入框點擊刪除按鈕是否有單詞彈出提示信息刪除該單詞點擊取消按鈕清空各框內(nèi)內(nèi)容瀏覽詞庫按升序列出詞庫單詞是否被單擊列出單詞信息可否發(fā)音發(fā)音按鈕變紅單擊瀏覽按鈕發(fā)音按鈕是否紅結(jié)束

16、結(jié)束ynynyynnyyny單擊發(fā)音四、具體程序設(shè)計代碼package languanhengdictionary;import java.awt.borderlayout;import java.sql.*;import java.io.file;import java.io.ioexception;import javax.sound.sampled.audiosystem;import javax.sound.sampled.lineunavailableexception;import javax.sound.sampled.unsupportedaudiofileexception;

17、import javax.sound.sampled.audioinputstream;import javax.sound.sampled.audioformat;import javax.sound.sampled.sourcedataline;import javax.sound.sampled.dataline;import javax.swing.jframe;import javax.swing.jtabbedpane;import java.awt.rectangle;import javax.swing.jpanel;import javax.swing.jlabel;impo

18、rt java.awt.font;import java.awt.color;import javax.swing.jtextfield;import javax.swing.jbutton;import java.awt.event.actionevent;import java.awt.event.actionlistener;import javax.swing.jtextarea;import java.awt.textarea;import java.awt.dimension;import java.awt.choice;import java.awt.event.itemeven

19、t;import java.awt.event.itemlistener;import java.awt.checkbox;import javax.swing.jcombobox;import javax.swing.jlist;import javax.swing.joptionpane;import java.awt.*;import javax.swing.jscrollpane;import java.awt.event.mouseadapter;import java.awt.event.mouseevent;import javax.swing.defaultlistmodel;

20、import java.awt.event.hierarchylistener;import java.awt.event.hierarchyevent;import javax.swing.event.caretlistener;import javax.swing.event.caretevent;import javax.swing.border.titledborder;import javax.swing.uimanager;import javax.swing.borderfactory;import java.io.*;import javax.swing.border.bord

21、er;public class englishframe extends jframe connection connection = null; statement statement = null; resultset result = null; public englishframe() try jbinit(); catch (exception exception) exception.printstacktrace(); private void jbinit() throws exception getcontentpane().setlayout(null); mainjp.

22、setfont(new java.awt.font(宋體, font.plain, 25); mainjp.setforeground(new color(0, 242, 118); mainjp.setborder(titledborder1); mainjp.settooltiptext(); mainjp.setbounds(new rectangle(2, 51, 543, 295); searchenglishorchinesejp.setlayout(null); addwordjp.setlayout(null); deletejp.setlayout(null); scanst

23、ock.setlayout(null); jlabel2.setfont(new java.awt.font(宋體, font.plain, 20); jlabel2.setforeground(new color(0, 180, 62); jlabel2.settext(輸入引擎詞); jlabel2.setbounds(new rectangle(8, 16, 106, 43); inputsearchword.setfont(new java.awt.font(宋體, font.plain, 20); jscrollpane1.setbounds(new rectangle(118, 6

24、0, 145, 178); listsearchenglish.setfont(new java.awt.font(宋體, font.plain, 20); listsearchenglish.setforeground(color.blue); listsearchenglish.setselectionbackground(new color(51, 255, 104); outputsearchenglish.setfont(new java.awt.font(宋體, font.plain, 20); outputsearchenglish.setbounds(new rectangle

25、(267, 59, 227, 179); jlabel4.setfont(new java.awt.font(宋體, font.plain, 25); jlabel4.setforeground(new color(0, 180, 0); jlabel4.settext(新單詞); jlabel4.setbounds(new rectangle(6, 9, 81, 34); inputnewword.setfont(new java.awt.font(宋體, font.plain, 20); inputnewword.setbounds(new rectangle(93, 11, 155, 3

26、4); jlabel5.setfont(new java.awt.font(宋體, font.plain, 25); jlabel5.setforeground(new color(0, 159, 14); jlabel5.settext(發(fā) 音); jlabel5.setbounds(new rectangle(6, 118, 76, 33); jlabel6.setfont(new java.awt.font(宋體, font.plain, 25); jlabel6.setforeground(new color(0, 173, 55); jlabel6.settext(詞 性); jla

27、bel6.setbounds(new rectangle(7, 63, 81, 35); pronunciation.setfont(new java.awt.font(arial unicode ms, font.plain,20); pronunciation.setbounds(new rectangle(92, 119, 154, 36); newwordclass.setbounds(new rectangle(95, 62, 154, 36); jscrollpane3.setbounds(new rectangle(93, 156, 154, 79); jlabel7.setfo

28、nt(new java.awt.font(宋體, font.plain, 25); jlabel7.setforeground(new color(0, 208, 48); jlabel7.settext(注 釋); jlabel7.setbounds(new rectangle(267, 9, 72, 34); newwordchinese.setfont(new java.awt.font(宋體, font.plain, 20); newwordchinese.setbounds(new rectangle(354, 11, 164, 34); jlabel8.setfont(new ja

29、va.awt.font(宋體, font.plain, 25); jlabel8.setforeground(new color(0, 187, 0); jlabel8.settooltiptext(); jlabel8.settext(過去式); jlabel8.setbounds(new rectangle(264, 62, 77, 32); newwordpreterite.setfont(new java.awt.font(宋體, font.plain, 20); newwordpreterite.setbounds(new rectangle(353, 61, 164, 36); j

30、label9.setfont(new java.awt.font(宋體, font.plain, 25); jlabel9.setforeground(new color(0, 187, 21); jlabel9.settext(現(xiàn)代式); jlabel9.setbounds(new rectangle(263, 122, 75, 31); newwordmodernism.setfont(new java.awt.font(宋體, font.plain, 20); newwordmodernism.setbounds(new rectangle(353, 121, 163, 37); add

31、okjbutton.setbounds(new rectangle(261, 179, 83, 40); addokjbutton.setfont(new java.awt.font(宋體, font.plain, 20); addokjbutton.settext(確定); addcancelbutton.setbounds(new rectangle(407, 182, 83, 37); addcancelbutton.setfont(new java.awt.font(宋體, font.plain, 20); addcancelbutton.settext(取消); jlabel10.s

32、etfont(new java.awt.font(宋體, font.plain, 25); jlabel10.setforeground(new color(0, 187, 62); jlabel10.settext(輸入詞匯); jlabel10.setbounds(new rectangle(6, 33, 107, 34); inputdeleteword.setfont(new java.awt.font(宋體, font.plain, 20); inputdeleteword.setbounds(new rectangle(112, 31, 186, 37); deletewordch

33、inese.setfont(new java.awt.font(宋體, font.plain, 20); deletewordchinese.setbounds(new rectangle(112, 69, 185, 168); jscrollpane4.setbounds(new rectangle(297, 31, 139, 206); deletejlist.setfont(new java.awt.font(宋體, font.plain, 20); deletejlist.setforeground(color.blue); deletejlist.setselectionbackgr

34、ound(new color(51, 255, 0); deleteokbutton.setbounds(new rectangle(437, 31, 83, 38); deleteokbutton.setfont(new java.awt.font(楷體, font.plain, 20); deleteokbutton.setforeground(new color(0, 187, 55); deleteokbutton.settext(刪除); scanbutton.setforeground(new color(0, 214, 0); scanbutton.settext(瀏覽); js

35、crollpane5.setbounds(new rectangle(25, 59, 146, 178); scanoutput.setcolumns(5); scanoutput.setfont(new java.awt.font(宋體, font.plain, 20); scanoutput.setbounds(new rectangle(188, 60, 315, 177); scanwordjlist.setfont(new java.awt.font(宋體, font.plain, 20); scanwordjlist.setforeground(color.blue); scanw

36、ordjlist.setselectionbackground(color.green); jlabel11.setfont(new java.awt.font(楷體, font.plain, 45); jlabel11.setforeground(new color(0, 255, 138); jlabel11.settext(歡迎訪問詞庫); jlabel11.setbounds(new rectangle(197, 8, 287, 40); deletecancelbutton.setbounds(new rectangle(437, 96, 83, 34); deletecancelb

37、utton.setfont(new java.awt.font(楷體, font.plain, 20); deletecancelbutton.setforeground(new color(0, 221, 42); deletecancelbutton.settooltiptext(); deletecancelbutton.settext(取消); pronunciationjlist.setselectionbackground(new color(51, 255, 125); sound.setbounds(new rectangle(420, 24, 74, 33); sound.s

38、etfont(new java.awt.font(宋體, font.plain, 20); sound.settooltiptext(); sound.settext(發(fā)音); inputsearchword.setbounds(new rectangle(117, 24, 302, 35); scanbutton.setbackground(new color(240, 240, 240); scanbutton.setfont(new java.awt.font(宋體, font.plain, 20); scansoundbutton.setbounds(new rectangle(110

39、, 15, 79, 37); scansoundbutton.setfont(new java.awt.font(宋體, font.plain, 20); scansoundbutton.settext(發(fā)音); scanbutton.setbounds(new rectangle(27, 14, 78, 38); this.getcontentpane().add(mainjp); searchenglishorchinesejp.add(jlabel2); searchenglishorchinesejp.add(jscrollpane1); searchenglishorchinesej

40、p.add(outputsearchenglish); searchenglishorchinesejp.add(inputsearchword); searchenglishorchinesejp.add(sound); jscrollpane1.getviewport().add(listsearchenglish); mainjp.add(searchenglishorchinesejp, 英漢互譯); mainjp.add(addwordjp, 添加詞匯); addwordjp.add(jlabel4); addwordjp.add(inputnewword); addwordjp.a

41、dd(jlabel7); addwordjp.add(newwordchinese); addwordjp.add(newwordclass); addwordjp.add(jlabel6); addwordjp.add(newwordpreterite); addwordjp.add(jlabel5); addwordjp.add(jlabel9); addwordjp.add(newwordmodernism); addwordjp.add(jscrollpane3); addwordjp.add(pronunciation); addwordjp.add(addokjbutton); a

42、ddwordjp.add(addcancelbutton); addwordjp.add(jlabel8); jscrollpane3.getviewport().add(pronunciationjlist); mainjp.add(deletejp, 刪除詞匯); deletejp.add(jlabel10); deletejp.add(inputdeleteword); deletejp.add(deletewordchinese); deletejp.add(jscrollpane4); deletejp.add(deleteokbutton); deletejp.add(delete

43、cancelbutton); jscrollpane4.getviewport().add(deletejlist); mainjp.add(scanstock, 瀏覽詞庫); scanstock.add(jscrollpane5); jscrollpane5.getviewport().add(scanwordjlist); scanstock.add(scanbutton); scanstock.add(scanoutput); scanstock.add(jlabel11); scanstock.add(scansoundbutton); this.getcontentpane().ad

44、d(jlabel1); jlabel1.setfont(new java.awt.font(楷體, font.plain, 45); jlabel1.setforeground(color.blue); jlabel1.settext(藍氏簡易英漢詞典); jlabel1.setbounds(new rectangle(107, 5, 374, 47); newwordclass.additem(n. 名詞); newwordclass.additem(adj. 形容詞); newwordclass.additem(adv. 副詞); newwordclass.additem(num. 量詞)

45、; newwordclass.additem(v. 動詞); newwordclass.additem(vi. 不及物動詞); newwordclass.additem(vt. 及物動詞); newwordclass.additem(短語); pronunciationjlist.setlayoutorientation(pronunciationjlist.horizontal_wrap); this.setsize(new dimension(560, 385); /第一個參/為長度，第二個參數(shù)為高度/-英漢互譯模塊函數(shù)調(diào)用-/ /發(fā)音按鈕監(jiān)聽器 sound.addactionlisten

46、er(new actionlistener() public void actionperformed(actionevent e) sound_actionperformed(e); ); /查找輸入框監(jiān)聽器 inputsearchword.addcaretlistener(new caretlistener() public void caretupdate(caretevent e) inputsearch_caretupdate(e); ); /查找單詞列表監(jiān)聽器 listsearchenglish.addmouselistener(new mouseadapter() public

47、void mouseclicked(mouseevent e) listsearchenglish_mouseclicked(e); );/-添加面板模塊函數(shù)調(diào)-/ /新單詞輸入框監(jiān)聽器 inputnewword.addcaretlistener(new caretlistener() public void caretupdate(caretevent e) inputnewword_caretupdate(e); ); /新單詞音標(biāo)輸入框監(jiān)聽器 pronunciation.addcaretlistener(new caretlistener() public void caretupdat

48、e(caretevent e) pronunciation_caretupdate(e); ); /音標(biāo)選擇列表鼠標(biāo)監(jiān)聽器 pronunciationjlist.addmouselistener(new mouseadapter() public void mouseclicked(mouseevent e) pronunciationjlist_mouseclicked(e); ); /添加按鈕監(jiān)聽器 addokjbutton.addactionlistener(new actionlistener() public void actionperformed(actionevent e) addokjbutton_actionperformed(e); ); / 取消添加單詞按鈕監(jiān)聽器 addcancelbutton.addactionlistener(new actionlistener() public void actionperformed(actionevent e) addcancelbutton_actionperformed(e); ); /-刪除模塊函數(shù)調(diào)用-/ /刪除單詞輸入框監(jiān)聽器 inputdeleteword.addcaretlistener(