reportbean.java

It is an genric employee management application developed using JSP

/**
 * 
 */
package com;

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

/**
 * @author Prakash S
 */
public class ReportBean extends DBOperations
{
	String	likeColumn;

	String	likeValue;

	String	orderColumn;

	String	orderMode;

	public ReportBean()
	{
		super();

	}

	public String getLikeColumn()
	{
		return likeColumn;
	}

	public String getLikeValue()
	{
		return likeValue;
	}

	public String getOrderColumn()
	{
		return orderColumn;
	}

	public String getOrderMode()
	{
		return orderMode;
	}

	// select * frrom tbl where empNo LiKE 2 ORDER BY name ASC
	public Vector getResults()
	{
		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] " +
			    		" WHERE "+ likeColumn+ " LIKE '"+ likeValue+ "*' ORDER BY  "+ orderColumn + " " + orderMode+";";
		ResultSet beanRecSet = objDbOperations.selectFromTable(selectQuery);
		if(beanRecSet==null)
		{
			System.out.println("No Rows Returned !");
		}
		else
		{
			System.out.println("Rows Returned !");
		}
		int count=0;
		try
		{
			while (beanRecSet.next())
			{
				count++;
				Employee tempBean = new Employee();
				tempBean.setEmpNo(beanRecSet.getInt("Employee_ID"));
				tempBean.setName(beanRecSet.getString("Name"));
				tempBean.setGender(beanRecSet.getString("Gender"));
				SimpleDateFormat sdf = new SimpleDateFormat("dd/MM/yyyy");
				String dtString = sdf.format(beanRecSet.getDate("DOB"))
						.toString();
				tempBean.setDOB(dtString);
				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);
				System.out.println("Count Records:"+count);
			}
			System.out.println("Count Records:"+count);
			return beanVetor;
		} catch (SQLException e)
		{
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return beanVetor;

	}

	public void setLikeColumn(String likeColumn)
	{
		this.likeColumn = likeColumn;
	}

	public void setLikeValue(String likeValue)
	{
		this.likeValue = likeValue;
	}

	public void setOrderColumn(String orderColumn)
	{
		this.orderColumn = orderColumn;
	}

	public void setOrderMode(String orderMode)
	{
		this.orderMode = orderMode;
	}

}