數(shù)據(jù)庫課程設(shè)計(jì)80203

1、 安徽工業(yè)大學(xué)工商學(xué)院數(shù)據(jù)庫課程設(shè)計(jì)報(bào)告學(xué)生信息管理系統(tǒng) 姓名：金村界 學(xué)號(hào)：141842211 專業(yè)：計(jì)算機(jī)科學(xué)與技術(shù) 班級(jí)：計(jì)1441 教師：甘麗2017.1.31、 題目：學(xué)生信息管理系統(tǒng) 學(xué)生信息管理是一個(gè)教育單位不可缺少的部分，它的內(nèi)容對(duì)于學(xué)校的決策者和管理者來說都是至關(guān)重要的。所以學(xué)生信息管理系統(tǒng)應(yīng)該能夠?yàn)橛脩籼峁┏渥愕男畔⒑涂旖莸牟樵兪侄巍１鞠到y(tǒng)采用Microsoft Visual Studio 2010作為開發(fā)工具，Microsoft SQL Server 2012建立數(shù)據(jù)庫，并進(jìn)行初始數(shù)據(jù)輸入，在進(jìn)行界面的設(shè)計(jì)和代碼的編寫，界面簡潔，功能明確，方便了工作人員的操作。二、開發(fā)工

2、具：Microsoft Visual Studio 2010三、數(shù)據(jù)庫：Microsoft SQL Server 2012 Microsoft SQL Server 2012是一套完整的數(shù)據(jù)庫和分析產(chǎn)品，具有高度的可擴(kuò)展性和可靠性，對(duì)市場的快速反應(yīng)能力強(qiáng)，可以快速構(gòu)建各種業(yè)務(wù)和方案，具有高度的安全性保障。四、操作系統(tǒng)：Microsoft windows 10五、功能圖登錄添加更改刪除 查詢6、 用戶視圖與代碼1、登錄頁面using System;using System.Collections.Generic;using System.ComponentModel;using System.D

3、ata;using System.Drawing;using System.Linq;using System.Text;using System.Windows.Forms;using System.Data.SqlClient;namespace 測試 public partial class Form1 : Form public Form1() InitializeComponent(); private void label1_Click(object sender, EventArgs e) private void comboBox1_SelectedIndexChanged(o

4、bject sender, EventArgs e) if (comboBox1.Text = "學(xué)生") pictureBox1.Image = Image.FromFile("pic1.jpg"); if (comboBox1.Text = "教師") pictureBox1.Image = Image.FromFile("pic2.jpg"); private void button2_Click(object sender, EventArgs e) string str, sql; str = "

5、;Server=.;Database=學(xué)生信息管理系統(tǒng);User id='sa'pwd='167349'" SqlConnection conn = new SqlConnection(str); conn.Open(); sql = "select * from 教師登入表 where zh='" + textBox1.Text + "' and mima='" + textBox2.Text + "'" SqlCommand cmd = new SqlCom

6、mand(sql, conn); cmd.CommandType = CommandType.Text; SqlDataReader sdr; sdr = cmd.ExecuteReader(); if (sdr.Read() && comboBox1.Text = "教師") Form3 form2 = new Form3(); form2.Show(); else if (comboBox1.Text = "請(qǐng)選擇") MessageBox.Show("未選擇登錄選項(xiàng)"); else MessageBox.Show

7、("賬號(hào)或密碼錯(cuò)誤！", "錯(cuò)誤提示", MessageBoxButtons.OK, MessageBoxIcon.Error); private void button3_Click(object sender, EventArgs e) this.Dispose(); 2、功能頁面 using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Linq;using

8、 System.Text;using System.Windows.Forms;namespace 測試 public partial class Form3 : Form public Form3() InitializeComponent(); private void radioButton1_CheckedChanged(object sender, EventArgs e) private void radioButton2_CheckedChanged(object sender, EventArgs e) private void radioButton3_CheckedChan

9、ged(object sender, EventArgs e) private void radioButton4_CheckedChanged(object sender, EventArgs e) private void button2_Click(object sender, EventArgs e) if (radioButton1.Checked) Form4 f = new Form4(); f.Show(); if (radioButton2.Checked) Form5 f = new Form5(); f.Show(); if (radioButton3.Checked)

10、Form6 f = new Form6(); f.Show(); if (radioButton4.Checked) Form7 f = new Form7(); f.Show(); private void button1_Click(object sender, EventArgs e) this.Dispose(); private void groupBox1_Enter(object sender, EventArgs e) private void label2_Click(object sender, EventArgs e) 系統(tǒng)功能：（1） 查詢 using System;u

11、sing System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Linq;using System.Text;using System.Windows.Forms;using System.Data.SqlClient;namespace 測試 public partial class Form4 : Form public Form4() InitializeComponent(); private void dataGridView

12、1_CellContentClick(object sender, DataGridViewCellEventArgs e) private void button1_Click(object sender, EventArgs e) /查詢 string str = "Server=.;Database=學(xué)生信息管理系統(tǒng);User id='sa'pwd='167349'" SqlConnection con = new SqlConnection(str); String sqlstr = "Select 姓名,性別,專

13、業(yè),班級(jí) From stu where 學(xué)號(hào) = '" + textBox1.Text + "'" SqlDataAdapter dr = new SqlDataAdapter(sqlstr,con); DataSet DataSet1 = new DataSet(); dr.Fill(DataSet1,"stu"); dataGridView1.DataSource = DataSet1.Tables"stu" private void butto

14、n2_Click(object sender, EventArgs e) this.Dispose(); private void button3_Click(object sender, EventArgs e) Form3 thild = new Form3(); thild.Show(); this.Dispose(); private void Form4_Load(object sender, EventArgs e) （2） 刪除 using System;using System.Collections.Generic;using System.ComponentModel;us

15、ing System.Data;using System.Drawing;using System.Linq;using System.Text;using System.Windows.Forms;using System.Data.SqlClient;namespace 測試 public partial class Form5 : Form public Form5() InitializeComponent(); private void button1_Click(object sender, EventArgs e) string str = "Server=.;Data

16、base=學(xué)生信息管理系統(tǒng);User id='sa'pwd='167349'" SqlConnection con = new SqlConnection(str); String sqlstr = "Select 姓名,性別,專業(yè),班級(jí) From stu where 學(xué)號(hào) = '" + textBox1.Text + "'" SqlDataAdapter dr = new SqlDataAdapter(sqlstr, con)

17、; DataSet DataSet1 = new DataSet(); dr.Fill(DataSet1, "stu"); dataGridView1.DataSource = DataSet1.Tables"stu" private void button2_Click(object sender, EventArgs e) string str = "Server=.;Database=學(xué)生信息管理系統(tǒng);User id='sa'pwd='167349'" SqlConnection con = ne

18、w SqlConnection(str); String sqlstr = "delete  From stu where 學(xué)號(hào)='" + textBox1.Text + "'" SqlCommand mycom2 = new SqlCommand(sqlstr, con); con.Open(); mycom2.ExecuteNonQuery(); MessageBox.Show("該學(xué)生信息刪除成功!", "恭喜", MessageBoxButt

19、ons.OK, MessageBoxIcon.Information); private void button3_Click(object sender, EventArgs e) Form3 thild = new Form3(); thild.Show(); this.Dispose(); private void button4_Click(object sender, EventArgs e) this.Dispose(); private void Form5_Load(object sender, EventArgs e) （3） 更改 using System;using Sy

20、stem.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Linq;using System.Text;using System.Windows.Forms;using System.Data.SqlClient;namespace 測試 public partial class Form6 : Form public Form6() InitializeComponent(); private void groupBox1_Enter(obj

21、ect sender, EventArgs e) private void textBox2_TextChanged(object sender, EventArgs e) private void button2_Click(object sender, EventArgs e) String Sex; if (radioButton1.Checked = true) Sex = "男" else Sex = "女" string str = "Server=.;Database=學(xué)生信息管理系統(tǒng);User id='sa'pw

22、d='167349'" SqlConnection con = new SqlConnection(str); String sqlstr = "update stu set 學(xué)號(hào)='" + textBox2.Text + "' ,姓名='" + textBox3.Text + "',性別='" + Sex + "',專業(yè)='" + textBox6.Text + "',年齡=

23、'" + textBox5.Text + "',班級(jí)='" + textBox4.Text + "' Where 學(xué)號(hào)='" + textBox1.Text + "'" SqlCommand mycom1 = new SqlCommand(sqlstr, con); con.Open(); mycom1.ExecuteNonQuery(); MessageBox.Show("該學(xué)生信息更新成功!", "恭喜", Mes

24、sageBoxButtons.OK, MessageBoxIcon.Information); con.Close(); private void button1_Click(object sender, EventArgs e) string str = "Server=.;Database=學(xué)生信息管理系統(tǒng);User id='sa'pwd='167349'" SqlConnection con = new SqlConnection(str); String sqlstr = "Select 學(xué)號(hào),姓名,專業(yè),性別,年

25、齡,班級(jí) From stu where 學(xué)號(hào) = '" + textBox1.Text + "'" SqlDataAdapter dr = new SqlDataAdapter(sqlstr, con); DataSet DataSet1 = new DataSet(); dr.Fill(DataSet1, "stu"); dataGridView1.DataSource = DataSet1.Tables"stu" private void but

26、ton3_Click_1(object sender, EventArgs e) Form3 fiveth = new Form3(); fiveth.Show(); this.Dispose(); private void Form6_Load(object sender, EventArgs e) （4） 添加 using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Linq;using Syst

27、em.Text;using System.Windows.Forms;using System.Data.SqlClient;namespace 測試 public partial class Form7 : Form public Form7() InitializeComponent(); private void label1_Click(object sender, EventArgs e) private void button1_Click(object sender, EventArgs e) String Sex; if (radioButton1.Checked = true) Sex = "男" else Sex = "女" string str = "Server=.;Database=學(xué)生信息管理系統(tǒng);User id='sa'pwd='167349'" SqlConnection con = new SqlConnection(str); String sqlstr = "insert into stu(學(xué)號(hào),姓名,性別,專業(yè),年齡,班級(jí))