public ArrayList<Local> listar(String condicao) throws Exception
	{
		String sql = "SELECT * FROM local " + condicao;
		ArrayList<Local> listaLocal = new ArrayList<Local>();
		
		try
		{
			PreparedStatement stmt = ConnectionFactory.getConnection().prepareStatement(sql);
			ResultSet rs = stmt.executeQuery();
			
			while (rs.next())
			{
				Local local = new Local();
				local.setId(rs.getLong("id"));
				local.setCidade(rs.getString("cidade"));
				local.setEstado(rs.getString("estado"));
				local.setDescricao(rs.getString("descricao"));
				
				listaLocal.add(local);
			}
			
			rs.close();
		}
		catch (SQLException e)
		{
			throw e;
		}
		
		return listaLocal;
	}