YES Rocksmith comes with the cable to connect your guitar to the console!
checkout this video it shows an unboxing of Rocksmith: http://www.youtube.com/watch?v=tUTYtohm3mg