基于java实现的多种数据库的分页解析

最新推荐文章于 2025-06-26 15:47:13 发布

原创最新推荐文章于 2025-06-26 15:47:13 发布 · 839 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#数据库 #java #string #table #sybase #null

Java 同时被 2 个专栏收录

15 篇文章

订阅专栏

数据库

5 篇文章

订阅专栏

本文介绍了在Oracle、MySQL和Sybase等不同数据库中实现分页查询的方法，包括使用ROWNUM、LIMIT关键字及结果集定位来获取指定范围的数据记录。

Oracle用rownum实现游标：

String finalSql="select * from (select rownum as my_rownum,table_a.* from("
+nowPageSql+") table_a where rownum<="+endNum+") where my_rownum>"+startNum;

部分代码：

String finalSql="select * from (select rownum as my_rownum,table_a.* from("
+nowPageSql+") table_a where rownum<="+endNum+") where my_rownum>"+startNum;

rs = stmt.executeQuery(finalSql);

ResultSetMetaData rsmd = rs.getMetaData();
int nowColumn = rsmd.getColumnCount();
this.setRowNum(nowColumn);
int r = 1;

while (rs.next())
{

for (int i=0;i<nowColumn;i++)
{
     String temp = rs.getString(i+1);

  if(temp == null)
  {
   temp = "";
  }

returnArr.add(temp);

}

}
stmt.close();
return returnArr;

mySql用limit实现指定行查询：

String finalSql = nowPageSql + " limit " + startNum + "," + (endNum-startNum);

部分代码：

String finalSql = nowPageSql + " limit " + startNum + "," + (endNum-startNum);
rs = stmt.executeQuery(finalSql);

ResultSetMetaData rsmd = rs.getMetaData();
int nowColumn = rsmd.getColumnCount();
this.setRowNum(nowColumn);
int r = 1;

while (rs.next())
{

for (int i=0;i<nowColumn;i++)
{
     String temp = rs.getString(i+1);

  if(temp == null)
  {
   temp = "";
  }

returnArr.add(temp);

}

}
stmt.close();
return returnArr;

Sybase用方法: rs.absolute(startNum+1);

部分代码：

stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);

   rs = stmt.executeQuery(nowPageSql);

   ResultSetMetaData rsmd = rs.getMetaData();
   int nowColumn = rsmd.getColumnCount();
   this.setRowNum(nowColumn);
   int r = 1;

   while (rs.next())
   {
    if (r == 1)
     rs.absolute(startNum+1);

    for (int i=0;i<nowColumn;i++)
    {
        String temp = rs.getString(i+1);

     if(temp == null)
     {
      temp = "";
     }