s1(java)项目实战(固定资产管理)(set_ employeeAdd )

来源:互联网 发布:淘宝logo设计理念 编辑:程序博客网 时间:2024/04/30 21:34

package set;

import java.awt.*;
import java.awt.event.*;
import java.util.*;
import javax.swing.*;
import tools.*;

/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2007</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class employeeAdd extends JDialog {
    private JLabel jLabel1 = new JLabel();
    private JLabel jLabel2 = new JLabel();
    private JLabel jLabel3 = new JLabel();
    private JLabel jLabel4 = new JLabel();
    private JTextField txtID = new JTextField();
    private JTextField txtname = new JTextField();
    private JTextField txtduty = new JTextField();
    private JTextField txtmem = new JTextField();
    private JButton btnadd = new JButton();
    private JButton btncancle = new JButton();
    private DBConnection dcon = null;

    public employeeAdd(Frame owner, String title, boolean modal) {
        super(owner, title, modal);
        try {
            setDefaultCloseOperation(DISPOSE_ON_CLOSE);
            jbInit();
            pack();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    public employeeAdd() {
        this(new Frame(), "employeeAdd", false);
    }

    private void jbInit() throws Exception {
        this.getContentPane().setLayout(null);
        jLabel1.setFont(new java.awt.Font("宋体", Font.BOLD, 13));
        jLabel1.setText("姓  名");
        jLabel1.setBounds(new Rectangle(26, 44, 49, 28));
        jLabel3.setFont(new java.awt.Font("宋体", Font.BOLD, 13));
        jLabel3.setToolTipText("");
        jLabel3.setText("职  务");
        jLabel3.setBounds(new Rectangle(26, 75, 49, 28));
        jLabel4.setFont(new java.awt.Font("宋体", Font.BOLD, 13));
        jLabel4.setToolTipText("");
        jLabel4.setText("备  注");
        jLabel4.setBounds(new Rectangle(26, 102, 49, 28));
        txtID.setText(getEmployeeID());
        txtID.setEditable(false);
        txtID.setBounds(new Rectangle(77, 17, 100, 23));
        txtname.setText("");
        txtname.setBounds(new Rectangle(77, 49, 100, 23));
        txtduty.setText("");
        txtduty.setBounds(new Rectangle(77, 78, 100, 23));
        txtmem.setText("");
        txtmem.setBounds(new Rectangle(77, 107, 100, 23));
        btnadd.setBounds(new Rectangle(13, 143, 77, 29));
        btnadd.setText("确定");
        btncancle.setBounds(new Rectangle(106, 142, 69, 29));
        btncancle.setText("取消");
        this.getContentPane().add(jLabel3);
        this.getContentPane().add(jLabel4);
        this.getContentPane().add(jLabel2);
        this.getContentPane().add(jLabel1);
        this.getContentPane().add(txtID);
        this.getContentPane().add(txtname);
        this.getContentPane().add(txtduty);
        this.getContentPane().add(txtmem);
        this.getContentPane().add(btnadd);
        this.getContentPane().add(btncancle);
        jLabel2.setFont(new java.awt.Font("宋体", Font.BOLD, 13));
        jLabel2.setText("编  号");
        jLabel2.setBounds(new Rectangle(26, 17, 49, 28));
        btncancle.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent e) {
                closedialog();
            }
        });
        btnadd.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent e) {
                addEmployee();
            }
        });
    }

//add
    private void addEmployee() {
        if (txtname.getText().trim().length() == 0) {
            JOptionPane.showMessageDialog(this, "名称不能为空");
        } else {
            String duty = "";
            String mem = "";
            if (txtduty.getText().trim().length() != 0) {
                duty = txtduty.getText().trim();
            }
            if (txtmem.getText().trim().length() != 0) {
                mem = txtmem.getText().trim();
            }
            dcon = new DBConnection();
            String sql =
                    "insert into Employee(employee_id,employee_name,employee_post,remark) values ('";
            sql += txtID.getText().trim() + "','";
            sql += txtname.getText().trim() + "','";
            sql += duty + "','";
            sql += mem.trim() + "')";
            JOptionPane.showMessageDialog(this, dcon.update(3, sql));
            closedialog();
        }
    }

    //get employee id
    private String getEmployeeID() {
        String id = "";
        dcon = new DBConnection();
        String sql =
                "select employee_id from Employee order by  employee_id asc";
        Vector v = dcon.select(sql);
        if (v.size() == 0) {
            return "1";
        }
        int autoid = 1;
        for (int i = 0; i < v.size(); i++) {
            String getid = ((Vector) v.get(i)).get(0).toString().trim();
            if (!getid.equals(String.valueOf(autoid))) {
                return String.valueOf(autoid);
            }
            autoid++;
        }
        return String.valueOf(v.size() + 1);
    }

    //close
    private void closedialog() {
        this.dispose();
    }
}
 

原创粉丝点击