（傲娇的白狐）0sqlserver分页查询及开启驼峰命名

java bean 

 

 

分页查询

 

n 代表第几页

 

sqlserver 2012 之后支持

select * from userinfo order by id

offset (n-1)*10+1 rows fetch next 10 rows only;

 

sqlserver 2003支持

select top 10 * from userinfo where id not in(

select top(n-1)\10 id from userinfo order by id asc

)

 

 

 

开启驼峰命名

<setting name="mapUnderscoreToCamelCase" value="true"/>