diaryframe.java

ACCP 软件工程java 教程学生用书

            } else if (btnAdd.getText().equals("保存")) {
                sqlString = "Insert into Contacts values('" +
                            txtFirstName.getText() + "', '" +
                            txtLastName.getText() + "','" + txaAddress.getText() +
                            "', " + Integer.parseInt(txtTel.getText()) + "," +
                            Integer.parseInt(txtMobile.getText()) + ", '" +
                            txtEmailID.getText() + "')";
                stmt.executeUpdate(sqlString);
                JOptionPane.showMessageDialog(contentPane, "已成功添加记录");
                sqlString = "Select * from Contacts";
                rsContacts = stmt.executeQuery(sqlString);
                rsContacts.next();
                rsToText();
                btnAdd.setText("添加");
                btnDelete.setText("删除");
            }
        } catch (Exception sql) {
            System.out.println(sql);
        }
    }

    public void btnPrevious_actionPerformed(ActionEvent e) {
        try {
            rsContacts.previous();
            rsToText();
            if (rsContacts.isFirst()) {
                btnNext.setEnabled(true);
                btnLast.setEnabled(true);
                btnPrevious.setEnabled(false);

            }

        } catch (SQLException sql) {

        }
    }

    public void btnNext_actionPerformed(ActionEvent e) {
        try {
            rsContacts.next();
            rsToText();
            btnFirst.setEnabled(true);
            btnPrevious.setEnabled(true);
            if (rsContacts.isLast()) {
                btnNext.setEnabled(false);
                btnLast.setEnabled(false);
                btnFirst.setEnabled(true);
                btnPrevious.setEnabled(true);
            }

        } catch (Exception sql) {

        }
    }

    public void btnFirst_actionPerformed(ActionEvent e) {
        try {
            rsContacts.first();
            rsToText();
            if (rsContacts.isLast()) {
                btnFirst.setEnabled(false);
                btnPrevious.setEnabled(false);
                btnLast.setEnabled(false);
                btnNext.setEnabled(false);
            } else {
                btnFirst.setEnabled(false);
                btnPrevious.setEnabled(false);
                btnNext.setEnabled(true);
                btnLast.setEnabled(true);
            }
        } catch (Exception sql) {
        }
    }

    public void btnLast_actionPerformed(ActionEvent e) {
        try {
            rsContacts.last();
            rsToText();
            if (rsContacts.isLast()) {
                btnFirst.setEnabled(true);
                btnLast.setEnabled(false);
                btnNext.setEnabled(false);
                btnPrevious.setEnabled(true);
            }

        } catch (Exception sql) {

        }
    }

    public void btnSearch_actionPerformed(ActionEvent e) {
        if (btnDelete.getText().equals("删除")) {
            sqlString = "Insert into Contacts values('" + txtFirstName.getText() +
                        "', '" + txtLastName.getText() + "','" +
                        txaAddress.getText() + "', " +
                        Integer.parseInt(txtTel.getText()) + "," +
                        Integer.parseInt(txtMobile.getText()) + ", '" +
                        txtEmailID.getText() + "')";
            int answer;
            answer = JOptionPane.showConfirmDialog(contentPane, "是否确实要删除当前记录",
                    "删除", JOptionPane.ERROR_MESSAGE);
            switch (answer) {
            case JOptionPane.YES_OPTION: {
                try {
                    stmt.executeUpdate(
                            "Delete from Contacts where FirstName = '" +
                            txtFirstName.getText() + "'");
                    sqlString = "Select * from Contacts";
                    rsContacts = stmt.executeQuery(sqlString);
                    rsContacts.next();
                    rsToText();
                    JOptionPane.showMessageDialog(contentPane,
                                                  "记录已成功删除");
                    if (rsContacts.isFirst()) {
                        btnFirst.setEnabled(false);
                        btnPrevious.setEnabled(false);
                        btnLast.setEnabled(true);
                        btnNext.setEnabled(true);
                    }
                } catch (Exception sql) {
                    System.out.println(sql);
                }
            }
            }
        } else if (btnDelete.getText().equals("取消")) {
            try {
                btnDelete.setText("删除");
                btnAdd.setText("添加");
                sqlString = "Select * from Contacts";
                rsContacts = stmt.executeQuery(sqlString);
                rsContacts.next();
                rsToText();
                btnNext.setEnabled(true);
                btnLast.setEnabled(true);
            } catch (Exception sql) {
                System.out.println(sql);
            }

        }
    }
}


class DiaryFrame_btnSearch_actionAdapter implements ActionListener {
    private DiaryFrame adaptee;
    DiaryFrame_btnSearch_actionAdapter(DiaryFrame adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {

        adaptee.btnSearch_actionPerformed(e);
    }
}


class DiaryFrame_btnLast_actionAdapter implements ActionListener {
    private DiaryFrame adaptee;
    DiaryFrame_btnLast_actionAdapter(DiaryFrame adaptee) {
        this.adaptee = adaptee;
    }

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


class DiaryFrame_btnFirst_actionAdapter implements ActionListener {
    private DiaryFrame adaptee;
    DiaryFrame_btnFirst_actionAdapter(DiaryFrame adaptee) {
        this.adaptee = adaptee;
    }

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


class DiaryFrame_btnPrevious_actionAdapter implements ActionListener {
    private DiaryFrame adaptee;
    DiaryFrame_btnPrevious_actionAdapter(DiaryFrame adaptee) {
        this.adaptee = adaptee;
    }

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


class DiaryFrame_btnAdd_actionAdapter implements ActionListener {
    private DiaryFrame adaptee;
    DiaryFrame_btnAdd_actionAdapter(DiaryFrame adaptee) {
        this.adaptee = adaptee;
    }

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


class DiaryFrame_btnExit_actionAdapter implements ActionListener {
    private DiaryFrame adaptee;
    DiaryFrame_btnExit_actionAdapter(DiaryFrame adaptee) {
        this.adaptee = adaptee;
    }

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


class DiaryFrame_btnNext_actionAdapter implements ActionListener {
    private DiaryFrame adaptee;
    DiaryFrame_btnNext_actionAdapter(DiaryFrame adaptee) {
        this.adaptee = adaptee;
    }

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