basicinfocheck.java~89~

Tt s a good book ,if you want to learn java good

    JTextField jTextField_Age = new JTextField();
    JLabel jLabel_Nation = new JLabel();
    JTextField jTextField_Nation = new JTextField();
    JLabel jLabel_PhotoStatus = new JLabel();
    JLabel jLabel_Other = new JLabel();
    JTextField jTextField_Other = new JTextField();
    JLabel jLabel_Major = new JLabel();
    JTextField jTextField_College = new JTextField();
    JLabel jLabel_Status = new JLabel();
    JLabel jLabel_Class = new JLabel();
    JLabel jLabel_Grade = new JLabel();
    JTextField jTextField_Grade = new JTextField();
    JLabel jLabel_College = new JLabel();
    JTextField jTextField_Major = new JTextField();
    JButton jButton_Check = new JButton();
    JButton jButton_Reset = new JButton();
    JButton jButton_Cancel = new JButton();
    JTextField jTextField_Status = new JTextField();
    JTextField jTextField_Name = new JTextField();
    JLabel jLabel_Hometown = new JLabel();
    JTextField jTextField_Hometown = new JTextField();
    JScrollPane jScrollPane_Photo = new JScrollPane();
    JTextField jTextField_Class = new JTextField();
    JTextField jTextField_Sex = new JTextField();
    JButton jButton_Delete = new JButton();

    public void deleteOne() {
        try {
            if (!canInput) {
                throw new Exception();
            }
            String tempName = "";
            Statement stmt;
            ResultSet rs;
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            Connection con = DriverManager.getConnection("jdbc:odbc:db_STU",
                    "",
                    "");
            stmt = con.createStatement();
            int deleteConfirm = JOptionPane.showConfirmDialog(this,
                    "你确定要删除该学生的信息记录（其选课信息也会被删除）？", "删除记录？", 2);
            if (deleteConfirm == 0) {
                String tempOrder =
                        "delete from Basic_Info where 学号=(select 学号 from Basic_Info where 学号=" +
                        "'" + strNumber + "')";
                stmt.executeUpdate(tempOrder);
                 String order =
                         "delete from Result_Info where 学号=(select 学号 from Result_Info where 学号=" +
                         "'" + strNumber + "')";
                 stmt.executeUpdate(order);
                 //将学生的选课信息一同从Result_Info中删除
            }
            stmt.close();
            con.close();
        } catch (Exception e) {
        }
        reset();
    }

    public void check() {
        strNumber = jTextField_SN.getText().trim();
        if (strNumber.equals("")) {
            JOptionPane.showMessageDialog(this, "  学生的学号不能为空！",
                                          "注意！", 2);
        } else {
            try {
                String tempName = "";
                Statement stmt;
                ResultSet rs;
                Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
                Connection con = DriverManager.getConnection("jdbc:odbc:db_STU",
                        "",
                        "");
                stmt = con.createStatement();
                rs = stmt.executeQuery("select * from Basic_Info");
                while (rs.next()) {
                    if (strNumber.equals(rs.getString(1))) {
                        jTextField_SN.setEditable(false);
                        tempName = rs.getString(2);
                        jTextField_Name.setText(tempName);
                        jTextField_ID.setText(rs.getString(3));
                        jTextField_Sex.setText(rs.getString(4));
                        jTextField_Age.setText(rs.getString(5));
                        jTextField_Nation.setText(rs.getString(6));
                        jTextField_Major.setText(rs.getString(7));
                        jTextField_College.setText(rs.getString(8));
                        jTextField_Grade.setText(rs.getString(9));
                        jTextField_Class.setText(rs.getString(10));
                        jTextField_Status.setText(rs.getString(11));
                        jTextField_Hometown.setText(rs.getString(12));
                        jTextField_Other.setText(rs.getString(13));
                        canInput = true;
                        jButton_Delete.setEnabled(canInput && TestFrame.id == 1);
                        jButton_Check.setEnabled(false);
                        jButton_Reset.setEnabled(canInput);
                        break;
                    }
                }
                if (tempName.equals("")) {
                    reset();
                    JOptionPane.showMessageDialog(this,
                                                  "抱歉，没找到学号为“" + strNumber +
                                                  "”的学生记录。请检查输入的学号是否正确！\n如有其它问题请与管理员联系。",
                                                  "注意！", 2);
                }
                stmt.close();
                con.close();
            } catch (Exception e) {
            }
        }
    }

    public void reset() {
        canInput = false;
        jTextField_SN.setText("");
        jTextField_Name.setText("");
        jTextField_ID.setText("");
        jTextField_Sex.setText("");
        jTextField_Age.setText("");
        jTextField_Nation.setText("");
        jTextField_Major.setText("");
        jTextField_College.setText("");
        jTextField_Grade.setText("");
        jTextField_Class.setText("");
        jTextField_Status.setText("");
        jTextField_Hometown.setText("");
        jTextField_Other.setText("");
        jButton_Check.setEnabled(true);
        jTextField_SN.setEditable(true);
        jButton_Delete.setEnabled(canInput && TestFrame.id == 1);
    }

    public void jButton_Check_actionPerformed(ActionEvent e) {
        check();
    }

    public void jButton_Cancel_actionPerformed(ActionEvent e) {
        dispose();
    }

    public void jTextField_SN_actionPerformed(ActionEvent e) {
        check();
    }

    public void jButton_Reset_actionPerformed(ActionEvent e) {
        reset();
        jButton_Reset.setEnabled(false);
        jTextField_SN.setEditable(true);
    }

    public void jButton_Delete_actionPerformed(ActionEvent e) {
        deleteOne();
    }

    public static void main(String[] args) {
        new BasicInfoCheck(new AFrame(), true);
    }
}


class BasicInfoCheck_jButton_Delete_actionAdapter implements ActionListener {
    private BasicInfoCheck adaptee;
    BasicInfoCheck_jButton_Delete_actionAdapter(BasicInfoCheck adaptee) {
        this.adaptee = adaptee;
    }

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


class BasicInfoCheck_jButton_Check_actionAdapter implements ActionListener {
    private BasicInfoCheck adaptee;
    BasicInfoCheck_jButton_Check_actionAdapter(BasicInfoCheck adaptee) {
        this.adaptee = adaptee;
    }

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


class BasicInfoCheck_jTextField_SN_actionAdapter implements ActionListener {
    private BasicInfoCheck adaptee;
    BasicInfoCheck_jTextField_SN_actionAdapter(BasicInfoCheck adaptee) {
        this.adaptee = adaptee;
    }

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


class BasicInfoCheck_jButton_Cancel_actionAdapter implements ActionListener {
    private BasicInfoCheck adaptee;
    BasicInfoCheck_jButton_Cancel_actionAdapter(BasicInfoCheck adaptee) {
        this.adaptee = adaptee;
    }

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


class BasicInfoCheck_jButton_Reset_actionAdapter implements ActionListener {
    private BasicInfoCheck adaptee;
    BasicInfoCheck_jButton_Reset_actionAdapter(BasicInfoCheck adaptee) {
        this.adaptee = adaptee;
    }

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