assertselpanel.java

固定资产管理

        //判断是否填写资产编号或者资产名称
        if (assertid.equals("") && assertname.equals("")) {
            JOptionPane.showMessageDialog(this, "请填写资产编号或者资产名称");
            return;
        }
        //判断资产编号是否为数字
        for (int i = 0; i < assertid.length(); i++) {
            char si = assertid.charAt(i);
            if (!Character.isDigit(si)) {
                JOptionPane.showMessageDialog(this, "资产编号必须为数字");
                return;
            }
        }
        //系统默认按资产编号查询
        if (!assertid.equals("") && !assertname.equals("")) {
            JOptionPane.showMessageDialog(this, "系统默认按资产编号查询");
            String sql1 = "select * from asset where assetid = '" + assertid +
                          "'";

            ArrayList arr1 = new ArrayList();
            ArrayList arr2 = new ArrayList();
            ArrayList arr3 = new ArrayList();
            arr1 = db.chaxun(sql1, 10);

            if (arr1.size() < 1) {
                JOptionPane.showMessageDialog(this, "未查到指定资产编号信息");
            } else {
//---------------------asset表------------------------------------
                txtAssertId1.setText(assertid); // "资产编号"
                txtAssertName1.setText(arr1.get(1).toString()); //"资产名称"
                txtMainId.setText(arr1.get(2).toString()); // "主类编号"
                txtSortId.setText(arr1.get(3).toString()); //"子类编号"
                txtType.setText(arr1.get(4).toString()); // "样    式"
                txtPrice.setText(arr1.get(5).toString()); //价  格
                txtBuyDate.setText(arr1.get(6).toString()); // "购入日期"
                txtStatus.setText(arr1.get(7).toString()); //状   态
                if(arr1.get(9)==null){
                     txtRemark.setText("");
                 }else{
                       txtRemark.setText(arr1.get(9).toString()); //"备      注"
                 }

//-----------------------Lend-----------------------------------------
                String sql2 = "select * from lend where assetid = '" + assertid +
                              "'";
                arr2 = db.chaxun(sql2, 8);
                if (arr2.size() < 1) {
                    txtLandDate.setText(""); //借用日期
                    txtReturnDate.setText(""); // 归还日期
                    txtReturnYorN.setText(""); //是否归还
                    txtBuyer.setText(""); // "购   入  人"

                } else {
                    txtLandDate.setText(arr2.get(3).toString()); //借用日期
                    txtReturnDate.setText(arr2.get(4).toString()); // 归还日期
                    txtReturnYorN.setText(arr2.get(5).toString()); //是否归还
                    txtBuyer.setText(arr2.get(6).toString()); // "购   入  人"
                    String empon = arr2.get(2).toString();
                    String sql3 = "select ename from employee where empno = '" +
                                  empon + "'";
                    arr3 = db.chaxun(sql3, 1);
//----------------------employee表 ----------------------------------
                    txtLendMan.setText(arr3.get(0).toString()); //借  用  人

                }

            }
        }
        //按资产编号查询
        if (!assertid.equals("") && assertname.equals("")) {
            String sql1 = "select * from asset where assetid = '" + assertid +
                          "'";

            ArrayList arr1 = new ArrayList();
            ArrayList arr2 = new ArrayList();
            ArrayList arr3 = new ArrayList();
            arr1 = db.chaxun(sql1, 10);

            if (arr1.size() < 1) {
                JOptionPane.showMessageDialog(this, "未查到指定资产编号信息");
            } else {
//---------------------asset表------------------------------------
                txtAssertId1.setText(assertid); // "资产编号"
                txtAssertName1.setText(arr1.get(1).toString()); //"资产名称"
                txtMainId.setText(arr1.get(2).toString()); // "主类编号"
                txtSortId.setText(arr1.get(3).toString()); //"子类编号"
                txtType.setText(arr1.get(4).toString()); // "样    式"
                txtPrice.setText(arr1.get(5).toString()); //价  格
                txtBuyDate.setText(arr1.get(6).toString()); // "购入日期"
                txtStatus.setText(arr1.get(7).toString()); //状   态
                if(arr1.get(9)==null){
                    txtRemark.setText("");
                }else{
                      txtRemark.setText(arr1.get(9).toString()); //"备      注"
                }

//-----------------------Lend-----------------------------------------
                String sql2 = "select * from lend where assetid = '" + assertid +
                              "'";
                arr2 = db.chaxun(sql2, 8);
                if (arr2.size() < 1) {
                    txtLandDate.setText(""); //借用日期
                    txtReturnDate.setText(""); // 归还日期
                    txtReturnYorN.setText(""); //是否归还
                    txtBuyer.setText(""); // "购   入  人"

                } else {
                    txtLandDate.setText(arr2.get(3).toString()); //借用日期
                    txtReturnDate.setText(arr2.get(4).toString()); // 归还日期
                    txtReturnYorN.setText(arr2.get(5).toString()); //是否归还
                    txtBuyer.setText(arr2.get(6).toString()); // "购   入  人"
                    String empon = arr2.get(2).toString();
                    String sql3 = "select ename from employee where empno = '" +
                                  empon + "'";
                    arr3 = db.chaxun(sql3, 1);
//----------------------employee表 ----------------------------------
                    txtLendMan.setText(arr3.get(0).toString()); //借  用  人

                }

            }

        }
        //按资产名称查询
        if (assertid.equals("") && !assertname.equals("")) {
            String sql = "select assetid from asset where asset_name = '" +
                         assertname + "'";
            ArrayList assetid = db.chaxun(sql, 1);

            String sql1 = "select * from asset where assetid = '" +
                          assetid.get(0).toString() +
                          "'";

            ArrayList arr1 = new ArrayList();
            ArrayList arr2 = new ArrayList();
            ArrayList arr3 = new ArrayList();
            arr1 = db.chaxun(sql1, 10);

            if (arr1.size() < 1) {
                JOptionPane.showMessageDialog(this, "未查到指定资产名称信息");
            } else {
//---------------------asset表------------------------------------
                txtAssertId1.setText(assetid.get(0).toString()); // "资产编号"
                txtAssertName1.setText(assertname); //"资产名称"
                txtMainId.setText(arr1.get(2).toString()); // "主类编号"
                txtSortId.setText(arr1.get(3).toString()); //"子类编号"
                txtType.setText(arr1.get(4).toString()); // "样    式"
                txtPrice.setText(arr1.get(5).toString()); //价  格
                txtBuyDate.setText(arr1.get(6).toString()); // "购入日期"
                txtStatus.setText(arr1.get(7).toString()); //状   态
                if(arr1.get(9)==null){
                        txtRemark.setText("");
                    }else{
                          txtRemark.setText(arr1.get(9).toString()); //"备      注"
                    }

//-----------------------Lend-----------------------------------------
                String sql2 = "select * from lend where assetid = '" +
                                                assetid.get(0).toString() +
                                                "'";
                    arr2 = db.chaxun(sql2, 8);

                if (arr2.size() < 1) {
                    txtLandDate.setText(""); //借用日期
                    txtReturnDate.setText(""); // 归还日期
                    txtReturnYorN.setText(""); //是否归还
                    txtBuyer.setText(""); // "购   入  人"

                } else {


                    txtLandDate.setText(arr2.get(3).toString()); //借用日期
                    txtReturnDate.setText(arr2.get(4).toString()); // 归还日期
                    txtReturnYorN.setText(arr2.get(5).toString()); //是否归还
                    txtBuyer.setText(arr2.get(6).toString()); // "购   入  人"
//----------------------employee表 ----------------------------------
                    String empon = arr2.get(2).toString();
                    String sql3 = "select ename from employee where empno = '" +
                                  empon + "'";
                    arr3 = db.chaxun(sql3, 1);
                    txtLendMan.setText(arr3.get(0).toString()); //借  用  人
                }
            }
        }
    }
}


class AssertSelPanel_btnSel_actionAdapter implements ActionListener {
    private AssertSelPanel adaptee;
    AssertSelPanel_btnSel_actionAdapter(AssertSelPanel adaptee) {
        this.adaptee = adaptee;
    }

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