xgkcxx.java

java+SQLServer2005编写的学生学籍管理系统

                }
                kcms.setText(rs.getString("course_Des"));
            }
        }
        catch (SQLException ex) {
            String err = ex.getMessage();
            JOptionPane.showMessageDialog(null, "这是最后一条记录！");
        }
    }

    void previous_actionPerformed(ActionEvent e) {
        kclx.removeAllItems();
        try {
            if (rs.previous()) {
                kcbh.setText(rs.getString("course_No"));
                mc.setText(rs.getString("course_Name"));
                //  kclx.addItem(rs.getString("course_Type"));
                if (rs.getString("course_Type").trim().equals(bx)) {
                    kclx.addItem(bx);
                    kclx.addItem(rx);
                    kclx.addItem(xx);
                }
                else if (rs.getString("course_Type").trim().equals(rx)) {
                    kclx.addItem(rx);
                    kclx.addItem(bx);
                    kclx.addItem(xx);
                }
                else {
                    kclx.addItem(xx);
                    kclx.addItem(bx);
                    kclx.addItem(rx);
                }
                kcms.setText(rs.getString("course_Des"));
            }
            else {
                JOptionPane.showMessageDialog(null, "这是第一条记录!");
            }
        }
        catch (SQLException ex) {
        }
    }

    void next_actionPerformed(ActionEvent e) {
        kclx.removeAllItems();
        try {
            if (rs.next()) {
                kcbh.setText(rs.getString("course_No"));
                mc.setText(rs.getString("course_Name"));
                //   kclx.addItem(rs.getString("course_Type"));
                if (rs.getString("course_Type").trim().equals(bx)) {
                    kclx.addItem(bx);
                    kclx.addItem(rx);
                    kclx.addItem(xx);
                }
                else if (rs.getString("course_Type").trim().equals(rx)) {
                    kclx.addItem(rx);
                    kclx.addItem(bx);
                    kclx.addItem(xx);
                }
                else {
                    kclx.addItem(xx);
                    kclx.addItem(bx);
                    kclx.addItem(rx);
                }
                kcms.setText(rs.getString("course_Des"));
            }
            else {
                JOptionPane.showMessageDialog(null, "这是最后一条记录!");
            }
        }
        catch (SQLException ex) {

        }
    }

    void gxsj_actionPerformed(ActionEvent e) {
        try {
            rs = ps.executeQuery("select * from course");
            if (rs.next()) {
                kcbh.setText(rs.getString("course_No"));
                mc.setText(rs.getString("course_Name"));
                //  kclx.addItem(rs.getString("course_Type"));
                if (rs.getString("course_Type").trim().equals(bx)) {
                    kclx.addItem(bx);
                    kclx.addItem(rx);
                    kclx.addItem(xx);
                }
                else if (rs.getString("course_Type").trim().equals(rx)) {
                    kclx.addItem(rx);
                    kclx.addItem(bx);
                    kclx.addItem(xx);
                }
                else {
                    kclx.addItem(xx);
                    kclx.addItem(bx);
                    kclx.addItem(rx);
                }
                kcms.setText(rs.getString("course_Des"));
            }
        }
        catch (SQLException ex) {
            String err = ex.getMessage();
            JOptionPane.showMessageDialog(null, err);
        }
    }

    void scjl_actionPerformed(ActionEvent e) {
        JOptionPane.showConfirmDialog(null,"确定删除？", "删除课程", JOptionPane.YES_NO_OPTION);                                    
        try {
            sc.executeUpdate("delete from result where 'course_Name'=(select course_Name from course where course_No='" +
                          kcbh.getText() +"');");
            System.out.println("here");
            ins.executeUpdate("delete from course where course_No='" +
                          kcbh.getText() +
                          "'");

            JOptionPane.showMessageDialog(null, "删除成功!");
            try {
                rs = ps.executeQuery("select * from course");

                if (rs.next()) {
                    kcbh.setText(rs.getString("course_No"));
                    mc.setText(rs.getString("course_Name"));
                    //  kclx.addItem(rs.getString("course_Type"));
                    if (rs.getString("course_Type").trim().equals(bx)) {
                        kclx.addItem(bx);
                        kclx.addItem(rx);
                        kclx.addItem(xx);
                    }
                    else if (rs.getString("course_Type").trim().equals(rx)) {
                        kclx.addItem(rx);
                        kclx.addItem(bx);
                        kclx.addItem(xx);
                    }
                    else {
                        kclx.addItem(xx);
                        kclx.addItem(bx);
                        kclx.addItem(rx);
                    }
                    kcms.setText(rs.getString("course_Des"));
                }
            }
            catch (SQLException ex) {
                String err = ex.getMessage();
                JOptionPane.showMessageDialog(null, err);
            }
        }
        catch (SQLException ex) {
            String err = ex.getMessage();
            JOptionPane.showMessageDialog(null, err);
        }
    }

    void cencel_actionPerformed(ActionEvent e) {
        this.dispose();
    }
}

class xgkcxx_xgjl_actionAdapter
    implements java.awt.event.ActionListener {
    xgkcxx adaptee;

    xgkcxx_xgjl_actionAdapter(xgkcxx adaptee) {
        this.adaptee = adaptee;
    }

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

class xgkcxx_first_actionAdapter
    implements java.awt.event.ActionListener {
    xgkcxx adaptee;

    xgkcxx_first_actionAdapter(xgkcxx adaptee) {
        this.adaptee = adaptee;
    }

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

class xgkcxx_previous_actionAdapter
    implements java.awt.event.ActionListener {
    xgkcxx adaptee;

    xgkcxx_previous_actionAdapter(xgkcxx adaptee) {
        this.adaptee = adaptee;
    }

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

class xgkcxx_next_actionAdapter
    implements java.awt.event.ActionListener {
    xgkcxx adaptee;

    xgkcxx_next_actionAdapter(xgkcxx adaptee) {
        this.adaptee = adaptee;
    }

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

class xgkcxx_last_actionAdapter
    implements java.awt.event.ActionListener {
    xgkcxx adaptee;

    xgkcxx_last_actionAdapter(xgkcxx adaptee) {
        this.adaptee = adaptee;
    }

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

class xgkcxx_gxsj_actionAdapter
    implements java.awt.event.ActionListener {
    xgkcxx adaptee;

    xgkcxx_gxsj_actionAdapter(xgkcxx adaptee) {
        this.adaptee = adaptee;
    }

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

class xgkcxx_scjl_actionAdapter
    implements java.awt.event.ActionListener {
    xgkcxx adaptee;

    xgkcxx_scjl_actionAdapter(xgkcxx adaptee) {
        this.adaptee = adaptee;
    }

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

class xgkcxx_cencel_actionAdapter
    implements java.awt.event.ActionListener {
    xgkcxx adaptee;

    xgkcxx_cencel_actionAdapter(xgkcxx adaptee) {
        this.adaptee = adaptee;
    }

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