java - MyBatis动态SQL实现ORDER BY和LIMIT的控制？

Question

MyBatis如果想用动态SQL实现ORDER BY和LIMIT语句的运行与否，怎么办？

Answer 1

I’m not sure about your needs, but you can try adding the @SelectProvider annotation to the mapper interface. By customizing the sql, you can process the sql differently based on the parameters. Similarly, there are @UpdateProvider, @ DeleteProvider, @InsertProvider these annotations.