1、一、設(shè)計目的2二、功能介紹2三、程序流程23.1總流程2流程圖3四、設(shè)計步驟34.1數(shù)據(jù)庫設(shè)計34.1.1學(xué)生信息表34.1.2教師表4課程表4成績表44.2功能描述5登錄54.2.2教師端8學(xué)生端9五、設(shè)計總結(jié)10六、程序活單10七、參考文獻(xiàn)22、設(shè)計目的1具有新用戶注冊功能。2具有注冊用戶登錄功能。3具有學(xué)生成績的錄入功能，要求只錄入各科成績，自動計算每個學(xué)生的總績。4具有數(shù)據(jù)查詢功能，可以實(shí)現(xiàn)查詢?nèi)啃畔⒑桶礂l件執(zhí)行查詢。5具有按條件刪除數(shù)據(jù)功能。、功能介紹學(xué)生信息管理系統(tǒng)分為兩個模塊，教師端和學(xué)生端，（1）教師端包括的子模塊有：教師注冊，教師添加學(xué)生成績，教師修改學(xué)生成績，教師刪除學(xué)生

2、成績，教師修改登錄密碼等主要功能。（2）學(xué)生端：本模塊的功能較少，只有學(xué)生查詢本人成績，和修改學(xué)生登錄密碼的功能三、程序流程N(yùn)四、設(shè)計步驟4.1數(shù)據(jù)庫設(shè)計本次設(shè)計數(shù)據(jù)庫使用SQLSever2005,一共四張表，分別為學(xué)生信息表，教師信息表，還有學(xué)生成績表，教師所教的課程表學(xué)生信息表學(xué)生信息表包括學(xué)生姓名，學(xué)號，登錄密碼，性別，年齡，還有一個沒有關(guān)系的主鍵，如圖_數(shù)據(jù)類型允許空希!IntBnamevarchar(SO)pwdvarctiarpO)numvardiar50)sexvanar(5O)圜agevardnar(50)ffl圖4-1教師表教師信息表包括教師姓名，教師編號，教師登錄密碼和所教

3、授的課程，和一個沒有關(guān)系的主鍵，用來自動增長。如圖4-2。列名數(shù)據(jù)類型允許空卜Ndnintnamevarchar(5O)pwdvardiarfO)numvarchar(5O)ctassesvardir(5O)圖4-2課程表課程表為教師所教的課程，其中包括課程編號，課程名，課程學(xué)分等。如圖4-3列名教據(jù)類型id_-”一!nrilllrvilliivi|jj|IHfJintBHUMvarchar(EO)0namevarcharfSO)EJxuefenvarchar(5&)0圖4-3成績表成績表是教師上成績之后，所有成績儲存在成績表中，其中包括課程，學(xué)分，學(xué)生編號，學(xué)期等。如圖4-4頂坦_教據(jù)類型元

4、許空質(zhì)jid_IbitEkemuvarcharfSU)SscorevarchdrM0numvarchrfSO)囹xueqivardiar(5(J)0圖4-44.2功能描述登錄當(dāng)程序運(yùn)行的時候，會出現(xiàn)如圖4-5的登錄，然后根據(jù)提示進(jìn)行選擇操作,輸入賬號和密碼，選擇登錄的類型，登錄界面還有注冊新用戶和修還密碼等功能圖4-5登錄代碼如下:if(!name.equals()ifandpwd=(!pwd.equals()if(!type.equals(if(type.equals(sql=Select;選擇類型)學(xué)生)*fromstudentwherenumiftry(type.equals(教師”)s

5、ql=Select*fromteacherwherenum=+name+andpwd=+rs=db.Query(sql);while(rs.next()pwd;+pwd+name);num);教師)name1=rs.getString(num=rs.getString(if(type.equals(+name+classes=rs.getString(classes);catch(SQLExceptione1)e1.printStackTrace();if(!namel.equals()if(type.equals(學(xué)生）Login.this.close();tryDisplaydisplay

6、=Display.getDefault();studentshell=newstudent(display);shell.open();shell.layout();while(!shell.isDisposed()if(!display.readAndDispatch()display.sleep();)catch(Exceptione1)(e1.printStackTrace();)if(type.equals(教師)Login.this.close();tryDisplaydisplay=Display.getDefault();AddChengshell=newAddCheng(dis

7、play);shell.open();shell.layout();while(!shell.isDisposed()if(!display.readAndDispatch()display.sleep();)catch(Exceptione1)e1.printStackTrace();)elseMessageDialog.openError(getShell(),提示，用戶名密碼錯誤)；)elseMessageDialog.openWarning(getShell(),提示，你還沒選擇登錄類型)；)elseMessageDialog.openWarning(getShell(),提示，密碼不

8、能為空)；)elseMessageDialog.openWarning(getShell(),提示，用戶名為空)；)修改密碼功能修改在此登錄的用戶，修改密碼的用戶必須輸入原密碼，和新密碼才能進(jìn)行密碼的修改。如圖4-6修改密碼4-6修改密碼代碼如下:.getText()+where(getShell(),提示提示,修改密碼Stringsql=updateteachersetpwd=+text_1num=+Login.num+;booleanb=MessageDialog.openQuestion,是否修改密碼)；if(b)db.Update(sql);MessageDialog.openWarn

9、ing(getShell(),成功);注冊用戶功能點(diǎn)擊進(jìn)入注冊用戶的功能后，進(jìn)行相應(yīng)的提示進(jìn)行操作，填入對應(yīng)的教師的信息后點(diǎn)擊添加就可以成功的注冊一個新的用戶了，在進(jìn)行相關(guān)的操作，如圖4-7注冊圖4-7注冊新用戶代碼如下:if(!text(iin+text+text.getText().equals()if(!text_1.getText().equals(if(!text_2.getText().equals(!text_3.getText().equals(Stringsql=+text2.getText()+3.getText()+HlIIIMessageDialog.提示，注冊成功if

10、)openQuestion);)insertintoteachervalues.getText()+,+text_1.getText()+Jbooleanb=(getShell(),(b)db.Update(sql);MessageDialog.openWarning(getShell(),提示,是否注冊);if教師端登錄類型選擇教師，進(jìn)入教師端，此處含有增加，刪除，修改和教師修還密碼等功能，每一步都有相應(yīng)的校驗。選擇功能進(jìn)行操作。增加學(xué)生成績功能進(jìn)入之后會有提示，輸入學(xué)號，成績，學(xué)年等信息，點(diǎn)擊確定完成添加學(xué)生成績的操作。如圖4-8教師端圖4-8教師端代碼如下：if(!num.equals(

11、)(if(!fenshu.equals()(if(!xueqi.equals()(Stringsql=insertinto分?jǐn)?shù)values(+kemu+,+fenshu+,+num+,+xueqi+);db.Update(sql);num=;fenshu=;fenye();MessageDialog.openWarning(getShell(),提示,添加成功);)else(MessageDialog.openError(getShell(),提示,學(xué)期不能為空);)else(MessageDialog.openError(getShell(),提示，分?jǐn)?shù)不能為空)；)else(Message

12、Dialog.openError(getShell(),提示，學(xué)號不能為空);)選擇某個人后點(diǎn)擊鼠標(biāo)右鍵，會出現(xiàn)修改和刪除功能。如圖4-9鼠標(biāo)右鍵功能圖4-9鼠標(biāo)右鍵功能修改學(xué)生成績選擇某個人之后，右鍵選擇修改功能，就會出現(xiàn)如圖4-10的界面，修改學(xué)號和成績后點(diǎn)擊確定，即可修改學(xué)生成績圖4-10修改學(xué)生成績代碼如下：Stringsql=updateteachersetpwd=+text_1.getText()+wherenum=+Login.num+openQuestion,是否修改密碼ifbooleanb=MessageDialog.);(b)(db.Update(sql);MessageD

13、ialog.openWarning(getShell(),(getShell(),成功);刪除學(xué)生成績右鍵選擇刪除學(xué)生成績功能，會出現(xiàn)如圖4-11的詢問框，選擇確認(rèn)，刪除此學(xué)生的成績，點(diǎn)擊否即為取消刪除圖4-11刪除學(xué)生信息代碼如下：Stringsql=booleandeletefromtag=MessageDialog.if成績wherenum=+text_1openQuestion(getShell(),.getText()提示，是否刪);(tag)(db.Update(sql);MessageDialog.openWarning(getShell(),);學(xué)生端學(xué)生端查詢學(xué)生信息的功能，

14、該功能含有按學(xué)年查詢，按科目和查詢?nèi)康裙δ埽x擇功能進(jìn)行操作，如圖4-12圖4-12學(xué)生查詢Select*fromstudentwherenum=+name+andpwd=代碼如下：Stringsql=+pwd+;rs=db.Query(sql);try(while(rs.next()(Tableitemtableitem=newTableitem(table,SWT.tableItem.setText(0,+rs.getString(1);tableitem.setText(1,+rs.getString(2);tableitem.setText(2,+rs.getString(3);ta

15、bleitem.setText(3,+rs.getString(4);tableitem.setText(4,+rs.getString(5);tableitem.setText(4,+rs.getString(6);NONE);)catch(SQLExceptione)(e.printStackTrace();)五、設(shè)計總結(jié)通過幾天的課程設(shè)計使我懂得了理論與實(shí)際相結(jié)合是很重要的，只有理論知識是遠(yuǎn)遠(yuǎn)不夠的，只有把所學(xué)的理論知識與實(shí)踐相結(jié)合起來，從理論中得出結(jié)論，才能真正為社會效勞，從而提高自己的實(shí)際動手能力和獨(dú)立思考的能力。在設(shè)計的過程中遇到問題，可以說得是困難重重，這畢竟第一次真真的做程序設(shè)

16、計，難免會遇到過各種各樣的問題，同時在設(shè)計的過程中發(fā)現(xiàn)了自己的缺乏之處，對一些前面學(xué)過的知識理解得不夠深刻，掌握得不夠牢固，比方說結(jié)構(gòu)體，通過這次課程設(shè)計之后，我們把前面所學(xué)過的知識乂重新溫故了一遍。六、程序清單packageStudent;importjava.sql.ResultSet;publicclassAddChengextendsShellprivateTexttext_1;privateTexttext_2;privateTabletable;privateTexttext;publicintstart=0;publicintpage=1;publicintrow_number=

17、0;publicintmaxPage=0;publicintpageSize=5;Stringxueqi;Stringkemu;Combocombo;DBHelperdb=newDBHelper();ResultSetrs;Stringnum;Labellabel_4;* Launchtheapplication.* paramargs*/publicstaticvoidmain(Stringargs)(try(Displaydisplay=Display.getDefault();AddChengshell=newAddCheng(display);shell.open();shell.la

18、yout();while(!shell.isDisposed()if(!display.readAndDispatch()display.sleep();)catch(Exceptione)e.printStackTrace();)* /*Createtheshell.paramdisplay*/publicAddCheng(Displaydisplay)(super(display,SWT.SHELL_TRIM);Labellabel_8=newLabel(this,SWT.BORDER);label_8.setBounds(223,5,94,17);label_8.setText(Logi

19、1);Labellabel_10=newLabel(this,SWT.NONE);label_10.setBounds(352,294,61,17);label_10.setText(u9875);label_4=newLabel(this,SWT.NONE);label_4.setBounds(325,294,21,17);Labellabel=newLabel(this,SWT.NONE);label.setBounds(21,39,35,17);label.setText(u79D1u76EE);Labellabel_1=newLabel(this,SWT.NONE);lab

20、el_1.setBounds(146,39,30,17);label_1.setText(u5B66u53F7);texttexttext=newText(this,SWT.BORDER|SWT.READ_ONLY);.setBounds(60,39,80,23);.setText(Login.classes);texttext11=newText(this,SWT.BORDER);.setBounds(182,39,94,23);Labellabel_2=newLabel(this,SWT.NONE);label_2.setBounds(282,39,35,17);label_2.setTe

21、xt(u6210u7EE9);text_2text2=newText(this,SWT.setBounds(325,39,94,23);BORDER);combocombo2021-2021-1combocombo=newCombo(this,SWT.setItems(newString(,2021-2021-2);.setBounds(466,39,100,25);.select(1);NONE);2021-2021-12021-2021-2kemu=text.getText();xueqi=combo.getText();values(Buttonbutton=newButton(butt

22、on.addSelectionListener(OverridepublicvoidwidgetSelected(SelectionEvente)(Stringnum=text_1.getText();Stringfenshu=text_2.getText();if(!num.equals()(-if(!fenshu.equals(if(!xueqi.equals(Stringsql=+kemu+,+fenshu+,+num+db.Update(sql);num=;fenshu=;this,SWT.NONE);newSelectionAdapter()()()(insertinto分?jǐn)?shù),+xu

23、eqi+);提示,添fenye();MessageDialog.openWarning(getShell(),加成功);elseMessageDialog.openError(getShell(),提示”，學(xué)期不能為空);空)；);elseMessageDialog.openError(getShell(),提示”，分?jǐn)?shù)不能為elseMessageDialog.openError(getShell(),提示，學(xué)號不能為空);button.setBounds(572,39,80,27);button.setText(u6DFBu52A0);table=newTable(this,SWT.BORD

24、ER|SWT.FULL_SELECTION);table.addSelectionListener(newSelectionAdapter()OverridepublicvoidwidgetSelected(SelectionEvente)TableItemit=table.getSelection();Tableitemi=it0;num=i.getText(O););table.setBounds(61,82,571,193);table.setHeaderVisible(true);table.setLinesVisible(true);TableColumntblclmnNewColu

25、mn_1=newTableColumn(table,SWT.NONE);tblclmnNewColumn_1.setWidth(109);tblclmnNewColumn_1.setText(u7F16u53F7);TableColumntableColumn=newTableColumn(table,SWT.NONE);tableColumn.setWidth(112);tableColumn.setText(u5B66u53F7);Menumenu=newMenu(table);table.setMenu(menu);MenuItemmenuItem=newMenuItem(menu,SW

26、T.NONE);menuitem.setText(u4FEEu6539);MenuItemmenuItem_1=newMenuItem(menu,SWT.NONE);menuitem_1.addSelectionListener(newSelectionAdapter()OverridepublicvoidwidgetSelected(SelectionEvente)booleantag=MessageDialog.openQuestion(getShell(),提示是否刪除)；if(tag);newTableColumn(table,SWT.NONE);menuitem_1.setText(

27、u5220u9664);TableColumntblclmnNewColumn=tblclmnNewColumn.setWidth(108);tblclmnNewColumn.setText(u79D1u76EE）；table,SWT.NONE);table,SWT.NONE);TableColumntableColumn_1=tableColumn_1.setWidth(112);tableColumn_1.setText(TableColumntableColumn_2=tableColumn_2.setWidth(118);tableColumn_2.setText(newTableCo

28、lumn(u6210u7EE9);newTableColumn(u5B66u5E74);+kemu+andxueqi=Stringsql=select*from分?jǐn)?shù)wherekemu=,+xueqi+;rs=db.Query(sql);try(while(rs.next()(row_number+;)catch(SQLExceptione)(e.printStackTrace();if(row_numbermaxPage=else(maxPage=%pageSizerownumberrownumber=0)(pageSizepageSize+1;Buttonbutton_1=newButton

29、(this,SWT.NONE);button_1.addSelectionListener(newSelectionAdapter()(OverridepublicvoidwidgetSelected(SelectionEvente)(if(page-1!=0)(page-;fenye();else(MessageDialog.openError(getShell(),提示，已經(jīng)是第一頁););button_1.setBounds(114,289,80,27);button_1.setText(u4E0Au4E00u9875);Buttonbutton_2=newButton(this,SWT

30、.NONE);button_2.addSelectionListener(newSelectionAdapter()(OverridepublicvoidwidgetSelected(SelectionEvente)(if(pagemaxPage)(page+;fenye();else(MessageDialog.openError(getShell(),提示，已經(jīng)是最后一頁););button_2.setBounds(466,289,80,27);button_2.setText(u4E0Bu4E00u9875);Labellabel_3=newLabel(thislabel_3.setBo

31、unds(425,39,35,17);label_3.setText(u5B66u5E74,SWT.);NONE);Labellabel_5=newLabel(this,SWT.NONE);label_5.setBounds(21,5,61,17);label_5.setText(u6559u5E08u7F16u53F7);Labellabel_6=newLabel(this,SWT.BORDER);label_6.setBounds(88,5,61,17);label_6.setText(Login.num);Labellabel_7=newLabel(this,SWT.NONE);labe

32、l_7.setBounds(167,5,61,17);label_7.setText(u6559u5E08u59D3u540D);Linklink=newLink(this,SWT.NONE);link.addSelectionListener(newSelectionAdapter()OverridepublicvoidwidgetSelected(SelectionEvente)tryDisplaydisplay=Display.getDefault();Changpwdshell=newChangpwd(display);shell.open();shell.layout();while

33、(!shell.isDisposed()if(!display.readAndDispatch()display.sleep();catch(Exceptione1)e1.printStackTrace(););link.setBounds(534,5,53,17);link.setText(u4FEEu6539u5BC6u7801);Linklink_1=newLink(this,SWT.NONE);link_1.addSelectionListener(newSelectionAdapter()OverridepublicvoidwidgetSelected(SelectionEvente

34、)AddCheng.this.close(););link_1.setBounds(611,5,53,17);link_1.setText(u6CE8u9500);Labellabel_9=newLabel(this,SWT.NONE);label_9.setBounds(285,294,61,17);label_9.setText(u7B2C);System.out.println(1);fenye();System.out.println(1);createContents();/*Createcontentsoftheshell.*/protectedtablelabelvoidfeny

35、e().removeAll();4.setText(String.);valueOf(page)+);label_4.setText(page+startStringasc)ask,*fromwheres.k=(page-1)*sql=select分?jǐn)?shù)wherekemu=pageSize;*from(selectrow_number()+kemu+andxueqi=over(orderby+xueqi+)assid+start+ands.k=+(start+pageSize)+System.out.println(sql);rs=db.Query(sql);trywhile(rs.next()

36、Tableitemtableitem=newTableitem(table,SWT.NONE);tableItem.setText(0,+rs.getString(id);tableitem.setText(l,+rs.getString(num);tableitem.setText(2,+rs.getString(kemu);tableitem.setText(3,+rs.getString(score);tableitem.setText(4,+rs.getString(xueqi);* catch(SQLExceptione)e.printStackTrace();protectedvo

37、idcreateContents()setText(u6DFBu52A0u5B66u751Fu6210u7EE9);setSize(690,377);OverrideprotectedvoidcheckSubclass()packageStudent;importorg.eclipse.swt.SWT;publicclassstudentextendsShellprivateTabletable;privateTexttext;privateTexttext_1;/*Launchtheapplication.* paramargs*/publicstaticvoidmain(Stringarg

38、s)tryDisplaydisplay=Display.getDefault();studentshell=newstudent(display);shell.open();shell.layout();while(!shell.isDisposed()if(!display.readAndDispatch()display.sleep();catch(Exceptione)e.printStackTrace();Createtheshell.paramdisplay*/publicstudent(Displaydisplay)super(display,SWT.SHELL_TRIM);tex

39、t_1=newText(this,SWT.BORDER);text_1.setBounds(182,47,89,23);text_1.setText(Ll);Combocombo_1=newCombo(this,SWT.NONE);combo_1.setItems(newStringu5168u90E8u5B66u5E74”2021-2021-1-,2021-2021-2,2021-2021-1,2021-2021-2);combo_1.setBounds(331,47,88,25);combo_1.select(0);Combocombo=newCombo(this,SWT

40、.NONE);combo.setItems(newStringu5168u90E8u79D1u76EEu672Au901Au8FC7,u5DF2u901Au8FC7);combo.setBounds(459,47,88,17);combo.select(0);table=newTable(this,SWT.BORDER|SWT.table.setBounds(40,94,605,222);table.setHeaderVisible(true);table.setLinesVisible(true);newTableColumn(FULL_SELECTION);TableColumntable

41、Column_2=tableColumn_2.setWidth(100);tableColumn_2.setText(TableColumntableColumn_3=tableColumn_3.setWidth(100);tableColumn_3.setText(TableColumntableColumn=tableColumn.setWidth(100);tableColumn.setText(TableColumntableColumn_1=tableColumn_1.setWidth(100);tableColumn_1.setText(u5B66u53F7);newTableCo

42、lumn(u59D3u540D);newTableColumn(u79D1u76EE);newTableColumn(u5206u6570);TableColumntblclmnNewColumn=tblclmnNewColumn.setWidth(100);tblclmnNewColumn.setText(TableColumntableColumn_4=tableColumn_4.setWidth(100);tableColumn_4.setText(table,SWT.NONE);table,SWT.NONE);table,SWT.NONE);table,SWT.NONE);newTab

43、leColumn(table,SWT.NONE);u5B66u5206);newTableColumn(table,SWT.NONE);u5B66u5E74););table,SWT.NONE);TableItemtableItem=tableItem.setText(0,tableItem.setText(1,tableItem.setText(2,tableItem.setText(3,tableItem.setText(4,tableItem.setText(5,newTableItem(041040421);李興國)；java);90);5);2021-2021-2NONE);Labe

44、l(this,SWT.Labellabel=newlabel.setBounds(24,50,33,17);label.setText(u5B66u53F7);Labellabel_2=newLabel(thislabel_2.setBounds(153,50,61,17);label_2.setText(u59D3u540D,SWT.NONE););Labellabel_4=newLabel(thislabel_4.setBounds(425,50,61,17);label_4.setText(u79D1u76EE”,SWT.NONE););Labellabel_5=newLabel(lab

45、el_5.setBounds(287,50,61,17);this,SWT.NONE);label_5.setText(u5B66u5E74）；Buttonbutton=newButton(this,SWT.NONE);button.setBounds(553,45,80,27);button.setText(u67E5u8BE2);Buttonbutton_1=newButton(this,SWT.NONE);button_1.setBounds(140,339,80,27);button_1.setText(u4E0Au4E00u9875);Labellabel_6=newLabel(th

46、is,SWT.NONE);label_6.setBounds(304,344,26,17);label_6.setText(1);ButtonbtnNewButton=newButton(this,SWT.NONE);btnNewButton.setBounds(416,339,80,27);btnNewButton.setText(u4E0Bu4E00u9875);Linklink=newLink(this,SWT.NONE);link.setBounds(533,10,53,17);link.setText(u4FEEu6539u5BC6u7801);Linklink_1=newLink(

47、this,SWT.NONE);link_1.setBounds(603,10,53,17);link_1.setText(u6CE8u9500);text=newText(this,SWT.BORDER);text.setBounds(59,47,88,23);text.setText(Login.num);createContents();*Createcontentsoftheshell.*/protectedvoidcreateContents()(setText(u5B66u751Fu67E5u8BE2);setSize(687,436);Overrideprotectedvoidch

48、eckSubclass()(/DisablethecheckthatpreventssubclassingofSWTcomponentspackageStudent;importorg.eclipse.jface.dialogs.MessageDialog;publicclassregisextendsShell(privateTexttext;privateTexttext_1;privateTexttext_2;privateTexttext_3;DBHelperdb=newDBHelper();* Launchtheapplication.* paramargs*/publicstati

49、cvoidmain(Stringargs)(try(Displaydisplay=Display.getDefault();regisshell=newregis(display);IIIshell.open();shell.layout();while(!shell.isDisposed()if(!display.readAndDispatch()display.sleep();)catch(Exceptione)e.printStackTrace();)/*Createtheshell.paramdisplay*/publicsuperregis(Displaydisplay)(displ

50、ay,SWT.text_3text3text_2text2text_1text1textSHELL_TRIM);=newText(this,SWT.setBounds(166,184,114,23);=newText(this,SWT.setBounds(166,148,114,23);=newText(this,SWT.setBounds(166,109,114,23);BORDER);BORDER|SWT.PASSWORD);BORDER);newText(this,SWT.BORDER);text.setBounds(166,67,114,23);Labellabel_1=newLabe

51、l(thislabel_1.setBounds(85,70,61,17);label_1.setText(u59D3u540DLabellabel_2=newLabel(thislabel_2.setBounds(85,112,61,17);label_2.setText(u7F16u53F7Labellabel_3=newLabel(label_3.setBounds(85,151,61,17);label_3.setText(u5BC6u7801thisLabellabel=newLabel(thislabel.setBounds(85,187,61,17);label.setText(u

52、79D1u76EE,SWT.NONE););,SWT.NONE););,SWT.NONE););,SWT.NONE)；);Labellabel_4=newLabel(this,SWT.CENTER);label_4.setFont(SWTResourceManager.getFont(隸書”，21,SWT.NORMAL);label_4.setBounds(146,10,195,36);label_4.setText(u6CE8u518Cu65B0u7528u6237);Buttonbutton=newButton(this,SWT.NONE);button.addSelectionListe

53、ner(newSelectionAdapter()Overridepublicif(!voidtextif(!widgetSelected(SelectionEvente).getText().equals()text_1if(+text.getText()+xt_3.getText()+)HIIII.getText().equals(!text_2.getText().equals(if(!text_3.getText().equals(Stringsql=+text_2.getText()+)insertintoteachervalues,+text_1.getText()+booleanb=MessageDialog.MessageDialog.openWarning(getShell(),“提openQuestion(g