Most aquarium lights I've seen come with end caps. Either for both ends or one end. The wires lead to a box thing (the starter unit) which has a lead that plugs into the mains.
Flourescent lighting requires quite a big jolt to get started, no mains supply could come close, therefore it requires a ballast. I'm sure someone can provide a more detailed answer, but that is the short story.