I had a diabetic cat and gave her insulin shots 2 x a day. It was uneventful for the cat and for me. She got lots of loving after each shot and never was concerned about them.
I had her on a diet the vet recommended (the Science Diet) but today I'd follow this site if I still had her:
http://www.catinfo.org/felinediabetes.htm