I'm a fan of the Israeli method of preventing school shootings. They implemented a policy of arming their teachers back in the 70's and school shootings there have dropped to nearly zero. Rocket attacks are a different matter, but we don't currently have that problem here in the US.