billinframe.java

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

    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 saveBillIn()
    {
        try
        {
            ResultSet rs = st.executeQuery(
                    "select BInID from BillIn order by BInID desc");
            rs.next();
            String temp = rs.getString(1); //temp为临时存储单号的变量
            //对单号加一并显示
            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';
            }
            temp = temp.charAt(0) + String.valueOf(temp2) + temp1;
            //提取入库单数据
            String billID = jTextField1.getText();
            char billType;
            if (jCheckBox1.isSelected()) {
                billType = 'z';
            } else {
                billType = 'r';
            }
            String barID = jTextField3.getText();
            String client = String.valueOf(jComboBox3.getSelectedItem());
            String storage = String.valueOf(jComboBox1.getSelectedItem());
            String maker = jTextField4.getText();
            //System.out.print(jSpinner1.getValue());
            SpinnerDateModel sdm = (SpinnerDateModel)jSpinner1.getModel();
            //System.out.print(sdm.getDate());
            Date date = sdm.getDate();
            String remark = jTextField6.getText();
            if(temp.equals(jTextField1.getText()))
            {
                //System.out.print(Float.valueOf(jTextField2.getText()));
                if(Float.valueOf(jTextField2.getText()) >= Float.valueOf(jTextField7.getText()))
                {
                    String driver =
                            "com.microsoft.jdbc.sqlserver.SQLServerDriver";
                    String url =
                            "jdbc:microsoft:sqlserver://sli-wind:1433;DatabaseName=YarnMangerSystem";
                    Class.forName(driver);
                    Connection con = DriverManager.getConnection(url, "sa", "12");
                    Statement st = con.createStatement();
                    YarnTableModel ytm = (YarnTableModel) jTable2.getModel();
                    Vector data = ytm.getVector();
                    //PreparedStatement ps = jf.getPreparedStatement("");
                    st.executeUpdate("insert into BillIn values ('" + billID +
                                     "','" + billType + "','" + client + "','" +
                                     barID + "','" + storage + "','" + maker +
                                     "','" + /*date*/"" + "','" + remark + "')");

                    Class.forName(driver);
                    Connection conn = DriverManager.getConnection(url, "sa", "12");
                    conn.setAutoCommit(false);
                    PreparedStatement ps = conn.prepareStatement("insert into BillInItem values (?,?,?,?,?,0,?,?,'')");
                    for (int i = 0; i < data.size()-1;i++)
                    {
                        Object[] row = (Object[]) data.elementAt(i);
                        if(!row[1].equals(""))
                        {
                            ps.setObject(1, Integer.valueOf(String.valueOf(row[0])));
                            ps.setObject(2, String.valueOf(billID));
                            ps.setObject(3, String.valueOf(row[1]));
                            ps.setObject(4, String.valueOf(row[4]));
                            if (String.valueOf(row[5]).equals("true"))
                                ps.setObject(5, "1");
                            else if (String.valueOf(row[5]).equals("false"))
                                ps.setObject(5, "0");
                            ps.setObject(6, Float.valueOf(String.valueOf(row[6])));
                            ps.setObject(7, Float.valueOf(String.valueOf(row[7])));
                            ps.executeUpdate();
                        }
                    }
                    conn.commit();
                    conn.setAutoCommit(true);
                    conn.close();
                }
                else
                    JOptionPane.showMessageDialog(this, "入库仓库没有足够容量", "错误",
                                                  JOptionPane.ERROR_MESSAGE);
            }
            else
                JOptionPane.showMessageDialog(this, "单号已存在，请进行刷新", "错误",
                                                  JOptionPane.ERROR_MESSAGE);

        }
        catch(Exception ex)
        {
            ex.printStackTrace();
        }
    }
    public void jButton6_actionPerformed(ActionEvent e) {
        refurbish();
    }

    public void jButton1_actionPerformed(ActionEvent e) {
        saveBillIn();
    }
}


class BillInFrame_jButton1_actionAdapter implements ActionListener {
    private BillInFrame adaptee;
    BillInFrame_jButton1_actionAdapter(BillInFrame adaptee) {
        this.adaptee = adaptee;
    }

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


class BillInFrame_jButton6_actionAdapter implements ActionListener {
    private BillInFrame adaptee;
    BillInFrame_jButton6_actionAdapter(BillInFrame adaptee) {
        this.adaptee = adaptee;
    }

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


class BillInFrame_jButton5_actionAdapter implements ActionListener {
    private BillInFrame adaptee;
    BillInFrame_jButton5_actionAdapter(BillInFrame adaptee) {
        this.adaptee = adaptee;
    }

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


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

    public void actionPerformed(ActionEvent e) {

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

    public void itemStateChanged(ItemEvent e)
    {
        adaptee.jComboBox1_itemStateChanged(e);
    }
}
//jTextField3的文档监听器类
class BillInFrame_jTextField5_DocumentAdapter implements DocumentListener
{
    private BillInFrame adaptee;
    BillInFrame_jTextField5_DocumentAdapter(BillInFrame 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 BillInFrame_tableDoubleClick_MouseListener implements MouseListener
{
    private BillInFrame adaptee;
    BillInFrame_tableDoubleClick_MouseListener(BillInFrame 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 BillInFrame_yarnIDJComboBoxCell_CellListener implements CellEditorListener
{
    private BillInFrame adaptee;
    BillInFrame_yarnIDJComboBoxCell_CellListener(BillInFrame adaptee)
    {
        this.adaptee = adaptee;
    }
    public void editingCanceled(ChangeEvent e)
    {
        adaptee.yarnIDJComboBoxEditingCanceled(e);
    }
     public void editingStopped(ChangeEvent e)
     {
         adaptee.yarnIDJComboBoxEditingStopped(e);
     }

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

}