frame2.java

学生管理系统

    JComboBox jComboBox1 = new JComboBox();
    JLabel jLabel5 = new JLabel();
    JTextField F3 = new JTextField();
    JLabel jLabel6 = new JLabel();
    JTextField F4 = new JTextField();
    JLabel jLabel7 = new JLabel();
    JTextField F5 = new JTextField();
    JLabel jLabel8 = new JLabel();
    JPanel jPanel2 = new JPanel();
    JButton jButton1 = new JButton();
    JButton jButton2 = new JButton();
    JButton jButton3 = new JButton();
    JButton jButton4 = new JButton();
    TitledBorder titledBorder1 = new TitledBorder("");
    JLabel jLabel9 = new JLabel();
    JTextField Fe = new JTextField();
    JLabel jLabel10 = new JLabel();
    JTextField Fe1 = new JTextField();
    JLabel jLabel11 = new JLabel();
    JComboBox jComboBox2 = new JComboBox();
    JLabel jLabel12 = new JLabel();
    JTextField Fe2 = new JTextField();
    JLabel jLabel13 = new JLabel();
    JTextField Fe3 = new JTextField();
    JLabel jLabel14 = new JLabel();
    JTextField Fe4 = new JTextField();
    JButton jButton5 = new JButton();
    JButton jButton6 = new JButton();


    public void this_windowOpened(WindowEvent e) { //连库
        try {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            con = DriverManager.getConnection("jdbc:odbc:ser");
            set = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
                                      ResultSet.CONCUR_READ_ONLY);
            rc = set.executeQuery("select * from Student");
            rc.next();
        } catch (Exception ew) {
            ew.printStackTrace();
        }
    }

    public void cod() {
        try {
            F1.setText(rc.getString(1).trim());
            F2.setText(rc.getString(2).trim());
            jComboBox1.setSelectedItem(rc.getString(3).trim());
            F3.setText(rc.getString(4).trim());
            F4.setText(rc.getString(5).trim());
            F5.setText(rc.getString(6).trim());

        } catch (Exception go) {
            go.printStackTrace();
        }
    }

    public void jButton1_actionPerformed(ActionEvent e) { //最前一条
        try {
            rc.first();
            cod();

        } catch (Exception dd) {
            dd.printStackTrace();
        }

    }

    public void jButton2_actionPerformed(ActionEvent e) { //下一条
        try {
            if (!rc.isLast()) {
                rc.next();
                cod();
            }
        } catch (Exception gg) {
            gg.printStackTrace();
        }

    }

    public void jButton3_actionPerformed(ActionEvent e) { //上一条
        try {
            if (!rc.isFirst()) {
                rc.previous();
                cod();
            }

        } catch (Exception r) {
            r.printStackTrace();
        }
    }

    public void jButton4_actionPerformed(ActionEvent e) { //最后一条
        try {
            rc.last();
            cod();

        } catch (Exception r) {
            r.printStackTrace();
        }

    }

    public void jButton6_actionPerformed(ActionEvent e) {
        System.exit(0);
    }

    public void jButton5_actionPerformed(ActionEvent e) {
        try {
            con = DriverManager.getConnection("jdbc:odbc:ser");
//      Statement st = con.prepareStatement("insert into Student values('"+Fe.getText()+"','"+Fe1.getText()+"','"+jComboBox2.getSelectedItem().toString()+"','"+Fe2.getText())+"','"+Fe3.getText()+"','"+Fe4.getText()+"')");
            PreparedStatement st = con.prepareStatement(
                    "insert into  Student values(?,?,?,?,?,?) ");
            st.setString(1, Fe.getText());
            st.setString(2, Fe1.getText());
            st.setString(3, jComboBox2.getSelectedItem().toString());
            st.setString(4, Fe2.getText());
            st.setString(5, Fe3.getText());
            st.setString(6, Fe4.getText());
            st.executeUpdate();
            JOptionPane.showMessageDialog(this,"已成功写入表");
        } catch (Exception ro) {
            ro.printStackTrace();
        }
    }


}


class Frame2_jButton5_actionAdapter implements ActionListener {
    private Frame2 adaptee;
    Frame2_jButton5_actionAdapter(Frame2 adaptee) {
        this.adaptee = adaptee;
    }

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


class Frame2_jButton6_actionAdapter implements ActionListener {
    private Frame2 adaptee;
    Frame2_jButton6_actionAdapter(Frame2 adaptee) {
        this.adaptee = adaptee;
    }

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


class Frame2_jButton4_actionAdapter implements ActionListener {
    private Frame2 adaptee;
    Frame2_jButton4_actionAdapter(Frame2 adaptee) {
        this.adaptee = adaptee;
    }

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


class Frame2_jButton3_actionAdapter implements ActionListener {
    private Frame2 adaptee;
    Frame2_jButton3_actionAdapter(Frame2 adaptee) {
        this.adaptee = adaptee;
    }

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


class Frame2_jButton2_actionAdapter implements ActionListener {
    private Frame2 adaptee;
    Frame2_jButton2_actionAdapter(Frame2 adaptee) {
        this.adaptee = adaptee;
    }

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


class Frame2_jButton1_actionAdapter implements ActionListener {
    private Frame2 adaptee;
    Frame2_jButton1_actionAdapter(Frame2 adaptee) {
        this.adaptee = adaptee;
    }

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


class Frame2_this_windowAdapter extends WindowAdapter {
    private Frame2 adaptee;
    Frame2_this_windowAdapter(Frame2 adaptee) {
        this.adaptee = adaptee;
    }

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