addworkerpanel.java

固定资产管理

package stage_project;

import java.awt.*;

import javax.swing.*;
import javax.swing.table.JTableHeader;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.util.ArrayList;

/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2008</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class AddWorkerPanel extends JPanel {
    public AddWorkerPanel() {
        try {
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    ImageIcon img = new ImageIcon("xiubei.gif");
    JLabel lblBeijing = new JLabel(img);
    private void jbInit() throws Exception {
        this.setLayout(null);
        setSize(new Dimension(960, 600));
        jLabel1.setText("职工号：");
        jLabel1.setBounds(new Rectangle(341, 160, 63, 35));
        jLabel2.setText("姓    名：");
        jLabel2.setBounds(new Rectangle(341, 220, 63, 35));
        jLabel3.setText("工    位：");
        jLabel3.setBounds(new Rectangle(341, 280, 60, 35));
        jLabel4.setText("备    注：");
        jLabel4.setBounds(new Rectangle(341, 340, 60, 35));
        txtWorkerId.setText("");
        txtWorkerId.setBounds(new Rectangle(465, 160, 145, 35));
        txtWorkerName.setText("");
        txtWorkerName.setBounds(new Rectangle(465, 220, 145, 35));
        txtPosition.setText("");
        txtPosition.setBounds(new Rectangle(465, 280, 145, 35));
        txaRemark.setText("");
        txaRemark.setBounds(new Rectangle(465, 340, 145, 100));
        btnAdd.setBounds(new Rectangle(266, 463, 70, 25));
        btnAdd.setText("增  加");
        btnAdd.addActionListener(new AddWorkerPanel_btnAdd_actionAdapter(this));
        btnSel.setBounds(new Rectangle(640, 463, 70, 25));
        btnSel.setText("查  询");
        btnSel.addActionListener(new AddWorkerPanel_btnSel_actionAdapter(this));
        btnMod.setBounds(new Rectangle(390, 463, 70, 25));
        btnMod.setText("修  改");
        btnMod.addActionListener(new AddWorkerPanel_btnMod_actionAdapter(this));
        btnDel.setBounds(new Rectangle(515, 463, 70, 25));
        btnDel.setText("删  除");
        btnDel.addActionListener(new AddWorkerPanel_btnDel_actionAdapter(this));
        lblBeijing.setIcon(img);
        lblBeijing.setBounds(new Rectangle(0, 0, 960, 600));
        this.add(btnAdd);
        this.add(txtWorkerId);
        this.add(txaRemark);
        this.add(txtPosition);
        this.add(txtWorkerName);
        this.add(jLabel4);
        this.add(jLabel3);
        this.add(jLabel2);
        this.add(jLabel1);
        this.add(btnDel);
        this.add(btnMod);
        this.add(btnSel);
        this.add(lblBeijing);
    }

    JLabel jLabel1 = new JLabel();
    JLabel jLabel2 = new JLabel();
    JLabel jLabel3 = new JLabel();
    JLabel jLabel4 = new JLabel();
    JTextField txtWorkerId = new JTextField();
    JTextField txtWorkerName = new JTextField();
    JTextField txtPosition = new JTextField();
    JTextArea txaRemark = new JTextArea();
    JButton btnAdd = new JButton();
    JButton btnSel = new JButton();
    JButton btnMod = new JButton();
    JButton btnDel = new JButton();
    Object[][] cells = { {"1", "2", "3", "4"}
    };
    String[] colnames = {"职工号", "姓    名", "工    位", "备    注"};
    DBAccess db = new DBAccess();
    //增加职工
    public void btnAdd_actionPerformed(ActionEvent e) {
         //得到文本信息
        String workerid = txtWorkerId.getText();
        String workername = txtWorkerName.getText();
        String position = txtPosition.getText();
        String remark = txaRemark.getText();

        //验证员工编号是否重复
        String sql1 = "select * from employee where empno = '" + workerid + "'";
        boolean b1 = db.jiancha(sql1);
        if (b1) {
            JOptionPane.showMessageDialog(this,
                                          "添加" + "\n" + workerid +
                                          "员工编号已经存在，请重新添加");
            return;
        }
        //验证员工编号是否为空
        if (workerid.equals("")) {
            JOptionPane.showMessageDialog(this, "员工编号不允许为空，请重新添加");
            return;
        }
        //验证员工编号是否为数字
        for (int i = 0; i < workerid.length(); i++) {
            char wi = workerid.charAt(i);
            if (!Character.isDigit(wi)) {
                JOptionPane.showMessageDialog(this, "员工编号必须为数字");
                return;
            }
        }
        //验证姓名编号是否为空
        if (workername.equals("")) {
            JOptionPane.showMessageDialog(this, "工位不允许为空，请重新添加");
            return;
        }

        //验证员工工位是否为空
        if (position.equals("")) {
            JOptionPane.showMessageDialog(this, "工位不允许为空，请重新添加");
            return;
        }
        //  //执行添加SQL语句
        String sql2 =
                "insert into employee(empno,ename,[position],remarks) values ('" +
                workerid + "','" + workername + "','" +
                position + "','" + remark + "')";
        int num = db.doUpdate(sql2);
        if (num == 1) {
            JOptionPane.showMessageDialog(this, "添加成功！！");
        } else {
            JOptionPane.showMessageDialog(this, "添加失败！！");
        }

    }
    //查询事件 查询出要修改和删除的员工信息
    public void btnSel_actionPerformed(ActionEvent e) {
         //得到文本信息
        String workerid = txtWorkerId.getText();
            //验证员工编号是否为空
           if (workerid.equals("")) {
               JOptionPane.showMessageDialog(this, "员工编号不允许为空，请重新添加");
               return;
           }
           //验证员工编号是否为数字
           for (int i = 0; i < workerid.length(); i++) {
               char wi = workerid.charAt(i);
               if (!Character.isDigit(wi)) {
                   JOptionPane.showMessageDialog(this, "员工编号必须为数字");
                   return;
               }
           }
     //执行查询SQL语句
           String sql = "select * from employee where empno = '" + workerid + "'";
           ArrayList arr = new ArrayList();
           arr = db.chaxun(sql, 4);
           if (arr.size() < 1) {
            JOptionPane.showMessageDialog(this, "未找到编号为"+workerid+"员工，请确认输入是否正确！");
            return;
        } else {

            txtWorkerName.setText(arr.get(1).toString());
            txtPosition.setText(arr.get(2).toString());
            txaRemark.setText(arr.get(3).toString());
        }
    }
    //修改查询到的员工信息
    public void btnMod_actionPerformed(ActionEvent e) {
        //得到文本信息
        String workerid = txtWorkerId.getText();
        String workername = txtWorkerName.getText();
        String position = txtPosition.getText();
        String remark = txaRemark.getText();
        //验证员工编号是否为空
        if (workerid.equals("")) {
            JOptionPane.showMessageDialog(this, "员工编号不允许为空，请重新添加");
            return;
        }
        //验证员工编号是否为数字
        for (int i = 0; i < workerid.length(); i++) {
            char wi = workerid.charAt(i);
            if (!Character.isDigit(wi)) {
                JOptionPane.showMessageDialog(this, "员工编号必须为数字");
                return;
            }
        }
        //执行SQL语句
        String sql = "update employee set ename='" + workername +
                     "',[position]='" +
                     position + "',remarks='" + remark + "' where empno = '" +
                     workerid + "'";
        int num = -1;
        num = db.doUpdate(sql);
        if (num ==1) {
            JOptionPane.showMessageDialog(this, "修改成功！！");
        } else {
            JOptionPane.showMessageDialog(this, "修改失败！！");
        }

    }
    //删除查询到的员工信息
    public void btnDel_actionPerformed(ActionEvent e) {
         //得到文本信息
        String workerid = txtWorkerId.getText();

            //验证员工编号是否为空
           if (workerid.equals("")) {
               JOptionPane.showMessageDialog(this, "员工编号不允许为空，请重新添加");
               return;
           }
           //验证员工编号是否为数字
           for (int i = 0; i < workerid.length(); i++) {
               char wi = workerid.charAt(i);
               if (!Character.isDigit(wi)) {
                   JOptionPane.showMessageDialog(this, "员工编号必须为数字");
                   return;
               }
           }
//           //验证员工编号是否存在
//           String sql1 = "select * from employee where empno = '" + workerid + "'";
//           boolean b1 = db.jiancha(sql1);
//           if (b1) {
//               JOptionPane.showMessageDialog(this,
//                                             "删除" + "\n" + workerid +
//                                             "员工编号不已经存在");
//               return;
//           }
           //执行SQL语句
           String sql = "delete from  employee where empno = '" + workerid + "'";
           int num = -1;
           num = db.doUpdate(sql);
           if (num == 1) {
               JOptionPane.showMessageDialog(this, "删除成功！！");
           } else {
               JOptionPane.showMessageDialog(this, "删除失败！！");
           }
    }
}
class AddWorkerPanel_btnDel_actionAdapter implements ActionListener {
    private AddWorkerPanel adaptee;
    AddWorkerPanel_btnDel_actionAdapter(AddWorkerPanel adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.btnDel_actionPerformed(e);
    }
}
class AddWorkerPanel_btnAdd_actionAdapter implements ActionListener {
    private AddWorkerPanel adaptee;
    AddWorkerPanel_btnAdd_actionAdapter(AddWorkerPanel adaptee) {
        this.adaptee = adaptee;
    }

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


class AddWorkerPanel_btnSel_actionAdapter implements ActionListener {
    private AddWorkerPanel adaptee;
    AddWorkerPanel_btnSel_actionAdapter(AddWorkerPanel adaptee) {
        this.adaptee = adaptee;
    }

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


class AddWorkerPanel_btnMod_actionAdapter implements ActionListener {
    private AddWorkerPanel adaptee;
    AddWorkerPanel_btnMod_actionAdapter(AddWorkerPanel adaptee) {
        this.adaptee = adaptee;
    }

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