You wanted songs with reference to gender or sex, which aint easy, and most respondents seem to go for straight drinking songs. Me too.

Beer, beer, glorious beer
Arf a pint of ale (Gus Elen)
A jug of this
Champagne Charlie
Johnnie (Walker) (Sam Mayo)
Fill 'em up (Hettie King)
When JONES' ALE was new
Seven drunken nights
The barley mow
Anacreontic anthem (same one, different name)
The Bond Street tea walk (in case anyone TT)