scoreinfo.java

S1项目本需求规格说明描述了北大青鸟ACCP教学管理系统项目的要求

                               "delete from Score where StudentNo = ?");
                       sql.setString(1, this.jTable1.getValueAt(row, 0).toString());
                       int i = sql.executeUpdate();
                       if (i > 0) {
                           bg.removeRow(row);
                           JOptionPane.showMessageDialog(this, "删除成功");
                       } else {
                           JOptionPane.showMessageDialog(this, "删除失败");
                       }
                       this.txtStudentNo.setText("");
                       this.txtCourse.setText("");
                       this.txaRemark.setText("");
                       this.cmbExamNo.setSelectedItem("");
                       this.txtTeacher.setText("");
                       this.txtScore.setText("");
                       this.txtExamDate.setText("");
                       sql.close();
                       nod.close();
                   }
               } catch (Exception ex) {

               }

    }

    public void btnAdd_actionPerformed(ActionEvent e) {
        try {
                if(this.txtStudentNo.getText().equals("")){
                    JOptionPane.showMessageDialog(this,"请输入学号");
                    return;
                }try {
                     Integer.parseInt(this.txtStudentNo.getText());
                 } catch (Exception ex) {
                    JOptionPane.showMessageDialog(this,"对不起！没有这名学生。");
                 }/*if(this.txtCourse.getText().equals("")){
                     JOptionPane.showMessageDialog(this,"请输入课程名称");
                     return;
                 }try {
                      //Integer.parseInt(this.txtCourse.getText());
                  } catch (Exception ex) {
                      JOptionPane.showMessageDialog(this,"请正确输入课程名称");
                     return;
                  }if(this.cmbExamNo.getSelectedItem().toString().equals("")){
                      JOptionPane.showMessageDialog(this,"请输入考试次数");
                     return;
                 }try {
                     //Integer.parseInt(this.cmbExamNo.getSelectedItem().toString());
                     JOptionPane.showMessageDialog(this,"请正确输入考试次数");
                     return;
                 } catch (Exception ex) {
                 }
                 if (this.txtScore.getText().equals("")) {
                    JOptionPane.showMessageDialog(this, "请输入成绩");
                    return;
                }try {
                     //Integer.parseInt(this.txtScore.getText());
                     JOptionPane.showMessageDialog(this,"请正确输入成绩");
                     return;
                 } catch (Exception ex) {

                 }*/
                Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
                Connection conn = DriverManager.getConnection("jdbc:odbc:xiangmu");
                PreparedStatement sql = conn.prepareStatement(
                        "insert into Score (StudentNo,Course,Teacher,ExamDate,ExamNo,Score,Remark ) values(?,?,?,?,?,?,?)");
                sql.setString(1, this.txtStudentNo.getText());
                sql.setString(2, this.txtCourse.getText());
                sql.setString(3, this.txtTeacher.getText());
                sql.setString(4, this.txtExamDate.getText());
                sql.setString(5, this.cmbExamNo.getSelectedItem().toString());
                sql.setString(6, this.txtScore.getText());
                sql.setString(7, this.txaRemark.getText());
                int row = sql.executeUpdate();
                if (row > 0) {
                    JOptionPane.showMessageDialog(this, "添加成功！");
                } else {
                    JOptionPane.showMessageDialog(this, "添加失败！");
                }

                sql.close();
                conn.close();
            } catch (Exception ex) {
                JOptionPane.showMessageDialog(this, "添加失败！");
            }

    }

    public void btnshuaxin_actionPerformed(ActionEvent e) {
                        this.txtStudentNo.setText("");
                        this.txtCourse.setText("");
                        this.txaRemark.setText("");
                        this.cmbExamNo.setSelectedItem("");
                        this.txtTeacher.setText("");
                        this.txtScore.setText("");
                        this.txtExamDate.setText("");

    }

    public void btnEdit_actionPerformed(ActionEvent e) {
        try {
                        Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");//加载驱动程序
                        Connection conn = DriverManager.getConnection("jdbc:odbc:xiangmu");//注册驱动并连接数据库
                        PreparedStatement ps = conn.prepareStatement(
                        "update Score set StudentNo=?,Course=?,Teacher=?,ExamDate=?,ExamNo=?,Score=?,Remark=? where StudentNo=?");//创建执行语句的对象
                        int selRow=jTable1.getSelectedRow();
                        ps.setString(2, this.txtCourse.getText());
                        ps.setString(1, this.txtStudentNo.getText());
                        ps.setString(3, this.txtTeacher.getText());
                        ps.setString(4, this.txtExamDate.getText());
                        ps.setString(5, this.cmbExamNo.getSelectedItem().toString());
                        ps.setString(6, this.txtScore.getText());
                        ps.setString(7, this.txaRemark.getText());
                        ps.setString(8,jTable1.getValueAt(selRow,0).toString());
                        int rows = ps.executeUpdate();//执行语句,返回受影响行数
                        if (rows > 0) {
                            jTable1.setValueAt(this.txtCourse.getText(),selRow,1);
                            jTable1.setValueAt(this.txtStudentNo.getText(),selRow,0);
                            jTable1.setValueAt(this.txtTeacher.getText(),selRow,2);
                            jTable1.setValueAt(this.txtExamDate.getText(),selRow,3);
                            jTable1.setValueAt(this.cmbExamNo.getSelectedItem().toString(),selRow,4);
                            jTable1.setValueAt(this.txtScore.getText(),selRow,5);
                            jTable1.setValueAt(this.txaRemark.getText(),selRow,6);
                            JOptionPane.showMessageDialog(this, "修改成功！");
                        } else {
                            JOptionPane.showMessageDialog(this, "修改失败！");
                        }
                        ps.close();
                        conn.close();
                    } catch (Exception ex) {
                        ex.printStackTrace();
                        JOptionPane.showMessageDialog(this, "修改失败！");
             }

    }

    public void this_windowOpened(WindowEvent e) {
        denglu obj = new denglu();
        userType = obj.cmbUserType.getSelectedItem().toString();
        if (denglu.userType.equals("普通用户")) {
            this.btnEdit.setEnabled(false);
            this.btnDel.setEnabled(false);
        }
    }
}


class ScoreInfo_this_windowAdapter extends WindowAdapter {
    private ScoreInfo adaptee;
    ScoreInfo_this_windowAdapter(ScoreInfo adaptee) {
        this.adaptee = adaptee;
    }

    public void windowOpened(WindowEvent e) {
        adaptee.this_windowOpened(e);
    }
}


class ScoreInfo_btnEdit_actionAdapter implements ActionListener {
    private ScoreInfo adaptee;
    ScoreInfo_btnEdit_actionAdapter(ScoreInfo adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.btnEdit_actionPerformed(e);
    }
}


class ScoreInfo_btnshuaxin_actionAdapter implements ActionListener {
    private ScoreInfo adaptee;
    ScoreInfo_btnshuaxin_actionAdapter(ScoreInfo adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.btnshuaxin_actionPerformed(e);
    }
}


class ScoreInfo_btnAdd_actionAdapter implements ActionListener {
    private ScoreInfo adaptee;
    ScoreInfo_btnAdd_actionAdapter(ScoreInfo adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.btnAdd_actionPerformed(e);
    }
}


class ScoreInfo_btnDel_actionAdapter implements ActionListener {
    private ScoreInfo adaptee;
    ScoreInfo_btnDel_actionAdapter(ScoreInfo adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.btnDel_actionPerformed(e);
    }
}


class ScoreInfo_jTable1_mouseAdapter extends MouseAdapter {
    private ScoreInfo adaptee;
    ScoreInfo_jTable1_mouseAdapter(ScoreInfo adaptee) {
        this.adaptee = adaptee;
    }

    public void mouseClicked(MouseEvent e) {
        adaptee.jTable1_mouseClicked(e);
    }
}


class ScoreInfo_btnjiansuo_actionAdapter implements ActionListener {
    private ScoreInfo adaptee;
    ScoreInfo_btnjiansuo_actionAdapter(ScoreInfo adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.btnjiansuo_actionPerformed(e);
    }
}


class ScoreInfo_btnExit_actionAdapter implements ActionListener {
    private ScoreInfo adaptee;
    ScoreInfo_btnExit_actionAdapter(ScoreInfo adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.btnExit_actionPerformed(e);
    }
}