{
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
相关推荐：
loading