addmovestoragetable_frm.java

库存管理信息系统

          //frame的显示
          frame.show();
        }
      }
      catch (Exception ex) {
        System.out.println(ex.getMessage());
      }
    }
    else {
      JOptionPane.showMessageDialog(null, "请填写完整后再进行该操作。");
    }
  }

  void jButton2_actionPerformed(ActionEvent e) {
    String osid = jTextField1.getText();
    try {
      parameterRow1.setInt("msid", Integer.parseInt(osid));
      queryDataSet1.refresh();
    }
    catch (Exception ex) {
      ex.printStackTrace();
    }
  }

  void jButton3_actionPerformed(ActionEvent e) {
    this.dispose();
  }

  void jButton4_actionPerformed(ActionEvent e) {
    String msid = jTextField1.getText();
    String charger = jTextField4.getText();
    String mstime = jTextField5.getText();
    String remarks = jTextField7.getText();
    ErrorCheck errmsg = new ErrorCheck();
    if (errmsg.isNum(msid)) {
      ResultSet rs = null;
      ConnectDBBean conn = new ConnectDBBean();
      //sql语句
      String sql = "select * from msgoods where msid='" +
          msid + "'";
      try {

        rs = conn.executeQuery(sql);
        if (rs.next()) {
          Connection conndb = null;
          Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
          conndb = DriverManager.getConnection("jdbc:odbc:KcglSys", "sa", "sa");
          //创建调用存储过程得SQL语句
          String insertsql = "{call sp_InsertMoveStorage(?,?,?,?)}";
          //创建CallableStatement接口调用存储过程
          CallableStatement cStatement = conndb.prepareCall(insertsql);
          cStatement.setInt(1, Integer.parseInt(msid));
          cStatement.setString(2, mstime);
          cStatement.setString(3, charger);
          cStatement.setString(4, remarks);
          cStatement.executeUpdate();
          cStatement.close();
          JOptionPane.showMessageDialog(null, "调库操作成功！");
        }
        else {
          JOptionPane.showMessageDialog(null, "您还未录入货物，请录入后再进行调库操作！");
        }
      }
      catch (Exception ex) {
        System.out.println(ex.getMessage());
      }
    }
    else {
      JOptionPane.showMessageDialog(null, "调库失败，请正确操作！");
    }

  }

  void jTextField4_actionPerformed(ActionEvent e) {

  }

  void jComboBox4_actionPerformed(ActionEvent e) {

  }

  void jComboBox2_mouseClicked(MouseEvent e) {
    String whid = (String) jComboBox1.getSelectedItem();
    String whstallid = (String) jComboBox2.getSelectedItem();
    ResultSet rs = null;
    //实例化ConnectDBBean
    ConnectDBBean conndb = new ConnectDBBean();
    //sql查询语句
    String sql =
        "select wsname from warehousestalls  where whid='" +
        Integer.parseInt(whid) + "' and wsid='" +
        Integer.parseInt(whstallid) + "'";
    try {
      rs = conndb.executeQuery(sql);
      if (rs.next()) {
        String wsname = String.valueOf(rs.getString(1));
        jTextField3.setText(wsname);
      }
    }
    catch (Exception ex1) {
    }

  }

  void jComboBox4_mouseClicked(MouseEvent e) {
    String whid = (String) jComboBox3.getSelectedItem();
    String whstallid = (String) jComboBox4.getSelectedItem();
    ResultSet rs = null;
    //实例化ConnectDBBean
    ConnectDBBean conndb = new ConnectDBBean();
    //sql查询语句
    String sql =
        "select wsname from warehousestalls  where whid='" +
        Integer.parseInt(whid) + "' and wsid='" +
        Integer.parseInt(whstallid) + "'";
    try {
      rs = conndb.executeQuery(sql);
      if (rs.next()) {
        String wsname = String.valueOf(rs.getString(1));
        jTextField8.setText(wsname);
      }
    }
    catch (Exception ex1) {
    }

  }
}

class AddMoveStorageTable_Frm_jComboBox1_actionAdapter
    implements java.awt.event.ActionListener {
  AddMoveStorageTable_Frm adaptee;

  AddMoveStorageTable_Frm_jComboBox1_actionAdapter(AddMoveStorageTable_Frm
      adaptee) {
    this.adaptee = adaptee;
  }

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

class AddMoveStorageTable_Frm_jComboBox2_actionAdapter
    implements java.awt.event.ActionListener {
  AddMoveStorageTable_Frm adaptee;

  AddMoveStorageTable_Frm_jComboBox2_actionAdapter(AddMoveStorageTable_Frm
      adaptee) {
    this.adaptee = adaptee;
  }

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

class AddMoveStorageTable_Frm_this_mouseAdapter
    extends java.awt.event.MouseAdapter {
  AddMoveStorageTable_Frm adaptee;

  AddMoveStorageTable_Frm_this_mouseAdapter(AddMoveStorageTable_Frm adaptee) {
    this.adaptee = adaptee;
  }

  public void mouseClicked(MouseEvent e) {
    adaptee.this_mouseClicked(e);
  }
}

class AddMoveStorageTable_Frm_jComboBox3_actionAdapter
    implements java.awt.event.ActionListener {
  AddMoveStorageTable_Frm adaptee;

  AddMoveStorageTable_Frm_jComboBox3_actionAdapter(AddMoveStorageTable_Frm
      adaptee) {
    this.adaptee = adaptee;
  }

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

class AddMoveStorageTable_Frm_jButton1_actionAdapter
    implements java.awt.event.ActionListener {
  AddMoveStorageTable_Frm adaptee;

  AddMoveStorageTable_Frm_jButton1_actionAdapter(AddMoveStorageTable_Frm
                                                 adaptee) {
    this.adaptee = adaptee;
  }

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

class AddMoveStorageTable_Frm_jButton2_actionAdapter
    implements java.awt.event.ActionListener {
  AddMoveStorageTable_Frm adaptee;

  AddMoveStorageTable_Frm_jButton2_actionAdapter(AddMoveStorageTable_Frm
                                                 adaptee) {
    this.adaptee = adaptee;
  }

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

class AddMoveStorageTable_Frm_jButton3_actionAdapter
    implements java.awt.event.ActionListener {
  AddMoveStorageTable_Frm adaptee;

  AddMoveStorageTable_Frm_jButton3_actionAdapter(AddMoveStorageTable_Frm
                                                 adaptee) {
    this.adaptee = adaptee;
  }

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

class AddMoveStorageTable_Frm_jButton4_actionAdapter
    implements java.awt.event.ActionListener {
  AddMoveStorageTable_Frm adaptee;

  AddMoveStorageTable_Frm_jButton4_actionAdapter(AddMoveStorageTable_Frm
                                                 adaptee) {
    this.adaptee = adaptee;
  }

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

class AddMoveStorageTable_Frm_jTextField4_actionAdapter
    implements java.awt.event.ActionListener {
  AddMoveStorageTable_Frm adaptee;

  AddMoveStorageTable_Frm_jTextField4_actionAdapter(AddMoveStorageTable_Frm
      adaptee) {
    this.adaptee = adaptee;
  }

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

class AddMoveStorageTable_Frm_jComboBox4_actionAdapter
    implements java.awt.event.ActionListener {
  AddMoveStorageTable_Frm adaptee;

  AddMoveStorageTable_Frm_jComboBox4_actionAdapter(AddMoveStorageTable_Frm
      adaptee) {
    this.adaptee = adaptee;
  }

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

class AddMoveStorageTable_Frm_jComboBox2_mouseAdapter
    extends java.awt.event.MouseAdapter {
  AddMoveStorageTable_Frm adaptee;

  AddMoveStorageTable_Frm_jComboBox2_mouseAdapter(AddMoveStorageTable_Frm
                                                  adaptee) {
    this.adaptee = adaptee;
  }

  public void mouseClicked(MouseEvent e) {
    adaptee.jComboBox2_mouseClicked(e);
  }
}

class AddMoveStorageTable_Frm_jComboBox4_mouseAdapter
    extends java.awt.event.MouseAdapter {
  AddMoveStorageTable_Frm adaptee;

  AddMoveStorageTable_Frm_jComboBox4_mouseAdapter(AddMoveStorageTable_Frm
                                                  adaptee) {
    this.adaptee = adaptee;
  }

  public void mouseClicked(MouseEvent e) {
    adaptee.jComboBox4_mouseClicked(e);
  }
}