📄 employeemanagepanel.java
字号:
pnlRejigger.add(lalRTouch);
pnlRejigger.add(lalRAddress);
pnlRejigger.add(lalRremark);
pnlRejigger.add(txtRremark);
pnlRejigger.add(txtRAddress);
pnlRejigger.add(txtRDuty);
pnlRejigger.add(lalRDuty);
pnlRejigger.add(txtRWage);
pnlRejigger.add(lalRWage);
this.add(pnlAppend);
pnlAppend.add(btnAConfirm);
pnlAppend.add(btnAagain);
pnlAppend.add(lalAInfo);
pnlAppend.add(lalAId);
pnlAppend.add(lalAName);
pnlAppend.add(lalASex);
pnlAppend.add(lalADuty);
pnlAppend.add(lalAage);
pnlAppend.add(txtAWage);
pnlAppend.add(txtATouch);
pnlAppend.add(txtAaddress);
pnlAppend.add(lalAWage);
pnlAppend.add(txtAId);
pnlAppend.add(txtAName);
pnlAppend.add(cboASex);
pnlAppend.add(txtAage);
pnlAppend.add(txtADuty);
pnlAppend.add(lalATouch);
pnlAppend.add(lalAaddress);
pnlAppend.add(lalARemark);
pnlAppend.add(txtARemark);
this.add(pnlQuery);
pnlTitle.add(btnDelete);
pnlTitle.add(btnQuery);
pnlTitle.add(btnAppend);
pnlTitle.add(btnRejigger);
pnlTitle.add(btnInfo);
pnlQuery.setVisible(false);
pnlAppend.setVisible(false);
pnlRejigger.setVisible(false);
pnlDelete.setVisible(false);
queryFile.setVisible(false);
cboASex.addItem("男");
cboASex.addItem("女");
}
JButton btnQuery = new JButton();
JButton btnRejigger = new JButton();
JButton btnAppend = new JButton();
JButton btnDelete = new JButton();
JButton btnInfo = new JButton();
JPanel pnlQuery = new JPanel();
JLabel lblQName = new JLabel();
JTextField txtQId = new JTextField();
JButton btnQConfirm = new JButton();
JButton btnQAgain = new JButton();
JPanel pnlAppend = new JPanel();
JLabel lalAInfo = new JLabel();
JLabel lalAName = new JLabel();
JLabel lalAage = new JLabel();
JLabel lalASex = new JLabel();
JLabel lalADuty = new JLabel();
JLabel lalAWage = new JLabel();
JLabel lalATouch = new JLabel();
JLabel lalAaddress = new JLabel();
JTextField txtAName = new JTextField();
JTextField txtAage = new JTextField();
JComboBox cboASex = new JComboBox();
JTextField txtADuty = new JTextField();
JTextField txtAWage = new JTextField();
JTextField txtATouch = new JTextField();
JTextField txtAaddress = new JTextField();
JLabel lalARemark = new JLabel();
JTextArea txtARemark = new JTextArea();
JButton btnAConfirm = new JButton();
JButton btnAagain = new JButton();
JPanel pnlRejigger = new JPanel();
JLabel lalRInfo = new JLabel();
JLabel lalRId = new JLabel();
JTextField txtRId = new JTextField();
JLabel lalRDuty = new JLabel();
JLabel lalRWage = new JLabel();
JTextField txtRDuty = new JTextField();
JTextField txtRWage = new JTextField();
JButton btnRConfirm = new JButton();
JButton btnRAgian = new JButton();
JPanel pnlDelete = new JPanel();
JLabel lalDInfo = new JLabel();
JLabel lalDId = new JLabel();
JTextField txtDId = new JTextField();
JButton btnDConfirm = new JButton();
JButton btnDAgian = new JButton();
JLabel jLabel1 = new JLabel();
JLabel lalAId = new JLabel();
JTextField txtAId = new JTextField();
JLabel lalRAddress = new JLabel();
JLabel lalRTouch = new JLabel();
JTextField txtRAddress = new JTextField();
JTextField txtRTouch = new JTextField();
JLabel lalRremark = new JLabel();
JTextPane txtRremark = new JTextPane();
JPanel pnlTitle = new JPanel();
public int isNum(String num) {
char ch[] = num.toCharArray();
int i;
for (i = 0; i < ch.length; i++) {
if (Character.isDigit(ch[i])) {
continue;
}else{
break;
}
}
return i;
}
public void btnQuery_actionPerformed(ActionEvent e) {
pnlQuery.setVisible(true);
pnlAppend.setVisible(false);
pnlRejigger.setVisible(false);
pnlDelete.setVisible(false);
queryFile.setVisible(false);
}
public void btnAppend_actionPerformed(ActionEvent e) {
pnlQuery.setVisible(false);
pnlAppend.setVisible(true);
pnlRejigger.setVisible(false);
pnlDelete.setVisible(false);
queryFile.setVisible(false);
}
public void btnRejigger_actionPerformed(ActionEvent e) {
pnlQuery.setVisible(false);
pnlAppend.setVisible(false);
pnlRejigger.setVisible(true);
pnlDelete.setVisible(false);
queryFile.setVisible(false);
}
public void btnDelete_actionPerformed(ActionEvent e) {
pnlQuery.setVisible(false);
pnlAppend.setVisible(false);
pnlRejigger.setVisible(false);
queryFile.setVisible(false);
pnlDelete.setVisible(true);
}
public void btnExit_actionPerformed(ActionEvent e) {
String strSql = "select * from EmployeeInfo";
rs = ds.GetRs(strSql);
try {
vc.removeAllElements();
//更新表格内容
tm.fireTableStructureChanged();
while (rs.next()) {
Vector rec_vector = new Vector();
//从结果集中取数据放入向量rec_vector中
rec_vector.addElement(rs.getString(1));
rec_vector.addElement(rs.getString(2));
rec_vector.addElement(rs.getString(3));
rec_vector.addElement(rs.getString(4));
rec_vector.addElement(rs.getString(5));
rec_vector.addElement(rs.getString(6));
rec_vector.addElement(rs.getString(7));
rec_vector.addElement(rs.getString(8));
rec_vector.addElement(rs.getString(9));
//向量rec_vector加入向量vect中
vc.addElement(rec_vector);
}
//更新表格，显示向量vect的内容
tm.fireTableStructureChanged();
pnlQuery.setVisible(false);
pnlAppend.setVisible(false);
pnlRejigger.setVisible(false);
pnlDelete.setVisible(false);
queryFile.setVisible(true);
} catch (Exception ee) {
} finally {
ds.closed();
}
}
public void btnAConfirm_actionPerformed(ActionEvent e) {
try {
int i=0;
rs=ds.GetRs("select * from employeeinfo");
while (rs.next()) {
if (txtAId.getText().toString().equals(rs.getString(1).toString()))
{
i++;
break;
}
}
if (i!=0)
{
JOptionPane.showMessageDialog(this, "您输入的员工编号已存在，请重新输入");
txtAId.setText(null);
}
else if (txtAId.getText().length() == 0) {
JOptionPane.showMessageDialog(this, "您没有输入员工的编号");
} else if (txtAName.getText().length() == 0) {
JOptionPane.showMessageDialog(this, "您没有输入员工的姓名");
} else if (txtAage.getText().length() == 0) {
JOptionPane.showMessageDialog(this, "您没有输入员工的年龄");
} else if (isNum(txtAage.getText().toString()) <
txtAage.getText().length()) {
JOptionPane.showMessageDialog(this,"员工的年龄必须是数字，请重新输入！");
txtAage.setText(null);
} else if (txtADuty.getText().length() == 0) {
JOptionPane.showMessageDialog(this, "您没有输入员工的职务");
} else if (txtAWage.getText().length() == 0) {
JOptionPane.showMessageDialog(this, "您没有员工的工资");
}else if (isNum(txtAWage.getText().toString()) <
txtAWage.getText().length()) {
JOptionPane.showMessageDialog(this,"员工的工资必须是数字，请重新输入！");
txtAWage.setText(null);
}else if (txtATouch.getText().length() == 0) {
JOptionPane.showMessageDialog(this, "您没有输入员工的联系方式");
} else if (txtAaddress.getText().length() == 0) {
JOptionPane.showMessageDialog(this, "您没有输入员工的地址");
} else
{
String strSql = "insert into EmployeeInfo(Id,Name,Sex,Age,Duty,Wage,ConnectMode,Dwelling,Remark) values('" +
txtAId.getText() + "','" +
txtAName.getText() +
"','" +
cboASex.getSelectedItem() +
"','" +
Integer.valueOf(txtAage.getText()) +
"','" + txtADuty.getText()
+ "','" +
Float.valueOf(txtAWage.getText()) +
"','" +
txtATouch.getText() + "','" +
txtAaddress.getText() +
"','"+txtARemark.getText() +
"')";
ds.ResultSql(strSql);
JOptionPane.showMessageDialog(this, "添加成功");
txtAId.setText(null);
txtAName.setText(null);
txtAage.setText(null);
txtADuty.setText(null);
txtAWage.setText(null);
txtATouch.setText(null);
txtAaddress.setText(null);
txtARemark.setText(null);
}
} catch (Exception ex) {
} finally {
ds.closed();
}
}
public void btnAagain_actionPerformed(ActionEvent e) {
txtAId.setText(null);
txtAName.setText(null);
txtAage.setText(null);
txtADuty.setText(null);
txtAWage.setText(null);
txtATouch.setText(null);
txtAaddress.setText(null);
txtARemark.setText(null);
}
public void btnQConfirm_actionPerformed(ActionEvent e) {
try {
int i = 0;
rs = ds.GetRs("select * from employeeinfo");
while (rs.next()) {
if (txtQId.getText().toString().equals(rs.getString(1).toString())) {
i++;
break;
}
}
if (txtQId.getText().length() == 0) {
JOptionPane.showMessageDialog(this, "您没有输入员工的编号");
} else if (i == 0) {
JOptionPane.showMessageDialog(this, "您输入的员工编号不存在，请重新输入");
txtQId.setText(null);
} else {
String strSql = "select * from EmployeeInfo where Id='" +
this.txtQId.getText().toString() + "'";
rs = ds.GetRs(strSql);
vc.removeAllElements();
//更新表格内容
tm.fireTableStructureChanged();
while (rs.next()) {
Vector rec_vector = new Vector();
//从结果集中取数据放入向量rec_vector中
rec_vector.addElement(rs.getString(1));
rec_vector.addElement(rs.getString(2));
rec_vector.addElement(rs.getString(3));
rec_vector.addElement(rs.getString(4));
rec_vector.addElement(rs.getString(5));
rec_vector.addElement(rs.getString(6));
rec_vector.addElement(rs.getString(7));
rec_vector.addElement(rs.getString(8));
rec_vector.addElement(rs.getString(9));
//向量rec_vector加入向量vect中
vc.addElement(rec_vector);
}
//更新表格，显示向量vect的内容
tm.fireTableStructureChanged();
pnlQuery.setVisible(false);
queryFile.setVisible(true);
txtQId.setText(null);
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -