How do women during ?

I had for the first time and it was painful and not particularly pleasurable, now I'm worried about doing it again because my bf thinks I will next time because it won't hurt. I'm not sure. Please help, and sorry if it's a stupid question. Thanks.