What am I supposed to do?

I failed my exam by marginal marks. I was really upset. Just because of this I can't study in another city. The next step will be resit. I didn't want this to happen but I guess I can't change what has happened. I don't like my current university, i really wanted to leave. I can't accept this. I really can't. I feel terrible. I can't cry. Just truly disappointed. How can really face all these for 1 more year? How can I put everything behind and resit? I can hardly open my old textbook.. I feel like I had let everybody down. Everybody.. I left myself down, it hurts so much.