英語學習助手-嵌入式軟件開發(fā)-課程設計說明書本科學位論文

xx大學課程設計說明書

數(shù)據(jù)庫大型實驗周

學生姓名學號：學生姓名學號：學生姓名學號：學生姓名學號：學院:軟件學院

專業(yè):嵌入式軟件開發(fā)

題目:英語學習助手

指導教師：職稱:副教授

20141.設計目的主要目的是幫助人們對不同層次的詞匯學習和對日常應用語句的學習。英語學習助手主要包含四大模塊：單詞、例句、短文、單詞測試，用戶可以在單詞、例句、短文模塊中進行查詢、修改、錄入等操作，在單詞測試模塊中，通過選擇難度，隨機生成單詞測試題，方便學習和鞏固單詞。本報告首先引出英語學習的重要性，然后對整個系統(tǒng)作出一個系統(tǒng)分析，畫出各個實體之間的E-R圖，抽象成數(shù)據(jù)表，在SQLServer2005中建立相應的數(shù)據(jù)表，為各個數(shù)據(jù)表添加好數(shù)據(jù)后，應用ASP.NET為平臺，連接數(shù)據(jù)庫，實現(xiàn)對各個數(shù)據(jù)表的相關操作。2.設計內容設計如下主要功能模塊:①實現(xiàn)英語單詞的錄入、修改、刪除等基本操作；②實現(xiàn)常用英語單詞例句的錄入、修改、刪除等基本操作；③實現(xiàn)英語單詞檢索、翻譯等；④常用英語單詞例句檢索；⑤根據(jù)難度隨機生成一份單詞測試題目；⑥能夠檢索出短文極其翻譯對照表；3.開發(fā)和運行環(huán)境介開發(fā)工具：visualstudio2008，SQlserver2005運行環(huán)境：Window7操作系統(tǒng)需求分析4.1功能需求 英語學習助手英語學習助手測試翻譯查詢錄入測試翻譯查詢錄入查詢例句查詢短文查詢單詞查詢例句查詢短文查詢單詞錄入單詞翻譯短文翻譯例句錄入短文錄入例句根據(jù)難易程度隨機生成一份測試題翻譯單詞錄入單詞翻譯短文翻譯例句錄入短文錄入例句根據(jù)難易程度隨機生成一份測試題翻譯單詞圖4.1數(shù)據(jù)流程圖4.2性能需求首先需要建立與該系統(tǒng)相對應的數(shù)據(jù)庫，包含有各種表的設計、視圖以及觸發(fā)器等等。然后需要測試所建立的數(shù)據(jù)庫，看其能否實現(xiàn)相應的查詢、修改、增加、刪除功能。最后，根據(jù)建立的數(shù)據(jù)庫和系統(tǒng)的功能需求，利用ASP.NET實現(xiàn)相應的功能。4.3數(shù)據(jù)流圖根據(jù)英語學習要求及需求調查分析，對系統(tǒng)畫出如圖所示的數(shù)據(jù)流圖用戶用戶輸入單詞修改單詞刪除單詞輸入例句修改例句刪除例句D1D2例句表D1單詞表圖4.2數(shù)據(jù)流程圖4.4E-R圖有了數(shù)據(jù)流圖，用E-R圖來說明英語學習助手的數(shù)據(jù)庫概念模式，如圖所示：英語學習助手英語學習助手包括容納包括容納編號例句單詞單詞號詞匯關鍵字編號例句單詞單詞號詞匯關鍵字翻譯級別翻譯句子翻譯級別翻譯句子圖4.3E—R圖邏輯模型設計5.1用戶表圖5.15.2單詞表圖5.25.3例句表圖5.35.4短文表圖5.46.系統(tǒng)設計與實現(xiàn)6.1模塊功能描述模塊功能完成人單詞的添加，修改，刪除，檢索馬騰例句的添加，修改，刪除郝志強例句的檢索，短文的添加，修改陳煒短文的刪除，檢索劉勇 表6.1共同完成模塊：用戶的登錄界面，主界面，數(shù)據(jù)庫的創(chuàng)建6.2用戶登錄圖6.1 stringuserName=textBox1.Text;stringpassword=textBox2.Text;stringconnString=@"DataSource=rjjc-119\sqlexpress;InitialCatalog=英語學習助手;IntegratedSecurity=True";SqlConnectionconnection=newSqlConnection(connString);stringsql=String.Format("selectcount(*)from[用戶表]whereuserName='{0}'andpassword='{1}'",userName,password);try{connection.Open();SqlCommandcommand=newSqlCommand(sql,connection);intnum=(int)command.ExecuteScalar();if(num>0){//如有匹配的行，則表明用戶名和密碼正確MessageBox.Show("歡迎進入英語學習助手！","登錄成功",MessageBoxButtons.OK,MessageBoxIcon.Information);主界面mainForm=new主界面();mainForm.Show();this.Visible=false;}else{MessageBox.Show("您輸入的用戶名或密碼錯誤!","登錄失敗",MessageBoxButtons.OK,MessageBoxIcon.Exclamation);}}catch(Exceptionex){MessageBox.Show(ex.Message,"操作數(shù)據(jù)庫出錯!",MessageBoxButtons.OK,MessageBoxIcon.Exclamation);}finally{connection.Close();}6.3主界面圖6.2 privatevoidbutton1_Click(objectsender,EventArgse){單詞模塊mainForm=new單詞模塊();mainForm.Show();this.Visible=false;}privatevoidbutton2_Click(objectsender,EventArgse){例句模塊mainForm=new例句模塊();mainForm.Show();this.Visible=false;}privatevoidbutton3_Click(objectsender,EventArgse){短文模塊mainForm=new短文模塊();mainForm.Show();this.Visible=false;}privatevoidbutton4_Click(objectsender,EventArgse){Application.Exit();}6.4單詞模塊圖6.3privatevoid添加單詞ToolStripMenuItem_Click(objectsender,EventArgse){添加單詞模塊mainForm=new添加單詞模塊();mainForm.Show();this.Visible=false;}privatevoid修改單詞ToolStripMenuItem_Click(objectsender,EventArgse){修改單詞模塊mainForm=new修改單詞模塊();mainForm.Show();this.Visible=false;}privatevoid刪除單詞ToolStripMenuItem_Click(objectsender,EventArgse){刪除單詞模塊mainForm=new刪除單詞模塊();mainForm.Show();this.Visible=false;}privatevoid單詞檢索ToolStripMenuItem_Click(objectsender,EventArgse){單詞檢索模塊mainForm=new單詞檢索模塊();mainForm.Show();this.Visible=false;}privatevoid單詞自測ToolStripMenuItem_Click(objectsender,EventArgse){單詞自測模塊mainForm=new單詞自測模塊();mainForm.Show();this.Visible=false;}privatevoid返回主界面ToolStripMenuItem_Click(objectsender,EventArgse){主界面mainForm=new主界面();mainForm.Show();this.Visible=false;}privatevoid退出系統(tǒng)ToolStripMenuItem_Click(objectsender,EventArgse){Application.Exit();}6.5添加單詞模塊圖6.4stringconnString=@"DataSource=rjjc-119\sqlexpress;InitialCatalog=英語學習助手;IntegratedSecurity=True;";stringnum=textBox1.Text;stringnum3=textBox2.Text;stringnum1=textBox3.Text;stringnum2=textBox4.Text;SqlConnectionconnection=newSqlConnection(connString);stringsql=String.Format("update[單詞表]setfanyi='{0}',Num='{1}',jibie='{2}'whereword='{3}'",num1,num2,num3,num);try{connection.Open();SqlCommandcommand=newSqlCommand(sql,connection);intcount=command.ExecuteNonQuery();if(count>0){MessageBox.Show("修改英語單詞成功！","修改成功",MessageBoxButtons.OK,MessageBoxIcon.Information);}else{MessageBox.Show("修改失敗!","修改失敗",MessageBoxButtons.OK,MessageBoxIcon.Information);}}catch(Exceptionex){MessageBox.Show(ex.Message,"操作數(shù)據(jù)庫出錯!",MessageBoxButtons.OK,MessageBoxIcon.Exclamation);}finally{connection.Close();}6.6修改單詞模塊圖6.5stringconnString=@"DataSource=rjjc-119\sqlexpress;InitialCatalog=英語學習助手;IntegratedSecurity=True;";stringnum=textBox1.Text;stringnum3=textBox2.Text;stringnum1=textBox3.Text;stringnum2=textBox4.Text;SqlConnectionconnection=newSqlConnection(connString);stringsql=String.Format("update[單詞表]setfanyi='{0}',Num='{1}',jibie='{2}'whereword='{3}'",num1,num2,num3,num);try{connection.Open();SqlCommandcommand=newSqlCommand(sql,connection);intcount=command.ExecuteNonQuery();if(count>0){MessageBox.Show("修改英語單詞成功！","修改成功",MessageBoxButtons.OK,MessageBoxIcon.Information);}else{MessageBox.Show("修改失敗!","修改失敗",MessageBoxButtons.OK,MessageBoxIcon.Information);}}catch(Exceptionex){MessageBox.Show(ex.Message,"操作數(shù)據(jù)庫出錯!",MessageBoxButtons.OK,MessageBoxIcon.Exclamation);}finally{connection.Close();}6.7刪除單詞模塊圖6.6stringconnString=@"DataSource=rjjc-119\sqlexpress;InitialCatalog=英語學習助手;IntegratedSecurity=True;";stringnum=textBox1.Text;stringnum2=textBox2.Text;SqlConnectionconnection=newSqlConnection(connString);stringsql=String.Format("deletefrom[單詞表]whereword='{0}'orfanyi='{1}'",num,num2);connection.Open();SqlCommandcommand=newSqlCommand(sql,connection);intcount=command.ExecuteNonQuery();if(count>0){stringmessage=String.Format("刪除成功，刪除了{0}個",count);MessageBox.Show(message,"刪除成功",MessageBoxButtons.OK,MessageBoxIcon.Information);}6.8單詞檢索模塊圖6.7privatevoidbutton1_Click(objectsender,EventArgse){stringconnString=@"DataSource=rjjc-119\sqlexpress;InitialCatalog=英語學習助手;IntegratedSecurity=True";stringwords=textBox1.Text;SqlConnectionconnection=newSqlConnection(connString);stringsql=String.Format("selectfanyifrom[單詞表]whereword='{0}'",words);connection.Open();SqlCommandcommand=newSqlCommand(sql,connection);stringwordOne=Convert.ToString(command.ExecuteScalar());textBox2.Text=wordOne;}privatevoidbutton2_Click(objectsender,EventArgse){stringconnString=@"DataSource=rjjc-119\sqlexpress;InitialCatalog=英語學習助手;IntegratedSecurity=True";stringwords=textBox2.Text;SqlConnectionconnection=newSqlConnection(connString);stringsql=String.Format("selectwordfrom[單詞表]wherefanyi='{0}'",words);connection.Open();SqlCommandcommand=newSqlCommand(sql,connection);stringwordOne=Convert.ToString(command.ExecuteScalar());textBox1.Text=wordOne;}privatevoidbutton3_Click(objectsender,EventArgse){主界面mainForm=new主界面();mainForm.Show();this.Visible=false;}6.9例句模塊圖6.8privatevoid添加例句ToolStripMenuItem_Click(objectsender,EventArgse){添加例句模塊mainForm=new添加例句模塊();mainForm.Show();this.Visible=false;}privatevoid修改例句ToolStripMenuItem_Click(objectsender,EventArgse){修改例句模塊mainForm=new修改例句模塊();mainForm.Show();this.Visible=false;}privatevoid刪除例句ToolStripMenuItem_Click(objectsender,EventArgse){刪除例句模塊mainForm=new刪除例句模塊();mainForm.Show();this.Visible=false;}privatevoid例句檢索ToolStripMenuItem_Click(objectsender,EventArgse){例句檢索模塊mainForm=new例句檢索模塊();mainForm.Show();this.Visible=false;}privatevoid返回主界面ToolStripMenuItem_Click(objectsender,EventArgse){主界面mainForm=new主界面();mainForm.Show();this.Visible=false;}privatevoid退出系統(tǒng)ToolStripMenuItem_Click(objectsender,EventArgse){Application.Exit();}6.10添加例句模塊圖6.9stringliju=textBox2.Text;stringfanyi=textBox3.Text;stringNum=textBox1.Text;stringconnString=@"DataSource=rjjc-119\sqlexpress;InitialCatalog=英語學習助手;IntegratedSecurity=True";SqlConnectionconnection=newSqlConnection(connString);stringsql=String.Format("INSERTINTO[例句表](Num,liju,fanyi)VALUES('{0}','{1}','{2}')",Num,liju,fanyi);try{connection.Open();SqlCommandcommand=newSqlCommand(sql,connection);intcount=command.ExecuteNonQuery();if(count>0){MessageBox.Show("添加英語例句成功！","添加成功",MessageBoxButtons.OK,MessageBoxIcon.Information);}else{MessageBox.Show("添加失敗!","添加失敗",MessageBoxButtons.OK,MessageBoxIcon.Information);}}catch(Exceptionex){MessageBox.Show(ex.Message,"操作數(shù)據(jù)庫出錯!",MessageBoxButtons.OK,MessageBoxIcon.Exclamation);}finally{connection.Close();}6.11修改例句模塊圖6.10stringconnString=@"DataSource=rjjc-119\sqlexpress;InitialCatalog=英語學習助手;IntegratedSecurity=True;";stringnum1=textBox3.Text;stringnum2=textBox1.Text;stringnum3=textBox2.Text;SqlConnectionconnection=newSqlConnection(connString);stringsql=String.Format("update[例句表]setfanyi='{0}',Num='{1}'whereliju='{2}'",num1,num2,num3);try{connection.Open();SqlCommandcommand=newSqlCommand(sql,connection);intcount=command.ExecuteNonQuery();if(count>0){MessageBox.Show("修改英語例句成功！","修改成功",MessageBoxButtons.OK,MessageBoxIcon.Information);}else{MessageBox.Show("修改失敗!","修改失敗",MessageBoxButtons.OK,MessageBoxIcon.Information);}}catch(Exceptionex){MessageBox.Show(ex.Message,"操作數(shù)據(jù)庫出錯!",MessageBoxButtons.OK,MessageBoxIcon.Exclamation);}finally{connection.Close();}6.12刪除例句模塊圖6.11stringconnString=@"DataSource=rjjc-119\sqlexpress;InitialCatalog=英語學習助手;IntegratedSecurity=True;";stringnum=textBox1.Text;stringnum2=textBox2.Text;SqlConnectionconnection=newSqlConnection(connString);stringsql=String.Format("deletefrom[例句表]whereliju='{0}'orfanyi='{1}'",num,num2);connection.Open();SqlCommandcommand=newSqlCommand(sql,connection);intcount=command.ExecuteNonQuery();if(count>0){stringmessage=String.Format("刪除成功，刪除了{0}個",count);MessageBox.Show(message,"刪除成功",MessageBoxButtons.OK,MessageBoxIcon.Information);}6.13例句檢索模塊圖6.12privatevoidbutton1_Click(objectsender,EventArgse){stringconnString=@"DataSource=rjjc-119\sqlexpress;InitialCatalog=英語學習助手;IntegratedSecurity=True";stringliju=textBox1.Text;SqlConnectionconnection=newSqlConnection(connString);stringsql=String.Format("selectfanyifrom[例句表]whereliju='{0}'",liju);connection.Open();SqlCommandcommand=newSqlCommand(sql,connection);stringwordOne=Convert.ToString(command.ExecuteScalar());textBox2.Text=wordOne;}privatevoidbutton2_Click(objectsender,EventArgse){stringconnString=@"DataSource=rjjc-119\sqlexpress;InitialCatalog=英語學習助手;IntegratedSecurity=True";stringliju=textBox2.Text;SqlConnectionconnection=newSqlConnection(connString);stringsql=String.Format("selectlijufrom[例句表]wherefanyi='{0}'",liju);connection.Open();SqlCommandcommand=newSqlCommand(sql,connection);stringwordOne=Convert.ToString(command.ExecuteScalar());textBox1.Text=wordOne;}6.14短文模塊圖6.13privatevoid添加短文ToolStripMenuItem_Click(objectsender,EventArgse){添加短文模塊mainForm=new添加短文模塊();mainForm.Show();this.Visible=false;}privatevoid修改短文ToolStripMenuItem_Click(objectsender,EventArgse){修改短文模塊mainForm=new修改短文模塊();mainForm.Show();this.Visible=false;}privatevoid刪除短文ToolStripMenuItem_Click(objectsender,EventArgse){刪除短文模塊mainForm=new刪除短文模塊();mainForm.Show();this.Visible=false;}privatevoid短文檢索ToolStripMenuItem_Click(objectsender,EventArgse){短文檢索模塊mainForm=new短文檢索模塊();mainForm.Show();this.Visible=false;}privatevoid返回主界面ToolStripMenuItem_Click(objectsender,EventArgse){主界面mainForm=new主界面();mainForm.Show();this.Visible=false;}privatevoid退出系統(tǒng)ToolStripMenuItem_Click(objectsender,EventArgse){Application.Exit();}6.15添加短文模塊圖6.14stringduanwen=textBox2.Text;stringfanyi=textBox3.Text;stringNum=textBox1.Text;stringconnString=@"DataSource=rjjc-119\sqlexpress;InitialCatalog=英語學習助手;IntegratedSecurity=True";SqlConnectionconnection=newSqlConnection(connString);stringsql=String.Format("INSERTINTO[短文表](Num,duanwen,fanyi)VALUES('{0}','{1}','{2}')",Num,duanwen,fanyi);try{connection.Open();SqlCommandcommand=newSqlCommand(sql,connection);intcount=command.ExecuteNonQuery();if(count>0){MessageBox.Show("添加英語短文成功！","添加成功",MessageBoxButtons.OKMessageBoxIcon.Information);}else{MessageBox.Show("添加失敗!","添加失敗",MessageBoxButtons.OK,MessageBoxIcon.Information);}}catch(Exceptionex){MessageBox.Show(ex.Message,"操作數(shù)據(jù)庫出錯!",MessageBoxButtons.OK,MessageBoxIcon.Exclamation);}finally{connection.Close();}6.16修改短文模塊圖6.15stringconnString=@"DataSource=rjjc-119\sqlexpress;InitialCatalog=英語學習助手;IntegratedSecurity=True;";stringnum1=textBox3.Text;stringnum2=textBox1.Text;stringnum3=textBox2.Text;SqlConnectionconnection=newSqlConnection(connString);stringsql=String.Format("update[短文表]setfanyi='{0}',Num='{1}'whereduanwen='{2}'",num1,num2,num3);try{connection.Open();SqlCommandcommand=newSqlCommand(sql,connection);intcount=command.ExecuteNonQuery();if(count>0){MessageBox.Show("修改英語短文成功！","修改成功",MessageBoxButtons.OK,MessageBoxIcon.Information);}else{MessageBox.Show("修改失敗!","修改失敗",MessageBoxButtons.OK,MessageBoxIcon.Information);}}catch(Exceptionex){MessageBox.Show(ex.Message,"操作數(shù)據(jù)庫出錯!",MessageBoxButtons.OK,MessageBoxIcon.Exclamation);}finally{connection.Close();}6.17刪除短文模塊圖6.16stringconnString=@"DataSource=rjjc-119\sqlexpress;InitialCatalog=英語學習助手;IntegratedSecurity=True;";stringnum=textBox1.Text;stringnum2=textBox2.Text;SqlConnectionconnection=newSqlConnection(connString);stringsql=String.Format("deletefrom[短文表]whereduanwen='{0}'orfanyi='{1}'",num,num2);connection.Open();SqlCommandcommand=newSqlCommand(sql,connection);intcount=command.ExecuteNonQuery();if(count>0){stringmessage=String.Format("刪除成功，刪除了{0}個",count);MessageBox.Show(message,"刪除成功",MessageBoxButtons.OK,MessageBoxIcon.Information);}6.18短文檢索模塊圖6.17privatevoidbutton1_Click(objectsender,EventArgse){StringconnString=@"DataSource=rjjc-119\s