SelectDataFromTable

public class SelectDataFromTable
{
	public static Vector tableVector,selectedRowVector;
	public static SelectDataFromTable staticTablaDataObject,selectedRowData;
	SelectDataFromTable tableRowObj;

	String Name,DateofBirth,address,description;

//	This is for Query: Select * from Table;
	public boolean TableSelection(String statement)
	{
		tableVector=new Vector();
		try
		{
			LoadingScreen.uri=URI.create(LoadingScreen.dbLocation+"ManualRecords.db");
			LoadingScreen.database=DatabaseFactory.openOrCreate(LoadingScreen.uri, new DatabaseSecurityOptions(false));
			LoadingScreen.database.beginTransaction();
			Statement st=LoadingScreen.database.createStatement(statement);
			st.prepare();
			Cursor c = st.getCursor();

            Row r;
            int i = 0;
            while(c.next())
            {
            	tableRowObj=new SelectDataFromTable();
                r = c.getRow();
                i++;
                tableRowObj.setName(r.getString(0));
                tableRowObj.setDateofBirth(r.getString(1));
                tableRowObj.setAddress(r.getString(2));
                tableRowObj.setDescription(r.getString(3));
                tableVector.addElement(tableRowObj);
            }
            st.execute();
			st.close();
			LoadingScreen.database.commitTransaction();
			LoadingScreen.database.close();
            if (i==0)
            {
            	return false;
            }
			System.out.println("============================Got Table Data Successfully");
		}
		catch(Exception e)
		{
			try
			{
				LoadingScreen.database.commitTransaction();
				LoadingScreen.database.close();
			}
			catch(Exception exp)
			{
				exp.printStackTrace();
				System.out.println("Exception:==========================="+exp.getMessage()+"\n");
			}
			e.printStackTrace();
			System.out.println("Exception:============================="+e.getMessage()+"\n");
		}
		return true;
	}

//	selected Perticular Row from the Table; Query: Select * from Employee where name='abc';
	public boolean selectedRow(String statement)
	{
		selectedRowVector=new Vector();
		try
		{
			LoadingScreen.uri=URI.create(LoadingScreen.dbLocation+"ManualRecords.db");
			LoadingScreen.database=DatabaseFactory.openOrCreate(LoadingScreen.uri, new DatabaseSecurityOptions(false));
			LoadingScreen.database.beginTransaction();
			Statement st=LoadingScreen.database.createStatement(statement);
			st.prepare();

			Cursor c = st.getCursor();
            Row r;
            int i = 0;
            while(c.next())
            {
            	selectedRowData=new SelectDataFromTable();
                r = c.getRow();
                i++;
                selectedRowData.setName(r.getString(0));
                selectedRowData.setDateofBirth(r.getString(1));
                selectedRowData.setAddress(r.getString(2));
                selectedRowData.setDescription(r.getString(3));
                selectedRowVector.addElement(selectedRowData);
            }
			st.execute();
			st.close();
			LoadingScreen.database.commitTransaction();
			LoadingScreen.database.close();
			if (i==0)
            {
            	return false;
            }
			System.out.println("============================Selected Perticular Data is Done Successfully");
		}
		catch(Exception e)
		{
			try
			{
				LoadingScreen.database.commitTransaction();
				LoadingScreen.database.close();
			}
			catch(Exception exp)
			{
				exp.printStackTrace();
				System.out.println("Exception:======"+exp.getMessage()+"\n");
			}
			e.printStackTrace();
			System.out.println("Exception:======"+e.getMessage()+"\n");
		}
		return true;
	}


//	Setter and getter Methods;

	public void setName(String Name)
	{
		this.Name=Name;
	}
	public String getName()
	{
		return Name;
	}
//
	public void setDateofBirth(String date)
	{
		DateofBirth=date;
	}
	public String getDateofBirth()
	{
		return DateofBirth;
	}
//
	public void setAddress(String Address)
	{
		address=Address;
	}
	public String getAddress()
	{
		return address;
	}
//
	public void setDescription(String description)
	{
		this.description=description;
	}
	public String getDescription()
	{
		return description;
	}
}