studentinfopanel.java

使用JBuilder基于Oracle数据库的课程作业

            if(jComboBox_class.getSelectedItem()==null){
                class_no="";
            }else{
                String clname=(String)(jComboBox_class.getSelectedItem());
                ResultSet rs=SQLRunner.getResult("select * from class where clname='"+clname+"'");
                if(!rs.next())return false;
                class_no=rs.getString("class_no").trim();
            }
            String sname=jTextField_name.getText().trim();
            if(sname.equals("")){
                JOptionPane.showMessageDialog(null,"姓名不能为空","系统提示",JOptionPane.ERROR_MESSAGE);
                return false;
            }
            String stu_no=jTextField_stu_no.getText().trim();
            String home_phone=jTextField_home_phone.getText().trim();
            String address=jTextField_address.getText().trim();
            String score=jTextField_score.getText().trim();
            String birthday=jFormattedTextField_birthday.getText().trim();
            if(score.equals(""))score="null";
            String nation;
            if(jComboBox_nation.getSelectedItem()==null){
                nation="";
            }else{
                nation=((String)jComboBox_nation.getSelectedItem()).trim();
            }String Build_no;
            if(jComboBox_Build_no.getSelectedItem()==null){
                Build_no="";
            }else{
                Build_no=((String)jComboBox_Build_no.getSelectedItem()).trim();
            }String sex;
            if(jComboBox_sex.getSelectedItem()==null){
                sex="";
            }else{
                sex=((String)jComboBox_sex.getSelectedItem()).trim();
            }String polity;
            if(jComboBox_polity.getSelectedItem()==null){
                polity="";
            }else{
                polity=((String)jComboBox_polity.getSelectedItem()).trim();
            }String source;
            if(jComboBox_source.getSelectedItem()==null){
                source="";
            }else{
                source=((String)jComboBox_source.getSelectedItem()).trim();
            }String dorm_no;
            if(jComboBox_Build_no.getSelectedItem()==null||jComboBox_apartment_no.getSelectedItem()==null){
                JOptionPane.showMessageDialog(null,"宿舍不能为空","系统提示",JOptionPane.ERROR_MESSAGE);
                return false;
            }else{
                dorm_no=((String)jComboBox_Build_no.getSelectedItem()).trim()+((String)jComboBox_apartment_no.getSelectedItem()).trim();
            }
            ResultSet room=SQLRunner.getResult("select * from dormitory where dorm_no='"+dorm_no+"'");
            if(!room.next())return false;
            if(!sex.equals(room.getString("sex"))){
                JOptionPane.showMessageDialog(null,"性别与宿舍不匹配","系统提示",JOptionPane.ERROR_MESSAGE);
                return false;
            }
            String livein=room.getString("livein").trim();
            if(Integer.parseInt(livein)>=Integer.parseInt(room.getString("capacity").trim())){
                JOptionPane.showMessageDialog(null,"宿舍已满","系统提示",JOptionPane.ERROR_MESSAGE);
                return false;
            }
            Date d=new Date();
            jFormattedTextField_birthday.setValue(d);
            String createdate=jFormattedTextField_birthday.getText().trim();
            jFormattedTextField_birthday.setText(birthday);
            String insertsql="insert into student(stu_no,sname,nation,sex,polity,dorm_no,source,class_no,score,home_phone,address,birthday,createdate) values('"+stu_no+"','"+sname+"','"+nation+"','"+sex+"','"+polity+"','"+dorm_no+"','"+source+"','"+class_no+"',"+score+",'"+home_phone+"','"+address+"',to_date('"+birthday+"','yyyy-mm-dd'"+"),to_date('"+createdate+"','yyyy-mm-dd'"+"))";
            return SQLRunner.executSql(insertsql);
        }catch(Exception e){
            JOptionPane.showMessageDialog(null,e.toString(),"新建提示",JOptionPane.ERROR_MESSAGE);
            return false;
        }

    }

    public void setAllNew() {//父类按钮响应
        try {
            jButton_remove.setVisible(false);
            addItemFromDic(jComboBox_sex,"sex");
            addItemFromDic(jComboBox_source,"source");
            addItemFromDic(jComboBox_polity,"polity");
            addItemFromDic(jComboBox_nation,"nation");
            addItem(jComboBox_college,"select * from college","coname");
            addItemFromBld(jComboBox_Build_no);
            jComboBox_nation.setSelectedItem(null);
            jComboBox_sex.setSelectedItem(null);
            jComboBox_source.setSelectedItem(null);
            jComboBox_polity.setSelectedItem(null);
            jTextField_home_phone.setText("");
            //jTextField_name.setText("");
            jTextField_name.setText("");
            jTextField_stu_no.setText("");
            //jTextField_stu_no.setText("");
            jFormattedTextField_birthday.setText("");
            jTextField_score.setText("");
            jTextField_address.setText("");
            jComboBox_class.setSelectedItem(null);
            jComboBox_department.setSelectedItem(null);
            jComboBox_Build_no.setSelectedItem(null);
            jComboBox_apartment_no.setSelectedItem(null);
            jComboBox_college.setSelectedItem(null);
        } catch (SQLException ex) {
            JOptionPane.showMessageDialog(null,ex.toString(),"系统提示",JOptionPane.ERROR_MESSAGE);
        }

    }

    public void setAllInfo(String keyValue) {//对外借口
        updateModel=true;//
        this.keyValue=keyValue;//
        jButton_remove.setVisible(enable);
        try {
            ResultSet rs=SQLRunner.getResult("select * from studentinfo where stu_no='"+keyValue+"'");
            if(!rs.next())return;
            addItemFromDic(jComboBox_sex,"sex");//从字典加
            jComboBox_sex.setSelectedItem(rs.getString("sex"));
            addItemFromDic(jComboBox_source,"source");
            jComboBox_source.setSelectedItem(rs.getString("source"));
            addItemFromDic(jComboBox_polity,"polity");
            jComboBox_polity.setSelectedItem(rs.getString("polity"));
            addItemFromDic(jComboBox_nation,"nation");
            jComboBox_nation.setSelectedItem(rs.getString("nation"));
            addItem(jComboBox_college,"select * from college","coname");//addItem示例，从制定表
            jComboBox_college.setSelectedItem(rs.getString("coname"));//
            addItemFromDpt(jComboBox_department,jComboBox_college);
            jComboBox_department.setSelectedItem(rs.getString("dpname"));
            addItemFromCls(jComboBox_class,jComboBox_department);
            jComboBox_class.setSelectedItem(rs.getString("clname"));
            addItemFromBld(jComboBox_Build_no);
            jComboBox_Build_no.setSelectedItem(rs.getString("Build_no"));
            addItemFromRom(jComboBox_apartment_no,jComboBox_Build_no);
            jComboBox_apartment_no.setSelectedItem(rs.getString("apartment_no"));
            jTextField_home_phone.setText(rs.getString("home_phone"));
            jTextField_stu_no.setText(rs.getString("stu_no"));
            jTextField_name.setText(rs.getString("sname"));
            String birthday=rs.getString("birthday");
            Date d;
            if(birthday!=null){
                d=new Date(Date.parse(birthday));
                jFormattedTextField_birthday.setValue(d);
            }
            jTextField_score.setText(rs.getString("score"));
            jTextField_address.setText(rs.getString("address"));

        } catch (SQLException ex) {
            System.out.print(ex.toString());
        }

    }
    void addItemFromDpt(JComboBox jcb,JComboBox p) throws SQLException {
       jcb.removeAllItems();
       String colname=new String();
       if(p.getItemCount()==0){
           return;
       }else{
           colname=(String)p.getSelectedItem();
           ResultSet rdepartment=SQLRunner.getResult("select distinct * from department,college where department.college_no=college.college_no and coname='"+colname+"'");
           while(rdepartment.next()){jcb.addItem(rdepartment.getString("dpname"));}
       }
   }
   void addItemFromCls(JComboBox jcb,JComboBox p) throws SQLException {
       jcb.removeAllItems();
       String dptname=new String();
       if(p.getItemCount()==0){
           return;
       }else{
           dptname=(String)p.getSelectedItem();
           ResultSet rdepartment=SQLRunner.getResult("select distinct * from department,class where department.depart_no=class.depart_no and dpname='"+dptname+"'");
           while(rdepartment.next()){jcb.addItem(rdepartment.getString("clname"));}
       }
   }
   void addItemFromBld(JComboBox jcb) throws SQLException {
       jcb.removeAllItems();
       ResultSet rbuilding=SQLRunner.getResult("select distinct BUILD_NO from DORMITORY");
       while(rbuilding.next()){jcb.addItem(rbuilding.getString("BUILD_NO"));}
   }
   void addItemFromRom(JComboBox jcb,JComboBox p) throws SQLException {
       jcb.removeAllItems();
       String bno=new String();
       if(p.getItemCount()==0){
           return;
       }else{
           bno=(String)p.getSelectedItem();
           ResultSet rroom=SQLRunner.getResult("select distinct * from DORMITORY where build_no='"+bno+"'");
           while(rroom.next()){jcb.addItem(rroom.getString("apartment_no"));}
       }
   }

    public void jComboBox_college_actionPerformed(ActionEvent e) {
        try {
            addItemFromDpt(jComboBox_department, jComboBox_college);
        } catch (SQLException ex) {
        }
    }

    public void jComboBox_department_actionPerformed(ActionEvent e) {
        try {
            addItemFromCls(jComboBox_class, jComboBox_department);
        } catch (SQLException ex) {
        }
    }

    public void jComboBox_Build_no_actionPerformed(ActionEvent e) {
        try {
            addItemFromRom(jComboBox_apartment_no, jComboBox_Build_no);
        } catch (SQLException ex) {
        }
    }


}


class MyStudentInfoPanel_jComboBox_Build_no_actionAdapter implements
        ActionListener {
    private StudentInfoPanel adaptee;
    MyStudentInfoPanel_jComboBox_Build_no_actionAdapter(StudentInfoPanel
            adaptee) {
        this.adaptee = adaptee;
    }

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


class MyStudentInfoPanel_jComboBox_department_actionAdapter implements
        ActionListener {
    private StudentInfoPanel adaptee;
    MyStudentInfoPanel_jComboBox_department_actionAdapter(StudentInfoPanel
            adaptee) {
        this.adaptee = adaptee;
    }

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


class MyStudentInfoPanel_jComboBox_college_actionAdapter implements
        ActionListener {
    private StudentInfoPanel adaptee;
    MyStudentInfoPanel_jComboBox_college_actionAdapter(StudentInfoPanel
            adaptee) {
        this.adaptee = adaptee;
    }

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