Large Language Models For Text Classification: Case Study And Comprehensive Review