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(); }}
