public static void editAdress(Adress a){
		
		try {
			   if(conn == null || conn.isClosed()){
			    conn = DatabaseConnection.getConnection();
			   }
			  } catch (SQLException e1) {
			   // TODO Auto-generated catch block
			   e1.printStackTrace();
			  }
	
		try{
			conn.setAutoCommit(false);
			PreparedStatement stmnt = conn.prepareStatement("UPDATE Addresses set street = ?, number = ?, bus = ?, postal_code = ?, city = ? WHERE address_id = ?");
			
			stmnt.setString(1, a.getStreet());
			stmnt.setString(2, a.getHouseNr());
			stmnt.setString(3, a.getBus());
			stmnt.setInt(4, a.getZipcode());
			stmnt.setString(5, a.getCity());
			stmnt.setInt(6, a.getAdressID());
			
			stmnt.execute();
			conn.commit();
			conn.setAutoCommit(true);
		
		}catch(SQLException e){
			System.out.println("update fail!! - " + e);
		}

}