How many wires connected to the CD rom?

Usually two cables total. Such as the SATA Cable and the power cable.

As for how many wires are in those cables, it would depends on the connection. Such as IDE have 40 wires. Power cables are usually four pin. It all depends.