To TS, D5000 doesn't have an autofocus motor built into the body so the AF-D will become MF.
You want AF, then you must get 35mm F1.8 AF-S
35mm f1.8 afs is my pick.you can always add a canon 500d close-up filter
An excerpt from a website talking about the 500D
"Close-up lenses are cheaper than dedicated macro lenses, but more expensive than extension tubes"...
"A dedicated macro lens will give better results, but I've been very satisfied with the
quality of pictures taken using the 500D.
"They give a much better working distance than extension tubes, but the two can be combined to produce
greater magnification. They are very handy to use with 300/400 focal lengths: you can slip the filter into
your camera bag or pocket when you're out and just screw it on the lens, if you spot something small,
but photogenic. Although, depth of field is quite small, so handholding while possible is far from ideal."
Quoted from
http://www.rogercavanagh.com/helpinfo/18_500d-2.stm#pros
You may have a problem with the very off centre weight due to the close up filter being a heavy piece of glass right at the front.