mainframe.java

学生管理系统

                    for(int i = 0; i < temp.size()/rsmd.getColumnCount(); i++){
                        for(int j = 0; j < rsmd.getColumnCount(); j++){
                            strInfo_cell[i][j] = temp.elementAt(i*rsmd.getColumnCount()+j);
                        }
                    }
//                    System.out.println("strInfo_cell-->"+strInfo_cell[0][0]);
//                    System.out.println("strColnames-->"+strColnames[0]);
                    if(jTable1 != null){
                        jTable1 = null;
                    }

                    jTable1 = new JTable(strInfo_cell,strColnames);
                    jScrollPane2.getViewport().add(jTable1);
                } catch (SQLException ex1) {
                    ex1.printStackTrace();
        }
    }

    public void jButton4_actionPerformed(ActionEvent e) {

        try {
                            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); //驅動加載
                        } catch (ClassNotFoundException ex) {
                        }

                        String sql = "select Grade_name as 年級,kc_name as 課程名,kc_book as 使用書本 from kctable,gradetable where gradetable.Grade_id=kctable.Grade_id";
                        try {
                            Connection con = DriverManager.getConnection("jdbc:odbc:glxt"); //數據橋連名子為ＯＤＢＣ名為glxt

                            PreparedStatement pstm = con.prepareStatement(sql);
//                    pstm.setInt(1,);where grade_id=
                            ResultSet rs = pstm.executeQuery();

                            ResultSetMetaData rsmd = rs.getMetaData();
//                            System.out.println("rsmd-->" + rsmd.getColumnCount());
                            Vector temp = new Vector();

                            while(rs.next()){
//                        System.out.println("hhhhhhhh");
                                for(int i = 0; i < rsmd.getColumnCount(); i++ ){
                                    temp.addElement(rs.getString(i+1));
                                }
                            }

                            strInfo_cell = new String[temp.size()/rsmd.getColumnCount()][rsmd.getColumnCount()];

                            strColnames = new String[rsmd.getColumnCount()];
//                            System.out.println("rsmd.getColumnCount()-->"+rsmd.getColumnCount());
                            for (int i = 0; i < rsmd.getColumnCount(); i++) {
                                strColnames[i] = new String(rsmd.getColumnLabel(i+1));
                            }

                            for(int i = 0; i < temp.size()/rsmd.getColumnCount(); i++){
                                for(int j = 0; j < rsmd.getColumnCount(); j++){
                                    strInfo_cell[i][j] = temp.elementAt(i*rsmd.getColumnCount()+j);
                                }
                            }
//                            System.out.println("strInfo_cell-->"+strInfo_cell[0][0]);
//                            System.out.println("strColnames-->"+strColnames[0]);
                            if(jTable1 != null){
                                jTable1 = null;
                            }

                            jTable1 = new JTable(strInfo_cell,strColnames);
                            jScrollPane2.getViewport().add(jTable1);
                        } catch (SQLException ex1) {
                            ex1.printStackTrace();
        }




    }

    public void jButton3_actionPerformed(ActionEvent e) {

        try {
                                   Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); //驅動加載
                               } catch (ClassNotFoundException ex) {
                               }

                               String sql = "select stu_xh as 學號,stu_name as 姓名,stu_sex as 姓別,stu_birthday as 生日,stu_address as 地址,stu_tel as 電話 from stutable";
                               try {
                                   Connection con = DriverManager.getConnection("jdbc:odbc:glxt"); //數據橋連名子為ＯＤＢＣ名為glxt

                                   PreparedStatement pstm = con.prepareStatement(sql);
//                    pstm.setInt(1,);where grade_id=
                                   ResultSet rs = pstm.executeQuery();

                                   ResultSetMetaData rsmd = rs.getMetaData();
//                                   System.out.println("rsmd-->" + rsmd.getColumnCount());
                                   Vector temp = new Vector();

                                   while(rs.next()){
//                        System.out.println("hhhhhhhh");
                                       for(int i = 0; i < rsmd.getColumnCount(); i++ ){
                                           temp.addElement(rs.getString(i+1));
                                       }
                                   }

                                   strInfo_cell = new String[temp.size()/rsmd.getColumnCount()][rsmd.getColumnCount()];

                                   strColnames = new String[rsmd.getColumnCount()];
                                   System.out.println("rsmd.getColumnCount()-->"+rsmd.getColumnCount());
                                   for (int i = 0; i < rsmd.getColumnCount(); i++) {
                                       strColnames[i] = new String(rsmd.getColumnLabel(i+1));
                                   }

                                   for(int i = 0; i < temp.size()/rsmd.getColumnCount(); i++){
                                       for(int j = 0; j < rsmd.getColumnCount(); j++){
                                           strInfo_cell[i][j] = temp.elementAt(i*rsmd.getColumnCount()+j);
                                       }
                                   }
//                                   System.out.println("strInfo_cell-->"+strInfo_cell[0][0]);
//                                   System.out.println("strColnames-->"+strColnames[0]);
                                   if(jTable1 != null){
                                       jTable1 = null;
                                   }

                                   jTable1 = new JTable(strInfo_cell,strColnames);
                                   jScrollPane2.getViewport().add(jTable1);
                               } catch (SQLException ex1) {
                                   ex1.printStackTrace();
        }




    }

    public void jButton1_actionPerformed(ActionEvent e) {

        try {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); //驅動加載
        } catch (ClassNotFoundException ex) {
        }

        String sql = "select stu_name as '姓名',kctable.kc_name as '課程名',cj as '成績' from kctable,stutable FULL outer join cjtable on cjtable.stu_id=stutable.stu_id where cjtable.cj BETWEEN ? and ? and kctable.kc_id=cjtable.kc_id and kctable.kc_name=?";
        try {
            Connection con = DriverManager.getConnection("jdbc:odbc:glxt"); //數據橋連名子為ＯＤＢＣ名為glxt
            PreparedStatement pstm = con.prepareStatement(sql);
            pstm.setInt(1, jComboBox2.getSelectedIndex());
            pstm.setInt(2, jComboBox3.getSelectedIndex());
            pstm.setString(3, String.valueOf(jComboBox1.getSelectedItem()));

//            System.out.println(String.valueOf(jComboBox1.getSelectedItem()));
//            System.out.println(jComboBox3.getSelectedIndex());
//            System.out.println(jComboBox2.getSelectedIndex());

            ResultSet rs = pstm.executeQuery();
            ResultSetMetaData rsmd = rs.getMetaData();
            Vector temp = new Vector();

            while (rs.next()) {

                for (int i = 0; i < rsmd.getColumnCount(); i++) {
                    temp.addElement(rs.getString(i + 1));
                }
            }

            strInfo_cell = new String[temp.size() /
                           rsmd.getColumnCount()][rsmd.getColumnCount()];

            strColnames = new String[rsmd.getColumnCount()];

            for (int i = 0; i < rsmd.getColumnCount(); i++) {
                strColnames[i] = new String(rsmd.getColumnLabel(i + 1));
            }

            for (int i = 0; i < temp.size() / rsmd.getColumnCount(); i++) {
                for (int j = 0; j < rsmd.getColumnCount(); j++) {
                    strInfo_cell[i][j] = temp.elementAt(i * rsmd.getColumnCount() +
                            j);
                }
            }

            if (jTable1 != null) {
                jTable1 = null;
            }

            jTable1 = new JTable(strInfo_cell,
                                 strColnames);
            jScrollPane2.getViewport().add(
                    jTable1);
        } catch (SQLException ex1) {
            ex1.printStackTrace();
        }


        }

    public void jTree1_valueChanged(TreeSelectionEvent e) {

System.out.println("jTree1_valueChanged");
    }

    public void jTree1_vetoableChange(PropertyChangeEvent evt) throws
            PropertyVetoException {
System.out.println("jTree1_vetoableChange");
    }
}


class MainFrame_jTree1_treeSelectionAdapter implements TreeSelectionListener {
    private MainFrame adaptee;
    MainFrame_jTree1_treeSelectionAdapter(MainFrame adaptee) {
        this.adaptee = adaptee;
    }

    public void valueChanged(TreeSelectionEvent e) {
        adaptee.jTree1_valueChanged(e);
        System.out.println("valueChanged");
    }
}


class MainFrame_jTree1_vetoableChangeAdapter implements VetoableChangeListener {
    private MainFrame adaptee;
    MainFrame_jTree1_vetoableChangeAdapter(MainFrame adaptee) {
        this.adaptee = adaptee;
    }

    public void vetoableChange(PropertyChangeEvent evt) {
        try {
            adaptee.jTree1_vetoableChange(evt);
        } catch (java.beans.PropertyVetoException exception0) {
            exception0.printStackTrace();
        }
    }
}


class MainFrame_jButton1_actionAdapter implements ActionListener {
    private MainFrame adaptee;
    MainFrame_jButton1_actionAdapter(MainFrame adaptee) {
        this.adaptee = adaptee;
    }

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


class MainFrame_jButton3_actionAdapter implements ActionListener {
    private MainFrame adaptee;
    MainFrame_jButton3_actionAdapter(MainFrame adaptee) {
        this.adaptee = adaptee;
    }

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


class MainFrame_jButton4_actionAdapter implements ActionListener {
    private MainFrame adaptee;
    MainFrame_jButton4_actionAdapter(MainFrame adaptee) {
        this.adaptee = adaptee;
    }

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


class MainFrame_jButton2_actionAdapter implements ActionListener {
    private MainFrame adaptee;
    MainFrame_jButton2_actionAdapter(MainFrame adaptee) {
        this.adaptee = adaptee;
    }

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


class MainFrame_jComboBox2_actionAdapter implements ActionListener {
    private MainFrame adaptee;
    MainFrame_jComboBox2_actionAdapter(MainFrame adaptee) {
        this.adaptee = adaptee;
    }

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


class MainFrame_jComboBox1_actionAdapter implements ActionListener {
    private MainFrame adaptee;
    MainFrame_jComboBox1_actionAdapter(MainFrame adaptee) {
        this.adaptee = adaptee;
    }

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


class MainFrame_jMenuItem3_actionAdapter implements ActionListener {
    private MainFrame adaptee;
    MainFrame_jMenuItem3_actionAdapter(MainFrame adaptee) {
        this.adaptee = adaptee;
    }

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


class MainFrame_jMenuItem4_actionAdapter implements ActionListener {
    private MainFrame adaptee;
    MainFrame_jMenuItem4_actionAdapter(MainFrame adaptee) {
        this.adaptee = adaptee;
    }

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


class MainFrame_jMenuItem2_actionAdapter implements ActionListener {
    private MainFrame adaptee;
    MainFrame_jMenuItem2_actionAdapter(MainFrame adaptee) {
        this.adaptee = adaptee;
    }

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


class MainFrame_jMenuItem1_actionAdapter implements ActionListener {
    private MainFrame adaptee;
    MainFrame_jMenuItem1_actionAdapter(MainFrame adaptee) {
        this.adaptee = adaptee;
    }

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