public static ArrayList<Adress> getAll()  {
		
		try {
			   if(conn == null || conn.isClosed()){
			    conn = DatabaseConnection.getConnection();
			   }
			  } catch (SQLException e1) {
			   // TODO Auto-generated catch block
			   e1.printStackTrace();
			  }
		
		ArrayList<Adress> adressList = new ArrayList<Adress>();
		try {
			Statement stmnt = conn.createStatement();
			String sql = "SELECT * FROM Addresses";
			ResultSet res = stmnt.executeQuery(sql);

			while(res.next()) {
				Adress a = new Adress(res.getString("bus"),
						res.getString("street"), res.getString("city"), res.getString("number"),
						res.getInt("postal_code"),res.getInt("address_id"));
				adressList.add(a);
			}

		}
		catch(SQLException e) {
			System.out.println(e);
		}
		
		return adressList;
	}