學(xué)生管理信息系統(tǒng)課程設(shè)計(jì)報(bào)告

1、數(shù)據(jù)庫(kù)系統(tǒng)應(yīng)用課程設(shè)計(jì)課程設(shè)計(jì)報(bào)告 設(shè) 計(jì) 題 目： 學(xué)生成績(jī)管理系統(tǒng)_ 專 業(yè) (方 向)： 信息管理與信息系統(tǒng) 年 級(jí)、 班： xxxxxxxxx 學(xué) 生 學(xué) 號(hào)： xxxxxxxxxx 學(xué) 生 姓 名： XX 指 導(dǎo) 教 師： XXX 12 月 17 日目 錄 TOC o 1-3 h z u HYPERLINK l _Toc 一、概述 表 3所示。表 SEQ 表 * ARABIC 3課程信息表列名數(shù)據(jù)類型長(zhǎng)度備注課程號(hào)Char5主鍵課程名稱String 10無(wú)課程類型string5無(wú)學(xué)分int5無(wú)3.2.4成績(jī)信息表如 REF _Ref h 表 4所示。表 SEQ 表 * ARABIC

2、4成績(jī)信息表列名數(shù)據(jù)類型長(zhǎng)度備注學(xué)號(hào)Char10主鍵課程號(hào)Char5主鍵成績(jī)類型String5無(wú)分?jǐn)?shù)float5無(wú)3.2.5顧客信息表如 REF _Ref h 表 5所示。表 SEQ 表 * ARABIC 5顧客信息表列名數(shù)據(jù)類型長(zhǎng)度備注登錄IDchar5主鍵登錄名String10無(wú)顧客名String 10無(wú)密碼String 10四、具體設(shè)計(jì)（一）、系統(tǒng)管理功能模塊旳實(shí)現(xiàn)創(chuàng)立一種FormSystemMessage窗體，實(shí)現(xiàn)添加顧客、刪除顧客、修改密碼、退出系統(tǒng)旳功能。public partial class FormSystemMessage : Form public FormSystemM

3、essage() InitializeComponent(); private void operatorBindingNavigatorSaveItem_Click(object sender, EventArgs e) this.Validate(); this.operatorBindingSource.EndEdit(); this.tableAdapterManager.UpdateAll(this.dataSetUserPassword); DataSetUserPassword dsp = new DataSetUserPassword(); DataSetUserPasswor

4、dTableAdapters.OperatorTableAdapter dsup = new DataSetUserPasswordTableAdapters.OperatorTableAdapter(); private void FormSystemMessage_Load(object sender, EventArgs e) / TODO: 這行代碼將數(shù)據(jù)加載到表“dataSetUserPassword.Operator”中。您可以根 據(jù)需要移動(dòng)或刪除它。 this.operatorTableAdapter.Fill(this.dataSetUserPassword.Operator)

5、; dsup.Fill(dsp.Operator); dataGridViewSystemMessage.DataSource = dsp.Operator; private void buttonDelete_Click(object sender, EventArgs e) DataSetUserPassword.OperatorRow row = (DataSetUserPassword.OperatorRow) (DataRowView)dataGridViewSystemMessage.CurrentRow.DataBoundItem).Row); if (MessageBox.Sh

6、ow(您擬定要?jiǎng)h除這個(gè)顧客嗎？, 擬定提示) = DialogResult.No) return; row.Delete(); private void buttonAdd_Click(object sender, EventArgs e) if (string.IsNullOrEmpty(nameTextBox.Text) MessageBox.Show(顧客名不能為空, 錯(cuò)誤提示, MessageBoxButtons.OK, MessageBoxIcon.Error); return; if (string.IsNullOrEmpty(passwordTextBox.Text) Messa

7、geBox.Show(密碼不能為空, 錯(cuò)誤提示, MessageBoxButtons.OK, MessageBoxIcon.Error); return; DataSetUserPassword.OperatorRow row = dsp.Operator.NewOperatorRow(); row.Name = nameTextBox.Text; row.Password = passwordTextBox.Text; dsp.Operator.AddOperatorRow(row); private void buttonSave_Click(object sender, EventArg

8、s e) try dsup.Update(dsp.Operator); MessageBox.Show(數(shù)據(jù)保存成功, 提示信息, MessageBoxButtons.OK, MessageBoxIcon.Information); catch (Exception ex) MessageBox.Show(ex.Message, 提示信息, MessageBoxButtons.OK, MessageBoxIcon.Error); private void buttonExit_Click(object sender, EventArgs e) Application.Exit(); （二）、學(xué)

9、生信息管理模塊旳實(shí)現(xiàn)4.2.1.“學(xué)生信息管理”窗體旳實(shí)現(xiàn)如圖4.2.1所示。圖 4.2.1“學(xué)生信息管理”窗體在構(gòu)造函數(shù)前添加數(shù)據(jù)庫(kù)上下文對(duì)象，并在構(gòu)造函數(shù)中增長(zhǎng)如下代碼ScoreManContext db = new ScoreManContext();public FormClass() InitializeComponent(); db.Studentes.Load(); studentBindingSource.DataSource = db.Studentes.Local; “新添”按鈕代碼實(shí)現(xiàn)如下private void bindingNavigatorAddNewItem_Cl

10、ick(object sender, EventArgs e) Student student = new Course(); course.Id = Guid.NewGuid(); FormEditCourse formEdit = new FormEditCourse(course ); if(formEdit.ShowDialog ()=DialogResult.OK) courseBindingSource.Add(course); courseBindingSource.EndEdit(); db.SaveChanges(); “刪除”按鈕代碼實(shí)現(xiàn)如下private void bin

11、dingNavigatorDeleteItem_Click(object sender, EventArgs e) if (studentBindingSource.Current = null) return; if(Dialogs.ShowConfirm (你擬定刪除嗎)=DialogResult.Yes) studentBindingSource.RemoveCurrent(); db.SaveChanges(); “編輯”按鈕代碼實(shí)現(xiàn)如下private void toolStripEdit_Click(object sender, EventArgs e) if (studentBin

12、dingSource.Current = null) return; Student student = studentBindingSource.Current as Student; FormStudentEdit formEdit = new FormStudentEdit(student); if(formEdit .ShowDialog ()=DialogResult.OK) studentBindingSource.EndEdit(); db.SaveChanges(); else db.Entry(student).Reload(); studentBindingSource.R

13、esetBindings(false ); 4.2.2.“編輯學(xué)生信息”窗體設(shè)計(jì)如圖4.2.2所示。圖 4.2.2“編輯學(xué)生信息”窗體設(shè)計(jì)在該窗體中“選擇照片”按鈕代碼實(shí)現(xiàn)如下private void buttonSelectPicture_Click(object sender, EventArgs e) OpenFileDialog openDialog = new OpenFileDialog(); openDialog.Filter = 所有圖片（*.jpg;*.png;*.bmp;*.gif）|*.jpg;*.png;*.gif;*.bmp; if(openDialog .ShowD

14、ialog()=DialogResult.OK) photoPictureBox.Image = Image.FromFile(openDialog.FileName); “擬定”按鈕代碼實(shí)現(xiàn)如下private void buttonOK_Click(object sender, EventArgs e) if (ValidateData() DialogResult = DialogResult.OK; “取消”按鈕代碼實(shí)現(xiàn)如下private void buttonCancel_Click(object sender, EventArgs e) DialogResult = DialogRe

15、sult.Cancel; （三）、班級(jí)信息管理模塊旳實(shí)現(xiàn) 4.3.1.“班級(jí)信息管理”窗體設(shè)計(jì)如圖4.3.1所示。圖 4.3.1“班級(jí)信息管理”窗體設(shè)計(jì)在構(gòu)造函數(shù)前添加數(shù)據(jù)庫(kù)上下文對(duì)象，并在構(gòu)造函數(shù)中增長(zhǎng)如下代碼ScoreManContext db = new ScoreManContext();public FormClass() InitializeComponent(); db.Classes.Load(); classBindingSource.DataSource = db.Classes.Local; “新添”按鈕代碼實(shí)現(xiàn)如下private void bindingNavigato

16、rAddNewItem_Click(object sender, EventArgs e) Class classes = new Class(); classes.Id = Guid.NewGuid(); FormEditClass formEdit = new FormEditClass(); if (formEdit.ShowDialog() = DialogResult.OK) classBindingSource.Add(classes); classBindingSource.EndEdit(); db.SaveChanges(); “刪除”按鈕代碼實(shí)現(xiàn)如下private void

17、 bindingNavigatorDeleteItem_Click(object sender, EventArgs e) if (classBindingSource.Current = null) return; classBindingSource.RemoveCurrent(); db.SaveChanges(); Dialogs.ShowMessage(刪除成功); “編輯”按鈕代碼實(shí)現(xiàn)如下private void toolStripButton1_Click(object sender, EventArgs e) if (classBindingSource.Current = n

18、ull) return; Class classes = classBindingSource.Current as Class; FormEditClass formEdit = new FormEditClass( ); if (formEdit.ShowDialog() = DialogResult.OK) db.SaveChanges(); else db.Entry(classes ).Reload(); 4.3.2.“編輯班級(jí)信息”窗體如圖4.3.2所示。圖4.3.2“編輯班級(jí)信息”窗體設(shè)計(jì)“擬定”按鈕代碼實(shí)現(xiàn)如下private void buttonOK_Click(object

19、 sender, EventArgs e) if (ValidateData() DialogResult = DialogResult.OK; “取消”按鈕代碼實(shí)現(xiàn)如下private void buttonCancel_Click(object sender, EventArgs e) DialogResult = DialogResult.Cancel; （四）、課程信息管理模塊旳實(shí)現(xiàn)4.4.1.“課程信息窗體”設(shè)計(jì)如圖4.4.1所示。圖 4.4.1“課程信息窗體”設(shè)計(jì)在構(gòu)造函數(shù)前添加數(shù)據(jù)庫(kù)上下文對(duì)象，并在構(gòu)造函數(shù)中增長(zhǎng)如下代碼ScoreManContext db = new ScoreM

20、anContext();public FormClass() InitializeComponent(); db.Courses.Load(); courseBindingSource.DataSource = db.Courses.Local; “新添”按鈕實(shí)現(xiàn)代碼如下private void bindingNavigatorAddNewItem_Click(object sender, EventArgs e) Course course = new Course(); course.Id = Guid.NewGuid(); FormEditCourse formEdit = new Fo

21、rmEditCourse(course ); if(formEdit.ShowDialog ()=DialogResult.OK) courseBindingSource.Add(course); courseBindingSource.EndEdit(); db.SaveChanges(); “刪除”按鈕實(shí)現(xiàn)代碼如下private void bindingNavigatorDeleteItem_Click(object sender, EventArgs e) if (courseBindingSource.Current = null) return; courseBindingSourc

22、e.RemoveCurrent(); db.SaveChanges(); Dialogs.ShowMessage(刪除成功); “編輯”按鈕實(shí)現(xiàn)代碼如下 private void toolStripButtonEdit_Click(object sender, EventArgs e) if (courseBindingSource.Current = null) return; Course course = courseBindingSource.Current as Course; FormEditCourse formEdit = new FormEditCourse(course);

23、 if(formEdit .ShowDialog ()=DialogResult.OK) db.SaveChanges(); else db.Entry(course).Reload(); 4.4.2.“編輯課程信息”窗體設(shè)計(jì)如圖4.4.2所示。圖 4.4.2“編輯課程信息”窗體設(shè)計(jì)“擬定”按鈕代碼實(shí)現(xiàn)如下private void buttonOK_Click(object sender, EventArgs e) if (ValidateData() DialogResult = DialogResult.OK; “取消”按鈕代碼實(shí)現(xiàn)如下private void buttonCancel_C

24、lick(object sender, EventArgs e) DialogResult = DialogResult.Cancel; （五）、成績(jī)信息管理模塊旳實(shí)現(xiàn)4.5.1.“成績(jī)信息管理”窗體設(shè)計(jì)如圖4.5.1所示。圖 4.5.1“成績(jī)信息管理”窗體設(shè)計(jì)在構(gòu)造函數(shù)前添加數(shù)據(jù)庫(kù)上下文對(duì)象，并在構(gòu)造函數(shù)中增長(zhǎng)如下代碼ScoreManContext db = new ScoreManContext();public FormClass() InitializeComponent(); db.Scores.Load(); scoreBindingSource.DataSource = db.S

25、cores.Local; “新添”按鈕實(shí)現(xiàn)代碼如下 private void bindingNavigatorAddNewItem_Click(object sender, EventArgs e) Score score = new Score(); score.StudentId = Guid.NewGuid(); score.CourseId = Guid.NewGuid(); FormEditScore formEdit = new FormEditScore(); if (formEdit.ShowDialog() = DialogResult.OK) scoreBindingSou

26、rce.Add(score); scoreBindingSource.EndEdit(); db.SaveChanges(); “刪除”按鈕實(shí)現(xiàn)代碼如下 private void bindingNavigatorDeleteItem_Click(object sender, EventArgs e) if (scoreBindingSource.Current = null) return; scoreBindingSource.RemoveCurrent(); db.SaveChanges(); Dialogs.ShowMessage(刪除成功); “編輯”按鈕實(shí)現(xiàn)代碼如下 private void toolStripButton1_Click(object sender, EventArgs e) if (scoreBindingSource.Current = null) return; Score score = scoreBindingSource.Current as Score; FormEditScore formEdit = new FormEditScore(); if (formEdit.ShowDialog() = DialogResult.OK) scoreBindingSource.EndEdit(); db.SaveC