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"/>

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