If you can tape the connector in place for long enough to use a USB cable to trasnsfer your persponal files to another PC, you got lucky. Then buy a new HDD and reinstall Windows. The cable you need has three ends. One to connect to another PC or laptop, one to power the drive and the third for the data transfer.
e-Bay always have thousand of ads if you search for HDD USB caddy and specify if it's a 2½" or 3½" drive.