学生管理系统实习报告模板

{

this.Visible = false;

mainface main = new mainface(this); main.Show(); } }

catch(Exception ex) {

MessageBox.Show(ex.ToString(),\提示\ }

} else {

MessageBox.Show(\请输入用户名和密码\提示\ } }

5.3 查询模块代码设计

private void btQuery_Click(object sender, EventArgs e) {

mySql query=new mySql();

if (sNInput.Text.Trim() == \\学号,SN AS 姓名,MN AS 专业名称,SEX AS 性别,BIRDAY AS 出生日期,TS AS 总学分,COM AS 备注 FROM S WHERE SNO=\

if (sNInput.Text.Trim() != \= \学号,SN AS 姓名,MN AS 专业名称,SEX AS 性别,BIRDAY AS 出生日期,TS AS 总学分,COM AS 备注 FROM S WHERE SN='\

if (sNInput.Text.Trim() != \= \学号,SN AS 姓名,MN AS 专业名称,SEX AS 性别,BIRDAY AS 出生日期,TS AS 总学分,COM AS 备注 FROM S WHERE SN='\+ sNInput.Text.Trim() + \and SNO=\

if (sNInput.Text.Trim() == \&& sNoinput.Text.Trim() == \MessageBox.Show(\您输入的信息为空，请重新输入！\错误信息\ else {

if (query.getFlag()) {

query.runSql();

dataGridView1.DataSource = query.table; }

15

else MessageBox.Show(\您查找的信息不存在\错误信息\ } }

5.4 添加模块代码设计

private void addbtOK_Click(object sender, EventArgs e) {

if (addStuNo.Text.Trim() != \&& addStuName.Text.Trim() != \addStuMajor.Text.Trim()!=\ {

mySql sql = new mySql();

sql.commondText = \CNO FROM C WHERE CN='\+ listmn.Text.ToString().Trim()+ \ sql.runSql();

String temp = sql.table.Table.Rows[0][\ String sexTemp=radioButton1.Checked ? \男\女\ String comTemp;

if (addStuCom.Text.ToString().Trim() == \ comTemp = \

else comTemp = addStuCom.Text.ToString().Trim(); String birTemp=\

if (addStuBir.Text.ToString().Trim() == \ comTemp = \

else birTemp = addStuCom.Text.ToString().Trim();

sql.commondText = \INTO S (SNO,SN,MN,SEX,BIRDAY,COM) VALUES(\

+addStuNo.Text.ToString().Trim()+\ +addStuName.Text.ToString().Trim()+\ +addStuMajor.Text.ToString().Trim()+\ +sexTemp+\ +birTemp+\ +comTemp+\ sql.update();

if(score.Text.ToString().Trim()!=\

sql.commondText = \INTO SC(SNO,CNO,SCORE) VALUES (\

+\ sql.update(); }

this.Close(); } else

16

{

MessageBox.Show(\学号、姓名和专业名称都不可以为空！！！\错误！\ } }

private void AddNew_Load(object sender, EventArgs e) {//获取专业列表

mySql sql = new mySql();

sql.commondText = \ SqlDataAdapter sda = new SqlDataAdapter(sql.commondText, sql.connectionString);

DataSet ds = new DataSet(); sda.Fill(ds);

listmn.DataSource = ds.Tables[0].DefaultView; listmn.DisplayMember = \

listmn.DisplayMember = listmn.DisplayMember.ToString().Trim(); }

5.5 更新模块代码设计

private void upbtOK_Click(object sender, EventArgs e) {

mySql sql = new mySql();

sql.commondText = \学号 FROM detail WHERE 学号=\

bool flagtemp = sql.getFlag();

if (!flagtemp) //如果表中无该条记录，提示是否进行添加新记录操作 {

if (MessageBox.Show(\查无当前记录，无法进行更新操作！\\n是否进行添加新记录的操作？\提示\ {

if (upStuNo.Text.Trim() != \&& upStuName.Text.Trim() != \&& upStuMajor.Text.Trim() != \ {

mySql sqlme = new mySql();

sqlme.commondText = \listmn.Text.ToString().Trim() + \

sqlme.runSql();

String temp = sqlme.table.Table.Rows[0][\课程号

String sexTemp = radioButton1.Checked ? \男\女\ String comTemp;

17

if (upStuCom.Text.ToString().Trim() == \ comTemp = \

else comTemp = upStuCom.Text.ToString().Trim(); String birTemp;

if (upStuBir.Text.ToString().Trim() == \ birTemp = \

else birTemp = upStuCom.Text.ToString().Trim(); sqlme.commondText = \INTO S (SNO,SN,MN,SEX,BIRDAY,COM) VALUES(\

+ upStuNo.Text.ToString().Trim() + \ + upStuName.Text.ToString().Trim() + \ + upStuMajor.Text.ToString().Trim() + \ + sexTemp + \ + birTemp + \ + comTemp + \ sqlme.update();

if (upStuScore.Text.ToString().Trim() != \ {

sqlme.commondText = \INTO SC(SNO,CNO,SCORE) VALUES (\ + \+ temp + \+ upStuScore.Text.ToString().Trim() + \

sqlme.update(); }

this.Close(); } else {

MessageBox.Show(\学号、姓名和专业名称都不可以为空！！！\错误！\

} } } else {

if (upStuNo.Text.Trim() != \&& upStuName.Text.Trim() != \&& upStuMajor.Text.Trim() != \ {

sql.commondText = \CNO FROM C WHERE CN='\+ listmn.Text.ToString().Trim() + \ sql.runSql();

String temp = sql.table.Table.Rows[0][\获取课程号 String sexTemp = radioButton1.Checked ? \男\女\ String comTemp;

18