public Agent getAgent(int agentId) {
		
		Agent newAgent = new Agent();
		newAgent.setAgentId(agentId);
		try {
			rs = stmt.executeQuery("SELECT agtfirstname,agtmiddleinitial,agtlastname,agtbusphone,"
					+"agtemail,agtposition,agencyid FROM agents WHERE agentid="+agentId);
			while (rs.next())
			{
				
				newAgent.setAgentFirstName(rs.getString(1));
				newAgent.setAgentMI(rs.getString(2));
				newAgent.setAgentLastName(rs.getString(3));
				newAgent.setAgentPhone(rs.getString(4));
				newAgent.setAgentEmail(rs.getString(5));
				newAgent.setAgentPosition(rs.getString(6));
				newAgent.setAgencyId(rs.getString(7));
				
			}
		} catch (SQLException e) {
			
			e.printStackTrace();
		}
		return newAgent;//the method returns an instance of agent
	}