String class_no;
            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())System.out.println("can't find clname");
                class_no=rs.getString("class_no").trim();
            }
            String sname=jTextField_name.getText().trim();
            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();
            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){
                dorm_no="";
            }else{
                dorm_no=((String)jComboBox_Build_no.getSelectedItem()).trim()+((String)jComboBox_apartment_no.getSelectedItem()).trim();
            }String insertsql="insert into student(stu_no,sname,nation,sex,polity,dorm_no,source,class_no,score,home_phone,address) values('"+stu_no+"','"+sname+"','"+nation+"','"+sex+"','"+polity+"','"+dorm_no+"','"+source+"','"+class_no+"',"+score+",'"+home_phone+"','"+address+"')";
            return SQLRunner.executSql(insertsql);
        }catch(Exception e){
            JOptionPane.showMessageDialog(null,e.toString(),"新建提示",JOptionPane.ERROR_MESSAGE);
            return false;
        }

    }

    public void setAllNew() {//父類按鈕響應
        try {
            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) {
        }

    }

    public void setAllInfo(String keyValue) {//對外借口
        updateModel=true;
        this.keyValue=keyValue;
        try {
            //rs.next();
            ResultSet rs=SQLRunner.getResult("select * from studentinfo where stu_no='"+keyValue+"'");
            rs.next();
            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");
            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"));
            jFormattedTextField_birthday.setText(rs.getString("birthday"));
            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 * 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 * 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 * 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 * 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 MyStudentInfoPanel adaptee;
    MyStudentInfoPanel_jComboBox_Build_no_actionAdapter(MyStudentInfoPanel
            adaptee) {
        this.adaptee = adaptee;
    }

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


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

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


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

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