I have to get fillings! Does it hurt?

I have two very small cavities. My dentist said he wouldn't give me shots unless i said it hurt. But people says the drill doesn't hurt its just freaky. will it hurt?