wuyebody.java

基于UML的小区物业管理系统设计:1.对小区所有房屋资料的录入和增

                          fanghao.addItem(rst.getString("FANGHAO"));

                      rst.close();
                      stat.close();
                      lianjie.close();
            }catch(Exception ee){}
        }
        nian.addItem("2005");
        nian.addItem("2006");
        nian.addItem("2007");
        nian.addItem("2008");

        yue.addItem("1");
        yue.addItem("2");
        yue.addItem("3");
        yue.addItem("4");
        yue.addItem("5");
        yue.addItem("6");
        yue.addItem("7");
        yue.addItem("8");
        yue.addItem("9");
        yue.addItem("10");
        yue.addItem("11");
        yue.addItem("12");

        qianshui.setText("0");
        qiandian.setText("0");
        qianwuye.setText("0");

    }

    public void jButton1_actionPerformed(ActionEvent e) {
this.dispose();
        new feiguan();
    }

    public void yue_actionPerformed(ActionEvent e) {
        DBConnection lianjie = new DBConnection();
        Statement stat=lianjie.stat;
        try{
            ResultSet rst=stat.executeQuery("select * from QIANFEI where FANGHAO='"+
                          fanghao.getSelectedItem()+"'and NIANFEN='"+
        nian.getSelectedItem()+"'and YUEFEN='"+
                          yue.getSelectedItem()+"'");
        if(!rst.next())
        {
            qianshui.setText("0");
            qiandian.setText("0");
            qianwuye.setText("0");

        }
            do
            {   yezhu.setText(rst.getString("YEZHU"));
                qianshui.setText(String.valueOf(rst.getDouble("QIANSHUI")));
                qiandian.setText(String.valueOf(rst.getDouble("QIANDIAN")));
                qianwuye.setText(String.valueOf(rst.getDouble("QIANWU")));
            }while(rst.next());
            rst.close();
            stat.close();
            lianjie.close();
        }catch(Exception ee){

        }
    }

    public void jiaoshui_actionPerformed(ActionEvent e) {
    qianshui.setText("0");
    shui=true;
    }

    public void jiaodian_actionPerformed(ActionEvent e) {
qiandian.setText("0");
        dian=true;
    }

    public void jiaowuye_actionPerformed(ActionEvent e) {
qianwuye.setText("0");
        wu=true;
    }

    public void jButton2_actionPerformed(ActionEvent e) {
        DBConnection lianjie = new DBConnection();

        if (dian) {
            try {
              Statement stat = lianjie.stat;
              stat.execute("update QIANFEI set QIANDIAN=0 where FANGHAO='"+
                      fanghao.getSelectedItem()+"' and NIANFEN='"+
                 nian.getSelectedItem()+"'and YUEFEN='"+
            yue.getSelectedItem()+"'");
              JOptionPane.showMessageDialog(this,"交电费成功");
            } catch (Exception ee) {}
        }
        if(shui)
        {
            try {
              Statement stat = lianjie.stat;
              stat.execute("update QIANFEI set QIANSHUI=0 where FANGHAO='"+
                      fanghao.getSelectedItem()+"' and NIANFEN='"+
                 nian.getSelectedItem()+"'and YUEFEN='"+
            yue.getSelectedItem()+"'");
              JOptionPane.showMessageDialog(this,"交水费成功");
            } catch (Exception ee) {}

        }
        if(wu)
        {
            try {
              Statement stat = lianjie.stat;
              stat.execute("update QIANFEI set QIANWU=0 where FANGHAO='"+
                      fanghao.getSelectedItem()+"' and NIANFEN='"+
                 nian.getSelectedItem()+"'and YUEFEN='"+
            yue.getSelectedItem()+"'");
              JOptionPane.showMessageDialog(this,"交物业费成功");
            } catch (Exception ee) {}

        }

       dian=false;
       shui=false;
       wu=false;


       Statement stat1=lianjie.stat;
       try{
           stat1.execute("delete from QIANFEI where QIANDIAN=0 AND QIANSHUI=0 AND QIANWU=0");
       }catch(Exception eee){}

    }
}


class wuyebody_jButton1_actionAdapter implements ActionListener {
    private wuyebody adaptee;
    wuyebody_jButton1_actionAdapter(wuyebody adaptee) {
        this.adaptee = adaptee;
    }

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


class wuyebody_jButton2_actionAdapter implements ActionListener {
    private wuyebody adaptee;
    wuyebody_jButton2_actionAdapter(wuyebody adaptee) {
        this.adaptee = adaptee;
    }

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


class wuyebody_jiaowuye_actionAdapter implements ActionListener {
    private wuyebody adaptee;
    wuyebody_jiaowuye_actionAdapter(wuyebody adaptee) {
        this.adaptee = adaptee;
    }

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


class wuyebody_jiaodian_actionAdapter implements ActionListener {
    private wuyebody adaptee;
    wuyebody_jiaodian_actionAdapter(wuyebody adaptee) {
        this.adaptee = adaptee;
    }

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


class wuyebody_jiaoshui_actionAdapter implements ActionListener {
    private wuyebody adaptee;
    wuyebody_jiaoshui_actionAdapter(wuyebody adaptee) {
        this.adaptee = adaptee;
    }

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


class wuyebody_yue_actionAdapter implements ActionListener {
    private wuyebody adaptee;
    wuyebody_yue_actionAdapter(wuyebody adaptee) {
        this.adaptee = adaptee;
    }

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