addempinfo.java

完整的JAVA工程

package employee;

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


/**
 * 职工信息管理模块
 * 添加新的职工信息
 */
public class AddEmpInfo extends EmpInfo{
	Statement stmt;
	ResultSet rs;
	String Eid="";
	EmpBean empBean = new EmpBean();
	public AddEmpInfo() {
		JFrame.setDefaultLookAndFeelDecorated(true);
		Font font=new Font("JFrame",Font.PLAIN,14);
		Enumeration keys=UIManager.getLookAndFeelDefaults().keys();
		while(keys.hasMoreElements()){
			Object key=keys.nextElement();
			if(UIManager.get(key)instanceof Font)UIManager.put(key,font);
		}
		if(!ConnectServer.conn("jdbc:odbc:employee_manage","sa","")){
			JOptionPane.showMessageDialog(null,"数据库连接不成功！");
			System.exit(0);
		}
		
		this.setTitle("添加职工信息");
		this.setResizable(false);
		//设置运行时窗口的位置
		Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize();
		this.setLocation((screenSize.width - 500) / 2, 
			(screenSize.height - 680) / 2);
	}

	public void downInit(){
		/*addInfo.setText("添加");
		addInfo.setFont(new Font("Dialog",0,12));
		downPanel.add(addInfo);
		clearInfo.setText("清空");
		clearInfo.setFont(new Font("Dialog",0,12));
		downPanel.add(clearInfo);*/
		eixtInfo.setText("退出");
		eixtInfo.setFont(new Font("Dialog",0,12));
		downPanel.add(eixtInfo);

		//添加事件侦听
		//addInfo.addActionListener(this);
		//clearInfo.addActionListener(this);
		eixtInfo.addActionListener(this);

		this.contentPane.add(downPanel,BorderLayout.SOUTH);
	}

	/**
	 * 事件处理
	 */
	public void actionPerformed(ActionEvent e) {
		try{
			  Object obj = e.getSource();
		      if (obj == eixtInfo) { //退出
			       this.dispose();
		      }
		      else if (obj == addpic){//添加照片
		            fc=new JFileChooser(".");//建立文件选择器
			        fc.addChoosableFileFilter(new MyFileFilter("gif"));//设置选择器
			        fc.addChoosableFileFilter(new MyFileFilter("jpg"));//设置选择器
			        int result=fc.showOpenDialog(this);//打开文件选择器，选择图片文件
			        if(result==JFileChooser.APPROVE_OPTION){//若打开
			             File file=fc.getSelectedFile();
			             fname=file.getAbsoluteFile().toString();
			             pic.setIcon(new ImageIcon(fname));
			        }
			        else if (result==fc.CANCEL_OPTION){//若选择撤销
				     ;//没有选择任何文件，什么也不做
				    }
		    }
		    else if (obj == addInfo1) { //添加
			     if(!fname.equals("")){
					 try{
					 	  Eid=eEid1.getText();
						  String sql="insert into picture (eid,photo)values(?,?)";
						  PreparedStatement pstmt=ConnectServer.con.prepareStatement(sql);
						  File file=new File(fname);
						  FileInputStream fis=new FileInputStream(file);//建立文件输入流
						  pstmt.setString(1,Eid);
						  pstmt.setBinaryStream(2,fis,(int)file.length());//设置数据流
						  pstmt.executeUpdate();
						  pstmt.close();
					}catch(Exception ee){ee.printStackTrace();}
			   }
			   
			   EmpBean addEmp = new EmpBean();
			   addEmp.empAdd(eEid1.getText(),ePassword.getText(),eName.getText(),(String)eSex.getSelectedItem(), eNation.getText(), eRegion.getText(), (String)eEducation.getSelectedItem(), eSpecialty.getText(), eBirthday.getText(), (String)eGstatus.getSelectedItem(), (String)eMarriage.getSelectedItem(), eIdcard.getText(), eHlocation.getText(), (String)eCityhk.getSelectedItem(), eCaddress.getText(), ePostcode.getText(), eMobilephone.getText(), eHomephone.getText(), eEmail.getText(),(String)eCategory.getSelectedItem(),eJobdate.getText(),eContractdate.getText(),eZzdate.getText(),eXqdate.getText(),eFilelocation.getText());
			   setNull1();
		}
		else if (obj == clearInfo1) { //清空
			setNull1();
		}
		else if(obj==addInfo2){
			EmpBean addEmpCom = new EmpBean();
			addEmpCom.empComAdd(eEid2.getText(),(String)Dname.getSelectedItem(),(String)Aname.getSelectedItem(),Begtime.getText(),Endtime.getText(), (String)Test.getSelectedItem(), Officephone.getText(),Remark.getText());
			setNull2();
		}
		else if(obj==clearInfo2){
			setNull2();
		}
		else if(obj==addInfo3){
			EmpBean addEmpTra = new EmpBean();
			addEmpTra.empTraAdd(eEid3.getText(),(String)tName.getSelectedItem(),tBegtime.getText(),tEndtime.getText(), (String)tTest.getSelectedItem(),tRemark.getText());
			setNull3();
		}
		else if(obj==clearInfo3){
			setNull3();
		}
		}catch(Exception ee){ee.printStackTrace();}
	}
}