數(shù)據(jù)庫(kù)課程設(shè)計(jì)說(shuō)明書(shū)格式

1、中北大學(xué) 課 程 設(shè) 計(jì) 說(shuō) 明 書(shū) 數(shù)據(jù)庫(kù)大型實(shí)驗(yàn)周學(xué)生姓名 :苗瑞林 學(xué) 號(hào):0906034216 學(xué)生姓名 : 羅凡鈺 學(xué) 號(hào):0906034250 學(xué)生姓名 : 曹旭利 學(xué) 號(hào):0906034204 學(xué)生姓名 : 黃麗 學(xué) 號(hào):0906034208 學(xué) 院 : 電子與計(jì)算機(jī)科學(xué)技術(shù)學(xué)院專 業(yè) : 計(jì)算機(jī)科學(xué)與技術(shù)題 目 : 英語(yǔ)學(xué)習(xí)助手指導(dǎo)教師:武瑞娟 職稱 : 副教授 2012 年 6月 22日1. 設(shè)計(jì)目的隨著社會(huì)的發(fā)展和時(shí)代的進(jìn)步, 英語(yǔ)已經(jīng)成為人們?cè)谌粘Ｉ詈凸ぷ髦斜仨?掌握和應(yīng)用語(yǔ)言。 為了更好、 更快的掌握英語(yǔ)基礎(chǔ)知識(shí), 盡快具備英語(yǔ)會(huì)話和寫(xiě) 作能力, 適應(yīng)當(dāng)前人們的工作、

2、 生活需要, 推動(dòng)英語(yǔ)學(xué)習(xí)的普及, 所以我們小組 集體開(kāi)發(fā)了這套完整的英語(yǔ)學(xué)習(xí)助手, 歡迎大家使用和提出改進(jìn)意見(jiàn)。 此系統(tǒng)主 要實(shí)現(xiàn)了以下幾大功能:后臺(tái):單詞及單詞例句信息管理(英語(yǔ)單詞的錄入、 修 改、刪除 ; 前臺(tái):實(shí)現(xiàn)英語(yǔ)單詞檢索、翻譯。英語(yǔ)單詞自測(cè),自測(cè)結(jié)果顯示功 能。2. 設(shè)計(jì)內(nèi)容(1主要的數(shù)據(jù)表用戶表,英語(yǔ)分級(jí)單詞表,常用單詞例句表等等。(2主要功能模塊1實(shí)現(xiàn)英語(yǔ)單詞的錄入、修改、刪除等基本操作。2實(shí)現(xiàn)常用英語(yǔ)單詞例句的錄入、修改、刪除等基本操作。3實(shí)現(xiàn)英語(yǔ)單詞檢索、翻譯等。4常用英語(yǔ)單詞例句檢索。5隨機(jī)生成一份單詞測(cè)試題目。3. 開(kāi)發(fā)和運(yùn)行環(huán)境介紹開(kāi)發(fā)工具:Visual Stud

3、io 2010,SQL2008運(yùn)行環(huán)境:Windows 9x 、 Windows NT、 Windows 2000、 Windowsxp 操作系 統(tǒng)。4. 需求分析4.1功能需求本系統(tǒng)的功能分為如下幾大模塊:1. 單詞模塊:包括單詞表的建立,單詞的錄入、修改、刪除等基本操作。單 詞表包括單詞和漢語(yǔ)翻譯以及初級(jí)、 中級(jí)、 高級(jí)三種難度單詞的分類。 單詞錄入 要求能夠?qū)崿F(xiàn)錄入 (增加 單詞及其漢語(yǔ)翻譯; 修改要求能修改單詞的拼寫(xiě)以及 其漢語(yǔ)意思;刪除即能夠刪除某一單詞記錄。2. 例句模塊:包括例句表的建立,例句的錄入、修改、刪除等基本操作。例 句表包括例句及其中文翻譯等。 例句錄入要求能夠?qū)崿F(xiàn)錄入

4、 (增加 例句及其漢語(yǔ)翻譯; 修改要求能修改例句的單詞以及其漢語(yǔ)意思; 刪除即能夠刪除某一例句 記錄。3. 試題模塊:隨機(jī)生成一份相應(yīng)難度的單詞測(cè)試表。 可以給出英文單詞選擇 其正確的漢語(yǔ)翻譯4. 檢索模塊:包括單詞檢索和例句檢索, 。單詞檢索要實(shí)現(xiàn)輸入一個(gè)單詞, 可以檢索出它的漢語(yǔ)翻譯。 例句檢索要能實(shí)現(xiàn)輸入句子, 可以檢索出其中文翻譯。 4.2 性能需求(1盡量采取學(xué)?，F(xiàn)有軟硬件環(huán)境,及先進(jìn)的管理系統(tǒng)開(kāi)發(fā)方案,從而達(dá) 到充分利用學(xué)?，F(xiàn)有資源,提高系統(tǒng)系統(tǒng)開(kāi)發(fā)水平的目的。(2系統(tǒng)應(yīng)符合學(xué)校學(xué)生現(xiàn)有的多媒體條件,滿足學(xué)生日常英語(yǔ)學(xué)習(xí)的需 要,并達(dá)到操作過(guò)程的直觀,方便,實(shí)用等要求。(3系統(tǒng)采用

5、模塊化程序設(shè)計(jì)方法,既便于系統(tǒng)功能的各種組合和修改。 4.3 數(shù)據(jù)流圖(1順序圖 符合,登錄成功 不符合, 登錄失 敗 圖 2 E-R圖5. 系統(tǒng)設(shè)計(jì)與實(shí)現(xiàn) (寫(xiě)清楚每個(gè)人負(fù)責(zé)的模塊 5.1 模塊功能描述苗瑞林:自測(cè),實(shí)現(xiàn)單詞和例句的修改羅凡鈺:實(shí)現(xiàn)單詞和例句的檢索曹旭利:實(shí)現(xiàn)例句的錄入,刪除黃麗:實(shí)現(xiàn)單詞的錄入,刪除5.2 軟件實(shí)現(xiàn)黃麗:實(shí)現(xiàn)單詞的錄入,刪除添加單詞:using System;using System.ComponentModel;using System.Data;using System.Drawing;using System.Linq;using System.Tex

6、t;namespace WindowsFormsApplication1public partial class Form1 : Formpublic Form1(InitializeComponent(;private void Form1_Load(object sender, EventArgs eprivate void btnYes_Click(object sender, EventArgs e string word = textBox1.Text;string fanyi=textBox2.Text;string dengji=textBox3.Text;string Num

7、= textBox4.Text;string Constr = "server = .;database=ENGLISHWORD;uid=sa;pwd=123"SqlConnection con = new SqlConnection(Constr;string sql = String.Format("INSERT INTO word(Num,word,fanyi,dengjiVALUES('0','1','2','3'",Num,word,fanyi,dengji;con.Open(;S

8、qlCommand cmd = new SqlCommand(sql, con;int count = cmd.ExecuteNonQuery(;if (count>0MessageBox.Show("添加英語(yǔ)單詞成功! "," 添加成功 ", MessageBoxButtons.OK,MessageBoxIcon.Information;elseMessageBox.Show("添加失敗 !"," 添加失敗 ",MessageBoxButtons.OK,MessageBoxIcon.Information;

9、 private void lblWord_Click(object sender, EventArgs e private void btnClose_Click(object sender, EventArgs e Form3 ss = new Form3(;ss.Show(;this.Visible = false;刪除單詞:using System;using System.ComponentModel;using System.Data;using System.Drawing;using System.Linq;using System.Text;namespace Windows

10、FormsApplication1public partial class Form4 : Formpublic Form4(InitializeComponent(;private void Form4_Load(object sender, EventArgs estring Constr = "server = .;database=ENGLISHWORD;uid=sa;pwd=123" SqlConnection con = new SqlConnection(Constr;string sql = "select * from word"con

11、.Open(;SqlDataAdapter adpt=new SqlDataAdapter(sql, con;DataTable dt=new DataTable(;adpt.Fill(dt;dataGridView1.DataSource = dt;private void button1_Click(object sender, EventArgs estring id = dataGridView1.Rows0.Cells0.Value.ToString(;string Constr = "server = .;database=ENGLISHWORD;uid=sa;pwd=1

12、23" SqlConnection con = new SqlConnection(Constr;string sql = "DELETE from word WHERE Num="+id+""string sql1 = "SELECT * FROM word"con.Open(;SqlCommand cmd = new SqlCommand(sql, con;if (cmd.ExecuteNonQuery( > 0string message = String.Format("刪 除 成 功 ",

13、 cmd.ExecuteNonQuery(;MessageBox.Show(message, "刪除成功 ", MessageBoxButtons.OK, MessageBoxIcon.Information;SqlDataAdapter adpt = new SqlDataAdapter(sql1,con;DataTable dt = new DataTable(;adpt.Fill(dt;dataGridView1.DataSource = dt;private void button2_Click(object sender, EventArgs eForm3 ssi

14、 = new Form3(;ssi.Show(;this.Visible = false;private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e曹旭利:實(shí)現(xiàn)例句的錄入,刪除添加例句:using System;using System.ComponentModel;using System.Data;using System.Drawing;using System.Linq;using System.Text;namespace WindowsFormsApplication1

15、public partial class Form7 : Formpublic Form7(InitializeComponent(;private void Form7_Load(object sender, EventArgs eprivate void btnYes_Click(object sender, EventArgs estring sentence = textBox1.Text;string fanyi = textBox2.Text;string sword = textBox3.Text;string Num = textBox4.Text;string Constr

16、= "server = .;database=ENGLISHWORD;uid=sa;pwd=123" SqlConnection con = new SqlConnection(Constr;string sql = String.Format("INSERT INTO sentence(Num,sentence,fanyi,sword VALUES('0','1','2','3'", Num, sentence, fanyi, sword;con.Open(;SqlCommand cmd

17、= new SqlCommand(sql, con;SqlCommand command = new SqlCommand(sql, con;if (cmd.ExecuteNonQuery( > 0MessageBox.Show("添加英語(yǔ)例句成功! ", "添加成功 ",MessageBoxButtons.OK, MessageBoxIcon.Information; elseMessageBox.Show("添加失敗 !", "添加失敗 ",MessageBoxButtons.OK, MessageBox

18、Icon.Information; private void lblSword_Click(object sender, EventArgs e private void button2_Click(object sender, EventArgs e Form3 ss = new Form3(;ss.Show(;this.Visible = false;刪除例句:using System;using System.ComponentModel;using System.Data;using System.Drawing;using System.Linq;using System.Text;

19、namespace WindowsFormsApplication1public partial class Form9 : Formpublic Form9(InitializeComponent(;string Constr = "server = .;database=ENGLISHWORD;uid=sa;pwd=123" SqlConnection con = new SqlConnection(Constr;string sql = "select * from sentence"con.Open(;SqlDataAdapter adpt =

20、new SqlDataAdapter(sql, con;DataTable dt = new DataTable(;adpt.Fill(dt;dataGridView1.DataSource = dt;private void button3_Click(object sender, EventArgs estring Constr = "server = .;database=ENGLISHWORD;uid=sa;pwd=123" SqlConnection con = new SqlConnection(Constr;string sql = "select

21、* from sentence"con.Open(;SqlCommand cmd = new SqlCommand(sql, con;cmd.ExecuteNonQuery(;private void textBox1_TextChanged(object sender, EventArgs eprivate void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs eprivate void button2_Click_1(object sender, EventArgs eForm3

22、ssi = new Form3(;ssi.Show(;this.Visible = false;private void button1_Click_1(object sender, EventArgs estring id = dataGridView1.Rows0.Cells0.Value.ToString(;string Constr = "server = .;database=ENGLISHWORD;uid=sa;pwd=123" SqlConnection con = new SqlConnection(Constr;string sql = "DEL

23、ETE from sentence WHERE Num=" + id + ""string sql1 = "SELECT * FROM sentence"con.Open(;SqlCommand cmd = new SqlCommand(sql, con;if (cmd.ExecuteNonQuery( > 0string message = String.Format("刪 除 成 功 ", cmd.ExecuteNonQuery(;MessageBox.Show(message, "刪除成功 "

24、, MessageBoxButtons.OK, MessageBoxIcon.Information;SqlDataAdapter adpt = new SqlDataAdapter(sql1, con; DataTable dt = new DataTable(;adpt.Fill(dt;dataGridView1.DataSource = dt;private void Form9_Load(object sender, EventArgs e羅凡鈺:實(shí)現(xiàn)單詞和例句的檢索檢索單詞 :using System;using System.ComponentModel;using System.

25、Data;using System.Drawing;using System.Linq;using System.Text;namespace WindowsFormsApplication1public partial class Form2 : Formpublic Form2(InitializeComponent(;private void button1_Click(object sender, EventArgs estring Constr = "server = .;database=ENGLISHWORD;uid=sa;pwd=123" SqlConnec

26、tion con = new SqlConnection(Constr;con.Open(;string word = textBox1.Text;string sql = String.Format("select fanyi from word where word='0'", word;SqlCommand cmd = new SqlCommand(sql, con;string wordone = Convert.ToString(cmd.ExecuteScalar(;textBox2.Text =wordone;bool row = cmd.Exe

27、cuteScalar(!=null;if (rowstring message = String.Format("查 詢 成 功 ", cmd.ExecuteNonQuery(;MessageBox.Show(message, "查詢成功 ", MessageBoxButtons.OK, MessageBoxIcon.Information;elseMessageBox.Show("查詢失敗 !", "查詢失敗 ",MessageBoxButtons.OK, MessageBoxIcon.Information;p

28、rivate void button2_Click(object sender, EventArgs e Form3 asd = new Form3(;asd.Show(;this.Visible = false;private void Form2_Load(object sender, EventArgs e 例句檢索:using System;using System.ComponentModel;using System.Data;using System.Drawing;using System.Linq;using System.Text;namespace WindowsForm

29、sApplication1public partial class Form11 : Formpublic Form11(InitializeComponent(;private void button1_Click(object sender, EventArgs e string Constr = "server = .;database=ENGLISHWORD;uid=sa;pwd=123"SqlConnection con = new SqlConnection(Constr;con.Open(;string word = textBox1.Text;string

30、sql = String.Format("select fanyi from sentence where sentence='0'", word;SqlCommand cmd = new SqlCommand(sql, con;string wordone = Convert.ToString(cmd.ExecuteScalar(;textBox2.Text = wordone;bool row = cmd.ExecuteScalar( != null;if (rowstring message = String.Format("查 詢 成 功

31、", cmd.ExecuteNonQuery(;MessageBox.Show(message, " 查 詢 成 功 ", MessageBoxButtons.OK, MessageBoxIcon.Information;elseMessageBox.Show("查詢失敗 !", "查詢失敗 ",MessageBoxButtons.OK, MessageBoxIcon.Information;private void button2_Click(object sender, EventArgs e Form3 asd = n

32、ew Form3(;asd.Show(;this.Visible = false;苗瑞林:自測(cè),實(shí)現(xiàn)單詞和例句的修改單詞修改:using System;using System.ComponentModel;using System.Data;using System.Drawing;using System.Linq;using System.Text;namespace WindowsFormsApplication1public partial class Form5 : Formpublic Form5(InitializeComponent(;string Constr = &quo

33、t;server = .;database=ENGLISHWORD;uid=sa;pwd=123"string sql = "select * from word"SqlConnection con = new SqlConnection(Constr;con.Open(;SqlDataAdapter adpt = new SqlDataAdapter(sql, con; DataTable dt = new DataTable(;adpt.Fill(dt;dataGridView1.DataSource = dt;private void Form5_Load(

34、object sender, EventArgs eprivate void button2_Click(object sender, EventArgs e string num = textBox1.Text;string num1 = textBox2.Text;string num2 = textBox3.Text;string num3 = textBox4.Text;string Constr = "server = .;database=ENGLISHWORD;uid=sa;pwd=123"SqlConnection con = new SqlConnecti

35、on(Constr;string sql = "Update word set word='"+num1+"',fanyi='"+num2+"', dengji='"+num3+"' where Num='"+num+"'"con.Open(;trySqlCommand cmd = new SqlCommand(sql, con; int count = cmd.ExecuteNonQuery(;if (count>0Mess

36、ageBox.Show("修改英語(yǔ)單詞成功! "," 修改 成功 ",MessageBoxButtons.OK,MessageBoxIcon.Information;elseMessageBox.Show("修改失敗 !"," 修改失敗 ",MessageBoxButtons.OK,MessageBoxIcon.Information;catch (Exception exMessageBox.Show(ex.Message,"操作數(shù)據(jù)庫(kù)出錯(cuò) !",MessageBoxButtons.OK,Me

37、ssageBoxIcon.Exclamation;finallycon.Close(;private void button1_Click(object sender, EventArgs eForm3 sw = new Form3(;sw.Show(;this.Visible = false;private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e例句修改 :using System;using System.ComponentModel;using System.Data;u

38、sing System.Drawing;using System.Linq;using System.Text;namespace WindowsFormsApplication1public partial class Form10 : Formpublic Form10(InitializeComponent(;private void button1_Click(object sender, EventArgs estring num = textBox1.Text;string num1 = textBox2.Text;string num2 = textBox3.Text;strin

39、g num3 = textBox4.Text;string Constr = "server = .;database=ENGLISHWORD;uid=sa;pwd=123"SqlConnection con = new SqlConnection(Constr;string sql = "update sentence set sentence='"+num1+"',sword='"+num2+"',fanyi='"+num3+"' where Num=&

40、#39;"+num+"'"con.Open(;trySqlCommand cmd = new SqlCommand(sql, con;int count = cmd.ExecuteNonQuery(;if (count > 0MessageBox.Show("修改英語(yǔ)單詞成功! ", "修改成 功 ",MessageBoxButtons.OK, MessageBoxIcon.Information;elseMessageBox.Show("修改失敗 !", "修改失敗 "

41、,MessageBoxButtons.OK, MessageBoxIcon.Information;catch (Exception exMessageBox.Show(ex.Message, "操作數(shù)據(jù)庫(kù)出錯(cuò) !", MessageBoxButtons.OK, MessageBoxIcon.Exclamation;finallycon.Close(;private void button2_Click(object sender, EventArgs e Form3 sap = new Form3(;sap.Show(;this.Visible = false;6. 軟件

42、測(cè)試6.1測(cè)試方法(1動(dòng)態(tài)黑盒測(cè)試,即不深入代碼細(xì)節(jié)的軟件測(cè)試方法,對(duì)軟件的各 功能模塊進(jìn)行通過(guò)性測(cè)試。所謂動(dòng)態(tài),即測(cè)試過(guò)程在軟件運(yùn)行中進(jìn)行。所謂 黑盒,即測(cè)試過(guò)程無(wú)視代碼,只關(guān)注軟件的輸入、輸出。(2兼容性測(cè)試。在不同的虛擬機(jī)、電腦上測(cè)試。6.2測(cè)試環(huán)境Visual studio 20106.3測(cè)試用例及測(cè)試結(jié)果動(dòng)態(tài)黑盒測(cè)試測(cè)試用例 1: 圖 3添加測(cè)試測(cè)試結(jié)果:按下添加按鈕后,再打開(kāi)數(shù)據(jù)庫(kù)中的 word 表可以看到剛才添加 的單詞都全部成功的加入了 word 表中。測(cè)試用例 2: 圖 4單詞刪除測(cè)試測(cè)試結(jié)果:按下確定刪除按鈕后, 可以在窗口數(shù)據(jù)庫(kù)列表中看到上述單詞被刪除 了 。 測(cè)試用例 3: 圖 5單詞修改測(cè)試 按下確定修改按鈕,可以在窗口中看到單詞、翻譯、編號(hào)、例句已經(jīng)被修改了。 測(cè)試用例 4: 圖 6添加例句測(cè)試測(cè)試結(jié)果:按下確定添加按鈕后, 可以在窗口數(shù)據(jù)庫(kù)列表中看到上述例句被添 加了。 測(cè)試用例 5: 圖 7刪除例句測(cè)試測(cè)