設(shè)計數(shù)據(jù)庫課程設(shè)計(Java實現(xiàn))

1、設(shè)計數(shù)據(jù)庫課程設(shè)計(java實現(xiàn))一、課程設(shè)計目的在數(shù)據(jù)庫原理課程根底上，培育同學綜合運用數(shù)據(jù)庫學問的力量。學會數(shù)據(jù)庫的設(shè)計、規(guī)劃以及應用程序的開發(fā)和調(diào)試，使同學把握客戶機/效勞器體系構(gòu)造，學會大型數(shù)據(jù)庫的工作形式。大型數(shù)據(jù)庫管理系統(tǒng)存放于效勞器，數(shù)據(jù)庫放在效勞器上，同學在客戶機上開發(fā)應用程序訪問效勞器上的數(shù)據(jù)庫，并完成應用系統(tǒng)所要求的各項功能，應用程序的開發(fā)需要采納當前流行的新軟件。二、課程設(shè)計內(nèi)容1數(shù)據(jù)庫的設(shè)計依據(jù)同學信息管理系統(tǒng)，經(jīng)過調(diào)查討論，構(gòu)建合理的數(shù)據(jù)庫。首先構(gòu)建根本表以及表和表之間的聯(lián)絡(luò)，在此根底上構(gòu)建視圖和索引表。2效勞器的組織依據(jù)建立的根本表、視圖和索引表搭建效勞器。3】4前

2、端開發(fā)工具：java學習并完成編寫程序。效勞器端：sql server20125開發(fā)應用程序利用所學的新軟件開發(fā)工具進展應用程序的開發(fā)。6連接、調(diào)試。三、軟硬件環(huán)境及系統(tǒng)所采納的體系構(gòu)造系統(tǒng)的體系構(gòu)造為c/s構(gòu)造，詳細開發(fā)工具為ecplise ，前臺為java，后臺數(shù)據(jù)庫一般為sql server2012?！舅?、需求分析通過對同學信息管理的理解，確定本系統(tǒng)具備一下功能。多用戶賬號登錄只要通過用戶登錄驗證后，能對同學的記錄信息進展修改，增加，刪除等操作。五、系統(tǒng)設(shè)計1系統(tǒng)構(gòu)造圖$?a.功能模塊圖 | * 2數(shù)據(jù)庫設(shè)計同學包含的信息： ! "n m!login表usestudent*go

3、set ansi_nulls ongoset quoted_identifier ongo同學宿舍住址電話性別同學課程選擇用戶用戶名密碼create tabledbo.login(usernamenvarchar(20)not null,passwordnvarchar(10)null,constraintpk_loginprimary key clustered(usernameasc)with (pad_index=off,statistics_norecompute=off,ignore_dup_key=off,allow_row_locks =on,allow_page_locks=o

4、n)onprimary)onprimarygostudentifor表usestudentgoset ansi_nulls ongoset quoted_identifier ongocreate tabledbo.studentifor(codenvarchar(10)not null,，namenvarchar(10)not null,sexnchar(2)not null,roomnvarchar(10)not null,addressnvarchar(50)null,telnvarchar(11)null,constraintpk_studentinforprimary key clu

5、steredcodeasc：)with (pad_index=off,statistics_norecompute=off,ignore_dup_key=off,allow_row_locks =on,allow_page_locks=on)onprimary)onprimarygocrouse表create tabledbo.course(courseidnchar(5)not null,coursenamenvarchar(40)not null,constraintpk_courseprimary key clustered(courseidasc)with (pad_index=off

6、,statistics_norecompute=off,ignore_dup_key=off,allow_row_locks =on,allow_page_locks=on)onprimary)onprimarygostudent_crouse表create tabledbo.student_course(codenvarchar(10)not null,courseidnchar(5)not null,coursegradefloatnull,constraintpk_student_courseprimary key clustered：codeasc,courseidasc)with (

7、pad_index=off,statistics_norecompute=off,ignore_dup_key=off,allow_row_locks =on,allow_page_locks=on)onprimary)onprimarygo六、系統(tǒng)的施行系統(tǒng)的實現(xiàn)方法是用java結(jié)合sqlserver2012，用java編寫前端的用戶界面主要的界面代碼如下：public class windows implements actionlistenerprivate jframe frame;private jlabel label;private jtextfield textfield;pr

8、ivate jlist list;private jscrollpane jscrollpane;private defaultlistmodel listmodel;private jradiobutton mjradiobutton, fjradiobutton;private buttongroup setbuttongrop;private jbutton button;private jbutton jbu;private container con;private resultset resultset;private string sinfor = "* 學號:&quo

9、t;,"* 姓名:","* 性別:","*宿舍:","住址:","電話:"private string binfor = "增加","刪除","修改","查找","上一條","下一條"public windows() frame = new jframe("同學信息管理 ");con = ();(null);(350, 150);"(7770/15

10、, 6000/15);(false);textfield = new jtextfield6;label = new jlabel6;button = new jbutton6;for(int i = 0; iprivate void clicktwo(object value)string str = null;resultset re;select se;str = ().substring(0, 8);();se = new select();re = (str);·try textfield0.settext( ("code");textfield1.se

11、ttext("name");if("sex").equals("女 ") = true)(true);else(true);textfield3.settext("room");，textfield4.settext("address");textfield5.settext("tel"); catch (sqlexception e) ();();【public void actionperformed(actionevent e) string code = null,

12、name = null, sex = "", room = null, address =null, tel = null;if() = button0)code = textfield0.gettext();name = textfield1.gettext();enumeration en=();while()abstractbutton ab=();if()sex = ();room = textfield3.gettext();address = textfield4.gettext();tel = textfield5.gettext();();();();();

13、();if("")!= trueselect se = new select();resultset = ();listmodel = new defaultlistmodel();try while() ("code") +" "+ ("name");% catch (sqlexception e1) ();(listmodel);();for(int i = 0; ideli = (frame, "請輸入刪除的學號:");if(deli != null)();if("")

14、 != true)if(new deleteinfor(deli).studentdel() = true) $(frame, "刪除勝利");select se = new select();resultset = ();listmodel = new defaultlistmodel();try while()：("code") +" "+ ("name"); catch (sqlexception e1) ();(listmodel);();|else(frame, "刪除失敗,請核對信息"

15、;);else(frame, "學號不能為空","錯誤",;if() = button2)code = textfield0.gettext();name = textfield1.gettext();enumeration en=();while()abstractbutton ab=();if()sex = ();(room = textfield3.gettext();address = textfield4.gettext();tel = textfield5.gettext();();();();();；();if("")!

16、= trueselect se = new select();resultset = ();listmodel = new defaultlistmodel();:try while()("code") +" "+ ("name"); catch (sqlexception e1) ();，(listmodel);();else(frame, "修改失敗,請核對信息","錯誤",;else(frame, "填入信息不全,請核對","警告",;【if() =

17、 button3)resultset s;select sall;string seach = null;seach = (frame, "請輸入查找的學號:");if(seach != null)();if("") != true)sall = new select();s = (seach);try for(int i = 0; i < 6; i+)#if(i = 2)if(3).equals("男")(true);else(true);elsetextfieldi.settext(i+1); catch (headless

18、exception e1) (); catch (sqlexception e1) (frame, "查找的同學記錄不存在:");();else(frame, "學號不能為空","錯誤",;if() = button4)jscrollbar jsscrobar;int lis;lis = ();if(lis = -1)(0);jsscrobar = ();(0);else(lis - 1);jsscrobar = ();(lis * 10 - 1);if() = button5)int lis;jscrollbar jsscrobar;lis = ();(lis + 1);jsscrobar = ();(lis * 10 + 1);if() = jbu)code = textfield0.gettext();if(code != null)();if("") != true)new crouseframe(code);else(frame, "學號不能為空");七、系統(tǒng)評價及心得體會1改良方案本次試驗中，自己設(shè)計的程序功能上存在缺乏的地方，如查詢時有限制格式，沒有很好的容錯性，代碼強健性缺乏，沒有詳細的應用價值。同時代碼執(zhí)行的效率也是還有進步的空間的，沒有很好的算法參加