I wouldn't do it if you want it to look nice in 6 months. While you can get decent results with spray paint, it takes a lot of prep and good quality paint. If you decide to go ahead with it, go to an automotive paint supply place and have them put some good quality paint in a spray can for you. Make sure you get good tips/nozzles for the spray cans too.