Does it hurt to get your cavities filled?

Im asking this cuz im getting mine filled on Monday. And my brother says it's gonna feel like im being stabbed in the mouth, and that there's gonna be blood everywhere. Is he telling the truth?