qualification.java

It is an genric employee management application developed using JSP

/**
 * This Bean Has All the Functionalities related to the Bean and Properties
 */
package com;

import java.io.DataInputStream;
import java.io.IOException;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Enumeration;
import java.util.Vector;

/**
 * @author Prakash S
 */
public class Qualification
{
	//Default Constructor for the Bean
	public Qualification()
	{
		
	}
	
	/*Declarations
	 * ------------------
	 *Fields used by the Bean for Various Operations inculding Reports
	 * 
	 * */
	
	ResultSet beanRecSet=null;
	String strQuery="";
	int qualid;
	String qualification;
	
	
	public int getQualid()
	{
		return qualid;
	}
	public void setQualid(int qualid)
	{
		this.qualid = qualid;
	}
	public String getQualification()
	{
		return qualification;
	}
	public void setQualification(String qualification)
	{
		this.qualification = qualification;
	}
	/* Adds a Recdord to a Table
	 * 
	 */
	public int addSamBean()
	{
		int count=0;
		DBOperations objDbOperations = new DBOperations();
		String insQuery = "INSERT INTO tbl_Qualification (Qualification) VALUES('"+qualification+"')";
        count = objDbOperations.insertToTable(insQuery );
        objDbOperations.disConnect();
		return count;
	}
	/* Update Recdord(s) in the Table
	 * 
	 */
	public int updateSamBean()
	{
		int count=0;
		//Qualification_ID,Qualification,tbl_Qualification
		DBOperations objDbOperations = new DBOperations();
        String updateQuery = "UPDATE tbl_Qualification SET " + " Qualification='"+ qualification+"' WHERE id="+qualid;
        count = objDbOperations.insertToTable( updateQuery );
        objDbOperations.disConnect();
		return count;
	}
	/*
	 * Delete Record(s) From Table
	 */
	public int deleteSamBean()
	{
		int count=0;
		DBOperations objDbOperations = new DBOperations();
        String deleteQuery = "DELETE FROM tbl_Qualification WHERE Qualification_ID="+ qualid + "";
        count = objDbOperations.deleteFromTable( deleteQuery );
        objDbOperations.disConnect();
		return count;
	}
	/*
	 * Set Current Bean Values for Update
	 */
	
	public void setRecord()
	{
		//Set Every Field to Empty and Clear the Field Contents
			/*setF1("");*/
		DBOperations objDbOperations = new DBOperations();
        String selectQuery = "SELECT Qualification_ID,Qualification FROM tbl_Qualification WHERE Qualification_ID="+ qualid;
		beanRecSet = objDbOperations.selectFromTable( selectQuery );
        try
        {
            while (beanRecSet.next())
            {
            	//set()
            	setQualification(beanRecSet.getString("Qualification"));
            	setQualid(beanRecSet.getInt("Qualification_ID"));
            }
        }catch(SQLException e)
        {
        	
        }
		//Set New Values
		/*setF1(rs.getString());*/
        objDbOperations.disConnect();
		
	}
	//Returns All the Records as a Vector
	public Vector getAllRecords()
	{
		Vector beanVetor=new Vector();
		DBOperations objDbOperations = new DBOperations();
        String selectQuery = "SELECT Qualification_ID,Qualification FROM tbl_Qualification ORDER BY Qualification_ID ASC";
        beanRecSet = objDbOperations.selectFromTable( selectQuery );
		try
		{
			while(beanRecSet.next())
			{
				Qualification tempBean=new Qualification();
				tempBean.setQualification(beanRecSet.getString("Qualification"));
				tempBean.setQualid(Integer.parseInt(beanRecSet.getString("Qualification_ID")));
				beanVetor.addElement( tempBean );				
			}
			return beanVetor;
		} catch (SQLException e)
		{
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return beanVetor;		
	}	
	
}