It's 100% automatic, as far as weapons and spells are concerned, you have to choose to attack with it every turn or else you will use your fists by default.
no way, I just bought a sword and said I don't have no weapon. Then I have to sell it and buy it again and now it says I have a weapon, WTH. I just wasted gil from the first sword.