A man has been charged with attempted murder and a string of other serious offences after a police officer was shot in Brisbane earlier this month.