frmasset.java~170~

用java实现的固定资产管理系统相信对于初学者可以从中学到一点知识....!

                    }
                    jTable1.setModel(cdb.getAstinfo());
                }
            } else
                JOptionPane.showMessageDialog(this, "没有选中固定资产表中的任何一项", "错误",
                                              JOptionPane.ERROR_MESSAGE);
    }

    public void btnrenew_actionPerformed(ActionEvent e) {
        if (txtastid.getText().equals("") || txtastname.getText().equals("") ||
            txtprice.getText().equals("") || txtdate.getText().equals("") ||
            txtuseby.getText().equals("")) {
            JOptionPane.showMessageDialog(this, "输入的固定资产信息不完整", "错误",
                                          JOptionPane.ERROR_MESSAGE);
        } else if (Float.valueOf(txtprice.getText()).floatValue() < 2000) {
            JOptionPane.showMessageDialog(this, "输入的固定资产价格要不少于2000", "错误",
                                          JOptionPane.ERROR_MESSAGE);
        } else {
            int flag = JOptionPane.showConfirmDialog(this, "确定真的要把当前的资产信息更新吗？",
                    "更新信息", 0);
            if (flag == 0) {
                cdb.astrenew(txtastid.getText(), txtastname.getText(),
                             String.valueOf(combcateid.getSelectedItem()),
                             String.valueOf(combsubcateid.getSelectedItem()),
                             txtmodel.getText(), Float.valueOf(txtprice.getText()),
                             txtdate.getText(),
                             String.valueOf(combstatus.getSelectedItem()),
                             txtuseby.getText(), txtremarks.getText());
                jTable1.setModel(cdb.getAstinfo());
            }
        }
    }


    public void jTable1_mousePressed(MouseEvent e) {
        int r = jTable1.getSelectedRow();
        txtastid.setText(String.valueOf(jTable1.getValueAt(r,0)));
        txtastname.setText(String.valueOf(jTable1.getValueAt(r,1)));
        combcateid.setSelectedItem(String.valueOf(jTable1.getValueAt(r,2)));
        combsubcateid.setSelectedItem(String.valueOf(jTable1.getValueAt(r,3)));
        txtmodel.setText(String.valueOf(jTable1.getValueAt(r,4)));
        txtprice.setText(String.valueOf(jTable1.getValueAt(r,5)));
        txtdate.setText(String.valueOf(jTable1.getValueAt(r,6)));
        combstatus.setSelectedItem(String.valueOf(jTable1.getValueAt(r,7)));
        txtuseby.setText(String.valueOf(jTable1.getValueAt(r,8)));
        txtremarks.setText(String.valueOf(jTable1.getValueAt(r,9)));
    }

    public void combcateid_itemStateChanged(ItemEvent e) {
        combsubcateid.removeAllItems();
        for (int i = 0;i<cdb.getsubcateid(String.valueOf(combcateid.getSelectedItem())).size();
                     i++) {
            combsubcateid.addItem(String.valueOf(cdb.getsubcateid(String.valueOf(combcateid.getSelectedItem())).get(i)));
        }
    }

    public void jTable1_keyPressed(KeyEvent e) {
        if(e.getKeyCode()==e.VK_DOWN){
            int r = jTable1.getSelectedRow();
            if(r>=jTable1.getRowCount()-1){
                r=jTable1.getRowCount()-2;
            }
            txtastid.setText(String.valueOf(jTable1.getValueAt(r+1,0)));
            txtastname.setText(String.valueOf(jTable1.getValueAt(r+1,1)));
            combcateid.setSelectedItem(String.valueOf(jTable1.getValueAt(r+1,2)));
            combsubcateid.setSelectedItem(String.valueOf(jTable1.getValueAt(r+1,3)));
            txtmodel.setText(String.valueOf(jTable1.getValueAt(r+1,4)));
            txtprice.setText(String.valueOf(jTable1.getValueAt(r+1,5)));
            txtdate.setText(String.valueOf(jTable1.getValueAt(r+1,6)));
            combstatus.setSelectedItem(String.valueOf(jTable1.getValueAt(r+1,7)));
            txtuseby.setText(String.valueOf(jTable1.getValueAt(r+1,8)));
            txtremarks.setText(String.valueOf(jTable1.getValueAt(r+1,9)));
        }
        else if(e.getKeyCode()==e.VK_UP){
            int r = jTable1.getSelectedRow();
            if(r==0){
                r=1;
            }
            txtastid.setText(String.valueOf(jTable1.getValueAt(r-1,0)));
            txtastname.setText(String.valueOf(jTable1.getValueAt(r-1,1)));
            combcateid.setSelectedItem(String.valueOf(jTable1.getValueAt(r-1,2)));
            combsubcateid.setSelectedItem(String.valueOf(jTable1.getValueAt(r-1,3)));
            txtmodel.setText(String.valueOf(jTable1.getValueAt(r-1,4)));
            txtprice.setText(String.valueOf(jTable1.getValueAt(r-1,5)));
            txtdate.setText(String.valueOf(jTable1.getValueAt(r-1,6)));
            combstatus.setSelectedItem(String.valueOf(jTable1.getValueAt(r-1,7)));
            txtuseby.setText(String.valueOf(jTable1.getValueAt(r-1,8)));
            txtremarks.setText(String.valueOf(jTable1.getValueAt(r-1,9)));
       }
       else if(e.getKeyCode()==e.VK_PAGE_DOWN){
           int r = jTable1.getRowCount() - 1;
           txtastid.setText(String.valueOf(jTable1.getValueAt(r,0)));
           txtastname.setText(String.valueOf(jTable1.getValueAt(r,1)));
           combcateid.setSelectedItem(String.valueOf(jTable1.getValueAt(r,2)));
           combsubcateid.setSelectedItem(String.valueOf(jTable1.getValueAt(r,3)));
           txtmodel.setText(String.valueOf(jTable1.getValueAt(r,4)));
           txtprice.setText(String.valueOf(jTable1.getValueAt(r,5)));
           txtdate.setText(String.valueOf(jTable1.getValueAt(r,6)));
           combstatus.setSelectedItem(String.valueOf(jTable1.getValueAt(r,7)));
           txtuseby.setText(String.valueOf(jTable1.getValueAt(r,8)));
           txtremarks.setText(String.valueOf(jTable1.getValueAt(r,9)));
       }
       else if(e.getKeyCode()==e.VK_PAGE_UP){
           txtastid.setText(String.valueOf(jTable1.getValueAt(0,0)));
           txtastname.setText(String.valueOf(jTable1.getValueAt(0,1)));
           combcateid.setSelectedItem(String.valueOf(jTable1.getValueAt(0,2)));
           combsubcateid.setSelectedItem(String.valueOf(jTable1.getValueAt(0,3)));
           txtmodel.setText(String.valueOf(jTable1.getValueAt(0,4)));
           txtprice.setText(String.valueOf(jTable1.getValueAt(0,5)));
           txtdate.setText(String.valueOf(jTable1.getValueAt(0,6)));
           combstatus.setSelectedItem(String.valueOf(jTable1.getValueAt(0,7)));
           txtuseby.setText(String.valueOf(jTable1.getValueAt(0,8)));
           txtremarks.setText(String.valueOf(jTable1.getValueAt(0,9)));
      }
    }

}

class FrmAsset_combcateid_itemAdapter implements ItemListener {
    private FrmAsset adaptee;
    FrmAsset_combcateid_itemAdapter(FrmAsset adaptee) {
        this.adaptee = adaptee;
    }

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


class FrmAsset_jTable1_mouseAdapter extends MouseAdapter {
    private FrmAsset adaptee;
    FrmAsset_jTable1_mouseAdapter(FrmAsset adaptee) {
        this.adaptee = adaptee;
    }

    public void mousePressed(MouseEvent e) {
        adaptee.jTable1_mousePressed(e);
    }
}


class FrmAsset_jTable1_keyAdapter extends KeyAdapter {
    private FrmAsset adaptee;
    FrmAsset_jTable1_keyAdapter(FrmAsset adaptee) {
        this.adaptee = adaptee;
    }

    public void keyPressed(KeyEvent e) {
        adaptee.jTable1_keyPressed(e);
    }
}


class FrmAsset_btnrenew_actionAdapter implements ActionListener {
        private FrmAsset adaptee;
        FrmAsset_btnrenew_actionAdapter(FrmAsset adaptee) {
            this.adaptee = adaptee;
        }

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


    class FrmAsset_btndel_actionAdapter implements ActionListener {
        private FrmAsset adaptee;
        FrmAsset_btndel_actionAdapter(FrmAsset adaptee) {
            this.adaptee = adaptee;
        }

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


    class FrmAsset_btnadd_actionAdapter implements ActionListener {
        private FrmAsset adaptee;
        FrmAsset_btnadd_actionAdapter(FrmAsset adaptee) {
            this.adaptee = adaptee;
        }

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