A man opened fire in a hospital in Alabama, US, wounding a police officer and two employees before he was shot dead by police.