well, the most common is lacquer. sometimes water-based, sometimes oil-based.

the rather inexpensive method of painting that I have chosen to do on my project guitar is just staining the wood and then getting a spray-on clear coat.

have a look around stewmac for guitar supplies (including painting supplies) and project guitar for how-to's on guitars (including painting) I've linked you straight to the sections about paint in both links