数据库课程设计

工业大学工商学院数据库课程设计报告学生信息管理系统：金村界学号：141842211专业：计算机科学与技术班级：计1441教师：甘丽2017.1.3题目：学生信息管理系统学生信息管理是一个教育单位不可缺少的部分，它的容对于学校的决策者和管理者来说都是至关重要的。所以学生信息管理系统应该能够为用户提供充足的信息和快捷的查询手段。本系统采用MicrosoftVisualStudio2010作为开发工具，MicrosoftSQLServer2012建立数据库，并进行初始数据输入，在进行界面的设计和代码的编写，界面简洁，功能明确，方便了工作人员的操作。二、开发工具：MicrosoftVisualStudio2010三、数据库：MicrosoftSQLServer2012MicrosoftSQLServer2012是一套完整的数据库和分析产品，具有高度的可扩展性和可靠性，对市场的快速反应能力强，可以快速构建各种业务和方案，具有高度的安全性保障。四、操作系统：Microsoftwindows10五、功能图登录登录添加更改删除查询添加更改删除查询用户视图与代码1、登录页面usingSystem;usingSystem.Collections.Generic;usingSystem.ponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Linq;usingSystem.Text;usingSystem.Windows.Forms;usingSystem.Data.SqlClient;namespace测试{publicpartialclassForm1:Form{publicForm1(){Initializeponent();}privatevoidlabel1_Click(objectsender,EventArgse){}privatevoidboBox1_SelectedIndexChanged(objectsender,EventArgse){if(boBox1.Text=="学生")pictureBox1.Image=Image.FromFile("pic\\1.jpg");if(boBox1.Text=="教师")pictureBox1.Image=Image.FromFile("pic\\2.jpg");}privatevoidbutton2_Click(objectsender,EventArgse){stringstr,sql;str="Server=.;Database=学生信息管理系统;Userid='sa';pwd='167349'";SqlConnectionconn=newSqlConnection(str);conn.Open();sql="select*from教师登入表wherezh='"+textBox1.Text+"'andmima='"+textBox2.Text+"'";Sqlmandcmd=newSqlmand(sql,conn);cmd.mandType=mandType.Text;SqlDataReadersdr;sdr=cmd.ExecuteReader();if(sdr.Read()&&boBox1.Text=="教师"){Form3form2=newForm3();form2.Show();}elseif(boBox1.Text=="请选择")MessageBox.Show("未选择登录选项");elseMessageBox.Show("账号或密码错误！","错误提示",MessageBoxButtons.OK,MessageBoxIcon.Error);}privatevoidbutton3_Click(objectsender,EventArgse){this.Dispose();}}}2、功能页面usingSystem;usingSystem.Collections.Generic;usingSystem.ponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Linq;usingSystem.Text;usingSystem.Windows.Forms;namespace测试{publicpartialclassForm3:Form{publicForm3(){Initializeponent();}privatevoidradioButton1_CheckedChanged(objectsender,EventArgse){}privatevoidradioButton2_CheckedChanged(objectsender,EventArgse){}privatevoidradioButton3_CheckedChanged(objectsender,EventArgse){}privatevoidradioButton4_CheckedChanged(objectsender,EventArgse){}privatevoidbutton2_Click(objectsender,EventArgse){if(radioButton1.Checked){Form4f=newForm4();f.Show();}if(radioButton2.Checked){Form5f=newForm5();f.Show();}if(radioButton3.Checked){Form6f=newForm6();f.Show();}if(radioButton4.Checked){Form7f=newForm7();f.Show();}}privatevoidbutton1_Click(objectsender,EventArgse){this.Dispose();}privatevoidgroupBox1_Enter(objectsender,EventArgse){}privatevoidlabel2_Click(objectsender,EventArgse){}}}系统功能：查询usingSystem;usingSystem.Collections.Generic;usingSystem.ponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Linq;usingSystem.Text;usingSystem.Windows.Forms;usingSystem.Data.SqlClient;namespace测试{publicpartialclassForm4:Form{publicForm4(){Initializeponent();}privatevoiddataGridView1_CellContentClick(objectsender,DataGridViewCellEventArgse){}privatevoidbutton1_Click(objectsender,EventArgse)//查询{stringstr="Server=.;Database=学生信息管理系统;Userid='sa';pwd='167349'";SqlConnectioncon=newSqlConnection(str);Stringsqlstr="Select

,性别,专业,班级

From

stu

where

学号

=

'"+textBox1.Text+"'";SqlDataAdapterdr=newSqlDataAdapter(sqlstr,con);DataSetDataSet1=newDataSet();dr.Fill(DataSet1,"stu");dataGridView1.DataSource=DataSet1.Tables["stu"];}privatevoidbutton2_Click(objectsender,EventArgse){this.Dispose();}privatevoidbutton3_Click(objectsender,EventArgse){Form3thild=newForm3();thild.Show();this.Dispose();}privatevoidForm4_Load(objectsender,EventArgse){}}}删除usingSystem;usingSystem.Collections.Generic;usingSystem.ponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Linq;usingSystem.Text;usingSystem.Windows.Forms;usingSystem.Data.SqlClient;namespace测试{publicpartialclassForm5:Form{publicForm5(){Initializeponent();}privatevoidbutton1_Click(objectsender,EventArgse){stringstr="Server=.;Database=学生信息管理系统;Userid='sa';pwd='167349'";SqlConnectioncon=newSqlConnection(str);Stringsqlstr="Select

,性别,专业,班级

From

stu

where

学号

=

'"+textBox1.Text+"'";SqlDataAdapterdr=newSqlDataAdapter(sqlstr,con);DataSetDataSet1=newDataSet();dr.Fill(DataSet1,"stu");dataGridView1.DataSource=DataSet1.Tables["stu"];}privatevoidbutton2_Click(objectsender,EventArgse){stringstr="Server=.;Database=学生信息管理系统;Userid='sa';pwd='167349'";SqlConnectioncon=newSqlConnection(str);Stringsqlstr="delete

From

stu

where

学号='"+textBox1.Text+"'";Sqlmandmy2=newSqlmand(sqlstr,con);con.Open();my2.ExecuteNonQuery();MessageBox.Show("该学生信息删除成功!","恭喜",MessageBoxButtons.OK,MessageBoxIcon.Information);}privatevoidbutton3_Click(objectsender,EventArgse){Form3thild=newForm3();thild.Show();this.Dispose();}privatevoidbutton4_Click(objectsender,EventArgse){this.Dispose();}privatevoidForm5_Load(objectsender,EventArgse){}}}更改usingSystem;usingSystem.Collections.Generic;usingSystem.ponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Linq;usingSystem.Text;usingSystem.Windows.Forms;usingSystem.Data.SqlClient;namespace测试{publicpartialclassForm6:Form{publicForm6(){Initializeponent();}privatevoidgroupBox1_Enter(objectsender,EventArgse){}privatevoidtextBox2_TextChanged(objectsender,EventArgse){}privatevoidbutton2_Click(objectsender,EventArgse){StringSex;if(radioButton1.Checked==true){Sex="男";}else{Sex="女";}stringstr="Server=.;Database=学生信息管理系统;Userid='sa';pwd='167349'";SqlConnectioncon=newSqlConnection(str);Stringsqlstr="update

stu

set

学号='"+textBox2.Text+"'

,='"+textBox3.Text+"',性别='"+Sex+"',专业='"+textBox6.Text+"',年龄='"+textBox5.Text+"',班级='"+textBox4.Text+"'

Where

学号='"+textBox1.Text+"'";Sqlmandmy1=newSqlmand(sqlstr,con);con.Open();my1.ExecuteNonQuery();MessageBox.Show("该学生信息更新成功!","恭喜",MessageBoxButtons.OK,MessageBoxIcon.Information);con.Close();}privatevoidbutton1_Click(objectsender,EventArgse){stringstr="Server=.;Database=学生信息管理系统;Userid='sa';pwd='167349'";SqlConnectioncon=newSqlConnection(str);Stringsqlstr="Select

学号,,专业,性别,年龄,班级

From

stu

where

学号

=

'"+textBox1.Text+"'";SqlDataAdapterdr=newSqlDataAdapter(sqlstr,con);DataSetDataSet1=newDataSet();dr.Fill(DataSet1,"stu");dataGridView1.DataSource=DataSet1.Tables["stu"];}privatevoidbutton3_Click_1(objectsender,EventArgse){Form3fiveth=newForm3();fiveth.Show();this.Dispose();}privatevoidForm6_Load(objectsender,EventArgse){}}}添加usingSystem;usingSystem.Collections.Generic;usingSystem.ponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Linq;usingSystem.Text;usingSystem.Windows.Forms;usingSystem.Data.SqlClient;namespace测试{publicpartialclassForm7:Form{publicForm7(){Initializeponent();}privatevoidlabel1_Click(objectsender,EventArgse){}privatevoidbutton1_Click(objectsender,EventArgse){StringSex;if(radioButton1.Checked==true){Sex="男";}else{Sex="女";}stringstr="Server=.;Database=学生信息管理系统;Userid='sa';pwd='167349'";SqlConnectioncon=newSqlConnectio