conn.close(); stmt.close(); } catch(Exception E) {
}
}
if(e.getSource()==deleteInfo) {
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); }
conn.close(); stmt.close();
}
}
catch(Exception E) { }
【课程信息管理】部分关键代码及注释： public void actionPerformed(ActionEvent e) { if(e.getSource()==addInfo) {
String kch=cNum.getText(); String kcm=cName.getText(); String rkjs= cTeacher.getText(); try
{
Class.forName(\
String url= \Access Driver (*.mdb)};DBQ=student.mdb\
Connection conn=DriverManager.getConnection(url); Statement stmt=conn.createStatement(); String sqlstr=\into values('\
int result=stmt.executeUpdate(sqlstr); if(result>0) {
JOptionPane.showMessageDialog(this,\数据添加成功\课程信息管理
kc(kch,kcm,rkjs)
系统\ this.setVisible(false); }
conn.close(); stmt.close(); }
catch(Exception E) { }
}
if(e.getSource()==modifyInfo) {
String kch=cNum.getText(); String kcm=cName.getText();
String rkjs=cTeacher.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); }
conn.close(); stmt.close();
}
catch(Exception E) {
} }
if(e.getSource()==deleteInfo) {
int n=JOptionPane.showConfirmDialog(this,\你确定要删除学号和所有的信息
吗？\课程信息管理系统\ if(n==JOptionPane.YES_OPTION) { String kch=cNum.getText();
String kcm=cName.getText();
String rkjs=cTeacher.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); }
conn.close(); stmt.close();
}
}
}
catch(Exception E) { } }
else {
JOptionPane.showMessageDialog(this,\数据删除失败\课程信息管理系统}
\
【成绩信息管理】部分关键代码及注释： public void focusGained(FocusEvent e)
{ if(e.getSource()==gName) try
{
Class.forName(\
String url= \Access Driver (*.mdb)};DBQ= student.mdb\ Connection conn=DriverManager.getConnection(url); Statement stmt=conn.createStatement();
String sqlstr=\ResultSet result=stmt.executeQuery(sqlstr);
while(result.next()) {
gName.setText(result.getString(\ gName.setEnabled(false); gNum.setEditable(false); } conn.close();
stmt.close(); }
catch(Exception E) { }
else if(e.getSource()==gGrade)
String kcm=(String)gCourse.getSelectedItem(); try
{
{
Driver
Class.forName(\ String url= \Access (*.mdb)};DBQ=student.mdb\ Connection conn=DriverManager.getConnection(url);
Statement stmt=conn.createStatement();
String sqlstr=\* from cj where xh='\and
kcm='\ ResultSet result=stmt.executeQuery(sqlstr);
while(result.next())
{
gGrade.setText(result.getString(\ }
conn.close(); stmt.close(); }
catch(Exception w){} } } {
}
public void actionPerformed(ActionEvent e) {
if(e.getSource()==addInfo) {
if(gNum.getText().equals(\ {JOptionPane.showMessageDialog(this,\姓名和学号、成绩不能为空\提示
public void focusLost(FocusEvent e)
\TION_MESSAGE);}
else {
String xh=gNum.getText(); String xm=gName.getText();
String cj=gGrade.getText();
String kcm=(String)gCourse.getSelectedItem(); try
{ Class.forName(\
String url= \Access Driver (*.mdb)};DBQ= Connection conn=DriverManager.getConnection(url); Statement stmt=conn.createStatement();
String sqlstr=\
student.mdb\