editempinfo2.java

完整的JAVA工程

package employee;

import java.awt.*;
import java.sql.*;
import java.awt.event.*;
import javax.swing.*;
import java.io.File;
import java.io.FileInputStream;
import java.io.InputStream;
import java.util.*;
import javax.swing.table.*;
import javax.swing.border.*;
import javax.swing.filechooser.*;

public class EditEmpInfo2 extends EmpInfo2 {
	String eEid_str = "";
	String id_str = "";
	
	public EditEmpInfo2() {
		this.setTitle("修改职工基本信息");
		this.setResizable(false);
		searchInfo2.addActionListener(this);
		modifyInfo2.addActionListener(this);
		clearInfo2.addActionListener(this);
		Id.setEditable(false);
		eEid2.setEditable(false);
		Id.setText("请查询职工纪录");
		Dname.setEditable(false);
		Aname.setEditable(false);
		Begtime.setEditable(false);
		Endtime.setEditable(false);
		Test.setEditable(false);
		Officephone.setEditable(false);
		Remark.setEditable(false);
		Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize();
		this.setLocation((screenSize.width - 500) / 2, 
			(screenSize.height - 680) / 2);
	}
	public void downInit(){
		eixtInfo.setText("退出");
		eixtInfo.setFont(new Font("Dialog",0,12));
		downPanel.add(eixtInfo);
		eixtInfo.setEnabled(true);
		eixtInfo.addActionListener(this);
		this.contentPane.add(downPanel,BorderLayout.SOUTH);
	}
	public void actionPerformed(ActionEvent e){
		Object obj=e.getSource();
		String[] s = new String[9];
		if (obj == eixtInfo) { //退出
			this.dispose();
		}
		else if (obj == searchAll){
			EmpInfoInputEeid eise = new EmpInfoInputEeid(this);
			eise.pack();
			eise.setVisible(true);
			try{
				eEid_str = eise.getEeid();
			}catch(Exception ex){
				JOptionPane.showMessageDialog(null, "没有查找到该职工编号！"); 
			}
			ResultEmpCom rE = new ResultEmpCom("eid",eEid_str);
			searchInfo2.setEnabled(true);
		}
		else if (obj == modifyInfo2) { //修改
			Database DB = new Database();
		    String sql = "update empcom set dname='"+Dname.getText()+"',aname='"+Aname.getText()+"',begtime='"+Begtime.getText()+"',endtime='"+Endtime.getText()+"',test='"+Test.getText()+"',officephone='"+Officephone.getText()+"',remark='"+Remark.getText()+"'where id="+Integer.parseInt(Id.getText())+" ";
		    try{
		    	DB.OpenConn();
				DB.executeUpdate(sql);
				JOptionPane.showMessageDialog(null,"成功修改了职工的公司信息记录！");
		    }
		    catch(Exception e2){
				System.out.println(e2);
				JOptionPane.showMessageDialog(null, "更新失败！", "错误", JOptionPane.ERROR_MESSAGE); 
			}
			finally {
				DB.closeStmt();
				DB.closeConn();
			}
		}
		else if (obj == clearInfo2) { //清空
			setNull2();
		}
		else if (obj == searchInfo2) { //职工编号查询
			
			EmpInfoInputId eise = new EmpInfoInputId(this);
			eise.pack();
			eise.setVisible(true);
			try{
				id_str = eise.getId();
			}catch(Exception ex){
				JOptionPane.showMessageDialog(null, "没有查找到该职工编号！"); 
			}
			
			EmpBean searchEmp = new EmpBean();
			s = searchEmp.empComSearch(id_str);
			if(s == null){
				JOptionPane.showMessageDialog(null, "记录不存在！");
					Id.setText("请查询职工纪录");
					eEid2.setText("");
			        Dname.setText("");
			        Aname.setText("");
			        Begtime.setText("");
			        Endtime.setText("");
			        Test.setText("");
			        Officephone.setText("");
			        Remark.setText("");
				
				    eEid2.setEditable(false);
				    Dname.setEditable(false);
		            Aname.setEditable(false);
		            Begtime.setEditable(false);
		            Endtime.setEditable(false);
		            Test.setEditable(false);
		            Officephone.setEditable(false);
		            Remark.setEditable(false);
				    return;
			}
			else{
			        Id.setText(s[0]);
			        eEid2.setText(s[1]);
		            Dname.setText(s[2]);
			        Aname.setText(s[3]);
			        Begtime.setText(s[4]);
			        Endtime.setText(s[5]);
			        Test.setText(s[6]);
			        Officephone.setText(s[7]);
			        Remark.setText(s[8]);
			        
			        Dname.setEditable(true);
				    Aname.setEditable(true);
				    Begtime.setEditable(true);
				    Endtime.setEditable(true);
				    Test.setEditable(true);
				    Officephone.setEditable(true);
				    Remark.setEditable(true);
				    modifyInfo2.setEnabled(true);
			    }
		}
	}
}