jf_view_student.java

学生成绩管理系统,包括参数设置：年级设置、班级设置、科目设置、考试类别四项管理功能模块

        appstu.model.Obj_student object = new appstu.model.Obj_student();
        /*String classid = "0" + String.valueOf(jComboBox1.getSelectedIndex() + 1)
                         + "0" + String.valueOf(jComboBox2.getSelectedIndex() + 1);*/
        String classid = classID[Integer.parseInt(String.valueOf(jComboBox2.getSelectedIndex()))];
        object.setStuid(jTextField1.getText().trim());
        object.setClassID(classid);
        object.setStuname(jTextField3.getText().trim());
        int age = 0;
        try{
            age = Integer.parseInt(jTextField4.getText().trim());
        }catch(java.lang.NumberFormatException formate){
            JOptionPane.showMessageDialog(null,"数据录入有误，错误信息:\n" + formate.getMessage(), "系统提示",JOptionPane.ERROR_MESSAGE);
            jTextField4.requestFocus();
            return;
        }

        object.setAge(age);
        object.setSex(String.valueOf(jComboBox3.getSelectedItem()));
        object.setPhone(jTextField5.getText().trim());
        object.setAddress(jTextField6.getText().trim());

        appstu.util.JdbcAdapter adapter = new appstu.util.JdbcAdapter();
        if (adapter.InsertOrUpdateObject(object)){
            ActionEvent event = new ActionEvent(jBrefresh,0,null);
            jBrefresh_actionPerformed(event);
        }
    }

    public void jBrefresh_actionPerformed(ActionEvent e) {
       DefaultTableModel tablemodel = null;
       String[] name = {"学生编号","班级编号","学生姓名","性别","年龄","家庭住址","联系电话"};
       String sqlStr = "select * from tb_studentinfo";
       appstu.util.RetrieveObject bdt = new  appstu.util.RetrieveObject();
       tablemodel = bdt.getTableModel(name,sqlStr);
       jTable1.setModel(tablemodel);
       jTable1.setRowHeight(24);

    }

    public void jBdel_actionPerformed(ActionEvent e) {
         if (jTextField1.getText().trim().length() <= 0) return;

         int result = JOptionPane.showOptionDialog(null,"是否删除学生的基本信息数据?","系统提示",
                                    JOptionPane.YES_NO_OPTION,JOptionPane.QUESTION_MESSAGE,
                                    null,new String[]  {"是","否"},"否");
         if (result == JOptionPane.NO_OPTION)  return;

         String sqlDel = "delete tb_studentinfo where stuid = '" + jTextField1.getText().trim() + "'";
         JdbcAdapter jdbcAdapter = new JdbcAdapter();
         if (jdbcAdapter.DeleteObject(sqlDel)) {
             jTextField1.setText("");
             jTextField2.setText("");
             jTextField3.setText("");
             jTextField4.setText("");
             jTextField5.setText("");
             jTextField6.setText("");
             jComboBox1.removeAllItems();
             jComboBox3.removeAllItems();
             ActionEvent event = new ActionEvent(jBrefresh,0,null);
             jBrefresh_actionPerformed(event);

         }

    }

    public void jTable1_mouseClicked(MouseEvent e) {
        String id = null;
        String sqlStr = null;
        int selectrow = 0;
        selectrow = jTable1.getSelectedRow();
        if (selectrow < 0 ) return;

        id = jTable1.getValueAt(selectrow,0).toString();
        sqlStr = "select * from tb_studentinfo where stuid = '" + id + "'";
        java.util.Vector vdata = null;
        RetrieveObject retrive = new RetrieveObject();
        vdata = retrive.getObjectRow(sqlStr);
        String gradeid = null,classid = null;
        String gradename = null,classname = null;
        java.util.Vector vname = null;
        classid = vdata.get(1).toString();
        gradeid = classid.substring(0,2);
        vname = retrive.getObjectRow("select className from tb_classinfo where classID = '" + classid + "'");
        classname = String.valueOf(vname.get(0));
        vname = retrive.getObjectRow("select gradeName from tb_gradeinfo where gradeID = '" + gradeid + "'");
        gradename = String.valueOf(vname.get(0));

        jTextField1.setText(vdata.get(0).toString());
        jTextField2.setText(gradename + classname);
        jTextField3.setText(vdata.get(2).toString());
        jTextField4.setText(vdata.get(4).toString());
        jTextField5.setText(vdata.get(6).toString());
        jTextField6.setText(vdata.get(5).toString());
        jComboBox3.removeAllItems();
        jComboBox3.addItem(vdata.get(3).toString());

    }

    public void jComboBox1_itemStateChanged(ItemEvent e) {
        jComboBox2.removeAllItems();
        int Index = jComboBox1.getSelectedIndex();
        String sqlStr = null;
        sqlStr  = "select classID,className from tb_classinfo where gradeID = '" + gradeID[Index] + "'";
        RetrieveObject retrieve = new RetrieveObject();
        java.util.Collection collection = null;
        java.util.Iterator iterator = null;
        collection = retrieve.getTableCollection(sqlStr);
        iterator = collection.iterator();
        classID = new String[collection.size()];
        int i = 0;
        while(iterator.hasNext()){
            java.util.Vector vdata = (java.util.Vector)iterator.next();
            classID[i] = String.valueOf(vdata.get(0));
            jComboBox2.addItem(vdata.get(1));
            i ++;
        }
    }

    public void jComboBox2_itemStateChanged(ItemEvent e) {
        if (jComboBox2.getSelectedIndex() < 0) return;

        String cid = classID[jComboBox2.getSelectedIndex()];
        DefaultTableModel tablemodel = null;
        String[] name = {"学生编号", "班级编号", "学生姓名", "性别", "年龄", "家庭住址", "联系电话"};
        String sqlStr = "select * from tb_studentinfo where classid = '" + cid + "'";
        appstu.util.RetrieveObject bdt = new appstu.util.RetrieveObject();
        tablemodel = bdt.getTableModel(name, sqlStr);
        jTable1.setModel(tablemodel);
        jTable1.setRowHeight(24);

    }
}


class JF_view_student_jComboBox2_itemAdapter implements ItemListener {
    private JF_view_student adaptee;
    JF_view_student_jComboBox2_itemAdapter(JF_view_student adaptee) {
        this.adaptee = adaptee;
    }

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


class JF_view_student_jComboBox1_itemAdapter implements ItemListener {
    private JF_view_student adaptee;
    JF_view_student_jComboBox1_itemAdapter(JF_view_student adaptee) {
        this.adaptee = adaptee;
    }

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


class JF_view_student_jTable1_mouseAdapter extends MouseAdapter {
    private JF_view_student adaptee;
    JF_view_student_jTable1_mouseAdapter(JF_view_student adaptee) {
        this.adaptee = adaptee;
    }

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


class JF_view_student_jBdel_actionAdapter implements ActionListener {
    private JF_view_student adaptee;
    JF_view_student_jBdel_actionAdapter(JF_view_student adaptee) {
        this.adaptee = adaptee;
    }

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


class JF_view_student_jBrefresh_actionAdapter implements ActionListener {
    private JF_view_student adaptee;
    JF_view_student_jBrefresh_actionAdapter(JF_view_student adaptee) {
        this.adaptee = adaptee;
    }

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


class JF_view_student_jBexit_actionAdapter implements ActionListener {
    private JF_view_student adaptee;
    JF_view_student_jBexit_actionAdapter(JF_view_student adaptee) {
        this.adaptee = adaptee;
    }

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


class JF_view_student_jBadd_actionAdapter implements ActionListener {
    private JF_view_student adaptee;
    JF_view_student_jBadd_actionAdapter(JF_view_student adaptee) {
        this.adaptee = adaptee;
    }

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


class JF_view_student_jBsave_actionAdapter implements ActionListener {
    private JF_view_student adaptee;
    JF_view_student_jBsave_actionAdapter(JF_view_student adaptee) {
        this.adaptee = adaptee;
    }

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