学生成绩管理系统课程设计源程序文档格式.docx
《学生成绩管理系统课程设计源程序文档格式.docx》由会员分享,可在线阅读,更多相关《学生成绩管理系统课程设计源程序文档格式.docx(47页珍藏版)》请在冰点文库上搜索。
}
添加课程信息AddCourse.cs
usingMySql.Data.MySqlClient;
publicpartialclassAddCourse:
publicAddCourse()
privatevoidbtnExit_Click(objectsender,EventArgse)
privatevoidbtnAddCourse_Click(objectsender,EventArgse)
stringmyConnectionString="
Database=student;
DataSource=localhost;
UserId=root;
Password=k6smile20xq"
;
MySqlConnectionmycn=newMySqlConnection(myConnectionString);
mycn.Open();
stringsql;
Coursecourse=newCourse();
course.Cno=txtCno.Text;
course.Cname=txtCname.Text;
try
sql="
selectcount(*)fromcoursewherecno='
"
+txtCno.Text+"
'
MySqlCommandmycm=newMySqlCommand(sql,mycn);
MySqlDataReadermsdr=mycm.ExecuteReader();
msdr.Read();
intstuCount=msdr.GetInt32("
count(*)"
);
msdr.Close();
if(stuCount==0&
&
txtCname.Text!
="
&
txtCno.Text!
)
{
insertintocourse(cno,cname)values('
+course.Cno+"
'
+course.Cname+"
)"
MySqlCommandmycm1=newMySqlCommand(sql,mycn);
mycm1.ExecuteNonQuery();
catch(Exceptionexception)
MessageBox.Show(exception.Message);
return;
finally
mycn.Close();
MessageBox.Show("
添加成功!
elseif(stuCount>
=1&
//这里需要关闭资源
该课程的信息已存在,请重新输入!
else
请输入要添加的信息"
catch(Exceptiona)
Console.WriteLine(a.ToString());
finally
txtCno.Text="
txtCname.Text="
privatevoidAddCourse_Load(objectsender,EventArgse)
添加学生信息AddStudent.cs
usingSystem.IO;
publicpartialclassAddStudent:
publicAddStudent()
privatevoidAddStudent_Load(objectsender,EventArgse)
privatevoidbtnCancel_Click(objectsender,EventArgse)
privatevoidbtnAddStudent_Click(objectsender,EventArgse)
//intstuNum=Selectcount(id)from
Studentstu=newStudent();
stu.Sno=txtSno.Text;
stu.Sname=txtName.Text;
stu.Age=txtAge.Text;
stu.ClassName=txtClassName.Text;
stu.Password=txtPassword.Text;
stu.Id=txtId.Text;
if(rbStuGirl.Checked)stu.Sex="
女?
elseif(rbStuBoy.Checked)stu.Sex="
男D"
//if(rbStuGirl.Checked)stu.Sex="
girl"
//elseif(rbStuBoy.Checked)stu.Sex="
boy"
selectcount(*)fromstudentwheresno='
+txtSno.Text+"
MySqlDataReadermsdr=mycm.ExecuteReader();
txtSno.Text!
txtName.Text!
txtAge.Text!
txtClassName.Text!
txtPassword.Text!
txtId.Text!
insertintostudent(sno,sname,sex,age,classname,password,id)values('
+stu.Sno+"
+stu.Sname+"
+stu.Sex+"
+stu.Age+"
+stu.ClassName+"
+stu.Password+"
+stu.Id+"
Console.WriteLine(sql);
try
mycm1.ExecuteNonQuery();
}catch(Exceptionexception)
return;
MessageBox.Show("
添?
¨
?
加¨
成¨
功|!
ê
该学生的信息已存在"
}finally
txtSno.Text="
txtName.Text="
txtAge.Text="
txtClassName.Text="
txtPassword.Text="
txtId.Text="
}
主窗口程序AdminWindou.cs
publicpartialclassAdminWindow:
publicAdminWindow()
privatevoidAdminWindow_Load(objectsender,EventArgse)
privatevoid查询学生信息ToolStripMenuItem2_Click(objectsender,EventArgse)
newSearchStudent().ShowDialog();
privatevoid添加学生信息ToolStripMenuItem3_Click(objectsender,EventArgse)
newAddStudent().ShowDialog();
privatevoid修改学生信息ToolStripMenuItem3_Click(objectsender,EventArgse)
newUpdateStudent().ShowDialog();
privatevoid删除学生信息ToolStripMenuItem3_Click(objectsender,EventArgse)
newDeleteStudent().ShowDialog();
privatevoid查询课程信息ToolStripMenuItem2_Click(objectsender,EventArgse)
newSearchCourse().ShowDialog();
privatevoid添加课程信息ToolStripMenuItem3_Click(objectsender,EventArgse)
newAddCourse().ShowDialog();
newUpdateCourse().ShowDialog();
privatevoid删除课程信息ToolStripMenuItem3_Click(objectsender,EventArgse)
newDeleteCourse().ShowDialog();
privatevoid关于ToolStripMenuItem2_Click(objectsender,EventArgse)
newAbout().ShowDialog();
privatevoid退出系统ToolStripMenuItem2_Click(objectsender,EventArgse)
Application.Exit();
}
privatevoid排名ToolStripMenuItem1_Click(objectsender,EventArgse)
newCourseRank().ShowDialog();
privatevoid查询学生成绩ToolStripMenuItem2_Click(objectsender,EventArgse)
newScoreSearch().ShowDialog();
privatevoid各班平均分ToolStripMenuItem2_Click(objectsender,EventArgse)
newClassAvg().ShowDialog();
privatevoid各科平均分ToolStripMenuItem2_Click(objectsender,EventArgse)
newCourseAvg().ShowDialog();
班级平均成绩查询ClassAvg.cs
publicpartialclassClassAvg:
publicClassAvg()
privatevoidClassAvg_Load(objectsender,EventArgse)
privatevoidbtnsearch_Click(objectsender,EventArgse)
stringbjmc=txtbjmc.Text;
using(MySqlConnectionconn=newMySqlConnection(@"
))
conn.Open();
using(MySqlCommandcmd=conn.CreateCommand())
cmd.CommandText=@"
selectavg(score)fromscoreinfi
whereclassname=@bjmc"
cmd.Parameters.Add(newMySqlParameter("
bjmc"
bjmc));
stringbjavg=Convert.ToString(cmd.ExecuteScalar());
txtbjavg.Text=bjavg;
privatevoidbtncancle_Click(objectsender,EventArgse)
单科平均成绩CourseAvg.cs
publicpartialclassCourseAvg:
publicCourseAvg()
privatevoidbtnquery_Click(objectsender,EventArgse)
stringcourseid=txtcourseid.Text;
stringcoursename=txtcoursename.Text;
using(MySqlCommandcmd=conn.CreateCommand())
cmd.CommandText=@"
selectavg(score)asavgfromscoreinfi
wherecname=@coursename"
coursename"
coursename));
/*DataSetdataset=newDataSet();
MySqlDataAdapteradapter=newMySqlDataAdapter(cmd);
adapter.Fill(dataset);
DataTabletable=dataset.Tables[0];
for(inti=0;
i<
table.Rows.Count;
i++)
DataRowrow=table.Rows[i];
txtavg.Text=Convert.ToString(row["
avg"
]);
}*/
txtavg.Text=Convert.ToString(cmd.ExecuteScalar());
privatevoidCourseAvg_Load(objectsender,EventArgse)
privatevoidbtnexit_Click(objectsender,EventArgse)
单科成绩排名CourseRank.cs
publicpartialclassCourseRank:
publicCourseRank()
privatevoidForm1_Load(objectsender,EventArgse)
//this