分页方案二：(利用ID大于多少和SELECT TOP分页）效率最高，需要拼接SQL语句 分页方案一：(利用Not In和SELECT TOP分页) 效率次之，需要拼接SQL语句-Paging scheme: (using the ID is greater than the number of and SELECT TOP paging), the most efficient stitching SQL statements paging scheme: (Not In SELECT

自由拼接SQL查询WHERE条件 比如对于where name = maxwell and age <18-The free stitching SQL query WHERE condition such as for the where name = ' maxwell' and age < 18

动态SQL语句拼接，多条件查询可选,动态SQL语句拼接，多条件查询可选-Dynamic sql statement stitching, multi-condition optional query