A gunman walked into a US exercise class, turned off the lights and shot three women dead before killing himself.