Java面试总结

1.分页
在项目中分页分为两种：
1.1数据库sql语句分页：
1.1.1SQLServer语句分页
select * from (
select ,row_number() over (order by id) as rownum from t1
) t where t.rownum>=startrow and t.rownum<=endrow
1.1.2Oracle语句分页
select * from (
select * from (
select t. ,row_number() over (order by Id) as rownum
from t
) p where p.rownum>first
)
where rownum<=pagesize
1.1.3MySQL语句分页
select * from table limit ((pageindex-1)*pagesize,pagesize)
注意：pageindex代表当前页数，pagesize代表每页数据记录数
1.2框架自带分页插件
1.2.1Mybatis自带分页插件PageHelper
1.2.2Hibernate自带分页·类
HQL语句分页：
Query query = session.createQuery(sql);
query.setFirstResult((pageindex-1)*pagesize);
query.setMaxResult(pagesize);
List result = query.list();
Criteria分页：
Criteria criteria = session.createCriteria(Example.class);
criteria .s