数据库实验340795

1、实验报告学院（系）名称：计算机与通信工程学院姓名王远志学号20135632专业计算机科学与技术班级2班实验项目实验三：数据库编程课程名称数据库系统课程代码0668026实验时间15年12月7日10：00-13：00实验地点计算机软件实验室7-215批改意见成绩教师签字： 1.实验目的1) 了解常用数据库访问技术2) 掌握ODBC、ADO.NET、JDBC等数据库访问技术3)掌握通过编程的方式对数据库进行操作，为进行数据库课程设计作准备2.实验工具MS SQL server2008、面向对象高级程序设计语言（C#或Java）3.实验内容 完成小型管理信息系统的开发，题目可自选，要求选择一面向对象

2、高级语言，连接后台数据库，以图形界面的方式实现对数据库的增、删、改、查操作。4.实验要求：1）认真完成并按时提交实验报告，在实验报告中附核心源码并给出执行结果截图；2）整理上机步骤，总结经验和体会。实验代码：using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Linq;using System.Text;using System.Threading.Tasks;using System.Windo

3、ws.Forms;using System.Data.SqlClient;namespace doc3 public partial class MainForm : Form public MainForm() InitializeComponent(); private void MainForm_Load(object sender, EventArgs e) DataTable dataTable = DBUtil.QueryData("select sno '学号', sname '姓名', sage '年龄', sdept

4、'学院' from Student"); studentDataGridView.DataSource = dataTable; private void studentDataGridView_CellClick(object sender, DataGridViewCellEventArgs e) int index = studentDataGridView.CurrentCell.RowIndex; / vs2012的写法 snoTextBox.Text = studentDataGridView.Rowsindex.Cells"学号".V

5、alue.ToString(); snameTextBox.Text = studentDataGridView.Rowsindex.Cells"姓名".Value.ToString(); sageTextBox.Text = studentDataGridView.Rowsindex.Cells"年龄".Value.ToString(); sdeptTextBox.Text = studentDataGridView.Rowsindex.Cells"学院".Value.ToString(); private void createS

6、tudentButton_Click(object sender, EventArgs e) string sno = snoTextBox.Text.Trim(); string sname = snameTextBox.Text.Trim(); string sage = sageTextBox.Text.Trim(); string sdept = sdeptTextBox.Text.Trim(); if ("".Equals(sno) | "".Equals(sname) | "".Equals(sage) | "&

7、quot;.Equals(sdept) MessageBox.Show("数据必须全不能为空", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error); else string sql = "insert into Student(sno,sname,sage,sdept) values('" + sno + "', '" + sname + "', '" + sage + "', '

8、" + sdept + "')" if (DBUtil.CUDData(sql) MessageBox.Show("创建操作成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); private void readStudentButton_Click(object sender, EventArgs e) DataTable dataTable = DBUtil.QueryData("select sno '学号', s

9、name '姓名', sage '年龄', sdept '学院' from Student"); studentDataGridView.DataSource = dataTable; private void updateStudentButton_Click(object sender, EventArgs e) string sno = snoTextBox.Text.Trim(); string sname = snameTextBox.Text.Trim(); string sage = sageTextBox.Text.Tr

10、im(); string sdept = sdeptTextBox.Text.Trim(); if ("".Equals(sno) | "".Equals(sname) | "".Equals(sage) | "".Equals(sdept) MessageBox.Show("数据必须全不能为空", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error); else string sql = "update Student

11、 set sname='" + sname + "', sage='" + sage + "', sdept='" + sdept + "' where sno=" + sno; if (DBUtil.CUDData(sql) MessageBox.Show("更新操作成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); private void deleteStud

12、etnButton_Click(object sender, EventArgs e) int index = studentDataGridView.CurrentCell.RowIndex; string sno = studentDataGridView.Rowsindex.Cells"学号".Value.ToString(); string sql = "delete from Student where sno = '" + sno + "'" if (DBUtil.CUDData(sql) MessageB

13、ox.Show("删除操作成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); private void readScoreButton_Click(object sender, EventArgs e) string sql = "select * from Score" DataTable dataTable = DBUtil.QueryData(sql); scoreListView.GridLines = true; scoreListView.FullR

14、owSelect = true; / 初始化scoreListView的列 scoreListView.View = View.Details; scoreListView.Columns.Clear(); scoreListView.Columns.Add("学号", 268, HorizontalAlignment.Left); scoreListView.Columns.Add("成绩", 266, HorizontalAlignment.Left); scoreListView.Items.Clear(); / 将DataTable转换为Data

15、TableReader DataTableReader dr = dataTable.CreateDataReader(); while (dr.Read() ListViewItem lvi = new ListViewItem(dr0.ToString(); lvi.SubItems.Add(dr1.ToString(); scoreListView.Items.Add(lvi); private void createScoreButton_Click(object sender, EventArgs e) string sno = ssnoTextbox.Text.Trim(); st

16、ring sscore = sscoreTextBox.Text.Trim(); if ("".Equals(sno) | "".Equals(sscore) MessageBox.Show("数据必须全不能为空", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error); else string sql = "insert into Score(sno,sscore) values('" + sno + "', '" + sscore + "')" if (DBUtil.CUDData(sql) MessageBox.Show("创建操作成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); private void ssnoTextbox_TextChanged(object sender, EventArgs e) private void snoTextBox_TextChanged(object sender, EventArg