How can I deal with my straight crush?

I have a friend who is literally exactly what I want in a boyfriend. We have the same interest and he is really physically attractive. Unfortunately he is straight and I want to stay friends with him but it's so painful to be around him. Any advice on dealing with my feelings?