Yeah, you're going to have to go back to being friends again. You may come to understand why I never have had sex with any of my friends, unless they'd become a boyfriend... which was also a bad idea for me. But as long as you guys can both keep being friends you should be fine. Though I do recommend putting him emotionally at an arm's length if you desire him at all. I do with guys I like, cause sooner or later things will be said and done, that could be misunderstood, and can either stop being friends, or as you said, "just get over it".
Foremost, take care of yourself first. No matter what your friend is thinking is out of your control. Be kind and respectful, but know that you can't determine the outcome of his actions. You've got to be okay with this, or you'll be consumed by "woulda, shoulda, and coulda" for the next... however long. IMHO*