billoutframe.java

Jbuilder编写的纱线制衣厂的仓库管理系统（学习java时做的一个系统）源码

              columnName);
              jTable1.setModel(yarnInModel);
          }
          catch (Exception ex)
          {
              ex.printStackTrace();
          }
      }
      //新增明细按钮的动作监听
       public void jButton4_actionPerformed(ActionEvent e)
       {
           ((YarnTableModel)jTable2.getModel()).addTableItem();
       }

       public void jComboBox1_itemStateChanged(ItemEvent e)
          {
              jTextField2.setText(String.valueOf(storageRemain()));
      }

      //查询文本框文本更改的监听方法
     public void jTextField5_ChangedUpdate(DocumentEvent e)
    {
        String[] columnName = {"纱线ID", "色号", "色名", "品种规格", "客户", "客户色号"};
        tableDisplay(lookUpYarn_ID(jTextField5.getText()),columnName);
    }
    //查询文本框文本插入的监听方法
    public void jTextField5_insertUpdate(DocumentEvent e)
    {
        String[] columnName = {"纱线ID", "色号", "色名", "品种规格", "客户", "客户色号"};
        tableDisplay(lookUpYarn_ID(jTextField5.getText()),columnName);
    }
    //查询文本框文本移除的监听方法
    public void jTextField5_removeUpdate(DocumentEvent e)
    {
        String[] columnName = {"纱线ID", "色号", "色名", "品种规格", "客户", "客户色号"};
        tableDisplay(lookUpYarn_ID(jTextField5.getText()),columnName);
    }

    //双击事件监听实现方法
        public void tableDoubleClick(MouseEvent e)
        {
            int rowCount;
            Object[] signalrowData = new Object[8];
            rowCount = jTable1.getSelectedRow();
            signalrowData[1] = jTable1.getValueAt(rowCount,0);
            signalrowData[2] = jTable1.getValueAt(rowCount,1);
            signalrowData[3] = jTable1.getValueAt(rowCount,3);
            signalrowData[5] = false;
            YarnTableModel temp = (YarnTableModel)jTable2.getModel();
            temp.setLastNonFillRow(signalrowData);
      }
      //纱线组合框ID的动作监听方法实线
      public void yarnIDJComboBoxEditor(ActionEvent e)
      {
          if(jTable2.getSelectedRow()>-1)
          {
              try
              {
                  ResultSet rs = jf.executeQuery(
                          "select YColorID,YVariety from Yarn where YID = '" +
                          jTable2.getValueAt(jTable2.getSelectedRow(),1) + "'");
                  if (rs.next())
                  {

                      jTable2.setValueAt(rs.getString(1), jTable2.getSelectedRow(),
                                         2);
                      jTable2.setValueAt(rs.getString(2), jTable2.getSelectedRow(),
                                         3);
                      ((YarnTableModel)jTable2.getModel()).addTableItem();
                  }
                  else
                  {
                      jTable2.setValueAt("", jTable2.getSelectedRow(), 2);
                      jTable2.setValueAt("", jTable2.getSelectedRow(), 3);
                  }

              } catch (Exception ex)
              {
                  ex.printStackTrace();
              }
          }

      }



     //纱线表格的YID组合框的单元改变监听方法实现
    public void yarnIDJComboBoxEditingStopped(ChangeEvent e)
   {
       if(jTable2.getSelectedRow()>-1)
       {
           try
           {
               ResultSet rs = jf.executeQuery(
                       "select YColorID,YVariety from Yarn where YID = '" +
                       jTable2.getValueAt(jTable2.getSelectedRow(),1) + "'");
               if (rs.next())
               {

                   jTable2.setValueAt(rs.getString(1), jTable2.getSelectedRow(),
                                      2);
                   jTable2.setValueAt(rs.getString(2), jTable2.getSelectedRow(),
                                      3);
                   ((YarnTableModel)jTable2.getModel()).addTableItem();

               }
               else
               {
                   jTable2.setValueAt("", jTable2.getSelectedRow(), 2);
                   jTable2.setValueAt("", jTable2.getSelectedRow(), 3);
               }

           } catch (Exception ex)
           {
               ex.printStackTrace();
           }
       }
   }
   public void yarnIDJComboBoxEditingCanceled(ChangeEvent e)
   {

   }
   //明细表的金额和重量编辑框的编辑完成监听方法
   public void yarnMWJTextFieldCellEditingStopped(ChangeEvent e)
   {
       if (e.getSource() == jTable2.getColumnModel().getColumn(6).getCellEditor())
       {
           float sum = tableColumnSum(jTable2,6);
           jTextField7.setText(String.valueOf(sum));
       }
       if (e.getSource() == jTable2.getColumnModel().getColumn(7).getCellEditor())
       {
           float sum = tableColumnSum(jTable2,7);
           jTextField8.setText(String.valueOf(sum));
       }
   }
   //统计表格列总和，参数为表格JTable和列Column的索引
   public float tableColumnSum(JTable table,int columnIndex)
   {
       float sum = 0;
       for (int i = 0; i < table.getRowCount(); i++)
       {
           try
           {
               float t = Float.valueOf(Float.valueOf((String) table.getValueAt(i,
                       columnIndex)));
               sum = sum + t;
           }
           catch (Exception ex)
           {
               sum = sum;
           }
       }
       return sum;
   }



   public void yarnMWJTextFieldCellEditingCanceled(ChangeEvent e)
    {

   }

      public void jButton5_actionPerformed(ActionEvent e) {
          //返回表格选择了的行的索引
                  int[] sRows = jTable2.getSelectedRows();
                  YarnTableModel temp = (YarnTableModel)jTable2.getModel();
                  temp.deleteRows(sRows);
                  //重新计算总金额和总重量，并更新文本框
                  jTextField7.setText(String.valueOf(tableColumnSum(jTable2,6)));
          jTextField8.setText(String.valueOf(tableColumnSum(jTable2,7)));
    }
    //查找最大单号加1并且填进单号的填写栏，即新建单据令单号加1
    public void refurbish()
    {
        try {
                ResultSet rs = st.executeQuery("select BInID from BillIn order by BInID desc");
                rs.next();
                String temp = rs.getString(1); //temp为临时存储单号的变量
                rs.close();
                //对单号加一并显示
                String temp1 = String.valueOf(Integer.valueOf(temp.substring(1))+1);
                int numz = temp.length() - temp1.length();
                char[] temp2 =new char[numz-1];
                for(int i = 0 ; i<numz-1 ; i++)
                {
                    temp2[i] = '0';
                }
                jTextField1.setText(temp.charAt(0)+String.valueOf(temp2)+temp1);
            } catch (Exception ex) {
                ex.printStackTrace();
            }
    }

    public void jButton6_actionPerformed(ActionEvent e) {
        refurbish();
    }

}


class BillOutFrame_jButton6_actionAdapter implements ActionListener {
    private BillOutFrame adaptee;
    BillOutFrame_jButton6_actionAdapter(BillOutFrame adaptee) {
        this.adaptee = adaptee;
    }

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


class BillOutFrame_jButton5_actionAdapter implements ActionListener {
    private BillOutFrame adaptee;
    BillOutFrame_jButton5_actionAdapter(BillOutFrame adaptee) {
        this.adaptee = adaptee;
    }

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


//新增明细按钮动作监听类
class BillOutFrame_jButton4_actionAdapter implements ActionListener {
    private BillOutFrame adaptee;
    BillOutFrame_jButton4_actionAdapter(BillOutFrame adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {

        adaptee.jButton4_actionPerformed(e);
    }
}
//仓库选择框的物品监听类
class BillOutFrame_jComboBox1_itemAdapter implements ItemListener
{
    private BillOutFrame adaptee;
    BillOutFrame_jComboBox1_itemAdapter(BillOutFrame adaptee)
    {
        this.adaptee = adaptee;
    }

    public void itemStateChanged(ItemEvent e)
    {
        adaptee.jComboBox1_itemStateChanged(e);
    }
}
//jTextField3的文档监听器类
class BillOutFrame_jTextField5_DocumentAdapter implements DocumentListener
{
    private BillOutFrame adaptee;
    BillOutFrame_jTextField5_DocumentAdapter(BillOutFrame adaptee)
    {
        this.adaptee = adaptee;
    }
    public void changedUpdate(DocumentEvent e)
    {
        adaptee.jTextField5_ChangedUpdate(e);
    }
    public void insertUpdate(DocumentEvent e)
    {
        adaptee.jTextField5_insertUpdate(e);
    }
    public void removeUpdate(DocumentEvent e)
    {
        adaptee.jTextField5_removeUpdate(e);
    }
}
//表格选择模式的双击监听类
class BillOutFrame_tableDoubleClick_MouseListener implements MouseListener
{
    private BillOutFrame adaptee;
    BillOutFrame_tableDoubleClick_MouseListener(BillOutFrame adaptee)
    {
        this.adaptee = adaptee;
    }
    public void mouseClicked(MouseEvent e)
   {

   }
   public void mouseEntered(MouseEvent e)
   {

   }
   public void mouseExited(MouseEvent e)
   {

   }
   public void mousePressed(MouseEvent e)
   {

   }
   //但鼠标两次点击完成是计算时间差以判断是否双击事件
   public void mouseReleased(MouseEvent e)
   {
       if (doubleClick())//双击的判断
       {
          adaptee.tableDoubleClick(e);
       }
   }
   long clickTime = 0;
   public boolean doubleClick()
    {
       long nowTime = (new Date()).getTime();

       if ( (nowTime - clickTime) < 300) {
           clickTime = nowTime;
           return true;
       }
       clickTime = nowTime;
       return false;
   }
}
//纱线表格的YID组合选择框的单元改变监听类
class BillOutFrame_yarnIDJComboBoxCell_CellListener implements CellEditorListener
{
    private BillOutFrame adaptee;
    BillOutFrame_yarnIDJComboBoxCell_CellListener(BillOutFrame adaptee)
    {
        this.adaptee = adaptee;
    }
    public void editingCanceled(ChangeEvent e)
    {
        adaptee.yarnIDJComboBoxEditingCanceled(e);
    }
     public void editingStopped(ChangeEvent e)
     {
         adaptee.yarnIDJComboBoxEditingStopped(e);
     }

}
 //纱线表格的金额和重量编辑框的单元改变监听类
class BillOutFrame_yarnMWJTextFieldCell_CellListener implements CellEditorListener
{
    private BillOutFrame adaptee;
    BillOutFrame_yarnMWJTextFieldCell_CellListener(BillOutFrame adaptee)
    {
        this.adaptee = adaptee;
    }
    public void editingCanceled(ChangeEvent e)
    {
        adaptee.yarnMWJTextFieldCellEditingCanceled(e);
    }
     public void editingStopped(ChangeEvent e)
     {
         adaptee.yarnMWJTextFieldCellEditingStopped(e);
     }

}