Using a Nikon Lens mount on sony NEX-3 camera?

I'm looking into getting a Nikon lens for my Sony NEX-3. I know that I need a adapter to do this, but was wondering if the adapter only works for specific lenses. I'm looking at this one on ebay now: http://cgi.ebay.com/..._500wt_949.

Any recommendations for other lenses or help altogether would be nice!

And why would you want to do that? Adapters are often not what they're cracked up to be. They may not let the camera and lens "talk" which means no auto focus / exposure.

You'd be smart to stick with lenses made for your camera.

I agree with Jim on this one. It's not a good idea. And with adapters, you AWAYS lose something in the process.
I can't click on the link as you posted it.

The NEX has an excellent APS-C sensor and is designed for and ideal for use with other brand lenses. I have a inexpensive (~$30) adapter that I got on Ebay for Canon FD lenses, and I get wonderful photos. Among other things, I got an older Canon FD 50mm 1.4 for less than $50! In the latest release of the firmware, Sony has included peaking, which makes manual focus much, much easier (http://www.popphoto.com/news/2011/06/sony-firmware-update-brings-peaking-to-nex-3-and-nex-5). As others note, when you use other brand lenses, the camera does not "talk" to the lens and vice-versa. So while shutter speed can be automatic, aperture is not. You'll have to adjust that and focus manually--just like on older 35mm film cameras such as the Canon AE-1. Granted you'll being focusing manually, you'll want to get older lenses that are made to be focused manually. And to answer your question, you'll want to get an adapter that is made specifically for the type of lens you will get. For example, I have an adapter for Canon FD lenses. It does not work with non-FD Canon lenses. By the way, Sony does have a costly adapter that works with its non-NEX lenses. However, auto-focus is painfully slow (so slow that with a bit of practice you would easily be able to beat it manually). And finally, for excellent results, stick with OEM lenses such as Nikon, Canon, Olympus, etc. Tamron et al may be OK too. Cheap off brands, such as Vivitar, produce inferior results.