jf_view_gradesub.java

学生成绩管理系统 1.1 管理员登录 双击“学生成绩管理系统.exe”文件

                                  JOptionPane.YES_NO_OPTION,JOptionPane.QUESTION_MESSAGE,
                                  null,new String[]  {"是","否"},"否");
       if (result == JOptionPane.NO_OPTION) return;

        int rcount ;
        rcount = jTable2.getRowCount();
        if (rcount > 0){
            appstu.util.JdbcAdapter jdbcAdapter = new appstu.util.JdbcAdapter();
            Obj_gradeinfo_sub[] object = new Obj_gradeinfo_sub[rcount];
            for (int i = 0; i < rcount; i++) {
                object[i] = new Obj_gradeinfo_sub();
                object[i].setStuid(String.valueOf(jTable2.getValueAt(0, 0)));
                object[i].setKindID(examkindid[jComboBox1.getSelectedIndex()]);
                //object[i].setCode("0" + (i + 1));
                object[i].setCode(subjectcode[i]);
                object[i].setSutname(String.valueOf(jTable2.getValueAt(0, 1)));
                float grade;
                grade = Float.parseFloat(String.valueOf(jTable2.getValueAt(i, 4)));
                object[i].setGrade(grade);
                java.sql.Date rq = null;
                try {
                    System.out.println(jTable2.getValueAt(i,5));
                    String strrq = String.valueOf(jTable2.getValueAt(i,5));
                    System.out.println(i + ";strrq = " + strrq + "strrq.length = " + strrq.length());
                    rq = java.sql.Date.valueOf(strrq);
                    System.out.println("rq = " + rq);
                } catch (Exception dt) {
                    JOptionPane.showMessageDialog(null,
                                                  "第【" + i + "】行输入的数据格式有误,请重新录入!!\n" +
                                                  dt.getMessage(), "系统提示",
                                                  JOptionPane.ERROR_MESSAGE);
                    return;
                }
                object[i].setExamdate(rq);
            }
            //执行公共类中的数据存盘操作
            jdbcAdapter.InsertOrUpdate_Obj_gradeinfo_sub(object);
        }


    }

    public void jBexit_actionPerformed(ActionEvent e) {
        javax.swing.DefaultDesktopManager manger = new DefaultDesktopManager();
        int result = JOptionPane.showOptionDialog(null,"是否退出学生考试成绩管理?","系统提示",
                                   JOptionPane.YES_NO_OPTION,JOptionPane.QUESTION_MESSAGE,
                                   null,new String[]  {"是","否"},"否");
        if (result == JOptionPane.YES_OPTION) {
           manger.closeFrame(this);
        }
    }

    public void jTable1_mouseClicked(MouseEvent e) {
        int currow = jTable1.getSelectedRow();

        if (currow >= 0){
            DefaultTableModel tablemodel = null;
            String[] name = {"学生编号", "学生姓名", "考试类别", "考试科目", "考试成绩", "考试时间"};
            tablemodel = new DefaultTableModel(name, 0);

            String sqlStr = null;
            java.util.Collection collection = null;
            Object[] object = null;

            sqlStr = "SELECT * FROM tb_gradeinfo_sub where stuid = '" +
                     jTable1.getValueAt(currow,0) + "' and kindID = '" +
                     examkindid[jComboBox1.getSelectedIndex()] + "'";
            RetrieveObject retrieve = new RetrieveObject();
            collection = retrieve.getTableCollection(sqlStr);
            object = collection.toArray();
            int findindex = 0 ;
            for (int i = 0; i < object.length; i++) {
                java.util.Vector vrow = new java.util.Vector();
                java.util.Vector vdata = (java.util.Vector)object[i];

                String sujcode = String.valueOf(vdata.get(3));
                    for(int aa = 0 ; aa < this.subjectcode.length ; aa++){
//                        System.out.println(sujcode +  ";" +  subjectcode[aa]);
                        if (sujcode.equals(subjectcode[aa])){
                            findindex = aa;
                            System.out.println("findindex = " + findindex);
                        }
                    }

                if (i == 0){

                    vrow.addElement(vdata.get(0));
                    vrow.addElement(vdata.get(1));
                    vrow.addElement(examkindname[Integer.parseInt(String.
                            valueOf(vdata.get(2))) - 1]);

                    vrow.addElement(subjectname[findindex]);
                    vrow.addElement(vdata.get(4));

                    String ksrq = String.valueOf(vdata.get(5));

                    ksrq = ksrq.substring(0, 10);
                    System.out.println(ksrq);
                    vrow.addElement(ksrq);

                }else{
                    vrow.addElement("");
                    vrow.addElement("");
                    vrow.addElement("");
                   /* vrow.addElement(subjectname[Integer.parseInt(String.valueOf(
                            vdata.get(3))) - 1]);*/
                   vrow.addElement(subjectname[findindex]);
                    vrow.addElement(vdata.get(4));

                    String ksrq = String.valueOf(vdata.get(5));

                    ksrq = ksrq.substring(0, 10);
                    System.out.println(ksrq);
                    vrow.addElement(ksrq);

                }

                tablemodel.addRow(vrow);
            }
            this.jTable2.setModel(tablemodel);
            this.jTable2.setRowHeight(22);
        }
    }

    public void jBdel_actionPerformed(ActionEvent e) {
        int rcount = jTable2.getRowCount();
        if (rcount > 0){
            int result = JOptionPane.showOptionDialog(null,
                    "是否删除学生【" + jTable2.getValueAt(0, 1) + "】的考试成绩数据?", "系统提示",
                    JOptionPane.YES_NO_OPTION, JOptionPane.QUESTION_MESSAGE,
                    null, new String[] {"是", "否"}, "否");
            if (result == JOptionPane.NO_OPTION)
                return;



            appstu.util.JdbcAdapter jdbcAdapter = new appstu.util.JdbcAdapter();
            Obj_gradeinfo_sub[] object = new Obj_gradeinfo_sub[rcount];
            for (int i = 0; i < rcount; i++) {
                object[i] = new Obj_gradeinfo_sub();
                object[i].setStuid(String.valueOf(jTable2.getValueAt(0, 0)));
                object[i].setKindID(examkindid[jComboBox1.getSelectedIndex()]);
                //object[i].setCode("0" + (i + 1));
                object[i].setCode(subjectcode[i]);
                object[i].setSutname(String.valueOf(jTable2.getValueAt(i, 1)));
                float grade;
                grade = Float.parseFloat(String.valueOf(jTable2.getValueAt(i, 4)));
                object[i].setGrade(grade);
                java.sql.Date rq = null;
                try {
                    System.out.println(jTable2.getValueAt(i,5));
                    String strrq = String.valueOf(jTable2.getValueAt(i,5));
                    System.out.println(i + ";strrq = " + strrq + "strrq.length = " + strrq.length());
                    rq = java.sql.Date.valueOf(strrq);

                } catch (Exception dt) {
                    JOptionPane.showMessageDialog(null,
                                                  "第【" + i + "】行输入的数据格式有误,请重新录入!!\n" +
                                                  dt.getMessage(), "系统提示",
                                                  JOptionPane.ERROR_MESSAGE);
                    return;
                }
                object[i].setExamdate(rq);
            }
            //执行公共类中的数据删除操作
            if (jdbcAdapter.Delete_Obj_gradeinfo_sub(object)){
               /* MouseEvent event = new MouseEvent()
                jTable1_mouseClicked(event);*/
            }
        }

    }
}


class JF_view_gradesub_jBdel_actionAdapter implements ActionListener {
    private JF_view_gradesub adaptee;
    JF_view_gradesub_jBdel_actionAdapter(JF_view_gradesub adaptee) {
        this.adaptee = adaptee;
    }

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


class JF_view_gradesub_jTable1_mouseAdapter extends MouseAdapter {
    private JF_view_gradesub adaptee;
    JF_view_gradesub_jTable1_mouseAdapter(JF_view_gradesub adaptee) {
        this.adaptee = adaptee;
    }

    public void mouseClicked(MouseEvent e) {
        adaptee.jTable1_mouseClicked(e);
    }
}


class JF_view_gradesub_jBexit_actionAdapter implements ActionListener {
    private JF_view_gradesub adaptee;
    JF_view_gradesub_jBexit_actionAdapter(JF_view_gradesub adaptee) {
        this.adaptee = adaptee;
    }

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


class JF_view_gradesub_jBsave_actionAdapter implements ActionListener {
    private JF_view_gradesub adaptee;
    JF_view_gradesub_jBsave_actionAdapter(JF_view_gradesub adaptee) {
        this.adaptee = adaptee;
    }

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


class JF_view_gradesub_jBadd_actionAdapter implements ActionListener {
    private JF_view_gradesub adaptee;
    JF_view_gradesub_jBadd_actionAdapter(JF_view_gradesub adaptee) {
        this.adaptee = adaptee;
    }

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


class JF_view_gradesub_jComboBox2_itemAdapter implements ItemListener {
    private JF_view_gradesub adaptee;
    JF_view_gradesub_jComboBox2_itemAdapter(JF_view_gradesub adaptee) {
        this.adaptee = adaptee;
    }

    public void itemStateChanged(ItemEvent e) {
        adaptee.jComboBox2_itemStateChanged(e);
    }
}