productoutupdatedialog.java~1~

是适合于使用的管理系统 可以在现实中使用

package mysiloer;

import java.awt.*;
import javax.swing.*;
import java.awt.event.ActionEvent;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.sql.Date;
import java.awt.event.ActionListener;
import java.sql.Connection;
import java.sql.Statement;
import java.sql.ResultSet;
import javax.swing.border.Border;
import java.util.Calendar;
import java.util.Vector;

/**
 * <p>Title: MySiloer</p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2005</p>
 *
 * <p>Company: yskey</p>
 *
 * @author 杨涛
 * @version 1.0
 */
public class ProductOutUpdateDialog
    extends JDialog {
  JPanel mainPanel = new JPanel();
  BorderLayout borderLayout1 = new BorderLayout();
  JPanel radioPanel = new JPanel();
  JPanel controtPanel = new JPanel();
  JPanel contentPanel = new JPanel();
  JRadioButton deleteRadio = new JRadioButton();
  JRadioButton createRadio = new JRadioButton();
  JLabel jLabel1 = new JLabel();
  JButton cancelButt = new JButton();
  JButton okButt = new JButton();
  JLabel jLabel2 = new JLabel();
  static int CREATE = 0, DELETE = 1;
  int action = 2;
  JLabel[] labs = {
      new JLabel(), new JLabel(), new JLabel(), new JLabel(),
      new JLabel(), new JLabel(), new JLabel()};
  JTextField[] params = {
      new JTextField(), new JTextField(), new JTextField(),
      new JTextField(), new JTextField(), new JTextField()};
  GridLayout gridLayout1 = new GridLayout();
  ButtonGroup buttonGroup1 = new ButtonGroup();
  Border border1 = BorderFactory.createEmptyBorder(0, 10, 5, 10);
  Border border2 = BorderFactory.createEmptyBorder(5, 10, 5, 10);
  Border border3 = BorderFactory.createEmptyBorder(5, 10, 10, 10);
  Connection con = null;
  float totalQuantity = 0;
  SalePanel parentPanel = null;
  Toolkit kit = Toolkit.getDefaultToolkit();

  public ProductOutUpdateDialog(Frame owner, SalePanel parent, boolean modal) {
    super(owner, "材料出库更新对话框", modal);
    try {
      this.con = parent.dataBase.getConnection();
      this.parentPanel = parent;
      setDefaultCloseOperation(DISPOSE_ON_CLOSE);
      jbInit();
      pack();
      Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize();
      Dimension frameSize = getSize();
      if (frameSize.height > screenSize.height) {
        frameSize.height = screenSize.height;
      }
      if (frameSize.width > screenSize.width) {
        frameSize.width = screenSize.width;
      }
      setLocation( (screenSize.width - frameSize.width) / 2,
                  (screenSize.height - frameSize.height) / 2 - 150);

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

  private void jbInit() throws Exception {
    mainPanel.setLayout(borderLayout1);
    deleteRadio.setText("删除记录");
    deleteRadio.addActionListener(new
                                  SiloOutUpdateDialog_deleteRadio_actionAdapter(this));
    createRadio.setText("添加新记录");
    createRadio.addActionListener(new
                                  SiloOutUpdateDialog_createRadio_actionAdapter(this));
    jLabel1.setText("               ");
    cancelButt.setText("取   消");
    cancelButt.addActionListener(new
                                 SiloOutUpdateDialog_cancelButt_actionAdapter(this));
    okButt.setText("确   定");
    okButt.addActionListener(new SiloOutUpdateDialog_okButt_actionAdapter(this));
    jLabel2.setText("            ");
    contentPanel.setLayout(gridLayout1);
    gridLayout1.setHgap(5);
    gridLayout1.setVgap(5);
    radioPanel.setBorder(border1);
    contentPanel.setBorder(border2);
    controtPanel.setBorder(border3);
    getContentPane().add(mainPanel);
    controtPanel.add(okButt);
    controtPanel.add(jLabel2);
    controtPanel.add(cancelButt);
    mainPanel.add(radioPanel, java.awt.BorderLayout.NORTH);
    radioPanel.add(createRadio);
    radioPanel.add(jLabel1);
    radioPanel.add(deleteRadio);
    mainPanel.add(contentPanel, java.awt.BorderLayout.CENTER);
    mainPanel.add(controtPanel, java.awt.BorderLayout.SOUTH);
    buttonGroup1.add(createRadio);
    buttonGroup1.add(deleteRadio);
    for (int i = 0; i < params.length; i++) {
      params[i].addActionListener(new ActionListener() {
        public void actionPerformed(ActionEvent e) {
          okButt_actionPerformed(e);
        }
      });
    }
  }

  public void createRadio_actionPerformed(ActionEvent e) {
    this.action = this.CREATE;
    contentPanel.removeAll();
    gridLayout1.setColumns(2);
    gridLayout1.setRows(5);
    contentPanel.setLayout(gridLayout1);
    clearFields();
    labs[0].setText("产品名称：");
    labs[1].setText("领货人名称：");
    labs[2].setText("发货人名称：");
    labs[3].setText("货物数量：");
    labs[4].setText("产品型号名称：");
    contentPanel.add(labs[0]);
    contentPanel.add(params[0]);
    contentPanel.add(labs[4]);
    contentPanel.add(params[4]);
    contentPanel.add(labs[1]);
    contentPanel.add(params[1]);
    contentPanel.add(labs[2]);
    contentPanel.add(params[2]);
    contentPanel.add(labs[3]);
    contentPanel.add(params[3]);
    mainPanel.add(contentPanel, BorderLayout.CENTER);
    validate();
    pack();
    repaint();
  }

  public void deleteRadio_actionPerformed(ActionEvent e) {
    this.action = this.DELETE;
    contentPanel.removeAll();
    gridLayout1.setColumns(2);
    gridLayout1.setRows(1);
    contentPanel.setLayout(gridLayout1);

    clearFields();
    labs[0].setText("请输入要删除的记录的序号：");
    contentPanel.add(labs[0]);
    contentPanel.add(params[0]);
    mainPanel.add(contentPanel, BorderLayout.CENTER);
    validate();
    pack();
    repaint();
  }

  private void clearFields() {
    for (int i = 0; i < params.length; i++) {
      params[i].setText("");
    }
  }

  public void cancelButt_actionPerformed(ActionEvent e) {
    this.setVisible(false);
    this.dispose();
  }

  public void okButt_actionPerformed(ActionEvent e) {
    if (this.action == this.CREATE) {
      String name = params[0].getText();
      String marqueName = params[4].getText();
      String getUserName = params[1].getText();
      String sendUserName = params[2].getText();
      String quantity = params[3].getText();
      if (name.length() <= 0 || getUserName.length() <= 0 ||
          sendUserName.length() <= 0 || quantity.length() <= 0 ||
          marqueName.length() <= 0) {
        JOptionPane.showMessageDialog(this, "请输入全部必要信息，文本域不允许为空！！", "错误提示!",
                                      JOptionPane.ERROR_MESSAGE);
      }
      else {
        boolean canOut = checkCanOut(name, marqueName, quantity);
        if (canOut) {
          String insertSql = "insert into " + Type.PRODUCTOUTTABLE + " values(" +
              getNextId() + ",'" +
              name + "','" +marqueName+"','"+ getUserName + "','" + sendUserName + "'," +
              quantity +
              ",";
          insertSql = insertDate(insertSql);
          float newQuantity = totalQuantity - Float.parseFloat(quantity);
          String updateSql = "update " + Type.PRODUCTTABLE + " set 数量=" +
              newQuantity + " where 成品名称='" + name + "'";
          try {
            con.setAutoCommit(false);
            Statement sta = con.createStatement();
            sta.executeUpdate(insertSql);
            sta.executeUpdate(updateSql);
            con.commit();
            sta.close();
            con.setAutoCommit(true);
            updateView();
            JOptionPane.showMessageDialog(this, "出库货单添加成功！！");
            kit.beep();
          }
          catch (SQLException ex) {
            try {
              con.rollback();
            }
            catch (SQLException ex1) {
              System.err.println(ex1.toString());
            }
            System.err.println(ex.toString());