学生数据库管理系统源程序

附录：源程序 32 Program.csusing System;using System.Collections.Generic;using System.Linq;using System.Windows.Forms;namespace studentMIS static class Program / / 应用程序的主入口点。 / STAThread static void Main() Application.EnableVisualStyles(); Application.SetCompatibleTextRenderingDefault(false);Application.Run(new Formlogin(); Formlogin.csusing System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Linq;using System.Text;using System.Windows.Forms;using DAL;namespace studentMIS public partial class Formlogin : Form public Formlogin() InitializeComponent(); private void buttonok_Click(object sender, EventArgs e) int total = new SQLHelper().login(textBoxusername.Text.Trim(), textBoxpassword.Text.Trim(); if (total 0) formmain main =new formmain (); main .Show (); this.Hide (); main.bind(); else MessageBox.Show (用户名或密码错误,提示); textBoxusername.Text =; textBoxpassword.Text =; textBoxusername.Focus(); private void buttoncancel_Click(object sender, EventArgs e) textBoxusername.Text = ; textBoxpassword.Text = ; textBoxusername.Focus(); Formmain.csusing System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Linq;using System.Text;using System.Windows.Forms;using DAL;namespace studentMIS public partial class formmain : Form public formmain() InitializeComponent(); private void 信息录入ToolStripMenuItem_Click(object sender, EventArgs e) FormAddStudent add = new FormAddStudent(); add.ShowDialog();if (add.DialogResult = DialogResult.OK) bind(); BindingSource bs = new BindingSource(); public void bind()/刷新网络 bs.DataSource = new SQLHelper().CreateTable(); dataGridView.DataSource = bs; public void Formmain_Load(object sender, EventArgs e) bind(); private void 信息删除ToolStripMenuItem_Click(object sender, EventArgs e) FormDeleteStudent delete = new FormDeleteStudent(); delete.ShowDialog(); if (delete.DialogResult = DialogResult.OK) bind(); private void 信息查找ToolStripMenuItem_Click(object sender, EventArgs e) FormSearchStudent select = new FormSearchStudent(); select.ShowDialog(); private void 信息修改ToolStripMenuItem_Click(object sender, EventArgs e) FormModifystudent modify = new FormModifystudent(); modify.ShowDialog(); if (modify.DialogResult = DialogResult.OK) bind(); private void 注销ToolStripMenuItem_Click(object sender, EventArgs e) Formlogin login = new Formlogin(); DialogResult dr = MessageBox.Show(确定注销吗？, 提示, MessageBoxButtons.OKCancel) if (dr = DialogResult.OK) login.Show(); this.Hide(); else return; private void 退出ToolStripMenuItem_Click(object sender, EventArgs e) DialogResult dr = MessageBox.Show(确定退出系统吗？, 提示, MessageBoxButtons.OKCancel); if (dr = DialogResult.OK) this.Dispose(); else return; FormAddStudent.csusing System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Linq;using System.Text;using System.Windows.Forms;using DAL;namespace studentMIS public partial class FormAddStudent : Form public FormAddStudent() InitializeComponent(); private void textBox3_TextChanged(object sender, EventArgs e) private voidbuttonok_Click(object sender, EventArgs e) string sno = textBoxsno.Text.Trim(); string sname = textBoxsname.Text.Trim(); string sex = comboBoxsex.Text.Trim(); string birthday = textBoxbirthday.Text.Trim(); new StudentDAO().insert(sno, sname, sex, birthday); this.DialogResult = DialogResult.OK; MessageBox.Show(输入成功,提示); FormDeleteStudent.csusing System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Linq;using System.Text;using System.Windows.Forms;using DAL;namespace studentMIS public partial class FormDeleteStudent : Form public FormDeleteStudent() InitializeComponent(); private void buttonok_Click(object sender, EventArgs e) if (textBoxsno.Text != ) int total = new SQLHelper().delectstudentbysno(textBoxsno.Text.Trim(); if (total 0) new StudentDAO().deletebysno(textBoxsno.Text.Trim(); MessageBox.Show(删除成功！, 提示); this.DialogResult = DialogResult.OK; else MessageBox.Show(输入不正确，请重新输入！, 提示);textBoxsno.Focus();textBoxsno.Text = ; return; else int total = new SQLHelper().delectstudentbysname(textBoxsname.Text.Trim(); if (total 0) new StudentDAO().deletebysname(textBoxsname.Text.Trim(); MessageBox.Show(删除成功！, 提示); this.DialogResult = DialogResult.OK; else MessageBox.Show(输入不正确，请重新输入！, 提示); textBoxsname.Focus(); textBoxsname.Text = ; return; private void buttoncancel_Click(object sender, EventArgs e) textBoxsno.Text = ; textBoxsname.Text = ; textBoxsno.Focus(); private void radioButton2_CheckedChanged(object sender, EventArgs e) textBoxsno.Focus(); FormSearchStudent.csusing System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Linq;using System.Text;using System.Windows.Forms;using DAL;namespace studentMIS public partial class FormSearchStudent : Form public FormSearchStudent() InitializeComponent(); private void textBox1_TextChanged(object sender, EventArgs e) BindingSource bs = new BindingSource(); private void buttonsearchbysno_Click(object sender, EventArgs e) bs.DataSource = new StudentDAO().searchbysno(textBoxsno.Text.Trim(); /表格 if (bs != null) textBoxsno.Text = null; textBoxsno.Focus(); dataGridViewSearch.DataSource = bs; else MessageBox.Show(查询失败，数据库中没有该学生!, 提示); return; private void buttonsearchbysname_Click(object sender, EventArgs e) bs.DataSource = new StudentDAO().searchbysname(textBoxsname.Text.Trim(); if (bs != null) textBoxsname.Text = null; textBoxsname.Focus(); dataGridViewSearch.DataSource = bs; else MessageBox.Show(查询失败，数据库中没有该学生!, 提示); return; private void radioButtonsno_CheckedChanged(object sender, EventArgs e) textBoxsno.Focus(); private void radioButtonsname_CheckedChanged(object sender, EventArgs e) textBoxsname.Focus(); FormModifystudent.csusing System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Linq;using System.Text;using System.Windows.Forms;using DAL;namespace studentMIS public partial class FormModifystudent : Form public FormModifystudent() InitializeComponent(); private void buttonok_Click(object sender, EventArgs e) string msno = textBoxmsno.Text.Trim(); string sname = textBoxsname.Text.Trim(); string sex = comboBoxsex.Text.Trim(); string birthday = textBoxbirthday.Text.Trim(); new StudentDAO().modify(msno, sname, sex, birthday); this.DialogResult = DialogResult.OK; MessageBox.Show(修改成功!,提示); private void buttoncancel_Click(object sender, EventArgs e) textBoxmsno.Text=; textBoxsname.Text=; comboBoxsex.Text=男; textBoxbirthday.Text =; textBoxmsno.Focus(); BindingSource bs = new BindingSource(); private void button1_Click(object sender, EventArgs e) bs.DataSource = new StudentDAO().searchbysno(textBoxmsno.Text.Trim(); /表格 if (bs != null) dataGridViewSearch.DataSource = bs; else MessageBox.Show(查询失败，数据库中没有该学生!, 提示); return; private void buttoncancel1_Click(object sender, EventArgs e) textBoxmsno.Text = ; textBoxmsno.Focus(); StudentDAO.csusing System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Data.SqlClient;using System.Data;namespace DAL public class StudentDAO private SQLHelper sqlhelper = null; public StudentDAO() sqlhelper = new SQLHelper(); /增 public void insert(string sno, string sname, string sex, string birthday) string sql = insert into student values(sno,sname,sex,birthday); SqlParameter para = new SqlParameter new SqlParameter(sno,SqlDbType.NChar), new SqlParameter(sname,SqlDbType.NVarChar), new SqlParameter(sex,SqlDbType.NChar), new SqlParameter(birthday,SqlDbType.NChar) ; int i = 0; parai+.Value = sno; parai+.Value = sname; parai+.Value = sex; parai+.Value = birthday; sqlhelper.ExecuteNonQuery(sql, para); /删除 public void deletebysno(string sno) string sql = delete from student where sno=sno; SqlParameter para = new SqlParameter new SqlParameter(sno,SqlDbType.NChar) ; int i = 0; parai+.Value = sno; sqlhelper.ExecuteNonQuery(sql, para); public void deletebysname(string sname) string sql = delete from student where sname=sname; SqlParameter para = new SqlParameter new SqlParameter(sname,SqlDbType.NVarChar) ; int i = 0; parai+.Value = sname; sqlhelper.ExecuteNonQuery(sql, para); /查找 public DataTable searchbysno(string sno) DataTable table = new DataTable(); string sql = select * from student where sno=sno; SqlParameter para = new SqlParameter new SqlParameter(sno,SqlDbType.NChar) ; int i = 0; parai+.Value = sno; table = sqlhelper.CreateTablesearch(sql, para); return table; public DataTable searchbysname(string sname) DataTable table = new DataTable(); string sql = select * from student where sname=sname; SqlParameter para = new SqlParameter new SqlParameter(sname ,SqlDbType.NChar) ; int i = 0; parai+.Value = sname; table = sqlhelper.CreateTablesearch(sql, para); return table; /修改 public DataTable modify(string msno, string sname, string sex, string birthday) DataTable table = new DataTable(); string sql = update student set sname=sname,ssex=sex,birthday=birthday where sno=msno; SqlParameter para = new SqlParameter new SqlParameter (msno,SqlDbType.NChar), new SqlParameter(sname,SqlDbType.NVarChar), new SqlParameter(sex,SqlDbType.NChar), new SqlParameter(birthday,SqlDbType.NChar) ; int i = 0; parai+.Value = msno; parai+.Value = sname; parai+.Value = sex; parai+.Value = birthday; table = sqlhelper.CreateTablemodify(sql, para); return table; SQLHelper.csusing System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Data.SqlClient;using System.Data;namespace DAL public class SQLHelper public void ExecuteNonQuery(string sql, params SqlParameter para) string connstr = server=97SD-UG;database=student;integrated security=sspi; using (SqlConnection conn = new SqlConnection(connstr) conn.Open(); using (SqlCommand cmd = new SqlCommand(sql, conn) cmd.Parameters.AddRange(para); cmd.ExecuteNonQuery(); /判断学号是否与后台数据库取出来的是否一致 public int delectstudentbysno(string tsno) string connstr = server=97SD-UG;database=student;integrated security=sspi; using (SqlConnection conn = new SqlConnection(connstr) conn.Open(); using (SqlCommand cmd = conn.CreateCommand() cmd.CommandText = select count(*) from student where sno=sno; cmd.Parameters.Add(new SqlParameter(sno, tsno); int total = Convert.ToInt32(cmd.ExecuteScalar();/返回查询值的首行首列,返回值类型 /不确定，是object 类型， return total; /判断姓名是否与后台数据库取出来的是否一致 public int delectstudentbysname(string tsname) string connstr = server=97SD-UG;database=student;integrated security=sspi; using (SqlConnection conn = new SqlConnection(connstr) conn.Open(); using (SqlCommand cmd = conn.CreateCommand() cmd.CommandText = select count(*) from student where sname=sname ; cmd.Parameters.Add(new SqlParameter(sname, tsname); int total = Convert.ToInt32(cmd.ExecuteScalar();/返回查询值的首行首列,返回值类型 /不确定，是object 类型， return total; public DataTable CreateTable() DataTable table = new DataTable(); string connstr = server=97SD-UG;database=student;integrated security=sspi; using (SqlConnection conn = new SqlConnection(connstr) conn.Open(); string sql = select * from student; using (SqlDataAdapter adapter = new SqlDataAdapter(sql, conn) adapter.Fill(table); return table; public DataTable CreateTablesearch(string sql, params SqlParameter para) DataTable table = new DataTable(); string c