数据库实验报告.docx

1、数据库实验报告重庆交通大学信息科学与工程学院设计性实验报告专 业：计算机科学与技术 （软件开发）班 级： 2013 级 2 班 学 号： 姓 名： 课 程 名 称： 数据库原理 实验项目性质： 设计性实验 实验所属课程： 数据库原理 实验室(中心)： 软件与通信实验室 指 导 教 师 ： 王家伟 实验完成时间： 2015 年 12 月 日此页必须保留评分标准及成绩评分细则评分报告表述的清晰程度和完整性（20分）概念模型的合理性（20分）逻辑模型的合理性（20分）功能合理性（20分）功能完善性（10分）个人体会（10分）总成绩教师签名日期总体实验要求：1 排版要求标题用黑体四号，段前、段后距6磅

2、（或0.3行）；正文用小四号宋体，行距为1.5倍行距。报告必须生成目录，目录必须带页码。2 设计报告需要打印，装订，1份/人，理论课考试时交设计报告。3 各班学习委员收集每位同学做的成果，包含数据库的备份、程序源代码和运行配置说明，并将每位同学的成果拷贝到软件与通信实验室的教师机上。报告正文一、 实验目的1、根据给定的题目，把现实世界中的具体事物抽象为某一概念级的模型，即建立整个问题的概念模型，建立起数据库设计人员与用户之间的交流，为数据模型的建立奠定基础。2、学习C#下怎么访问数据库；3、使用C#编写简单的数据库程序。二、实验内容及要求题目描述：某大学需要使用计算机管理学生信息、成绩信息等，

3、要求如下：1、学生信息管理，包含学生的基本信息，如学号、姓名、性别、出生日期等；还要包含学生的简历、社会关系等；2、课程管理，包含整个学校开设的所有课程；3、教学计划管理，包含设定各系各专业在哪学期开设什么样的课程，学分是多少；4、学生选课管理，包含学生在某学期选择什么样的课程；5、学生成绩管理，包含学生各课程的成绩、是否补考、补考成绩；6、学生奖惩管理，管理学生在校期间所获得的奖励和惩罚记录。根据实验一的结果，完成设计。可以根据自己的实际情况实现一部分也可。三、实验设备及软件实验设备：电脑一台；软件：powerdesigner15.1、SQL Server2008、Visual Studio

4、 2013。四、实验步骤1、建立概念模型。打开powerdesigner15.1，通过对问题抽象出实体，然后开始建立概念模型。概念模型及实体列表如下图所示：2、由概念模型转物理模型。在check model没有错之后，选择Tools-Generate Physical Data Model，开始转为物理模，步骤及物理模型如下：3、导出SQL语句，选择DataBase-Generate DataBase开始导出SQL语句，如下：4、根据导出的SQL语句开始建立数据库。5、利用Visual Studio 2013开始编写程序。五、实验结果及说明在所有窗口中，除了主页外，其他窗口加载时自动连接数据库

5、，关闭窗口时自动断开数据库。六、主要代码1、MyHomePage窗口的主要代码 private void 输入学生信息ToolStripMenuItem_Click(object sender, EventArgs e) Student ob = new Student(); ob.ShowDialog(); private void 课程信息ToolStripMenuItem_Click(object sender, EventArgs e) Course ob = new Course(); ob.ShowDialog(); private void 输入ToolStripMenuItem

6、_Click(object sender, EventArgs e) College ob = new College(); ob.ShowDialog(); private void 民族信息ToolStripMenuItem_Click(object sender, EventArgs e) Nation ob = new Nation(); ob.ShowDialog(); private void 考试信息ToolStripMenuItem_Click(object sender, EventArgs e) ExamSort ob = new ExamSort(); ob.ShowDi

7、alog(); private void 输入课程管理信息ToolStripMenuItem_Click(object sender, EventArgs e) CourseManage ob = new CourseManage(); ob.ShowDialog(); private void 输入政治面貌信息ToolStripMenuItem_Click(object sender, EventArgs e) Politics ob = new Politics(); ob.ShowDialog(); private void 输入成绩管理信息ToolStripMenuItem_Click

8、(object sender, EventArgs e) ResultManage ob = new ResultManage(); ob.ShowDialog(); private void 输入简历信息ToolStripMenuItem_Click(object sender, EventArgs e) StudentResume ob = new StudentResume(); ob.ShowDialog(); private void 输入奖惩制度信息ToolStripMenuItem_Click(object sender, EventArgs e) Punishment ob =

9、 new Punishment(); ob.ShowDialog(); private void 输入奖惩管理信息ToolStripMenuItem_Click(object sender, EventArgs e) PunishmentManage ob = new PunishmentManage(); ob.ShowDialog(); private void 输入社会关系信息ToolStripMenuItem_Click(object sender, EventArgs e) SocialRelation ob = new SocialRelation(); ob.ShowDialog

10、(); private void 输入专业信息ToolStripMenuItem_Click(object sender, EventArgs e) Specialty ob = new Specialty(); ob.ShowDialog(); private void 输入教学计划ToolStripMenuItem_Click(object sender, EventArgs e) TeachPlanManage ob = new TeachPlanManage(); ob.ShowDialog(); private void 信息显示ToolStripMenuItem_Click(obj

11、ect sender, EventArgs e) InformationView ob = new InformationView(); ob.ShowDialog(); private void 输入学生选课ToolStripMenuItem_Click(object sender, EventArgs e) ChooseCourse ob = new ChooseCourse(); ob.ShowDialog(); 2、输入窗口的主要带只有部分细小的不同，主要是SQL语句改变为相应的表即可，一下粘贴Student窗口代码做代表：private void button1_Click(obje

12、ct sender, EventArgs e) string strSQL; strSQL = Insert into Student (sid,specialtyid,politicsid,nationid,sname,ssex,grade,birthday) values( + textBox1.Text + , + textBox2.Text + , + textBox3.Text + , + textBox4.Text + , + textBox5.Text + , + textBox6.Text + , +textBox7.Text + ,+textBox8.Text+); SqlC

13、ommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandType = CommandType.Text; cmd.CommandText = strSQL; try cmd.ExecuteNonQuery(); textBox1.Text = textBox2.Text = textBox3.Text = textBox4.Text = textBox5.Text = textBox6.Text = textBox7.Text = textBox8.Text = ; catch MessageBox.Show(写入数据库

14、失败！); private void Student_Load(object sender, EventArgs e) try string strConn = server=USER-20150909CT;database= Manage;integrated security=true; conn = new SqlConnection(strConn); conn.Open(); catch (Exception err) MessageBox.Show(err.Message); private void Student_FormClosed(object sender, FormCl

15、osedEventArgs e) try conn.Close(); catch (Exception err) MessageBox.Show(err.Message); 3、InformationView窗口的主要代码： TreeNode node; DataSet ds = new DataSet(); public InformationView() InitializeComponent(); SqlConnection conn; string choose = ; string mainid = ; private void treeView1_AfterSelect(objec

16、t sender, TreeViewEventArgs e) switch (treeView1.SelectedNode.Text) case 学生信息: dataGridView1.DataSource = ds; dataGridView1.DataMember = Student; break; case 教学计划: dataGridView1.DataSource = ds; dataGridView1.DataMember = TeachPlan; break; case 选课: dataGridView1.DataSource = ds; dataGridView1.DataMe

17、mber = ChooseCourse; break; case 学院: dataGridView1.DataSource = ds; dataGridView1.DataMember = College; break; case 课程: dataGridView1.DataSource = ds; dataGridView1.DataMember = Course; break; case 课程管理: dataGridView1.DataSource = ds; dataGridView1.DataMember = CourseManage; break; case 考试种类: dataGr

18、idView1.DataSource = ds; dataGridView1.DataMember = ExamSort; break; case 民族: dataGridView1.DataSource = ds; dataGridView1.DataMember = Nation; break; case 政治面貌: dataGridView1.DataSource = ds; dataGridView1.DataMember = PoliticsStatus; break; case 成绩管理: dataGridView1.DataSource = ds; dataGridView1.D

19、ataMember = ResultManage; break; case 简历: dataGridView1.DataSource = ds; dataGridView1.DataMember = Resume; choose = Resume; break; case 奖惩制度: dataGridView1.DataSource = ds; dataGridView1.DataMember = RewardPunishment; break; case 奖惩管理: dataGridView1.DataSource = ds; dataGridView1.DataMember = RPMan

20、age; break; case 社会关系: dataGridView1.DataSource = ds; dataGridView1.DataMember = SocialRelation; break; case 专业: dataGridView1.DataSource = ds; dataGridView1.DataMember = Specialty; break; private void InformationView_Load(object sender, EventArgs e) try string strConn = server=USER-20150909CT;datab

21、ase= Manage;integrated security=true; conn = new SqlConnection(strConn); conn.Open(); catch (Exception err) MessageBox.Show(err.Message); node = treeView1.Nodes.Add(学生信息); node = treeView1.Nodes.Add(教学计划); node = treeView1.Nodes.Add(选课); node = treeView1.Nodes.Add(学院); node = treeView1.Nodes.Add(课程)

22、; node = treeView1.Nodes.Add(课程管理); node = treeView1.Nodes.Add(考试种类); node = treeView1.Nodes.Add(民族); node = treeView1.Nodes.Add(政治面貌); node = treeView1.Nodes.Add(成绩管理); node = treeView1.Nodes.Add(简历); node = treeView1.Nodes.Add(奖惩制度); node = treeView1.Nodes.Add(奖惩管理); node = treeView1.Nodes.Add(社会关

23、系); node = treeView1.Nodes.Add(专业); SqlDataAdapter adapter = new SqlDataAdapter(); SqlCommand cmd = new SqlCommand(Select * from Student, conn); adapter.SelectCommand = cmd; adapter.Fill(ds, Student); adapter = new SqlDataAdapter(); cmd = new SqlCommand(Select*from TeachPlan, conn); adapter.SelectCo

24、mmand = cmd; adapter.Fill(ds, TeachPlan); adapter = new SqlDataAdapter(); cmd = new SqlCommand(Select*from ChooseCourse, conn); adapter.SelectCommand = cmd; adapter.Fill(ds, ChooseCourse); adapter = new SqlDataAdapter(); cmd = new SqlCommand(Select*from College, conn); adapter.SelectCommand = cmd; a

25、dapter.Fill(ds, College); adapter = new SqlDataAdapter(); cmd = new SqlCommand(Select*from Course, conn); adapter.SelectCommand = cmd; adapter.Fill(ds, Course); adapter = new SqlDataAdapter(); cmd = new SqlCommand(Select*from CourseManage, conn); adapter.SelectCommand = cmd; adapter.Fill(ds, CourseM

26、anage); adapter = new SqlDataAdapter(); cmd = new SqlCommand(Select*from ExamSort, conn); adapter.SelectCommand = cmd; adapter.Fill(ds, ExamSort); adapter = new SqlDataAdapter(); cmd = new SqlCommand(Select*from Nation, conn); adapter.SelectCommand = cmd; adapter.Fill(ds, Nation); adapter = new SqlD

27、ataAdapter(); cmd = new SqlCommand(Select*from PoliticsStatus, conn); adapter.SelectCommand = cmd; adapter.Fill(ds, PoliticsStatus); adapter = new SqlDataAdapter(); cmd = new SqlCommand(Select*from ResultManage, conn); adapter.SelectCommand = cmd; adapter.Fill(ds, ResultManage); adapter = new SqlDat

28、aAdapter(); cmd = new SqlCommand(Select*from Resume, conn); adapter.SelectCommand = cmd; adapter.Fill(ds, Resume); adapter = new SqlDataAdapter(); cmd = new SqlCommand(Select*from RewardPunishment, conn); adapter.SelectCommand = cmd; adapter.Fill(ds, RewardPunishment); adapter = new SqlDataAdapter()

29、; cmd = new SqlCommand(Select*from RPManage, conn); adapter.SelectCommand = cmd; adapter.Fill(ds, RPManage); adapter = new SqlDataAdapter(); cmd = new SqlCommand(Select*from SocialRelation, conn); adapter.SelectCommand = cmd; adapter.Fill(ds, SocialRelation); adapter = new SqlDataAdapter(); cmd = new SqlCommand(Select*from Specialty, conn); adapter.SelectCommand = cmd; adapter.Fill(ds, Specialty); private void InformationView_FormClosed(object sender, FormClosedEventArgs e) try c