public static Adress getAdressByID(int adressID){
		
		try {
			   if(conn == null || conn.isClosed()){
			    conn = DatabaseConnection.getConnection();
			   }
			  } catch (SQLException e1) {
			   // TODO Auto-generated catch block
			   e1.printStackTrace();
			  }
	
		try {
			PreparedStatement stmnt = conn.prepareStatement("SELECT * FROM Addresses WHERE address_id = ?");
			stmnt.setInt(1, adressID);
			ResultSet res = stmnt.executeQuery();
			res.next();
			
				adress = new Adress(res.getString("bus"),res.getString("street"),res.getString("city"),res.getString("number"),res.getInt("postal_code"),res.getInt("address_id"));
				
		}
		catch(SQLException e) {

		}
		
		return adress;
	}