employee.java

It is an genric employee management application developed using JSP

package com;

import java.sql.ResultSet;
import java.sql.Date;
import java.sql.SQLException;
import java.text.SimpleDateFormat;
import java.util.Vector;

public class Employee extends Qualification
{
	int		age;

	int		desigId;

	String	designation;

	String	DOB;

	String	DOJ;

	int		tempId;

	int		empNo;

	int		expInYears;

	String	Gender;

	Date	dob;

	Date	doj;

	int		genderid;

	String	Name;

	int		Qualid;

	String	qualification;

	int		tempEmpNo;

	public Employee()
	{

	}

	public Date getDob()
	{
		return dob;
	}

	public void setDob(Date dob)
	{
		this.dob = dob;
	}

	public Date getDoj()
	{
		return doj;
	}

	public void setDoj(Date doj)
	{
		this.doj = doj;
	}

	public int addEmployee()
	{
		int count = 0;
		DBOperations objDbOperations = new DBOperations();
		String insQuery = "INSERT INTO tbl_Employee (Name,DOB,DOJ,Gender,Designation,Qualification) VALUES('"
				+ Name
				+ "','"
				+ DOB
				+ "','"
				+ DOJ
				+ "',"
				+ genderid
				+ ","
				+ desigId + "," + Qualid + ")";
		count = objDbOperations.insertToTable(insQuery);
		objDbOperations.disConnect();
		return count;
	}

	public int getAge()
	{
		return age;
	}

	public int getDesigId()
	{
		return desigId;
	}

	public String getDesignation()
	{
		return designation;
	}

	public String getDOB()
	{
		return DOB;
	}

	public String getDOJ()
	{
		return DOJ;
	}

	public int deleteEmployee()
	{
		int count = 0;
		DBOperations objDbOperations = new DBOperations();
		String deleteQuery = "DELETE FROM tbl_Employee WHERE Employee_ID="
				+ empNo;
		count = objDbOperations.deleteFromTable(deleteQuery);
		objDbOperations.disConnect();
		return count;
	}

	public void getRecord()
	{
		DBOperations objDbOperations = new DBOperations();
		String selectQuery = "SELECT [tbl_Employee].[Employee_ID], [tbl_Employee].[Name], [tbl_Gender].[Gender], [tbl_Employee].[DOB], [tbl_Employee].[DOJ], [tbl_Qualification].[Qualification], [tbl_Designation].[Designation]FROM tbl_Qualification INNER JOIN (tbl_Gender INNER JOIN (tbl_Designation INNER JOIN tbl_Employee ON [tbl_Designation].[Designation_ID]=[tbl_Employee].[Designation]) ON [tbl_Gender].[Gender_id]=[tbl_Employee].[Gender]) ON [tbl_Qualification].[Qualification_ID]=[tbl_Employee].[Qualification] WHERE [tbl_Employee].[Employee_ID]="
				+ empNo;
		ResultSet beanRecSet = objDbOperations.selectFromTable(selectQuery);
		try
		{
			while (beanRecSet.next())
			{

				setEmpNo(beanRecSet.getInt("Employee_ID"));
				setName(beanRecSet.getString("Name"));
				setGender(beanRecSet.getString("Gender"));
				SimpleDateFormat sdf = new SimpleDateFormat("dd/MM/yyyy");
				String dtString = sdf.format(beanRecSet.getDate("DOB"))
						.toString();
				setDOB(dtString);
				// tempBean.setDoj(beanRecSet.getDate("DOJ"));

				dtString = sdf.format(beanRecSet.getDate("DOJ")).toString();
				setDOJ(dtString);
				setQualification(beanRecSet.getString("Qualification"));
				setDesignation(beanRecSet.getString("Designation"));

			}

		} catch (SQLException e)
		{
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}

	public int updateEmployee()
	{
		int count = 0;
		DBOperations objDbOperations = new DBOperations();
		String updateQuery = "UPDATE tbl_Employee SET " + " Name='" + Name
				+ "' , DOB='" + DOB + "' , DOJ='" + DOJ + "' , Gender="
				+ genderid + " , Designation=" + desigId + " , Qualification="
				+ Qualid + " WHERE Employee_ID=" + tempId;
		count = objDbOperations.insertToTable(updateQuery);
		objDbOperations.disConnect();
		return count;
	}

	public Vector getEmployeees()
	{
		Vector beanVetor = new Vector();
		DBOperations objDbOperations = new DBOperations();
		String selectQuery = "SELECT [tbl_Employee].[Employee_ID], [tbl_Employee].[Name], [tbl_Gender].[Gender], [tbl_Employee].[DOB], [tbl_Employee].[DOJ],Round((Date()-DOB)/365) AS Age, [tbl_Qualification].[Qualification], [tbl_Designation].[Designation], Round((Date()-DOJ)/365) AS Exp FROM tbl_Qualification INNER JOIN (tbl_Gender INNER JOIN (tbl_Designation INNER JOIN tbl_Employee ON [tbl_Designation].[Designation_ID]=[tbl_Employee].[Designation]) ON [tbl_Gender].[Gender_id]=[tbl_Employee].[Gender]) ON [tbl_Qualification].[Qualification_ID]=[tbl_Employee].[Qualification];";
		ResultSet beanRecSet = objDbOperations.selectFromTable(selectQuery);
		try
		{
			while (beanRecSet.next())
			{
				Employee tempBean = new Employee();
				tempBean.setEmpNo(beanRecSet.getInt("Employee_ID"));
				tempBean.setName(beanRecSet.getString("Name"));
				tempBean.setGender(beanRecSet.getString("Gender"));
				// tempBean.setDob(beanRecSet.getDate("DOB"));

				SimpleDateFormat sdf = new SimpleDateFormat("dd/MM/yyyy");
				String dtString = sdf.format(beanRecSet.getDate("DOB"))
						.toString();
				tempBean.setDOB(dtString);
				// tempBean.setDoj(beanRecSet.getDate("DOJ"));

				dtString = sdf.format(beanRecSet.getDate("DOJ")).toString();
				tempBean.setDOJ(dtString);

				tempBean.setAge(beanRecSet.getInt("Age"));
				tempBean
						.setQualification(beanRecSet.getString("Qualification"));
				tempBean.setDesignation(beanRecSet.getString("Designation"));
				tempBean.setExpInYears(beanRecSet.getInt("Exp"));
				beanVetor.addElement(tempBean);
			}
			return beanVetor;
		} catch (SQLException e)
		{
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return beanVetor;
	}

	// -----------------------------------------------------------
	public Vector getEmployeees(String orderByCol)
	{
		Vector beanVetor = new Vector();
		DBOperations objDbOperations = new DBOperations();
		String selectQuery = "SELECT [tbl_Employee].[Employee_ID], [tbl_Employee].[Name], [tbl_Gender].[Gender], [tbl_Employee].[DOB], [tbl_Employee].[DOJ],Round((Date()-DOB)/365) AS Age, [tbl_Qualification].[Qualification], [tbl_Designation].[Designation], Round((Date()-DOJ)/365) AS Exp FROM tbl_Qualification INNER JOIN (tbl_Gender INNER JOIN (tbl_Designation INNER JOIN tbl_Employee ON [tbl_Designation].[Designation_ID]=[tbl_Employee].[Designation]) ON [tbl_Gender].[Gender_id]=[tbl_Employee].[Gender]) ON [tbl_Qualification].[Qualification_ID]=[tbl_Employee].[Qualification] ORDER BY "
				+ orderByCol;
		ResultSet beanRecSet = objDbOperations.selectFromTable(selectQuery);
		try
		{
			while (beanRecSet.next())
			{
				Employee tempBean = new Employee();
				tempBean.setEmpNo(beanRecSet.getInt("Employee_ID"));
				tempBean.setName(beanRecSet.getString("Name"));
				tempBean.setGender(beanRecSet.getString("Gender"));
				// tempBean.setDob(beanRecSet.getDate("DOB"));

				SimpleDateFormat sdf = new SimpleDateFormat("dd/MM/yyyy");
				String dtString = sdf.format(beanRecSet.getDate("DOB"))
						.toString();
				tempBean.setDOB(dtString);
				// tempBean.setDoj(beanRecSet.getDate("DOJ"));

				dtString = sdf.format(beanRecSet.getDate("DOJ")).toString();
				tempBean.setDOJ(dtString);

				tempBean.setAge(beanRecSet.getInt("Age"));
				tempBean
						.setQualification(beanRecSet.getString("Qualification"));
				tempBean.setDesignation(beanRecSet.getString("Designation"));
				tempBean.setExpInYears(beanRecSet.getInt("Exp"));
				beanVetor.addElement(tempBean);
			}
			return beanVetor;
		} catch (SQLException e)
		{
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return beanVetor;
	}

	// -----------------------------------------------------------
	public int getEmpNo()
	{
		return empNo;
	}

	public int getExpInYears()
	{
		return expInYears;
	}

	public String getGender()
	{
		return Gender;
	}

	public int getGenderid()
	{
		return genderid;
	}

	public String getName()
	{
		return Name;
	}

	public int getQualid()
	{
		return Qualid;
	}

	public String getQualification()
	{
		return qualification;
	}

	public int getTempEmpNo()
	{
		return tempEmpNo;
	}

	public void setAge(int age)
	{
		this.age = age;
	}

	public void setDesigId(int desigId)
	{
		this.desigId = desigId;
	}

	public void setDesignation(String designation)
	{
		this.designation = designation;
	}

	public void setDOB(String dob)
	{
		this.DOB = dob;
	}

	public void setDOJ(String doj)
	{
		this.DOJ = doj;
	}

	public void setEmpNo(int empNo)
	{
		this.empNo = empNo;
	}

	public void setExpInYears(int expInYears)
	{
		this.expInYears = expInYears;
	}

	public void setGender(String gender)
	{
		this.Gender = gender;
	}

	public void setGenderid(int genderid)
	{
		this.genderid = genderid;
	}

	public void setName(String name)
	{
		this.Name = name;
	}

	public void setQualid(int qualid)
	{
		this.Qualid = qualid;
	}

	public void setQualification(String qualification)
	{
		this.qualification = qualification;
	}

	public void setTempEmpNo(int tempEmpNo)
	{
		this.tempEmpNo = tempEmpNo;
	}

	public int getTempId()
	{
		return tempId;
	}

	public void setTempId(int tempId)
	{
		this.tempId = tempId;
	}

}