通过Hibernate分页

通过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);
}