How do I connect a lamp wire to an actual circuit?
That's all there really is to it - white to white and black to black. If they are not color coded then the black wire should be connected to the pin at the bottom of the light socket.

This assumes your light is line voltage (120V in North America).  If it is not line voltage then there should be a transformer somewhere in the fixture already.