}
catch(Exception E) { }
}
else if(e.getSource()==itemDeleteS) {
String xh=JOptionPane.showInputDialog(this,\请输入要删除的学号\学if(xh.length()==0)
生成绩管理系统\
{
JOptionPane.showMessageDialog(this,\学号不能为空,请重新输入\学生信息管理系统\
} else
{ StuInfo newst=new StuInfo(); newst.addInfo.setEnabled(false);
newst.clearInfo.setEnabled(false); newst.modifyInfo.setEnabled(false);
try { Class.forName(\
String url= \Access Driver
(*.mdb)};DBQ=student.mdb\ Connection conn=DriverManager.getConnection(url);
Statement stmt=conn.createStatement();
String sqlstr=\ ResultSet rs=stmt.executeQuery(sqlstr); while(rs.next()) {
if(rs.getString(\男\判断获取性别字段时输出的 \男\或\女\
newst.xb1.setSelected(true); else
newst.xb2.setSelected(true);
newst.sNum.setText(rs.getString(\ newst.sName.setText(rs.getString(\ }
newst.sBirth.setText(rs.getString(\newst.sMajor.setText(rs.getString(\
newst.sHome.setText(rs.getString(\
}
catch(Exception E) { }
} }
else if(e.getSource()==itemAddC) { }
courseInfo newst=new courseInfo(); newst.modifyInfo.setEnabled(false); newst.deleteInfo.setEnabled(false); newst.clearInfo.setEnabled(false);
else if(e.getSource()==itemEditC) {
String kch=JOptionPane.showInputDialog(this,\请输入要修改的课程的课程号\课程信息管理系统\ if(kch.length()==0)
{
JOptionPane.showMessageDialog(this,\课程号不能为空，请重新输入
\课程信息管理系统\ } else {
courseInfo newst=new courseInfo(); newst.addInfo.setEnabled(false);
newst.deleteInfo.setEnabled(false); newst.clearInfo.setEnabled(false); newst.cNum.setText(kch); newst.cNum.setEnabled(false); try {
Class.forName(\
String url= \Access Driver (*.mdb)};DBQ=student.mdb\
Connection conn=DriverManager.getConnection(url); Statement stmt=conn.createStatement();
String sqlstr=\ ResultSet rs=stmt.executeQuery(sqlstr); while(rs.next())
{
newst.cName.setText(rs.getString(\ newst.cTeacher.setText(rs.getString(\
}
} catch(Exception E) { } }
else if(e.getSource()==itemDeleteC) {
String kch=JOptionPane.showInputDialog(this,\请输入要删除课程的课程 }
号\学生成绩管理系统\ if(kch.length()==0)
{
JOptionPane.showMessageDialog(this,\课程号不能为空，请重新输入\
课程信息管理系统\ } else
{
courseInfo newst=new courseInfo();
newst.addInfo.setEnabled(false); newst.clearInfo.setEnabled(false); newst.modifyInfo.setEnabled(false); newst.cNum.setText(kch); newst.cNum.setEnabled(false); try
{ Class.forName(\
String url= \Access Driver
(*.mdb)};DBQ=student.mdb\ Connection conn=DriverManager.getConnection(url);
Statement stmt=conn.createStatement();
String sqlstr=\ ResultSet rs=stmt.executeQuery(sqlstr); while(rs.next()) {
newst.cNum.setText(rs.getString(\ newst.cName.setText(rs.getString(\ }
newst.cTeacher.setText(rs.getString(\
}
catch(Exception E) {
}
}
}
else if(e.getSource()==itemAddG) { }
else if(e.getSource()==itemEditG) {
gradeInfo newst=new gradeInfo(); newst.addInfo.setEnabled(false); gradeInfo newst=new gradeInfo(); newst.clearInfo.setEnabled(false); newst.modifyInfo.setEnabled(false);
}
else if(e.getSource()==itemSearchMutGrd) {
cjcx newst=new cjcx();
}
}
【学生信息管理】部分关键代码：
public void actionPerformed(ActionEvent e) { if(e.getSource()==addInfo)
{
String xb;
String xh=sNum.getText(); String xm= sName.getText(); if(xb1.isSelected()) xb=\男\ else
xb=\女\
String csrq=sBirth.getText();
String zy=sMajor.getText(); String jg=sHome.getText();
try
{
Class.forName(\
String url= \Access Driver (*.mdb)};DBQ=student.mdb\
Connection conn=DriverManager.getConnection(url); Statement stmt=conn.createStatement(); String sqlstr=\into xs(xh,xm,xb,csrq,zy,jg)
values('\
int result=stmt.executeUpdate(sqlstr); if(result>0) { JOptionPane.showMessageDialog(this,\数据添加成功\学生成绩管理系统\ this.setVisible(false); }
conn.close(); stmt.close();
}
}
catch(Exception E) { }
if(e.getSource()==modifyInfo) { String xb;
String xh=sNum.getText(); String xm= sName.getText(); if(xb1.isSelected()) xb=\男\ else xb=\女\
String csrq=sBirth.getText(); String zy=sMajor.getText();
String jg=sHome.getText(); try {
Class.forName(\
String url= \Access Driver (*.mdb)};DBQ=student.mdb\
Connection conn=DriverManager.getConnection(url); Statement stmt=conn.createStatement(); String sqlstr=\ int result=stmt.executeUpdate(sqlstr); if(result>0)
{
JOptionPane.showMessageDialog(this,\数据修改成功\学生成绩管理系统\ this.setVisible(false); }
xs
set
xm='\