通过Hibernate分页
PreparedStatement stat = null;
Connection conn =null;
ResultSet resultSet = null;
ResultSetMetaData metadata =null;
pageIndex = evtLogVO.getPageIndex();//currentPage
pageSize = evtLogVO.getPageSize();
Properties pro = new Properties ();
pro.setProperties("hibernate.dialect", "org.hibernate.dialect.OracleDialect");
Dialect dialect = Dialect .getDialect(pro);
int startpage = (pageIndex-1)*pageSize;
//hibernate分页函数
sqlQuery = dialect .getLimitString("Select * from tabel", startpage, pageSize);
stat = conn.prepareStatement(sqlQuery);
stat.setObject(1, String.valueOf(startpage + pageSize));//分页参数设置
if(startpage !=0)
stat.setObject(2, String.valueOf(startpage));//分页参数设置
resultSet = stat.executeQuery();
metadata = resultSet .getMetaData();
//column
for(int i=1;i<metadata.getColumnCount();i++){//jdbc 1 start
String columnNm = metadata.getColumnName(i);
List columnList = new ArrayList();
columnList.add(columnNm );//column的 集合
}
//data
while(resultSet .next()) {//每一个单元作为一条数据
Map map = new LinkedHashMap();//有顺序的排列
for (int j=1;j<=metadata.getColumnCount();j++) {
String value = resultSet.getString(j);
map.put(metadata.getColumnName(j), value); //存放成一条
}
List dataList = new ArrayList();
dataList.add(map);
}