xgxjxx.java

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

    void next_actionPerformed(ActionEvent e) {
        try {
            if (rs.next()) {
            xh.setText(rs.getString("student_ID"));
            xm.setText(rs.getString("student_Name"));
            sex.setText(rs.getString("student_Sex"));
            rq.setText(rs.getString("born_Date").substring(0, 10));
            bh.addItem(rs.getString("class_NO"));
            tel.setText(rs.getString("tele_Number"));
            rxrq.setText(rs.getString("ru_Date").substring(0, 10));
            address.setText(rs.getString("address"));
            comment.setText(rs.getString("comment"));
        }
        else
            JOptionPane.showMessageDialog(null, "这是最后一条记录");
        }
        catch (SQLException sqle) {
            String error = sqle.getMessage();
            JOptionPane.showMessageDialog(null, error);
            sqle.printStackTrace();
        }
    }

    void previous_actionPerformed(ActionEvent e) {
        try {
            if (rs.previous()) {
            xh.setText(rs.getString("student_ID"));
            xm.setText(rs.getString("student_Name"));
            sex.setText(rs.getString("student_Sex"));
            rq.setText(rs.getString("born_Date").substring(0, 10));
            bh.addItem(rs.getString("class_NO"));
            tel.setText(rs.getString("tele_Number"));
            rxrq.setText(rs.getString("ru_Date").substring(0, 10));
            address.setText(rs.getString("address"));
            comment.setText(rs.getString("comment"));
        }
        else
            JOptionPane.showMessageDialog(null, "这是第一条记录");
        }
        catch (SQLException sqle) {
            String error = sqle.getMessage();
            JOptionPane.showMessageDialog(null, error);
            sqle.printStackTrace();
        }
    }

    void last_actionPerformed(ActionEvent e) {
        try {
            if (rs.last()) {
                xh.setText(rs.getString("student_ID"));
                xm.setText(rs.getString("student_Name"));
                sex.setText(rs.getString("student_Sex"));
                rq.setText(rs.getString("born_Date").substring(0, 10));
                bh.addItem(rs.getString("class_NO"));
                tel.setText(rs.getString("tele_Number"));
                rxrq.setText(rs.getString("ru_Date").substring(0, 10));
                address.setText(rs.getString("address"));
                comment.setText(rs.getString("comment"));
            }
            else
                JOptionPane.showMessageDialog(null, "这是最后一条记录");
        }   
        catch (SQLException sqle) {
            String error = sqle.getMessage();
            JOptionPane.showMessageDialog(null, error);
            sqle.printStackTrace();
        }
    }

    void gxjl_actionPerformed(ActionEvent e) {
        try {
            rs = ps.executeQuery("select * from student"); //读取数据库
            if (rs.next()) {
                xh.setText(rs.getString("student_ID"));
                xm.setText(rs.getString("student_Name"));
                sex.setText(rs.getString("student_Sex"));
                rq.setText(rs.getString("born_Date").substring(0, 10));
                bh.addItem(rs.getString("class_NO"));
                tel.setText(rs.getString("tele_Number"));
                rxrq.setText(rs.getString("ru_Date").substring(0, 10));
                address.setText(rs.getString("address"));
                comment.setText(rs.getString("comment"));
            }
        }
        catch (SQLException sqle) {
            String error = sqle.getMessage();
            JOptionPane.showMessageDialog(null, error);
            sqle.printStackTrace();
        }
    }

    void xgxl_actionPerformed(ActionEvent e) {
        JOptionPane.showConfirmDialog(null,"确定修改", "修改学籍", JOptionPane.YES_NO_OPTION);                                     
        try {
            ps.executeUpdate("update student set student_Name='" + xm.getText().trim() +
                       "',student_Sex='" + sex.getText().trim() +
                       "',born_Date='"
                       + rq.getText().trim() + "',class_NO='" +
                      bh.getSelectedItem()+ "',tele_Number='"
                       + tel.getText().trim() + "',ru_Date='" +
                       rxrq.getText().trim() + "',address='" +
                       address.getText().trim() + "',comment='"
                       + comment.getText().trim() + "'where student_ID='" +
                       xh.getText().trim() +
                       "'");
            JOptionPane.showMessageDialog(null, "修改学籍成功");
            //this.dispose();
        }
        catch (SQLException sqle) {
            String error = sqle.getMessage();
            JOptionPane.showMessageDialog(null, error);
            sqle.printStackTrace();
        }
    }

    void delete_actionPerformed(ActionEvent e) {
        int v=JOptionPane.showConfirmDialog(this,"确定删除吗？将删除所有此学生信息","用户确认",
                                             JOptionPane.OK_CANCEL_OPTION,
                                             JOptionPane.INFORMATION_MESSAGE);
        if(v==JOptionPane.OK_OPTION){         
            try {
                ps.executeUpdate("delete from student where student_ID='" +
                           xh.getText().trim() +
                           "'");
                ps.executeUpdate("delete from result where student_ID='" +
                           xh.getText().trim() +
                           "'");
                JOptionPane.showMessageDialog(null, "删除学籍成功");
                //this.dispose();
            }
            catch (SQLException sqle) {
                String error = sqle.getMessage();
                JOptionPane.showMessageDialog(null, error);
                sqle.printStackTrace();

            }
        }
        try {
            String name = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
            String url ="jdbc:sqlserver://localhost:1433;DatabaseName=Student";  
            Class.forName(name);
            Connection con = DriverManager.getConnection(url, "ss", "123");
            ps = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);                            
        }
        catch (Exception err) {
            String error = err.getMessage();
            JOptionPane.showMessageDialog(null, error);

        }
        try {
            rs = ps.executeQuery("select * from student"); //读取数据库
            if (rs.next()) {
                xh.setText(rs.getString("student_ID"));
                xm.setText(rs.getString("student_Name"));
                sex.setText(rs.getString("student_Sex"));
                rq.setText(rs.getString("born_Date").substring(0, 10));
                bh.addItem(rs.getString("class_NO"));
                tel.setText(rs.getString("tele_Number"));
                rxrq.setText(rs.getString("ru_Date").substring(0, 10));
                address.setText(rs.getString("address"));
                comment.setText(rs.getString("comment"));
            }
        }
        catch (SQLException sqle) {
            String error = sqle.getMessage();
            JOptionPane.showMessageDialog(null, error);
            sqle.printStackTrace();
        }
    }

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

    void bh_actionPerformed(ActionEvent e) {

    }
}

class xgxjxx_first_actionAdapter implements java.awt.event.ActionListener {   
    xgxjxx adaptee;
    xgxjxx_first_actionAdapter(xgxjxx adaptee) {
        this.adaptee = adaptee;
    }
    public void actionPerformed(ActionEvent e) {
        adaptee.first_actionPerformed(e);
    }
}

class xgxjxx_next_actionAdapter implements java.awt.event.ActionListener {   
    xgxjxx adaptee;
    xgxjxx_next_actionAdapter(xgxjxx adaptee) {
        this.adaptee = adaptee;
    }
    public void actionPerformed(ActionEvent e) {
        adaptee.next_actionPerformed(e);
    }
}

class xgxjxx_previous_actionAdapter implements java.awt.event.ActionListener {   
    xgxjxx adaptee;
    xgxjxx_previous_actionAdapter(xgxjxx adaptee) {
        this.adaptee = adaptee;
    }
    public void actionPerformed(ActionEvent e) {
        adaptee.previous_actionPerformed(e);
    }
}

class xgxjxx_last_actionAdapter implements java.awt.event.ActionListener {   
    xgxjxx adaptee;
    xgxjxx_last_actionAdapter(xgxjxx adaptee) {
        this.adaptee = adaptee;
    }
    public void actionPerformed(ActionEvent e) {
        adaptee.last_actionPerformed(e);
    }
}

class xgxjxx_gxjl_actionAdapter implements java.awt.event.ActionListener {   
    xgxjxx adaptee;
    xgxjxx_gxjl_actionAdapter(xgxjxx adaptee) {
        this.adaptee = adaptee;
    }
    public void actionPerformed(ActionEvent e) {
        adaptee.gxjl_actionPerformed(e);
    }
}

class xgxjxx_xgxl_actionAdapter implements java.awt.event.ActionListener {  
    xgxjxx adaptee;
    xgxjxx_xgxl_actionAdapter(xgxjxx adaptee) {
        this.adaptee = adaptee;
    }
    public void actionPerformed(ActionEvent e) {
        adaptee.xgxl_actionPerformed(e);
    }
}

class xgxjxx_delete_actionAdapter implements java.awt.event.ActionListener {
    xgxjxx adaptee;
    xgxjxx_delete_actionAdapter(xgxjxx adaptee) {
        this.adaptee = adaptee;
    }
    public void actionPerformed(ActionEvent e) {
        adaptee.delete_actionPerformed(e);
    }
}

class xgxjxx_cancel_actionAdapter implements java.awt.event.ActionListener {
    xgxjxx adaptee;
    xgxjxx_cancel_actionAdapter(xgxjxx adaptee) {
        this.adaptee = adaptee;
    }
    public void actionPerformed(ActionEvent e) {
        adaptee.cancel_actionPerformed(e);
    }
}

class xgxjxx_bh_actionAdapter implements java.awt.event.ActionListener {
    xgxjxx adaptee;
    xgxjxx_bh_actionAdapter(xgxjxx adaptee) {
        this.adaptee = adaptee;
    }
    public void actionPerformed(ActionEvent e) {
        adaptee.bh_actionPerformed(e);
    }
}