數(shù)據(jù)庫開發(fā)第六次實(shí)驗(yàn)報(bào)告

1、寧波大學(xué)商學(xué)院實(shí)驗(yàn)報(bào)告實(shí)驗(yàn)課程名稱： 數(shù)據(jù)庫開發(fā)與應(yīng)用 學(xué) 院： 商學(xué)院 專 業(yè)： 信息管理與信息系統(tǒng) 指導(dǎo)教師： 張宇萌 報(bào)告人姓名： 李杰 學(xué)號(hào)： 156001240 班 級(jí)： 15信管 學(xué) 期： 大二第二學(xué)期 商學(xué)院商科實(shí)驗(yàn)教學(xué)中心制實(shí)驗(yàn)成績(jī)實(shí)驗(yàn)項(xiàng)目名稱實(shí)現(xiàn)MDI窗口查找（模糊查找）、修改、刪除功能。一、實(shí)驗(yàn)?zāi)康呐c要求： 實(shí)現(xiàn)MDI窗口查找（模糊查找）、修改、刪除功能。二、實(shí)驗(yàn)設(shè)備及軟件：三、實(shí)驗(yàn)方法（原理、流程圖）四、實(shí)驗(yàn)過程、步驟及內(nèi)容一、代碼：namespace 添加數(shù)據(jù)庫數(shù)據(jù) public partial class Form1 : Form public Form1() Ini

2、tializeComponent(); OleDbConnection Database1 = new OleDbConnection(); OleDbCommand CMD = new OleDbCommand(); DataSet dt = new DataSet(); OleDbDataAdapter adpater = new OleDbDataAdapter(); private void button1_Click(object sender, EventArgs e) Database1.ConnectionString = Provider=Microsoft.Jet.OLED

3、B.4.0;Data Source=D:C+作業(yè)Database1.mdb; CMD.Connection = Database1; Database1.Open(); CMD.CommandText = Select 學(xué)號(hào) from students where 學(xué)號(hào) = + textBox1.Text + ; object t = CMD.ExecuteScalar(); if (t != null) MessageBox.Show(該學(xué)號(hào)已存在); return; CMD.CommandText = insert into students(學(xué)號(hào),姓名,班級(jí),性別) values( +

4、textBox1.Text + , + textBox2.Text + , + textBox3.Text + , + textBox4.Text + ); CMD.ExecuteNonQuery(); dt.Clear(); CMD.CommandText = Select 姓名,學(xué)號(hào),班級(jí),性別 from students; adpater.SelectCommand = CMD; adpater.Fill(dt, students); dataGridView1.DataSource = dt.Tablesstudents; Database1.Close(); MessageBox.S

5、how(添加成功！); private void button2_Click(object sender, EventArgs e) Database1.ConnectionString = Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:C+作業(yè)Database1.mdb; CMD.Connection = Database1; Database1.Open(); CMD.CommandText = Select 課程號(hào) from course where 課程號(hào) = + textBox5.Text + ; object t = CMD.Exec

6、uteScalar(); if (t != null) MessageBox.Show(該課程號(hào)已存在); return; CMD.CommandText = insert into course(課程號(hào),課程名,學(xué)分) values( + textBox5.Text + , + textBox6.Text + , + textBox7.Text + ); Database1.Close(); MessageBox.Show(添加成功！); private void button3_Click(object sender, EventArgs e) dt.Clear(); Database1.

7、ConnectionString = Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:C+作業(yè)Database1.mdb; CMD.Connection = Database1; Database1.Open(); CMD.CommandText = Select 姓名,學(xué)號(hào),班級(jí),性別 from students where 學(xué)號(hào) like% + textBox1.Text + %; adpater.SelectCommand = CMD; adpater.Fill(dt, students); dataGridView1.DataSource

8、= dt.Tablesstudents; Database1.Close(); private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e) textBox1.Text = dataGridView1學(xué)號(hào), e.RowIndex.Value.ToString(); textBox2.Text = dataGridView1姓名, e.RowIndex.Value.ToString(); textBox3.Text = dataGridView1班級(jí), e.RowIndex.Value.ToStr

9、ing(); textBox4.Text = dataGridView1性別, e.RowIndex.Value.ToString(); private void button4_Click(object sender, EventArgs e) Database1.ConnectionString = Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:C+作業(yè)Database1.mdb; CMD.Connection = Database1; Database1.Open(); CMD.CommandText = update students s

10、et 學(xué)號(hào)= + textBox1.Text +,姓名= + textBox2.Text + ,班級(jí)= + textBox3.Text +,性別= + textBox4.Text + where 學(xué)號(hào)= + textBox1.Text + ; CMD.ExecuteNonQuery(); dt.Clear(); CMD.CommandText = Select 姓名,學(xué)號(hào),班級(jí),性別 from students; adpater.SelectCommand = CMD; adpater.Fill(dt, students); dataGridView1.DataSource = dt.Tabl

11、esstudents; Database1.Close(); private void button5_Click(object sender, EventArgs e) Database1.ConnectionString = Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:C+作業(yè)Database1.mdb; CMD.Connection = Database1; Database1.Open(); CMD.CommandText = Delete from students where 學(xué)號(hào)= + textBox1.Text + ; CMD.ExecuteNonQuery(); dt.Clear(); CMD.CommandText = Select 姓名,學(xué)號(hào),班級(jí),性別 from students; adpater.SelectCommand = CMD; adpater.Fill(dt, students); dataGridView1.DataSource = dt.Table