employeeinfo.java

基于j2ee的物流软件

package com.wuliu.entity;
/**/
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.text.MessageFormat;

import com.wuliu.DBConnection.DBConnection;
import com.wuliu.dao.GetDate;

public class EmployeeInfo
{
	/**
	 * @author 崔斌 --职员信息 2009.1.9
	 * 崔斌于2.5修改自动生成ID
	 */
	private int id;// EmployeeInfoTableId--该表自动编号
	private String employeeId;// EmployeeId--职员编号(主键)
	private String employeeName;// EmployeeName--职员姓名(not null)
	private String employeeSex;// EmployeeSex----职员性别(M或F)
	private int employeeAge;// EmployeeAge--职员年龄(not null)
	private String employeeIdCard;// EmployeeIdCard--职员身份证号 not null
	private String employeeBirthDate;// EmployeeBirthDate--职员出生日期
	private String employeeDiploma;// EmployeeDiploma--职员学历
	private String employeeAddr;// EmployeeAddr--职员住址 not null
	private String employeePhone;// EmployeePhone--职员电话 not null
	private String employeeMobile;// EmployeeMobile--职员移动电话
	private String departmentId;// DepartmentId --foreign key
	// DepartmentInfoTable(DepartmentId),--部门编号not
	// null
	private String jobsId;// JobsId--foreign key JobsInfoTable(JobsId)
	// --职务编号(not null)
	private String employeePhoto; //EmployeePhoto --职员照片 袁子鹏 2009.1.14 添加 

	/* 插入职员信息，这些都是必须的 */
	public EmployeeInfo(String EmployeeName, int EmployeeAge,
			String EmployeeIdCard,String EmployeeAddr,
			String EmployeePhone, String DepartmentId, String JobsId)
	{
		this.employeeId = this.getTempId();
		this.employeeName = EmployeeName;
		this.employeeAge = EmployeeAge;
		this.employeeIdCard = EmployeeIdCard;
		this.employeeAddr = EmployeeAddr;
		this.employeePhone = EmployeePhone;
		this.departmentId = DepartmentId;
		this.jobsId = JobsId;
	}
	public EmployeeInfo(String EmployeeName, 
			String EmployeeSex,int EmployeeAge, String EmployeeIdCard, 
			String EmployeeBirthDate,String EmployeeDiploma,
			String EmployeeAddr,String EmployeePhone,
			String EmployeeMobile,
			String DepartmentId, String JobsId,String EmployeePhoto)
	{
		
		this.employeeId = this.getTempId();
		this.employeeName = EmployeeName;
		this.employeeSex = EmployeeSex;
		this.employeeAge = EmployeeAge;
		this.employeeIdCard = EmployeeIdCard;
		this.employeeBirthDate = EmployeeBirthDate;
		this.employeeDiploma = EmployeeDiploma;
		this.employeeAddr = EmployeeAddr;
		this.employeePhone = EmployeePhone;
		this.employeeMobile = EmployeeMobile;
		this.departmentId = DepartmentId; 
		this.jobsId = JobsId;
		this.employeePhoto = EmployeePhoto;//袁子鹏 2009.1.14 添加 
	}
	
	
	/*用于查询存储全部信息*/
	public EmployeeInfo(int id,String EmployeeId,String EmployeeName, 
			String EmployeeSex,int EmployeeAge, String EmployeeIdCard, 
			String EmployeeBirthDate,String EmployeeDiploma,
			String EmployeeAddr,String EmployeePhone,
			String EmployeeMobile,
			String DepartmentId, String JobsId,String EmployeePhoto)
	{
		this.id = id;
		this.employeeId = EmployeeId;
		this.employeeName = EmployeeName;
		this.employeeSex = EmployeeSex;
		this.employeeAge = EmployeeAge;
		this.employeeIdCard = EmployeeIdCard;
		this.employeeBirthDate = EmployeeBirthDate;
		this.employeeDiploma = EmployeeDiploma;
		this.employeeAddr = EmployeeAddr;
		this.employeePhone = EmployeePhone;
		this.employeeMobile = EmployeeMobile;
		this.departmentId = DepartmentId; 
		this.jobsId = JobsId;
		this.employeePhoto = EmployeePhoto;//袁子鹏 2009.1.14 添加 
	}
	
	public EmployeeInfo(String EmployeeId,String EmployeeName, 
			String EmployeeSex,int EmployeeAge, String EmployeeIdCard, 
			String EmployeeBirthDate,String EmployeeDiploma,
			String EmployeeAddr,String EmployeePhone,
			String EmployeeMobile,
			String DepartmentId, String JobsId)
	{
		this.employeeId = EmployeeId;
		this.employeeName = EmployeeName;
		this.employeeSex = EmployeeSex;
		this.employeeAge = EmployeeAge;
		this.employeeIdCard = EmployeeIdCard;
		this.employeeBirthDate = EmployeeBirthDate;
		this.employeeDiploma = EmployeeDiploma;
		this.employeeAddr = EmployeeAddr;
		this.employeePhone = EmployeePhone;
		this.employeeMobile = EmployeeMobile;
		this.departmentId = DepartmentId; 
		this.jobsId = JobsId;
	}

	/* 自动生成员工ID号 EP＋年份号＋流水号 */
	private String getTempId()
	{
		String temp = null;
		DBConnection db = new DBConnection();
		Connection cn = db.getConnection();
		// 获得年份，如2009为09
		GetDate date = new GetDate();
		String year = date.getDate().substring(2, 4);
		try
		{
			Statement st = cn.createStatement();
			ResultSet rs = st.executeQuery("select max(EmployeeInfoTableId) from " +
					"EmployeeInfoTable");
			if (rs.next())
			{
				int no = rs.getInt(1) + 1;
				// 生成员工编号
				temp =MessageFormat.format("EP{0}{1,number,00}",year,no);;
			}
		} catch (SQLException e)
		{
			e.printStackTrace();
		} finally
		{
			db.closeConnection(cn);
		}
		return temp;
	}
	public int getId()
	{
		return id;
	}
	public void setId(int id)
	{
		this.id = id;
	}
	public String getEmployeeId()
	{
		return employeeId;
	}
	public void setEmployeeId(String employeeId)
	{
		this.employeeId = employeeId;
	}
	public String getEmployeeName()
	{
		return employeeName;
	}
	public void setEmployeeName(String employeeName)
	{
		this.employeeName = employeeName;
	}
	public String getEmployeeSex()
	{
		return employeeSex;
	}
	public void setEmployeeSex(String employeeSex)
	{
		this.employeeSex = employeeSex;
	}
	public int getEmployeeAge()
	{
		return employeeAge;
	}
	public void setEmployeeAge(int employeeAge)
	{
		this.employeeAge = employeeAge;
	}
	public String getEmployeeIdCard()
	{
		return employeeIdCard;
	}
	public void setEmployeeIdCard(String employeeIdCard)
	{
		this.employeeIdCard = employeeIdCard;
	}
	public String getEmployeeBirthDate()
	{
		return employeeBirthDate;
	}
	public void setEmployeeBirthDate(String employeeBirthDate)
	{
		this.employeeBirthDate = employeeBirthDate;
	}
	public String getEmployeeDiploma()
	{
		return employeeDiploma;
	}
	public void setEmployeeDiploma(String employeeDiploma)
	{
		this.employeeDiploma = employeeDiploma;
	}
	public String getEmployeeAddr()
	{
		return employeeAddr;
	}
	public void setEmployeeAddr(String employeeAddr)
	{
		this.employeeAddr = employeeAddr;
	}
	public String getEmployeePhone()
	{
		return employeePhone;
	}
	public void setEmployeePhone(String employeePhone)
	{
		this.employeePhone = employeePhone;
	}
	public String getEmployeeMobile()
	{
		return employeeMobile;
	}
	public void setEmployeeMobile(String employeeMobile)
	{
		this.employeeMobile = employeeMobile;
	}
	public String getDepartmentId()
	{
		return departmentId;
	}
	public void setDepartmentId(String departmentId)
	{
		this.departmentId = departmentId;
	}
	public String getJobsId()
	{
		return jobsId;
	}
	public void setJobsId(String jobsId)
	{
		this.jobsId = jobsId;
	}
	public String getEmployeePhoto() {
		return employeePhoto;
	}
	public void setEmployeePhoto(String employeePhoto) {
		this.employeePhoto = employeePhoto;
	}
//	public static void main(String[] args)
//	{
//		EmployeeInfo el = new EmployeeInfo("lili",20,"610404198505011265","asdasdasd","13636795425","YS","BMZZ");
//		DBConnection db = new DBConnection();
//		Connection cn = db.getConnection();
//		try
//		{
//			PreparedStatement ps = cn.prepareStatement("insert into EmployeeInfoTable(EmployeeId,EmployeeName,EmployeeAge,EmployeeIdCard,EmployeeAddr,EmployeePhone,DepartmentId,JobsId) values(?,?,?,?,?,?,?,?)");
//			ps.setString(1,el.getEmployeeId());
//			ps.setString(2,el.getEmployeeName());
//			ps.setInt(3,el.getEmployeeAge());
//			ps.setString(4,el.getEmployeeIdCard());
//			ps.setString(5,el.getEmployeeAddr());
//			ps.setString(6, el.getEmployeePhone());
//			ps.setString(7, el.getDepartmentId());
//			ps.setString(8, el.getJobsId());
//			ps.addBatch();
//			ps.executeUpdate();
//
//		} catch (SQLException e)
//		{
//			// TODO Auto-generated catch block
//			e.printStackTrace();
//		}
//	}
}