java JTable：如何避免重复行和聚合项目数量

2 月，3 周 Questions & Answers 501

我是一名软件开发新手，对Java桌面和web应用程序感兴趣。我正在编写一个桌面应用程序，只使用Swing组件，它读取代码，并通过从数据库检索相关字段，将它们写入JTable。我遇到了麻烦，因为程序在我输入代码时添加了一行代码相同的新行，而不是增加已输入代码的quantity列

我希望程序对第一列执行检查，对每一行重复搜索，直到找到代码（如果存在）或到达最后一行。如果是新代码，则必须添加一行，如果是已输入的代码，则实际物料数量必须增加一行。下面是我的解决方案，不起作用，你能帮忙吗？谢谢你的关注

private void cmdFindItemActionPerformed(java.awt.event.ActionEvent evt) {                                                

     try {

         item = Item.findItem(itemTextField.getText(), DeskApp.conn);

         // Definition and initialisation of control variables pertaining "while" cycle
         boolean isCodePresent = false;
         int row = 0;
         double discount = 0.0d;
         double colSum = 0.0d;

         // Discounted price = unit price * qty * (1 - discount)

         while (!isCodePresent && row < defMod.getRowCount()) {

             // Code already present: add quantity

             if (item.getCode() == defMod.getValueAt(row, 0)) {
                 int actualQty = (int)defMod.getValueAt(row, 4);
                 defMod.setValueAt(++actualQty, row, 4);
                 double unitPrice = (double) defMod.getValueAt(row, 3);
                 discount = (double)defMod.getValueAt(row, 5);
                 double totRow = unitPrice * actualQty * (100 - discount) / 100;
                 defMod.setValueAt(totRow, row, 6);
                 double discountedPrice = (double)defMod.getValueAt(row, 3) *
                      (double)defMod.getValueAt(row, 4) *
                              ((100 - (double)defMod.getValueAt(row, 5) / 100));
                 defMod.setValueAt(discountedPrice, row, 6);
                 isCodePresent = true;
             }

             row++;
         }

         // Code not yet present: add row

         if (!isCodePresent) {
             MyButton buttonAdd = new MyButton(MyButton.BEHAVIOUR_ADD, table.getRowCount());
             MyButton buttonRemove = new MyButton(MyButton.BEHAVIOUR_REMOVE, table.getRowCount());
             MyButton buttonDeleteRow = new MyButton(MyButton.BEHAVIOUR_DELETE_ROW, table.getRowCount());

             buttonAdd.setText("+1");
             buttonRemove.setText("-1");
             buttonDeleteRow.setText("Delete row");

             DecimalFormat digitFormat = new DecimalFormat("#.##");

             for (int i = 0; i < defMod.getRowCount(); i++) {
                 colSum += (double) defMod.getValueAt(i, 6);
             }

             double discountedPrice = (double)defMod.getValueAt(row, 3) * 
                  (double)defMod.getValueAt(row, 4) *
                       ((100 - (double)defMod.getValueAt(row, 5) / 100));
             defMod.addRow(new Object[]{item.getCode(), item.getOtherCode(),
                     item.getDescription(), item.getPrice(), 1, discount,
                           item.getPrice(), buttonAdd, buttonRemove, buttonDeleteRow});
         }

Python中文网

有 Java 编程相关的问题?

java JTable：如何避免重复行和聚合项目数量

共 (1) 个答案

# 1 楼答案