学生信息管理系统数据库代码(mysql的学生管理系统源代码_学生信息管理系统2(程序设计篇 源码 数据库备份)...)

1使用系统； 2 using system.collections.generic； 3 usingSystem.ComponentModel； 4 usingSystem.Data； 5 usingSystem.Drawing； 6 usingSystem.Linq； 7 usingSystem.Text； 8 usingSystem.Threading.Tasks； 9 usingSystem.Windows.Forms； 10

11 namespacesql _ homework _ end 12 (13 publicpartialclassmain : form 14 ) 15publicmain ) 16 ) 17初始化组件； 18

19 )绑定20//显示相关信息

21数据ds=new dataset (； 22 DataTable dt=newDataTable (； 23 private void学生信息toolstrip menuitem _ click (对象发送器，事件e (25ds=sqlhelper.execute dataset ) select*Frect ) ) 26 dt=ds.Tables[0]； 27 datagridview1.数据来源=dt； ) 29 ) 29

30 private void课程信息toolstrip menuitem _ click (对象发送器，事件e ) 31 (32ds=sqlhelper.execute dataset (select * f rrrref ) 34 dataGridView1.DataSource=dt； 6636

37 private void选择信息toolstrip menuitem _ click (object sender，EventArgs e ) 386539 ds=sqlhelper.execute dataset (select * f RECK ) 40 dt=ds.Tables[0]； 41 datagridview1.数据来源=dt； 42 datagridview1. columns [ ' sc _ id ' ].display index=0； 43 ) 44privatevoid管理员信息toolstrip menuitem _ click (object sender，zxdYC ) 46ds=sqlhelper.execute dataset (选择* fromtb 47 DD 48 datagridview1.数据来源=dt； 49 ) 50//按钮添加事件

51 privatevoidbtn _ insert _ click (对象发送器，事件e (53if ) datagridview1. columns [0].header text==' studdd student_password，student_sex56，student_age， sudent _ dept (values (' datagridview1. rows [ datagridview1. rowcount-2 ].cells [0].value甜蜜航空/p 57 datagridvieeees ' datagridview1. rows [ datagridview1. rowcount-2 ].cells [2].value 58 '，' ' datagridview1. rows [ datagridview1.2] ' ' datagridview1. rows [ datagridview1] ' ' datagridview1. rows [ datagridview1. rowcount-2 ].cells [5].value ' ' 60sqlhelper.executenoquery(SQL； 61

62 ) 63 else if (datagridview1. columns [0] . headertext=='course_num ' ) 64 (65 string SQL=@ ' insert TB _ course ) ) 65 course _ semester (values (' datagrigrier )

View1.RowCount - 2].Cells[1].Value + "','" + dataGridView1.Rows[dataGridView1.RowCount - 2].Cells[2].Value + "','" + dataGridView1.Rows[dataGridView1.RowCount - 2].Cells[3].Value + "')";66 sqlhelper.ExecuteNoQuery(sql);67 }68 else if (dataGridView1.Columns[0].HeaderText=="sc_id")69 {70 try

71 {72 string sql = @"insert tb_student_course (sc_id,student_num,course_num,grade)values('" + dataGridView1.Rows[dataGridView1.RowCount - 2].Cells[0].Value + "','" + dataGridView1.Rows[dataGridView1.RowCount - 2].Cells[1].Value + "','" + dataGridView1.Rows[dataGridView1.RowCount - 2].Cells[2].Value + "','" + dataGridView1.Rows[dataGridView1.RowCount - 2].Cells[3].Value + "')";73 sqlhelper.ExecuteNoQuery(sql);74 }75 catch(Exception)76 {77 MessageBox.Show("学号或姓名不存在，请重新添加。");78 }79

80 }81 else if (dataGridView1.Columns[0].HeaderText == "admin_id")82 {83 string sql = @"insert tb_admin (admin_id,admin_name,admin_password,remark)values('" + dataGridView1.Rows[dataGridView1.RowCount - 2].Cells[0].Value + "','" + dataGridView1.Rows[dataGridView1.RowCount - 2].Cells[1].Value + "','" + dataGridView1.Rows[dataGridView1.RowCount - 2].Cells[2].Value + "','" + dataGridView1.Rows[dataGridView1.RowCount - 2].Cells[3].Value + "')";84 sqlhelper.ExecuteNoQuery(sql);85 }86 MessageBox.Show("添加成功");87 }88 //更新按钮事件

89 private void btn_update_Click(objectsender, EventArgs e)90 {91 if (dataGridView1.Columns[0].HeaderText == "student_num")92 {93 update("tb_student","student_num");94 }95 else if (dataGridView1.Columns[0].HeaderText == "course_num")96 {97 update("tb_course","course_num");98 }99 else if (dataGridView1.Columns[0].HeaderText == "admin_id")100 {101 update("tb_admin","admin_id");102 }103 else if (dataGridView1.Columns[0].HeaderText == "sc_id")104 {105 try

106 {107 update("tb_studnet_course","sc_id");108 }109 catch(Exception)110 {111 MessageBox.Show("学号或课程号不存在，请重新输入");112 throw;113 }114 }115 }116 //更新方法

117 private void update(string table,stringhead_id)118 {119 for (int i = 0; i < dataGridView1.RowCount; i++)120 {121 int id = Convert.ToInt32(dataGridView1.Rows[i].Cells[0].Value);122 for (int j = 1; j < dataGridView1.ColumnCount; j++)123 {124 if (dataGridView1.Columns[j].Visible == true)125 {126 string columnName =dataGridView1.Columns[j].Name.ToString();127 string sql = "update" + table + "set" + columnName + "='" + dataGridView1.Rows[i].Cells[j].Value + "' where" + head_id + "='" + id + "'";128 sqlhelper.ExecuteNoQuery(sql);129 }130 }131 }132 MessageBox.Show("更新成功");133 }134

135 //删除事件

136 private void btn_delete_Click(objectsender, EventArgs e)137 {138 if (dataGridView1.Columns[0].HeaderText == "student_num")139 {140 string sql = "delete from tb_student where student_num='" + dataGridView1.SelectedCells[0].Value + "'";141 sqlhelper.ExecuteNoQuery(sql);142 }143 else if (dataGridView1.Columns[0].HeaderText == "course_num")144 {145 string sql = "delete from tb_course where course_num='" + dataGridView1.SelectedCells[0].Value + "'";146 sqlhelper.ExecuteNoQuery(sql);147 }148 else if (dataGridView1.Columns[0].HeaderText == "sc_id")149 {150 string sql = "delete from tb_student_course where sc_id='" + dataGridView1.SelectedCells[0].Value + "'";151 sqlhelper.ExecuteNoQuery(sql);152 }153 else if (dataGridView1.Columns[0].HeaderText == "admin_id")154 {155 string sql = "delete from tb_admin where admin_id='" + dataGridView1.SelectedCells[0].Value + "'";156 sqlhelper.ExecuteNoQuery(sql);157 }158 MessageBox.Show("删除成功");159 }160

161 //界面载入显示身份和登录时间

162 private void main_Load(objectsender, EventArgs e)163 {164 lbl_username.Text = "Welcome," + login.mhdbbz "";165 lbl_logintime.Text ="登录时间:" +DateTime.Now.ToString()+"";166 }167 }168 }