Depends, internal HDD's and DVD drives will either use IDE or SATA when it comes to data transfering and when it comes to power they can either use a SATA power or a Molex connector.
And by LED sticks i assume you mean cold cathodes, which do connect to the PSU, but they require a converter inside your system(because they need AC power) which comes with the cathodes themselves.