数据库课程设计说明书格式

1.设计目的 2.设计内容 3.开发和运行环境介绍 4.需求分析 2黄丽：实现单词的录入，删除 3 3 8罗凡钰：实现单词和例句的检索 苗瑞林：自测，实现单词和例句的修改 用户表，英语分级单词表，常用单词例句表等等。2）实现常用英语单词例句的录入、修改、删除等基本操作。本系统的功能分为如下几大模块：1.单词模块：包括单词表的建立，单词的录入、修改、删除等基本操作。单词表包括单词和汉语翻译以及初级、中级、高级三种难度单词的分类。单词录入要求能够实现录入(增加)单词及其汉语翻译；修改要求能修改单词的拼写以及其汉语意思；删除即能够删除某一单词记录。2.例句模块：包括例句表的建立，例句的录入、修改、删除等基本操作。例句表包括例句及其中文翻译等。例句录入要求能够实现录入(增加)例句及其汉语翻译；修改要求能修改例句的单词以及其汉语意思；删除即能够删除某一例句记录。3.试题模块：随机生成一份相应难度的单词测试表。可以给出英文单词选择其正确的汉语翻译4.检索模块：包括单词检索和例句检索，。单词检索要实现输入一个单词，可以检索出它的汉语翻译。例句检索要能实现(1)尽量采取学校现有软硬件环境，及先进的管理系统开发方案，从而达到充分利用学校现有资源，提高系统系统开发水平的目的。(2)系统应符合学校学生现有的多媒体条件，满足学生日常英语学习的需要，并达到操作过程的直观，方便，实用等要求。(3)系统采用模块化程序设计方法，既便于系统功能的各种组合和修改。(1)顺序图图1顺序图关键单例句5.系统设计与实现(写清楚每个人负责的模块)苗瑞林：自测，实现单词和例句的修改罗凡钰：实现单词和例句的检索曹旭利：实现例句的录入，删除黄丽：实现单词的录入，删除黄丽：实现单词的录入，删除System.Collections.Generic;usingSystem.Data.SqlClient;{{{}{}{word(Num,word,fanyidengjiVALUES('{0}','{1}','{2}','{3}')"Numwordfanyidengji{MessageBoxButtons.OK,MessageBoxIcon.Information)}{MessageBox.Show("添加失败!","添加失败",MessageBoxButtons.OK,MessageBoxIcon.Information)}}{}{}}}usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Linq;usingSystem.Text;usingSystem.Data.SqlClient;usingSystem.Windows.Forms;namespaceWindowsFormsApplication1{{publicForm4(){InitializeComponent();}privatevoidForm4Load(objectsender,EventArgse){stringConstr="server=.;database=ENGLISHWORD;uid=sa;pwd=123SqlConnectioncon=newSqlConnection(Constr);con.Open();SqlDataAdapteradpt=newSqlDataAdapter(sql,con);DataTabledt=newDataTable();adpt.Fill(dt);dataGridView1.DataSource=dt;}privatevoidbutton1Click(objectsender,EventArgse){stringid=dataGridView1.Rows[0].Cells[0].Value.ToString();stringConstr="server=.;database=ENGLISHWORD;uid=sa;pwd=123SqlConnectioncon=newSqlConnection(Constr);stringsql="DELETEfromwordWHERENum="+id+"";con.Open();SqlCommandcmd=newSqlCommand(sql,con);{cmd.ExecuteNonQuery());MessageBox.Show(message,"删除成功",MessageBoxButtons.OK,MessageBoxIcon.Information);SqlDataAdapteradpt=newSqlDataAdapter(sql1,con);DataTabledt=newDataTable();adpt.Fill(dt);dataGridView1.DataSource=dt;}}privatevoidbutton2Click(objectsender,EventArgse){ssi.Show();this.Visible=false;}privatevoiddataGridView1CellContentClick(objectsender,DataGridViewCellEventArgse){}}}usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Linq;usingSystem.Text;usingSystem.Data.SqlClient;usingSystem.Windows.Forms;namespaceWindowsFormsApplication1{{publicForm7(){InitializeComponent();}privatevoidForm7Load(objectsender,EventArgse){}privatevoidbtnYesClick(objectsender,EventArgse){stringsentencetextBoxTexstringfanyitextBoxTextstringNum=textBox4.Text;stringConstr="server=.;database=ENGLISHWORD;uid=sa;pwd=123SqlConnectioncon=newSqlConnection(Constr);stringsqlStringFormatINsentence(Num,sentence,fanyi,sword)VALUES('{0}','{1}','{2}','{3}')",Num,con.Open();SqlCommandcmd=newSqlCommand(sql,con);SqlCommandcommand=newSqlCommand(sql,con);{MessageBoxButtons.OK,MessageBoxIcon.Information);}{MessageBox.Show("添加失败!","添加失败",MessageBoxButtons.OK,MessageBoxIcon.Information);}}privatevoidlblSwordClick(objectsender,EventArgse){}privatevoidbutton2Click(objectsender,EventArgse){ss.Show();this.Visible=false;}}}usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Linq;usingSystem.Text;usingSystem.Data.SqlClient;usingSystem.Windows.Forms;namespaceWindowsFormsApplication1{{publicForm9(){InitializeComponent();stringConstr="server=.;database=ENGLISHWORD;uid=sa;pwd=123SqlConnectioncon=newSqlConnection(Constr);con.Open();SqlDataAdapteradpt=newSqlDataAdapter(sql,con);DataTabledt=newDataTable();adpt.Fill(dt);dataGridView1.DataSource=dt;}privatevoidbutton3Click(objectsender,EventArgse){stringConstr="server=.;database=ENGLISHWORD;uid=sa;pwd=123SqlConnectioncon=newSqlConnection(Constr);con.Open();SqlCommandcmd=newSqlCommand(sql,con);cmd.ExecuteNonQuery();}privatevoidtextBox1TextChanged(objectsender,EventArgse){}privatevoiddataGridView1CellContentClick(objectsender,DataGridViewCellEventArgse){}privatevoidbutton2Click1(objectsender,EventArgse){ssi.Show();this.Visible=false;}privatevoidbutton1Click1(objectsender,EventArgse){stringid=dataGridView1.Rows[0].Cells[0].Value.ToString();stringConstr="server=.;database=ENGLISHWORD;uid=sa;pwd=123SqlConnectioncon=newSqlConnection(Constr);con.Open();SqlCommandcmd=newSqlCommand(sql,con);{cmd.ExecuteNonQuery());MessageBox.Show(message,"删除成功",MessageBoxButtons.OK,MessageBoxIcon.Information);SqlDataAdapteradpt=newSqlDataAdapter(sql1,con);DataTabledt=newDataTable();adpt.Fill(dt);dataGridView1.DataSource=dt;}}privatevoidForm9Load(objectsender,EventArgse){}}}罗凡钰：实现单词和例句的检索usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Linq;usingSystem.Text;usingSystem.Data.SqlClient;usingSystem.Windows.Forms;namespaceWindowsFormsApplication1{{publicForm2(){InitializeComponent();}privatevoidbutton1Click(objectsender,EventArgse){stringConstr="server=.;database=ENGLISHWORD;uid=sa;pwd=123SqlConnectioncon=newSqlConnection(Constr);con.Open();stringword=textBox1.Text;stringsql=String.Format("selectfanyifromwordwhereword='{0}'",word);SqlCommandcmd=newSqlCommand(sql,con);stringwordone=Convert.ToString(cmd.ExecuteScalar());textBox2.Text=wordone;boolrow=cmd.ExecuteScalar()!=null;{cmd.ExecuteNonQuery());MessageBox.Show(message,"查询成功",MessageBoxButtons.OK,MessageBoxIcon.Information);}{MessageBox.Show("查询失败!","查询失败",MessageBoxButtons.OK,MessageBoxIcon.Information);}}privatevoidbutton2Click(objectsender,EventArgse){Form3asd=newForm3();asd.Show();this.Visible=false;}privatevoidForm2Load(objectsender,EventArgse){}}}{{{}{Convert.ToString(cmd.ExecuteScalar());textBox2.Text=wordone;{cmd.ExecuteNonQuery());MessageBoxButtons.OK,MessageBoxIcon.Information);}{MessageBoxButtons.OK,MessageBoxIcon.Information);}}{}}}苗瑞林：自测，实现单词和例句的修改usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Linq;usingSystem.Text;{{{}{}{word='"+num1+"',fanyi='"+num2+"',Num='"+num+"'";{{MessageBoxButtons.OK,MessageBoxIcon.Information);}{MessageBox.Show("修改失败!","修改失败"MessageBoxButtons.OK,MessageBoxIcon.Information);}}{MessageBox.Show(ex.Message,"操作数据库出错!",MessageBoxButtons.OK,MessageBoxIconExclamation}{}}{}{}}}usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Linq;usingSystem.Text;{{{}{sentence='"+num1+"',sword='"+num2+"',fanyi='numwhereNum='"+num+"'";{{MessageBoxButtons.OK,MessageBoxIcon.Information);}{MessageBoxButtons.OK,MessageBoxIcon.Information);}}{MessageBoxButtons.OK,MessageBoxIcon.Exclamation);}finally{con.Close();}}privatevoidbutton2Click(objectsender,EventArgse){sap.Show();this.Visible=false;}图3添加测试6.2测试环境6.3测试用例及测试结果测试用例1:be是等级：添加英语单词成功!单词删除vordfarvi是4施T是Ⅲ