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);
		
		eEid.setEditable(true);
		ePassword.setEditable(true);
		eName.setEditable(true);
		eNation.setEditable(true);
		eRegion.setEditable(true);
		eSpecialty.setEditable(true);
		eBirthday.setEditable(true);
		eIdcard.setEditable(true);
		eHlocation.setEditable(true);
		eCaddress.setEditable(true);
		ePostcode.setEditable(true);
		eMobilephone.setEditable(true);
		eHomephone.setEditable(true);
		eEmail.setEditable(true);

		//设置运行时窗口的位置
		Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize();
		this.setLocation((screenSize.width - 500) / 2, 
			(screenSize.height - 600) / 2 + 45);
	}

	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 == addInfo) { //添加
			     if(!fname.equals("")){
					 try{
					 	  Eid=eEid.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();}
			   }
			   eEid.setEnabled(false);
			   ePassword.setEnabled(false);
			   eName.setEnabled(false);
			   eSex.setEnabled(false);
			   eNation.setEnabled(false);
			   eRegion.setEnabled(false);
			   eEducation.setEnabled(false);
			   eSpecialty.setEnabled(false);
			   eBirthday.setEnabled(false);
			   eGstatus.setEnabled(false);
			   eMarriage.setEnabled(false);
			   eIdcard.setEnabled(false);
			   eHlocation.setEnabled(false);
			   eCityhk.setEnabled(false);
			   eCaddress.setEnabled(false);
			   ePostcode.setEnabled(false);
			   eMobilephone.setEnabled(false);
			   eHomephone.setEnabled(false);
			   eEmail.setEnabled(false);

			   addInfo.setEnabled(false);
			   clearInfo.setEnabled(false);
			   eixtInfo.setEnabled(false);

			   EmpBean addEmp = new EmpBean();
			   addEmp.empAdd(eEid.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());
			
			   this.dispose();

			   AddEmpInfo aei = new AddEmpInfo();
			   aei.downInit();
			   aei.setVisible(true);
		}
		else if (obj == clearInfo) { //清空
			setNull();
		}
		}catch(Exception ee){ee.printStackTrace();}
	}
}