It doesnt matter what ssd you use, no matter what speeds it supports. If it supports sata2, and you have a sata3 ssd, itll work, just not at gen3 speeds. If you have a gen 2 ssd, and your pc supports gen 3, you will get gen 2 speeds.
As for the sata cable, just get any ol’ sata cable similar to these, as long as you have a spare sata power cable as well. These are just data cables. I wouldn’t go with the cheapest ones, though.
Cable Matters 3-Pack 90 Degree Right Angle SATA III 6.0 Gbps SATA Cable (SATA 3 Cable) Black - 18 Inches https://www.amazon.com/dp/B018Y2LEBE/ref=cm_sw_r_cp_api_glc_fabc_0Em7Fb1Q1C41H