A school shooting in the US state of Connecticut has ended with the gunman dead and at least one teacher wounded, while frightened students fled outdoors.