Need help desperately. Nervous

Me and my boyfriend are planning to have sex and I've been waiting for a while. I feel it's a special moment and I'm really scared. He said he'll wait but I know he wants it but I'm still scared. Does it hurt? Or does it feel good. -- this is error but I tried fingering myself and ended up hurting myself and im not sure if sex will feel the same. Any one know?